Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Some notes from a real use case #13

Open
alankjackson opened this issue Apr 14, 2019 · 1 comment
Open

Some notes from a real use case #13

alankjackson opened this issue Apr 14, 2019 · 1 comment

Comments

@alankjackson
Copy link

I just used the package to help turn a 200,000 record permit database into a geocoding file (https://cohgis-mycity.opendata.arcgis.com/datasets/permits-wm-structural?geometry=-97.509%2C29.379%2C-93.263%2C30.213)

A few things I noted.

A handful of records were missing the zip, and I didn't see a filter to remove those records, so I used:

geo2 <- pm_postal_detect(geo2) %>% 
  filter(pm.hasZip==TRUE) %>% 
  select(-pm.hasZip)

A few records had unit numbers attached to the house number (no blank), for example:

7301#1 AVE K, 77011
5146#2 LONGMONT DR, 77056
1212A W DREW ST, 77006
2002C GENESEE ST, 77006

so I cleaned them up with

geo2$pm.house <- str_remove(geo2$pm.house, "[A-Z#][0-9]*")

In general the package performed very well. Thanks for your efforts.

@chris-prener
Copy link
Member

thanks @alankjackson - we're getting an update ready to deal with units like what you've described there. we don't intend to duplicate dplyr's subsetting functionality at this time - so that would be how we would recommend going about this. Glad to hear it is working well - we'll have a big update out soon!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants