View In:   ArcGIS Online Map Viewer

Name: Drain_Conveyance_Public

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset contains storm drain conveyances used for the Public Works GIS/SAP Work Management System. The layer is created and maintained to ensure that infrastructure is represented in the appropriate spatial context with sufficient attribution to determine structural material, size, and configurations.

Service Item Id: 7a2661c47fba4c6bbba5c27c4cf908df

Copyright Text: City of San Diego, Stormwater Department

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 6244646.839979053
YMin: 1777337.020770058
XMax: 6352922.906891048
YMax: 1986857.116164729
Spatial Reference: 102646  (2230)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [132, 68, 54, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• iamfloc ( modelName: iamfloc, nullable: true, editable: true, defaultValue: null, length: 30, alias: IAMFLOC, type: esriFieldTypeString )
• sapobjnr ( modelName: sapobjnr, nullable: true, editable: true, defaultValue: null, length: 22, alias: SAPOBJNR, type: esriFieldTypeString )
• code ( modelName: code, nullable: true, editable: true, defaultValue: D, length: 1, alias: Drain Conveyance Type, type: esriFieldTypeString )
• status ( modelName: status, nullable: true, editable: true, defaultValue: A, length: 1, alias: Active Status, type: esriFieldTypeString )
• mapng_stat_cd ( modelName: mapng_stat_cd, nullable: true, editable: true, defaultValue: AB, length: 2, alias: Mapping Status, type: esriFieldTypeString )
• material ( modelName: material, nullable: true, editable: true, defaultValue: null, length: 10, alias: Material, type: esriFieldTypeString )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble )
• width ( modelName: width, nullable: true, editable: true, defaultValue: null, alias: Width, type: esriFieldTypeDouble )
• height ( modelName: height, nullable: true, editable: true, defaultValue: null, alias: Height, type: esriFieldTypeDouble )
• act_length ( modelName: act_length, nullable: true, editable: true, defaultValue: null, alias: Actual Length, type: esriFieldTypeDouble )
• conv_shp ( modelName: conv_shp, nullable: true, editable: true, defaultValue: C, length: 1, alias: Conveyance Shape, type: esriFieldTypeString )
• lined ( modelName: lined, nullable: true, editable: true, defaultValue: N, length: 1, alias: Lined, type: esriFieldTypeString )
• slope ( modelName: slope, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• roughness ( modelName: roughness, nullable: true, editable: true, defaultValue: null, alias: Roughness, type: esriFieldTypeDouble )
• loc_desc ( modelName: loc_desc, nullable: true, editable: true, defaultValue: null, length: 40, alias: Location Description, type: esriFieldTypeString )
• from_elev ( modelName: from_elev, nullable: true, editable: true, defaultValue: null, alias: From Elevation, type: esriFieldTypeDouble )
• to_elev ( modelName: to_elev, nullable: true, editable: true, defaultValue: null, alias: To Elevation, type: esriFieldTypeDouble )
• from_iamfloc ( modelName: from_iamfloc, nullable: true, editable: true, defaultValue: null, length: 30, alias: From IAMFLOC, type: esriFieldTypeString )
• to_iamfloc ( modelName: to_iamfloc, nullable: true, editable: true, defaultValue: null, length: 30, alias: To IAMFLOC, type: esriFieldTypeString )
• drawing_no ( modelName: drawing_no, nullable: true, editable: true, defaultValue: null, length: 30, alias: Drawing Number, type: esriFieldTypeString )
• install_ye ( modelName: install_ye, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• inst_yr ( modelName: inst_yr, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date Year, type: esriFieldTypeDate )
• asbuilt_date ( modelName: asbuilt_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: As-built Date, type: esriFieldTypeDate )
• asm_instl_d ( modelName: asm_instl_d, nullable: true, editable: true, defaultValue: null, length: 50, alias: Assumed Install Date, type: esriFieldTypeString )
• subdivision_dwg ( modelName: subdivision_dwg, nullable: true, editable: true, defaultValue: null, length: 30, alias: Subdivision Map Number, type: esriFieldTypeString )
• easement_dwg ( modelName: easement_dwg, nullable: true, editable: true, defaultValue: null, length: 30, alias: Easement Drawing Number, type: esriFieldTypeString )
• easement ( modelName: easement, nullable: true, editable: true, defaultValue: null, length: 60, alias: Easement Description, type: esriFieldTypeString )
• era ( modelName: era, nullable: true, editable: true, defaultValue: null, length: 25, alias: Encroachment Removal Agreement (ERA), type: esriFieldTypeString )
• work_order ( modelName: work_order, nullable: true, editable: true, defaultValue: null, length: 10, alias: Project Number, type: esriFieldTypeString )
• watershed ( modelName: watershed, nullable: true, editable: true, defaultValue: null, alias: Watershed, type: esriFieldTypeSmallInteger )
• mwmp_watershed ( modelName: mwmp_watershed, nullable: true, editable: true, defaultValue: null, alias: MWMP Watershed, type: esriFieldTypeSmallInteger )
• hu ( modelName: hu, nullable: true, editable: true, defaultValue: null, alias: Hydrologic Unit, type: esriFieldTypeInteger )
• ha ( modelName: ha, nullable: true, editable: true, defaultValue: null, alias: Hydrologic Area, type: esriFieldTypeInteger )
• hsa ( modelName: hsa, nullable: true, editable: true, defaultValue: null, alias: Hydrologic Sub Area, type: esriFieldTypeInteger )
• huname ( modelName: huname, nullable: true, editable: true, defaultValue: null, length: 35, alias: Hydrologic Unit Code, type: esriFieldTypeString )
• haname ( modelName: haname, nullable: true, editable: true, defaultValue: null, length: 35, alias: Hydrologic Area Code, type: esriFieldTypeString )
• hsaname ( modelName: hsaname, nullable: true, editable: true, defaultValue: null, length: 35, alias: Hydrologic Sub Area Code, type: esriFieldTypeString )
• name ( modelName: name, nullable: true, editable: true, defaultValue: null, length: 40, alias: Channel Name, type: esriFieldTypeString )
• cdcode ( modelName: cdcode, nullable: true, editable: true, defaultValue: null, alias: Council District, type: esriFieldTypeSmallInteger )
• cpcode ( modelName: cpcode, nullable: true, editable: true, defaultValue: null, alias: Community Planning Area, type: esriFieldTypeSmallInteger )
• from_latitude ( modelName: from_latitude, nullable: true, editable: true, defaultValue: null, alias: From Latitude, type: esriFieldTypeDouble )
• from_longitude ( modelName: from_longitude, nullable: true, editable: true, defaultValue: null, alias: From Longitude, type: esriFieldTypeDouble )
• to_latitude ( modelName: to_latitude, nullable: true, editable: true, defaultValue: null, alias: To Latitude, type: esriFieldTypeDouble )
• to_longitude ( modelName: to_longitude, nullable: true, editable: true, defaultValue: null, alias: To Longitude, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Drain_Conveyance_Public
  Description:
  Prototype:
  asm_instl_d: null
  watershed: null
  code: D
  huname: null
  from_elev: null
  haname: null
  asbuilt_date: null
  mwmp_watershed: null
  iamfloc: null
  to_iamfloc: null
  subdivision_dwg: null
  hu: null
  hsaname: null
  cdcode: null
  cpcode: null
  lined: N
  diameter: null
  from_iamfloc: null
  sapobjnr: null
  roughness: null
  era: null
  from_longitude: null
  install_ye: null
  loc_desc: null
  inst_yr: null
  easement: null
  work_order: null
  height: null
  act_length: null
  slope: null
  drawing_no: null
  from_latitude: null
  to_longitude: null
  material: null
  easement_dwg: null
  hsa: null
  mapng_stat_cd: AB
  width: null
  conv_shp: C
  name: null
  to_latitude: null
  ha: null
  to_elev: null
  status: A
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata