{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "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_2", "description": "Jurisdiction", "codedValues": [ { "name": "Atherton", "code": "Atherton" }, { "name": "Belmont", "code": "Belmont" }, { "name": "Brisbane", "code": "Brisbane" }, { "name": "Burlingame", "code": "Burlingame" }, { "name": "Colma", "code": "Colma" }, { "name": "Daly City", "code": "Daly City" }, { "name": "East Palo Alto", "code": "East Palo Alto" }, { "name": "Foster City", "code": "Foster City" }, { "name": "Half Moon Bay", "code": "Half Moon Bay" }, { "name": "Hillsborough", "code": "Hillsborough" }, { "name": "Menlo Park", "code": "Menlo Park" }, { "name": "Millbrae", "code": "Millbrae" }, { "name": "Pacifica", "code": "Pacifica" }, { "name": "Portolla Valley", "code": "Portola Valley" }, { "name": "Redwood City", "code": "Redwood City" }, { "name": "San Bruno", "code": "San Bruno" }, { "name": "San Carlos", "code": "San Carlos" }, { "name": "San Mateo", "code": "San Mateo" }, { "name": "South San Francisco", "code": "South San Francisco" }, { "name": "Woodside", "code": "Woodside" }, { "name": "Unincorporated San Mateo", "code": "Unincorporated San Mateo" } ], "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": "C/CAG Travel Model", "code": "C/CAG Travel Model" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "vmt_metric", "type": "esriFieldTypeString", "alias": "VMT Metric", "length": 255, "domain": { "type": "codedValue", "name": "VMTMetric_2", "description": "VMT Metric", "codedValues": [ { "name": "Home-based VMT per Resident", "code": "Home-based VMT per Resident" }, { "name": "Total Project Generated VMT per Service Population", "code": "Total Project Generated VMT per Service Population" }, { "name": "Home-based Work VMT per Employee", "code": "Home-based Work VMT per Employee" } ], "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" } ], "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": "R47_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G64jurisdiction", "fields": "jurisdiction", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G64vmt_metric", "fields": "vmt_metric", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G64data_version", "fields": "data_version", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G64DataVersion_I", "fields": "DataVersion_Index", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G64VMTMetric_Ind", "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": "{7719F888-3899-42AB-9534-5CE7F595A8E2}" }, { "id": 5, "name": "ThresholdConfig", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "VMTMetric_Index", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FF6BB649-5088-4288-B114-BEA10B2BC24E}" }, { "id": 1, "name": "DataVersionConfig", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "DataVersion_Index", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C2E8F41F-48E8-4530-9819-1491FAF0EBF3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }