The layers in this map are used to report the mileage of vehicles within the City of Gillette by the year and quarter. The layers are based on a feature class called avlPathToHistory and view called avlVehicleQuarterMiles.

This service has numerous types over many fields. Please refer to the data to find the appropriate information.

Important fields in the service include, but are not limited to Unit ID, Unit Title, Vehicle Group, Miles, Quarter, Departments, Division, ReferenceID, Title, Division, Quarter, Year, Days, Total Miles. There are no ArcGIS standard fields.

The layers and view have definition queries assigned. The queries return the AVL paths for 2016, 2017, 2018, 2019, and a quarter report the these years.

AVL Path 2016:

DATESTAMP >= '2016-01-01 00:00:00' AND DATESTAMP <= '2016-12-31 00:00:00'

AVL Path 2017:

DATESTAMP >= '2017-01-01 00:00:00' AND DATESTAMP <= '2017-12-31 00:00:00'

AVL Path 2018:

DATESTAMP >= '2018-01-01 00:00:00' AND DATESTAMP <= '2018-12-31 00:00:00'

AVL Path 2019:

DATESTAMP >= '2019-01-01 00:00:00' AND DATESTAMP <= '2019-12-31 00:00:00'

avlVehicleQuarterMiles

Year >= '2016'

There are not Related Tables are associated with these Feature Classes:

For more information, please contact the City of Gillette GIS Division at (307) 686-5364 or gisadmin@gillettewy.gov.
None
[{'id': 1, 'name': 'SDE.WEBREADER.%avlVehicleQuarterMiles', 'type': 'Table'}, {'id': 2, 'name': 'SDE.DBO.avlQuarterReport', 'type': 'Table'}]
{'Title': 'AVL - Quarter Report', 'Author': 'City of Gillette', 'Comments': "The layers in this map are used to report the mileage of vehicles within the City of Gillette by the year and quarter. The layers are based on a feature class called avlPathToHistory and view called avlVehicleQuarterMiles.\n\nThis service has numerous types over many fields. Please refer to the data to find the appropriate information.\n\nImportant fields in the service include, but are not limited to Unit ID, Unit Title, Vehicle Group, Miles, Quarter, Departments, Division, ReferenceID, Title, Division, Quarter, Year, Days, Total Miles. There are no ArcGIS standard fields.\n\nThe layers and view have definition queries assigned. The queries return the AVL paths for 2016, 2017, 2018, 2019, and a quarter report the these years.\n\nAVL Path 2016:\n\nDATESTAMP >= '2016-01-01 00:00:00' AND DATESTAMP <= '2016-12-31 00:00:00'\n\nAVL Path 2017:\n\nDATESTAMP >= '2017-01-01 00:00:00' AND DATESTAMP <= '2017-12-31 00:00:00'\n\nAVL Path 2018:\n\nDATESTAMP >= '2018-01-01 00:00:00' AND DATESTAMP <= '2018-12-31 00:00:00'\n\nAVL Path 2019:\n\nDATESTAMP >= '2019-01-01 00:00:00' AND DATESTAMP <= '2019-12-31 00:00:00'\n\navlVehicleQuarterMiles\n\nYear >= '2016'\n\nThere are not Related Tables are associated with these Feature Classes:\n\nFor more information, please contact the City of Gillette GIS Division at (307) 686-5364 or gisadmin@gillettewy.gov.", 'Subject': 'This map service displays statistics for quarterly AVL activity within the City of Gillette.', 'Category': '', 'AntialiasingMode': 'None', 'TextAntialiasingMode': 'Force', 'Version': '10.1', 'Keywords': 'avl,quarter reports,vehicles,departments,divisions,City of Gillette'}
nan
nan