{ "currentVersion" : 12, "id" : 1, "name" : "Planned Addresses", "type" : "Feature Layer", "serviceItemId" : "5c5187a826c043a0a64f75b2a0bae56c", "cacheMaxAge" : 30, "displayField" : "street_name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "created_date", "creatorField" : "created_user", "editDateField" : "last_edited_date", "editorField" : "last_edited_user" }, "editingInfo" : { "lastEditDate" : 1727811974552, "schemaLastEditDate" : 1727811974552, "dataLastEditDate" : 1727811974552 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 2400, "maxScale" : 0, "extent" : { "xmin" : 636410.872520946, "ymin" : 727604.07307583094, "xmax" : 878836.93414472044, "ymax" : 759489.80187353492, "spatialReference" : { "wkt" : "PROJCS[\"NAD_1983_StatePlane_Arizona_Central_FIPS_0202_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",700000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-111.9166666666667],PARAMETER[\"Scale_Factor\",0.9999],PARAMETER[\"Latitude_Of_Origin\",31.0],UNIT[\"Foot\",0.3048]]", "wkt2" : "PROJCS[\"NAD_1983_StatePlane_Arizona_Central_FIPS_0202_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",700000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-111.9166666666667],PARAMETER[\"Scale_Factor\",0.9999],PARAMETER[\"Latitude_Of_Origin\",31.0],UNIT[\"Foot\",0.3048]]" } }, "spatialReference" : { "wkt" : "PROJCS[\"NAD_1983_StatePlane_Arizona_Central_FIPS_0202_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",700000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-111.9166666666667],PARAMETER[\"Scale_Factor\",0.9999],PARAMETER[\"Latitude_Of_Origin\",31.0],UNIT[\"Foot\",0.3048]]", "wkt2" : "PROJCS[\"NAD_1983_StatePlane_Arizona_Central_FIPS_0202_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",700000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-111.9166666666667],PARAMETER[\"Scale_Factor\",0.9999],PARAMETER[\"Latitude_Of_Origin\",31.0],UNIT[\"Foot\",0.3048]]", "xyTolerance" : 0.0032808398950131233, "zTolerance" : 0.001, "mTolerance" : 0.001, "falseX" : -17746700, "falseY" : -44067300, "xyUnits" : 3048, "falseZ" : -100000, "zUnits" : 10000, "falseM" : -100000, "mUnits" : 10000 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[225,225,225,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.75}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[full_address]","labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"label_class = 'Primary'","useCodedValues":true,"maxScale":200,"minScale":600,"name":"primary 200-600","priority":-1,"symbol":{"type":"esriTS","color":[225,225,225,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[78,78,78,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.building_identifier","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":false,"removeDuplicates":"none","where":"label_class = 'Building Identifier'","useCodedValues":true,"maxScale":200,"minScale":1200,"name":"building_identifier","priority":-1,"symbol":{"type":"esriTS","color":[225,225,225,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[78,78,78,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.building_name"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"building_name IS NOT NULL","useCodedValues":true,"maxScale":200,"minScale":600,"name":"building_name","priority":-1,"symbol":{"type":"esriTS","color":[225,225,225,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[78,78,78,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.unit"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":false,"removeDuplicates":"none","where":"label_class = 'Unit' And floor = '1' Or floor IS NULL","useCodedValues":true,"maxScale":200,"minScale":600,"name":"unit","priority":-1,"symbol":{"type":"esriTS","color":[225,225,225,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[78,78,78,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.address_number"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"label_class = 'Primary'","useCodedValues":true,"maxScale":600,"minScale":1200,"name":"primary 600-1200","priority":-1,"symbol":{"type":"esriTS","color":[225,225,225,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[78,78,78,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.room_name + TextFormatting.NewLine + $feature.room_number","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":false,"removeDuplicates":"none","where":"label_class = 'Room' And floor = '1' Or floor IS NULL","useCodedValues":true,"maxScale":0,"minScale":200,"name":"room","priority":-1,"symbol":{"type":"esriTS","color":[255,235,190,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "address_id", "type" : "esriFieldTypeInteger", "alias" : "Address ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "address_number", "type" : "esriFieldTypeInteger", "alias" : "Address Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "street_pre_directional", "type" : "esriFieldTypeString", "alias" : "Street Pre Directional", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "directionals", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "USPS abbreviated directionals for addressing.", "codedValues" : [ { "name" : "N", "code" : "N" }, { "name" : "S", "code" : "S" }, { "name" : "E", "code" : "E" }, { "name" : "W", "code" : "W" } ] }, "defaultValue" : null }, { "name" : "street_pre_type", "type" : "esriFieldTypeString", "alias" : "Street Pre Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "street_name", "type" : "esriFieldTypeString", "alias" : "Street Name", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "street_post_type", "type" : "esriFieldTypeString", "alias" : "Street Post Type", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "street_suffix", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "USPS abbreviated street suffixes.", "codedValues" : [ { "name" : "ALY", "code" : "ALY" }, { "name" : "AVE", "code" : "AVE" }, { "name" : "BEND", "code" : "BEND" }, { "name" : "BLVD", "code" : "BLVD" }, { "name" : "CIR", "code" : "CIR" }, { "name" : "CT", "code" : "CT" }, { "name" : "DR", "code" : "DR" }, { "name" : "HWY", "code" : "HWY" }, { "name" : "LN", "code" : "LN" }, { "name" : "LOOP", "code" : "LOOP" }, { "name" : "PASS", "code" : "PASS" }, { "name" : "PATH", "code" : "PATH" }, { "name" : "PKWY", "code" : "PKWY" }, { "name" : "PL", "code" : "PL" }, { "name" : "PLZ", "code" : "PLZ" }, { "name" : "RD", "code" : "RD" }, { "name" : "RUN", "code" : "RUN" }, { "name" : "ST", "code" : "ST" }, { "name" : "TER", "code" : "TER" }, { "name" : "TRCE", "code" : "TRCE" }, { "name" : "TRL", "code" : "TRL" }, { "name" : "WAY", "code" : "WAY" } ] }, "defaultValue" : null }, { "name" : "street_post_directional", "type" : "esriFieldTypeString", "alias" : "Street Post Directional", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "directionals", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "USPS abbreviated directionals for addressing.", "codedValues" : [ { "name" : "N", "code" : "N" }, { "name" : "S", "code" : "S" }, { "name" : "E", "code" : "E" }, { "name" : "W", "code" : "W" } ] }, "defaultValue" : null }, { "name" : "full_street_name", "type" : "esriFieldTypeString", "alias" : "Full Street Name", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "place_name", "type" : "esriFieldTypeString", "alias" : "Place Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "building_name", "type" : "esriFieldTypeString", "alias" : "Building Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "building_identifier", "type" : "esriFieldTypeString", "alias" : "Building Identifier", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "floor", "type" : "esriFieldTypeString", "alias" : "Floor", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LEVEL_ID", "type" : "esriFieldTypeString", "alias" : "Level ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "1" }, { "name" : "unit_type", "type" : "esriFieldTypeString", "alias" : "Unit Type", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "unit_type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "USPS abbreviated unit types.", "codedValues" : [ { "name" : "APT", "code" : "APT" }, { "name" : "BLDG", "code" : "BLDG" }, { "name" : "LOT", "code" : "LOT" }, { "name" : "RM", "code" : "RM" }, { "name" : "SPC", "code" : "SPC" }, { "name" : "STE", "code" : "STE" }, { "name" : "UNIT", "code" : "UNIT" } ] }, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "room_name", "type" : "esriFieldTypeString", "alias" : "Room Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "room_number", "type" : "esriFieldTypeString", "alias" : "Room Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "full_address", "type" : "esriFieldTypeString", "alias" : "Full Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "city", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Maricopa" }, { "name" : "county", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Pinal" }, { "name" : "state", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "AZ" }, { "name" : "country", "type" : "esriFieldTypeString", "alias" : "Country", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "US" }, { "name" : "zip_code", "type" : "esriFieldTypeInteger", "alias" : "Zip Code", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "zipcodes", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "USPS zip codes.", "codedValues" : [ { "name" : "85138", "code" : 85138 }, { "name" : "85139", "code" : 85139 } ] }, "defaultValue" : null }, { "name" : "apn", "type" : "esriFieldTypeString", "alias" : "APN", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "subdivision", "type" : "esriFieldTypeString", "alias" : "Subdivision", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "lot", "type" : "esriFieldTypeString", "alias" : "Lot", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "planning_case", "type" : "esriFieldTypeString", "alias" : "Planning Case", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "base_zoning", "type" : "esriFieldTypeString", "alias" : "Base Zoning", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "use_type", "type" : "esriFieldTypeString", "alias" : "Use Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "address_use_type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Address use types for general use.", "codedValues" : [ { "name" : "Business", "code" : "Business" }, { "name" : "Church", "code" : "Church" }, { "name" : "Driveway Entrance", "code" : "Driveway Entrance" }, { "name" : "Government", "code" : "Government" }, { "name" : "Healthcare", "code" : "Healthcare" }, { "name" : "Hotel", "code" : "Hotel" }, { "name" : "Library", "code" : "Library" }, { "name" : "Meter", "code" : "Meter" }, { "name" : "Monument Sign", "code" : "Monument Sign" }, { "name" : "Multi Family Residential", "code" : "Multi Family Residential" }, { "name" : "Parcel", "code" : "Parcel" }, { "name" : "Park", "code" : "Park" }, { "name" : "School", "code" : "School" }, { "name" : "Single Family Residential", "code" : "Single Family Residential" }, { "name" : "Tower", "code" : "Tower" }, { "name" : "Utility", "code" : "Utility" } ] }, "defaultValue" : null }, { "name" : "address_status", "type" : "esriFieldTypeString", "alias" : "Address Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "address_status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Address status.", "codedValues" : [ { "name" : "Approved", "code" : "Approved" }, { "name" : "Changed", "code" : "Changed" }, { "name" : "Planned", "code" : "Planned" }, { "name" : "Retired", "code" : "Retired" } ] }, "defaultValue" : null }, { "name" : "effective_date", "type" : "esriFieldTypeDate", "alias" : "Effective Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "expiration_date", "type" : "esriFieldTypeDate", "alias" : "Expiration Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "development_status", "type" : "esriFieldTypeString", "alias" : "Development Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "address_development_status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Address development status.", "codedValues" : [ { "name" : "Building Permit", "code" : "Building Permit" }, { "name" : "Built", "code" : "Built" }, { "name" : "Undeveloped", "code" : "Undeveloped" } ] }, "defaultValue" : null }, { "name" : "digitize_source", "type" : "esriFieldTypeString", "alias" : "Digitize Source", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "label_class", "type" : "esriFieldTypeString", "alias" : "Label Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "address_label_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Address label class for cartograpy and filtering.", "codedValues" : [ { "name" : "Building Identifier", "code" : "Building Identifier" }, { "name" : "Primary", "code" : "Primary" }, { "name" : "Unit", "code" : "Unit" }, { "name" : "Room", "code" : "Room" } ] }, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "created_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "created_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "last_edited_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "last_edited_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ADDRESSI__F4B70D857C3DFEA9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_46690.ADDRESSING_APPROVED_ADDRESSES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "created_dateIndex", "fields" : "created_date", "isAscending" : true, "isUnique" : false, "description" : "created_date Field index", "indexType" : "Attribute" }, { "name" : "created_userIndex", "fields" : "created_user", "isAscending" : false, "isUnique" : false, "description" : "created_user Field index", "indexType" : "Attribute" }, { "name" : "last_edited_dateIndex", "fields" : "last_edited_date", "isAscending" : true, "isUnique" : false, "description" : "last_edited_date Field index", "indexType" : "Attribute" }, { "name" : "last_edited_userIndex", "fields" : "last_edited_user", "isAscending" : false, "isUnique" : false, "description" : "last_edited_user Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Planned Addresses", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }