View In:
ArcGIS Online Map Viewer
Name: Texas_finalmerged
Display Field: contractor_name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: bb2ad35e48aa453cbc8f5a237137af34
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: -95.66876649999995
YMin: 31.139737100000048
XMax: -94.66305029999995
YMax: 32.05708780000003
Spatial Reference: 4326
(4326)
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: false
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: true
Supports Query With LOD Spatial Reference: true
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
(
nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID
)
-
objectid_lh
(
modelName: objectid_lh, nullable: true, editable: true, defaultValue: null, alias: objectid_lh, type: esriFieldTypeInteger
)
-
globalid_lh
(
modelName: globalid_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: globalid_lh, type: esriFieldTypeString
)
-
incidentid_lh
(
modelName: incidentid_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: incidentid_lh, type: esriFieldTypeString
)
-
type_lh
(
modelName: type_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: type_lh, type: esriFieldTypeString
)
-
local_load_date
(
modelName: local_load_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Local_Load_Date, type: esriFieldTypeDate
)
-
loadtime_lh
(
modelName: loadtime_lh, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: loadtime_lh, type: esriFieldTypeDate
)
-
ticket_id
(
modelName: ticket_id, nullable: true, editable: true, defaultValue: null, length: 256, alias: Ticket_ID, type: esriFieldTypeString
)
-
truck_id
(
modelName: truck_id, nullable: true, editable: true, defaultValue: null, alias: Truck_ID, type: esriFieldTypeInteger
)
-
contractor_name
(
modelName: contractor_name, nullable: true, editable: true, defaultValue: null, length: 256, alias: Contractor_Name, type: esriFieldTypeString
)
-
subcontactor_lh
(
modelName: subcontactor_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: subcontactor_lh, type: esriFieldTypeString
)
-
capacity_lh
(
modelName: capacity_lh, nullable: true, editable: true, defaultValue: null, alias: capacity_lh, type: esriFieldTypeInteger
)
-
trucktype_lh
(
modelName: trucktype_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckType_lh, type: esriFieldTypeString
)
-
truckcert_lh
(
modelName: truckcert_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckCert_lh, type: esriFieldTypeString
)
-
material
(
modelName: material, nullable: true, editable: true, defaultValue: null, length: 256, alias: Material, type: esriFieldTypeString
)
-
payableunit_lh
(
modelName: payableunit_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: payableunit_lh, type: esriFieldTypeString
)
-
payableunitvalue_lh
(
modelName: payableunitvalue_lh, nullable: true, editable: true, defaultValue: null, alias: payableUnitValue_lh, type: esriFieldTypeInteger
)
-
countunits_lh
(
modelName: countunits_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: countUnits_lh, type: esriFieldTypeString
)
-
sumloads_lh
(
modelName: sumloads_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: sumLoads_lh, type: esriFieldTypeString
)
-
percentload_lh
(
modelName: percentload_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: percentLoad_lh, type: esriFieldTypeString
)
-
comments_lh
(
modelName: comments_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: comments_lh, type: esriFieldTypeString
)
-
load_monitor
(
modelName: load_monitor, nullable: true, editable: true, defaultValue: null, length: 256, alias: Load_Monitor, type: esriFieldTypeString
)
-
city_lh
(
modelName: city_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: city_lh, type: esriFieldTypeString
)
-
zone_lh
(
modelName: zone_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: zone_lh, type: esriFieldTypeString
)
-
highway_lh
(
modelName: highway_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: highway_lh, type: esriFieldTypeString
)
-
milemarker_lh
(
modelName: milemarker_lh, nullable: true, editable: true, defaultValue: null, alias: mileMarker_lh, type: esriFieldTypeDouble
)
-
highwayoffset_lh
(
modelName: highwayoffset_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: highwayOffset_lh, type: esriFieldTypeString
)
-
editdate_lh
(
modelName: editdate_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: EditDate_lh, type: esriFieldTypeString
)
-
editor_lh
(
modelName: editor_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: Editor_lh, type: esriFieldTypeString
)
-
version_lh
(
modelName: version_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: version_lh, type: esriFieldTypeString
)
-
creationdate_lh
(
modelName: creationdate_lh, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CreationDate_lh, type: esriFieldTypeDate
)
-
creator_lh
(
modelName: creator_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: Creator_lh, type: esriFieldTypeString
)
-
editdate_1_lh
(
modelName: editdate_1_lh, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EditDate_1_lh, type: esriFieldTypeDate
)
-
editor_1_lh
(
modelName: editor_1_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: Editor_1_lh, type: esriFieldTypeString
)
-
test_lh
(
modelName: test_lh, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: test_lh, type: esriFieldTypeDate
)
-
tickettype_lh
(
modelName: tickettype_lh, nullable: true, editable: true, defaultValue: null, length: 256, alias: tickettype_lh, type: esriFieldTypeString
)
-
longitude
(
modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: longitude, type: esriFieldTypeDouble
)
-
latitude
(
modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: latitude, type: esriFieldTypeDouble
)
-
objectid_mt
(
modelName: objectid_mt, nullable: true, editable: true, defaultValue: null, alias: objectid_mt, type: esriFieldTypeDouble
)
-
globalid_mt
(
modelName: globalid_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: globalid_mt, type: esriFieldTypeString
)
-
incidentid_mt
(
modelName: incidentid_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: incidentid_mt, type: esriFieldTypeString
)
-
debristype_mt
(
modelName: debristype_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: debristype_mt, type: esriFieldTypeString
)
-
type_mt
(
modelName: type_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: type_mt, type: esriFieldTypeString
)
-
disposal_site
(
modelName: disposal_site, nullable: true, editable: true, defaultValue: null, length: 256, alias: Disposal_Site, type: esriFieldTypeString
)
-
local_unload_date
(
modelName: local_unload_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Local_Unload_Date, type: esriFieldTypeDate
)
-
local_unload_time
(
modelName: local_unload_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Local_Unload_Time, type: esriFieldTypeDate
)
-
truckid_mt
(
modelName: truckid_mt, nullable: true, editable: true, defaultValue: null, alias: truckid_mt, type: esriFieldTypeInteger
)
-
contractor_mt
(
modelName: contractor_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: contractor_mt, type: esriFieldTypeString
)
-
subcontactor_mt
(
modelName: subcontactor_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: subcontactor_mt, type: esriFieldTypeString
)
-
capacity_mt
(
modelName: capacity_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: capacity_mt, type: esriFieldTypeString
)
-
trucktype_mt
(
modelName: trucktype_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckType_mt, type: esriFieldTypeString
)
-
truckcert_mt
(
modelName: truckcert_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckCert_mt, type: esriFieldTypeString
)
-
payableunit_mt
(
modelName: payableunit_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: payableunit_mt, type: esriFieldTypeString
)
-
payableunitvalue_mt
(
modelName: payableunitvalue_mt, nullable: true, editable: true, defaultValue: null, alias: payableUnitValue_mt, type: esriFieldTypeDouble
)
-
unit_weight_mt
(
modelName: unit_weight_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: unit_weight_mt, type: esriFieldTypeString
)
-
dispoweight_lb_mt
(
modelName: dispoweight_lb_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: dispoweight_lb_mt, type: esriFieldTypeString
)
-
num_tare_lb_mt
(
modelName: num_tare_lb_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: num_tare_lb_mt, type: esriFieldTypeString
)
-
netweight_lb_mt
(
modelName: netweight_lb_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: netweight_lb_mt, type: esriFieldTypeString
)
-
dispoweight_ton_mt
(
modelName: dispoweight_ton_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: dispoweight_ton_mt, type: esriFieldTypeString
)
-
num_tare_ton_mt
(
modelName: num_tare_ton_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: num_tare_ton_mt, type: esriFieldTypeString
)
-
netweight_ton_mt
(
modelName: netweight_ton_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: netweight_ton_mt, type: esriFieldTypeString
)
-
dispoweight_mt
(
modelName: dispoweight_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: dispoweight_mt, type: esriFieldTypeString
)
-
num_tare_mt
(
modelName: num_tare_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: num_tare_mt, type: esriFieldTypeString
)
-
num_tare_hydrated_mt
(
modelName: num_tare_hydrated_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: num_tare_hydrated_mt, type: esriFieldTypeString
)
-
num_tare_final_mt
(
modelName: num_tare_final_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: num_tare_final_mt, type: esriFieldTypeString
)
-
payableweight_mt
(
modelName: payableweight_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: payableWeight_mt, type: esriFieldTypeString
)
-
netweight_mt
(
modelName: netweight_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: netweight_mt, type: esriFieldTypeString
)
-
f__full
(
modelName: f__full, nullable: true, editable: true, defaultValue: null, alias: F__Full, type: esriFieldTypeDouble
)
-
payablecy_mt
(
modelName: payablecy_mt, nullable: true, editable: true, defaultValue: null, alias: payableCY_mt, type: esriFieldTypeDouble
)
-
net_quantity
(
modelName: net_quantity, nullable: true, editable: true, defaultValue: null, alias: Net_Quantity, type: esriFieldTypeDouble
)
-
scale_receipt_mt
(
modelName: scale_receipt_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: scale_receipt_mt, type: esriFieldTypeString
)
-
operator
(
modelName: operator, nullable: true, editable: true, defaultValue: null, length: 256, alias: Operator, type: esriFieldTypeString
)
-
comments_mt
(
modelName: comments_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: comments_mt, type: esriFieldTypeString
)
-
mileage_mt
(
modelName: mileage_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: mileage_mt, type: esriFieldTypeString
)
-
editeddate_mt
(
modelName: editeddate_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: EditedDate_mt, type: esriFieldTypeString
)
-
editorname_mt
(
modelName: editorname_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: EditorName_mt, type: esriFieldTypeString
)
-
version_mt
(
modelName: version_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: version_mt, type: esriFieldTypeString
)
-
creationdate_mt
(
modelName: creationdate_mt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CreationDate_mt, type: esriFieldTypeDate
)
-
creator_mt
(
modelName: creator_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: Creator_mt, type: esriFieldTypeString
)
-
editdate_mt
(
modelName: editdate_mt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EditDate_mt, type: esriFieldTypeDate
)
-
editor_mt
(
modelName: editor_mt, nullable: true, editable: true, defaultValue: null, length: 256, alias: Editor_mt, type: esriFieldTypeString
)
-
lon_field_mt
(
modelName: lon_field_mt, nullable: true, editable: true, defaultValue: null, alias: lon_field_mt, type: esriFieldTypeDouble
)
-
lat_field_mt
(
modelName: lat_field_mt, nullable: true, editable: true, defaultValue: null, alias: lat_field_mt, type: esriFieldTypeDouble
)
-
objectid_dt
(
modelName: objectid_dt, nullable: true, editable: true, defaultValue: null, alias: objectid_dt, type: esriFieldTypeDouble
)
-
globalid_dt
(
modelName: globalid_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: globalid_dt, type: esriFieldTypeString
)
-
debristype_dt
(
modelName: debristype_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: debristype_dt, type: esriFieldTypeString
)
-
disposite_dt
(
modelName: disposite_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: disposite_dt, type: esriFieldTypeString
)
-
dispodate_dt
(
modelName: dispodate_dt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: dispodate_dt, type: esriFieldTypeDate
)
-
dispotime_dt
(
modelName: dispotime_dt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: dispotime_dt, type: esriFieldTypeDate
)
-
truckid_dt
(
modelName: truckid_dt, nullable: true, editable: true, defaultValue: null, alias: truckid_dt, type: esriFieldTypeInteger
)
-
contractor_dt
(
modelName: contractor_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: contractor_dt, type: esriFieldTypeString
)
-
subcontactor_dt
(
modelName: subcontactor_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: subcontactor_dt, type: esriFieldTypeString
)
-
trucktype_dt
(
modelName: trucktype_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckType_dt, type: esriFieldTypeString
)
-
capacity_dt
(
modelName: capacity_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: capacity_dt, type: esriFieldTypeString
)
-
truckcert_dt
(
modelName: truckcert_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: truckCert_dt, type: esriFieldTypeString
)
-
dispomonitor_dt
(
modelName: dispomonitor_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: dispomonitor_dt, type: esriFieldTypeString
)
-
comments_dt
(
modelName: comments_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: comments_dt, type: esriFieldTypeString
)
-
editordate_dt
(
modelName: editordate_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: EditorDate_dt, type: esriFieldTypeString
)
-
editorname_dt
(
modelName: editorname_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: EditorName_dt, type: esriFieldTypeString
)
-
version_dt
(
modelName: version_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: version_dt, type: esriFieldTypeString
)
-
creationdate_dt
(
modelName: creationdate_dt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CreationDate_dt, type: esriFieldTypeDate
)
-
creator_dt
(
modelName: creator_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: Creator_dt, type: esriFieldTypeString
)
-
editdate_dt
(
modelName: editdate_dt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EditDate_dt, type: esriFieldTypeDate
)
-
editor_dt
(
modelName: editor_dt, nullable: true, editable: true, defaultValue: null, length: 256, alias: Editor_dt, type: esriFieldTypeString
)
-
lon_field_dt
(
modelName: lon_field_dt, nullable: true, editable: true, defaultValue: null, alias: lon_field_dt, type: esriFieldTypeDouble
)
-
lat_field_dt
(
modelName: lat_field_dt, nullable: true, editable: true, defaultValue: null, alias: lat_field_dt, type: esriFieldTypeDouble
)
-
total_miles
(
modelName: total_miles, nullable: true, editable: true, defaultValue: null, alias: Total_Miles, type: esriFieldTypeDouble
)
-
rte_nbr
(
modelName: rte_nbr, nullable: true, editable: true, defaultValue: null, alias: RTE_NBR, type: esriFieldTypeInteger
)
-
startmp
(
modelName: startmp, nullable: true, editable: true, defaultValue: null, alias: StartMP, type: esriFieldTypeDouble
)
-
endmp
(
modelName: endmp, nullable: true, editable: true, defaultValue: null, alias: EndMP, type: esriFieldTypeDouble
)
-
cnty_nm
(
modelName: cnty_nm, nullable: true, editable: true, defaultValue: null, length: 256, alias: CNTY_NM, type: esriFieldTypeString
)
-
dist_nm
(
modelName: dist_nm, nullable: true, editable: true, defaultValue: null, length: 256, alias: DIST_NM, type: esriFieldTypeString
)
Templates:
-
Name: Texas_finalmerged
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata