{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "VMTMetricConfig", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "jurisdiction", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 255, "domain": { "type": "codedValue", "name": "Jurisdiction", "description": "Jurisdiction", "codedValues": [ { "name": "Covina", "code": "Covina" }, { "name": "Arcadia", "code": "Arcadia" }, { "name": "Baldwin Park", "code": "Baldwin Park" }, { "name": "Claremont", "code": "Claremont" }, { "name": "Diamond Bar", "code": "Diamond Bar" }, { "name": "Duarte", "code": "Duarte" }, { "name": "El Monte", "code": "El Monte" }, { "name": "Industry", "code": "Industry" }, { "name": "Irwindale", "code": "Irwindale" }, { "name": "La Canada Flintridge", "code": "La Canada Flintridge" }, { "name": "La Puente", "code": "La Puente" }, { "name": "La Verne", "code": "La Verne" }, { "name": "Monrovia", "code": "Monrovia" }, { "name": "Montebello", "code": "Montebello" }, { "name": "Monterey Park", "code": "Monterey Park" }, { "name": "Pomona", "code": "Pomona" }, { "name": "Rosemead", "code": "Rosemead" }, { "name": "San Gabriel", "code": "San Gabriel" }, { "name": "San Marino", "code": "San Marino" }, { "name": "Sierra Madre", "code": "Sierra Madre" }, { "name": "South El Monte", "code": "South El Monte" }, { "name": "Temple City", "code": "Temple City" }, { "name": "Walnut", "code": "Walnut" }, { "name": "West Covina", "code": "West Covina" }, { "name": "Azusa", "code": "Azusa" }, { "name": "Alhambra", "code": "Alhambra" }, { "name": "San Dimas", "code": "San Dimas" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "data_version", "type": "esriFieldTypeString", "alias": "Data Version", "length": 255, "domain": { "type": "codedValue", "name": "DataVersion", "description": "Data Version Used", "codedValues": [ { "name": "VTA Countywide Model December 2019", "code": "VTA Countywide Model December 2019" }, { "name": "SCAG Regional Travel Demand Model 2016 RTP Base Year 2012", "code": "SCAG Regional Travel Demand Model 2016 RTP Base Year 2012" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "vmt_metric", "type": "esriFieldTypeString", "alias": "VMT Metric", "length": 255, "domain": { "type": "codedValue", "name": "VMTMetric", "description": "VMT Metric", "codedValues": [ { "name": "Home-based Work VMT per Worker", "code": "Home-based Work VMT per Worker" }, { "name": "Home-based VMT per Capita", "code": "Home-based VMT per Capita" }, { "name": "Total VMT per Service Population", "code": "Total VMT per Service Population" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "land_use_type", "type": "esriFieldTypeString", "alias": "Land Use Type", "length": 255, "domain": { "type": "codedValue", "name": "LandUseType", "description": "Land Use Type", "codedValues": [ { "name": "Residential", "code": "Residential" }, { "name": "Office", "code": "Office" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Commercial", "code": "Commercial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "numerator_field", "type": "esriFieldTypeString", "alias": "Numerator Field", "length": 255, "domain": null }, { "name": "denominator_field", "type": "esriFieldTypeString", "alias": "Denominator Field", "length": 255, "domain": null }, { "name": "DataVersion_Index", "type": "esriFieldTypeString", "alias": "DataVersion_Index", "length": 100, "domain": null }, { "name": "VMTMetric_Index", "type": "esriFieldTypeString", "alias": "VMTMetric_Index", "length": 150, "domain": null } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1313jurisdictio", "fields": "jurisdiction", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1313vmt_metric", "fields": "vmt_metric", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1313data_versio", "fields": "data_version", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1313DataVersion", "fields": "DataVersion_Index", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1313VMTMetric_I", "fields": "VMTMetric_Index", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BaselineConfig", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "VMTMetric_Index", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5D8D5355-9B57-4D62-9C55-2872067C000D}" }, { "id": 5, "name": "ThresholdConfig", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "VMTMetric_Index", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4E8F5E57-8BAD-46C7-904D-E94CF9EEEF1A}" }, { "id": 1, "name": "VTA_VMT_WebTool.DBO.DataVersionConfig", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "DataVersion_Index", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{61BB0F57-406F-4787-BA6A-918FD7918533}" } ], "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "6f2a89f1fa7d43b58c0c9ec9920ae7e0" }