View In:   ArcGIS Online Map Viewer

Name: Stormwater Lateral Line

Display Field: CreatedBy

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 4c43de4c2fa642df8eaa0420eeb35104

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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

Supports Datum Transformation: true

Extent:

XMin: 6107800.758576825
YMin: 1949631.1781547219
XMax: 6130769.997087076
YMax: 1978533.046860069
Spatial Reference: 102643  (2227)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LifecycleStatus
Field 2: OWNEDBY
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ACT,1
  Label: Active, City of Sunnyvale
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 115, 223, 255]
  Width: 1
• Value: ACT,2
  Label: Active, Santa Clara County Flood Control (SCCFC)
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 115, 223, 255]
  Width: 1
• Value: ACT,-1
  Label: Active, Private
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 115, 223, 255]
  Width: 1
• Value: ABN,1
  Label: Abandoned, City of Sunnyvale
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [130, 130, 130, 255]
  Width: 1
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: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: LifecycleStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FACILITYID )
• Atlas ( type: esriFieldTypeString, alias: Atlas, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Atlas )
• SeqNo ( type: esriFieldTypeSmallInteger, alias: NO, editable: true, nullable: true, defaultValue: null, modelName: SeqNo )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...33 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [-1: Other] , [0: Unknown] , [0.625: 5/8"] , ...49 more... )
• LINETYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LINETYPE , Coded Values: [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , [SP: Segmented Pipe] , ...11 more... )
• DISTANCE ( type: esriFieldTypeInteger, alias: Distance, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: City of Sunnyvale] , [-1: Private] , [-2: Other] , ...11 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: City of Sunnyvale] , [-1: Private] , [-2: Other] , ...10 more... )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• SLOPE ( type: esriFieldTypeDouble, alias: NominalSlope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• CalculatedSlope ( type: esriFieldTypeDouble, alias: CalculatedSlope, editable: true, nullable: true, defaultValue: null, modelName: CalculatedSlope )
• PipeLength ( type: esriFieldTypeDouble, alias: PipeLength, editable: true, nullable: true, defaultValue: null, modelName: PipeLength )
• Stationing ( type: esriFieldTypeString, alias: Stationing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Stationing )
• LateralType ( type: esriFieldTypeInteger, alias: SubtypeSL, editable: true, nullable: true, defaultValue: 1, modelName: LateralType , Coded Values: [1: LateralLine] , [2: VirtualLine] )
• ProjectNo ( type: esriFieldTypeString, alias: ProjectNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectNo )
• DrawingNumber ( type: esriFieldTypeString, alias: DrawingNumber, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DrawingNumber )
• DrawingSheetNo ( type: esriFieldTypeString, alias: DrawingSheetNo, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DrawingSheetNo )
• DrainageBasin ( type: esriFieldTypeString, alias: DrainageBasin, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DrainageBasin , Coded Values: [Calabazas Creek: Calabazas Creek] , [East Channel: East Channel] , [El Camino Channel: El Camino Channel] , ...2 more... )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 5, defaultValue: ACT, modelName: LifecycleStatus , Coded Values: [ACT: Active] , [ABN: Abandoned] , [CST: Construction] , ...2 more... )
• SourceDocument ( type: esriFieldTypeString, alias: SourceDocument, editable: true, nullable: true, length: 10, defaultValue: DWG, modelName: SourceDocument , Coded Values: [DWG: Record Drawing] , [ASB: AsBuilt] , [ATLAS: Atlas] , ...5 more... )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LocationDescription )
• WorkorderID ( type: esriFieldTypeString, alias: WorkorderID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkorderID )
• PictureLinkID ( type: esriFieldTypeString, alias: PictureLinkID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PictureLinkID )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• Flag ( type: esriFieldTypeString, alias: Flag, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Flag )
• ModelID ( type: esriFieldTypeString, alias: ModelID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ModelID )
• InModel ( type: esriFieldTypeSmallInteger, alias: InModel, editable: true, nullable: true, defaultValue: 0, modelName: InModel , Coded Values: [0: False] , [1: True] )
• MapLibraryLink ( type: esriFieldTypeString, alias: MapLibraryLink, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MapLibraryLink )
• MapLibraryID ( type: esriFieldTypeString, alias: MapLibraryID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MapLibraryID )
• SourceBlocKMapName ( type: esriFieldTypeString, alias: SourceBlocKMapName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceBlocKMapName )
• SourceBlockMapPath ( type: esriFieldTypeString, alias: SourceBlockMapPath, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SourceBlockMapPath )
• LegacyObjID ( type: esriFieldTypeInteger, alias: LegacyObjID, editable: true, nullable: true, defaultValue: null, modelName: LegacyObjID )
• FeatureClassName ( type: esriFieldTypeString, alias: FeatureClassName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeatureClassName )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• VerifiedBy ( type: esriFieldTypeString, alias: Verified By, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VerifiedBy )
• VerifiedDate ( type: esriFieldTypeDate, alias: Verified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VerifiedDate )
• VerificationComments ( type: esriFieldTypeString, alias: Verification Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: VerificationComments )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• GISGUID ( type: esriFieldTypeString, alias: GISGUID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GISGUID )
• PIPESEGMENTREFID ( type: esriFieldTypeString, alias: Pipe Segment Reference Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPESEGMENTREFID )
• TempID ( type: esriFieldTypeString, alias: TempID2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TempID )
• NewObjID ( type: esriFieldTypeInteger, alias: NewObjID, editable: true, nullable: true, defaultValue: null, modelName: NewObjID )
• OutFall ( type: esriFieldTypeSmallInteger, alias: OutFall, editable: true, nullable: true, defaultValue: null, modelName: OutFall )
• SystemInterconnect ( type: esriFieldTypeString, alias: SystemInterconnect, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SystemInterconnect , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: ACT
Name: Active, City of Sunnyvale
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• LINETYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• LateralType:
  Inherited
• DrainageBasin:
  Inherited
• LifecycleStatus:
  Inherited
• SourceDocument:
  Inherited
• InModel:
  Inherited
• SystemInterconnect:
  Inherited
Templates:
• Name: Active, City of Sunnyvale
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  DISTANCE: null
  DrainageBasin: null
  ModelID: null
  MATERIAL: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Stationing: null
  SystemInterconnect: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  INSTALLDATE: null
  DIAMETER: 4
  LINETYPE: null
  MAINTBY: 1
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  CalculatedSlope: null
  PipeLength: null
  LateralType: 1
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  SourceDocument: DWG
  LocationDescription: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  FeatureClassName: null
  NewObjID: null
  TempID: null
  PIPESEGMENTREFID: null
  GISGUID: null
  VerifiedDate: -2208988800000
  VerificationComments: null
  OutFall: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Active, Private
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  DISTANCE: null
  DrainageBasin: null
  ModelID: null
  MATERIAL: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Stationing: null
  SystemInterconnect: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  INSTALLDATE: null
  DIAMETER: 4
  LINETYPE: null
  MAINTBY: 1
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  CalculatedSlope: null
  PipeLength: null
  LateralType: 1
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  SourceDocument: DWG
  LocationDescription: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  FeatureClassName: null
  NewObjID: null
  TempID: null
  PIPESEGMENTREFID: null
  GISGUID: null
  VerifiedDate: -2208988800000
  VerificationComments: null
  OutFall: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: ACT, 2
  Description:
  Prototype:
  SystemInterconnect: null
  OutFall: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  LINETYPE: null
  DISTANCE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 2
  MAINTBY: 1
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  LateralType: 1
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  DrainageBasin: null
  LifecycleStatus: ACT
  SourceDocument: DWG
  LocationDescription: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  ModelID: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  FeatureClassName: null
  TempID: null
  PIPESEGMENTREFID: null
  GISGUID: null
  NewObjID: null
  VerifiedBy: null
  VerifiedDate: null
  VerificationComments: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: ACT, -1
  Description:
  Prototype:
  SystemInterconnect: null
  OutFall: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  LINETYPE: null
  DISTANCE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: -1
  MAINTBY: 1
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  LateralType: 1
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  DrainageBasin: null
  LifecycleStatus: ACT
  SourceDocument: DWG
  LocationDescription: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  ModelID: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  FeatureClassName: null
  TempID: null
  PIPESEGMENTREFID: null
  GISGUID: null
  NewObjID: null
  VerifiedBy: null
  VerifiedDate: null
  VerificationComments: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: ABN
Name: Abandoned, City of Sunnyvale
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• LINETYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• LateralType:
  Inherited
• DrainageBasin:
  Inherited
• LifecycleStatus:
  Inherited
• SourceDocument:
  Inherited
• InModel:
  Inherited
• SystemInterconnect:
  Inherited
Templates:
• Name: Abandoned, City of Sunnyvale
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ABN
  DISTANCE: null
  DrainageBasin: null
  ModelID: null
  MATERIAL: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Stationing: null
  SystemInterconnect: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  INSTALLDATE: null
  DIAMETER: 4
  LINETYPE: null
  MAINTBY: 1
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  CalculatedSlope: null
  PipeLength: null
  LateralType: 1
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  SourceDocument: DWG
  LocationDescription: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  FeatureClassName: null
  NewObjID: null
  TempID: null
  PIPESEGMENTREFID: null
  GISGUID: null
  VerifiedDate: -2208988800000
  VerificationComments: null
  OutFall: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

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: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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