Name: MasterStreetName

Display Field: roadname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 119c7be1e33b428b9ec82dcaac69bd83

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• fullname ( modelName: FULLNAME, nullable: true, editable: true, defaultValue: null, length: 125, alias: Full Road Name, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• roadpremod ( modelName: ROADPREMOD, nullable: true, editable: true, defaultValue: null, length: 50, alias: Road Pre Modifier, type: esriFieldTypeString )
• roadpredir ( modelName: ROADPREDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: PD, type: esriFieldTypeString , Coded Values: [N: North] , [S: South] , [E: East] , ...9 more... )
• roadpretype ( modelName: PreType, nullable: true, editable: true, defaultValue: null, length: 25, alias: PT, type: esriFieldTypeString , Coded Values: [Farm: Farm] , [Loop: Loop] , [Oval: Oval] , ...39 more... )
• separatorelement ( modelName: SeparatorElement, nullable: true, editable: true, defaultValue: null, length: 10, alias: SeparatorElement, type: esriFieldTypeString , Coded Values: [And: And] , [At: At] , [At The: At The] , ...12 more... )
• roadname ( modelName: ROADNAME, nullable: true, editable: true, defaultValue: null, length: 75, alias: SN, type: esriFieldTypeString )
• roadtype ( modelName: ROADTYPE, nullable: true, editable: true, defaultValue: null, length: 5, alias: ST, type: esriFieldTypeString , Coded Values: [Acrs: Acres] , [Aly: Alley] , [Anx: Annex] , ...246 more... )
• roadpostdir ( modelName: ROADPOSTDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: SD, type: esriFieldTypeString , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• roadpostmod ( modelName: ROADPOSTMOD, nullable: true, editable: true, defaultValue: null, length: 50, alias: Road Post Modifier, type: esriFieldTypeString )
• altroadname ( modelName: ALTROADNAME, nullable: true, editable: true, defaultValue: null, length: 125, alias: Alternate Road Name, type: esriFieldTypeString )
• countyname ( modelName: CountyName, nullable: true, editable: true, defaultValue: Sullivan, length: 50, alias: CountyName, type: esriFieldTypeString )
• state ( modelName: State, nullable: false, editable: true, defaultValue: NY, length: 2, alias: State, type: esriFieldTypeString )
• country ( modelName: Country, nullable: true, editable: true, defaultValue: US, length: 2, alias: Country, type: esriFieldTypeString )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: Active, length: 30, alias: Status, type: esriFieldTypeString , Coded Values: [Active: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• geonameid ( modelName: GeoNameID, nullable: true, editable: true, defaultValue: null, alias: GeoNameID, type: esriFieldTypeInteger )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• privateroad ( modelName: PrivateRoad, nullable: true, editable: true, defaultValue: 0, alias: PrivateRoad, type: esriFieldTypeInteger , Coded Values: [1: Yes] , [0: No] , [2: Unknown] )
• municipality ( modelName: MUNICIPALITY, nullable: true, editable: true, defaultValue: null, length: 50, alias: MUNICIPALITY, type: esriFieldTypeString , Coded Values: [BE: Bethel] , [CA: Callicoon] , [CO: Cochecton] , ...30 more... )
• vzpt ( modelName: VZPT, nullable: true, editable: true, defaultValue: null, length: 10, alias: VZPT, type: esriFieldTypeString )
• vzst ( modelName: VZST, nullable: true, editable: true, defaultValue: null, length: 10, alias: VZST, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )

Templates:

• Name: MasterStreetName
  Description:
  Prototype:
  roadpostmod: null
  country: US
  geonameid: null
  roadpretype: null
  municipality: null
  roadpremod: null
  roadpostdir: null
  lasteditor: null
  roadtype: null
  countyname: Sullivan
  altroadname: null
  privateroad: 0
  separatorelement: null
  vzst: null
  fullname: null
  state: NY
  lastupdate: null
  roadpredir: null
  vzpt: null
  roadname: null
  status: Active
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• RoadCenterline (1) -- Related To: Road Centerlines (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata