View In:   ArcGIS Online Map Viewer

Name: ssCleanOut

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e50c3a18d1ea49c49cf961bb0f1ca085

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 814537.0001534112
YMin: 404649.114233993
XMax: 913717.7122246623
YMax: 477003.948854737
Spatial Reference: 102666  (2239)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: devicetype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Cleanout
  Label: Cleanout
  Description: Cleanout
  Symbol:
  
• Value: Lamp Hole
  Label: Lamp Hole
  Description: Lamp Hole
  Symbol:
  
• Value: Proposed Cleanout
  Label: Proposed Cleanout
  Description: Proposed Cleanout
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [115, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: devicetype

Fields:

• workorder ( modelName: WorkOrder, nullable: true, editable: true, defaultValue: null, length: 15, alias: Work Order, type: esriFieldTypeString )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility Identifier, type: esriFieldTypeString )
• devicetype ( modelName: DEVICETYPE, nullable: true, editable: true, defaultValue: Cleanout, length: 30, alias: Cleanout Type, type: esriFieldTypeString , Coded Values: [Cleanout: Cleanout] , [Flushing Structure: Flushing Structure] , [Lamp Hole: Lamp Hole] , ...3 more... )
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• gps ( modelName: GPS, nullable: true, editable: true, defaultValue: null, length: 3, alias: Gps, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Dip: Dip] , ...1 more... )
• collection_date ( modelName: collection_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Collection Date, type: esriFieldTypeDate )
• timecollected ( modelName: TimeCollected, nullable: true, editable: true, defaultValue: null, length: 10, alias: Time Collected, type: esriFieldTypeString )
• datacollector ( modelName: DataCollector, nullable: true, editable: true, defaultValue: null, length: 25, alias: Data Collector, type: esriFieldTypeString )
• northing ( modelName: NORTHING, nullable: true, editable: true, defaultValue: null, alias: Northing, type: esriFieldTypeDouble )
• easting ( modelName: EASTING, nullable: true, editable: true, defaultValue: null, alias: Easting, type: esriFieldTypeDouble )
• gps_source ( modelName: GPS_SOURCE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Gps Source, type: esriFieldTypeString , Coded Values: [Map Grade: Map Grade] , [Survey Grade: Survey Grade] )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: JWSC] , ...5 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: JWSC] , ...3 more... )
• lastupdate ( modelName: lastupdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• remarks ( modelName: REMARKS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Remarks, type: esriFieldTypeString )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 250, alias: Location, type: esriFieldTypeString )
• source ( modelName: SOURCE, nullable: true, editable: true, defaultValue: null, length: 100, alias: Source, type: esriFieldTypeString )
• scans ( modelName: SCANS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Scans, type: esriFieldTypeString )
• project_id ( modelName: PROJECT_ID, nullable: true, editable: true, defaultValue: null, length: 30, alias: Project Identifier, type: esriFieldTypeString )
• accessdiam ( modelName: ACCESSDIAM, nullable: true, editable: true, defaultValue: null, alias: Access Diameter, type: esriFieldTypeDouble , Range: [0, 72] )
• accessmat ( modelName: ACCESSMAT, nullable: true, editable: true, defaultValue: null, length: 20, alias: Access Material, type: esriFieldTypeString , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...39 more... )
• accesstype ( modelName: ACCESSTYPE, nullable: true, editable: true, defaultValue: Cover, length: 20, alias: Access Type, type: esriFieldTypeString , Coded Values: [Door: Door] , [Grate: Grate] , [Cover: Cover] , ...3 more... )
• intdepth ( modelName: INTDEPTH, nullable: true, editable: true, defaultValue: null, alias: Interior Depth, type: esriFieldTypeDouble )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• rotation ( modelName: ROTATION, nullable: true, editable: true, defaultValue: null, alias: Rotation, type: esriFieldTypeDouble )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• lifecycle ( modelName: LIFECYCLE, nullable: true, editable: true, defaultValue: null, length: 25, alias: Lifecycle, type: esriFieldTypeString , Coded Values: [ABN: Abandoned] , [ACT: Active] , [REP: Being Repaired] , ...5 more... )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeSmallInteger , Coded Values: [1: Excellent] , [2: Failed] , [3: Fair] , ...3 more... )
• conditiondate ( modelName: conditiondate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Condition Date, type: esriFieldTypeDate )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• criticalasset ( modelName: CRITICALASSET, nullable: true, editable: true, defaultValue: null, length: 20, alias: Critical Asset, type: esriFieldTypeString )
• installvalue ( modelName: INSTALLVALUE, nullable: true, editable: true, defaultValue: null, alias: Install Value, type: esriFieldTypeInteger )
• depreciatedvalue ( modelName: DEPRECIATEDVALUE, nullable: true, editable: true, defaultValue: null, alias: Depreciated Value, type: esriFieldTypeInteger )
• usefullife ( modelName: USEFULLIFE, nullable: true, editable: true, defaultValue: null, alias: Useful Life, type: esriFieldTypeInteger )
• legacyid ( modelName: LEGACYID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Legacy ID, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Types:

ID: Cleanout
Name: Cleanout
Domains:
• accessdiam:
  Inherited
• lifecycle:
  Inherited
• accesstype:
  Inherited
• condition:
  Inherited
• accessmat:
  Inherited
• gps_source:
  Inherited
• maintby:
  Inherited
• gps:
  Inherited
• ownedby:
  Inherited
• devicetype:
  Inherited
• enabled:
  Inherited
• activeflag:
  Inherited
Templates:
• Name: Cleanout
  Description:
  Prototype:
  collection_date: null
  installdate: null
  facilityid: null
  timecollected: null
  depreciatedvalue: null
  source: null
  northing: null
  devicetype: Cleanout
  enabled: 1
  lifecycle: null
  accessmat: null
  project_id: null
  scans: null
  datacollector: null
  warrantydate: null
  ownedby: 1
  intdepth: null
  conditiondate: null
  accessdiam: null
  accesstype: Cover
  easting: null
  criticalasset: null
  rotation: null
  gps: null
  lasteditor: null
  activeflag: 1
  condition: null
  gps_source: null
  legacyid: null
  location: null
  maintby: 1
  installvalue: null
  lastupdate: null
  workorder: null
  remarks: null
  usefullife: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Lamp Hole
Name: Lamp Hole
Domains:
• accessdiam:
  Inherited
• lifecycle:
  Inherited
• accesstype:
  Inherited
• condition:
  Inherited
• accessmat:
  Inherited
• gps_source:
  Inherited
• maintby:
  Inherited
• gps:
  Inherited
• ownedby:
  Inherited
• devicetype:
  Inherited
• enabled:
  Inherited
• activeflag:
  Inherited
Templates:
• Name: Lamp Hole
  Description:
  Prototype:
  collection_date: null
  installdate: null
  facilityid: null
  timecollected: null
  depreciatedvalue: null
  source: null
  northing: null
  devicetype: Lamp Hole
  enabled: 1
  lifecycle: null
  accessmat: null
  project_id: null
  scans: null
  datacollector: null
  warrantydate: null
  ownedby: 1
  intdepth: null
  conditiondate: null
  accessdiam: null
  accesstype: Cover
  easting: null
  criticalasset: null
  rotation: null
  gps: null
  lasteditor: null
  activeflag: 1
  condition: null
  gps_source: null
  legacyid: null
  location: null
  maintby: 1
  installvalue: null
  lastupdate: null
  workorder: null
  remarks: null
  usefullife: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Proposed Cleanout
Name: Proposed Cleanout
Domains:
• accessdiam:
  Inherited
• lifecycle:
  Inherited
• accesstype:
  Inherited
• condition:
  Inherited
• accessmat:
  Inherited
• gps_source:
  Inherited
• maintby:
  Inherited
• gps:
  Inherited
• ownedby:
  Inherited
• devicetype:
  Inherited
• enabled:
  Inherited
• activeflag:
  Inherited
Templates:
• Name: Proposed Cleanout
  Description:
  Prototype:
  collection_date: null
  installdate: null
  facilityid: null
  timecollected: null
  depreciatedvalue: null
  source: null
  northing: null
  devicetype: Proposed Cleanout
  enabled: 1
  lifecycle: null
  accessmat: null
  project_id: null
  scans: null
  datacollector: null
  warrantydate: null
  ownedby: 1
  intdepth: null
  conditiondate: null
  accessdiam: null
  accesstype: Cover
  easting: null
  criticalasset: null
  rotation: null
  gps: null
  lasteditor: null
  activeflag: 1
  condition: null
  gps_source: null
  legacyid: null
  location: null
  maintby: 1
  installvalue: null
  lastupdate: null
  workorder: null
  remarks: null
  usefullife: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata