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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: null

Fields:
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY )
• STNAME ( type: esriFieldTypeString, alias: STNAME, length: 20 )
• ACCT ( type: esriFieldTypeString, alias: ACCT, length: 16 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• ID_NUM ( type: esriFieldTypeInteger, alias: ID_NUM )
• Loc_name ( type: esriFieldTypeString, alias: Loc_name, length: 14 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ADDRESS_NUMBER ( type: esriFieldTypeString, alias: ADDRESS_NUMBER, length: 8 )
• FLAG ( type: esriFieldTypeString, alias: FLAG, length: 1 , Coded Values: [Y: Yes] , [N: No] )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: null

Fields:
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY )
• STNAME ( type: esriFieldTypeString, alias: STNAME, length: 20 )
• ACCT ( type: esriFieldTypeString, alias: ACCT, length: 16 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• ID_NUM ( type: esriFieldTypeInteger, alias: ID_NUM )
• Loc_name ( type: esriFieldTypeString, alias: Loc_name, length: 14 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ADDRESS_NUMBER ( type: esriFieldTypeString, alias: ADDRESS_NUMBER, length: 8 )
• FLAG ( type: esriFieldTypeString, alias: FLAG, length: 1 , Coded Values: [Y: Yes] , [N: No] )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DIST ( type: esriFieldTypeDouble, alias: DIST )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 16 )
• UNITID2 ( type: esriFieldTypeString, alias: UNITID2, length: 16 )
• ACTCODE ( type: esriFieldTypeString, alias: ACTCODE, length: 6 )
• ACTDESC ( type: esriFieldTypeString, alias: ACTDESC, length: 30 )
• ACTGRP ( type: esriFieldTypeString, alias: ACTGRP, length: 6 )
• COND ( type: esriFieldTypeString, alias: COND, length: 4 )
• MAINTTYPE ( type: esriFieldTypeString, alias: MAINTTYPE, length: 4 )
• STARTDTTM ( type: esriFieldTypeDate, alias: STARTDTTM, length: 8 )
• INITDTTM ( type: esriFieldTypeDate, alias: INITDTTM, length: 8 )
• COMPDTTM ( type: esriFieldTypeDate, alias: COMPDTTM, length: 8 )
• HISTKEY ( type: esriFieldTypeInteger, alias: HISTKEY )
• WONO ( type: esriFieldTypeString, alias: WONO, length: 9 )
• PROB ( type: esriFieldTypeString, alias: PROB, length: 5 )
• STOPPAGE ( type: esriFieldTypeString, alias: STOPPAGE, length: 1 )
• ACTION ( type: esriFieldTypeString, alias: ACTION, length: 1 )
• ACTKEY ( type: esriFieldTypeInteger, alias: ACTKEY )
• ADDBY ( type: esriFieldTypeString, alias: ADDBY, length: 30 )
• ADDDTTM ( type: esriFieldTypeDate, alias: ADDDTTM, length: 8 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• COMPTYPE ( type: esriFieldTypeInteger, alias: COMPTYPE )
• MODBY ( type: esriFieldTypeString, alias: MODBY, length: 30 )
• MODDTTM ( type: esriFieldTypeDate, alias: MODDTTM, length: 8 )
• RES ( type: esriFieldTypeString, alias: RES, length: 7 )
• RESP ( type: esriFieldTypeString, alias: RESP, length: 4 )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 75 )
• GREASE ( type: esriFieldTypeString, alias: GREASE, length: 1 )
• ROOTS ( type: esriFieldTypeString, alias: ROOTS, length: 1 )
• CLEAR ( type: esriFieldTypeString, alias: CLEAR, length: 1 )
• RESULTS ( type: esriFieldTypeString, alias: RESULTS, length: 50 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 1000 )
• RELIEVE_STOPPAGE ( type: esriFieldTypeString, alias: RELIEVE_STOPPAGE, length: 1 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• COMPBY ( type: esriFieldTypeString, alias: COMPBY, length: 12 )

Relationships:

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