View In:   ArcGIS Online Map Viewer

Name: SuffolkGIS.DBO.Cleanouts

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 37b0de932d6f4c6f86509933f52d8725

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 1056319.400000006
YMin: 3441
XMax: 1.2035342230000001E8
YMax: 3.47905038E7
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: GPS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 182, 224, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: No
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [190, 252, 182, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: No Cleanout Exists
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [189, 237, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 4
  Label: Yes – From Surveyed As-Built
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 226, 197, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: GPS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• SERVICEAREA ( type: esriFieldTypeString, alias: SERVICEAREA, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SERVICEAREA )
• POSTING ( type: esriFieldTypeString, alias: Posting, editable: true, nullable: true, length: 20, defaultValue: U, modelName: Posting , Coded Values: [1: Conceptual] , [2: Approved] , [3: Under Construction] , ...5 more... )
• PROJECTNO ( type: esriFieldTypeString, alias: PROJECTNO, editable: true, nullable: true, length: 18, defaultValue: null, modelName: PROJECTNO )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE )
• NTI_ASSACCOUNTNUM ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 9, defaultValue: null, modelName: NTI_ASSACCOUNTNUM )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENT )
• CAP_ELEV ( type: esriFieldTypeDouble, alias: Cleanout Elevation, editable: true, nullable: true, defaultValue: 999, modelName: CAP_ELEV )
• GPS ( type: esriFieldTypeInteger, alias: GPS Located, editable: true, nullable: true, defaultValue: 2, modelName: GPS )
• DO_NOT_CAP ( type: esriFieldTypeString, alias: DO_NOT_CAP, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DO_NOT_CAP , Coded Values: [Y: Yes] , [N: No] )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SP_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: 1
Name: Yes
Domains:
• POSTING:
  Inherited
• DO_NOT_CAP:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  SP_ID: null
  DO_NOT_CAP: N
  FACILITYID: null
  SERVICEAREA: null
  POSTING: U
  PROJECTNO: null
  SOURCE: null
  NTI_ASSACCOUNTNUM: null
  INSTALLDATE: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  COMMENT: null
  CAP_ELEV: null
  GPS: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: No
Domains:
• POSTING:
  Inherited
• DO_NOT_CAP:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  SP_ID: null
  DO_NOT_CAP: N
  FACILITYID: null
  SERVICEAREA: null
  POSTING: U
  PROJECTNO: null
  SOURCE: null
  NTI_ASSACCOUNTNUM: null
  INSTALLDATE: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  COMMENT: null
  CAP_ELEV: null
  GPS: 2
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: No Cleanout Exists
Domains:
• POSTING:
  Inherited
• DO_NOT_CAP:
  Inherited
Templates:
• Name: No Cleanout Exists
  Description:
  Prototype:
  SP_ID: null
  DO_NOT_CAP: N
  FACILITYID: null
  SERVICEAREA: null
  POSTING: U
  PROJECTNO: null
  SOURCE: null
  NTI_ASSACCOUNTNUM: null
  INSTALLDATE: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  COMMENT: null
  CAP_ELEV: 999
  GPS: 3
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Yes – From Surveyed As-Built
Domains:
• POSTING:
  Inherited
• DO_NOT_CAP:
  Inherited
Templates:
• Name: Yes – From Surveyed As-Built
  Description:
  Prototype:
  SP_ID: null
  DO_NOT_CAP: N
  FACILITYID: null
  SERVICEAREA: null
  POSTING: U
  PROJECTNO: null
  SOURCE: null
  NTI_ASSACCOUNTNUM: null
  INSTALLDATE: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  COMMENT: null
  CAP_ELEV: null
  GPS: 4
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

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

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