View In:   ArcGIS Online Map Viewer

Name: DPW.DBO.SMVSTRUCG

Display Field: SNG_ST_NO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3ee05d26c7e248e2a5eff266ea4ec50c

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: -115860600
YMin: -93269500
XMax: 6245263.838965
YMax: 1930906.620131
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [92, 163, 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:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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 )
• SNG_ST_NO ( type: esriFieldTypeString, alias: Structre_Num, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SNG_ST_NO_ )
• SNG_INVELE ( type: esriFieldTypeDouble, alias: Invert_Elev, editable: true, nullable: true, defaultValue: null, modelName: SNG_INVELE_ )
• SNG_DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: SNG_DEPTH__ )
• SNG_RIM_ELE ( type: esriFieldTypeDouble, alias: Rim_Elev, editable: true, nullable: true, defaultValue: null, modelName: SNG_RIM_ELE_ )
• SNG_TYPE_CD ( type: esriFieldTypeSmallInteger, alias: Struct_Type, editable: true, nullable: true, defaultValue: null, modelName: SNG_TYPE_CD_ , Coded Values: [11: Catch Basin] , [22: Inlet] , [23: Junction] , ...8 more... )
• SNG_Locatio ( type: esriFieldTypeString, alias: General_Loc, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SNG_Locatio_ )
• SNG_ID ( type: esriFieldTypeInteger, alias: Struct_Rec_Num, editable: true, nullable: true, defaultValue: null, modelName: SNG_ID_ )
• SNG_FUNC_CD ( type: esriFieldTypeSmallInteger, alias: Owner, editable: true, nullable: true, defaultValue: null, modelName: SNG_FUNC_CD_ , Coded Values: [6: Capitola] , [5: Santa Cruz] , [4: Scotts Valley] , ...13 more... )
• SNG_SEWSTRC ( type: esriFieldTypeSmallInteger, alias: NPDES_Cleaning, editable: true, nullable: true, defaultValue: null, modelName: SNG_SEWSTRC_ )
• SNG_LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: SNG_LENGTH_ )
• SNG_WIDTH ( type: esriFieldTypeDouble, alias: WIDTH, editable: true, nullable: true, defaultValue: null, modelName: SNG_WIDTH_ )
• SNG_X ( type: esriFieldTypeDouble, alias: SNG_X, editable: true, nullable: true, defaultValue: null, modelName: SNG_X_ )
• SNG_Y ( type: esriFieldTypeDouble, alias: SNG_Y, editable: true, nullable: true, defaultValue: null, modelName: SNG_Y_ )
• DESCR ( type: esriFieldTypeString, alias: DESCR, editable: true, nullable: true, length: 240, defaultValue: null, modelName: DESCR_ )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 240, defaultValue: null, modelName: SOURCE_ )
• NODE_TYPE ( type: esriFieldTypeString, alias: NODE_TYPE, editable: true, nullable: true, length: 16, defaultValue: null, modelName: NODE_TYPE )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Flow_Rate_CFS ( type: esriFieldTypeDouble, alias: Flow_Rate, editable: true, nullable: true, defaultValue: null, modelName: Flow_Rate_CFS )
• New_ID ( type: esriFieldTypeString, alias: New_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: New_ID )
• SNG_STYPE_CD ( type: esriFieldTypeSmallInteger, alias: SNG_STYPE_CD, editable: true, nullable: true, defaultValue: null, modelName: SNG_STYPE_CD , Coded Values: [1: Semi-Impervious Surfaces] , [2: Bio-Retention] , [3: Detention] , ...3 more... )
• SNG_USER28 ( type: esriFieldTypeDouble, alias: PostMiles, editable: true, nullable: true, defaultValue: null, modelName: SNG_USER28 )
• SNG_ADR_STR ( type: esriFieldTypeString, alias: SN_ADR_STR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SNG_ADR_STR , Coded Values: [10TH AV: 10TH AV] , [11TH AV: 11TH AV] , [12TH AV: 12TH AV] , ...1045 more... )
• SNG_OT_CD ( type: esriFieldTypeSmallInteger, alias: Outlet/Inlet Type, editable: true, nullable: true, defaultValue: null, modelName: SNG_OT_CD , Coded Values: [1: Open Pipe] , [2: Headwall] , [3: Box] , ...1 more... )
• SNG_USER8 ( type: esriFieldTypeDouble, alias: Sequence_Number, editable: true, nullable: true, defaultValue: null, modelName: SNG_USER8 )
• OLD_STRUCTURE_NUMBER ( type: esriFieldTypeString, alias: OLD_STRUCTURE_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OLD_STRUCTURE_NUMBER )
• MARKERED ( type: esriFieldTypeString, alias: MARKERED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MARKERED )
• SNG_STAT_CD ( type: esriFieldTypeSmallInteger, alias: SNG_STAT_CD, editable: true, nullable: true, defaultValue: null, modelName: SNG_STAT_CD )
• SNG_MZONE_CD ( type: esriFieldTypeString, alias: SNG_MZONE_CD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SNG_MZONE_CD )
• CNG_DIA ( type: esriFieldTypeInteger, alias: CNG_DIA, editable: true, nullable: true, defaultValue: null, modelName: CNG_DIA )
• CNG_INSP_CD ( type: esriFieldTypeString, alias: CNG_INSP_CD, editable: true, nullable: true, length: 50, defaultValue: Condition, modelName: CNG_INSP_CD )
• CNG_MART_CD ( type: esriFieldTypeSmallInteger, alias: CNG_MART_CD, editable: true, nullable: true, defaultValue: 0, modelName: CNG_MART_CD )
• CNG_TTYP_CD ( type: esriFieldTypeSmallInteger, alias: CNG_TTYP_CD, editable: true, nullable: true, defaultValue: 0, modelName: CNG_TTYP_CD )

Templates:

• Name: DPW.DBO.SMVSTRUCG
  Description:
  Prototype:
  CNG_MART_CD: 0
  CNG_TTYP_CD: 0
  SNG_ST_NO: null
  SNG_INVELE: null
  SNG_DEPTH: null
  SNG_RIM_ELE: null
  SNG_TYPE_CD: null
  SNG_Locatio: null
  SNG_ID: null
  SNG_FUNC_CD: null
  SNG_SEWSTRC: null
  SNG_LENGTH: null
  SNG_WIDTH: null
  SNG_X: null
  SNG_Y: null
  DESCR: null
  SOURCE: null
  NODE_TYPE: null
  Manufacturer: null
  Flow_Rate_CFS: null
  New_ID: null
  SNG_STYPE_CD: null
  SNG_USER28: null
  SNG_ADR_STR: null
  SNG_OT_CD: null
  SNG_USER8: null
  OLD_STRUCTURE_NUMBER: null
  MARKERED: null
  SNG_STAT_CD: null
  SNG_MZONE_CD: null
  CNG_DIA: null
  CNG_INSP_CD: Condition
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Uploads,Editing

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   Query Analytic   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata