View In:   ArcGIS Online Map Viewer

Name: PW_PreventiveMaintenance_ServiceRequests

Display Field: INCIDENT_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0269082059424ec283b8626ac2c94261

Copyright Text:

Default Visibility: true

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

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -438614.09695853293
YMin: -684467.1293600202
XMax: 3.4969241878198385E7
YMax: 3.616685255039914E7
Spatial Reference: 102736  (2274)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [79, 132, 33, 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 )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INCIDENT_NUMBER )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID, editable: true, nullable: true, defaultValue: 0, modelName: INCIDENT_TYPE_ID )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUEST_TYPE )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REQUEST_STATUS )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORTED_DATE )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old, editable: true, nullable: true, defaultValue: null, modelName: DAYS_OLD )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSE_DATE )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS1 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTAL_CODE )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PARCEL_ID )
• DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DRAIN_ZONE )
• STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_ZONE )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No, editable: true, nullable: true, defaultValue: null, modelName: cd_name )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No, editable: true, nullable: true, defaultValue: null, modelName: sccd_name )
• Start_Mile ( type: esriFieldTypeDouble, alias: Start_Mile, editable: true, nullable: true, defaultValue: null, modelName: Start_Mile )
• End_Mile ( type: esriFieldTypeDouble, alias: End_Mile, editable: true, nullable: true, defaultValue: null, modelName: End_Mile )
• Total_Mile ( type: esriFieldTypeDouble, alias: Total_Mile, editable: true, nullable: true, defaultValue: null, modelName: Total_Mile )
• 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 )
• SWEEP_LENGTH_MI ( type: esriFieldTypeSmallInteger, alias: Sweep Length Mi, editable: true, nullable: true, defaultValue: null, modelName: SWEEP_LENGTH_MI )
• SLA_MET ( type: esriFieldTypeString, alias: SLA Met, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SLA_MET )
• SYNC_DATE ( type: esriFieldTypeDate, alias: Sync Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SYNC_DATE )
• SOURCE_SYSTEM ( type: esriFieldTypeString, alias: Source Department, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SOURCE_SYSTEM )
• STREET_GRID ( type: esriFieldTypeInteger, alias: Street Grid, editable: true, nullable: true, defaultValue: null, modelName: STREET_GRID )

Templates:

• Name: PW_PreventiveMaintenance_ServiceRequests
  Description:
  Prototype:
  SOURCE_SYSTEM: null
  SYNC_DATE: null
  INCIDENT_NUMBER: null
  INCIDENT_TYPE_ID: 0
  REQUEST_TYPE: null
  REQUEST_STATUS: null
  REPORTED_DATE: null
  DAYS_OLD: null
  CLOSE_DATE: null
  ADDRESS1: null
  POSTAL_CODE: null
  PARCEL_ID: null
  DRAIN_ZONE: null
  STREET_ZONE: null
  cd_name: null
  sccd_name: null
  Start_Mile: null
  End_Mile: null
  Total_Mile: null
  STREET_GRID: null
  SLA_MET: null
  SWEEP_LENGTH_MI: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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 Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata