Name: intersectionAssetsTable

Display Field: Assets_Equip

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)
• IntersectionID (type: esriFieldTypeInteger, alias: IntersectionID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assets_Equip (type: esriFieldTypeString, alias: Assets_Equip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Load Switches: Load Switches], [Controller: Controller], [Signal Heads: Signal Heads], ... 17 more ...)
• Quantity (type: esriFieldTypeInteger, alias: Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Installed_Constructed (type: esriFieldTypeInteger, alias: Year_Installed_Constructed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Useful_Life__Years (type: esriFieldTypeInteger, alias: Est_Useful_Life _Years, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_FY_to_Replace (type: esriFieldTypeString, alias: Est_FY_to_Replace, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• Intersection_ID (type: esriFieldTypeString, alias: Intersection ID(Unique ID), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• est_year_to_replaced (type: esriFieldTypeInteger, alias: year to replaced, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unitCost (type: esriFieldTypeInteger, alias: Unit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetsCost (type: esriFieldTypeInteger, alias: Assets Cost(unit mult by quty), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: intersectionAssetsTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• trafficSignalIntersection (0) -- Related To: trafficSignalIntersection (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2020 11:28:31 PM

Schema Last Edit Date: 2/12/2020 11:28:31 PM

Data Last Edit Date: 2/12/2020 11:28:31 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat