{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "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": [ 155, 93, 54, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 567125.6770307273, "ymin": 2880694.027911648, "xmax": 595256.8156502247, "ymax": 2911527.5371106416, "spatialReference": { "wkid": 103072, "latestWkid": 6492, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "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": null }, { "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 Street", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurbingLocation", "type": "esriFieldTypeString", "alias": "CurbingLocation", "length": 255, "domain": { "type": "codedValue", "name": "DomStreetSide", "description": "Side of the Street", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Even", "code": "Even" }, { "name": "Odd", "code": "Odd" }, { "name": "Both Sides", "code": "Both" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurbLine", "type": "esriFieldTypeString", "alias": "LineStripingLocation", "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": "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" } ], "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "StreetName1", "type": "esriFieldTypeString", "alias": "StreetName", "length": 255, "domain": null }, { "name": "RITYear", "type": "esriFieldTypeSmallInteger", "alias": "RITYear", "domain": null }, { "name": "RITRepairType", "type": "esriFieldTypeString", "alias": "RITRepairType", "length": 255, "domain": { "type": "codedValue", "name": "DomRepairCatagories", "description": "Road repair types", "codedValues": [ { "name": "Crack Seal", "code": "Crack Seal" }, { "name": "Surface Seal", "code": "Surface Seal" }, { "name": "Overlay", "code": "Overlay" }, { "name": "Mill & Overlay", "code": "Mill & Overlay" }, { "name": "Rehabilitation", "code": "Rehabilitation" }, { "name": "Single Conventional Chip Seal", "code": "Single Conventional Chip Seal" }, { "name": "Thin Overlay \u2013 1.5\u201d", "code": "Thin Overlay \u2013 1.5\u201d" } ], "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" }, { "name": "2031", "code": "2031" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R22_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_22", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G20StreetLimitID", "fields": "StreetLimitID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.RoadImprovements", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{F600887F-55B7-4A54-B686-10D33582D9CC}" }, { "id": 1, "name": "DBO.Inspection", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9789750C-A241-4075-818E-39394F22DBD9}" }, { "id": 3, "name": "DBO.CIPPlanSegments", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1B65B06A-03AA-4C70-A860-B8DEC6792ACC}" }, { "id": 2, "name": "DBO.PCIHistory", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EC1003A4-05E4-4F92-8474-B76240BC70ED}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "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": "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_19", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.CIPPlanSegments", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7903F311-8618-4472-803F-F54F89B3479E}" } ], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "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 }, { "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 } ], "indexes": [ { "name": "R20_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_20", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G18RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18CIPSegmentGUI", "fields": "CIPSegmentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.CapitalPlan", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7903F311-8618-4472-803F-F54F89B3479E}" }, { "id": 3, "name": "DBO.Segment", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "CIPSegmentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1B65B06A-03AA-4C70-A860-B8DEC6792ACC}" } ], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "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": "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R21_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_21", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "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": "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G13RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "DBO.Segment", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9789750C-A241-4075-818E-39394F22DBD9}" } ], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "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": "Field", "type": "esriFieldTypeInteger", "alias": "Field", "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": "R17_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_17", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G15RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "DBO.Segment", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EC1003A4-05E4-4F92-8474-B76240BC70ED}" } ], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "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": "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RITTotalCost", "type": "esriFieldTypeDouble", "alias": "RITTotalCost", "domain": null }, { "name": "PCI_Pre", "type": "esriFieldTypeDouble", "alias": "Initial PCI", "domain": null }, { "name": "PCI_Post", "type": "esriFieldTypeDouble", "alias": "New PCI", "domain": null } ], "indexes": [ { "name": "R18_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_18", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G16RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.Segment", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{F600887F-55B7-4A54-B686-10D33582D9CC}" } ], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Repair Categories", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Category", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": null }, { "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": null }, { "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": "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": "PCI_Increment", "type": "esriFieldTypeDouble", "alias": "Increment", "domain": null }, { "name": "PCI_Cap", "type": "esriFieldTypeDouble", "alias": "PCI Cap", "domain": null } ], "indexes": [ { "name": "R23_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }