View In:   ArcGIS Online map viewer

Name: All Hansen Addresses

Display Field: ADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Hansen asset management database address table from Aug 6, 2020 was geocoded using the propadd streets locator sp. 17,725 matched (95%) while 903 (5%) did not match. Some manual re-matching occurred, however, many addresses appear to have been guesses. As of 8/6/20, 16,356 addresses can be related to 85,972 RCOSTSUM+HISTORY rows. 97%!

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: -3100017.721518889
YMin: -7193065.010240808
XMax: 1281661.0735049397
YMax: 533019.5362468511
Spatial Reference: 102685  (2248)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• STNAME ( type: esriFieldTypeString, alias: STNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STNAME )
• ACCT ( type: esriFieldTypeString, alias: ACCT, editable: true, nullable: true, length: 16, defaultValue: null, modelName: ACCT )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• ID_NUM ( type: esriFieldTypeInteger, alias: ID_NUM, editable: true, nullable: true, defaultValue: null, modelName: ID_NUM )
• Loc_name ( type: esriFieldTypeString, alias: Loc_name, editable: true, nullable: true, length: 14, defaultValue: null, modelName: Loc_name )
• ADDRESS_NUMBER ( type: esriFieldTypeString, alias: ADDRESS_NUMBER, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDRESS_NUMBER )
• FLAG ( type: esriFieldTypeString, alias: FLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FLAG , Coded Values: [Y: Yes] , [N: No] )

Templates:

• Name: Hansen Addresses
  Description:
  Prototype:
  ADDRESS_NUMBER: null
  FLAG: null
  ADDRKEY: null
  STNAME: null
  ACCT: null
  ADDRESS: null
  ID_NUM: null
  Loc_name: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• may have history (1) -- Related To: Hansen Sewer Activity (2)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata