Name: Postal Addresses

Display Field: pstladdid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 289899da80234e70a9468638d08a48ed

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -18000000
YMin: -12000000
XMax: 18000000
YMax: 16000000
Spatial Reference: 102100

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, isViewOverride: false, alias: OBJECTID )
• pstladdid ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, isViewOverride: false, alias: Postal Address Identifier )
• siteaddkey ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, isViewOverride: false, alias: Site Address ID )
• ownernm1 ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, isViewOverride: false, alias: Owner Name )
• ownernm2 ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, isViewOverride: false, alias: Owner Name )
• pstladdress ( nullable: true, editable: true, defaultValue: null, length: 250, type: esriFieldTypeString, isViewOverride: false, alias: Postal Address )
• pstlcity ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: false, alias: Postal City )
• pstlstate ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, isViewOverride: false, alias: Postal State )
• pstlzip5 ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, isViewOverride: false, alias: Postal Zip 5 )
• pstlzip4 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, isViewOverride: false, alias: Postal Zip +4 )
• intstate ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, isViewOverride: false, alias: International State )
• intpstlcd ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, isViewOverride: false, alias: International Postal Code )
• country ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: false, alias: Country )
• uspsboxtype ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, isViewOverride: false, alias: USPS Box Type )
• uspsboxid ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, isViewOverride: false, alias: USPS Box Identifier )
• uspsboxgrp ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, isViewOverride: false, alias: USPS Box Group )
• represent ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, isViewOverride: false, alias: Owner / Occupant )
• status ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, isViewOverride: false, alias: Status )

Templates:

• Name: Postal Addresses
  Description:
  Prototype:
  ownernm2: null
  country: null
  pstlzip5: null
  pstlzip4: null
  pstlcity: null
  intpstlcd: null
  siteaddkey: null
  intstate: null
  uspsboxgrp: null
  pstlstate: null
  pstladdid: null
  uspsboxid: null
  pstladdress: null
  uspsboxtype: null
  ownernm1: null
  represent: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SiteAddresses (1) -- Related To: Site Addresses (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata