{ "tables": [ { "extent": { "ymin": 4717804.791844514, "xmin": -8641509.431299949, "ymax": 4767900.826912176, "xmax": -8552008.560702158, "spatialReference": {"wkid": 102100} }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "siteaddkey", "role": "esriRelRoleDestination", "composite": false, "name": "SiteAddresses", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Postal Addresses", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "ownernm2": null, "country": null, "pstlzip5": null, "pstlzip4": null, "pstlcity": null, "intpstlcd": null, "siteaddkey": null, "intstate": null, "uspsboxgrp": null, "pstlstate": null, "pstladdid": null, "uspsboxid": null, "pstladdress": null, "uspsboxtype": null, "ownernm1": null, "represent": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "Postal Addresses", "displayField": "pstladdid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstladdid", "length": 20, "alias": "Postal Address Identifier", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteaddkey", "length": 20, "alias": "Site Address ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownernm1", "length": 150, "alias": "Owner Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownernm2", "length": 150, "alias": "Owner Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstladdress", "length": 250, "alias": "Postal Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstlcity", "length": 100, "alias": "Postal City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstlstate", "length": 2, "alias": "Postal State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstlzip5", "length": 5, "alias": "Postal Zip 5", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pstlzip4", "length": 4, "alias": "Postal Zip +4", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "intstate", "length": 5, "alias": "International State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "intpstlcd", "length": 10, "alias": "International Postal Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "country", "length": 100, "alias": "Country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uspsboxtype", "length": 10, "alias": "USPS Box Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uspsboxid", "length": 25, "alias": "USPS Box Identifier", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uspsboxgrp", "length": 50, "alias": "USPS Box Group", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "represent", "length": 30, "alias": "Owner / Occupant", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 30, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "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": "r478_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "exceedsLimitFactor": 1, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSql": true, "serviceItemId": "6a3f292b996541dea7484b908307da2d", "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "uniqueIdField": { "isSystemMaintained": true, "name": "objectid" }, "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": 4717804.791844514, "xmin": -8641509.431299949, "ymax": 4767900.826912176, "xmax": -8552008.560702158, "spatialReference": {"wkid": 102100} }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "siteaddid", "role": "esriRelRoleOrigin", "composite": false, "name": "EntrancePoints", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "siteaddid", "role": "esriRelRoleOrigin", "composite": false, "name": "PostalAddresses", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Site Addresses", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "esn": null, "addrnum": null, "addrrange": null, "unittype": null, "altunittype": null, "pointtype": null, "psap": null, "addrclass": null, "municipality": null, "addrnumsuf": null, "placename": null, "altunitid": null, "capturemeth": null, "unitid": null, "preaddrnum": null, "fullname": null, "fulladdr": null, "usngcoord": null, "addptkey": null, "siteaddid": null, "status": null, "msag": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "Site Addresses", "displayField": "fullname", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteaddid", "length": 20, "alias": "Site Address ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addptkey", "length": 20, "alias": "Address Point ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preaddrnum", "length": 5, "alias": "Address Number Prefix", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addrnumsuf", "length": 5, "alias": "Address Number Suffix", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addrnum", "length": 20, "alias": "Full Address Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addrrange", "length": 50, "alias": "Address Range", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_AddressUnitType", "type": "codedValue", "codedValues": [ { "code": "APT", "name": "Apartment" }, { "code": "BSMT", "name": "Basement" }, { "code": "BLDG", "name": "Building" }, { "code": "DEPT", "name": "Department" }, { "code": "FL", "name": "Floor" }, { "code": "FRNT", "name": "Front" }, { "code": "HNGR", "name": "Hanger" }, { "code": "KEY", "name": "Key" }, { "code": "LBBY", "name": "Lobby" }, { "code": "LOT", "name": "Lot" }, { "code": "LOWR", "name": "Lower" }, { "code": "OFC", "name": "Office" }, { "code": "PH", "name": "Penthouse" }, { "code": "PIER", "name": "Pier" }, { "code": "REAR", "name": "Rear" }, { "code": "RM", "name": "Room" }, { "code": "SIDE", "name": "Side" }, { "code": "SLIP", "name": "Slip" }, { "code": "SPC", "name": "Space" }, { "code": "STOP", "name": "Stop" }, { "code": "STE", "name": "Suite" }, { "code": "TRLR", "name": "Trailer" }, { "code": "UNIT", "name": "Unit" }, { "code": "UPPR", "name": "Upper" }, { "code": "Other", "name": "Other" } ] }, "name": "unittype", "length": 10, "alias": "Address Unit Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitid", "length": 10, "alias": "Address Unit Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_AddressUnitType", "type": "codedValue", "codedValues": [ { "code": "APT", "name": "Apartment" }, { "code": "BSMT", "name": "Basement" }, { "code": "BLDG", "name": "Building" }, { "code": "DEPT", "name": "Department" }, { "code": "FL", "name": "Floor" }, { "code": "FRNT", "name": "Front" }, { "code": "HNGR", "name": "Hanger" }, { "code": "KEY", "name": "Key" }, { "code": "LBBY", "name": "Lobby" }, { "code": "LOT", "name": "Lot" }, { "code": "LOWR", "name": "Lower" }, { "code": "OFC", "name": "Office" }, { "code": "PH", "name": "Penthouse" }, { "code": "PIER", "name": "Pier" }, { "code": "REAR", "name": "Rear" }, { "code": "RM", "name": "Room" }, { "code": "SIDE", "name": "Side" }, { "code": "SLIP", "name": "Slip" }, { "code": "SPC", "name": "Space" }, { "code": "STOP", "name": "Stop" }, { "code": "STE", "name": "Suite" }, { "code": "TRLR", "name": "Trailer" }, { "code": "UNIT", "name": "Unit" }, { "code": "UPPR", "name": "Upper" }, { "code": "Other", "name": "Other" } ] }, "name": "altunittype", "length": 10, "alias": "Alternate Address Unit Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altunitid", "length": 10, "alias": "Alternate Address Unit Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fullname", "length": 125, "alias": "Full Road Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fulladdr", "length": 250, "alias": "Full Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "placename", "length": 250, "alias": "Place Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "municipality", "length": 100, "alias": "Municipality Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esn", "length": 5, "alias": "Emergency Service Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "psap", "length": 4, "alias": "Public Safety Answering Point", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "msag", "length": 35, "alias": "MSAG Community", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usngcoord", "length": 50, "alias": "USNG Coordinate", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_SiteAddressClass", "type": "codedValue", "codedValues": [ { "code": 701, "name": "Agriculture, Food, and Livestock" }, { "code": 710, "name": "Industry" }, { "code": 720, "name": "Commercial and Retail" }, { "code": 730, "name": "Education" }, { "code": 740, "name": "Emergency Response and Law Enforcement" }, { "code": 750, "name": "Energy" }, { "code": 760, "name": "Banking and Finance" }, { "code": 780, "name": "Mail and Shipping" }, { "code": 790, "name": "Building General" }, { "code": 800, "name": "Health and Medical" }, { "code": 820, "name": "Public Attractions and Landmark Buildings" }, { "code": 830, "name": "Government and Military" }, { "code": 840, "name": "Weather" }, { "code": 850, "name": "Water Supply and Treatment" }, { "code": 880, "name": "Information and Communication" }, { "code": 810, "name": "Transportation Facilities" } ] }, "name": "addrclass", "alias": "Description", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_SiteAddressLocation", "type": "codedValue", "codedValues": [ { "code": "Building", "name": "Building" }, { "code": "Parcel", "name": "Parcel" }, { "code": "Unit, Condo, Office or Suite", "name": "Unit, Condo, Office or Suite" }, { "code": "Utility Asset", "name": "Utility Asset" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ] }, "name": "pointtype", "length": 30, "alias": "Location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_PointCollectionMethod", "type": "codedValue", "codedValues": [ { "code": "Geocoded", "name": "Geocoded" }, { "code": "GPS", "name": "GPS" }, { "code": "Site Visit", "name": "Site Visit" }, { "code": "Placed on Map", "name": "Placed on Map" }, { "code": "Other", "name": "Other" } ] }, "name": "capturemeth", "length": 30, "alias": "Capture Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_AddressStatus", "type": "codedValue", "codedValues": [ { "code": "Current", "name": "Current" }, { "code": "Pending", "name": "Pending" }, { "code": "Retired", "name": "Retired" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Other", "name": "Other" } ] }, "name": "status", "length": 30, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 128, "alias": "Editor", "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, "standardMaxRecordCountNoGeometry": 16000, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r475_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a371_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "exceedsLimitFactor": 1, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "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 }, "supportsValidateSql": true, "serviceItemId": "6a3f292b996541dea7484b908307da2d", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "uniqueIdField": { "isSystemMaintained": true, "name": "objectid" }, "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": [ 61, 153, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "extent": { "ymin": 4717804.791844514, "xmin": -8641509.431299949, "ymax": 4767900.826912176, "xmax": -8552008.560702158, "spatialReference": {"wkid": 102100} }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "siteaddkey", "role": "esriRelRoleDestination", "composite": false, "name": "SiteAddresses", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Entrance Points", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "capturemeth": null, "pointtype": null, "siteaddkey": null, "entranceptid": null, "restaccess": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "Entrance Points", "displayField": "entranceptid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "entranceptid", "length": 20, "alias": "Entrance ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteaddkey", "length": 20, "alias": "Site Address ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_AddressPointType", "type": "codedValue", "codedValues": [ { "code": "Driveway Entrance", "name": "Driveway Entrance" }, { "code": "Building Entrance", "name": "Building Entrance" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ] }, "name": "pointtype", "length": 30, "alias": "Address Point Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_PointCollectionMethod", "type": "codedValue", "codedValues": [ { "code": "Geocoded", "name": "Geocoded" }, { "code": "GPS", "name": "GPS" }, { "code": "Site Visit", "name": "Site Visit" }, { "code": "Placed on Map", "name": "Placed on Map" }, { "code": "Other", "name": "Other" } ] }, "name": "capturemeth", "length": 30, "alias": "Capture Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "SiteAddresses_938befdc98614779baccd7949f48d00e_YesNo", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "restaccess", "length": 5, "alias": "Restricted Access", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 128, "alias": "Editor", "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, "standardMaxRecordCountNoGeometry": 16000, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r477_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a373_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "exceedsLimitFactor": 1, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "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 }, "supportsValidateSql": true, "serviceItemId": "6a3f292b996541dea7484b908307da2d", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "uniqueIdField": { "isSystemMaintained": true, "name": "objectid" }, "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": [ 130, 71, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }