View In:   ArcGIS Online Map Viewer

Name: swInlet

Display Field: AsbuiltNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Stormwater system for the City of La Mesa.This feature class contains data pertaining to inlets within the City of La Mesa. Inlets are points at which water enters the stormwater collection system, and may be one of six types (subtypes): catch basin, headwall, inlet, sump, wall, or unknown.Based on the Esri Simplified Stormwater file geodatabase model; added La Mesa content.

Copyright Text: City of La Mesa, Department of Public Works

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: 6314872.638175473
YMin: 1851694.9973818958
XMax: 6336672.568000719
YMax: 1869870.6332746446
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [173, 3, 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 )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• AsbuiltNumber ( type: esriFieldTypeString, alias: AsbuiltNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AsbuiltNumber )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription , Coded Values: [ESMT: Easement] , [RDES: Roadway and Easement] , [ROAD: Roadway] , ...1 more... )
• SymbolRotation ( type: esriFieldTypeDouble, alias: SymbolRotation, editable: true, nullable: true, defaultValue: 0, modelName: SymbolRotation , Range: [0, 360] )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...1 more... )
• InletDimension ( type: esriFieldTypeString, alias: InletDimension, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletDimension )
• SubtypeCD ( type: esriFieldTypeInteger, alias: Structure, editable: true, nullable: true, defaultValue: 3, modelName: SubtypeCD , Coded Values: [1: Catch Basin] , [2: Headwall] , [3: Inlet] , ...1 more... )
• GroundElevation ( type: esriFieldTypeDouble, alias: Ground Elevation, editable: true, nullable: true, defaultValue: 0, modelName: GroundElevation )
• InvertElevation ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: 0, modelName: InvertElevation )
• StructureType ( type: esriFieldTypeString, alias: Structure Type, editable: true, nullable: true, length: 25, defaultValue: UNK, modelName: StructureType )
• PageNumber ( type: esriFieldTypeString, alias: MapBook Grid Page Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PageNumber , Coded Values: [A04: A-04] , [A05: A-05] , [A06: A-06] , ...68 more... )
• XCoordinate ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: XCoordinate )
• YCoordinate ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: YCoordinate )
• DataSource ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 20, defaultValue: Asbuilt, modelName: DataSource , Coded Values: [Asbuilt: Asbuilt] , [CAD: CAD] , [Redline: Redline] , ...5 more... )
• DataUse ( type: esriFieldTypeString, alias: Data Use, editable: true, nullable: true, length: 15, defaultValue: GIS, modelName: DataUse , Coded Values: [GIS: GIS] , [GIS Only: GIS Only] , [Model Data: Model Data] )
• StructureOwner ( type: esriFieldTypeString, alias: Structure Owner, editable: true, nullable: true, length: 15, defaultValue: null, modelName: StructureOwner , Coded Values: [Caltrans: Caltrans] , [Private: Private] , [San Diego: San Diego] , ...4 more... )
• SubBasinID ( type: esriFieldTypeString, alias: Sub-Basin ID, editable: true, nullable: true, length: 25, defaultValue: UNK, modelName: SubBasinID )
• FilterType ( type: esriFieldTypeString, alias: Filter Type, editable: true, nullable: true, length: 20, defaultValue: NA, modelName: FilterType )
• WidthFlt ( type: esriFieldTypeDouble, alias: WidthFlt, editable: true, nullable: true, defaultValue: null, modelName: WidthFlt )
• EditInitials ( type: esriFieldTypeString, alias: Edit Initials, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EditInitials )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• EditSource ( type: esriFieldTypeString, alias: Edit Source, editable: true, nullable: true, length: 200, defaultValue: null, modelName: EditSource )
• SBASIN ( type: esriFieldTypeString, alias: SBASIN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SBASIN , Coded Values: [A: Alvarado] , [B: University] , [C: Lake Murray] , ...3 more... )
• NEWID ( type: esriFieldTypeInteger, alias: NEWID, editable: true, nullable: true, defaultValue: null, modelName: NEWID )
• SEQID ( type: esriFieldTypeInteger, alias: SEQID, editable: true, nullable: true, defaultValue: null, modelName: SEQID )
• NODEID ( type: esriFieldTypeString, alias: NODEID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NODEID )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• WQFeature ( type: esriFieldTypeSmallInteger, alias: Water Quality Feature, editable: true, nullable: true, defaultValue: null, modelName: WQFeature , Coded Values: [0: False] , [1: True] )
• PILOT_ID ( type: esriFieldTypeString, alias: PILOT_ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PILOT_ID )
• CheckOut ( type: esriFieldTypeString, alias: CheckOut, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CheckOut )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )

Templates:

• Name: PW_GIS.DBO.swInlet
  Description:
  Prototype:
  YCoordinate: null
  DataSource: Asbuilt
  StructureOwner: City
  AncillaryRole: 0
  InletDimension: null
  SymbolRotation: 0
  DataUse: GIS
  GroundElevation: 0
  SubtypeCD: 3
  InvertElevation: 0
  SubBasinID: UNK
  CheckOut: null
  LocationDescription: null
  Enabled: 1
  AsbuiltNumber: null
  InstallDate: null
  LifecycleStatus: Active
  StructureType: UNK
  PageNumber: null
  XCoordinate: null
  FilterType: NA
  WidthFlt: null
  EditInitials: null
  EditDate: null
  EditSource: null
  SBASIN: null
  NEWID: null
  SEQID: null
  NODEID: null
  Notes: null
  WQFeature: null
  PILOT_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

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

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata