{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Case_MasterTable", "relatedTableId": 7, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "Cases_Parcel", "relatedTableId": 2, "id": 7, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Atlas_Case_Table", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "cd": null, "x_coord": null, "case_adddttm": null, "address": null, "case_type": null, "lon": null, "open_close": null, "csr_type": null, "case_resolution": null, "case_": null, "csr_priority": null, "last_mod": null, "pin": null, "y_coord": null, "lat": null, "apn": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_Case_Table", "displayField": "case_", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "case_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "case_", "length": 9, "alias": "CASE#", "type": "esriFieldTypeString" }, { "modelName": "open_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "open_close", "length": 1, "alias": "OPEN_CLOSE", "type": "esriFieldTypeString" }, { "modelName": "case_resolution", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "case_resolution", "length": 30, "alias": "CASE_RESOLUTION", "type": "esriFieldTypeString" }, { "modelName": "case_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "case_type", "length": 6, "alias": "CASE_TYPE", "type": "esriFieldTypeString" }, { "modelName": "case_adddttm", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "case_adddttm", "length": 29, "alias": "CASE_ADDDTTM", "type": "esriFieldTypeDate" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 50, "alias": "STATUS", "type": "esriFieldTypeString" }, { "modelName": "last_mod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "last_mod", "length": 29, "alias": "LAST_MOD", "type": "esriFieldTypeDate" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 36, "alias": "ADDRESS", "type": "esriFieldTypeString" }, { "modelName": "pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 20, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 10, "alias": "APN", "type": "esriFieldTypeString" }, { "modelName": "cd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cd", "length": 4, "alias": "CD", "type": "esriFieldTypeString" }, { "modelName": "csr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csr_type", "length": 254, "alias": "CSR_TYPE", "type": "esriFieldTypeString" }, { "modelName": "csr_priority", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csr_priority", "length": 4, "alias": "CSR_PRIORITY", "type": "esriFieldTypeString" }, { "modelName": "x_coord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x_coord", "alias": "X_COORD", "type": "esriFieldTypeDouble" }, { "modelName": "y_coord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y_coord", "alias": "Y_COORD", "type": "esriFieldTypeDouble" }, { "modelName": "lat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "modelName": "lon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g207pin", "isUnique": false, "description": "", "fields": "pin", "isAscending": true }, { "name": "r147_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "CSR_MasterTable", "relatedTableId": 7, "id": 10, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "CSR_Parcel", "relatedTableId": 2, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Atlas_CSR_Table", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "zip": null, "cd": null, "resolveddate": null, "x_coord": null, "resolvedas": null, "problemdate": null, "csrtye": null, "lon": null, "inspector": null, "suffix": null, "priority": null, "csr_": null, "stno": null, "pin": null, "district": null, "y_coord": null, "group_": null, "lat": null, "predir": null, "stname": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_CSR_Table", "displayField": "stname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "csr_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csr_", "alias": "CSR#", "type": "esriFieldTypeInteger" }, { "modelName": "stno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stno", "length": 6, "alias": "STNO", "type": "esriFieldTypeString" }, { "modelName": "predir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "predir", "length": 3, "alias": "PREDIR", "type": "esriFieldTypeString" }, { "modelName": "stname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stname", "length": 20, "alias": "STNAME", "type": "esriFieldTypeString" }, { "modelName": "suffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "suffix", "length": 4, "alias": "SUFFIX", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 10, "alias": "ZIP", "type": "esriFieldTypeString" }, { "modelName": "pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 20, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "cd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cd", "length": 4, "alias": "CD", "type": "esriFieldTypeString" }, { "modelName": "priority", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priority", "length": 4, "alias": "PRIORITY", "type": "esriFieldTypeString" }, { "modelName": "csrtye", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csrtye", "length": 5, "alias": "CSRTYE", "type": "esriFieldTypeString" }, { "modelName": "group_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "group_", "length": 4, "alias": "GROUP", "type": "esriFieldTypeString" }, { "modelName": "district", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "district", "length": 12, "alias": "DISTRICT", "type": "esriFieldTypeString" }, { "modelName": "inspector", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspector", "length": 12, "alias": "INSPECTOR", "type": "esriFieldTypeString" }, { "modelName": "problemdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "problemdate", "length": 29, "alias": "PROBLEMDATE", "type": "esriFieldTypeDate" }, { "modelName": "resolvedas", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "resolvedas", "length": 5, "alias": "RESOLVEDAS", "type": "esriFieldTypeString" }, { "modelName": "resolveddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "resolveddate", "length": 29, "alias": "RESOLVEDDATE", "type": "esriFieldTypeDate" }, { "modelName": "x_coord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x_coord", "alias": "X_COORD", "type": "esriFieldTypeDouble" }, { "modelName": "y_coord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y_coord", "alias": "Y_COORD", "type": "esriFieldTypeDouble" }, { "modelName": "lat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "modelName": "lon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g208pin", "isUnique": false, "description": "", "fields": "pin", "isAscending": true }, { "name": "r148_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin_nbr", "role": "esriRelRoleDestination", "composite": false, "name": "Permits_Parcel", "relatedTableId": 2, "id": 8, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin_nbr", "role": "esriRelRoleDestination", "composite": false, "name": "Permits_Address", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Atlas_Permits", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "submitted_date": null, "status_date": null, "hl": null, "work_desc": null, "primary_address": null, "solar": null, "lon": null, "refresh_time": null, "zip_code": null, "use_desc": null, "cofo_date": null, "issue_date": null, "zone": null, "apc": null, "cpa": null, "du_changed": null, "type_lat_lon": null, "cnc": null, "construction": null, "apn": null, "adu_changed": null, "lat": null, "height": null, "junior_adu": null, "cd": null, "square_footage": null, "status_desc": null, "b1_per_id1": null, "b1_per_id2": null, "b1_per_id3": null, "permit_group": null, "permit_type": null, "business_unit": null, "permit_nbr": null, "ct": null, "ev": null, "valuation": null, "pin_nbr": null, "permit_sub_type": null, "use_code": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_Permits", "displayField": "permit_nbr", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 8, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "permit_nbr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permit_nbr", "length": 17, "alias": "PERMIT_NBR", "type": "esriFieldTypeString" }, { "modelName": "primary_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_address", "length": 80, "alias": "PRIMARY_ADDRESS", "type": "esriFieldTypeString" }, { "modelName": "zip_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip_code", "alias": "ZIP_CODE", "type": "esriFieldTypeInteger" }, { "modelName": "cd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cd", "length": 4000, "alias": "CD", "type": "esriFieldTypeString" }, { "modelName": "pin_nbr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin_nbr", "length": 13, "alias": "PIN_NBR", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 10, "alias": "APN", "type": "esriFieldTypeString" }, { "modelName": "zone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone", "length": 4000, "alias": "ZONE", "type": "esriFieldTypeString" }, { "modelName": "apc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apc", "length": 4000, "alias": "APC", "type": "esriFieldTypeString" }, { "modelName": "cpa", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cpa", "length": 4000, "alias": "CPA", "type": "esriFieldTypeString" }, { "modelName": "cnc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cnc", "length": 4000, "alias": "CNC", "type": "esriFieldTypeString" }, { "modelName": "hl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hl", "length": 4000, "alias": "HL", "type": "esriFieldTypeString" }, { "modelName": "ct", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ct", "length": 4000, "alias": "CT", "type": "esriFieldTypeString" }, { "modelName": "permit_group", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permit_group", "length": 10, "alias": "PERMIT_GROUP", "type": "esriFieldTypeString" }, { "modelName": "permit_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permit_type", "length": 30, "alias": "PERMIT_TYPE", "type": "esriFieldTypeString" }, { "modelName": "permit_sub_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permit_sub_type", "length": 30, "alias": "PERMIT_SUB_TYPE", "type": "esriFieldTypeString" }, { "modelName": "use_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "use_code", "alias": "USE_CODE", "type": "esriFieldTypeSmallInteger" }, { "modelName": "use_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "use_desc", "length": 70, "alias": "USE_DESC", "type": "esriFieldTypeString" }, { "modelName": "submitted_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "submitted_date", "length": 29, "alias": "SUBMITTED_DATE", "type": "esriFieldTypeDate" }, { "modelName": "issue_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "issue_date", "length": 29, "alias": "ISSUE_DATE", "type": "esriFieldTypeDate" }, { "modelName": "cofo_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cofo_date", "length": 29, "alias": "COFO_DATE", "type": "esriFieldTypeDate" }, { "modelName": "du_changed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "du_changed", "alias": "DU_CHANGED", "type": "esriFieldTypeDouble" }, { "modelName": "adu_changed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adu_changed", "alias": "ADU_CHANGED", "type": "esriFieldTypeDouble" }, { "modelName": "junior_adu", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "junior_adu", "alias": "JUNIOR_ADU", "type": "esriFieldTypeDouble" }, { "modelName": "square_footage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "square_footage", "alias": "SQUARE_FOOTAGE", "type": "esriFieldTypeDouble" }, { "modelName": "status_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status_desc", "length": 30, "alias": "STATUS_DESC", "type": "esriFieldTypeString" }, { "modelName": "status_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "status_date", "length": 29, "alias": "STATUS_DATE", "type": "esriFieldTypeDate" }, { "modelName": "valuation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "valuation", "alias": "VALUATION", "type": "esriFieldTypeDouble" }, { "modelName": "construction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "construction", "length": 70, "alias": "CONSTRUCTION", "type": "esriFieldTypeString" }, { "modelName": "height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "HEIGHT", "type": "esriFieldTypeDouble" }, { "modelName": "type_lat_lon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type_lat_lon", "length": 8, "alias": "TYPE_LAT_LON", "type": "esriFieldTypeString" }, { "modelName": "lat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "modelName": "lon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" }, { "modelName": "work_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_desc", "length": 2000, "alias": "WORK_DESC", "type": "esriFieldTypeString" }, { "modelName": "ev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ev", "length": 1, "alias": "EV", "type": "esriFieldTypeString" }, { "modelName": "solar", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solar", "length": 1, "alias": "SOLAR", "type": "esriFieldTypeString" }, { "modelName": "business_unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "business_unit", "length": 30, "alias": "BUSINESS_UNIT", "type": "esriFieldTypeString" }, { "modelName": "b1_per_id1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "b1_per_id1", "length": 5, "alias": "B1_PER_ID1", "type": "esriFieldTypeString" }, { "modelName": "b1_per_id2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "b1_per_id2", "length": 5, "alias": "B1_PER_ID2", "type": "esriFieldTypeString" }, { "modelName": "b1_per_id3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "b1_per_id3", "length": 5, "alias": "B1_PER_ID3", "type": "esriFieldTypeString" }, { "modelName": "refresh_time", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "refresh_time", "length": 29, "alias": "REFRESH_TIME", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g209pin_nbr", "isUnique": false, "description": "", "fields": "pin_nbr", "isAscending": true }, { "name": "r149_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "buildingnum", "role": "esriRelRoleDestination", "composite": false, "name": "Benchmark_to_Building", "relatedTableId": 1, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "EBEWE_BENCHMARK", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "distribution_center_1": null, "distribution_center_2": null, "other_technology_1": null, "service_product_provider": null, "senior_car_community": null, "property_gfa_2": null, "convention_center_2": null, "property_gfa_1": null, "convention_center_1": null, "green_power_onsite": null, "indoor_water_use_insensity": null, "property_gfa_4": null, "property_gfa_3": null, "primary_property_1": null, "other_lodging_2": null, "water_current_date": null, "estimated_values_energy": null, "residential_care_facility": null, "other_speciality_hospital_2": null, "year_ending": null, "other_lodging_1": null, "largest_property_1": null, "largest_property_2": null, "bank_branch_1": null, "bank_branch_2": null, "electric_distribution_utility": null, "ambulatory_surgical_center_1": null, "ambulatory_surgical_center_2": null, "other_speciality_hospital_1": null, "refrigerated_warehouse_1": null, "refrigerated_warehouse_2": null, "release_date": null, "source_eui": null, "second_largest_2": null, "generation_date": null, "second_largest_1": null, "email": null, "police_station_1": null, "police_station_2": null, "energy_star_cert_1": null, "energy_star_cert_2": null, "energy_star_cert_3": null, "default_values": null, "total_ghg_emissions": null, "energy_star_score": null, "district_3": null, "lifestyle_center_1": null, "district_1": null, "district_2": null, "lifestyle_center_2": null, "third_largest_2": null, "site_eui": null, "third_largest_1": null, "property_3": null, "occupancy": null, "property_2": null, "address_1": null, "address_2": null, "parent_property_id": null, "last_modified_date": null, "property_1": null, "temporary_values": null, "wholesale_club_2": null, "wholesale_club_1": null, "weather_normalized_2": null, "weather_normalized_1": null, "other_public_services_1": null, "weather_normalized_4": null, "weather_normalized_3": null, "k_12_school_1": null, "weather_normalized_6": null, "pre_school_daycare_2": null, "weather_normalized_5": null, "pre_school_daycare_1": null, "weather_normalized_8": null, "other_public_services_2": null, "weather_normalized_7": null, "repair_services_2": null, "repair_services_1": null, "veterinary_office_2": null, "veterinary_office_1": null, "irrigated_area": null, "other_education_1": null, "other_education_2": null, "blank": null, "green_power_offsite": null, "state_provence": null, "total_ghg_emissions_intensity": null, "automobile_dealership": null, "annual_maximum_demand_2": null, "year_ending_date_only": null, "annual_maximum_demand_1": null, "energy_power_station_2": null, "non_refrigereated_warehouse_2": null, "non_refrigereated_warehouse_1": null, "energy_power_station_1": null, "urgent_care_clinic_other_2": null, "costar_property_id": null, "net_emissions": null, "number_of_buildings": null, "urgent_care_clinic_other_1": null, "worship_facility": null, "national_median_3": null, "national_median_2": null, "national_median_1": null, "office_1": null, "national_median_6": null, "office_2": null, "national_median_5": null, "national_median_4": null, "manufacture_industrial_plant_1": null, "data_quality_checker_run_date": null, "manufacture_industrial_plant_2": null, "social_meeting_hall_1": null, "parent_property_name": null, "social_meeting_hall_2": null, "water_use": null, "estimated_values_water": null, "percent_difference_1": null, "percent_difference_2": null, "energy_current_date": null, "multifamily_housing_5": null, "multifamily_housing_4": null, "data_quality_checker_run": null, "multifamily_housing_7": null, "multifamily_housing_6": null, "property_id": null, "college_university_1": null, "transportation_terminal_2": null, "college_university_2": null, "transportation_terminal_1": null, "multifamily_housing_1": null, "phone": null, "multifamily_housing_3": null, "multifamily_housing_2": null, "editdate": null, "alert_1": null, "alert_2": null, "restaurant_2": null, "city": null, "indirect_ghg_emissions": null, "hospital_1": null, "outdoor_water_use": null, "alert_7": null, "museum_1": null, "alert_8": null, "museum_2": null, "alert_9": null, "enclosed_mail_2": null, "restaurant_1": null, "alert_3": null, "enclosed_mail_1": null, "alert_4": null, "other_weekly_operating_hours": null, "alert_5": null, "alert_6": null, "metered_areas_1": null, "editor": null, "creator": null, "metered_areas_2": null, "source_energy_use": null, "other_mall_1": null, "electricity_use_1": null, "other_mall_2": null, "electricity_use_3": null, "electricity_use_2": null, "electricity_use_5": null, "electricity_use_4": null, "electricity_use_6": null, "medical_office_1": null, "medical_office_2": null, "organization": null, "site_energy_use": null, "postal_code": null, "strip_mall_1": null, "strip_mall_2": null, "last_modified_date_3": null, "last_modified_date_2": null, "last_modified_date_1": null, "creationdate": null, "other_services_2": null, "movie_theater_1": null, "movie_theater_2": null, "laboratory_1": null, "property_name": null, "laboratory_2": null, "performing_arts_1": null, "performing_arts_2": null, "other_entertainment_2": null, "other_entertainment_1": null, "indoor_water_use": null, "other_number_1": null, "last_modified_date_4": null, "other_utility_2": null, "on_behalf_of": null, "natural_gas_use": null, "avoided_emissions_1": null, "alert_11": null, "alert_10": null, "personal_services_2": null, "alert_12": null, "avoided_emissions_2": null, "other_recreation_2": null, "personal_services_1": null, "other_recreation_1": null, "financial_office_1": null, "financial_office_2": null, "year_built": null, "estimated_data_1": null, "other_services_1": null, "fire_station_2": null, "other_utility_1": null, "fire_station_1": null, "percent_total_electricity": null, "estimated_data_3": null, "retail_store_2": null, "estimated_data_2": null, "retail_store_1": null, "list_of_all_property_use_types": null, "other_use": null, "buildingnum": null, "library_1": null, "self_storage_facility_1": null, "self_storage_facility_2": null, "library_2": null, "hotel_1": null, "last_modified_by_2": null, "last_modified_by_1": null, "last_modified_by_4": null, "last_modified_by_3": null, "direct_ghg_emissions": null, "municipally_supplied_1": null, "property_notes": null, "primary_prpoerty_2": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "EBEWE_BENCHMARK", "displayField": "property_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "property_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_id", "length": 250, "alias": "PROPERTY_ID", "type": "esriFieldTypeString" }, { "modelName": "property_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_name", "length": 250, "alias": "PROPERTY_NAME", "type": "esriFieldTypeString" }, { "modelName": "parent_property_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_property_id", "length": 250, "alias": "PARENT_PROPERTY_ID", "type": "esriFieldTypeString" }, { "modelName": "parent_property_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_property_name", "length": 250, "alias": "PARENT_PROPERTY_NAME", "type": "esriFieldTypeString" }, { "modelName": "year_ending", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_ending", "length": 100, "alias": "YEAR_ENDING", "type": "esriFieldTypeString" }, { "modelName": "address_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_1", "length": 100, "alias": "ADDRESS_1", "type": "esriFieldTypeString" }, { "modelName": "address_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_2", "length": 100, "alias": "ADDRESS_2", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 100, "alias": "CITY", "type": "esriFieldTypeString" }, { "modelName": "state_provence", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_provence", "length": 100, "alias": "STATE_PROVENCE", "type": "esriFieldTypeString" }, { "modelName": "postal_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "postal_code", "length": 100, "alias": "POSTAL_CODE", "type": "esriFieldTypeString" }, { "modelName": "primary_property_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_property_1", "length": 100, "alias": "PRIMARY_PROPERTY_1", "type": "esriFieldTypeString" }, { "modelName": "primary_prpoerty_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_prpoerty_2", "length": 100, "alias": "PRIMARY_PRPOERTY_2", "type": "esriFieldTypeString" }, { "modelName": "list_of_all_property_use_types", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "list_of_all_property_use_types", "length": 250, "alias": "LIST_OF_ALL_PROPERTY_USE_TYPES", "type": "esriFieldTypeString" }, { "modelName": "national_median_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_1", "length": 100, "alias": "NATIONAL_MEDIAN_1", "type": "esriFieldTypeString" }, { "modelName": "property_gfa_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_gfa_1", "length": 100, "alias": "PROPERTY_GFA_1", "type": "esriFieldTypeString" }, { "modelName": "property_gfa_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_gfa_2", "length": 100, "alias": "PROPERTY_GFA_2", "type": "esriFieldTypeString" }, { "modelName": "property_gfa_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_gfa_3", "length": 100, "alias": "PROPERTY_GFA_3", "type": "esriFieldTypeString" }, { "modelName": "property_gfa_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_gfa_4", "length": 100, "alias": "PROPERTY_GFA_4", "type": "esriFieldTypeString" }, { "modelName": "irrigated_area", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "irrigated_area", "length": 100, "alias": "IRRIGATED_AREA", "type": "esriFieldTypeString" }, { "modelName": "buildingnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buildingnum", "length": 100, "alias": "BUILDINGNUM", "type": "esriFieldTypeString" }, { "modelName": "largest_property_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "largest_property_1", "length": 100, "alias": "LARGEST_PROPERTY_1", "type": "esriFieldTypeString" }, { "modelName": "largest_property_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "largest_property_2", "length": 100, "alias": "LARGEST_PROPERTY_2", "type": "esriFieldTypeString" }, { "modelName": "second_largest_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "second_largest_1", "length": 100, "alias": "SECOND_LARGEST_1", "type": "esriFieldTypeString" }, { "modelName": "second_largest_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "second_largest_2", "length": 100, "alias": "SECOND_LARGEST_2", "type": "esriFieldTypeString" }, { "modelName": "third_largest_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "third_largest_1", "length": 100, "alias": "THIRD_LARGEST_1", "type": "esriFieldTypeString" }, { "modelName": "third_largest_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "third_largest_2", "length": 100, "alias": "THIRD_LARGEST_2", "type": "esriFieldTypeString" }, { "modelName": "year_built", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built", "length": 100, "alias": "YEAR_BUILT", "type": "esriFieldTypeString" }, { "modelName": "number_of_buildings", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number_of_buildings", "length": 100, "alias": "NUMBER_OF_BUILDINGS", "type": "esriFieldTypeString" }, { "modelName": "occupancy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupancy", "length": 100, "alias": "OCCUPANCY", "type": "esriFieldTypeString" }, { "modelName": "property_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_notes", "length": 1000, "alias": "PROPERTY_NOTES", "type": "esriFieldTypeString" }, { "modelName": "last_modified_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_date", "length": 35, "alias": "LAST_MODIFIED_DATE", "type": "esriFieldTypeString" }, { "modelName": "property_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_1", "length": 100, "alias": "PROPERTY_1", "type": "esriFieldTypeString" }, { "modelName": "property_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_2", "length": 100, "alias": "PROPERTY_2", "type": "esriFieldTypeString" }, { "modelName": "property_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_3", "length": 100, "alias": "PROPERTY_3", "type": "esriFieldTypeString" }, { "modelName": "service_product_provider", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_product_provider", "length": 100, "alias": "SERVICE_PRODUCT_PROVIDER", "type": "esriFieldTypeString" }, { "modelName": "metered_areas_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "metered_areas_1", "length": 200, "alias": "METERED_AREAS_1", "type": "esriFieldTypeString" }, { "modelName": "metered_areas_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "metered_areas_2", "length": 100, "alias": "METERED_AREAS_2", "type": "esriFieldTypeString" }, { "modelName": "energy_star_cert_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_star_cert_1", "length": 125, "alias": "ENERGY_STAR_CERT_1", "type": "esriFieldTypeString" }, { "modelName": "energy_star_cert_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_star_cert_2", "length": 35, "alias": "ENERGY_STAR_CERT_2", "type": "esriFieldTypeString" }, { "modelName": "energy_star_cert_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_star_cert_3", "length": 100, "alias": "ENERGY_STAR_CERT_3", "type": "esriFieldTypeString" }, { "modelName": "energy_star_score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_star_score", "length": 100, "alias": "ENERGY_STAR_SCORE", "type": "esriFieldTypeString" }, { "modelName": "national_median_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_2", "length": 100, "alias": "NATIONAL_MEDIAN_2", "type": "esriFieldTypeString" }, { "modelName": "national_median_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_3", "length": 100, "alias": "NATIONAL_MEDIAN_3", "type": "esriFieldTypeString" }, { "modelName": "national_median_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_4", "length": 100, "alias": "NATIONAL_MEDIAN_4", "type": "esriFieldTypeString" }, { "modelName": "national_median_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_5", "length": 100, "alias": "NATIONAL_MEDIAN_5", "type": "esriFieldTypeString" }, { "modelName": "percent_difference_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_difference_1", "length": 100, "alias": "PERCENT_DIFFERENCE_1", "type": "esriFieldTypeString" }, { "modelName": "percent_difference_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_difference_2", "length": 100, "alias": "PERCENT_DIFFERENCE_2", "type": "esriFieldTypeString" }, { "modelName": "site_energy_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_energy_use", "length": 100, "alias": "SITE_ENERGY_USE", "type": "esriFieldTypeString" }, { "modelName": "source_energy_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_energy_use", "length": 100, "alias": "SOURCE_ENERGY_USE", "type": "esriFieldTypeString" }, { "modelName": "site_eui", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_eui", "length": 100, "alias": "SITE_EUI", "type": "esriFieldTypeString" }, { "modelName": "source_eui", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_eui", "length": 100, "alias": "SOURCE_EUI", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_1", "length": 100, "alias": "WEATHER_NORMALIZED_1", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_2", "length": 100, "alias": "WEATHER_NORMALIZED_2", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_3", "length": 100, "alias": "WEATHER_NORMALIZED_3", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_4", "length": 100, "alias": "WEATHER_NORMALIZED_4", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_5", "length": 100, "alias": "WEATHER_NORMALIZED_5", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_6", "length": 100, "alias": "WEATHER_NORMALIZED_6", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_7", "length": 100, "alias": "WEATHER_NORMALIZED_7", "type": "esriFieldTypeString" }, { "modelName": "weather_normalized_8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weather_normalized_8", "length": 100, "alias": "WEATHER_NORMALIZED_8", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_1", "length": 100, "alias": "ELECTRICITY_USE_1", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_2", "length": 100, "alias": "ELECTRICITY_USE_2", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_3", "length": 100, "alias": "ELECTRICITY_USE_3", "type": "esriFieldTypeString" }, { "modelName": "natural_gas_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "natural_gas_use", "length": 100, "alias": "NATURAL_GAS_USE", "type": "esriFieldTypeString" }, { "modelName": "district_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "district_1", "length": 100, "alias": "DISTRICT_1", "type": "esriFieldTypeString" }, { "modelName": "district_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "district_2", "length": 100, "alias": "DISTRICT_2", "type": "esriFieldTypeString" }, { "modelName": "district_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "district_3", "length": 100, "alias": "DISTRICT_3", "type": "esriFieldTypeString" }, { "modelName": "other_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_use", "length": 100, "alias": "OTHER_USE", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_4", "length": 100, "alias": "ELECTRICITY_USE_4", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_5", "length": 100, "alias": "ELECTRICITY_USE_5", "type": "esriFieldTypeString" }, { "modelName": "electricity_use_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electricity_use_6", "length": 100, "alias": "ELECTRICITY_USE_6", "type": "esriFieldTypeString" }, { "modelName": "green_power_onsite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "green_power_onsite", "length": 100, "alias": "GREEN_POWER_ONSITE", "type": "esriFieldTypeString" }, { "modelName": "green_power_offsite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "green_power_offsite", "length": 100, "alias": "GREEN_POWER_OFFSITE", "type": "esriFieldTypeString" }, { "modelName": "percent_total_electricity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_total_electricity", "length": 100, "alias": "PERCENT_TOTAL_ELECTRICITY", "type": "esriFieldTypeString" }, { "modelName": "avoided_emissions_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avoided_emissions_1", "length": 100, "alias": "AVOIDED_EMISSIONS_1", "type": "esriFieldTypeString" }, { "modelName": "avoided_emissions_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avoided_emissions_2", "length": 100, "alias": "AVOIDED_EMISSIONS_2", "type": "esriFieldTypeString" }, { "modelName": "total_ghg_emissions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_ghg_emissions", "length": 100, "alias": "TOTAL_GHG_EMISSIONS", "type": "esriFieldTypeString" }, { "modelName": "direct_ghg_emissions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direct_ghg_emissions", "length": 100, "alias": "DIRECT_GHG_EMISSIONS", "type": "esriFieldTypeString" }, { "modelName": "indirect_ghg_emissions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indirect_ghg_emissions", "length": 100, "alias": "INDIRECT_GHG_EMISSIONS", "type": "esriFieldTypeString" }, { "modelName": "net_emissions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "net_emissions", "length": 100, "alias": "NET_EMISSIONS", "type": "esriFieldTypeString" }, { "modelName": "total_ghg_emissions_intensity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_ghg_emissions_intensity", "length": 100, "alias": "TOTAL_GHG_EMISSIONS_INTENSITY", "type": "esriFieldTypeString" }, { "modelName": "national_median_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_median_6", "length": 100, "alias": "NATIONAL_MEDIAN_6", "type": "esriFieldTypeString" }, { "modelName": "water_current_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "water_current_date", "length": 35, "alias": "WATER_CURRENT_DATE", "type": "esriFieldTypeString" }, { "modelName": "water_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "water_use", "length": 100, "alias": "WATER_USE", "type": "esriFieldTypeString" }, { "modelName": "indoor_water_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indoor_water_use", "length": 100, "alias": "INDOOR_WATER_USE", "type": "esriFieldTypeString" }, { "modelName": "indoor_water_use_insensity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "indoor_water_use_insensity", "length": 100, "alias": "INDOOR_WATER_USE_INSENSITY", "type": "esriFieldTypeString" }, { "modelName": "outdoor_water_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outdoor_water_use", "length": 100, "alias": "OUTDOOR_WATER_USE", "type": "esriFieldTypeString" }, { "modelName": "default_values", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "default_values", "length": 100, "alias": "DEFAULT_VALUES", "type": "esriFieldTypeString" }, { "modelName": "temporary_values", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "temporary_values", "length": 100, "alias": "TEMPORARY_VALUES", "type": "esriFieldTypeString" }, { "modelName": "estimated_data_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_data_1", "length": 100, "alias": "ESTIMATED_DATA_1", "type": "esriFieldTypeString" }, { "modelName": "estimated_data_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_data_2", "length": 100, "alias": "ESTIMATED_DATA_2", "type": "esriFieldTypeString" }, { "modelName": "estimated_values_energy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_values_energy", "length": 100, "alias": "ESTIMATED_VALUES_ENERGY", "type": "esriFieldTypeString" }, { "modelName": "estimated_values_water", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_values_water", "length": 100, "alias": "ESTIMATED_VALUES_WATER", "type": "esriFieldTypeString" }, { "modelName": "estimated_data_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_data_3", "length": 100, "alias": "ESTIMATED_DATA_3", "type": "esriFieldTypeString" }, { "modelName": "alert_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_1", "length": 100, "alias": "ALERT_1", "type": "esriFieldTypeString" }, { "modelName": "alert_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_2", "length": 100, "alias": "ALERT_2", "type": "esriFieldTypeString" }, { "modelName": "alert_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_3", "length": 100, "alias": "ALERT_3", "type": "esriFieldTypeString" }, { "modelName": "data_quality_checker_run_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "data_quality_checker_run_date", "length": 35, "alias": "DATA_QUALITY_CHECKER_RUN_DATE", "type": "esriFieldTypeString" }, { "modelName": "data_quality_checker_run", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "data_quality_checker_run", "length": 100, "alias": "DATA_QUALITY_CHECKER_RUN", "type": "esriFieldTypeString" }, { "modelName": "energy_current_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_current_date", "length": 35, "alias": "ENERGY_CURRENT_DATE", "type": "esriFieldTypeString" }, { "modelName": "municipally_supplied_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "municipally_supplied_1", "length": 100, "alias": "MUNICIPALLY_SUPPLIED_1", "type": "esriFieldTypeString" }, { "modelName": "alert_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_4", "length": 100, "alias": "ALERT_4", "type": "esriFieldTypeString" }, { "modelName": "alert_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_5", "length": 100, "alias": "ALERT_5", "type": "esriFieldTypeString" }, { "modelName": "alert_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_6", "length": 100, "alias": "ALERT_6", "type": "esriFieldTypeString" }, { "modelName": "alert_7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_7", "length": 100, "alias": "ALERT_7", "type": "esriFieldTypeString" }, { "modelName": "alert_8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_8", "length": 100, "alias": "ALERT_8", "type": "esriFieldTypeString" }, { "modelName": "alert_9", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_9", "length": 100, "alias": "ALERT_9", "type": "esriFieldTypeString" }, { "modelName": "alert_10", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_10", "length": 100, "alias": "ALERT_10", "type": "esriFieldTypeString" }, { "modelName": "alert_11", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_11", "length": 100, "alias": "ALERT_11", "type": "esriFieldTypeString" }, { "modelName": "alert_12", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alert_12", "length": 100, "alias": "ALERT_12", "type": "esriFieldTypeString" }, { "modelName": "last_modified_date_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_date_1", "length": 35, "alias": "LAST_MODIFIED_DATE_1", "type": "esriFieldTypeString" }, { "modelName": "last_modified_date_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_date_2", "length": 35, "alias": "LAST_MODIFIED_DATE_2", "type": "esriFieldTypeString" }, { "modelName": "last_modified_date_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_date_3", "length": 35, "alias": "LAST_MODIFIED_DATE_3", "type": "esriFieldTypeString" }, { "modelName": "last_modified_date_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_date_4", "length": 35, "alias": "LAST_MODIFIED_DATE_4", "type": "esriFieldTypeString" }, { "modelName": "last_modified_by_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_by_1", "length": 100, "alias": "LAST_MODIFIED_BY_1", "type": "esriFieldTypeString" }, { "modelName": "last_modified_by_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_by_2", "length": 100, "alias": "LAST_MODIFIED_BY_2", "type": "esriFieldTypeString" }, { "modelName": "last_modified_by_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_by_3", "length": 100, "alias": "LAST_MODIFIED_BY_3", "type": "esriFieldTypeString" }, { "modelName": "last_modified_by_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_modified_by_4", "length": 100, "alias": "LAST_MODIFIED_BY_4", "type": "esriFieldTypeString" }, { "modelName": "annual_maximum_demand_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "annual_maximum_demand_1", "length": 100, "alias": "ANNUAL_MAXIMUM_DEMAND_1", "type": "esriFieldTypeString" }, { "modelName": "annual_maximum_demand_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "annual_maximum_demand_2", "length": 100, "alias": "ANNUAL_MAXIMUM_DEMAND_2", "type": "esriFieldTypeString" }, { "modelName": "electric_distribution_utility", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electric_distribution_utility", "length": 100, "alias": "ELECTRIC_DISTRIBUTION_UTILITY", "type": "esriFieldTypeString" }, { "modelName": "costar_property_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "costar_property_id", "length": 100, "alias": "COSTAR_PROPERTY_ID", "type": "esriFieldTypeString" }, { "modelName": "bank_branch_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bank_branch_1", "length": 100, "alias": "BANK_BRANCH_1", "type": "esriFieldTypeString" }, { "modelName": "bank_branch_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bank_branch_2", "length": 100, "alias": "BANK_BRANCH_2", "type": "esriFieldTypeString" }, { "modelName": "distribution_center_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "distribution_center_1", "length": 100, "alias": "DISTRIBUTION_CENTER_1", "type": "esriFieldTypeString" }, { "modelName": "distribution_center_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "distribution_center_2", "length": 100, "alias": "DISTRIBUTION_CENTER_2", "type": "esriFieldTypeString" }, { "modelName": "financial_office_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "financial_office_1", "length": 100, "alias": "FINANCIAL_OFFICE_1", "type": "esriFieldTypeString" }, { "modelName": "financial_office_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "financial_office_2", "length": 100, "alias": "FINANCIAL_OFFICE_2", "type": "esriFieldTypeString" }, { "modelName": "hospital_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hospital_1", "length": 100, "alias": "HOSPITAL_1", "type": "esriFieldTypeString" }, { "modelName": "hotel_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hotel_1", "length": 100, "alias": "HOTEL_1", "type": "esriFieldTypeString" }, { "modelName": "k_12_school_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "k_12_school_1", "length": 100, "alias": "K_12_SCHOOL_1", "type": "esriFieldTypeString" }, { "modelName": "medical_office_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "medical_office_1", "length": 100, "alias": "MEDICAL_OFFICE_1", "type": "esriFieldTypeString" }, { "modelName": "medical_office_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "medical_office_2", "length": 100, "alias": "MEDICAL_OFFICE_2", "type": "esriFieldTypeString" }, { "modelName": "non_refrigereated_warehouse_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "non_refrigereated_warehouse_1", "length": 100, "alias": "NON_REFRIGEREATED_WAREHOUSE_1", "type": "esriFieldTypeString" }, { "modelName": "non_refrigereated_warehouse_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "non_refrigereated_warehouse_2", "length": 100, "alias": "NON_REFRIGEREATED_WAREHOUSE_2", "type": "esriFieldTypeString" }, { "modelName": "office_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "office_1", "length": 100, "alias": "OFFICE_1", "type": "esriFieldTypeString" }, { "modelName": "office_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "office_2", "length": 100, "alias": "OFFICE_2", "type": "esriFieldTypeString" }, { "modelName": "refrigerated_warehouse_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refrigerated_warehouse_1", "length": 100, "alias": "REFRIGERATED_WAREHOUSE_1", "type": "esriFieldTypeString" }, { "modelName": "refrigerated_warehouse_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refrigerated_warehouse_2", "length": 100, "alias": "REFRIGERATED_WAREHOUSE_2", "type": "esriFieldTypeString" }, { "modelName": "retail_store_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retail_store_1", "length": 100, "alias": "RETAIL_STORE_1", "type": "esriFieldTypeString" }, { "modelName": "retail_store_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "retail_store_2", "length": 100, "alias": "RETAIL_STORE_2", "type": "esriFieldTypeString" }, { "modelName": "senior_car_community", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "senior_car_community", "length": 100, "alias": "SENIOR_CAR_COMMUNITY", "type": "esriFieldTypeString" }, { "modelName": "wholesale_club_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wholesale_club_1", "length": 100, "alias": "WHOLESALE_CLUB_1", "type": "esriFieldTypeString" }, { "modelName": "wholesale_club_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wholesale_club_2", "length": 100, "alias": "WHOLESALE_CLUB_2", "type": "esriFieldTypeString" }, { "modelName": "worship_facility", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "worship_facility", "length": 100, "alias": "WORSHIP_FACILITY", "type": "esriFieldTypeString" }, { "modelName": "ambulatory_surgical_center_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ambulatory_surgical_center_1", "length": 100, "alias": "AMBULATORY_SURGICAL_CENTER_1", "type": "esriFieldTypeString" }, { "modelName": "ambulatory_surgical_center_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ambulatory_surgical_center_2", "length": 100, "alias": "AMBULATORY_SURGICAL_CENTER_2", "type": "esriFieldTypeString" }, { "modelName": "automobile_dealership", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "automobile_dealership", "length": 100, "alias": "AUTOMOBILE_DEALERSHIP", "type": "esriFieldTypeString" }, { "modelName": "college_university_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "college_university_1", "length": 100, "alias": "COLLEGE_UNIVERSITY_1", "type": "esriFieldTypeString" }, { "modelName": "college_university_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "college_university_2", "length": 100, "alias": "COLLEGE_UNIVERSITY_2", "type": "esriFieldTypeString" }, { "modelName": "convention_center_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convention_center_1", "length": 100, "alias": "CONVENTION_CENTER_1", "type": "esriFieldTypeString" }, { "modelName": "convention_center_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convention_center_2", "length": 100, "alias": "CONVENTION_CENTER_2", "type": "esriFieldTypeString" }, { "modelName": "energy_power_station_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_power_station_1", "length": 100, "alias": "ENERGY_POWER_STATION_1", "type": "esriFieldTypeString" }, { "modelName": "energy_power_station_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "energy_power_station_2", "length": 100, "alias": "ENERGY_POWER_STATION_2", "type": "esriFieldTypeString" }, { "modelName": "enclosed_mail_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosed_mail_1", "length": 100, "alias": "ENCLOSED_MAIL_1", "type": "esriFieldTypeString" }, { "modelName": "enclosed_mail_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosed_mail_2", "length": 100, "alias": "ENCLOSED_MAIL_2", "type": "esriFieldTypeString" }, { "modelName": "fire_station_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fire_station_1", "length": 100, "alias": "FIRE_STATION_1", "type": "esriFieldTypeString" }, { "modelName": "fire_station_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fire_station_2", "length": 100, "alias": "FIRE_STATION_2", "type": "esriFieldTypeString" }, { "modelName": "laboratory_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "laboratory_1", "length": 100, "alias": "LABORATORY_1", "type": "esriFieldTypeString" }, { "modelName": "laboratory_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "laboratory_2", "length": 100, "alias": "LABORATORY_2", "type": "esriFieldTypeString" }, { "modelName": "library_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "library_1", "length": 100, "alias": "LIBRARY_1", "type": "esriFieldTypeString" }, { "modelName": "library_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "library_2", "length": 100, "alias": "LIBRARY_2", "type": "esriFieldTypeString" }, { "modelName": "lifestyle_center_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lifestyle_center_1", "length": 100, "alias": "LIFESTYLE_CENTER_1", "type": "esriFieldTypeString" }, { "modelName": "lifestyle_center_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lifestyle_center_2", "length": 100, "alias": "LIFESTYLE_CENTER_2", "type": "esriFieldTypeString" }, { "modelName": "manufacture_industrial_plant_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufacture_industrial_plant_1", "length": 100, "alias": "MANUFACTURE_INDUSTRIAL_PLANT_1", "type": "esriFieldTypeString" }, { "modelName": "manufacture_industrial_plant_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufacture_industrial_plant_2", "length": 100, "alias": "MANUFACTURE_INDUSTRIAL_PLANT_2", "type": "esriFieldTypeString" }, { "modelName": "movie_theater_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "movie_theater_1", "length": 100, "alias": "MOVIE_THEATER_1", "type": "esriFieldTypeString" }, { "modelName": "movie_theater_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "movie_theater_2", "length": 100, "alias": "MOVIE_THEATER_2", "type": "esriFieldTypeString" }, { "modelName": "museum_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "museum_1", "length": 100, "alias": "MUSEUM_1", "type": "esriFieldTypeString" }, { "modelName": "museum_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "museum_2", "length": 100, "alias": "MUSEUM_2", "type": "esriFieldTypeString" }, { "modelName": "other_education_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_education_1", "length": 100, "alias": "OTHER_EDUCATION_1", "type": "esriFieldTypeString" }, { "modelName": "other_education_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_education_2", "length": 100, "alias": "OTHER_EDUCATION_2", "type": "esriFieldTypeString" }, { "modelName": "other_entertainment_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_entertainment_1", "length": 100, "alias": "OTHER_ENTERTAINMENT_1", "type": "esriFieldTypeString" }, { "modelName": "other_entertainment_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_entertainment_2", "length": 100, "alias": "OTHER_ENTERTAINMENT_2", "type": "esriFieldTypeString" }, { "modelName": "other_lodging_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_lodging_1", "length": 100, "alias": "OTHER_LODGING_1", "type": "esriFieldTypeString" }, { "modelName": "other_lodging_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_lodging_2", "length": 100, "alias": "OTHER_LODGING_2", "type": "esriFieldTypeString" }, { "modelName": "other_mall_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_mall_1", "length": 100, "alias": "OTHER_MALL_1", "type": "esriFieldTypeString" }, { "modelName": "other_mall_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_mall_2", "length": 100, "alias": "OTHER_MALL_2", "type": "esriFieldTypeString" }, { "modelName": "other_public_services_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_public_services_1", "length": 100, "alias": "OTHER_PUBLIC_SERVICES_1", "type": "esriFieldTypeString" }, { "modelName": "other_public_services_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_public_services_2", "length": 100, "alias": "OTHER_PUBLIC_SERVICES_2", "type": "esriFieldTypeString" }, { "modelName": "other_recreation_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_recreation_1", "length": 100, "alias": "OTHER_RECREATION_1", "type": "esriFieldTypeString" }, { "modelName": "other_recreation_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_recreation_2", "length": 100, "alias": "OTHER_RECREATION_2", "type": "esriFieldTypeString" }, { "modelName": "other_services_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_services_1", "length": 100, "alias": "OTHER_SERVICES_1", "type": "esriFieldTypeString" }, { "modelName": "other_services_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_services_2", "length": 100, "alias": "OTHER_SERVICES_2", "type": "esriFieldTypeString" }, { "modelName": "other_speciality_hospital_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_speciality_hospital_1", "length": 100, "alias": "OTHER_SPECIALITY_HOSPITAL_1", "type": "esriFieldTypeString" }, { "modelName": "other_speciality_hospital_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_speciality_hospital_2", "length": 100, "alias": "OTHER_SPECIALITY_HOSPITAL_2", "type": "esriFieldTypeString" }, { "modelName": "other_technology_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_technology_1", "length": 100, "alias": "OTHER_TECHNOLOGY_1", "type": "esriFieldTypeString" }, { "modelName": "other_utility_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_utility_1", "length": 100, "alias": "OTHER_UTILITY_1", "type": "esriFieldTypeString" }, { "modelName": "other_utility_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_utility_2", "length": 100, "alias": "OTHER_UTILITY_2", "type": "esriFieldTypeString" }, { "modelName": "other_number_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_number_1", "length": 100, "alias": "OTHER_NUMBER_1", "type": "esriFieldTypeString" }, { "modelName": "other_weekly_operating_hours", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_weekly_operating_hours", "length": 100, "alias": "OTHER_WEEKLY_OPERATING_HOURS", "type": "esriFieldTypeString" }, { "modelName": "performing_arts_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "performing_arts_1", "length": 100, "alias": "PERFORMING_ARTS_1", "type": "esriFieldTypeString" }, { "modelName": "performing_arts_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "performing_arts_2", "length": 100, "alias": "PERFORMING_ARTS_2", "type": "esriFieldTypeString" }, { "modelName": "personal_services_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "personal_services_1", "length": 100, "alias": "PERSONAL_SERVICES_1", "type": "esriFieldTypeString" }, { "modelName": "personal_services_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "personal_services_2", "length": 100, "alias": "PERSONAL_SERVICES_2", "type": "esriFieldTypeString" }, { "modelName": "police_station_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "police_station_1", "length": 100, "alias": "POLICE_STATION_1", "type": "esriFieldTypeString" }, { "modelName": "police_station_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "police_station_2", "length": 100, "alias": "POLICE_STATION_2", "type": "esriFieldTypeString" }, { "modelName": "pre_school_daycare_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pre_school_daycare_1", "length": 100, "alias": "PRE_SCHOOL_DAYCARE_1", "type": "esriFieldTypeString" }, { "modelName": "pre_school_daycare_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pre_school_daycare_2", "length": 100, "alias": "PRE_SCHOOL_DAYCARE_2", "type": "esriFieldTypeString" }, { "modelName": "repair_services_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "repair_services_1", "length": 100, "alias": "REPAIR_SERVICES_1", "type": "esriFieldTypeString" }, { "modelName": "repair_services_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "repair_services_2", "length": 100, "alias": "REPAIR_SERVICES_2", "type": "esriFieldTypeString" }, { "modelName": "residential_care_facility", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "residential_care_facility", "length": 100, "alias": "RESIDENTIAL_CARE_FACILITY", "type": "esriFieldTypeString" }, { "modelName": "restaurant_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "restaurant_1", "length": 100, "alias": "RESTAURANT_1", "type": "esriFieldTypeString" }, { "modelName": "restaurant_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "restaurant_2", "length": 100, "alias": "RESTAURANT_2", "type": "esriFieldTypeString" }, { "modelName": "self_storage_facility_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "self_storage_facility_1", "length": 100, "alias": "SELF_STORAGE_FACILITY_1", "type": "esriFieldTypeString" }, { "modelName": "self_storage_facility_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "self_storage_facility_2", "length": 100, "alias": "SELF_STORAGE_FACILITY_2", "type": "esriFieldTypeString" }, { "modelName": "social_meeting_hall_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "social_meeting_hall_1", "length": 100, "alias": "SOCIAL_MEETING_HALL_1", "type": "esriFieldTypeString" }, { "modelName": "social_meeting_hall_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "social_meeting_hall_2", "length": 100, "alias": "SOCIAL_MEETING_HALL_2", "type": "esriFieldTypeString" }, { "modelName": "strip_mall_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strip_mall_1", "length": 100, "alias": "STRIP_MALL_1", "type": "esriFieldTypeString" }, { "modelName": "strip_mall_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strip_mall_2", "length": 100, "alias": "STRIP_MALL_2", "type": "esriFieldTypeString" }, { "modelName": "transportation_terminal_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transportation_terminal_1", "length": 100, "alias": "TRANSPORTATION_TERMINAL_1", "type": "esriFieldTypeString" }, { "modelName": "transportation_terminal_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transportation_terminal_2", "length": 100, "alias": "TRANSPORTATION_TERMINAL_2", "type": "esriFieldTypeString" }, { "modelName": "urgent_care_clinic_other_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "urgent_care_clinic_other_1", "length": 100, "alias": "URGENT_CARE_CLINIC_OTHER_1", "type": "esriFieldTypeString" }, { "modelName": "urgent_care_clinic_other_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "urgent_care_clinic_other_2", "length": 100, "alias": "URGENT_CARE_CLINIC_OTHER_2", "type": "esriFieldTypeString" }, { "modelName": "veterinary_office_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "veterinary_office_1", "length": 100, "alias": "VETERINARY_OFFICE_1", "type": "esriFieldTypeString" }, { "modelName": "veterinary_office_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "veterinary_office_2", "length": 100, "alias": "VETERINARY_OFFICE_2", "type": "esriFieldTypeString" }, { "modelName": "on_behalf_of", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "on_behalf_of", "length": 100, "alias": "ON_BEHALF_OF", "type": "esriFieldTypeString" }, { "modelName": "organization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "organization", "length": 100, "alias": "ORGANIZATION", "type": "esriFieldTypeString" }, { "modelName": "phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 100, "alias": "PHONE", "type": "esriFieldTypeString" }, { "modelName": "email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 100, "alias": "EMAIL", "type": "esriFieldTypeString" }, { "modelName": "generation_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "generation_date", "length": 35, "alias": "GENERATION_DATE", "type": "esriFieldTypeString" }, { "modelName": "release_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "release_date", "length": 35, "alias": "RELEASE_DATE", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_1", "length": 100, "alias": "MULTIFAMILY_HOUSING_1", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_2", "length": 100, "alias": "MULTIFAMILY_HOUSING_2", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_3", "length": 100, "alias": "MULTIFAMILY_HOUSING_3", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_4", "length": 100, "alias": "MULTIFAMILY_HOUSING_4", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_5", "length": 100, "alias": "MULTIFAMILY_HOUSING_5", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_6", "length": 100, "alias": "MULTIFAMILY_HOUSING_6", "type": "esriFieldTypeString" }, { "modelName": "multifamily_housing_7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multifamily_housing_7", "length": 100, "alias": "MULTIFAMILY_HOUSING_7", "type": "esriFieldTypeString" }, { "modelName": "year_ending_date_only", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "year_ending_date_only", "length": 29, "alias": "YEAR_ENDING_DATE_ONLY", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "blank", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "blank", "length": 256, "alias": "BLANK", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g210buildingnum", "isUnique": false, "description": "", "fields": "buildingnum", "isAscending": true }, { "name": "r150_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_150", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "MasterTable_to_Address", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "MasterTable_Case", "relatedTableId": 3, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "MasterTable_to_Parcel", "relatedTableId": 2, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "MasterTable_CSR", "relatedTableId": 4, "id": 10, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "bld_id", "role": "esriRelRoleDestination", "composite": false, "name": "MasterTable_to_Building", "relatedTableId": 1, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "MasterTable", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "mapsheet": null, "tract": null, "mod": null, "code": null, "flag": null, "zone_class_1": null, "book": null, "cncl_dist": null, "lon": null, "lot": null, "arb": null, "tier": null, "pin": null, "map_ref": null, "eng_dist": null, "block": null, "pind": null, "lat": null, "height": null, "zone_class": null, "parcel": null, "bpp": null, "programclass": null, "elev": null, "bld_id": null, "page": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "MasterTable", "displayField": "bld_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID_12" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "bld_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bld_id", "length": 20, "alias": "BLD_ID", "type": "esriFieldTypeString" }, { "modelName": "pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 13, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "pind", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pind", "length": 14, "alias": "PIND", "type": "esriFieldTypeString" }, { "modelName": "bpp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bpp", "length": 10, "alias": "BPP", "type": "esriFieldTypeString" }, { "modelName": "book", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book", "length": 4, "alias": "BOOK", "type": "esriFieldTypeString" }, { "modelName": "page", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "page", "length": 3, "alias": "PAGE", "type": "esriFieldTypeString" }, { "modelName": "parcel", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel", "length": 3, "alias": "PARCEL", "type": "esriFieldTypeString" }, { "modelName": "mapsheet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mapsheet", "length": 9, "alias": "MAPSHEET", "type": "esriFieldTypeString" }, { "modelName": "map_ref", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "map_ref", "length": 30, "alias": "MAP_REF", "type": "esriFieldTypeString" }, { "modelName": "tract", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tract", "length": 255, "alias": "TRACT", "type": "esriFieldTypeString" }, { "modelName": "block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 6, "alias": "BLOCK", "type": "esriFieldTypeString" }, { "modelName": "mod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mod", "length": 25, "alias": "MOD", "type": "esriFieldTypeString" }, { "modelName": "lot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "length": 40, "alias": "LOT", "type": "esriFieldTypeString" }, { "modelName": "arb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "arb", "length": 3, "alias": "ARB", "type": "esriFieldTypeString" }, { "modelName": "eng_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eng_dist", "length": 2, "alias": "ENG_DIST", "type": "esriFieldTypeString" }, { "modelName": "cncl_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cncl_dist", "length": 5, "alias": "CNCL_DIST", "type": "esriFieldTypeString" }, { "modelName": "lon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" }, { "modelName": "lat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "modelName": "code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "code", "length": 50, "alias": "CODE", "type": "esriFieldTypeString" }, { "modelName": "height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "HEIGHT", "type": "esriFieldTypeDouble" }, { "modelName": "elev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elev", "alias": "ELEV", "type": "esriFieldTypeDouble" }, { "modelName": "flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flag", "length": 50, "alias": "FLAG", "type": "esriFieldTypeString" }, { "modelName": "programclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "programclass", "length": 200, "alias": "PROGRAMCLASS", "type": "esriFieldTypeString" }, { "modelName": "tier", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tier", "alias": "TIER", "type": "esriFieldTypeSmallInteger" }, { "modelName": "zone_class", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone_class", "length": 75, "alias": "ZONE_CLASS", "type": "esriFieldTypeString" }, { "modelName": "zone_class_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone_class_1", "length": 75, "alias": "ZONE_CLASS", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g211bld_id", "isUnique": false, "description": "", "fields": "bld_id", "isAscending": true }, { "name": "g211pin", "isUnique": false, "description": "", "fields": "pin", "isAscending": true }, { "name": "r151_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_151", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 1715498.9961163104, "xmin": 6359687.901239052, "ymax": 1.862122868262081E7, "xmax": 6514562.446148142, "spatialReference": { "falseM": -100000, "xyTolerance": 6.561666666666666E-4, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2229, "zTolerance": 0.001, "wkid": 102645, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Address_Permits", "relatedTableId": 5, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "Address_to_Parcel", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleDestination", "composite": false, "name": "Address_to_MasterTable", "relatedTableId": 7, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Atlas_Address", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "str_sfx_dir_cd": null, "str_sfx_cd": null, "crtn_dt": null, "hse_dir_cd": null, "sys_user_id": null, "cncl_dist": null, "lon": null, "asgn_stts_ind": null, "y_coord_nbr": null, "exist_stts_cd": null, "pin": null, "zip_cd": null, "lst_modf_dt": null, "unit_range": null, "x_coord_nbr": null, "eng_dist": null, "hse_nbr": null, "hse_frac_nbr": null, "str_nm": null, "pind": null, "hse_id": null, "lat": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_Address", "allowTrueCurvesUpdates": false, "displayField": "pin", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "HSE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hse_id", "alias": "HSE_ID", "type": "esriFieldTypeInteger" }, { "modelName": "PIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 13, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "HSE_NBR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hse_nbr", "alias": "HSE_NBR", "type": "esriFieldTypeInteger" }, { "modelName": "HSE_FRAC_NBR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hse_frac_nbr", "length": 5, "alias": "HSE_FRAC_NBR", "type": "esriFieldTypeString" }, { "modelName": "HSE_DIR_CD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hse_dir_cd", "length": 2, "alias": "HSE_DIR_CD", "type": "esriFieldTypeString" }, { "modelName": "STR_NM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "str_nm", "length": 40, "alias": "STR_NM", "type": "esriFieldTypeString" }, { "modelName": "STR_SFX_CD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "str_sfx_cd", "length": 4, "alias": "STR_SFX_CD", "type": "esriFieldTypeString" }, { "modelName": "STR_SFX_DIR_CD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "str_sfx_dir_cd", "length": 5, "alias": "STR_SFX_DIR_CD", "type": "esriFieldTypeString" }, { "modelName": "UNIT_RANGE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_range", "length": 7, "alias": "UNIT_RANGE", "type": "esriFieldTypeString" }, { "modelName": "ZIP_CD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip_cd", "alias": "ZIP_CD", "type": "esriFieldTypeInteger" }, { "modelName": "X_COORD_NBR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x_coord_nbr", "alias": "X_COORD_NBR", "type": "esriFieldTypeDouble" }, { "modelName": "Y_COORD_NBR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y_coord_nbr", "alias": "Y_COORD_NBR", "type": "esriFieldTypeDouble" }, { "modelName": "ASGN_STTS_IND", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "asgn_stts_ind", "length": 1, "alias": "ASGN_STTS_IND", "type": "esriFieldTypeString" }, { "modelName": "ENG_DIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eng_dist", "length": 2, "alias": "ENG_DIST", "type": "esriFieldTypeString" }, { "modelName": "CNCL_DIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cncl_dist", "length": 5, "alias": "CNCL_DIST", "type": "esriFieldTypeString" }, { "modelName": "CRTN_DT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "crtn_dt", "length": 29, "alias": "CRTN_DT", "type": "esriFieldTypeDate" }, { "modelName": "LST_MODF_DT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lst_modf_dt", "length": 29, "alias": "LST_MODF_DT", "type": "esriFieldTypeDate" }, { "modelName": "SYS_USER_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sys_user_id", "length": 8, "alias": "SYS_USER_ID", "type": "esriFieldTypeString" }, { "modelName": "EXIST_STTS_CD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exist_stts_cd", "length": 1, "alias": "EXIST_STTS_CD", "type": "esriFieldTypeString" }, { "modelName": "LON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" }, { "modelName": "LAT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "modelName": "PIND", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pind", "length": 14, "alias": "PIND", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g204pin", "isUnique": false, "description": "", "fields": "pin", "isAscending": true }, { "name": "r144_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a94_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 34, 137, 104, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 1715123.1090728045, "xmin": 6359604.843334302, "ymax": 1945502.201135233, "xmax": 6514567.533408299, "spatialReference": { "falseM": -100000, "xyTolerance": 6.561666666666666E-4, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2229, "zTolerance": 0.001, "wkid": 102645, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "bld_id", "role": "esriRelRoleOrigin", "composite": false, "name": "Building_to_MasterTable", "relatedTableId": 7, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "bld_id", "role": "esriRelRoleOrigin", "composite": false, "name": "Building_to_BenchMark", "relatedTableId": 6, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Atlas_Buildings", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "old_bld_id": null, "area": null, "code": null, "elev": null, "bld_id": null, "source": null, "date_": null, "height": null, "status": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_Buildings", "allowTrueCurvesUpdates": false, "displayField": "code", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "CODE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "code", "length": 50, "alias": "CODE", "type": "esriFieldTypeString" }, { "modelName": "BLD_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bld_id", "length": 20, "alias": "BLD_ID", "type": "esriFieldTypeString" }, { "modelName": "HEIGHT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "HEIGHT", "type": "esriFieldTypeDouble" }, { "modelName": "ELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elev", "alias": "ELEV", "type": "esriFieldTypeDouble" }, { "modelName": "SOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 25, "alias": "SOURCE", "type": "esriFieldTypeString" }, { "modelName": "DATE_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_", "length": 4, "alias": "DATE_", "type": "esriFieldTypeString" }, { "modelName": "STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 50, "alias": "STATUS", "type": "esriFieldTypeString" }, { "modelName": "OLD_BLD_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "old_bld_id", "length": 20, "alias": "OLD_BLD_ID", "type": "esriFieldTypeString" }, { "modelName": "area", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "area", "alias": "area", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g205bld_id", "isUnique": false, "description": "", "fields": "bld_id", "isAscending": true }, { "name": "r145_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a95_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 252, 222, 199, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 1715118.927322641, "xmin": 6358870.505892217, "ymax": 1947324.7998522222, "xmax": 6516789.6762737185, "spatialReference": { "falseM": -100000, "xyTolerance": 6.561666666666666E-4, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2229, "zTolerance": 0.001, "wkid": 102645, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Parcel_CSR", "relatedTableId": 4, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Parcel_to_Address", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Parcel_to_MasterTable", "relatedTableId": 7, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Parcel_Cases", "relatedTableId": 3, "id": 7, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "pin", "role": "esriRelRoleOrigin", "composite": false, "name": "Parcel_Permits", "relatedTableId": 5, "id": 8, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Atlas_Parcel", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "crtn_dt": null, "parcel": null, "mapsheet": null, "bpp": null, "tract": null, "mod": null, "book": null, "cncl_dist": null, "lon": null, "lot": null, "arb": null, "map_ref": null, "pin": null, "lst_modf_dt": null, "user_id": null, "assetid": null, "eng_dist": null, "block": null, "id": null, "pind": null, "page": null, "lat": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Atlas_Parcel", "allowTrueCurvesUpdates": false, "displayField": "mapsheet", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "ASSETID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid", "alias": "ASSETID", "type": "esriFieldTypeDouble" }, { "modelName": "MAPSHEET", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mapsheet", "length": 9, "alias": "MAPSHEET", "type": "esriFieldTypeString" }, { "modelName": "ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id", "alias": "ID", "type": "esriFieldTypeSmallInteger" }, { "modelName": "BPP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bpp", "length": 10, "alias": "BPP", "type": "esriFieldTypeString" }, { "modelName": "MAP_REF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "map_ref", "length": 30, "alias": "MAP_REF", "type": "esriFieldTypeString" }, { "modelName": "TRACT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tract", "length": 255, "alias": "TRACT", "type": "esriFieldTypeString" }, { "modelName": "BLOCK", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 6, "alias": "BLOCK", "type": "esriFieldTypeString" }, { "modelName": "MOD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mod", "length": 25, "alias": "MOD", "type": "esriFieldTypeString" }, { "modelName": "LOT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "length": 40, "alias": "LOT", "type": "esriFieldTypeString" }, { "modelName": "ARB", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "arb", "length": 3, "alias": "ARB", "type": "esriFieldTypeString" }, { "modelName": "PIND", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pind", "length": 14, "alias": "PIND", "type": "esriFieldTypeString" }, { "modelName": "PIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 13, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "BOOK", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book", "length": 4, "alias": "BOOK", "type": "esriFieldTypeString" }, { "modelName": "PAGE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "page", "length": 3, "alias": "PAGE", "type": "esriFieldTypeString" }, { "modelName": "PARCEL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel", "length": 3, "alias": "PARCEL", "type": "esriFieldTypeString" }, { "modelName": "ENG_DIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eng_dist", "length": 2, "alias": "ENG_DIST", "type": "esriFieldTypeString" }, { "modelName": "CNCL_DIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cncl_dist", "length": 5, "alias": "CNCL_DIST", "type": "esriFieldTypeString" }, { "modelName": "LST_MODF_DT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lst_modf_dt", "length": 29, "alias": "LST_MODF_DT", "type": "esriFieldTypeDate" }, { "modelName": "CRTN_DT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "crtn_dt", "length": 29, "alias": "CRTN_DT", "type": "esriFieldTypeDate" }, { "modelName": "USER_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "user_id", "length": 8, "alias": "USER_ID", "type": "esriFieldTypeString" }, { "modelName": "LON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lon", "alias": "LON", "type": "esriFieldTypeDouble" }, { "modelName": "LAT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat", "alias": "LAT", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "This layer represents current city parcels within the City of Los Angeles. It shares topology with the Landbase parcel lines feature class. The Mapping and Land Records Division of the Bureau of Engineering, Department of Public Works provides the most current geographic information of the public right of way, ownership and land record information. The legal boundaries are determined on the ground by license surveyors in the State of California, and by recorded documents from the Los Angeles County Recorder's office and the City Clerk's office of the City of Los Angeles. Parcel and ownership information are available on NavigateLA, a website hosted by the Bureau of Engineering, Department of Public Works.Associated information about the landbase parcels is entered into attributes. Principal attributes include:PIN and PIND: represents the unique auto-generated parcel identifier and key to related features and tables. This field is related to the LA_LEGAL, LA_APN and LA_HSE_NBR tables. PIN contains spaces and PIND replaces those spaces with a dash (-).LA_LEGAL - Table attributes containing legal description. Principal attributes include the following:TRACT: The subdivision tract number as recorded by the County of Los AngelesMAP_REF: Identifies the subdivision map book reference as recorded by the County of Los Angeles.LOT: The subdivision lot number as recorded by the County of Los Angeles.ENG_DIST: The four engineering Districts (W=Westla, C=Central, V= Valley and H=Harbor).CNCL_DIST: Council Districts 1-15 of the City of Los Angeles. OUTLA means parcel is outside the City.LA_APN- Table attributes containing County of Los Angeles Assessors information. Principal attributes include the following:BPP: The Book, Page and Parcel from the Los Angeles County Assessors office. SITUS*: Address for the property.LA_HSE_NBR - Table attributes containing housenumber information. Principal attributes include the following:HSE_ID: Unique id of each housenumber record.HSE_NBR: housenumber numerical valueSTR_*: Official housenumber addressFor a complete list of attribute values, please refer to Landbase_parcel_polygons_data_dictionary. ", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g206pin", "isUnique": false, "description": "", "fields": "pin", "isAscending": true }, { "name": "r146_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a96_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f0af91c8b9db46bba4db0c447304956a", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 220, 196, 252, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "Randy Price\nDivision Manager\nMapping and Land Records Division\nBureau of Engineering / Department of Public Works\nCity of Los Angeles", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }