codeforkansascity / address-api

A address database accessible through an API that will return attributes about the address, neighborhood, council district, zoning...
http://address-api.codeforkc.org
MIT License
5 stars 9 forks source link

Hitting Loma Vista neighborhood breaks the address api. #124

Open JakeLaCombe opened 7 years ago

JakeLaCombe commented 7 years ago

The following endpoint appears to break the address api.

http://dev-api.codeforkc.org/address-by-neighborhood/V0/Loma%20Vista?city=Kansas%20City&state=MO

If there are too many addresses there, perhaps paginated limits should be there?

gregbonner commented 7 years ago

Looking at the query, we are probably returning too many columns. Is there a minimum set of columns that your site needs that endpoint to return? If we can trim it down to some basic columns such as address, lat, lng, etc, we can return all of the rows. This is one of the bigger neighborhoods, so if this works, we should be safe for the other large datasets.