{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "Routes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ROUTE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 30, "domain": null }, { "name": "TRANSITKEY", "type": "esriFieldTypeString", "alias": "Transit Key", "length": 20, "domain": null }, { "name": "ROUTE", "type": "esriFieldTypeString", "alias": "Route", "length": 20, "domain": { "type": "codedValue", "name": "WS2_TNSTRoute", "description": "Transit Routes", "codedValues": [ { "name": "104", "code": "104" }, { "name": "108", "code": "108" }, { "name": "112", "code": "112" }, { "name": "120", "code": "120" }, { "name": "128", "code": "128" }, { "name": "136", "code": "136" }, { "name": "136 B", "code": "136 B" }, { "name": "156", "code": "156" }, { "name": "184", "code": "184" }, { "name": "30", "code": "30" }, { "name": "40", "code": "40" }, { "name": "45", "code": "45" }, { "name": "48", "code": "48" }, { "name": "531", "code": "531" }, { "name": "533", "code": "533" }, { "name": "535", "code": "535" }, { "name": "541", "code": "541" }, { "name": "61", "code": "61" }, { "name": "77", "code": "77" }, { "name": "96", "code": "96" }, { "name": "Downtown Buzz", "code": "Downtown Buzz" }, { "name": "Fiesta Buzz", "code": "Fiesta Buzz" }, { "name": "NA", "code": "NA" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Owner_Text_2", "description": "Owner_Text", "codedValues": [ { "name": "Mesa", "code": "Mesa" }, { "name": "Private", "code": "Private" }, { "name": "Maricopa County", "code": "Maricopa County" }, { "name": "ADOT", "code": "ADOT" }, { "name": "SRP", "code": "SRP" }, { "name": "Mesa Trans", "code": "Mesa Trans" }, { "name": "Mesa Parks", "code": "Mesa Parks" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Not Applicable", "code": "Not Applicable" }, { "name": "Tempe", "code": "Tempe" }, { "name": "Chandler", "code": "Chandler" }, { "name": "Gilbert", "code": "Gilbert" }, { "name": "Apache Junction", "code": "Apache Junction" }, { "name": "Queen Creek", "code": "Queen Creek" }, { "name": "Pinal County", "code": "Pinal County" }, { "name": "COM Transit", "code": "COM Transit" }, { "name": "RWCD", "code": "RWCD" }, { "name": "CAP", "code": "CAP" }, { "name": "Valley Metro", "code": "Valley Metro" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ISACTIVE", "type": "esriFieldTypeString", "alias": "IsActive", "length": 10, "domain": { "type": "codedValue", "name": "WS2_YesNoText", "description": "Yes and No Text Codes and Descriptions", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 100, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G241TRANSITKEY", "fields": "TRANSITKEY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "TRANSIT", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }