View In:   ArcGIS Online Map Viewer

Name: SCF_E311_Requests

Display Field: requestid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: giscw_datatables.dbo.vw_SCF_E311_Requests

Service Item Id: 038c49304cdc4ed7adf95c43a4556756

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

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: 1933296.601334067
YMin: 216062.35267875285
XMax: 2011828.2302365638
YMax: 297089.3159417862
Spatial Reference: 102677  (3419)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [147, 143, 62, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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 )
• problemcode ( type: esriFieldTypeString, alias: problemcode, editable: true, nullable: false, length: 20, defaultValue: null, modelName: problemcode )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: description )
• details ( type: esriFieldTypeString, alias: details, editable: true, nullable: true, length: 500, defaultValue: null, modelName: details )
• priority ( type: esriFieldTypeString, alias: priority, editable: true, nullable: true, length: 2, defaultValue: null, modelName: priority )
• probaddress ( type: esriFieldTypeString, alias: probaddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: probaddress )
• reqcategory ( type: esriFieldTypeString, alias: reqcategory, editable: true, nullable: true, length: 50, defaultValue: null, modelName: reqcategory )
• initiatedby ( type: esriFieldTypeString, alias: initiatedby, editable: true, nullable: true, length: 50, defaultValue: null, modelName: initiatedby )
• submitto ( type: esriFieldTypeString, alias: submitto, editable: true, nullable: true, length: 50, defaultValue: null, modelName: submitto )
• 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 )
• PRJCOMPLETEDATE ( type: esriFieldTypeDate, alias: PRJCOMPLETEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRJCOMPLETEDATE )
• status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status )
• dateclosed ( type: esriFieldTypeDate, alias: dateclosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateclosed )
• daysSinceRequest ( type: esriFieldTypeInteger, alias: daysSinceRequest, editable: true, nullable: true, defaultValue: null, modelName: daysSinceRequest )
• daysToClose ( type: esriFieldTypeInteger, alias: daysToClose, editable: true, nullable: true, defaultValue: null, modelName: daysToClose )
• YR_INIT ( type: esriFieldTypeInteger, alias: YR_INIT, editable: true, nullable: true, defaultValue: null, modelName: YR_INIT )
• MO_INIT ( type: esriFieldTypeInteger, alias: MO_INIT, editable: true, nullable: true, defaultValue: null, modelName: MO_INIT )
• YR_CL ( type: esriFieldTypeInteger, alias: YR_CL, editable: true, nullable: true, defaultValue: null, modelName: YR_CL )
• MO_CL ( type: esriFieldTypeInteger, alias: MO_CL, editable: true, nullable: true, defaultValue: null, modelName: MO_CL )
• cwlink ( type: esriFieldTypeString, alias: cwlink, editable: true, nullable: false, length: 125, defaultValue: null, modelName: cwlink )

Templates:

• Name: SCF_E311_Requests
  Description:
  Prototype:
  MO_CL: null
  cwlink:
  requestid: 0
  problemcode:
  description: null
  details: null
  priority: null
  probaddress: null
  reqcategory: null
  initiatedby: null
  submitto: null
  datetimeinit: null
  datetimeclosed: null
  PRJCOMPLETEDATE: null
  status: null
  dateclosed: null
  daysSinceRequest: null
  daysToClose: null
  YR_INIT: null
  MO_INIT: null
  YR_CL: 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