The short description for this project would be "AN INTERACTIVE STREET MAP INDEX"
I am an hourly paid courier in need of a phone app that would allow me to quickly build a list of addresses. This project is not supported, endorsed, paid for or even known by the company I work for. It is a personal productivity tool.
The purpose of this app is to quickly(keyword) build a sortable list of addresses and use that list with a street map. In my job it is not practical to use GPS, there are just too many addresses to input and not enough time. Paper maps are still the fastest and best tool. This project will combine a digital index with a paper map.
The data I have is a list of all streets in each zip code. For some of the data I have a map index column. Eventually all streets will have info in the index column. Some streets may have a START and END number range and some streets may have notes. The app should be able to let me add to the data as I use it.
The way the app should work in steps is..
Select zip codes and load the street list of selected zip codes into one master list.
Select streets from the master list by typing the first few letters. The app should reduce the list so I can select the desired street or enter the whole street name if the street does not exist.
Enter house/building number. The app should remember previous house numbers entered and allow me to select from a list of house numbers for a specific street.
Select package location (optional entry). I can drive two types of vehicles. There can be three to thirteen location options, I may want to note the package location in the truck. The app should remember the last location selected until I change it. Examples of package loctions are BIN, SIDE DOOR, BACK DOOR, UPPER DRIVER SIDE FRONT SHELF, PASSENGER SIDE FLOOR BACK, etc..etc.
Once the street is selected, house numbered entered and package location identified, I should be able to add the info to the current address list. The database will have an INDEX ID for each street, that info is also included in the address list. The INDEX ID is the page number and grid number for where the street is located on the paper map.
From the address list I should be able to switch between the full address list (sortable by steet name, zip, index) and an INDEX list. The index list should show how many addresses are in each index. Tapping on one of the INDEXes should show me list of addresses within that index. Tapping on a street address should show me the index, package location, notes and an option to google map that address. There should also be a check box to check when I completed that address. I should also be able to check off from the INDEX list too.
Other information I should see are totals and percentages (total addresses, addresses done, addresses not done)
As I continue to build my database on a as-needed basis, I should be able to import the data to the app as a CSV file.
Attached is a very crude illustration of the various screens needed.