A simple web page that uses data about VA Service locations to create a map with a table of contents.
The data set is curated by the Virginia Department of Social Services and is read-only for the public.
This site was created by volunteers at Code for New River Valley. Pull requests are welcomed, but any changes must utimately be approved and published by VDSS.
Users authorized by VDSS may edit the data in the Google Spreadsheet. Changes to the data will be reflected on the map instantly. Changes cannot be undone, so please take care when editing the data. We recommend that editors download a local copy of the spreadsheet for backup.
The spreadsheet contains a number of sheets, accessible through the tabs at the bottom of the window. The order and title of these sheets determines how the Table of Contents on the website is created.
Each sheet has four required columns: Program, Address, Latitude, and Longitude. The Program column is used to title the info window that pops up on the map when an icon is clicked. The Address column must contain the full street address, including city, state, and zip code. The Latitude and Longitude columns must be created manually (with the headings spelled correctly), but those cells in each row will be filled in automatically.
Any other column will be used to populate the info window that appears when an icon is clicked on the map.
When a new row is added or an address is changed, make sure the cells for Latitude and Longitude are blank. Once the address is correct, click Geocoding in the menu at the top, then click Geocode Rows - Current Sheet. The Latitude and Longitude fields should be filled in automatically.
