| snippet:
|
Drives the ADT/Traffic web application for the Transportation Dept. This file is a merged file of multiple datasets from multiple years. It includes the following: INVENTORY, BEG_STA, END_STA, AADT, AADT_YR, COUNTY_HWY, FCNAME, FUNC_CLASS, LANES, MAINT_TYPE, MARKED_RT, MUNI_NAME, ROAD_NAME, SEG_LENGTH, SP_LIM, SURF_TYP, SURF_YR
The subset from each download for merging (plus any required geo-position columns such as OBJECTID, SHAPEID, etc.):
SELECT INVENTORY, BEG_STA, END_STA, AADT, AADT_YR, COUNTY_HWY, FCNAME, FUNC_CLASS, LANES, MAINT_TYPE, MARKED_RT, MUNI_NAME, ROAD_NAME, SEG_LENGTH, SP_LIM, SURF_TYP, SURF_YR
FROM [GISSDE].[GIS].[HWY2015]
where MUNI_NAME = 'SCHAUMBURG' AND AADT_YR = 2015 AND AADT > 0 |
| summary:
|
Drives the ADT/Traffic web application for the Transportation Dept. This file is a merged file of multiple datasets from multiple years. It includes the following: INVENTORY, BEG_STA, END_STA, AADT, AADT_YR, COUNTY_HWY, FCNAME, FUNC_CLASS, LANES, MAINT_TYPE, MARKED_RT, MUNI_NAME, ROAD_NAME, SEG_LENGTH, SP_LIM, SURF_TYP, SURF_YR
The subset from each download for merging (plus any required geo-position columns such as OBJECTID, SHAPEID, etc.):
SELECT INVENTORY, BEG_STA, END_STA, AADT, AADT_YR, COUNTY_HWY, FCNAME, FUNC_CLASS, LANES, MAINT_TYPE, MARKED_RT, MUNI_NAME, ROAD_NAME, SEG_LENGTH, SP_LIM, SURF_TYP, SURF_YR
FROM [GISSDE].[GIS].[HWY2015]
where MUNI_NAME = 'SCHAUMBURG' AND AADT_YR = 2015 AND AADT > 0 |