View In:   ArcGIS Online Map Viewer

Name: Sewer Fitting

Display Field: DrawingNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4c43de4c2fa642df8eaa0420eeb35104

Copyright Text:

Default Visibility: false

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: 6107263.183208406
YMin: 1938881.1074633151
XMax: 6131136.280475244
YMax: 1979336.1922353953
Spatial Reference: 102643  (2227)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FITTINGTYPE
Field 2: LifecycleStatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Cap,ACT
  Label: Cap, Active
  Description: N/A
  Symbol:
  
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: FITTINGTYPE

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 )
• Tract ( type: esriFieldTypeString, alias: Tract, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Tract )
• FITTINGTYPE ( type: esriFieldTypeString, alias: Fitting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FITTINGTYPE , Coded Values: [Bend: Bend] , [Cap: Cap] , [Coupling: Coupling] , ...14 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• 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: 20, defaultValue: null, modelName: Material , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...33 more... )
• 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 )

Types:

ID: Cap
Name: Cap, Active
Domains:
• FITTINGTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• Material:
  Inherited
• Basin:
  Inherited
• SubBasin:
  Inherited
• LifecycleStatus:
  Inherited
• SourceDocument:
  Inherited
• InModel:
  Inherited
Templates:
• Name: Cap, ACT
  Description:
  Prototype:
  GISGUID: null
  VerificationComments: null
  FACILITYID: null
  Atlas: null
  SeqNo: null
  Tract: null
  FITTINGTYPE: Cap
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  Stationing: null
  Material: null
  ProjectNo: null
  DrawingNumber: null
  DrawingSheetNo: null
  Basin: null
  SubBasin: null
  LifecycleStatus: ACT
  SourceDocument: DWG
  ContourElevation: null
  GPSDATE: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  WorkorderID: null
  PictureLinkID: null
  Comments: null
  Flag: null
  ModelID: null
  InModel: 0
  MapLibraryLink: null
  MapLibraryID: null
  SourceBlocKMapName: null
  SourceBlockMapPath: null
  LegacyObjID: null
  TempID: null
  FeatureClassName: null
  VerifiedDate: null
  VerifiedBy: null
  
  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