{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 31,
 "name": "Postal Addresses",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user",
  "dateFieldsTimeReference": {
   "timeZone": "UTC",
   "respectsDaylightSaving": false
  }
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 2,
   "name": "SiteAddressPoint",
   "relatedTableId": 10,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "siteaddid",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": true,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": true,
 "isDataReplicaTracked": true,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1667991065000
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": false
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": true,
 "supportsOidReservation": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "pstladdid",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "System-maintained ObjectID"
  },
  {
   "name": "pstladdid",
   "type": "esriFieldTypeString",
   "alias": "Postal Address Identifier",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "pstladdid"
  },
  {
   "name": "siteaddid",
   "type": "esriFieldTypeString",
   "alias": "Site Address ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "siteaddid"
  },
  {
   "name": "ownernm1",
   "type": "esriFieldTypeString",
   "alias": "Owner Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150,
   "defaultValue": null,
   "modelName": "ownernm1"
  },
  {
   "name": "ownernm2",
   "type": "esriFieldTypeString",
   "alias": "Owner Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150,
   "defaultValue": null,
   "modelName": "ownernm2"
  },
  {
   "name": "pstladdress",
   "type": "esriFieldTypeString",
   "alias": "Postal Address",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 300,
   "defaultValue": null,
   "modelName": "pstladdress"
  },
  {
   "name": "pstlcity",
   "type": "esriFieldTypeString",
   "alias": "Postal City",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "pstlcity"
  },
  {
   "name": "pstlstate",
   "type": "esriFieldTypeString",
   "alias": "Postal State",
   "domain": {
    "type": "codedValue",
    "name": "StateAbbreviation",
    "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"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   },
   "editable": true,
   "nullable": true,
   "length": 2,
   "defaultValue": null,
   "modelName": "pstlstate"
  },
  {
   "name": "pstlzip5",
   "type": "esriFieldTypeString",
   "alias": "Postal Zip 5",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 5,
   "defaultValue": null,
   "modelName": "pstlzip5"
  },
  {
   "name": "pstlzip4",
   "type": "esriFieldTypeString",
   "alias": "Postal Zip +4",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 4,
   "defaultValue": null,
   "modelName": "pstlzip4"
  },
  {
   "name": "intstate",
   "type": "esriFieldTypeString",
   "alias": "International State",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 5,
   "defaultValue": null,
   "modelName": "intstate"
  },
  {
   "name": "intpstlcd",
   "type": "esriFieldTypeString",
   "alias": "International Postal Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "intpstlcd"
  },
  {
   "name": "country",
   "type": "esriFieldTypeString",
   "alias": "Country",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "country"
  },
  {
   "name": "uspsboxtype",
   "type": "esriFieldTypeString",
   "alias": "USPS Box Type",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "uspsboxtype"
  },
  {
   "name": "uspsboxid",
   "type": "esriFieldTypeString",
   "alias": "USPS Box Identifier",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "uspsboxid"
  },
  {
   "name": "uspsboxgrp",
   "type": "esriFieldTypeString",
   "alias": "USPS Box Group",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "uspsboxgrp"
  },
  {
   "name": "represent",
   "type": "esriFieldTypeString",
   "alias": "Owner / Occupant",
   "domain": {
    "type": "codedValue",
    "name": "MailingAddressType",
    "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"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "represent"
  },
  {
   "name": "status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "domain": {
    "type": "codedValue",
    "name": "AddressStatus",
    "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"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "status"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  }
 ],
 "indexes": [
  {
   "name": "UUID_68",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G94siteaddid",
   "fields": "siteaddid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R68_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Pacific Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Postal Addresses",
   "description": "",
   "prototype": {
    "attributes": {
     "represent": "Owner/Occupant",
     "status": "Current"
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "17e4d4c7186c49a6b79bd923cf04ec4c"
}