View In:   ArcGIS Online Map Viewer

Name: SuffolkGIS.DBO.Stormwater_Structures

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 31452ec793334ce5a80c8f8019b351bd

Copyright Text:

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

Supports Datum Transformation: true

Extent:

XMin: 1.19437626457528E7
YMin: 3363906.37474026
XMax: 1.20968556937673E7
YMax: 3508936.38466734
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [145, 62, 173, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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

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 )
• STR_ID_PMI ( type: esriFieldTypeString, alias: STR_ID_PMI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STR_ID_PMI )
• STR_ID ( type: esriFieldTypeString, alias: STR_ID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: STR_ID )
• STR_ID_K ( type: esriFieldTypeString, alias: STR_ID_K, editable: true, nullable: true, length: 11, defaultValue: null, modelName: STR_ID_K )
• GRID ( type: esriFieldTypeString, alias: GRID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GRID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE , Coded Values: [BMP_DOWN: BMP Outfall Downstream] , [BMP_UP: BMP Outfall Upstream] , [CB: Catch Basin] , ...26 more... )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CONDITION , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...3 more... )
• RIM ( type: esriFieldTypeDouble, alias: RIM, editable: true, nullable: true, defaultValue: null, modelName: RIM )
• SUMP ( type: esriFieldTypeDouble, alias: SUMP, editable: true, nullable: true, defaultValue: null, modelName: SUMP )
• EAST ( type: esriFieldTypeDouble, alias: EAST, editable: true, nullable: true, defaultValue: null, modelName: EAST )
• NORTH ( type: esriFieldTypeDouble, alias: NORTH, editable: true, nullable: true, defaultValue: null, modelName: NORTH )
• FIELD_SURV ( type: esriFieldTypeDate, alias: FIELD_SURV, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIELD_SURV )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: INSPECTOR , Coded Values: [BR: Beth Ross] , [JW: Jeanetta Williams] , [CM: Chris Maxwell] , ...21 more... )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENT )
• PMI_STRUCT_REPORT ( type: esriFieldTypeString, alias: PMI FIELD REPORT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PMI_STRUCT_REPORT )
• PROJECT ( type: esriFieldTypeString, alias: PLANNING APPLICATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROJECT )
• STATUS ( type: esriFieldTypeString, alias: DEVELOPMENT STATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATUS , Coded Values: [APP: Approved] , [AB: AsBuilt] , [GPS: GPS Located] , ...2 more... )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• OUTFALL_CLASS ( type: esriFieldTypeString, alias: OUTFALL_CLASS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OUTFALL_CLASS , Coded Values: [MAJOR: Major Outfall] , [MINOR: Minor Outfall] , [N/A: Structure not Outfall] , ...3 more... )
• PHOTOLINK ( type: esriFieldTypeString, alias: PHOTOLINK, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PHOTOLINK )
• QC_DATE ( type: esriFieldTypeString, alias: QC_DATE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QC_DATE )
• QC_COMP_BY ( type: esriFieldTypeString, alias: QC_COMP_BY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QC_COMP_BY )
• QC_COMMENTS ( type: esriFieldTypeString, alias: QC_COMMENTS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: QC_COMMENTS )
• INVENTORY ( type: esriFieldTypeString, alias: INVENTORY, editable: true, nullable: true, length: 25, defaultValue: UNKNOWN, modelName: INVENTORY , Coded Values: [NOT FOUND: Not Found] , [NO ACCESS: Not Accessible] , [BURIED: Buried] , ...5 more... )
• ACCURACY ( type: esriFieldTypeString, alias: ACCURACY, editable: true, nullable: true, length: 10, defaultValue: UNKNOWN, modelName: ACCURACY , Coded Values: [RTK: Located using Real Time Kenematic GPS] , [TS: Located using Total Station] , [PLAN: Located from Plan Set] , ...5 more... )
• CONSTRUCTION ( type: esriFieldTypeString, alias: CONSTRUCTION, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: CONSTRUCTION , Coded Values: [PRC: Precast Concrete] , [CONC: Field Concrete] , [BRK_BLK: Brick/Block] , ...7 more... )
• RIP_RAPCND ( type: esriFieldTypeString, alias: RIP_RAPCND, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RIP_RAPCND , Coded Values: [NOT PRESENT: Not Present] , [STNGOOD: Stone in Good Condition] , [STNRPR: Stone in Need of Repair] , ...4 more... )
• CONC_CND ( type: esriFieldTypeString, alias: CONC_CND, editable: true, nullable: true, length: 20, defaultValue: N/A, modelName: CONC_CND , Coded Values: [MINOR: Minor Cracking - Hairline] , [MAJOR: Major Cracking - Greater than 1/4 inch] , [N/A: Not Applicable] , ...3 more... )
• METL_CND ( type: esriFieldTypeString, alias: METL_CND, editable: true, nullable: true, length: 20, defaultValue: N/A, modelName: METL_CND , Coded Values: [N/A: Not applicable to Structure] , [SURFACE: Light Surface Rust] , [SEVERE: Severe Rust] , ...3 more... )
• CLEAN ( type: esriFieldTypeString, alias: CLEAN, editable: true, nullable: true, length: 10, defaultValue: UNKNOWN, modelName: CLEAN , Coded Values: [CLEAR: Clear] , [UNKNOWN: Unknown] , [MINOR: Minor Debris Noted] , ...1 more... )
• FL_FLOAT ( type: esriFieldTypeString, alias: FL_FLOAT, editable: true, nullable: true, length: 10, defaultValue: NONE, modelName: FL_FLOAT , Coded Values: [NONE: None] , [OIL: Oil Sheen Found] , [UNK: Unknown] )
• FACILITYID ( type: esriFieldTypeString, alias: CITYWORKS_FACILITY_ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• PWZONE ( type: esriFieldTypeString, alias: CITYWORKS_ZONE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PWZONE )
• LOCATION ( type: esriFieldTypeString, alias: CITYWORKS_LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: CITYWORKS_INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• WATERSHED ( type: esriFieldTypeString, alias: WATERSHED, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WATERSHED , Coded Values: [JR: James River] , [CH: Chowan River] , [GD: Great Dismal] )
• THROATWIDTH_FT ( type: esriFieldTypeDouble, alias: THROATWIDTH_FT, editable: true, nullable: true, defaultValue: null, modelName: THROATWIDTH_FT )
• SESSIONID ( type: esriFieldTypeString, alias: SESSIONID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SESSIONID )
• LRID ( type: esriFieldTypeString, alias: LRID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LRID )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETNAME )
• TRAFFICDIR ( type: esriFieldTypeString, alias: TRAFFICDIR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TRAFFICDIR )
• SIDE ( type: esriFieldTypeString, alias: TRAFFICDIR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIDE )
• CAPMETHOD ( type: esriFieldTypeSmallInteger, alias: CAPMETHOD, editable: true, nullable: true, defaultValue: null, modelName: CAPMETHOD )
• MODIFYDATE ( type: esriFieldTypeDate, alias: MODIFYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MODIFYDATE )
• FROMMILE ( type: esriFieldTypeDouble, alias: FROMMILE, editable: true, nullable: true, defaultValue: null, modelName: FROMMILE )
• IMAGESEQ ( type: esriFieldTypeInteger, alias: IMAGESEQ, editable: true, nullable: true, defaultValue: null, modelName: IMAGESEQ )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• OFFSET ( type: esriFieldTypeDouble, alias: OFFSET, editable: true, nullable: true, defaultValue: null, modelName: OFFSET )
• IMGNAME ( type: esriFieldTypeString, alias: IMGNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IMGNAME )
• CAMINDEX ( type: esriFieldTypeSmallInteger, alias: CAMINDEX, editable: true, nullable: true, defaultValue: null, modelName: CAMINDEX )
• FACEDIR ( type: esriFieldTypeDouble, alias: FACEDIR, editable: true, nullable: true, defaultValue: null, modelName: FACEDIR )
• HEADING ( type: esriFieldTypeDouble, alias: HEADING, editable: true, nullable: true, defaultValue: null, modelName: HEADING )
• SDE_EDITOR ( type: esriFieldTypeString, alias: SDE_EDITOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SDE_EDITOR )
• DATE_EDIT ( type: esriFieldTypeDate, alias: DATE_EDIT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_EDIT )
• RECEIVING_CHANNEL ( type: esriFieldTypeString, alias: RECEIVING_CHANNEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RECEIVING_CHANNEL , Coded Values: [BLW: BLACKWATER RIVER] , [BEA: BEAMONS MILL POND] , [BEN: BENNETTS CREEK] , ...39 more... )
• TMDL ( type: esriFieldTypeString, alias: TMDL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TMDL )
• 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 )
• Constructed ( type: esriFieldTypeString, alias: Constructed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Constructed , Coded Values: [CONCEP: Conceptual] , [CONSTR: Constructed] )

Templates:

• Name: SuffolkGIS.DBO.Stormwater_Structures
  Description:
  Prototype:
  TMDL: null
  Constructed: null
  STR_ID_PMI: null
  STR_ID: null
  STR_ID_K: null
  GRID: null
  TYPE: null
  CONDITION: null
  RIM: null
  SUMP: null
  EAST: null
  NORTH: null
  FIELD_SURV: null
  INSPECTOR: null
  COMMENT: null
  PMI_STRUCT_REPORT: null
  PROJECT: null
  STATUS: null
  DIAMETER: null
  OUTFALL_CLASS: null
  PHOTOLINK: null
  QC_DATE: null
  QC_COMP_BY: null
  QC_COMMENTS: null
  INVENTORY: UNKNOWN
  ACCURACY: UNKNOWN
  CONSTRUCTION: UNKNOWN
  RIP_RAPCND: null
  CONC_CND: N/A
  METL_CND: N/A
  CLEAN: UNKNOWN
  FL_FLOAT: NONE
  FACILITYID: null
  PWZONE: null
  LOCATION: null
  INSTALLDATE: null
  WATERSHED: null
  THROATWIDTH_FT: null
  SESSIONID: null
  LRID: null
  STREETNAME: null
  TRAFFICDIR: null
  SIDE: null
  CAPMETHOD: null
  MODIFYDATE: null
  FROMMILE: null
  IMAGESEQ: null
  LATITUDE: null
  LONGITUDE: null
  X: null
  Y: null
  OFFSET: null
  IMGNAME: null
  CAMINDEX: null
  FACEDIR: null
  HEADING: null
  SDE_EDITOR: null
  DATE_EDIT: null
  RECEIVING_CHANNEL: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

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

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata