View In:   ArcGIS Online Map Viewer

Name: Sewer Service Lateral Abandoned

Display Field: ProjectNo

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: 5000.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: 6106926.73670283
YMin: 1938866.8309170604
XMax: 6130898.90299724
YMax: 1978353.6656571478
Spatial Reference: 102643  (2227)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [156, 156, 156, 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: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

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: 20, 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 )
• Tract ( type: esriFieldTypeString, alias: Tract, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Tract )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• 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... )
• 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... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCDESC )
• 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... )
• DISTANCE ( type: esriFieldTypeInteger, alias: Distance, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• 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... )
• NominalSlope ( type: esriFieldTypeDouble, alias: NominalSlope, editable: true, nullable: true, defaultValue: null, modelName: NominalSlope )
• 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: 20, defaultValue: null, modelName: Stationing )
• USElevation ( type: esriFieldTypeDouble, alias: USElevation, editable: true, nullable: true, defaultValue: null, modelName: USElevation )
• DSElevation ( type: esriFieldTypeDouble, alias: DSElevation, editable: true, nullable: true, defaultValue: null, modelName: DSElevation )
• 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 )
• Basin ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Basin , Coded Values: [1: Basin1] , [2: Basin2] , [3: Basin3] , ...2 more... )
• SubBasin ( type: esriFieldTypeString, alias: SubBasin, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SubBasin , Coded Values: [SB1: SubBasin1] , [SB2: SubBasin2] )
• 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... )
• ContourElevation ( type: esriFieldTypeDouble, alias: ContourElevation, editable: true, nullable: true, defaultValue: null, modelName: ContourElevation )
• 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 )
• TempID ( type: esriFieldTypeString, alias: TempID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TempID )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Templates:

• Name: Abandoned, City of Sunnyvale
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ABN
  WATERTYPE: null
  SubBasin: null
  ModelID: null
  LOCDESC: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PIPESEGMENTREFID: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  InstallYear: null
  INSTALLDATE: null
  MATERIAL: null
  LINETYPE: null
  DIAMETER: 4
  DISTANCE: null
  MAINTBY: 1
  NominalSlope: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  USElevation: null
  DSElevation: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SourceDocument: DWG
  ContourElevation: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  TempID: null
  FeatureClassName: null
  GISGUID: null
  VerificationComments: null
  VerifiedDate: -2208988800000
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Active, City of Santa Clara
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  WATERTYPE: null
  SubBasin: null
  ModelID: null
  LOCDESC: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PIPESEGMENTREFID: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  InstallYear: null
  INSTALLDATE: null
  MATERIAL: null
  LINETYPE: null
  DIAMETER: 4
  DISTANCE: null
  MAINTBY: 1
  NominalSlope: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  USElevation: null
  DSElevation: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SourceDocument: DWG
  ContourElevation: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  TempID: null
  FeatureClassName: null
  GISGUID: null
  VerificationComments: null
  VerifiedDate: -2208988800000
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Active, City of Sunnyvale
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  WATERTYPE: null
  SubBasin: null
  ModelID: null
  LOCDESC: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PIPESEGMENTREFID: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  InstallYear: null
  INSTALLDATE: null
  MATERIAL: null
  LINETYPE: null
  DIAMETER: 4
  DISTANCE: null
  MAINTBY: 1
  NominalSlope: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  USElevation: null
  DSElevation: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SourceDocument: DWG
  ContourElevation: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  TempID: null
  FeatureClassName: null
  GISGUID: null
  VerificationComments: null
  VerifiedDate: -2208988800000
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Active, Private
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  WATERTYPE: null
  SubBasin: null
  ModelID: null
  LOCDESC: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PIPESEGMENTREFID: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  InstallYear: null
  INSTALLDATE: null
  MATERIAL: null
  LINETYPE: null
  DIAMETER: 4
  DISTANCE: null
  MAINTBY: 1
  NominalSlope: null
  CalculatedSlope: null
  PipeLength: null
  Stationing: null
  USElevation: null
  DSElevation: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SourceDocument: DWG
  ContourElevation: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  TempID: null
  FeatureClassName: null
  GISGUID: null
  VerificationComments: null
  VerifiedDate: -2208988800000
  
  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