View In:   ArcGIS Online Map Viewer

Name: Water_Main_SD

Display Field: fac_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Line features representing the location of water main lines supporting the City of San Diego Potable Water Distribution System. Water main locations and attributes are maintained by the Public Utilities Department, Asset Management - Geographic Information System (GIS) section and are derived from input from City field crew as well as various engineering and construction exhibits (e.g. As Built, Development Drawings, Subdivision Drawings, etc.).Assets are only included if they do not reside in a spatial buffer within specific asset types:o Within 100 feet of any dam, outlet tower, or pump stations.o Within 500 feet of any treatment plants.

Service Item Id: 763d60314b094649a50da20990e8545d

Copyright Text: City of San Diego, Public Utilities Department; Asset Management-GIS section

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: 6244856.131883308
YMin: 1777501.7825796455
XMax: 6410394.957629129
YMax: 1989032.5353703052
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [116, 168, 84, 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 )
• fac_seq_num ( modelName: fac_seq_num, nullable: true, editable: true, defaultValue: null, alias: FACSEQNUM, type: esriFieldTypeInteger )
• fac_typ_cd ( modelName: fac_typ_cd, nullable: true, editable: true, defaultValue: null, length: 4, alias: FAC_TYP_CD, type: esriFieldTypeString )
• factypdesc ( modelName: factypdesc, nullable: true, editable: true, defaultValue: null, length: 35, alias: FACTYPDESC, type: esriFieldTypeString )
• infrastructure_typ_cd ( modelName: infrastructure_typ_cd, nullable: true, editable: true, defaultValue: null, length: 2, alias: INFRASTRUC, type: esriFieldTypeString )
• rawind ( modelName: rawind, nullable: true, editable: true, defaultValue: null, length: 1, alias: RAWIND, type: esriFieldTypeString )
• pipe_typ_cd ( modelName: pipe_typ_cd, nullable: true, editable: true, defaultValue: null, length: 5, alias: PIPETYPE, type: esriFieldTypeString )
• pipetyped ( modelName: pipetyped, nullable: true, editable: true, defaultValue: null, length: 25, alias: PIPETYPED, type: esriFieldTypeString )
• lgth_qty ( modelName: lgth_qty, nullable: true, editable: true, defaultValue: null, alias: LENGTH, type: esriFieldTypeInteger )
• insd_diam_size_num ( modelName: insd_diam_size_num, nullable: true, editable: true, defaultValue: null, alias: INSDIAMSZE, type: esriFieldTypeDouble )
• matl_cd ( modelName: matl_cd, nullable: true, editable: true, defaultValue: null, length: 5, alias: MATERIAL, type: esriFieldTypeString )
• materiald ( modelName: materiald, nullable: true, editable: true, defaultValue: null, length: 50, alias: MATERIALD, type: esriFieldTypeString )
• hgl_override_ind ( modelName: hgl_override_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: HGLOVRDIND, type: esriFieldTypeString )
• pressr_class_qty ( modelName: pressr_class_qty, nullable: true, editable: true, defaultValue: null, alias: PRESRCLASS, type: esriFieldTypeInteger )
• pressr_zn_nm ( modelName: pressr_zn_nm, nullable: true, editable: true, defaultValue: null, length: 20, alias: PRESSRZNNM, type: esriFieldTypeString )
• pressr_zn_qty ( modelName: pressr_zn_qty, nullable: true, editable: true, defaultValue: null, alias: PRESSRZNQT, type: esriFieldTypeInteger )
• small_span_ind ( modelName: small_span_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: SMLSPANIND, type: esriFieldTypeString )
• encasement_matl_cd ( modelName: encasement_matl_cd, nullable: true, editable: true, defaultValue: null, length: 5, alias: ENCSMNTMTL, type: esriFieldTypeString )
• easmnt_ind ( modelName: easmnt_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: EASMNTIND, type: esriFieldTypeString )
• lgth_gis_ind ( modelName: lgth_gis_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: LGTHGISIND, type: esriFieldTypeString )
• frctnfctqt ( modelName: frctnfctqt, nullable: true, editable: true, defaultValue: null, alias: FRCTNFCTQT, type: esriFieldTypeInteger )
• mapng_stat_cd ( modelName: mapng_stat_cd, nullable: true, editable: true, defaultValue: null, length: 24, alias: MAPNGSTAT, type: esriFieldTypeString )
• fnctnl_cd ( modelName: fnctnl_cd, nullable: true, editable: true, defaultValue: null, length: 1, alias: FUNCTIONAL, type: esriFieldTypeString )
• ownership_cd ( modelName: ownership_cd, nullable: true, editable: true, defaultValue: null, length: 2, alias: OWNERSHIP, type: esriFieldTypeString )
• ownrshipd ( modelName: ownrshipd, nullable: true, editable: true, defaultValue: null, length: 25, alias: OWNRSHIPD, type: esriFieldTypeString )
• strtadrtyp ( modelName: strtadrtyp, nullable: true, editable: true, defaultValue: null, length: 2, alias: STRTADRTYP, type: esriFieldTypeString )
• div_maint_by_cd ( modelName: div_maint_by_cd, nullable: true, editable: true, defaultValue: null, length: 2, alias: DIVMAINTBY, type: esriFieldTypeString )
• divmainbyd ( modelName: divmainbyd, nullable: true, editable: true, defaultValue: null, length: 25, alias: DIVMAINBYD, type: esriFieldTypeString )
• interceptor_ind ( modelName: interceptor_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: INTERCEPTR, type: esriFieldTypeString )
• sta_prim_num ( modelName: sta_prim_num, nullable: true, editable: true, defaultValue: null, alias: STAPRIM, type: esriFieldTypeDouble )
• sta_scndry_num ( modelName: sta_scndry_num, nullable: true, editable: true, defaultValue: null, alias: STASCNDRY, type: esriFieldTypeDouble )
• fac_name ( modelName: fac_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: FACLTYNAME, type: esriFieldTypeString )
• actl_inst_dt_ind ( modelName: actl_inst_dt_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: ACTLINSTDT, type: esriFieldTypeString )
• inst_dt ( modelName: inst_dt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INSTLDATE, type: esriFieldTypeDate )
• future_size ( modelName: future_size, nullable: true, editable: true, defaultValue: null, length: 5, alias: FUTURESIZE, type: esriFieldTypeString )
• future_matl_cd ( modelName: future_matl_cd, nullable: true, editable: true, defaultValue: null, length: 50, alias: FUTUREMATL, type: esriFieldTypeString )
• locn_desc_txt ( modelName: locn_desc_txt, nullable: true, editable: true, defaultValue: null, length: 150, alias: LOCNDESCPT, type: esriFieldTypeString )
• old_splash1_dwo_id ( modelName: old_splash1_dwo_id, nullable: true, editable: true, defaultValue: null, length: 10, alias: OLDDWOID, type: esriFieldTypeString )
• old_splash1_work_ordr_id ( modelName: old_splash1_work_ordr_id, nullable: true, editable: true, defaultValue: null, length: 10, alias: OLDWRKORDR, type: esriFieldTypeString )
• gps_surveyor_ind ( modelName: gps_surveyor_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: GPSSURVYOR, type: esriFieldTypeString )
• gps_x_coord_num ( modelName: gps_x_coord_num, nullable: true, editable: true, defaultValue: null, alias: GPSXCOORD, type: esriFieldTypeDouble )
• gps_y_coord_num ( modelName: gps_y_coord_num, nullable: true, editable: true, defaultValue: null, alias: GPSYCOORD, type: esriFieldTypeDouble )
• fac_stat_cd ( modelName: fac_stat_cd, nullable: true, editable: true, defaultValue: null, length: 1, alias: FACILSTAT, type: esriFieldTypeString )
• map_id ( modelName: map_id, nullable: true, editable: true, defaultValue: null, alias: MAPID, type: esriFieldTypeInteger )
• fld_bk_page_num ( modelName: fld_bk_page_num, nullable: true, editable: true, defaultValue: null, length: 6, alias: FLDBKPAGE, type: esriFieldTypeString )
• fld_bk_grid_num ( modelName: fld_bk_grid_num, nullable: true, editable: true, defaultValue: null, alias: FLDBKGRID, type: esriFieldTypeInteger )
• thomas_brothers_cd ( modelName: thomas_brothers_cd, nullable: true, editable: true, defaultValue: null, length: 11, alias: THMBRTHERS, type: esriFieldTypeString )
• strtnum ( modelName: strtnum, nullable: true, editable: true, defaultValue: null, alias: STRTNUM, type: esriFieldTypeDouble )
• strtpredir ( modelName: strtpredir, nullable: true, editable: true, defaultValue: null, length: 2, alias: STRTPREDIR, type: esriFieldTypeString )
• strtname ( modelName: strtname, nullable: true, editable: true, defaultValue: null, length: 20, alias: STRTNAME, type: esriFieldTypeString )
• strtsfx ( modelName: strtsfx, nullable: true, editable: true, defaultValue: null, length: 2, alias: STRTSFX, type: esriFieldTypeString )
• strt_unit ( modelName: strt_unit, nullable: true, editable: true, defaultValue: null, length: 8, alias: STRT_UNIT, type: esriFieldTypeString )
• gated_co ( modelName: gated_co, nullable: true, editable: true, defaultValue: null, length: 1, alias: GATED_CO, type: esriFieldTypeString )
• nad83e_num ( modelName: nad83e_num, nullable: true, editable: true, defaultValue: null, alias: NAD83E, type: esriFieldTypeDouble )
• nad83n_num ( modelName: nad83n_num, nullable: true, editable: true, defaultValue: null, alias: NAD83N, type: esriFieldTypeDouble )
• nad27e_num ( modelName: nad27e_num, nullable: true, editable: true, defaultValue: null, alias: NAD27E, type: esriFieldTypeDouble )
• nad27n_num ( modelName: nad27n_num, nullable: true, editable: true, defaultValue: null, alias: NAD27N, type: esriFieldTypeDouble )
• old_fac_seq_num ( modelName: old_fac_seq_num, nullable: true, editable: true, defaultValue: null, alias: OLDFACSQNO, type: esriFieldTypeDouble )
• senstvelnd ( modelName: senstvelnd, nullable: true, editable: true, defaultValue: null, length: 1, alias: SENSTVELND, type: esriFieldTypeString )
• drawg_num ( modelName: drawg_num, nullable: true, editable: true, defaultValue: null, length: 10, alias: DRAWG_NUM, type: esriFieldTypeString )
• drawg_sheet_num ( modelName: drawg_sheet_num, nullable: true, editable: true, defaultValue: null, alias: DRAWGSHTNO, type: esriFieldTypeInteger )
• drawg_typ_cd ( modelName: drawg_typ_cd, nullable: true, editable: true, defaultValue: null, length: 3, alias: DRAWG_TYP, type: esriFieldTypeString )
• drawg_typ_cd_desc ( modelName: drawg_typ_cd_desc, nullable: true, editable: true, defaultValue: null, length: 25, alias: DRAWG_TYPD, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Water_Main_SD
  Description:
  Prototype:
  strtpredir: null
  materiald: null
  pipetyped: null
  pressr_class_qty: null
  pressr_zn_nm: null
  easmnt_ind: null
  inst_dt: null
  lgth_gis_ind: null
  drawg_typ_cd: null
  gps_x_coord_num: null
  fac_stat_cd: null
  future_size: null
  strtnum: null
  strtsfx: null
  small_span_ind: null
  rawind: null
  nad27n_num: null
  sta_scndry_num: null
  old_fac_seq_num: null
  div_maint_by_cd: null
  sta_prim_num: null
  fnctnl_cd: null
  fac_typ_cd: null
  hgl_override_ind: null
  frctnfctqt: null
  ownrshipd: null
  fac_name: null
  actl_inst_dt_ind: null
  insd_diam_size_num: null
  mapng_stat_cd: null
  senstvelnd: null
  infrastructure_typ_cd: null
  ownership_cd: null
  drawg_typ_cd_desc: null
  strtadrtyp: null
  fac_seq_num: null
  drawg_num: null
  fld_bk_page_num: null
  strt_unit: null
  old_splash1_dwo_id: null
  future_matl_cd: null
  fld_bk_grid_num: null
  map_id: null
  matl_cd: null
  nad27e_num: null
  gps_surveyor_ind: null
  thomas_brothers_cd: null
  lgth_qty: null
  pressr_zn_qty: null
  old_splash1_work_ordr_id: null
  encasement_matl_cd: null
  drawg_sheet_num: null
  locn_desc_txt: null
  pipe_typ_cd: null
  nad83e_num: null
  gps_y_coord_num: null
  strtname: null
  divmainbyd: null
  interceptor_ind: null
  gated_co: null
  nad83n_num: null
  factypdesc: 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