View In:   ArcGIS Online Map Viewer

Parent Layer: StormWater

Name: PW Stormwater_Structures

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2b86c4dbf2c24757aaff3c8e67c26f51

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.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: -8559885.10181919
YMin: 4376640.611225247
XMax: -8505403.613048999
YMax: 4428061.001309633
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 255, 0, 255]
Size: 4.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:

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 ( modelName: OBJECTID, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• str_id_pmi ( modelName: STR_ID_PMI, nullable: true, editable: true, defaultValue: null, length: 254, alias: STR_ID_PMI, type: esriFieldTypeString )
• str_id ( modelName: STR_ID, nullable: true, editable: true, defaultValue: null, length: 11, alias: STR_ID, type: esriFieldTypeString )
• str_id_k ( modelName: STR_ID_K, nullable: true, editable: true, defaultValue: null, length: 11, alias: STR_ID_K, type: esriFieldTypeString )
• grid ( modelName: GRID, nullable: true, editable: true, defaultValue: null, length: 50, alias: GRID, type: esriFieldTypeString )
• type ( modelName: TYPE, nullable: true, editable: true, defaultValue: null, length: 254, alias: TYPE, type: esriFieldTypeString , Coded Values: [BMP_DOWN: BMP Outfall Downstream] , [BMP_UP: BMP Outfall Upstream] , [CB: Catch Basin] , ...26 more... )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, length: 254, alias: CONDITION, type: esriFieldTypeString , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...3 more... )
• rim ( modelName: RIM, nullable: true, editable: true, defaultValue: null, alias: RIM, type: esriFieldTypeDouble )
• sump ( modelName: SUMP, nullable: true, editable: true, defaultValue: null, alias: SUMP, type: esriFieldTypeDouble )
• east ( modelName: EAST, nullable: true, editable: true, defaultValue: null, alias: EAST, type: esriFieldTypeDouble )
• north ( modelName: NORTH, nullable: true, editable: true, defaultValue: null, alias: NORTH, type: esriFieldTypeDouble )
• field_surv ( modelName: FIELD_SURV, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FIELD_SURV, type: esriFieldTypeDate )
• inspector ( modelName: INSPECTOR, nullable: true, editable: true, defaultValue: null, length: 254, alias: INSPECTOR, type: esriFieldTypeString , Coded Values: [BR: Beth Ross] , [JW: Jeanetta Williams] , [CM: Chris Maxwell] , ...21 more... )
• comment ( modelName: COMMENT, nullable: true, editable: true, defaultValue: null, length: 254, alias: COMMENT, type: esriFieldTypeString )
• pmi_struct_report ( modelName: PMI_STRUCT_REPORT, nullable: true, editable: true, defaultValue: null, length: 100, alias: PMI FIELD REPORT, type: esriFieldTypeString )
• project ( modelName: PROJECT, nullable: true, editable: true, defaultValue: null, length: 20, alias: PLANNING APPLICATION, type: esriFieldTypeString )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 10, alias: DEVELOPMENT STATUS, type: esriFieldTypeString , Coded Values: [APP: Approved] , [AB: AsBuilt] , [GPS: GPS Located] , ...2 more... )
• diameter ( modelName: DIAMETER, nullable: true, editable: true, defaultValue: null, alias: DIAMETER, type: esriFieldTypeSmallInteger )
• outfall_class ( modelName: OUTFALL_CLASS, nullable: true, editable: true, defaultValue: null, length: 10, alias: OUTFALL_CLASS, type: esriFieldTypeString , Coded Values: [MAJOR: Major Outfall] , [MINOR: Minor Outfall] , [N/A: Structure not Outfall] , ...3 more... )
• photolink ( modelName: PHOTOLINK, nullable: true, editable: true, defaultValue: null, length: 100, alias: PHOTOLINK, type: esriFieldTypeString )
• qc_date ( modelName: QC_DATE, nullable: true, editable: true, defaultValue: null, length: 50, alias: QC_DATE, type: esriFieldTypeString )
• qc_comp_by ( modelName: QC_COMP_BY, nullable: true, editable: true, defaultValue: null, length: 10, alias: QC_COMP_BY, type: esriFieldTypeString )
• qc_comments ( modelName: QC_COMMENTS, nullable: true, editable: true, defaultValue: null, length: 150, alias: QC_COMMENTS, type: esriFieldTypeString )
• inventory ( modelName: INVENTORY, nullable: true, editable: true, defaultValue: UNKNOWN, length: 25, alias: INVENTORY, type: esriFieldTypeString , Coded Values: [NOT FOUND: Not Found] , [NO ACCESS: Not Accessible] , [BURIED: Buried] , ...5 more... )
• accuracy ( modelName: ACCURACY, nullable: true, editable: true, defaultValue: UNKNOWN, length: 10, alias: ACCURACY, type: esriFieldTypeString , Coded Values: [RTK: Located using Real Time Kenematic GPS] , [TS: Located using Total Station] , [PLAN: Located from Plan Set] , ...5 more... )
• construction ( modelName: CONSTRUCTION, nullable: true, editable: true, defaultValue: UNKNOWN, length: 20, alias: CONSTRUCTION, type: esriFieldTypeString , Coded Values: [PRC: Precast Concrete] , [CONC: Field Concrete] , [BRK_BLK: Brick/Block] , ...7 more... )
• rip_rapcnd ( modelName: RIP_RAPCND, nullable: true, editable: true, defaultValue: null, length: 20, alias: RIP_RAPCND, type: esriFieldTypeString , Coded Values: [NOT PRESENT: Not Present] , [STNGOOD: Stone in Good Condition] , [STNRPR: Stone in Need of Repair] , ...4 more... )
• conc_cnd ( modelName: CONC_CND, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: CONC_CND, type: esriFieldTypeString , Coded Values: [MINOR: Minor Cracking - Hairline] , [MAJOR: Major Cracking - Greater than 1/4 inch] , [N/A: Not Applicable] , ...3 more... )
• metl_cnd ( modelName: METL_CND, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: METL_CND, type: esriFieldTypeString , Coded Values: [N/A: Not applicable to Structure] , [SURFACE: Light Surface Rust] , [SEVERE: Severe Rust] , ...3 more... )
• clean ( modelName: CLEAN, nullable: true, editable: true, defaultValue: UNKNOWN, length: 10, alias: CLEAN, type: esriFieldTypeString , Coded Values: [CLEAR: Clear] , [UNKNOWN: Unknown] , [MINOR: Minor Debris Noted] , ...1 more... )
• fl_float ( modelName: FL_FLOAT, nullable: true, editable: true, defaultValue: NONE, length: 10, alias: FL_FLOAT, type: esriFieldTypeString , Coded Values: [NONE: None] , [OIL: Oil Sheen Found] , [UNK: Unknown] )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 30, alias: CITYWORKS_FACILITY_ID, type: esriFieldTypeString )
• pwzone ( modelName: PWZONE, nullable: true, editable: true, defaultValue: null, length: 5, alias: CITYWORKS_ZONE, type: esriFieldTypeString )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 50, alias: CITYWORKS_LOCATION, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CITYWORKS_INSTALL_DATE, type: esriFieldTypeDate )
• watershed ( modelName: WATERSHED, nullable: true, editable: true, defaultValue: null, length: 2, alias: WATERSHED, type: esriFieldTypeString , Coded Values: [JR: James River] , [CH: Chowan River] , [GD: Great Dismal] )
• throatwidth_ft ( modelName: THROATWIDTH_FT, nullable: true, editable: true, defaultValue: null, alias: THROATWIDTH_FT, type: esriFieldTypeDouble )
• sessionid ( modelName: SESSIONID, nullable: true, editable: true, defaultValue: null, length: 50, alias: SESSIONID, type: esriFieldTypeString )
• lrid ( modelName: LRID, nullable: true, editable: true, defaultValue: null, length: 50, alias: LRID, type: esriFieldTypeString )
• streetname ( modelName: STREETNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: STREETNAME, type: esriFieldTypeString )
• trafficdir ( modelName: TRAFFICDIR, nullable: true, editable: true, defaultValue: null, length: 20, alias: TRAFFICDIR, type: esriFieldTypeString )
• side ( modelName: SIDE, nullable: true, editable: true, defaultValue: null, length: 50, alias: TRAFFICDIR, type: esriFieldTypeString )
• capmethod ( modelName: CAPMETHOD, nullable: true, editable: true, defaultValue: null, alias: CAPMETHOD, type: esriFieldTypeSmallInteger )
• modifydate ( modelName: MODIFYDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: MODIFYDATE, type: esriFieldTypeDate )
• frommile ( modelName: FROMMILE, nullable: true, editable: true, defaultValue: null, alias: FROMMILE, type: esriFieldTypeDouble )
• imageseq ( modelName: IMAGESEQ, nullable: true, editable: true, defaultValue: null, alias: IMAGESEQ, type: esriFieldTypeInteger )
• latitude ( modelName: LATITUDE, nullable: true, editable: true, defaultValue: null, alias: LATITUDE, type: esriFieldTypeDouble )
• longitude ( modelName: LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE, type: esriFieldTypeDouble )
• x ( modelName: X, nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( modelName: Y, nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• offset_ ( modelName: OFFSET, nullable: true, editable: true, defaultValue: null, alias: OFFSET, type: esriFieldTypeDouble )
• imgname ( modelName: IMGNAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: IMGNAME, type: esriFieldTypeString )
• camindex ( modelName: CAMINDEX, nullable: true, editable: true, defaultValue: null, alias: CAMINDEX, type: esriFieldTypeSmallInteger )
• facedir ( modelName: FACEDIR, nullable: true, editable: true, defaultValue: null, alias: FACEDIR, type: esriFieldTypeDouble )
• heading ( modelName: HEADING, nullable: true, editable: true, defaultValue: null, alias: HEADING, type: esriFieldTypeDouble )
• sde_editor ( modelName: SDE_EDITOR, nullable: true, editable: true, defaultValue: null, length: 30, alias: SDE_EDITOR, type: esriFieldTypeString )
• date_edit ( modelName: DATE_EDIT, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DATE_EDIT, type: esriFieldTypeDate )
• receiving_channel ( modelName: RECEIVING_CHANNEL, nullable: true, editable: true, defaultValue: null, length: 50, alias: RECEIVING_CHANNEL, type: esriFieldTypeString , Coded Values: [BLW: BLACKWATER RIVER] , [BEA: BEAMONS MILL POND] , [BEN: BENNETTS CREEK] , ...39 more... )
• tmdl ( modelName: TMDL, nullable: true, editable: true, defaultValue: null, length: 254, alias: TMDL, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• constructed ( modelName: Constructed, nullable: true, editable: true, defaultValue: null, length: 50, alias: Constructed, type: esriFieldTypeString , Coded Values: [CONCEP: Conceptual] , [CONSTR: Constructed] )

Templates:

• Name: PW Stormwater_Structures
  Description:
  Prototype:
  watershed: null
  facilityid: null
  installdate: null
  imgname: null
  streetname: null
  conc_cnd: N/A
  project: null
  accuracy: UNKNOWN
  sessionid: null
  type: null
  receiving_channel: null
  lrid: null
  diameter: null
  rim: null
  offset_: null
  longitude: null
  trafficdir: null
  str_id_pmi: null
  field_surv: null
  throatwidth_ft: null
  camindex: null
  condition: null
  sump: null
  rip_rapcnd: null
  outfall_class: null
  str_id: null
  status: null
  qc_date: null
  qc_comp_by: null
  north: null
  latitude: null
  inventory: UNKNOWN
  east: null
  photolink: null
  modifydate: null
  sde_editor: null
  qc_comments: null
  pwzone: null
  date_edit: null
  construction: UNKNOWN
  pmi_struct_report: null
  side: null
  constructed: null
  frommile: null
  heading: null
  fl_float: NONE
  imageseq: null
  inspector: null
  metl_cnd: N/A
  clean: UNKNOWN
  facedir: null
  grid: null
  tmdl: null
  x: null
  y: null
  comment: null
  location: null
  str_id_k: null
  capmethod: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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

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