Airtable Extension To Query Geospatial Data
An extension that allow users join geospatial data to Airtable tables
Use our extension that seamlessly integrates into your existing Airtable table.
Create Your Data Source
Our extension relies on a polygon type data source. So if you do not have one yet, create one using our app with your own shape files or Airtable table. Please make sure you choose the option pre-compute if you decide to use Airtable as the data source for your tile.
Once your data-source is done processing and you see the state as Ready you can go ahead and copy the link for the endpoint.
Query Clockwork Micro API Through Airtable
Create a field that will correspond to the type of data you want to use from the intersections. If you are not sure about the type of data, you can use a generic long text field. After creating this field you are now ready to use the extension!
Select the fields for the latitude and longitude from your table. These fields will be used to query for properties within your tile.
Next, select the field that you just created. This field will be populated by the results of the API call.
Paste the data source endpoint from clockworkmicro.com. You can now perform a look-up operation in order to find out what properties you can use from a possible intersection.
After clicking on the Get Properties button, property fields will be made available when found.
Select the option you would like to use to populate the field you created in your table. Multiple values will be shown as a list with commas in between, i.e. result_A, result_B.
After selecting the property, all you need to do now is to click Submit. Using the selected property from the intersections, you field will be updated.