ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
DPW
>
StreetandAlleyCleaning (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (DPW/StreetandAlleyCleaning)
Layers:
Layer:
DC Boundary
(0)
Name:
DC Boundary
Display Field:
CITY_NAME
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
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: 389612.306999996
YMin: 124868.954999998
XMax: 407880.11999999697
YMax: 147558.136999998
Spatial Reference: 26985 (26985)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[252, 237, 202, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 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: 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:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
CITY_FIPS
( type: esriFieldTypeDouble, alias: CITY_FIPS )
CITY_NAME
( type: esriFieldTypeString, alias: CITY_NAME, length: 25 )
STATE_FIPS
( type: esriFieldTypeDouble, alias: STATE_FIPS )
STATE_NAME
( type: esriFieldTypeString, alias: STATE_NAME, length: 20 )
STATE_CITY
( type: esriFieldTypeDouble, alias: STATE_CITY )
CAPITAL
( type: esriFieldTypeString, alias: CAPITAL, length: 1 )
WEB_URL
( type: esriFieldTypeString, alias: WEB_URL, length: 50 )
AREAKM
( type: esriFieldTypeDouble, alias: AREAKM )
AREAMILES
( type: esriFieldTypeDouble, alias: AREAMILES )
SHAPE
( type: esriFieldTypeGeometry, alias: Shape )
SHAPE.AREA
( type: esriFieldTypeDouble, alias: SHAPE.AREA )
SHAPE.LEN
( type: esriFieldTypeDouble, alias: SHAPE.LEN )
SE_ANNO_CAD_DATA
( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA )
GIS_ID
( type: esriFieldTypeString, alias: GIS_ID, length: 50 )
GLOBALID
( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
CREATOR
( type: esriFieldTypeString, alias: CREATOR, length: 255 )
CREATED
( type: esriFieldTypeDate, alias: CREATED, length: 8 )
EDITOR
( type: esriFieldTypeString, alias: EDITOR, length: 255 )
EDITED
( type: esriFieldTypeDate, alias: EDITED, length: 8 )
Tables:
Table:
Weigh Scale Transactions
(1)
Name:
Weigh Scale Transactions
Display Field:
hauler_name
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 )
fiscal_week
( type: esriFieldTypeInteger, alias: fiscal_week )
fiscal_quarter
( type: esriFieldTypeInteger, alias: fiscal_quarter )
fiscal_year
( type: esriFieldTypeInteger, alias: fiscal_year )
material_type
( type: esriFieldTypeString, alias: material_type, length: 60000 )
payment_type
( type: esriFieldTypeString, alias: payment_type, length: 60000 )
hauler_name
( type: esriFieldTypeString, alias: hauler_name, length: 60000 )
hauler_account_number
( type: esriFieldTypeString, alias: hauler_account_number, length: 60000 )
Table:
Crews
(2)
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: 1073741822 )
crew_subtype
( type: esriFieldTypeString, alias: crew_subtype, length: 1073741822 )
source_app_id
( type: esriFieldTypeSmallInteger, alias: source_app_id )
external_id
( type: esriFieldTypeString, alias: external_id, length: 1073741822 )
inserted_at
( type: esriFieldTypeDate, alias: inserted_at, length: 8 )
updated_at
( type: esriFieldTypeDate, alias: updated_at, length: 8 )
department
( type: esriFieldTypeString, alias: department, length: 1073741822 )
division
( type: esriFieldTypeString, alias: division, length: 1073741822 )
section
( type: esriFieldTypeString, alias: section, length: 1073741822 )
business_unit
( type: esriFieldTypeString, alias: business_unit, length: 1073741822 )
activity
( type: esriFieldTypeString, alias: activity, length: 1073741822 )
Table:
Crew People
(3)
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: 60000 )
status
( type: esriFieldTypeString, alias: status, length: 60000 )
hours
( type: esriFieldTypeInteger, alias: hours )
total_hours
( type: esriFieldTypeInteger, alias: total_hours )
employee_status
( type: esriFieldTypeString, alias: employee_status, 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 )
employee_id
( type: esriFieldTypeString, alias: employee_id, length: 60000 )
Table:
Crews View
(4)
Name:
Crews View
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:
activity
( type: esriFieldTypeString, alias: activity, length: 60000 )
asset_id
( type: esriFieldTypeInteger, alias: asset_id )
business_unit
( type: esriFieldTypeString, alias: business_unit, length: 60000 )
computed_status
( type: esriFieldTypeString, alias: computed_status, length: 60000 )
crew_id
( type: esriFieldTypeInteger, alias: crew_id )
crew_people_id
( type: esriFieldTypeOID, alias: crew_people_id )
crew_subtype
( type: esriFieldTypeString, alias: crew_subtype, length: 60000 )
crew_type
( type: esriFieldTypeString, alias: crew_type, length: 60000 )
department
( type: esriFieldTypeString, alias: department, length: 60000 )
division
( type: esriFieldTypeString, alias: division, length: 60000 )
employee_id
( type: esriFieldTypeString, alias: employee_id, length: 60000 )
employee_status
( type: esriFieldTypeString, alias: employee_status, length: 60000 )
end_datetime
( type: esriFieldTypeDate, alias: end_datetime, length: 8 )
external_id
( type: esriFieldTypeString, alias: external_id, length: 60000 )
first_name
( type: esriFieldTypeString, alias: first_name, length: 60000 )
full_time_equivalent
( type: esriFieldTypeSingle, alias: full_time_equivalent )
hours
( type: esriFieldTypeInteger, alias: hours )
inserted_at
( type: esriFieldTypeDate, alias: inserted_at, length: 8 )
last_name
( type: esriFieldTypeString, alias: last_name, length: 60000 )
last_synced_from_trakster_at
( type: esriFieldTypeDate, alias: last_synced_from_trakster_at, length: 8 )
organization_id
( type: esriFieldTypeSmallInteger, alias: organization_id )
overtime_equivalent
( type: esriFieldTypeSingle, alias: overtime_equivalent )
overtime_hours
( type: esriFieldTypeInteger, alias: overtime_hours )
person_id
( type: esriFieldTypeInteger, alias: person_id )
phone
( type: esriFieldTypeString, alias: phone, length: 60000 )
section
( type: esriFieldTypeString, alias: section, length: 60000 )
source_app_id
( type: esriFieldTypeSmallInteger, alias: source_app_id )
start_datetime
( type: esriFieldTypeDate, alias: start_datetime, length: 8 )
status
( type: esriFieldTypeString, alias: status, length: 60000 )
status_category
( type: esriFieldTypeString, alias: status_category, length: 60000 )
title
( type: esriFieldTypeString, alias: title, length: 60000 )
total_hours
( type: esriFieldTypeInteger, alias: total_hours )
updated_at
( type: esriFieldTypeDate, alias: updated_at, length: 8 )
license_plate
( type: esriFieldTypeString, alias: license_plate, length: 60000 )
faster_id
( type: esriFieldTypeString, alias: faster_id, length: 60000 )
Table:
Faster Work Orders
(5)
Name:
Faster Work Orders
Display Field:
asset_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: esriFieldTypeOID, alias: id )
document_id
( type: esriFieldTypeInteger, alias: document_id )
asset_number
( type: esriFieldTypeString, alias: asset_number, length: 60000 )
work_order_status
( type: esriFieldTypeString, alias: work_order_status, length: 60000 )
in_date
( type: esriFieldTypeDate, alias: in_date, length: 8 )
out_date
( type: esriFieldTypeDate, alias: out_date, length: 8 )
promised_date
( type: esriFieldTypeDate, alias: promised_date, length: 8 )
work_order_modified_date
( type: esriFieldTypeDate, alias: work_order_modified_date, length: 8 )
availability_start_time
( type: esriFieldTypeDate, alias: availability_start_time, length: 8 )
availability_end_time
( type: esriFieldTypeDate, alias: availability_end_time, length: 8 )
description
( type: esriFieldTypeString, alias: description, length: 60000 )
faster_shop_id
( type: esriFieldTypeString, alias: faster_shop_id, length: 3 )
total_labor_charge
( type: esriFieldTypeDouble, alias: total_labor_charge )
total_parts_charge
( type: esriFieldTypeDouble, alias: total_parts_charge )
total_sublet_charge
( type: esriFieldTypeDouble, alias: total_sublet_charge )
total_other_charge
( type: esriFieldTypeDouble, alias: total_other_charge )
total_work_order_charge
( type: esriFieldTypeDouble, alias: total_work_order_charge )
asset_type
( type: esriFieldTypeString, alias: asset_type, length: 60000 )
make
( type: esriFieldTypeString, alias: make, length: 60000 )
model
( type: esriFieldTypeString, alias: model, length: 60000 )
asset_class
( type: esriFieldTypeString, alias: asset_class, length: 60000 )