View In:   ArcGIS Online Map Viewer

Name: REPL_GIMS.DBO.Addresses_ft

Display Field: ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 1200.0

Max Scale: 721.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 1513619.4169656932
YMin: 568017.1371248513
XMax: 1644475.1231015325
YMax: 676998.8975073546
Spatial Reference: 3754  (3754)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 0]
Size: 1.0
Angle: 0.0
XOffset: 0
YOffset: 0
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: [LHN]
Use Coded Values: true
Symbol:
Color: [0, 56, 140, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FEATUREID ( type: esriFieldTypeDouble, alias: FEATUREID, editable: true, nullable: true, defaultValue: null, modelName: FEATUREID )
• RECORDTYPE ( type: esriFieldTypeDouble, alias: RECORDTYPE, editable: true, nullable: true, defaultValue: null, modelName: RECORDTYPE )
• NAMEID ( type: esriFieldTypeDouble, alias: NAMEID, editable: true, nullable: true, defaultValue: null, modelName: NAMEID )
• ROUTEID ( type: esriFieldTypeDouble, alias: ROUTEID, editable: true, nullable: true, defaultValue: null, modelName: ROUTEID )
• ROADTYPE ( type: esriFieldTypeString, alias: ROADTYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ROADTYPE , Coded Values: [B: BIKE PATH] , [C: COUNTY] , [D: WPAFB] , ...8 more... )
• ROADNUMBER ( type: esriFieldTypeString, alias: ROADNUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ROADNUMBER )
• HOUSENUM ( type: esriFieldTypeDouble, alias: HOUSENUM, editable: true, nullable: true, defaultValue: null, modelName: HOUSENUM )
• UNITNUM ( type: esriFieldTypeString, alias: UNITNUM, editable: true, nullable: true, length: 12, defaultValue: null, modelName: UNITNUM )
• HNRANGE ( type: esriFieldTypeString, alias: HNRANGE, editable: true, nullable: true, length: 32, defaultValue: null, modelName: HNRANGE )
• UNITEXTRA ( type: esriFieldTypeString, alias: UNITEXTRA, editable: true, nullable: true, length: 64, defaultValue: null, modelName: UNITEXTRA )
• BUILDING ( type: esriFieldTypeString, alias: BUILDING, editable: true, nullable: true, length: 16, defaultValue: null, modelName: BUILDING )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLOOR )
• ST_PREFIX ( type: esriFieldTypeString, alias: ST_PREFIX, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ST_PREFIX , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ST_NAME )
• ST_TYPE ( type: esriFieldTypeString, alias: ST_TYPE, editable: true, nullable: true, length: 16, defaultValue: null, modelName: ST_TYPE , Coded Values: [ALY: ALY] , [AVE: AVE] , [BLVD: BLVD] , ...26 more... )
• ST_SUFFIX ( type: esriFieldTypeString, alias: ST_SUFFIX, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ST_SUFFIX , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ST_SUFFIX2 ( type: esriFieldTypeString, alias: ST_SUFFIX2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ST_SUFFIX2 )
• MUNI ( type: esriFieldTypeString, alias: MUNI, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUNI , Coded Values: [BEAVERCREEK: BEAVERCREEK] , [BELLBROOK: BELLBROOK] , [BOWERSVILLE: BOWERSVILLE] , ...11 more... )
• ALTPREFIX ( type: esriFieldTypeString, alias: ALTPREFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTPREFIX , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ALTNAME ( type: esriFieldTypeString, alias: ALTNAME, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ALTNAME )
• ALTTYPE ( type: esriFieldTypeString, alias: ALTTYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ALTTYPE , Coded Values: [ALY: ALY] , [AVE: AVE] , [BLVD: BLVD] , ...24 more... )
• ALTSUFFIX ( type: esriFieldTypeString, alias: ALTSUFFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTSUFFIX , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ALTSUFFIX2 ( type: esriFieldTypeString, alias: ALTSUFFIX2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTSUFFIX2 )
• SUBDIV ( type: esriFieldTypeString, alias: SUBDIV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBDIV )
• VILLAGE ( type: esriFieldTypeString, alias: VILLAGE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VILLAGE )
• SIDE ( type: esriFieldTypeDouble, alias: SIDE, editable: true, nullable: true, defaultValue: null, modelName: SIDE , Coded Values: [0: LEFT] , [1: RIGHT] )
• ABSSIDE ( type: esriFieldTypeString, alias: ABSSIDE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ABSSIDE , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• STRUC_TYPE ( type: esriFieldTypeDouble, alias: STRUC_TYPE, editable: true, nullable: true, defaultValue: null, modelName: STRUC_TYPE , Coded Values: [1: HOUSE] , [2: DUPLEX] , [3: TRAILER] , ...8 more... )
• SOURCE ( type: esriFieldTypeDouble, alias: SOURCE, editable: true, nullable: true, defaultValue: null, modelName: SOURCE , Coded Values: [0: FIELD VERIFIED] , [1: NOT FIELD VERIFIED] , [2: BEAVERCREEK] , ...5 more... )
• INVERSE ( type: esriFieldTypeString, alias: INVERSE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: INVERSE )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 60, defaultValue: null, modelName: COMMENT )
• COORDINATE ( type: esriFieldTypeDouble, alias: COORDINATE, editable: true, nullable: true, defaultValue: null, modelName: COORDINATE )
• DGPSX ( type: esriFieldTypeDouble, alias: DGPSX, editable: true, nullable: true, defaultValue: null, modelName: DGPSX )
• DGPSY ( type: esriFieldTypeDouble, alias: DGPSY, editable: true, nullable: true, defaultValue: null, modelName: DGPSY )
• DGPSZ ( type: esriFieldTypeDouble, alias: DGPSZ, editable: true, nullable: true, defaultValue: null, modelName: DGPSZ )
• DGPSQUALIT ( type: esriFieldTypeDouble, alias: DGPSQUALIT, editable: true, nullable: true, defaultValue: null, modelName: DGPSQUALIT )
• FIELDNOTE ( type: esriFieldTypeString, alias: FIELDNOTE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIELDNOTE )
• DATE_ ( type: esriFieldTypeString, alias: DATE_, editable: true, nullable: true, length: 24, defaultValue: null, modelName: DATE_ )
• GPSSECOND ( type: esriFieldTypeDouble, alias: GPSSECOND, editable: true, nullable: true, defaultValue: null, modelName: GPSSECOND )
• VAN ( type: esriFieldTypeDouble, alias: VAN, editable: true, nullable: true, defaultValue: null, modelName: VAN )
• SESSION_ ( type: esriFieldTypeDouble, alias: SESSION_, editable: true, nullable: true, defaultValue: null, modelName: SESSION_ )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: OH, modelName: STATE , Coded Values: [OH: OH] )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 24, defaultValue: GRE, modelName: COUNTY , Coded Values: [CLA: CLA] , [GRE: GRE] , [MOT: MOT] )
• LSN ( type: esriFieldTypeString, alias: LSN, editable: true, nullable: true, length: 125, defaultValue: null, modelName: LSN )
• ALSN ( type: esriFieldTypeString, alias: ALSN, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ALSN )
• LHN ( type: esriFieldTypeString, alias: LHN, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LHN )
• NLFIDNEW ( type: esriFieldTypeString, alias: NLFIDNEW, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NLFIDNEW )
• NLFIDOLD ( type: esriFieldTypeString, alias: NLFIDOLD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NLFIDOLD )
• QUAD ( type: esriFieldTypeString, alias: QUAD, editable: true, nullable: true, length: 2, defaultValue: null, modelName: QUAD )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE , Coded Values: [43128: 43128] , [43153: 43153] , [45068: 45068] , ...23 more... )
• USPS_CITY ( type: esriFieldTypeString, alias: USPS_CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USPS_CITY , Coded Values: [ALPHA: ALPHA] , [BELLBROOK: BELLBROOK] , [BOWERSVILLE: BOWERSVILLE] , ...15 more... )
• QCFLAG ( type: esriFieldTypeDouble, alias: QCFLAG, editable: true, nullable: true, defaultValue: null, modelName: QCFLAG , Coded Values: [0: NO ERROR] , [1: ERROR] , [2: ERROR RANGE] )
• ARCHAIN ( type: esriFieldTypeDouble, alias: ARCHAIN, editable: true, nullable: true, defaultValue: null, modelName: ARCHAIN )
• ARORDER ( type: esriFieldTypeDouble, alias: ARORDER, editable: true, nullable: true, defaultValue: null, modelName: ARORDER )
• SEGID ( type: esriFieldTypeDouble, alias: SEGID, editable: true, nullable: true, defaultValue: null, modelName: SEGID )
• TSSEGID ( type: esriFieldTypeDouble, alias: TSSEGID, editable: true, nullable: true, defaultValue: null, modelName: TSSEGID )
• PT_LEN ( type: esriFieldTypeDouble, alias: PT_LEN, editable: true, nullable: true, defaultValue: null, modelName: PT_LEN )
• MPVAL ( type: esriFieldTypeDouble, alias: MPVAL, editable: true, nullable: true, defaultValue: null, modelName: MPVAL )
• COMM ( type: esriFieldTypeString, alias: COMM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMM , Coded Values: [BATH TWP: BATH TWP] , [BEAVERCREEK: BEAVERCREEK] , [BEAVERCREEK TWP: BEAVERCREEK TWP] , ...26 more... )
• MAINT_DATE ( type: esriFieldTypeDate, alias: MAINT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINT_DATE )
• JOIN_ID ( type: esriFieldTypeInteger, alias: JOIN_ID, editable: true, nullable: true, defaultValue: null, modelName: JOIN_ID )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 60, defaultValue: null, modelName: NOTES )
• HOUSESUF ( type: esriFieldTypeString, alias: HOUSESUF, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HOUSESUF )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: REPL_GIMS.DBO.Addresses_ft
  Description:
  Prototype:
  HOUSESUF: null
  NOTES: null
  FEATUREID: null
  RECORDTYPE: null
  NAMEID: null
  ROUTEID: null
  ROADTYPE: null
  ROADNUMBER: null
  HOUSENUM: null
  UNITNUM: null
  HNRANGE: null
  UNITEXTRA: null
  BUILDING: null
  FLOOR: null
  ST_PREFIX: null
  ST_NAME: null
  ST_TYPE: null
  ST_SUFFIX: null
  ST_SUFFIX2: null
  MUNI: null
  ALTPREFIX: null
  ALTNAME: null
  ALTTYPE: null
  ALTSUFFIX: null
  ALTSUFFIX2: null
  SUBDIV: null
  VILLAGE: null
  SIDE: null
  ABSSIDE: null
  STRUC_TYPE: null
  SOURCE: null
  INVERSE: null
  COMMENT: null
  COORDINATE: null
  DGPSX: null
  DGPSY: null
  DGPSZ: null
  DGPSQUALIT: null
  FIELDNOTE: null
  DATE_: null
  GPSSECOND: null
  VAN: null
  SESSION_: null
  STATE: OH
  COUNTY: GRE
  LSN: null
  ALSN: null
  LHN: null
  NLFIDNEW: null
  NLFIDOLD: null
  QUAD: null
  ZIPCODE: null
  USPS_CITY: null
  QCFLAG: null
  ARCHAIN: null
  ARORDER: null
  SEGID: null
  TSSEGID: null
  PT_LEN: null
  MPVAL: null
  COMM: null
  MAINT_DATE: null
  JOIN_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata