View In:   ArcGIS Online Map Viewer

Name: Sewer Cleanout

Display Field: DrawingNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 6107797.697559327
YMin: 1938866.8309170604
XMax: 6129424.845577911
YMax: 1978612.0056916475
Spatial Reference: 102643  (2227)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 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 )
• ACCESSMAT ( type: esriFieldTypeString, alias: Access Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESSMAT , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...33 more... )
• ACCESSTYPE ( type: esriFieldTypeString, alias: Access Type, editable: true, nullable: true, length: 20, defaultValue: Cover, modelName: ACCESSTYPE , Coded Values: [Door: Door] , [Grate: Grate] , [Cover: Manhole Cover] , ...4 more... )
• INTDEPTH ( type: esriFieldTypeDouble, alias: Interior Depth, editable: true, nullable: true, defaultValue: null, modelName: INTDEPTH )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• DEVICETYPE ( type: esriFieldTypeString, alias: Cleanout Type, editable: true, nullable: true, length: 30, defaultValue: Cleanout, modelName: DEVICETYPE , Coded Values: [Cleanout: Cleanout] , [Flushing Structure: Flushing Structure] , [Lamp Hole: Lamp Hole] , ...3 more... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• 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... )
• Stationing ( type: esriFieldTypeString, alias: Stationing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Stationing )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Material )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: 24, modelName: Diameter )
• RimElevation ( type: esriFieldTypeDouble, alias: RimElevation, editable: true, nullable: true, defaultValue: null, modelName: RimElevation )
• OldID ( type: esriFieldTypeString, alias: OldID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OldID )
• InvertElevation ( type: esriFieldTypeDouble, alias: InvertElevation, editable: true, nullable: true, defaultValue: null, modelName: InvertElevation )
• 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 )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• GPS_X ( type: esriFieldTypeDouble, alias: GPS_X, editable: true, nullable: true, defaultValue: null, modelName: GPS_X )
• GPS_Y ( type: esriFieldTypeDouble, alias: GPS_Y, editable: true, nullable: true, defaultValue: null, modelName: GPS_Y )
• GPS_Z ( type: esriFieldTypeDouble, alias: GPS_Z, editable: true, nullable: true, defaultValue: null, modelName: GPS_Z )
• 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 )
• LocatedIn ( type: esriFieldTypeString, alias: LocatedIn, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocatedIn )

Templates:

• Name: ssCleanout
  Description:
  Prototype:
  VerifiedBy: null
  LifecycleStatus: ACT
  ROTATION: null
  SubBasin: null
  ModelID: null
  Material: null
  ACCESSMAT: null
  INSTALLDATE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  GISGUID: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  ACCESSTYPE: Cover
  INTDEPTH: null
  DEVICETYPE: Cleanout
  LOCDESC: null
  MAINTBY: 1
  Stationing: null
  Diameter: 24
  RimElevation: null
  OldID: null
  InvertElevation: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SourceDocument: DWG
  ContourElevation: null
  GPSDATE: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: 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
  LocatedIn: null
  VerificationComments: null
  VerifiedDate: -2208988800000
  
  Drawing Tool: esriFeatureEditToolPoint

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