{ "currentVersion": 10.91, "id": 1, "name": "Mesquite.DBO.ST_Improvements", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SectionID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SectionID", "type": "esriFieldTypeString", "alias": "SectionID", "length": 15, "domain": null }, { "name": "ImprovementType", "type": "esriFieldTypeString", "alias": "ImprovementType", "length": 25, "domain": { "type": "codedValue", "name": "ImprovementType_1", "description": "List of Improvements", "codedValues": [ { "name": "Added Width", "code": "Added Width" }, { "name": "Chipseal", "code": "Chipseal" }, { "name": "Crackseal", "code": "Crackseal" }, { "name": "Mill & Overlay", "code": "Mill & Overlay" }, { "name": "Pothole Repair", "code": "Pothole Repair" }, { "name": "Reconstruction", "code": "Reconstruction" }, { "name": "Rejuvenate", "code": "Rejuvenate" }, { "name": "Sealcoat", "code": "Sealcoat" }, { "name": "Skin Patch", "code": "Skin Patch" }, { "name": "Type 2 Slurry", "code": "Type 2 Slurry" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EstimatedCost", "type": "esriFieldTypeString", "alias": "EstimatedCost", "length": 50, "domain": null }, { "name": "YearImproved", "type": "esriFieldTypeString", "alias": "YearImproved", "length": 4, "domain": { "type": "codedValue", "name": "Years_1", "description": "List of Years", "codedValues": [ { "name": "2018", "code": "2018" }, { "name": "2019", "code": "2019" }, { "name": "2020", "code": "2020" }, { "name": "2021", "code": "2021" }, { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G83SectionID", "fields": "SectionID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Mesquite.DBO.PavementManagement", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SectionID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }