{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Ramp", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 140, 102, 40, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 2644.9929460863323, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "StreetID", "type": "esriFieldTypeInteger", "alias": "StreetID", "domain": null }, { "name": "StreetLimitID", "type": "esriFieldTypeSmallInteger", "alias": "StreetLimitID", "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 255, "domain": null }, { "name": "SWLimit", "type": "esriFieldTypeString", "alias": "StreetLimit", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDateOnly", "alias": "InspectionDate", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "EstCost", "type": "esriFieldTypeDouble", "alias": "EstCost", "domain": null }, { "name": "RampLocation", "type": "esriFieldTypeString", "alias": "RampLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the treet", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" }, { "name": "Integrated", "code": "Integrated" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RampType", "type": "esriFieldTypeString", "alias": "RampType", "length": 255, "domain": { "type": "codedValue", "name": "DomRampType", "description": "Ramp Material Type", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 255, "domain": { "type": "codedValue", "name": "DomJurisdiction", "description": "Jurisdiction of roadway", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Town", "code": "Town" }, { "name": "City", "code": "City" }, { "name": "State", "code": "State" }, { "name": "Federal", "code": "Federal" }, { "name": "Private Road", "code": "Private Road" }, { "name": "Private Other", "code": "Private Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FunctionalClass", "type": "esriFieldTypeString", "alias": "FunctionalClass", "length": 255, "domain": { "type": "codedValue", "name": "DomFunctionalClass", "description": "Functional Class of the roadway segment", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Principal Arterial", "code": "Principal Arterial" }, { "name": "Minor Arterial", "code": "Minor Arterial" }, { "name": "Major Collector", "code": "Major Collector" }, { "name": "Minor Collector", "code": "Minor Collector" }, { "name": "Local", "code": "Local" }, { "name": "Cul De Sac/Dead End", "code": "Cul De Sac/Dead End" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "DomSWCondition", "description": "Sidewalk Condition", "codedValues": [ { "name": "1-Excellent", "code": "1-Excellent" }, { "name": "2-Good", "code": "2-Good" }, { "name": "3-Fair", "code": "3-Fair" }, { "name": "4-Poor", "code": "4-Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RPITYear", "type": "esriFieldTypeSmallInteger", "alias": "Repair Year", "domain": null }, { "name": "RPITRepair", "type": "esriFieldTypeString", "alias": "Repair Material", "length": 255, "domain": { "type": "codedValue", "name": "DomRampRepairTypes", "description": "Ramp Repair Types", "codedValues": [ { "name": "Do Nothing", "code": "Do Nothing" }, { "name": "Ramp Maintenance", "code": "Ramp Maintenance" }, { "name": "Ramp Replacement", "code": "Ramp Replacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RPITTotalCost", "type": "esriFieldTypeDouble", "alias": "Repair Cost", "domain": null }, { "name": "RPCIPRepairType", "type": "esriFieldTypeString", "alias": "RPCIPRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomRampRepairTypes", "description": "Ramp Repair Types", "codedValues": [ { "name": "Do Nothing", "code": "Do Nothing" }, { "name": "Ramp Maintenance", "code": "Ramp Maintenance" }, { "name": "Ramp Replacement", "code": "Ramp Replacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RPCIPUnitPrice", "type": "esriFieldTypeDouble", "alias": "CIPUnitPrice", "domain": null }, { "name": "RPCIPEstTotalCost", "type": "esriFieldTypeDouble", "alias": "CIPRepairCost", "domain": null }, { "name": "RPCIPYear", "type": "esriFieldTypeString", "alias": "CIPYear", "length": 255, "domain": null }, { "name": "SWLimitID", "type": "esriFieldTypeInteger", "alias": "SWLimitID", "domain": null }, { "name": "Priority", "type": "esriFieldTypeSmallInteger", "alias": "Priority", "domain": null }, { "name": "RampID", "type": "esriFieldTypeInteger", "alias": "RampID", "domain": null }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 255, "domain": { "type": "codedValue", "name": "DomRampRepairTypes", "description": "Ramp Repair Types", "codedValues": [ { "name": "Do Nothing", "code": "Do Nothing" }, { "name": "Ramp Maintenance", "code": "Ramp Maintenance" }, { "name": "Ramp Replacement", "code": "Ramp Replacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DWP", "type": "esriFieldTypeString", "alias": "DWP", "length": 255, "domain": { "type": "codedValue", "name": "DomTrueFalse", "description": "True or False", "codedValues": [ { "name": "False", "code": "False" }, { "name": "True", "code": "True" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectYear", "type": "esriFieldTypeSmallInteger", "alias": "InspectYear", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_26", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_26", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710840000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "SidewalksSegment", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 103072, "latestWkid": 6492, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 149, 158, 75, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 2644.9929460863323, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "StreetLimitID", "type": "esriFieldTypeSmallInteger", "alias": "StreetLimitID", "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 255, "domain": null }, { "name": "SWLimit", "type": "esriFieldTypeString", "alias": "StreetLimit", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SWEndLimit", "type": "esriFieldTypeString", "alias": "EndLimit", "length": 255, "domain": null }, { "name": "Width", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null }, { "name": "SquareYards", "type": "esriFieldTypeDouble", "alias": "SquareYards", "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDateOnly", "alias": "InspectionDate", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "SCI", "type": "esriFieldTypeDouble", "alias": "PCI", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Miles", "type": "esriFieldTypeDouble", "alias": "Miles", "domain": null }, { "name": "UnitCost", "type": "esriFieldTypeDouble", "alias": "UnitCost", "domain": null }, { "name": "SquareFeet", "type": "esriFieldTypeDouble", "alias": "LifeYearsAdded", "domain": null }, { "name": "EstCost", "type": "esriFieldTypeDouble", "alias": "EstCost", "domain": null }, { "name": "SWBeginLimit", "type": "esriFieldTypeString", "alias": "BeginLimit", "length": 255, "domain": null }, { "name": "SidewalkLocation", "type": "esriFieldTypeString", "alias": "SidewalkLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the treet", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" }, { "name": "Integrated", "code": "Integrated" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SidewalkType", "type": "esriFieldTypeString", "alias": "PavementType", "length": 255, "domain": { "type": "codedValue", "name": "DomSWMaterialType", "description": "Sidewalk Surface Material", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Brick", "code": "Brick" }, { "name": "Composite", "code": "Composite" }, { "name": "Pavers", "code": "Pavers" }, { "name": "PCC", "code": "PCC" }, { "name": "Stonedust", "code": "Stonedust" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 255, "domain": { "type": "codedValue", "name": "DomJurisdiction", "description": "Jurisdiction of roadway", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Town", "code": "Town" }, { "name": "City", "code": "City" }, { "name": "State", "code": "State" }, { "name": "Federal", "code": "Federal" }, { "name": "Private Road", "code": "Private Road" }, { "name": "Private Other", "code": "Private Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FunctionalClass", "type": "esriFieldTypeString", "alias": "FunctionalClass", "length": 255, "domain": { "type": "codedValue", "name": "DomFunctionalClass", "description": "Functional Class of the roadway segment", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Principal Arterial", "code": "Principal Arterial" }, { "name": "Minor Arterial", "code": "Minor Arterial" }, { "name": "Major Collector", "code": "Major Collector" }, { "name": "Minor Collector", "code": "Minor Collector" }, { "name": "Local", "code": "Local" }, { "name": "Cul De Sac/Dead End", "code": "Cul De Sac/Dead End" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "DomSWCondition", "description": "Sidewalk Condition", "codedValues": [ { "name": "1-Excellent", "code": "1-Excellent" }, { "name": "2-Good", "code": "2-Good" }, { "name": "3-Fair", "code": "3-Fair" }, { "name": "4-Poor", "code": "4-Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreetID", "type": "esriFieldTypeInteger", "alias": "StreetID", "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "SWITYear", "type": "esriFieldTypeSmallInteger", "alias": "RITYear", "domain": null }, { "name": "SWITRepairMaterial", "type": "esriFieldTypeString", "alias": "RITRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomSWRepairType", "description": "Sidewalk Repair Types", "codedValues": [ { "name": "3-Replace With PCC", "code": "3-ReplaceWithPCC" }, { "name": "3-Replace With Asphalt", "code": "3-ReplaceWithAsphalt" }, { "name": "2-Stonedust Maintenance", "code": "2-Stonedust Maintenance" }, { "name": "2-PCC Maintenance", "code": "2-PCCMaintenance" }, { "name": "2-Brick or Paver Maintenance", "code": "2-BrickMaintenance" }, { "name": "2-Asphalt Maintenance", "code": "2-AsphaltMaintenance" }, { "name": "1-Defer Maintenance", "code": "1-DeferMaintenance" }, { "name": "3-Replace With Brick", "code": "3-ReplaceWithBrick" }, { "name": "3-Replace With Pavers", "code": "3-ReplaceWithPavers" }, { "name": "Replace With PCC Granite Curb", "code": "4-ReplaceWithPCC&GraniteCurb" }, { "name": "4-Replace With Asphalt & Asphalt Curb", "code": "4-ReplaceWithAsphalt&AsphaltCurb" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWITTotalCost", "type": "esriFieldTypeDouble", "alias": "RITCost", "domain": null }, { "name": "SWCIPRepairType", "type": "esriFieldTypeString", "alias": "CIPRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomSWRepairType", "description": "Sidewalk Repair Types", "codedValues": [ { "name": "3-Replace With PCC", "code": "3-ReplaceWithPCC" }, { "name": "3-Replace With Asphalt", "code": "3-ReplaceWithAsphalt" }, { "name": "2-Stonedust Maintenance", "code": "2-Stonedust Maintenance" }, { "name": "2-PCC Maintenance", "code": "2-PCCMaintenance" }, { "name": "2-Brick or Paver Maintenance", "code": "2-BrickMaintenance" }, { "name": "2-Asphalt Maintenance", "code": "2-AsphaltMaintenance" }, { "name": "1-Defer Maintenance", "code": "1-DeferMaintenance" }, { "name": "3-Replace With Brick", "code": "3-ReplaceWithBrick" }, { "name": "3-Replace With Pavers", "code": "3-ReplaceWithPavers" }, { "name": "Replace With PCC Granite Curb", "code": "4-ReplaceWithPCC&GraniteCurb" }, { "name": "4-Replace With Asphalt & Asphalt Curb", "code": "4-ReplaceWithAsphalt&AsphaltCurb" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWCIPUnitPrice", "type": "esriFieldTypeDouble", "alias": "CIPUnitPrice", "domain": null }, { "name": "SWCIPEstTotalCost", "type": "esriFieldTypeDouble", "alias": "CIPRepairCost", "domain": null }, { "name": "SWCIPYear", "type": "esriFieldTypeString", "alias": "CIPYear", "length": 255, "domain": { "type": "codedValue", "name": "DomCIPYear", "description": "CIP Years", "codedValues": [ { "name": "Not Planned", "code": "Not Planned" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWLimitID", "type": "esriFieldTypeInteger", "alias": "SWLimitID", "domain": null }, { "name": "SWITDate", "type": "esriFieldTypeDateOnly", "alias": "SWITDate", "domain": null }, { "name": "Priority", "type": "esriFieldTypeSmallInteger", "alias": "Priority", "domain": null }, { "name": "InspectYear", "type": "esriFieldTypeSmallInteger", "alias": "InspectYear", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_25", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I31SWLimit", "fields": "SWLimit", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_25", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790711023000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Segment", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 103072, "latestWkid": 6492, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 36, 130, 56, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 137556.3569578915, "ymin": 2888632.3118672473, "xmax": 171355.59479250983, "ymax": 2924888.241309928, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 2644.9929460863323, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "StreetLimitID", "type": "esriFieldTypeSmallInteger", "alias": "StreetLimitID", "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 255, "domain": null }, { "name": "StreetLimit", "type": "esriFieldTypeString", "alias": "StreetLimit", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "EndLimit", "type": "esriFieldTypeString", "alias": "EndLimit", "length": 255, "domain": null }, { "name": "Width", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null }, { "name": "CDSArea", "type": "esriFieldTypeDouble", "alias": "CDSArea", "domain": null }, { "name": "SquareYards", "type": "esriFieldTypeDouble", "alias": "SquareYards", "domain": null }, { "name": "AADT", "type": "esriFieldTypeDouble", "alias": "AADT", "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDateOnly", "alias": "InspectionDate", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "PCI", "type": "esriFieldTypeDouble", "alias": "PCI", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Miles", "type": "esriFieldTypeDouble", "alias": "Miles", "domain": null }, { "name": "AdjustedPCI", "type": "esriFieldTypeDouble", "alias": "AdjustedPCI", "domain": null }, { "name": "SuggestedRepair", "type": "esriFieldTypeString", "alias": "SuggestedRepair", "length": 255, "domain": { "type": "codedValue", "name": "DomTreatmentCategories", "description": "Treatment Categories", "codedValues": [ { "name": "1-Defer Maintenance", "code": "1-Defer Maintenance" }, { "name": "3-Surface Treatments", "code": "3-Surface Treatments" }, { "name": "4-Rehabilitation", "code": "4-Rehabilitation" }, { "name": "5-Structural", "code": "5-Structural" }, { "name": "2-Minor Maintenance", "code": "2-Minor Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UnitCost", "type": "esriFieldTypeDouble", "alias": "UnitCost", "domain": null }, { "name": "LifeYearsAdded", "type": "esriFieldTypeDouble", "alias": "LifeYearsAdded", "domain": null }, { "name": "CostBenefitValue", "type": "esriFieldTypeDouble", "alias": "CostBenefitValue", "domain": null }, { "name": "EstCost", "type": "esriFieldTypeDouble", "alias": "EstCost", "domain": null }, { "name": "Ward", "type": "esriFieldTypeDouble", "alias": "Ward", "domain": null }, { "name": "Precinct", "type": "esriFieldTypeDouble", "alias": "Precinct", "domain": null }, { "name": "Neighborhood", "type": "esriFieldTypeDouble", "alias": "Neighborhood", "domain": null }, { "name": "DistressDetails", "type": "esriFieldTypeString", "alias": "DistressDetails", "length": 255, "domain": null }, { "name": "PlowRoute_SaltRoute", "type": "esriFieldTypeSmallInteger", "alias": "PlowRoute_SaltRoute", "domain": null }, { "name": "NumberofLanes", "type": "esriFieldTypeSmallInteger", "alias": "NumberofLanes", "domain": null }, { "name": "BeginLimit", "type": "esriFieldTypeString", "alias": "BeginLimit", "length": 255, "domain": null }, { "name": "UtilityCuts", "type": "esriFieldTypeString", "alias": "UtilityCuts", "length": 255, "domain": { "type": "codedValue", "name": "DomTrueFalse", "description": "True or False", "codedValues": [ { "name": "False", "code": "False" }, { "name": "True", "code": "True" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SidewalkLocation", "type": "esriFieldTypeString", "alias": "SidewalkLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the treet", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" }, { "name": "Integrated", "code": "Integrated" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurbingLocation", "type": "esriFieldTypeString", "alias": "CurbingLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the treet", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" }, { "name": "Integrated", "code": "Integrated" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurbLine", "type": "esriFieldTypeString", "alias": "LineStripingLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the treet", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" }, { "name": "Integrated", "code": "Integrated" }, { "name": "Partial", "code": "Partial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PavementType", "type": "esriFieldTypeString", "alias": "PavementType", "length": 255, "domain": { "type": "codedValue", "name": "DomPavementType", "description": "Pavement Surface Type", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Asphalt", "code": "Asphalt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Chip Seal", "code": "Chip Seal" }, { "name": "Rubber Chip Seal", "code": "Rubber Chip Seal" }, { "name": "Microsurface", "code": "Microsurface" }, { "name": "Bonded Wearing Course", "code": "Bonded Wearing Course" }, { "name": "PCC", "code": "PCC" }, { "name": "Composite \u2013 Asphalt over PCC", "code": "Composite \u2013 Asphalt over PCC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 255, "domain": { "type": "codedValue", "name": "DomJurisdiction", "description": "Jurisdiction of roadway", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Town", "code": "Town" }, { "name": "City", "code": "City" }, { "name": "State", "code": "State" }, { "name": "Federal", "code": "Federal" }, { "name": "Private Road", "code": "Private Road" }, { "name": "Private Other", "code": "Private Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurbOddMat", "type": "esriFieldTypeString", "alias": "CurbOddMat", "length": 255, "domain": null }, { "name": "CurbEvenMat", "type": "esriFieldTypeString", "alias": "CurbEvenMat", "length": 255, "domain": null }, { "name": "SidewalkOddMat", "type": "esriFieldTypeString", "alias": "SidewalkOddMat", "length": 255, "domain": null }, { "name": "SidewalkEvenMat", "type": "esriFieldTypeString", "alias": "SidewalkEvenMat", "length": 255, "domain": null }, { "name": "Centerline", "type": "esriFieldTypeString", "alias": "Centerline", "length": 255, "domain": { "type": "codedValue", "name": "DomTrueFalse", "description": "True or False", "codedValues": [ { "name": "False", "code": "False" }, { "name": "True", "code": "True" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Accepted", "type": "esriFieldTypeString", "alias": "Accepted", "length": 255, "domain": { "type": "codedValue", "name": "DomTrueFalse", "description": "True or False", "codedValues": [ { "name": "False", "code": "False" }, { "name": "True", "code": "True" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FunctionalClass", "type": "esriFieldTypeString", "alias": "FunctionalClass", "length": 255, "domain": { "type": "codedValue", "name": "DomFunctionalClass", "description": "Functional Class of the roadway segment", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Principal Arterial", "code": "Principal Arterial" }, { "name": "Minor Arterial", "code": "Minor Arterial" }, { "name": "Major Collector", "code": "Major Collector" }, { "name": "Minor Collector", "code": "Minor Collector" }, { "name": "Local", "code": "Local" }, { "name": "Cul De Sac/Dead End", "code": "Cul De Sac/Dead End" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CommunityClass", "type": "esriFieldTypeString", "alias": "CommunityClass", "length": 255, "domain": { "type": "codedValue", "name": "DomCommunityClass", "description": "Comunity Class", "codedValues": [ { "name": "Urban", "code": "Urban" }, { "name": "Rural", "code": "Rural" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CrackSealPresent", "type": "esriFieldTypeString", "alias": "CrackSealPresent", "length": 255, "domain": { "type": "codedValue", "name": "DomTrueFalse", "description": "True or False", "codedValues": [ { "name": "False", "code": "False" }, { "name": "True", "code": "True" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "DomCondition", "description": "Road segment condition", "codedValues": [ { "name": "1-Excellent", "code": "1-Excellent" }, { "name": "2-Good", "code": "2-Good" }, { "name": "3-Fair", "code": "3-Fair" }, { "name": "4-Poor", "code": "4-Poor" }, { "name": "5-Critical", "code": "5-Critical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreetID", "type": "esriFieldTypeInteger", "alias": "StreetID", "domain": null }, { "name": "PVTArea", "type": "esriFieldTypeDouble", "alias": "PVTArea", "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "WEIGHTED_PCI", "type": "esriFieldTypeDouble", "alias": "WEIGHTED_PCI", "domain": null }, { "name": "RITYear", "type": "esriFieldTypeSmallInteger", "alias": "RITYear", "domain": null }, { "name": "RITRepairType", "type": "esriFieldTypeString", "alias": "RITRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomRepairCategories", "description": "Road repair types", "codedValues": [ { "name": "Crack Seal", "code": "Crack Seal" }, { "name": "Overlay", "code": "Overlay" }, { "name": "Mill & Overlay", "code": "Mill & Overlay" }, { "name": "Fog Seal", "code": "Fog Seal" }, { "name": "Ultrathin Bonded Overlay", "code": "Ultrathin Bonded Overlay" }, { "name": "Chip Seal", "code": "Chip Seal" }, { "name": "Chip Seal Rubberized", "code": "Chip Seal Rubberized" }, { "name": "Microsurface", "code": "Microsurface" }, { "name": "Shim & Overlay", "code": "Shim & Overlay" }, { "name": "Cold in Place Recycling", "code": "Cold in Place Recycling" }, { "name": "Hot in Place Recycling", "code": "Hot in Place Recycling" }, { "name": "Reclamation", "code": "Reclamation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RITCost", "type": "esriFieldTypeDouble", "alias": "RITCost", "domain": null }, { "name": "CIPRepairType", "type": "esriFieldTypeString", "alias": "CIPRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomRepairTypes", "description": "Full list of repairs", "codedValues": [ { "name": "Full Depth Reconstruction", "code": "Full Depth Reconstruction" }, { "name": "Mill and Overlay \u2013 3\u201d", "code": "Mill and Overlay \u2013 3\u201d" }, { "name": "Cold In-Place Recycling Hybrid", "code": "Cold In-Place Recycling Hybrid" }, { "name": "Cold In-Place Recycling Traditional", "code": "Cold In-Place Recycling Traditional" }, { "name": "Full Depth Reclamation (FDR) \u2013 4\u201d", "code": "Full Depth Reclamation (FDR) \u2013 4\u201d" }, { "name": "Full Depth Reclamation (FDR) \u2013 4\u201d plus Structures", "code": "Full Depth Reclamation (FDR) \u2013 4\u201d plus Structures" }, { "name": "Cape Seal (Conventional + Micro)", "code": "Cape Seal (Conventional + Micro)" }, { "name": "Cape Seal (SAM + Micro)", "code": "Cape Seal (SAM + Micro)" }, { "name": "Shim and Overlay \u2013 1.5\u201d", "code": "Shim and Overlay \u2013 1.5\u201d" }, { "name": "Mill and Overlay \u2013 1.5\u201d", "code": "Mill and Overlay \u2013 1.5\u201d" }, { "name": "Mill and Overlay \u2013 2\u201d", "code": "Mill and Overlay \u2013 2\u201d" }, { "name": "Hot In-Place Recycling w/Conventional Double Chip", "code": "Hot In-Place Recycling w/Conventional Double Chip" }, { "name": "Hot In-Place Recycling w/SAM", "code": "Hot In-Place Recycling w/SAM" }, { "name": "Hot In-Place Recycling w/Micro", "code": "Hot In-Place Recycling w/Micro" }, { "name": "Hot In-Place Recycling w/1.5\u201d HMA", "code": "Hot In-Place Recycling w/1.5\u201d HMA" }, { "name": "SAMI (with Prep Work)", "code": "SAMI (with Prep Work)" }, { "name": "Single Conventional Chip Seal", "code": "Single Conventional Chip Seal" }, { "name": "Double Conventional Chip Seal", "code": "Double Conventional Chip Seal" }, { "name": "Stress Absorbing Membrane (SAM)", "code": "Stress Absorbing Membrane (SAM)" }, { "name": "Thin Overlay \u2013 1.5\u201d", "code": "Thin Overlay \u2013 1.5\u201d" }, { "name": "Crack Seal", "code": "Crack Seal" }, { "name": "Fog Seal (Asphaltic)", "code": "Fog Seal (Asphaltic)" }, { "name": "Fog Seal Rejuvenator (MRT)", "code": "Fog Seal Rejuvenator (MRT)" }, { "name": "Fog Seal Rejuvenator (Organic)", "code": "Fog Seal Rejuvenator (Organic)" }, { "name": "Hand Work/Spot Improvements", "code": "Hand Work/Spot Improvements" }, { "name": "Mastics", "code": "Mastics" }, { "name": "Not Planned", "code": "Not Planned" }, { "name": "Microsurfacing \u2013 Single Lift", "code": "Microsurfacing \u2013 Single Lift" }, { "name": "Microsurfacing \u2013 Double Lift", "code": "Microsurfacing \u2013 Double Lift" }, { "name": "Microsurfacing (HIMA) \u2013 Single Lift", "code": "Microsurfacing (HIMA) \u2013 Single Lift" }, { "name": "Microsurfacing (HIMA) \u2013 Double Lift", "code": "Microsurfacing (HIMA) \u2013 Double Lift" }, { "name": "Ultra Thin Bonded Wearing Course", "code": "Ultra Thin Bonded Wearing Course" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPSource", "type": "esriFieldTypeString", "alias": "CIPSource", "length": 255, "domain": null }, { "name": "CIPContingency", "type": "esriFieldTypeDouble", "alias": "CIPContingency", "domain": null }, { "name": "CIPUnitPrice", "type": "esriFieldTypeDouble", "alias": "CIPUnitPrice", "domain": null }, { "name": "CIPLifeYearsAdded", "type": "esriFieldTypeDouble", "alias": "CIPLifeYearsAdded", "domain": null }, { "name": "CIPRepairCost", "type": "esriFieldTypeDouble", "alias": "CIPRepairCost", "domain": null }, { "name": "CIPYear", "type": "esriFieldTypeString", "alias": "CIPYear", "length": 255, "domain": { "type": "codedValue", "name": "DomCIPYear", "description": "CIP Years", "codedValues": [ { "name": "Not Planned", "code": "Not Planned" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectYear", "type": "esriFieldTypeSmallInteger", "alias": "InspectYear", "domain": null }, { "name": "CIP_Year1PCI", "type": "esriFieldTypeDouble", "alias": "CIP_Year1PCI", "domain": null }, { "name": "CIP_Year2PCI", "type": "esriFieldTypeDouble", "alias": "CIP_Year2PCI", "domain": null }, { "name": "CIP_Year3PCI", "type": "esriFieldTypeDouble", "alias": "CIP_Year3PCI", "domain": null }, { "name": "CIP_Year4PCI", "type": "esriFieldTypeDouble", "alias": "CIP_Year4PCI", "domain": null }, { "name": "CIP_Year5PCI", "type": "esriFieldTypeDouble", "alias": "CIP_Year5PCI", "domain": null }, { "name": "RITMoratoriumEndDate", "type": "esriFieldTypeDateOnly", "alias": "RITMoratoriumEndDate", "domain": null }, { "name": "RITMoratoriumDuration", "type": "esriFieldTypeSmallInteger", "alias": "RITMoratoriumDuration", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_24", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G30StreetLimitID", "fields": "StreetLimitID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I30StreetName", "fields": "StreetName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_24", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "DBO.RoadImprovements", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{44573134-E1BA-437D-A4A3-ED59CCEB8F24}" }, { "id": 1, "name": "DBO.CIPPlanSegments", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B76310C3-D26F-481E-80A5-8624ECD438B0}" }, { "id": 0, "name": "DBO.PCIHistory", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A64046D-D486-4B64-B0E9-040883ED2384}" }, { "id": 2, "name": "DBO.Inspection", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9BED2AF9-6B04-4579-90AE-EA5A25135815}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790711008000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Capital Plan", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PlanName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PlanName", "type": "esriFieldTypeString", "alias": "PlanName", "length": 255, "domain": null }, { "name": "CIPYear", "type": "esriFieldTypeSmallInteger", "alias": "CIPYear", "domain": null }, { "name": "CIPTotal", "type": "esriFieldTypeDouble", "alias": "CIPTotal", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_19", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_19", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.CIPPlanSegments", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C423D22F-BFED-4694-A185-11ECE610DCC9}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710754000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "CIP Plan Segments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CIPCapitalSource", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "CIPYear", "type": "esriFieldTypeSmallInteger", "alias": "CIPYear", "domain": null }, { "name": "CIPCapitalSource", "type": "esriFieldTypeString", "alias": "CIPCapitalSource", "length": 255, "domain": null }, { "name": "CIPRepairType", "type": "esriFieldTypeString", "alias": "CIPRepairType", "length": 255, "domain": null }, { "name": "CIPUnitPrice", "type": "esriFieldTypeDouble", "alias": "CIPUnitPrice", "domain": null }, { "name": "CIPLifeYearsAdded", "type": "esriFieldTypeSmallInteger", "alias": "CIPLifeYearsAdded", "domain": null }, { "name": "CIPRepairCost", "type": "esriFieldTypeDouble", "alias": "CIPRepairCost", "domain": null }, { "name": "CIPContingency", "type": "esriFieldTypeDouble", "alias": "CIPContingency", "domain": null }, { "name": "CIPVariedCosts", "type": "esriFieldTypeDouble", "alias": "CIPVariedCosts", "domain": null }, { "name": "CIPEstTotalCost", "type": "esriFieldTypeDouble", "alias": "CIPEstTotalCost", "domain": null }, { "name": "CIPEAC", "type": "esriFieldTypeDouble", "alias": "CIPEAC", "domain": null }, { "name": "CIPRSL", "type": "esriFieldTypeDouble", "alias": "CIPRSL", "domain": null }, { "name": "CIPWard", "type": "esriFieldTypeSmallInteger", "alias": "CIPWard", "domain": null }, { "name": "CIPProjectedPCI", "type": "esriFieldTypeDouble", "alias": "CIPProjectedPCI", "domain": null }, { "name": "CIPSegmentGUID", "type": "esriFieldTypeGUID", "alias": "CIPSegmentGUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_20", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G26RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G26CIPSegmentGUI", "fields": "CIPSegmentGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_20", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.CapitalPlan", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C423D22F-BFED-4694-A185-11ECE610DCC9}" }, { "id": 1, "name": "DBO.Segment", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "CIPSegmentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B76310C3-D26F-481E-80A5-8624ECD438B0}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710755000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Degradation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CommunityClass", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Degradation", "type": "esriFieldTypeDouble", "alias": "Degradation", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CommunityClass", "type": "esriFieldTypeString", "alias": "CommunityClass", "length": 255, "domain": { "type": "codedValue", "name": "DomCommunityClass", "description": "Comunity Class", "codedValues": [ { "name": "Urban", "code": "Urban" }, { "name": "Rural", "code": "Rural" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FunctionalClass", "type": "esriFieldTypeString", "alias": "FunctionalClass", "length": 255, "domain": { "type": "codedValue", "name": "DomFunctionalClass", "description": "Functional Class of the roadway segment", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Principal Arterial", "code": "Principal Arterial" }, { "name": "Minor Arterial", "code": "Minor Arterial" }, { "name": "Major Collector", "code": "Major Collector" }, { "name": "Minor Collector", "code": "Minor Collector" }, { "name": "Local", "code": "Local" }, { "name": "Cul De Sac/Dead End", "code": "Cul De Sac/Dead End" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_21", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_21", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710787000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Inspector", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDateOnly", "alias": "InspectionDate", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G21RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_15", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "DBO.Segment", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9BED2AF9-6B04-4579-90AE-EA5A25135815}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710801000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "PCI History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "PCI", "type": "esriFieldTypeDouble", "alias": "PCI", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_17", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G23RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_17", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.Segment", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A64046D-D486-4B64-B0E9-040883ED2384}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710817000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Repair Categories", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Category", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": { "type": "codedValue", "name": "DomTreatmentCategories", "description": "Treatment Categories", "codedValues": [ { "name": "1-Defer Maintenance", "code": "1-Defer Maintenance" }, { "name": "3-Surface Treatments", "code": "3-Surface Treatments" }, { "name": "4-Rehabilitation", "code": "4-Rehabilitation" }, { "name": "5-Structural", "code": "5-Structural" }, { "name": "2-Minor Maintenance", "code": "2-Minor Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HighPCI", "type": "esriFieldTypeDouble", "alias": "HighPCI", "domain": null }, { "name": "LowPCI", "type": "esriFieldTypeDouble", "alias": "LowPCI", "domain": null }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 255, "domain": null }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "Community_Class", "type": "esriFieldTypeString", "alias": "Community_Class", "length": 255, "domain": { "type": "codedValue", "name": "DomCommunityClass", "description": "Comunity Class", "codedValues": [ { "name": "Urban", "code": "Urban" }, { "name": "Rural", "code": "Rural" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AverageLYA", "type": "esriFieldTypeDouble", "alias": "AverageLYA", "domain": null }, { "name": "LifeYearsAdded", "type": "esriFieldTypeDouble", "alias": "LifeYearsAdded", "domain": null }, { "name": "AverageCost", "type": "esriFieldTypeDouble", "alias": "AverageCost", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PCI_Increment", "type": "esriFieldTypeDouble", "alias": "PCI_Increment", "domain": null }, { "name": "PCI_Cap", "type": "esriFieldTypeDouble", "alias": "PCI_Cap", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_16", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_16", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710856000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "RepairCategories_Ramps", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Treatment", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 255, "domain": { "type": "codedValue", "name": "DomRampRepairTypes", "description": "Ramp Repair Types", "codedValues": [ { "name": "Do Nothing", "code": "Do Nothing" }, { "name": "Ramp Maintenance", "code": "Ramp Maintenance" }, { "name": "Ramp Replacement", "code": "Ramp Replacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "DomSWCondition", "description": "Sidewalk Condition", "codedValues": [ { "name": "1-Excellent", "code": "1-Excellent" }, { "name": "2-Good", "code": "2-Good" }, { "name": "3-Fair", "code": "3-Fair" }, { "name": "4-Poor", "code": "4-Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_23", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_23", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710872000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "RepairCategories_Sidewalks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Category", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": { "type": "codedValue", "name": "DomSWRepairType", "description": "Sidewalk Repair Types", "codedValues": [ { "name": "3-Replace With PCC", "code": "3-ReplaceWithPCC" }, { "name": "3-Replace With Asphalt", "code": "3-ReplaceWithAsphalt" }, { "name": "2-Stonedust Maintenance", "code": "2-Stonedust Maintenance" }, { "name": "2-PCC Maintenance", "code": "2-PCCMaintenance" }, { "name": "2-Brick or Paver Maintenance", "code": "2-BrickMaintenance" }, { "name": "2-Asphalt Maintenance", "code": "2-AsphaltMaintenance" }, { "name": "1-Defer Maintenance", "code": "1-DeferMaintenance" }, { "name": "3-Replace With Brick", "code": "3-ReplaceWithBrick" }, { "name": "3-Replace With Pavers", "code": "3-ReplaceWithPavers" }, { "name": "Replace With PCC Granite Curb", "code": "4-ReplaceWithPCC&GraniteCurb" }, { "name": "4-Replace With Asphalt & Asphalt Curb", "code": "4-ReplaceWithAsphalt&AsphaltCurb" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HighSCI", "type": "esriFieldTypeDouble", "alias": "HighPCI", "domain": null }, { "name": "LowSCI", "type": "esriFieldTypeDouble", "alias": "LowPCI", "domain": null }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 255, "domain": null }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "AverageCost", "type": "esriFieldTypeDouble", "alias": "AverageCost", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": { "type": "codedValue", "name": "DomSWMaterialType", "description": "Sidewalk Surface Material", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Brick", "code": "Brick" }, { "name": "Composite", "code": "Composite" }, { "name": "Pavers", "code": "Pavers" }, { "name": "PCC", "code": "PCC" }, { "name": "Stonedust", "code": "Stonedust" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_22", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_22", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710903000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Road Improvement Tracking", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RITRepairType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "RITYear", "type": "esriFieldTypeSmallInteger", "alias": "RITYear", "domain": null }, { "name": "RITDate", "type": "esriFieldTypeDateOnly", "alias": "RITDate", "domain": null }, { "name": "RITRepairType", "type": "esriFieldTypeString", "alias": "RITRepairType", "length": 255, "domain": null }, { "name": "RITCapitalSource", "type": "esriFieldTypeString", "alias": "RITCapitalSource", "length": 255, "domain": null }, { "name": "RITContractor", "type": "esriFieldTypeString", "alias": "RITContractor", "length": 255, "domain": null }, { "name": "RITMoratoriumDuration", "type": "esriFieldTypeSmallInteger", "alias": "RITMoratoriumDuration", "domain": null }, { "name": "RITMoratoriumEndDate", "type": "esriFieldTypeDateOnly", "alias": "RITMoratoriumEndDate", "domain": null }, { "name": "RITWard", "type": "esriFieldTypeSmallInteger", "alias": "RITWard", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "RITTotalCost", "type": "esriFieldTypeDouble", "alias": "RITTotalCost", "domain": null }, { "name": "PCI_Pre", "type": "esriFieldTypeDouble", "alias": "PCI_Pre", "domain": null }, { "name": "PCI_Post", "type": "esriFieldTypeDouble", "alias": "PCI_Post", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_18", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G24RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_18", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "DBO.Segment", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{44573134-E1BA-437D-A4A3-ED59CCEB8F24}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1790710994000 } } ] }