Geocodio can help you look up the state legislative districts (state House, state Senate, or Unicameral) districts for addresses or coordinates.
Geocodio is built for batch processing. Whether you have 100 or 100,000,000 addresses, we can help you. This guide will show you how.
You can see an example of the results here.
The first step is to determine how you would like to add the state legislative districts. Do you need an API to get state legislative districts, or do you have a spreadsheet of addresses, such as an Excel file or CSV?
With Geocodio, you can do both. For example, you might have a donor database of 10,000 names and addresses, and then regularly receive new sign-ups on your website. You could backfill the current database via spreadsheet upload, and then integrate our API into your website to add state legislative districts to addresses as they come in.
This section walks you through how to add state legislative districts to addresses or coordinates via spreadsheet upload. If you would like to use an API instead, please see below to the next section.
The first step is to gather the locations into a spreadsheet. With Geocodio, you can upload latitude/longitude coordinates, or addresses. Note, each spreadsheet can only have one or the other; i.e., you cannot convert a list with coordinates for some records and addresses for others in the same upload. You need to do separate uploads.
We support two formats: multi-column and single column. The addresses do not need to be complete, and as long as you have either street + ZIP or street + city + state we will be able to look up the state legislative districts.
Multiple column format:
Street | City | State | ZIP |
---|---|---|---|
960 Orange Avenue | Coronado | CA | |
2050 N Stemmons Fwy | Dallas | TX | |
5020 E Sprague Ave | 99212 |
Single-column format:
Address |
---|
960 Orange Avenue Coronado CA |
2050 N Stemmons Fwy Dallas TX |
5020 E Sprague Ave 99212 |
However, the formats cannot be mixed, as below:
Location | |
---|---|
960 Orange Avenue Coronado CA | |
45.5045128,-73.621345 | |
5020 E Sprague Ave | 99212 |
Next, go to Geocodio's Upload tool and upload the spreadsheet. After confirming the columns and seeing a preview of the file on a map, you will be presented with options to append data. You will want to check the box that says "state legislative districts."
![Screenshot showing state legislative district appends option for spreadsheet uploads](/img/Screen Shot 2020-08-07 at 5.26.27 PM.png)
After you click Submit, the file will start processing. You do not need to stay on the dashboard for the file to process. We will send you an email when the file is done and you can download the file directly from that email.
You can also integrate state legislative district lookups directly into your website or application with the Geocodio API.
The first step is to create an API key. Creating an account and an API key is free. You can create an API key here.
You can add coordinates (or addresses) and state legislative districts to a location all in one go. You can also add other data at the same time, such as Congressional districts. You can see our documentation here.