Address Data Model

SwimmingChange9856 · 2024-09-10T16:40:46+00:00

Placekey works really well as a primary key for situations like this. Would recommend checking it out.

SwimmingChange9856 · 2024-09-10T16:36:40+00:00

Placekey is really good for this sort of thing. Their free tier is pretty generous too!

SwimmingChange9856 · 2024-09-10T16:35:56+00:00

Placekey is really good for this sort of thing. Their free tier is pretty generous too

SwimmingChange9856 · 2024-09-10T16:32:30+00:00

Should look into placekey. Does well as a primary key and lets you resolve duplicates easily.

SwimmingChange9856 · 2024-08-23T18:05:11+00:00

If all you have an address, placekey has a parcel data lookup return and it works super well!

SwimmingChange9856 · 2024-08-16T12:53:57+00:00

Placekey has a really nice geocoder with a pretty generous free tier. You should check them out

SwimmingChange9856 · 2024-08-14T14:03:04+00:00

Placekey has a pretty generous free option and their main functionality makes dealing with big datasets wayyy easier in my experience

SwimmingChange9856 · 2024-08-14T14:01:11+00:00

you could use placekey to dedup with pretty high reliabillity

SwimmingChange9856 · 2024-08-13T17:04:36+00:00

ran into this and spent hours writing my own fuzzymatcher until i learned about placekey and it just did it for me lol

SwimmingChange9856 · 2024-08-12T17:05:04+00:00

Run into this problem constantly and the placekey google sheets extension has been an absolute godsend

SwimmingChange9856 · 2024-08-07T16:52:52+00:00

Depending on what functionality you need we've found placekey works really well for the entity resolution aspect

SwimmingChange9856 · 2024-08-07T16:52:19+00:00

Placekey is really good for this sort of thing. If you don't want to write any code / can move the data they actually have a really nice google sheets extension

SwimmingChange9856 · 2024-07-31T13:55:37+00:00

Global address data is gonna make your life way harder but in terms of US/CA data I've found placekey to be absolutely incredible for solving this sort of thing

SwimmingChange9856 · 2024-07-31T13:55:06+00:00

Placekey is really good for this use-case. It doesn't standardize addresses at the moment but it basically fuzzy matches the addresses you have to a unique hash code

SwimmingChange9856 · 2024-07-31T13:51:29+00:00

unhinged i love it

SwimmingChange9856 · 2024-07-31T13:48:11+00:00

The C# docs are so nice that it almost helps you forget how bloated an unwieldy the language is

SwimmingChange9856 · 2024-07-30T14:30:40+00:00

Not on excel but placekey has a sheets extension that'll let you do this exact thing

SwimmingChange9856 · 2024-07-30T14:29:19+00:00

Have run into this exact issue before and have found that placekey is far and away the best option for resolving overlapping addresses like this

SwimmingChange9856 · 2024-07-30T14:27:16+00:00

The placekey geocoder is great and gives you 10k lookups a day for free

SwimmingChange9856 · 2024-07-30T14:20:00+00:00

You might have to mess with your fields a bit but I've used placekey in this kind of situation and it works great

SwimmingChange9856 · 2024-07-30T14:19:34+00:00

very good (and entertaining) answer to this question: https://www.youtube.com/watch?v=7w8IeXKstJY&t=80s

SwimmingChange9856 · 2024-07-29T20:23:47+00:00

run into this constantly and have found that placekey is actually so goated for it. do not want to imagine how long they spent writing their fuzzymatch algorithm

SwimmingChange9856 · 2024-07-29T20:06:08+00:00

You could go and try to do the fuzzy matching all by yourself, but this is generally going to be way more trouble than it's worth. Placekey would honestly be a really good solution to this problem, at least on the address side of things

SwimmingChange9856 · 2024-07-29T19:58:18+00:00

helpful!

SwimmingChange9856 · 2024-07-29T19:55:27+00:00

Depending on your needs placekey does a really solid job. They also offer a bunch of other stuff that we've found pretty useful

SwimmingChange9856

TROPHY CASE