View In:   ArcGIS Online Map Viewer

Name: Drain_Conveyance

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

Copyright Text: City of San Diego, Stormwater Department

Default Visibility: true

MaxRecordCount: 2000

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

Extent:

XMin: 6244646.839979053
YMin: 1777337.020770058
XMax: 6352922.906891048
YMax: 1985501.3528001457
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [119, 52, 155, 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: 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 )
• drain ( modelName: drain, nullable: true, editable: true, defaultValue: null, alias: Drain Conveyance ID, type: esriFieldTypeInteger )
• gisid ( modelName: gisid, nullable: true, editable: true, defaultValue: null, length: 10, alias: GIS ID, type: esriFieldTypeString )
• eqpid ( modelName: eqpid, nullable: true, editable: true, defaultValue: null, length: 9, alias: Equipment ID, type: esriFieldTypeString )
• sapid ( modelName: sapid, nullable: true, editable: true, defaultValue: null, length: 10, alias: SAP ID, type: esriFieldTypeString )
• fnode_ ( modelName: fnode_, nullable: true, editable: true, defaultValue: null, alias: From Drain Structure ID, type: esriFieldTypeInteger )
• tnode_ ( modelName: tnode_, nullable: true, editable: true, defaultValue: null, alias: To Drain Structure ID, type: esriFieldTypeInteger )
• code ( modelName: code, nullable: true, editable: true, defaultValue: D, length: 1, alias: Drain Conveyance Type, 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 )
• material ( modelName: material, nullable: true, editable: true, defaultValue: null, length: 10, alias: Material, type: esriFieldTypeString )
• conv_shp ( modelName: conv_shp, nullable: true, editable: true, defaultValue: C, length: 1, alias: Conveyance Shape, 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 )
• lined ( modelName: lined, nullable: true, editable: true, defaultValue: null, length: 1, alias: Lined, type: esriFieldTypeString )
• slope ( modelName: slope, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• era ( modelName: era, nullable: true, editable: true, defaultValue: null, length: 25, alias: ERA, type: esriFieldTypeString )
• easement ( modelName: easement, nullable: true, editable: true, defaultValue: null, length: 60, alias: Easement Description, type: esriFieldTypeString )
• install_ye ( modelName: install_ye, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• asbuilt_date ( modelName: asbuilt_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: As-built Date, type: esriFieldTypeDate )
• drawing_no ( modelName: drawing_no, nullable: true, editable: true, defaultValue: null, length: 30, alias: As-built Drawing No, type: esriFieldTypeString )
• easement_dwg ( modelName: easement_dwg, nullable: true, editable: true, defaultValue: null, length: 30, alias: Easement Drawing No, type: esriFieldTypeString )
• subdivision_dwg ( modelName: subdivision_dwg, nullable: true, editable: true, defaultValue: null, length: 30, alias: Subdivision Map No, type: esriFieldTypeString )
• work_order ( modelName: work_order, nullable: true, editable: true, defaultValue: null, length: 10, alias: Work Order, type: esriFieldTypeString )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 1, alias: Status, type: esriFieldTypeString )
• comments ( modelName: comments, nullable: true, editable: true, defaultValue: null, length: 100, alias: Comment, type: esriFieldTypeString )
• owner ( modelName: owner, nullable: true, editable: true, defaultValue: S, length: 1, alias: Owner, type: esriFieldTypeString )
• maint ( modelName: maint, nullable: true, editable: true, defaultValue: 6, length: 1, alias: Maintained By, type: esriFieldTypeString )
• roughness ( modelName: roughness, nullable: true, editable: true, defaultValue: null, alias: Roughness, type: esriFieldTypeDouble )
• name ( modelName: name, nullable: true, editable: true, defaultValue: null, length: 40, alias: Name, type: esriFieldTypeString )
• loc_desc ( modelName: loc_desc, nullable: true, editable: true, defaultValue: null, length: 40, alias: Location Description, type: esriFieldTypeString )
• watershed ( modelName: watershed, nullable: true, editable: true, defaultValue: null, alias: Watershed, type: esriFieldTypeSmallInteger )
• asm_instl_d ( modelName: asm_instl_d, nullable: true, editable: true, defaultValue: null, length: 50, alias: ASM_INSTL_D, type: esriFieldTypeString )
• debr_fnc ( modelName: debr_fnc, nullable: true, editable: true, defaultValue: null, length: 50, alias: DEBR_FNC, type: esriFieldTypeString )
• hu ( modelName: hu, nullable: true, editable: true, defaultValue: null, alias: HU, type: esriFieldTypeSmallInteger )
• hsa ( modelName: hsa, nullable: true, editable: true, defaultValue: null, alias: HSA, type: esriFieldTypeSmallInteger )
• huname ( modelName: huname, nullable: true, editable: true, defaultValue: null, length: 35, alias: HUNAME, type: esriFieldTypeString )
• hsaname ( modelName: hsaname, nullable: true, editable: true, defaultValue: null, length: 35, alias: HSANAME, type: esriFieldTypeString )
• cmnty_area ( modelName: cmnty_area, nullable: true, editable: true, defaultValue: null, length: 35, alias: CPNAME, type: esriFieldTypeString )
• cncl_dtrct ( modelName: cncl_dtrct, nullable: true, editable: true, defaultValue: null, alias: DISTRICT, type: esriFieldTypeInteger )
• cdcode ( modelName: cdcode, nullable: true, editable: true, defaultValue: null, alias: CDCODE, type: esriFieldTypeSmallInteger )
• cpcode ( modelName: cpcode, nullable: true, editable: true, defaultValue: null, alias: CPCODE, type: esriFieldTypeSmallInteger )
• where_installed ( modelName: where_installed, nullable: true, editable: true, defaultValue: null, length: 30, alias: WHERE_INSTALLED, type: esriFieldTypeString )
• 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 )
• mapng_stat_cd ( modelName: mapng_stat_cd, nullable: true, editable: true, defaultValue: AB, length: 2, alias: DRAIN_CONVEYANCE, type: esriFieldTypeString )
• inst_yr ( modelName: inst_yr, nullable: true, editable: true, defaultValue: null, length: 50, alias: INST_YR, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• own_verified ( modelName: own_verified, nullable: true, editable: true, defaultValue: null, length: 30, alias: OWN_VERIFIED, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Drain_Conveyance
  Description:
  Prototype:
  watershed: null
  asm_instl_d: null
  huname: null
  own_verified: null
  subdivision_dwg: null
  hu: null
  hsaname: null
  cpcode: null
  diameter: null
  debr_fnc: null
  roughness: null
  sapobjnr: null
  eqpid: null
  install_ye: null
  loc_desc: null
  inst_yr: null
  tnode_: null
  work_order: null
  height: null
  created_user: null
  fnode_: null
  slope: null
  hsa: null
  name: null
  mapng_stat_cd: AB
  where_installed: null
  status: null
  cncl_dtrct: null
  cmnty_area: null
  code: D
  from_elev: null
  asbuilt_date: null
  iamfloc: null
  drain: null
  cdcode: null
  lined: null
  era: null
  last_edited_date: null
  easement: null
  owner: S
  act_length: null
  comments: null
  drawing_no: null
  gisid: null
  last_edited_user: null
  material: null
  easement_dwg: null
  maint: 6
  width: null
  conv_shp: C
  to_elev: null
  created_date: null
  sapid: null
  
  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:   Field Groups   Contingent Values

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