{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 48, "name": "Amenity", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "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": 20, "domain": null }, { "name": "TRANSITKEY", "type": "esriFieldTypeString", "alias": "Transit Key", "length": 20, "domain": null }, { "name": "AMENITYTYPE", "type": "esriFieldTypeString", "alias": "Amenity Type", "length": 30, "domain": { "type": "codedValue", "name": "WS5_TNSTAmenity", "description": "Transit Amenity", "codedValues": [ { "name": "Advertising Kiosk", "code": "Advertising Kiosk" }, { "name": "Advertising Shelter", "code": "Advertising Shelter" }, { "name": "Bench", "code": "Bench" }, { "name": "Bike Rack", "code": "Bike Rack" }, { "name": "Miscellaneous", "code": "Miscellaneous" }, { "name": "Park and Ride", "code": "Park and Ride" }, { "name": "Shade Screens", "code": "Shade Screens" }, { "name": "Shelter", "code": "Shelter" }, { "name": "Transit Center", "code": "Transit Center" }, { "name": "Trash Can", "code": "Trash Can" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AMENITYSUBTYPE", "type": "esriFieldTypeString", "alias": "Amenity Subtype", "length": 30, "domain": { "type": "codedValue", "name": "WS5_TNSTAmenitySubType", "description": "Transit Amenity SubTypes", "codedValues": [ { "name": "3-Leg Style", "code": "3-Leg Style" }, { "name": "4' Mesh", "code": "4' Mesh" }, { "name": "6' No Vandal Bar", "code": "6' No Vandal Bar" }, { "name": "6' With Vandal Bar", "code": "6' With Vandal Bar" }, { "name": "Art", "code": "Art" }, { "name": "Attached", "code": "Attached" }, { "name": "Bolt In", "code": "Bolt In" }, { "name": "BRT", "code": "BRT" }, { "name": "Bus Decal", "code": "Bus Decal" }, { "name": "Cast in Concrete", "code": "Cast in Concrete" }, { "name": "City Owned", "code": "City Owned" }, { "name": "Cube", "code": "Cube" }, { "name": "Fiesta", "code": "Fiesta" }, { "name": "Global 36 Gallon", "code": "Global 36 Gallon" }, { "name": "Mesa Drive Specialty", "code": "Mesa Drive Specialty" }, { "name": "Mesh", "code": "Mesh" }, { "name": "Miniature", "code": "Miniature" }, { "name": "Pole Mounted", "code": "Pole Mounted" }, { "name": "Ribbed", "code": "Ribbed" }, { "name": "Simmi Seat", "code": "Simmi Seat" }, { "name": "Specialty", "code": "Specialty" }, { "name": "Specialty Art", "code": "Specialty Art" }, { "name": "Standard M-45", "code": "Standard M-45" }, { "name": "Three-Legged", "code": "Three-Legged" }, { "name": "Town Center", "code": "Town Center" }, { "name": "Transit Center", "code": "Transit Center" }, { "name": "University Specialty", "code": "University Specialty" }, { "name": "Vendor Owned", "code": "Vendor Owned" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AMENITYCOLOR", "type": "esriFieldTypeString", "alias": "Amenity Color", "length": 20, "domain": { "type": "codedValue", "name": "WS5_TNSTColor", "description": "Transit Color", "codedValues": [ { "name": "Rust Oxide RAL 3009", "code": "Rust Oxide RAL 3009" }, { "name": "Green", "code": "Green" }, { "name": "White", "code": "White" }, { "name": "Silver", "code": "Silver" }, { "name": "BRT", "code": "BRT" }, { "name": "Art: Various Colors", "code": "Art: Various Colors" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ISACTIVE", "type": "esriFieldTypeString", "alias": "IsActive", "length": 10, "domain": { "type": "codedValue", "name": "WS5_YesNoText", "description": "Yes and No Text Codes and Descriptions", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 20, "domain": { "type": "codedValue", "name": "WS5_Owner_Text", "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": "ASSET_COND", "type": "esriFieldTypeString", "alias": "Asset Condition", "length": 20, "domain": { "type": "codedValue", "name": "WS5_TNSTCondition", "description": "Transit Condition", "codedValues": [ { "name": "5 - New", "code": "5 - New" }, { "name": "4 - Excellent", "code": "4 - Excellent" }, { "name": "3 - Good", "code": "3 - Good" }, { "name": "2 - Fair", "code": "2 - Fair" }, { "name": "1 - Poor", "code": "1 - Poor" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "INSPECT_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "REFURB_DATE", "type": "esriFieldTypeDate", "alias": "Refurbished Date", "length": 8, "domain": null }, { "name": "RETIRE_DATE", "type": "esriFieldTypeDate", "alias": "Retire Date", "length": 8, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null } ], "indexes": [ { "name": "R128_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G711TRANSITKEY", "fields": "TRANSITKEY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "TRANSIT", "relatedTableId": 64, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 6, "name": "TRANSIT", "relatedTableId": 63, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 10, "name": "TRANSIT", "relatedTableId": 62, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 14, "name": "TRANSIT", "relatedTableId": 61, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 18, "name": "TRANSIT", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 22, "name": "TRANSIT", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 26, "name": "TRANSIT", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 30, "name": "TRANSIT", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 34, "name": "TRANSIT", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 38, "name": "TRANSIT", "relatedTableId": 56, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 42, "name": "TRANSIT", "relatedTableId": 57, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 46, "name": "TRANSIT", "relatedTableId": 58, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 50, "name": "TRANSIT", "relatedTableId": 59, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" }, { "id": 59, "name": "TRANSIT", "relatedTableId": 60, "role": "esriRelRoleDestination", "keyField": "TRANSITKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{83ABD549-35FB-4B3A-848F-CAF4563A46F3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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 }, "serviceItemId": "06ce554b0d9b4dca8223d5170bf5e6ba" }