View In:   ArcGIS Online Map Viewer

Parent Layer: Sewer Infrastructure

Name: Sewer Services

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Sewer services, typically drawn 90 degrees from main line. Source documents vary from "as builts" to inspection videos.</SPAN></P><P><SPAN STYLE="font-weight:bold;">4/14/2023 Notes</SPAN><SPAN>: Recent entries, those made within the last 3-4 years, are likely derived from "as builts" CAD .dwg drawings that contain coordinates. Older entries are likely from sewer inspections, and are drawn perpendicular to the main. These sewer inspections refer to the CCTV videos and documentation found in laserfische (link to Derek's file location). Entries that have nothing in the "Source" attribute may be from georeferenced 'as builts' scans (these can be found in the laserfiche Public Works-Engineering-Developement, or in the Public Works drive under either the GIS, Projects, and/or Subdivisions folders). It is also possible that it is unknown where those service locations came from.</SPAN></P><P><SPAN>Some service locations are GPS'd directly during construction by the building official/inspector. These are indicated in the source field.</SPAN></P><P><SPAN>This layer was first created cerca 2016-2017 by some combination of Ryan and an intern named Alma, and Jackie Malloy took-over the task after beginning as an intern in 2017. The first SDE database was scrubbed and rebuilt in 2018, so create dates may reflect this-not the actual create date. </SPAN></P><P><SPAN>Editing recommendations are to sort by NULL in the Source field, and then based-on location/neighborhood, reference the maps accompanying the inspection video (Derek's file).</SPAN></P><P><SPAN>The sewer system is going to be inspected, again, in the next 4ish years.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 84e9086a2e6941169640258afaf7e2ab

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500

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: 561470.8323339251
YMin: 451676.87321006216
XMax: 582268.9695482658
YMax: 466283.66814684734
Spatial Reference: 103032  (6451)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [209, 255, 115, 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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Comment )
• Address ( type: esriFieldTypeString, alias: Service Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Templates:

• Name: Sewer Services
  Description:
  Prototype:
  ID: null
  Comment: null
  Source: null
  Address: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata