search

CityOfLosAngeles / hcid-lookup-tool

A lookup tool for data from LAHD. Repository has been archived 2022-10-13.
Apache License 2.0
0 stars 3 forks source link

APN clarification #13

Open rhouse00 opened 7 years ago

rhouse00 commented 7 years ago

@hunterowens @gracebenedicto

Per the conference call Friday, it was our understanding that the APN numbers, are not suitable to use as a unique identifier for a given address. Is this accurate?

hunterowens commented 7 years ago

Yep! APNs sometimes change.

The APN Change File is published on the LA County Open Data Site. You can write custom logic based on that file to merge on APNs

rhouse00 commented 7 years ago

Thanks for the info.

I just did some searches of APNs from the first few rows of _propunit.csv, into the APN Change File, and most came back as "No Rows To Display". I searched further down, and did get a couple of hits, but some more misses as well.

I think we will continue using address as our common identifier across all the csv files.

hunterowens commented 7 years ago

@rhouse00

Miss - APN is constant Hit - APN has changed

rhouse00 commented 7 years ago

for the "Hit - APN has changed", is the AIN in the APN Change File the new apn, or the old apn?

hunterowens commented 7 years ago

Check the Parcel status field to see what happened to the AIN

On Wed, Mar 8, 2017 at 5:37 PM, Ryan House notifications@github.com wrote:

for the "Hit - APN has changed", is the AIN in the APN Change File the new apn, or the old apn?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/datala/hcid-lookup-tool/issues/13#issuecomment-285227491, or mute the thread https://github.com/notifications/unsubscribe-auth/ABp74kN7S6yER2RXdb3YCdOJW1Y0U_F4ks5rj1fsgaJpZM4MTPYY .

rhouse00 commented 7 years ago

Thanks. I figured out how to read what's going on in that file. Gonna need time to digest, to see if this can be utilized and if so, how.

hunterowens commented 7 years ago

For sure - Welcome to the complicated world of address + locations!

On Wed, Mar 8, 2017 at 5:48 PM, Ryan House notifications@github.com wrote:

Thanks. I figured out how to read what's going on in that file. Gonna need time to digest, to see if this can be utilized and if so, how.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/datala/hcid-lookup-tool/issues/13#issuecomment-285229360, or mute the thread https://github.com/notifications/unsubscribe-auth/ABp74nmd2LUThZh1xyfzmQEiwiC-AS86ks5rj1pwgaJpZM4MTPYY .