ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
DPW
>
StreetandAlleyCleaningOpreations (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (DPW/StreetandAlleyCleaningOpreations)
Layers:
Layer:
Night Sweeping Routes
(0)
Name:
Night Sweeping Routes
Display Field:
Route_Id_1
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 389874.8447000012
YMin: 126297.70949999988
XMax: 407538.6372999996
YMax: 147168.36549999937
Spatial Reference: 26985 (26985)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[163, 117, 0, 255]
Width:
1
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: true
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
OBJECTID_1
( type: esriFieldTypeOID, alias: OBJECTID_1 )
OBJECTID
( type: esriFieldTypeInteger, alias: OBJECTID )
Route_Id_1
( type: esriFieldTypeString, alias: Route_Id_1, length: 50 )
Route_Id
( type: esriFieldTypeString, alias: Route_Id, length: 50 )
Shape_Leng
( type: esriFieldTypeDouble, alias: Shape_Leng )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
Tables:
Table:
Weigh Scale Transactions
(1)
Name:
Weigh Scale Transactions
Display Field:
site_code
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
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: false
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: true
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:
null
Fields:
transaction_id
( type: esriFieldTypeOID, alias: transaction_id )
material_type_id
( type: esriFieldTypeSmallInteger, alias: material_type_id )
transaction_num
( type: esriFieldTypeInteger, alias: transaction_num )
site_code
( type: esriFieldTypeString, alias: site_code, length: 4 )
rate
( type: esriFieldTypeDouble, alias: rate )
tip_fee
( type: esriFieldTypeDouble, alias: tip_fee )
tare_weight_lbs
( type: esriFieldTypeInteger, alias: tare_weight_lbs )
gross_weight_lbs
( type: esriFieldTypeInteger, alias: gross_weight_lbs )
net_weight_lbs
( type: esriFieldTypeInteger, alias: net_weight_lbs )
company_id
( type: esriFieldTypeInteger, alias: company_id )
truck_number
( type: esriFieldTypeString, alias: truck_number, length: 60000 )
time_in
( type: esriFieldTypeDate, alias: time_in, length: 8 )
time_out
( type: esriFieldTypeDate, alias: time_out, length: 8 )
direction
( type: esriFieldTypeString, alias: direction, length: 1 )
payment_type_id
( type: esriFieldTypeSmallInteger, alias: payment_type_id )
vehicle_type_id
( type: esriFieldTypeSmallInteger, alias: vehicle_type_id )
total_fee
( type: esriFieldTypeDouble, alias: total_fee )
tendered
( type: esriFieldTypeDouble, alias: tendered )
inserted_at
( type: esriFieldTypeDate, alias: inserted_at, length: 8 )
updated_at
( type: esriFieldTypeDate, alias: updated_at, length: 8 )
Table:
Trakster Time and Attendance
(2)
Name:
Trakster Time and Attendance
Display Field:
employee_number
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeInteger, alias: id )
daily_crew_id
( type: esriFieldTypeInteger, alias: daily_crew_id )
employee_number
( type: esriFieldTypeString, alias: employee_number, length: 60000 )
date
( type: esriFieldTypeDate, alias: date, length: 8 )
department
( type: esriFieldTypeString, alias: department, length: 60000 )
division
( type: esriFieldTypeString, alias: division, length: 60000 )
section
( type: esriFieldTypeString, alias: section, length: 60000 )
status
( type: esriFieldTypeString, alias: status, length: 60000 )
hours
( type: esriFieldTypeInteger, alias: hours )
total_hours
( type: esriFieldTypeInteger, alias: total_hours )
business_unit
( type: esriFieldTypeString, alias: business_unit, length: 60000 )
employee_status
( type: esriFieldTypeString, alias: employee_status, length: 60000 )
activity
( type: esriFieldTypeString, alias: activity, length: 60000 )
status_category
( type: esriFieldTypeString, alias: status_category, length: 60000 )
computed_status
( type: esriFieldTypeString, alias: computed_status, length: 60000 )
full_time_equivalent
( type: esriFieldTypeSingle, alias: full_time_equivalent )
overtime_equivalent
( type: esriFieldTypeSingle, alias: overtime_equivalent )
overtime_hours
( type: esriFieldTypeInteger, alias: overtime_hours )
last_synced_from_trakster_at
( type: esriFieldTypeDate, alias: last_synced_from_trakster_at, length: 8 )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID )
Table:
Crews
(3)
Name:
Crews
Display Field:
crew_type
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeOID, alias: id )
start_datetime
( type: esriFieldTypeDate, alias: start_datetime, length: 8 )
end_datetime
( type: esriFieldTypeDate, alias: end_datetime, length: 8 )
organization_id
( type: esriFieldTypeSmallInteger, alias: organization_id )
crew_type
( type: esriFieldTypeString, alias: crew_type, length: 60000 )
crew_subtype
( type: esriFieldTypeString, alias: crew_subtype, length: 60000 )
source_app_id
( type: esriFieldTypeSmallInteger, alias: source_app_id )
external_id
( type: esriFieldTypeString, alias: external_id, length: 60000 )
inserted_at
( type: esriFieldTypeDate, alias: inserted_at, length: 8 )
updated_at
( type: esriFieldTypeDate, alias: updated_at, length: 8 )
department
( type: esriFieldTypeString, alias: department, length: 60000 )
division
( type: esriFieldTypeString, alias: division, length: 60000 )
section
( type: esriFieldTypeString, alias: section, length: 60000 )
business_unit
( type: esriFieldTypeString, alias: business_unit, length: 60000 )
activity
( type: esriFieldTypeString, alias: activity, length: 60000 )
Table:
Crew People
(4)
Name:
Crew People
Display Field:
title
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeOID, alias: id )
crew_id
( type: esriFieldTypeInteger, alias: crew_id )
person_id
( type: esriFieldTypeInteger, alias: person_id )
title
( type: esriFieldTypeString, alias: title, length: 1073741822 )
status
( type: esriFieldTypeString, alias: status, length: 1073741822 )
hours
( type: esriFieldTypeInteger, alias: hours )
total_hours
( type: esriFieldTypeInteger, alias: total_hours )
employee_status
( type: esriFieldTypeString, alias: employee_status, length: 1073741822 )
status_category
( type: esriFieldTypeString, alias: status_category, length: 1073741822 )
computed_status
( type: esriFieldTypeString, alias: computed_status, length: 1073741822 )
full_time_equivalent
( type: esriFieldTypeSingle, alias: full_time_equivalent )
overtime_equivalent
( type: esriFieldTypeSingle, alias: overtime_equivalent )
overtime_hours
( type: esriFieldTypeInteger, alias: overtime_hours )
last_synced_from_trakster_at
( type: esriFieldTypeDate, alias: last_synced_from_trakster_at, length: 8, precision: 1 )
employee_id
( type: esriFieldTypeString, alias: employee_id, length: 1073741822 )
external_id
( type: esriFieldTypeString, alias: external_id, length: 1073741822 )