search

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

Need better way to determine KCMO neighborhoods than parcel viewer file #23

Closed zmon closed 8 years ago

zmon commented 9 years ago

After loading the address and point files from KCMO's parcel viewer we discovered that we have 73,630 addresses without a value in the neighborhood field.

@rlh-aagis I think we will need to load neighborhoods with shapes and geo locate with them. @Eroche5 do you have good shape files?

            neighborhood              | count 
---------------------------------------+-------
                                       | 73630
 Armour Fields                         |   796
 Armour Hills                          |  1077
 Ashland Ridge                         |   512
 Bannister Ares                        |   584
 Beacon Hills                          |   673

Example of addresses with and without neighborhood for W 12TH ST. 200 and 200 have a neighborhood but 416 and 444 do not.

select single_line_address, neighborhood, city_address_id 
from city_address_attributes a 
left join address_keys k on k.city_address_id = a.id 
left join address d on d.id = k.address_id 
where pre_direction = 'W' and street_name = '12TH' and street_type = 'ST' order by street_number;

        single_line_address        |            neighborhood            | city_address_id 
-----------------------------------+------------------------------------+-----------------
 1000 W 12TH ST, KANSAS CITY, MO   |                                    |          122941
 105 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122606
 106 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122541
 109 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122607
 120 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122540
 1200 W 12TH ST, KANSAS CITY, MO   |                                    |          123207
 1208 W 12TH ST, KANSAS CITY, MO   |                                    |          123208
 1215 W 12TH ST, KANSAS CITY, MO   |                                    |          123236
 1222 W 12TH ST, KANSAS CITY, MO   |                                    |          123209
 1228 W 12TH ST, KANSAS CITY, MO   |                                    |          123210
 1300 W 12TH ST, KANSAS CITY, MO   |                                    |          123198
 1304 W 12TH ST, KANSAS CITY, MO   |                                    |          123199
 1310 W 12TH ST, KANSAS CITY, MO   |                                    |          123200
 1315 W 12TH ST, KANSAS CITY, MO   |                                    |          123222
 1320 W 12TH ST, KANSAS CITY, MO   |                                    |          123201
 1400 W 12TH ST, KANSAS CITY, MO   |                                    |          123191
 1401 W 12TH ST, KANSAS CITY, MO   |                                    |          123224
 1404 W 12TH ST, KANSAS CITY, MO   |                                    |          123192
 1408 W 12TH ST, KANSAS CITY, MO   |                                    |          123193
 1412 W 12TH ST, KANSAS CITY, MO   |                                    |          123194
 1500 W 12TH ST, KANSAS CITY, MO   |                                    |          258878
 1501 W 12TH ST, KANSAS CITY, MO   |                                    |          123241
 1509 W 12TH ST, KANSAS CITY, MO   |                                    |          123242
 1601 W 12TH ST, KANSAS CITY, MO   |                                    |          123243
 1700 W 12TH ST, KANSAS CITY, MO   |                                    |          123258
 200 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122547
 300 W 12TH ST, KANSAS CITY, MO    | Central Business District-Downtown |          122550
 416 W 12TH ST, KANSAS CITY, MO    |                                    |          123012
 444 W 12TH ST, KANSAS CITY, MO    |                                    |          123013
 500 W 12TH ST CE, KANSAS CITY, MO |                                    |          248580
 500 W 12TH ST, KANSAS CITY, MO    |                                    |          123010
 510 W 12TH ST, KANSAS CITY, MO    |                                    |          123011
 523 W 12TH ST, KANSAS CITY, MO    |                                    |          248205
 601 W 12TH ST, KANSAS CITY, MO    |                                    |          123362
 701 W 12TH ST, KANSAS CITY, MO    |                                    |          123349
 711 W 12TH ST, KANSAS CITY, MO    |                                    |          123350
 815 W 12TH ST, KANSAS CITY, MO    |                                    |          123363
(37 rows)
QuestofIranon commented 9 years ago

Would the file used on this map be useful? http://cdb.io/1TP5SdL

QuestofIranon commented 9 years ago

I pushed both a geojson and csv version of the file with those shapes here.

I'm not sure of the background, date they were created, or where exactly they came from though. It was grouped with the landbank data on the map we've been using for PAT, but was already added before I joined the project as I remember. @rlh-aagis might know.

zmon commented 9 years ago

@Eroche5 we have found a file for KCMO neighborhoods, but North of the river is missing. Are there formal neighborhoods North of the river? If so is there a shape file we could have access to?

EricRoche commented 9 years ago

@zmon I will see if I can get something more official uploaded. Remind me if I don't get back to you this week.

EricRoche commented 8 years ago

KCMO_Address_Nbhd (1).zip

Does this work? I had previously shared via Slack.

rlh-aagis commented 8 years ago

Eric,

I was able to use this, although I'm not certain it has incorporated it into the API yet. I will touch base with Paul on Monday about this.

Thanks, Ron

On Tue, Jan 12, 2016 at 10:25 AM, EricRoche notifications@github.com wrote:

KCMO_Address_Nbhd (1).zip https://github.com/codeforkansascity/address-api/files/87592/KCMO_Address_Nbhd.1.zip

Does this work? I had previously shared via Slack.

— Reply to this email directly or view it on GitHub https://github.com/codeforkansascity/address-api/issues/23#issuecomment-170964534 .