{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "ROAD_CONSTR_PROJS_INFO", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CONTRACT", "type": "esriFieldTypeString", "alias": "CONTRACT NO", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "CONTRACT NAME", "length": 50, "domain": { "type": "codedValue", "name": "CONPROJ_NAME", "description": "Names for construction projects", "codedValues": [ { "name": "RECONSTRUCTION", "code": "RECONSTRUCTION" }, { "name": "OVERLAY", "code": "OVERLAY" }, { "name": "CRACK SEAL", "code": "CRACK SEAL" }, { "name": "SURFACE TREATMENT & MICROSURFACE", "code": "SURFACE TREATMENT & MICROSURFACE" }, { "name": "WATERCOURSE IMPROVEMENT", "code": "WATERCOURSE IMPROVEMENT" }, { "name": "EXPANDED ASPHALT", "code": "EXPANDED ASPHALT" }, { "name": "MUNICIPAL STRUCTURE", "code": "MUNICIPAL STRUCTURE" }, { "name": "TREE CLEARING", "code": "TREE CLEARING" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "CONPROJ_STATUS", "description": "Statuses for construction projects", "codedValues": [ { "name": "PLANNED", "code": "PLANNED" }, { "name": "UNDERWAY", "code": "UNDERWAY" }, { "name": "WARRANTY", "code": "WARRANTY" }, { "name": "COMPLETE", "code": "COMPLETE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": { "type": "codedValue", "name": "CONPROJ_TYPE", "description": "Types for construction projects", "codedValues": [ { "name": "ROAD", "code": "ROAD" }, { "name": "WATERCOURSE", "code": "WATERCOURSE" }, { "name": "CULVERT", "code": "CULVERT" }, { "name": "BRIDGE", "code": "BRIDGE" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "YEAR_CON", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_CON", "domain": null }, { "name": "YEAR_COMPLETE", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_COMPLETE", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I8CONTRACT", "fields": "CONTRACT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }