{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "RoadMaintenanceHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "St_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "St_Name", "type": "esriFieldTypeString", "alias": "StName", "length": 50, "domain": null }, { "name": "St_From", "type": "esriFieldTypeString", "alias": "St_From", "length": 50, "domain": null }, { "name": "St_To", "type": "esriFieldTypeString", "alias": "St_To", "length": 50, "domain": null }, { "name": "Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "length": 50, "domain": { "type": "codedValue", "name": "Neighborhoods", "description": "CONA Neighborhoods", "codedValues": [ { "name": "Blanco Gardens", "code": "Blanco Gardens" }, { "name": "Blanco River North", "code": "Blanco River North" }, { "name": "Blanco Vista", "code": "Blanco Vista" }, { "name": "Castle Forest", "code": "Castle Forest" }, { "name": "Cottonwood Creek", "code": "Cottonwood Creek" }, { "name": "Downtown", "code": "Downtown" }, { "name": "Dunbar", "code": "Dunbar" }, { "name": "East Guadalupe", "code": "East Guadalupe" }, { "name": "El Camino Real", "code": "El Camino Real" }, { "name": "Fairlawn", "code": "Fairlawn" }, { "name": "Forest Hills", "code": "Forest Hills" }, { "name": "Heritage", "code": "Heritage" }, { "name": "Hills of Hays", "code": "Hills of Hays" }, { "name": "Holland Hills", "code": "Holland Hills" }, { "name": "Hughson Heights", "code": "Hughson Heights" }, { "name": "Hunter's Hill", "code": "Hunter's Hill" }, { "name": "Millview East", "code": "Millview East" }, { "name": "Millview West", "code": "Millview West" }, { "name": "Mockingbird Hills", "code": "Mockingbird Hills" }, { "name": "Oak Heights", "code": "Oak Heights" }, { "name": "Rio Vista", "code": "Rio Vista" }, { "name": "Sessom Creek", "code": "Sessom Creek" }, { "name": "Sierra Circle", "code": "Sierra Circle" }, { "name": "Southwest Hills", "code": "Southwest Hills" }, { "name": "Spring Lake Hills", "code": "Spring Lake Hills" }, { "name": "Sunset Acres", "code": "Sunset Acres" }, { "name": "Tanglewood", "code": "Tanglewood" }, { "name": "Texas State University", "code": "Texas State University" }, { "name": "Two Rivers East", "code": "Two Rivers East" }, { "name": "Unaffiliated", "code": "Unaffiliated" }, { "name": "Victory Gardens", "code": "Victory Gardens" }, { "name": "Wallace Addition", "code": "Wallace Addition" }, { "name": "Weatherford Heights", "code": "Weatherford Heights" }, { "name": "Westover", "code": "Westover" }, { "name": "Willow Creek", "code": "Willow Creek" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CompletedDate", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "WorkType", "length": 50, "domain": { "type": "codedValue", "name": "StWorkType", "description": "type of street maintainance performed", "codedValues": [ { "name": "Mill and Overlay", "code": "Mill and Overlay" }, { "name": "Other", "code": "Other" }, { "name": "Slurry Seal", "code": "Slurry Seal" }, { "name": "Reconstruction", "code": "Reconstruction" }, { "name": "Crack Seal", "code": "Crack Seal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "length": 50, "domain": { "type": "codedValue", "name": "PlannedWorkEntity", "description": "Construction/maintenance project responsibility", "codedValues": [ { "name": "Public Works", "code": "Public Works" }, { "name": "Public Services", "code": "Public Services" }, { "name": "Private", "code": "Private" }, { "name": "Other", "code": "Other" }, { "name": "Engineering", "code": "Engineering" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 250, "domain": null }, { "name": "MaximoID", "type": "esriFieldTypeString", "alias": "MaximoID", "length": 15, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FCGlobalID", "type": "esriFieldTypeGUID", "alias": "FCGlobalID", "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 } ], "indexes": [ { "name": "R16_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_16", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G61FCGlobalID", "fields": "FCGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G61MaximoID", "fields": "MaximoID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_16", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "RoadMaintenanceHistory", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "MaximoID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{08373077-D7D2-48E2-8E25-898C296DD7D5}" }, { "id": 1, "name": "RoadMaintenanceHistory", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "MaximoID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{08373077-D7D2-48E2-8E25-898C296DD7D5}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 } }