I'm starting a project from scratch but am budget constrained. In plain language I've got no money. What I want is to provide an address and return what governments have jurisdiction there. The identity of the governments will be coming from the US Census Bureau, though I am not sure they have borders of these governments.
I'm currently considering converting the address to lat/lon coordinates and defining that as a point and defining all ~90k US governments as polygons and then running a search. The large majority of governments are going to be in a different state so the ~90k number will be cut down by a lot just by filtering by state. Is setting up 50 layers (or 50 database tables) with all governments present in a state and then running the analysis only in that layer realistic? Or am I going to need to make enough layers to do it by counties? I'm trying to get at how much calculation am I avoiding if I restrict the geography of the polygons. How much restriction would likely be optimal?
When the GIS database is set up, people will be able to query for "their" results, more exactly the results of the address they put in. I'm also going to create a background task to process addresses ahead of time. The more efficient the calculations, the more I can precalculate.