{ "tables": [], "layers": [ { "extent": { "ymin": 5312853.829070105, "xmin": 472085.3299769669, "ymax": 5380462.268572995, "xmax": 540157.0872168053, "spatialReference": {"wkid": 26914} }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "relationships": null, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Site Addresses", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "esn": null, "addrnum": null, "unittype": null, "addrrange": null, "altunittype": null, "pointtype": null, "psap": null, "addrclass": null, "municipality": null, "addrnumsuf": null, "placename": null, "altunitid": null, "capturemeth": null, "unitid": null, "preaddrnum": null, "fulladdr": null, "fullname": null, "usngcoord": null, "addptkey": null, "siteaddid": null, "msag": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Site Addresses", "displayField": "fullname", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "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_AddressUnitType_2", "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_AddressUnitType_2", "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_SiteAddressClass_1", "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_SiteAddressLocation_1", "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_PointCollectionMethod_1", "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_AddressStatus_1", "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, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Site Address Points", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "G307ADDPTKEY", "isUnique": false, "description": "", "fields": "ADDPTKEY", "isAscending": true }, { "name": "G307SITEADDID", "isUnique": false, "description": "", "fields": "SITEADDID", "isAscending": true }, { "name": "PK__SiteAddr__F4B70D853BBB469D", "isUnique": true, "description": "clustered, unique, primary key", "fields": "OBJECTID", "isAscending": true }, { "name": "CreationDateIndex", "isUnique": false, "description": "CreationDate Field index", "fields": "CreationDate", "isAscending": true }, { "name": "CreatorIndex", "isUnique": false, "description": "Creator Field index", "fields": "Creator", "isAscending": false }, { "name": "EditDateIndex", "isUnique": false, "description": "EditDate Field index", "fields": "EditDate", "isAscending": true }, { "name": "EditorIndex", "isUnique": false, "description": "Editor Field index", "fields": "Editor", "isAscending": false } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "f2fd7d8d28f54319a9e0f812c59f1274", "supportsValidateSql": true, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "maxScale": 0, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 255, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 153, 153, 153, 255 ], "size": 1.5, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "", "label": "", "type": "simple" }, "transparency": 0 }, "copyrightText": "", "geometryType": "esriGeometryPoint" } ] }