Name: ALTSTREETNAME_TBL

Display Field: CompleteStreetName

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STNAME_ID (type: esriFieldTypeInteger, alias: STNAME_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DateModified (type: esriFieldTypeDate, alias: DateModified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NYSStreetID (type: esriFieldTypeInteger, alias: NYSStreetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CompleteStreetName (type: esriFieldTypeString, alias: CompleteStreetName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PreModifier (type: esriFieldTypeString, alias: PreModifier, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PreDirectional (type: esriFieldTypeString, alias: PreDirectional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• PreType (type: esriFieldTypeString, alias: PreType, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Alley: Alley], [Avenue: Avenue], [Boulevard: Boulevard], ... 40 more ...)
• SeparatorElement (type: esriFieldTypeString, alias: SeparatorElement, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [And: And], [At: At], [By The: By The], ... 11 more ...)
• StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PostType (type: esriFieldTypeString, alias: PostType, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AcRd: Access Road], [Acrs: Acres], [Aly: Alley], ... 159 more ...)
• PostDirectional (type: esriFieldTypeString, alias: PostDirectional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• PostModifier (type: esriFieldTypeString, alias: PostModifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SHIELD (type: esriFieldTypeString, alias: SHIELD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [C: C-County Road], [CT: CT-County Touring], [I: I-Interstate], ... 8 more ...)
• HighwayNumber (type: esriFieldTypeString, alias: HighwayNumber, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• NameSource (type: esriFieldTypeString, alias: NameSource, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [County E911: County E911], [County RPTS: County RPTS], [NYC LION: NYC LION], ... 3 more ...)
• CLDXF_PreDirectional (type: esriFieldTypeString, alias: CLDXF_PreDirectional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [East: East], [North: North], [Northeast: Northeast], ... 5 more ...)
• CLDXF_PostType (type: esriFieldTypeString, alias: CLDXF_PostType, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Access Road: Access Road], [Acres: Acres], [Alley: Alley], ... 159 more ...)
• CLDXF_PostDirectional (type: esriFieldTypeString, alias: CLDXF_PostDirectional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [East: East], [North: North], [Northeast: Northeast], ... 5 more ...)
• Label (type: esriFieldTypeString, alias: Label, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DiscrepancyAgencyID (type: esriFieldTypeString, alias: DiscrepancyAgencyID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LeftCityTownName (type: esriFieldTypeString, alias: LeftCityTownName, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RightCityTownName (type: esriFieldTypeString, alias: RightCityTownName, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LeftCountyName (type: esriFieldTypeString, alias: LeftCountyName, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• RightCountyName (type: esriFieldTypeString, alias: RightCountyName, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• CR_USERNAME (type: esriFieldTypeString, alias: CR_USERNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CR_DATETIME (type: esriFieldTypeDate, alias: CR_DATETIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AT_USERNAME (type: esriFieldTypeString, alias: AT_USERNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AT_DATETIME (type: esriFieldTypeDate, alias: AT_DATETIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: ALTSTREETNAME_TBL
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2020 7:07:25 PM

Schema Last Edit Date: 4/30/2020 7:07:25 PM

Data Last Edit Date: 4/30/2020 7:07:25 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat