{
  "currentVersion" : 12, 
  "id" : 16, 
  "name" : "Postal Addresses", 
  "type" : "Table", 
  "serviceItemId" : "4501683671e544ddbdfe504c1af6344f", 
  "displayField" : "pstladdid", 
  "description" : "", 
  "copyrightText" : "", 
  "defaultVisibility" : true, 
  "editFieldsInfo" : {
    "creationDateField" : "created_date", 
    "creatorField" : "created_user", 
    "editDateField" : "last_edited_date", 
    "editorField" : "last_edited_user"
  }, 
  "editingInfo" : {
    "lastEditDate" : 1741358761813, 
    "schemaLastEditDate" : 1741358761813, 
    "dataLastEditDate" : 1741358761813
  }, 
  "relationships" : [], 
  "isDataVersioned" : false, 
  "hasContingentValuesDefinition" : false, 
  "supportsAppend" : true, 
  "supportsCalculate" : true, 
  "supportsASyncCalculate" : true, 
  "supportsTruncate" : true, 
  "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, 
  "advancedQueryCapabilities" : {
    "supportsPagination" : true, 
    "supportsPaginationOnAggregatedQueries" : true, 
    "supportsQueryRelatedPagination" : true, 
    "supportsQueryWithDistance" : true, 
    "supportsReturningQueryExtent" : false, 
    "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" : true, 
    "supportsQueryWithDatumTransformation" : true, 
    "supportsCurrentUserQueries" : true, 
    "supportsHavingClause" : true, 
    "supportsOutFieldSQLExpression" : true, 
    "supportsMaxRecordCountFactor" : true, 
    "supportsTopFeaturesQuery" : 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" : [
    "count"
  ], 
  "useStandardizedQueries" : true, 
  "allowGeometryUpdates" : true, 
  "hasAttachments" : false, 
  "htmlPopupType" : "esriServerHTMLPopupTypeNone", 
  "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" : "pstladdid", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal Address Identifier", 
      "sqlType" : "sqlTypeOther", 
      "length" : 20, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "siteaddid", 
      "type" : "esriFieldTypeString", 
      "alias" : "Site Address ID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 20, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "ownernm1", 
      "type" : "esriFieldTypeString", 
      "alias" : "Owner Name", 
      "sqlType" : "sqlTypeOther", 
      "length" : 150, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "ownernm2", 
      "type" : "esriFieldTypeString", 
      "alias" : "Owner Name", 
      "sqlType" : "sqlTypeOther", 
      "length" : 150, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "pstladdress", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal Address", 
      "sqlType" : "sqlTypeOther", 
      "length" : 300, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "pstlcity", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal City", 
      "sqlType" : "sqlTypeOther", 
      "length" : 100, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "pstlstate", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal State", 
      "sqlType" : "sqlTypeOther", 
      "length" : 2, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "StateAbbreviation", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "description" : "The two digital abbreviation for the fifty US states as adapted from the USPS Publication 28", 
        "codedValues" : [
          {
            "name" : "Alabama", 
            "code" : "AL"
          }, 
          {
            "name" : "Alaska", 
            "code" : "AK"
          }, 
          {
            "name" : "American Samoa", 
            "code" : "AS"
          }, 
          {
            "name" : "Arizona", 
            "code" : "AZ"
          }, 
          {
            "name" : "Arkansas", 
            "code" : "AR"
          }, 
          {
            "name" : "California", 
            "code" : "CA"
          }, 
          {
            "name" : "Colorado", 
            "code" : "CO"
          }, 
          {
            "name" : "Connecticut", 
            "code" : "CT"
          }, 
          {
            "name" : "Delaware", 
            "code" : "DE"
          }, 
          {
            "name" : "District Of Columbia", 
            "code" : "DC"
          }, 
          {
            "name" : "Federated States Of Micronesia", 
            "code" : "FM"
          }, 
          {
            "name" : "Florida", 
            "code" : "FL"
          }, 
          {
            "name" : "Georgia", 
            "code" : "GA"
          }, 
          {
            "name" : "Guam", 
            "code" : "GU"
          }, 
          {
            "name" : "Hawaii", 
            "code" : "HI"
          }, 
          {
            "name" : "Idaho", 
            "code" : "ID"
          }, 
          {
            "name" : "Illinois", 
            "code" : "IL"
          }, 
          {
            "name" : "Indiana", 
            "code" : "IN"
          }, 
          {
            "name" : "Iowa", 
            "code" : "IA"
          }, 
          {
            "name" : "Kansas", 
            "code" : "KS"
          }, 
          {
            "name" : "Kentucky", 
            "code" : "KY"
          }, 
          {
            "name" : "Louisiana", 
            "code" : "LA"
          }, 
          {
            "name" : "Maine", 
            "code" : "ME"
          }, 
          {
            "name" : "Marshall Islands", 
            "code" : "MH"
          }, 
          {
            "name" : "Maryland", 
            "code" : "MD"
          }, 
          {
            "name" : "Massachusetts", 
            "code" : "MA"
          }, 
          {
            "name" : "Michigan", 
            "code" : "MI"
          }, 
          {
            "name" : "Minnesota", 
            "code" : "MN"
          }, 
          {
            "name" : "Mississippi", 
            "code" : "MS"
          }, 
          {
            "name" : "Missouri", 
            "code" : "MO"
          }, 
          {
            "name" : "Montana", 
            "code" : "MT"
          }, 
          {
            "name" : "Nebraska", 
            "code" : "NE"
          }, 
          {
            "name" : "Nevada", 
            "code" : "NV"
          }, 
          {
            "name" : "New Hampshire", 
            "code" : "NH"
          }, 
          {
            "name" : "New Jersey", 
            "code" : "NJ"
          }, 
          {
            "name" : "New Mexico", 
            "code" : "NM"
          }, 
          {
            "name" : "New York", 
            "code" : "NY"
          }, 
          {
            "name" : "North Carolina", 
            "code" : "NC"
          }, 
          {
            "name" : "North Dakota", 
            "code" : "ND"
          }, 
          {
            "name" : "Northern Mariana Islands", 
            "code" : "MP"
          }, 
          {
            "name" : "Ohio", 
            "code" : "OH"
          }, 
          {
            "name" : "Oklahoma", 
            "code" : "OK"
          }, 
          {
            "name" : "Oregon", 
            "code" : "OR"
          }, 
          {
            "name" : "Palau", 
            "code" : "PW"
          }, 
          {
            "name" : "Pennsylvania", 
            "code" : "PA"
          }, 
          {
            "name" : "Puerto Rico", 
            "code" : "PR"
          }, 
          {
            "name" : "Rhode Island", 
            "code" : "RI"
          }, 
          {
            "name" : "South Carolina", 
            "code" : "SC"
          }, 
          {
            "name" : "South Dakota", 
            "code" : "SD"
          }, 
          {
            "name" : "Tennessee", 
            "code" : "TN"
          }, 
          {
            "name" : "Texas", 
            "code" : "TX"
          }, 
          {
            "name" : "Utah", 
            "code" : "UT"
          }, 
          {
            "name" : "Vermont", 
            "code" : "VT"
          }, 
          {
            "name" : "Virgin Islands", 
            "code" : "VI"
          }, 
          {
            "name" : "Virginia", 
            "code" : "VA"
          }, 
          {
            "name" : "Washington", 
            "code" : "WA"
          }, 
          {
            "name" : "West Virginia", 
            "code" : "WV"
          }, 
          {
            "name" : "Wisconsin", 
            "code" : "WI"
          }, 
          {
            "name" : "Wyoming", 
            "code" : "WY"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "pstlzip5", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal Zip 5", 
      "sqlType" : "sqlTypeOther", 
      "length" : 5, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "pstlzip4", 
      "type" : "esriFieldTypeString", 
      "alias" : "Postal Zip +4", 
      "sqlType" : "sqlTypeOther", 
      "length" : 4, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "intstate", 
      "type" : "esriFieldTypeString", 
      "alias" : "International State", 
      "sqlType" : "sqlTypeOther", 
      "length" : 5, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "intpstlcd", 
      "type" : "esriFieldTypeString", 
      "alias" : "International Postal Code", 
      "sqlType" : "sqlTypeOther", 
      "length" : 10, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "country", 
      "type" : "esriFieldTypeString", 
      "alias" : "Country", 
      "sqlType" : "sqlTypeOther", 
      "length" : 100, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "uspsboxtype", 
      "type" : "esriFieldTypeString", 
      "alias" : "USPS Box Type", 
      "sqlType" : "sqlTypeOther", 
      "length" : 10, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "uspsboxid", 
      "type" : "esriFieldTypeString", 
      "alias" : "USPS Box Identifier", 
      "sqlType" : "sqlTypeOther", 
      "length" : 25, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "uspsboxgrp", 
      "type" : "esriFieldTypeString", 
      "alias" : "USPS Box Group", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "represent", 
      "type" : "esriFieldTypeString", 
      "alias" : "Owner / Occupant", 
      "sqlType" : "sqlTypeOther", 
      "length" : 30, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "MailingAddressType", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "description" : "The type of mailing address classifies the address record by owner, occupant or both.", 
        "codedValues" : [
          {
            "name" : "Owner/Occupant", 
            "code" : "Owner/Occupant"
          }, 
          {
            "name" : "Owner", 
            "code" : "Owner"
          }, 
          {
            "name" : "Occupant", 
            "code" : "Occupant"
          }, 
          {
            "name" : "Other", 
            "code" : "Other"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "status", 
      "type" : "esriFieldTypeString", 
      "alias" : "Status", 
      "sqlType" : "sqlTypeOther", 
      "length" : 30, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "AddressStatus", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "description" : "The status of the address or related feature", 
        "codedValues" : [
          {
            "name" : "Current", 
            "code" : "Current"
          }, 
          {
            "name" : "Pending", 
            "code" : "Pending"
          }, 
          {
            "name" : "Retired", 
            "code" : "Retired"
          }, 
          {
            "name" : "Temporary", 
            "code" : "Temporary"
          }, 
          {
            "name" : "Other", 
            "code" : "Other"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "GlobalID", 
      "type" : "esriFieldTypeGlobalID", 
      "alias" : "GlobalID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 38, 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "created_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "created_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 255, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true
    }, 
    {
      "name" : "created_date", 
      "type" : "esriFieldTypeDate", 
      "alias" : "created_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true, 
      "precision" : 1
    }, 
    {
      "name" : "last_edited_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "last_edited_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 255, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true
    }, 
    {
      "name" : "last_edited_date", 
      "type" : "esriFieldTypeDate", 
      "alias" : "last_edited_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true, 
      "precision" : 1
    }
  ], 
  "indexes" : [
    {
      "name" : "PK__ADDRESSI__F4B70D85C63B192A", 
      "fields" : "OBJECTID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "FDO_GlobalID", 
      "fields" : "GlobalID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "G83siteaddid", 
      "fields" : "siteaddid", 
      "isAscending" : true, 
      "isUnique" : false, 
      "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" : "Postal Addresses", 
      "description" : "", 
      "drawingTool" : "esriFeatureEditToolNone", 
      "prototype" : {
        "attributes" : {
          "uspsboxgrp" : null, 
          "represent" : "Owner/Occupant", 
          "status" : "Current", 
          "pstladdid" : null, 
          "siteaddid" : null, 
          "ownernm1" : null, 
          "ownernm2" : null, 
          "pstladdress" : null, 
          "pstlcity" : null, 
          "pstlstate" : null, 
          "pstlzip5" : null, 
          "pstlzip4" : null, 
          "intstate" : null, 
          "intpstlcd" : null, 
          "country" : null, 
          "uspsboxtype" : null, 
          "uspsboxid" : null
        }
      }
    }
  ], 
  "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", 
  "supportedConvertFileFormats" : "JSON,PBF", 
  "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", 
  "guidFormat" : "", 
  "supportsContingentValues" : true, 
  "supportedContingentValuesFormats" : "JSON, PBF", 
  "supportsFieldGroups" : true, 
  "supportedSyncDataOptions" : 260, 
  "hasStaticData" : false, 
  "maxRecordCount" : 2000, 
  "standardMaxRecordCount" : 32000, 
  "tileMaxRecordCount" : 8000, 
  "maxRecordCountFactor" : 1, 
  "capabilities" : "Create,Delete,Query,Update,Editing,Extract"
}