Name: PCIDashboard2_RelatedTableTest

Display Field: STR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 11035421.0067212
YMin: 3604276.48572473
XMax: 11082106.9681391
YMax: 3649693.71936515
Spatial Reference: 102747 (2284)

Drawing Info:

{"renderer":{"type":"classBreaks","authoringInfo":{"type":"classedColor","colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,252,240,255],"toColor":[223,242,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,242,218,255],"toColor":[204,235,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,235,197,255],"toColor":[169,222,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[169,222,182,255],"toColor":[122,204,196,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[122,204,196,255],"toColor":[78,181,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[78,181,212,255],"toColor":[44,142,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[44,142,191,255],"toColor":[9,103,171,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[9,103,171,255],"toColor":[8,65,130,255]}]},"classificationMethod":"esriClassifyManual"},"field":"PCI","classificationMethod":"esriClassifyManual","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[170,170,170,255],"width":3.75},"defaultLabel":"Unknown/Private/Not City Maintained","minValue":0,"classBreakInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[238,0,255,255],"width":3.75},"classMaxValue":10,"label":"Failed (0-10)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,0,42,255],"width":3.75},"classMaxValue":25,"label":"Serious (10-25)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[107,3,21,255],"width":3.75},"classMaxValue":40,"label":"Very Poor (25-40)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[212,123,6,255],"width":3.75},"classMaxValue":55,"label":"Poor (40-55)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[242,215,10,255],"width":3.75},"classMaxValue":70,"label":"Fair (55-70)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[1,117,22,255],"width":3.75},"classMaxValue":85,"label":"Satisfactory (70-85)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[7,222,57,255],"width":3.75},"classMaxValue":100,"label":"Good (80-100)"}],"legendOptions":{"order":"ascendingValues"}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• LO_LFT_ADD (type: esriFieldTypeDouble, alias: LO_LFT_ADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HI_LFT_ADD (type: esriFieldTypeDouble, alias: HI_LFT_ADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LO_RGT_ADD (type: esriFieldTypeDouble, alias: LO_RGT_ADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HI_RGT_ADD (type: esriFieldTypeDouble, alias: HI_RGT_ADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STR_NAME (type: esriFieldTypeString, alias: STR_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• SFX_TYPE (type: esriFieldTypeString, alias: SFX_TYPE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• SFX_DIR (type: esriFieldTypeString, alias: SFX_DIR, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• FULL_NAME (type: esriFieldTypeString, alias: FULL_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LOCALITY (type: esriFieldTypeString, alias: LOCALITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROUTE_NUMBER (type: esriFieldTypeString, alias: ROUTE_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CARTO_CLASS (type: esriFieldTypeString, alias: CARTO_CLASS, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ONE_WAY (type: esriFieldTypeString, alias: ONE_WAY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MPH (type: esriFieldTypeSmallInteger, alias: MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MINUTES (type: esriFieldTypeDouble, alias: MINUTES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTH_MILES (type: esriFieldTypeDouble, alias: LENGTH_MILES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Street_ID (type: esriFieldTypeInteger, alias: Street_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZIP_LEFT (type: esriFieldTypeInteger, alias: ZIP_LEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZIP_RIGHT (type: esriFieldTypeInteger, alias: ZIP_RIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIVIDED_HIGHWAY (type: esriFieldTypeString, alias: DIVIDED_HIGHWAY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ZLEVEL_FROM (type: esriFieldTypeSmallInteger, alias: ZLEVEL_FROM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZLEVEL_TO (type: esriFieldTypeSmallInteger, alias: ZLEVEL_TO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VDOT_PAVEMENT_WIDTH_MSR (type: esriFieldTypeInteger, alias: VDOT_PAVEMENT_WIDTH_MSR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EDIT_FLAG (type: esriFieldTypeString, alias: EDIT_FLAG, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TRUCKS (type: esriFieldTypeString, alias: TRUCKS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Restricted: Restricted], [Preferred: Preferred], [Allowed: Allowed])
• SegmentType (type: esriFieldTypeString, alias: SegmentType, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1: Airport Road], [2: Bridge/Overpass], [5: Gate], ... 10 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• VDOT (type: esriFieldTypeString, alias: VDOT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PCI (type: esriFieldTypeDouble, alias: PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LastPCI (type: esriFieldTypeDouble, alias: LastPCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FromStreet (type: esriFieldTypeString, alias: FromStreet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ToStreet (type: esriFieldTypeString, alias: ToStreet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: GlobalID_VW, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lane_Count (type: esriFieldTypeSmallInteger, alias: Lane_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pavement_Width_FT (type: esriFieldTypeSmallInteger, alias: Pavement_Width_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFTYPE (type: esriFieldTypeString, alias: SURFTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AC: Asphaltic Concrete], [PCC: Portland Cement Concrete], [BR: Brick])
• SurfaceMix (type: esriFieldTypeString, alias: Treatment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [12.5 D: 12.5 D], [9.5 A: 9.5 A], [9.5 D: 9.5 D])
• Collection_Date (type: esriFieldTypeDate, alias: Collection_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AVG_IRI (type: esriFieldTypeSmallInteger, alias: AVG_IRI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Quad_Left (type: esriFieldTypeString, alias: Quad_Left, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NE: NE], [NW: NW], [SE: SE], ... 1 more ...)
• Quad_Right (type: esriFieldTypeString, alias: Quad_Right, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NE: NE], [NW: NW], [SE: SE], ... 1 more ...)
• Contract_Paving_FY (type: esriFieldTypeSmallInteger, alias: Contract_Paving_FY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bike_Lane (type: esriFieldTypeString, alias: Bike_Lane, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CG_Left (type: esriFieldTypeString, alias: CG_Left, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CG2: CG2], [CG6: CG6], [Rolltop: Rolltop], ... 2 more ...)
• CG_Right (type: esriFieldTypeString, alias: CG_Right, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CG2: CG2], [CG6: CG6], [Rolltop: Rolltop], ... 2 more ...)
• LastPavedDT (type: esriFieldTypeDouble, alias: LastPavedDT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_SY (type: esriFieldTypeDouble, alias: Total_SY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Last_Paved_Date (type: esriFieldTypeDate, alias: Last Paved Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VDOT_Classification (type: esriFieldTypeString, alias: VDOT Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Interstate: Interstate], [Interstate Ramp: Interstate Ramp], [Other Freeway and Expressway: Other Freeway and Expressway], ... 11 more ...)
• Earliest_PCI_Score (type: esriFieldTypeInteger, alias: Earliest PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCI_2025 (type: esriFieldTypeInteger, alias: 2025, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCI_2024 (type: esriFieldTypeInteger, alias: 2024, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: PCIDashboard2_RelatedTableTest
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Relationships:

• PCI Streets (1) -- Related To: PCI Maintenance Related Table (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/4/2026 5:43:43 PM

Schema Last Edit Date: 2/2/2026 8:23:42 PM

Data Last Edit Date: 2/4/2026 5:43:43 PM

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