View In:   ArcGIS Online Map Viewer

Name: StreetlightServiceRequests

Display Field: PROBADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 311 requests for Streetlight Repair Investigation received 1/1/24 onwards

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: -9085265.596245749
YMin: 4519923.331563009
XMax: -8561855.903861366
YMax: 4720831.422644888
Spatial Reference: 102100  (3857)

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REQUESTID ( type: esriFieldTypeDouble, alias: REQUESTID, editable: true, nullable: false, defaultValue: null, modelName: REQUESTID )
• PROBADDRESS ( type: esriFieldTypeString, alias: PROBADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROBADDRESS )
• MAPPAGE ( type: esriFieldTypeString, alias: MAPPAGE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MAPPAGE )
• DATETIMEINIT ( type: esriFieldTypeDate, alias: DATETIMEINIT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEINIT )
• DATETIMECLOSED ( type: esriFieldTypeDate, alias: DATETIMECLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMECLOSED )
• status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status )
• c1_Q ( type: esriFieldTypeString, alias: c1_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c1_Q )
• c1_A ( type: esriFieldTypeString, alias: c1_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c1_A )
• c2_Q ( type: esriFieldTypeString, alias: c2_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c2_Q )
• c2_A ( type: esriFieldTypeString, alias: c2_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c2_A )
• c3_Q ( type: esriFieldTypeString, alias: c3_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c3_Q )
• c3_A ( type: esriFieldTypeString, alias: c3_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c3_A )
• c4_Q ( type: esriFieldTypeString, alias: c4_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c4_Q )
• c4_A ( type: esriFieldTypeString, alias: c4_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c4_A )
• c5_Q ( type: esriFieldTypeString, alias: c5_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c5_Q )
• c5_A ( type: esriFieldTypeString, alias: c5_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c5_A )
• c6_Q ( type: esriFieldTypeString, alias: c6_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c6_Q )
• c6_A ( type: esriFieldTypeString, alias: c6_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c6_A )
• c7_Q ( type: esriFieldTypeString, alias: c7_Q, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c7_Q )
• c7_A ( type: esriFieldTypeString, alias: c7_A, editable: true, nullable: true, length: 250, defaultValue: null, modelName: c7_A )
• SRX ( type: esriFieldTypeDouble, alias: SRX, editable: true, nullable: true, defaultValue: null, modelName: SRX )
• SRY ( type: esriFieldTypeDouble, alias: SRY, editable: true, nullable: true, defaultValue: null, modelName: SRY )
• OTHERSYSTEMID ( type: esriFieldTypeString, alias: OTHERSYSTEMID, editable: true, nullable: true, length: 70, defaultValue: null, modelName: OTHERSYSTEMID )
• REQCOMMENT ( type: esriFieldTypeString, alias: REQCOMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: REQCOMMENT )
• REQCOMMENTUPDTDATE ( type: esriFieldTypeDate, alias: REQCOMMENTUPDTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REQCOMMENTUPDTDATE )

Templates:

• Name: StreetlightServiceRequests
  Description:
  Prototype:
  REQCOMMENT: null
  REQCOMMENTUPDTDATE: null
  REQUESTID: 0
  PROBADDRESS: null
  MAPPAGE: null
  DATETIMEINIT: null
  DATETIMECLOSED: null
  status: null
  c1_Q: null
  c1_A: null
  c2_Q: null
  c2_A: null
  c3_Q: null
  c3_A: null
  c4_Q: null
  c4_A: null
  c5_Q: null
  c5_A: null
  c6_Q: null
  c6_A: null
  c7_Q: null
  c7_A: null
  SRX: null
  SRY: null
  OTHERSYSTEMID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata