Layers:

Layer: Sewer Activity (0)

Name: Sewer Activity

Display Field: ADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Subset of addresses related to sewer activity 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: [255, 170, 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 (0) -- Related To: Hansen Sewer Activity (2)

Layer: All Hansen Addresses (1)

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)

Tables:

Table: Hansen Sewer Activity (2)

Name: Hansen Sewer Activity

Display Field: UNITID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

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:

Drawing Info:
N/A
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DIST ( type: esriFieldTypeDouble, alias: DIST, editable: true, nullable: true, defaultValue: null, modelName: DIST )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• UNITID2 ( type: esriFieldTypeString, alias: UNITID2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID2 )
• ACTCODE ( type: esriFieldTypeString, alias: ACTCODE, editable: true, nullable: false, length: 6, defaultValue: null, modelName: ACTCODE )
• ACTDESC ( type: esriFieldTypeString, alias: ACTDESC, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACTDESC )
• ACTGRP ( type: esriFieldTypeString, alias: ACTGRP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ACTGRP )
• COND ( type: esriFieldTypeString, alias: COND, editable: true, nullable: true, length: 4, defaultValue: null, modelName: COND )
• MAINTTYPE ( type: esriFieldTypeString, alias: MAINTTYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MAINTTYPE )
• STARTDTTM ( type: esriFieldTypeDate, alias: STARTDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTDTTM )
• INITDTTM ( type: esriFieldTypeDate, alias: INITDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITDTTM )
• COMPDTTM ( type: esriFieldTypeDate, alias: COMPDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMPDTTM )
• HISTKEY ( type: esriFieldTypeInteger, alias: HISTKEY, editable: true, nullable: false, defaultValue: null, modelName: HISTKEY )
• WONO ( type: esriFieldTypeString, alias: WONO, editable: true, nullable: false, length: 9, defaultValue: null, modelName: WONO )
• PROB ( type: esriFieldTypeString, alias: PROB, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PROB )
• STOPPAGE ( type: esriFieldTypeString, alias: STOPPAGE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STOPPAGE )
• ACTION ( type: esriFieldTypeString, alias: ACTION, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACTION )
• ACTKEY ( type: esriFieldTypeInteger, alias: ACTKEY, editable: true, nullable: true, defaultValue: null, modelName: ACTKEY )
• ADDBY ( type: esriFieldTypeString, alias: ADDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDBY )
• ADDDTTM ( type: esriFieldTypeDate, alias: ADDDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDDTTM )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• COMPTYPE ( type: esriFieldTypeInteger, alias: COMPTYPE, editable: true, nullable: true, defaultValue: null, modelName: COMPTYPE )
• MODBY ( type: esriFieldTypeString, alias: MODBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MODBY )
• MODDTTM ( type: esriFieldTypeDate, alias: MODDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MODDTTM )
• RES ( type: esriFieldTypeString, alias: RES, editable: true, nullable: true, length: 7, defaultValue: null, modelName: RES )
• RESP ( type: esriFieldTypeString, alias: RESP, editable: true, nullable: true, length: 4, defaultValue: null, modelName: RESP )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ADDRESS )
• GREASE ( type: esriFieldTypeString, alias: GREASE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: GREASE )
• ROOTS ( type: esriFieldTypeString, alias: ROOTS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROOTS )
• CLEAR ( type: esriFieldTypeString, alias: CLEAR, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CLEAR )
• RESULTS ( type: esriFieldTypeString, alias: RESULTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESULTS )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENT )
• RELIEVE_STOPPAGE ( type: esriFieldTypeString, alias: RELIEVE_STOPPAGE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RELIEVE_STOPPAGE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• COMPBY ( type: esriFieldTypeString, alias: COMPBY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: COMPBY )
Templates:
• Name: Hansen Sewer Activity
  Description:
  Prototype:
  COMPBY: null
  RELIEVE_STOPPAGE: null
  DIST: null
  UNITID: null
  UNITID2: null
  ACTCODE:
  ACTDESC: null
  ACTGRP: null
  COND: null
  MAINTTYPE: null
  STARTDTTM: null
  INITDTTM: null
  COMPDTTM: null
  HISTKEY: 0
  WONO:
  PROB: null
  STOPPAGE: null
  ACTION: null
  ACTKEY: null
  ADDBY: null
  ADDDTTM: null
  COMPKEY: null
  COMPTYPE: null
  MODBY: null
  MODDTTM: null
  RES: null
  RESP: null
  ADDRKEY: null
  ADDRESS: null
  GREASE: null
  ROOTS: null
  CLEAR: null
  RESULTS: null
  COMMENT: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• belongs to (0) -- Related To: Sewer Activity (0)
• belongs to (1) -- Related To: All Hansen Addresses (1)