View In:   ArcGIS Online Map Viewer

Name: AddressPoint

Display Field: CPName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The AddressPoint feature class was created due to the need for the City of Redmond to have a single and accurate address database containing addresses and their geographical location down to the building level of detail. This master address database was created by combining all addresses from the City of Redmond’s multiple business systems (Permits Plus (Real Property), FDM, and Business License). These systems were compiled into a single master address list showing all currently known Redmond and UPD addresses. The list contained accurate addresses as well as duplicates, errors, and many were missing or not current. A GIS point feature class was generated for each individual address from the master list and associated with its appropriate Parcel linked from the PIN. Parcels having multiple addresses received multiple point features; one for each address. After the initial feature class was created, field workers from the Police and Fire departments performed extensive field checks to verify every address except for single family residential. They walked on foot to each unit of each condo, apartment, etc. to verify the correct address. They hand wrote down each addresses then brought those field notes into the office for GIS Services technicians to enter the field notes into the database.

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1312536.6697859028
YMin: 228893.8487833421
XMax: 1365215.2249391053
YMax: 275074.6743852198
Spatial Reference: 2926  (2926)  VCSWkid(5702)  LatestVCSWkid(5702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [240, 240, 240, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
Supports Query With LOD Spatial Reference: false
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StreetNo ( type: esriFieldTypeString, alias: StreetNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetNo )
• Address1 ( type: esriFieldTypeString, alias: Address1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address1 )
• Address2 ( type: esriFieldTypeString, alias: Address2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address2 )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: State )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ZIP )
• d_KnownIssue ( type: esriFieldTypeString, alias: d_KnownIssue, editable: true, nullable: false, length: 3, defaultValue: UNK, modelName: d_KnownIssue , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• d_AddressStatus ( type: esriFieldTypeString, alias: d_AddressStatus, editable: true, nullable: false, length: 3, defaultValue: ACT, modelName: d_AddressStatus , Coded Values: [ACT: Active] , [PRO: Proposed] , [APP: Approved] , ...3 more... )
• RetireDate ( type: esriFieldTypeDate, alias: RetireDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetireDate )
• RedAddressPointId ( type: esriFieldTypeInteger, alias: RedAddressPointId, editable: true, nullable: true, defaultValue: null, modelName: RedAddressPointId )
• VerifyDate ( type: esriFieldTypeDate, alias: VerifyDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VerifyDate )
• d_VerifiedBy ( type: esriFieldTypeString, alias: d_VerifiedBy, editable: true, nullable: true, length: 25, defaultValue: null, modelName: d_VerifiedBy , Coded Values: [Rich Gieseke: Rich Gieseke] , [Stacy Myers: Stacy Myers] , [Nate Fears: Nate Fears] , ...16 more... )
• d_MaintainedBy ( type: esriFieldTypeString, alias: d_MaintainedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: d_MaintainedBy , Coded Values: [CITY: City] , [OTH: Other] )
• d_MailingList ( type: esriFieldTypeString, alias: d_MailingList, editable: true, nullable: true, length: 6, defaultValue: null, modelName: d_MailingList , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• ModifiedBy ( type: esriFieldTypeString, alias: ModifiedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModifiedBy )
• DateModified ( type: esriFieldTypeDate, alias: DateModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• Alias1 ( type: esriFieldTypeString, alias: Alias1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alias1 )
• Alias2 ( type: esriFieldTypeString, alias: Alias2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alias2 )
• Alias3 ( type: esriFieldTypeString, alias: Alias, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alias3 )
• CPName ( type: esriFieldTypeString, alias: CPName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CPName )
• CPAlias1 ( type: esriFieldTypeString, alias: CPAlias1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CPAlias1 )
• CPAlias2 ( type: esriFieldTypeString, alias: CPAlias2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CPAlias2 )
• CPAlias3 ( type: esriFieldTypeString, alias: CPAlias3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CPAlias3 )
• FullAddr ( type: esriFieldTypeString, alias: FullAddr, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FullAddr )
• Address2POL ( type: esriFieldTypeString, alias: Address2POL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Address2POL )
• d_BaseAddress ( type: esriFieldTypeString, alias: d_BaseAddress, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_BaseAddress , Coded Values: [YES: Yes] , [NO: No] )
• d_Jurisdiction ( type: esriFieldTypeString, alias: d_Jurisdiction, editable: true, nullable: true, length: 6, defaultValue: CITY, modelName: d_Jurisdiction , Coded Values: [BEL: Bellevue] , [CITY: City Limits] , [KC: King County] , ...4 more... )

Templates:

• Name: AddressPoint
  Description:
  Prototype:
  d_BaseAddress: null
  StreetNo: null
  Address1: null
  Address2: null
  City: null
  State: null
  ZIP: null
  d_KnownIssue: UNK
  Comments: null
  d_AddressStatus: ACT
  RetireDate: null
  RedAddressPointId: null
  VerifyDate: null
  d_VerifiedBy: null
  d_MaintainedBy: null
  d_MailingList: null
  CreatedBy: null
  DateCreated: null
  ModifiedBy: null
  DateModified: null
  Alias1: null
  Alias2: null
  Alias3: null
  CPName: null
  CPAlias1: null
  CPAlias2: null
  CPAlias3: null
  FullAddr: null
  Address2POL: null
  d_Jurisdiction: CITY
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata