View In:   ArcGIS Online Map Viewer

Name: Address Numbers

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer contains site address for all addressed parcels, residences, businesses and facilities in the City of Tumwater. It was initially created using the TCOMM Site Address layer.

Service Item Id: 0f6194566f8d463796f996e4e63acd4d

Copyright Text: City of Tumwater and TCOMM 911

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1024364.4899580479
YMin: 597265.9335385561
XMax: 1049597.1432328075
YMax: 627518.0879291445
Spatial Reference: 2927  (2927)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [127, 68, 59, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 0] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Calibri
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• parcel_number ( modelName: PARCEL_NUMBER, nullable: true, editable: true, defaultValue: null, length: 11, alias: PARCEL NUMBER, type: esriFieldTypeString )
• address ( modelName: ADDRESS, nullable: true, editable: true, defaultValue: null, length: 60, alias: ADDRESS, type: esriFieldTypeString )
• address_number ( modelName: ADDRESS_NUMBER, nullable: true, editable: true, defaultValue: null, length: 10, alias: ADDRESS_NUMBER, type: esriFieldTypeString )
• predirectional ( modelName: PREDIRECTIONAL, nullable: true, editable: true, defaultValue: null, length: 4, alias: PREDIRECTIONAL, type: esriFieldTypeString , Coded Values: [N: N] , [NE: NE] , [E: E] , ...5 more... )
• street_name ( modelName: STREET_NAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: STREET NAME, type: esriFieldTypeString , Coded Values: [12TH: 12TH] , [21ST: 21ST] , [26TH: 26TH] , ...513 more... )
• street_type ( modelName: STREET_TYPE, nullable: true, editable: true, defaultValue: null, length: 4, alias: STREET_TYPE, type: esriFieldTypeString , Coded Values: [ALY: ALY] , [AVE: AVE] , [BLF: BLF] , ...42 more... )
• postdirectional ( modelName: POSTDIRECTIONAL, nullable: true, editable: true, defaultValue: null, length: 4, alias: POSTDIRECTIONAL, type: esriFieldTypeString , Coded Values: [N: N] , [NE: NE] , [E: E] , ...5 more... )
• sub_address_type ( modelName: SUB_ADDRESS_TYPE, nullable: true, editable: true, defaultValue: null, length: 15, alias: SUB_ADDRESS_TYPE, type: esriFieldTypeString , Coded Values: [APT: Apartment] , [BLDG: Building] , [DEPT: Department] , ...8 more... )
• sub_address_number ( modelName: SUB_ADDRESS_NUMBER, nullable: true, editable: true, defaultValue: null, length: 10, alias: SUB_ADDRESS_NUMBER, type: esriFieldTypeString )
• city ( modelName: CITY, nullable: true, editable: true, defaultValue: null, length: 20, alias: CITY, type: esriFieldTypeString , Coded Values: [TUM: Tumwater] , [OLY: Olympia] , [THUR: Thurston County] )
• zip ( modelName: ZIP, nullable: true, editable: true, defaultValue: null, length: 12, alias: ZIP, type: esriFieldTypeString , Coded Values: [98501: 98501] , [98512: 98512] )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 50, alias: LOCATION, type: esriFieldTypeString , Coded Values: [BLDG: Building] , [PARCEL: Parcel] , [UNIT: Unit, Condo, Office, Suite] , ...3 more... )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 20, alias: STATUS, type: esriFieldTypeString , Coded Values: [CURRENT: Current Active Address] , [PENDING: Pending Address] , [RETIRED: Retired Address] , ...2 more... )
• address_type ( modelName: ADDRESS_TYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: ADDRESS_TYPE, type: esriFieldTypeString , Coded Values: [RES: Residential Building] , [COM: Commerical Retail Building] , [IND: Industrial Building] , ...6 more... )
• utility_type ( modelName: UTILITY_TYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: UTILITY_TYPE, type: esriFieldTypeString , Coded Values: [PRV: Pressure Relief Valve] , [WAFILL: Water Filling Station] , [WM: Water Meter] , ...8 more... )
• capture_method ( modelName: CAPTURE_METHOD, nullable: true, editable: true, defaultValue: null, length: 30, alias: CAPTURE_LOCATION, type: esriFieldTypeString , Coded Values: [MAP: Placed on Map in GIS] , [GPS: GPS located Address] )
• name ( modelName: NAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: NAME, type: esriFieldTypeString )
• comment ( modelName: COMMENT, nullable: true, editable: true, defaultValue: null, length: 75, alias: COMMENT, type: esriFieldTypeString )
• x_coord ( modelName: X_COORD, nullable: true, editable: true, defaultValue: null, alias: X_COORD, type: esriFieldTypeDouble )
• y_coord ( modelName: Y_COORD, nullable: true, editable: true, defaultValue: null, alias: Y_COORD, type: esriFieldTypeDouble )
• editor ( modelName: EDITOR, nullable: true, editable: true, defaultValue: null, length: 25, alias: EDITOR, type: esriFieldTypeString )
• edit_date ( modelName: EDIT_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EDIT_DATE, type: esriFieldTypeDate )
• creator ( modelName: CREATOR, nullable: true, editable: true, defaultValue: null, length: 25, alias: CREATOR, type: esriFieldTypeString )
• create_date ( modelName: CREATE_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CREATE_DATE, type: esriFieldTypeDate )
• datagrade ( modelName: DataGrade, nullable: true, editable: true, defaultValue: null, length: 15, alias: DataGrade, type: esriFieldTypeString , Coded Values: [Survey: Survey] , [GPS: Mapping Grade GPS] , [Plan: Approved Plans] , ...2 more... )
• source ( modelName: Source, nullable: true, editable: true, defaultValue: null, length: 50, alias: Source, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, required: true, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, required: true, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, required: true, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, required: true, modelName: last_edited_date, alias: last_edited_date )
• uniqueid ( modelName: UniqueID, nullable: true, editable: true, defaultValue: null, length: 10, alias: UniqueID, type: esriFieldTypeString )
• validationstatus ( nullable: true, editable: true, defaultValue: 6, type: esriFieldTypeSmallInteger, required: true, modelName: validationstatus, alias: Validation status , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )

Templates:

• Name: Address Numbers
  Description:
  Prototype:
  x_coord: null
  utility_type: null
  city: null
  source: null
  street_name: null
  sub_address_type: null
  predirectional: null
  parcel_number: null
  sub_address_number: null
  validationstatus: 6
  create_date: null
  uniqueid: null
  zip: null
  capture_method: null
  editor: null
  creator: null
  address: null
  address_type: null
  datagrade: null
  address_number: null
  postdirectional: null
  name: null
  street_type: null
  location: null
  comment: null
  y_coord: null
  edit_date: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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

Child Resources:   Field Groups   Contingent Values

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