{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Addresses", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 5000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "DateCreated", "creatorField": "CreationUser", "editDateField": "DateModified", "editorField": "LastUser", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "SubAddresses", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{38840892-2156-44B7-AC97-D156BA92D5B1}" }, { "id": 1, "name": "RoadNames", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RoadNameGlobalID", "composite": false, "catalogID": "{EC9F4265-8460-45EB-9686-EBE9E2D9F68B}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1699553064000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1615661.0806884766, "ymin": 596464.0335083008, "xmax": 1646320.2324829102, "ymax": 625935.1533203125, "spatialReference": { "wkid": 102749, "latestWkid": 2286, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 3.780131583918991E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102749, "latestWkid": 2286, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Status", "uniqueValueGroups": [ { "heading": "", "classes": [ { "label": "Active", "description": "Active", "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Active" ] ] }, { "label": "Reserved", "description": "Reserved", "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Reserved" ] ] }, { "label": "Retired", "description": "Retired", "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Retired" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Active", "label": "Active" }, { "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Reserved", "label": "Reserved" }, { "symbol": { "type": "esriPMS", "url": "764da11df3d6f7b1c95c7043ff514387", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAE0lEQVQYlWNhIBKwjCrEB6gfPAAk1gApgIHhIQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 7, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Retired", "label": "Retired" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 156, 155, 212, 255 ], "toColor": [ 156, 155, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 155, 212, 160, 255 ], "toColor": [ 155, 212, 160, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 201, 153, 143, 255 ], "toColor": [ 201, 153, 143, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 149, 194, 201, 255 ], "toColor": [ 149, 194, 201, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 189, 149, 255 ], "toColor": [ 196, 189, 149, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 214, 176, 203, 255 ], "toColor": [ 214, 176, 203, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 140, 194, 255 ], "toColor": [ 187, 140, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 167, 196, 176, 255 ], "toColor": [ 167, 196, 176, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 178, 185, 214, 255 ], "toColor": [ 178, 185, 214, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 147, 164, 255 ], "toColor": [ 204, 147, 164, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 182, 176, 255 ], "toColor": [ 212, 182, 176, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 165, 191, 142, 255 ], "toColor": [ 165, 191, 142, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 143, 157, 196, 255 ], "toColor": [ 143, 157, 196, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.Address", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementCenterCenter", "deconflictionStrategy": "static", "removeDuplicates": "none", "stackLabel": false, "where": "Status = 'Active'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Active", "priority": -1, "symbol": { "type": "esriTS", "color": [ 56, 168, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 127 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } } }, { "labelExpressionInfo": {"expression": "$feature.Address"}, "labelPlacement": "esriServerPointLabelPlacementCenterCenter", "deconflictionStrategy": "static", "removeDuplicates": "none", "stackLabel": false, "where": "Status = 'Reserved'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Reserved", "priority": -1, "symbol": { "type": "esriTS", "color": [ 255, 127, 127, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 127 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } } }, { "labelExpressionInfo": {"expression": "$feature.Address"}, "labelPlacement": "esriServerPointLabelPlacementCenterCenter", "deconflictionStrategy": "static", "removeDuplicates": "none", "stackLabel": false, "where": "Status = 'Retired'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Retired", "priority": -1, "symbol": { "type": "esriTS", "color": [ 204, 190, 173, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 127 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Address", "typeIdField": "Status", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AddressNumber", "type": "esriFieldTypeInteger", "alias": "AddressNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AddressNumber" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "City" }, { "name": "CityCode", "type": "esriFieldTypeString", "alias": "CityCode", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "CityCode" }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Zip" }, { "name": "Zip4", "type": "esriFieldTypeString", "alias": "Zip4", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Zip4" }, { "name": "FullRoadName", "type": "esriFieldTypeString", "alias": "Full Road Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FullRoadName" }, { "name": "LocationName", "type": "esriFieldTypeString", "alias": "LocationName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LocationName" }, { "name": "AltLocationName", "type": "esriFieldTypeString", "alias": "AltLocationName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AltLocationName" }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "FacilityType", "type": "esriFieldTypeString", "alias": "FacilityType", "domain": { "type": "codedValue", "name": "AE_FacilityType2", "description": "", "codedValues": [ { "name": "Commercial", "code": "Commercial" }, { "name": "Multi-family", "code": "Multi-family" }, { "name": "Residential", "code": "Residential" }, { "name": "Public", "code": "Public" }, { "name": "Vacant", "code": "Vacant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "FacilityType" }, { "name": "LocationMethod", "type": "esriFieldTypeString", "alias": "LocationMethod", "domain": { "type": "codedValue", "name": "AE_LocationMethod", "description": "Method of establishing coordinates for address and subaddress points.", "codedValues": [ { "name": "GPS", "code": "GPS" }, { "name": "Aerial", "code": "Aerial" }, { "name": "Geocoding", "code": "Geocoding" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LocationMethod" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "AE_AddressStatus", "description": "Status of address point.", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Reserved", "code": "Reserved" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Status" }, { "name": "RoadNameGlobalID", "type": "esriFieldTypeGUID", "alias": "RoadNameGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "StreetNameID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AddressNumberSuffix", "type": "esriFieldTypeString", "alias": "AddressNumberSuffix", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AddressNumberSuffix" }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "Address", "type": "esriFieldTypeSingle", "alias": "Address", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Address" }, { "name": "GasService", "type": "esriFieldTypeString", "alias": "Gas Service Url", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "GasService" }, { "name": "CreationUser", "type": "esriFieldTypeString", "alias": "CreationUser", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CreationUser", "required": true }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateCreated", "required": true }, { "name": "LastUser", "type": "esriFieldTypeString", "alias": "LastUser", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LastUser", "required": true }, { "name": "DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateModified", "required": true } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "UUID_1677", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2878RoadNameGlo", "fields": "RoadNameGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1677_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1236_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "types": [ { "id": "Active", "name": "Active", "domains": { "FacilityType": {"type": "inherited"}, "LocationMethod": {"type": "inherited"}, "Status": {"type": "inherited"}, "Enabled": {"type": "inherited"} }, "templates": [ { "name": "Active", "description": "", "prototype": { "attributes": { "Address": null, "GasService": null, "AddressNumber": null, "City": null, "CityCode": null, "Zip": null, "Zip4": null, "FullRoadName": null, "LocationName": null, "AltLocationName": null, "ParcelNumber": null, "FacilityType": null, "LocationMethod": null, "Status": "Active", "RoadNameGlobalID": null, "Enabled": 1, "AddressNumberSuffix": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "Reserved", "name": "Reserved", "domains": { "FacilityType": {"type": "inherited"}, "LocationMethod": {"type": "inherited"}, "Status": {"type": "inherited"}, "Enabled": {"type": "inherited"} }, "templates": [ { "name": "Reserved", "description": "", "prototype": { "attributes": { "Address": null, "GasService": null, "AddressNumber": null, "City": null, "CityCode": null, "Zip": null, "Zip4": null, "FullRoadName": null, "LocationName": null, "AltLocationName": null, "ParcelNumber": null, "FacilityType": null, "LocationMethod": null, "Status": "Reserved", "RoadNameGlobalID": null, "Enabled": 1, "AddressNumberSuffix": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "Retired", "name": "Retired", "domains": { "FacilityType": {"type": "inherited"}, "LocationMethod": {"type": "inherited"}, "Status": {"type": "inherited"}, "Enabled": {"type": "inherited"} }, "templates": [ { "name": "Retired", "description": "", "prototype": { "attributes": { "Address": null, "GasService": null, "AddressNumber": null, "City": null, "CityCode": null, "Zip": null, "Zip4": null, "FullRoadName": null, "LocationName": null, "AltLocationName": null, "ParcelNumber": null, "FacilityType": null, "LocationMethod": null, "Status": "Retired", "RoadNameGlobalID": null, "Enabled": 1, "AddressNumberSuffix": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "userTypeExtensions": [ "advancedEditing" ], "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "b7a588c903264cdba6fe97c5677f40d7" }