openva / vabusinesses.org

Website for Virginia State Corporation Commission data.
https://vabusinesses.org/
MIT License
4 stars 1 forks source link

Some Roanoke businesses show up in the city and the county #37

Closed waldoj closed 9 years ago

waldoj commented 9 years ago

"Windy Lane Associates Limited Partnership" (L014822) is showing up in both Roanoke County and Roanoke city's data. (That isn't true for all Roanoke city businesses, so we can rule out a failure to carve out the city from the county boundary data.) Its address is two miles from the city/county boundary, so it seems unlikely that this is just some minor error in the boundary alignment for the two.

Figure out what's going on here and fix it.

waldoj commented 9 years ago

Now it's not showing up at all, which is certainly a step backward. It's not indexed by Elasticsearch.

$ curl -XGET 'http://localhost:9200/business/_search?q=L014822'
{"took":308,"timed_out":false,"_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":0,"max_score":null,"hits":[]}}
waldoj commented 9 years ago

But it is in the data:

$ grep L014822 3_lp.csv
True,L014822,WINDY LANE ASSOCIATES LIMITED PARTNERSHIP,ACTIVE,1998-02-24,2050-12-31,1998-02-24,VIRGINIA,,4139 BRANDON AVENUE,,ROANOKE,VA,24018,"[-80.0190543362054, 37.26439840085524]",,DAVID C HELSCHER,3140 CHAPARRAL DR STE 200-C,,ROANOKE,VA,24018,2005-07-25,4,ROANOKE COUNTY

So that's still an Elasticsearch problem, not a Crump problem.

waldoj commented 9 years ago

Aaaand now it's showing up again, and it's correctly appearing only in the city. I have absolutely no idea of what I changed to cause this to work properly.