[postgis-users] Geocode opinions

[Josh Livni]

What are you trying to accomplish?  Do you need to have a duplicate 
style geometry in the people table, or can you just make a join table 
and get people and geometries associated more dynamically each query?   
I guess I'm confused about what your end goal is. 

Of course others may not be... but just in case, can you describe your 
use-case in more detail?

  -Josh



easpengren wrote:
> I'm in the process of working out a way of geocoding using parcel shape data
> that I got from my local planning department. It's very nice, if very data
> specific, I wish I could share it. I will if anybody is interested, but it's
> not likely to scale to other applications.
>
> I've dumped the parcel data into PostGIS and I'm dumping the data of people
> who live in the area into the same database. I plan to do a pretty simple
> join between the two tables (with address data) and insert the geometry data
> from the parcels into the people table.
>
> Now I'm wondering, should I insert a centroid or PT_onsurface point from the
> parcels? Or is their a better option?
>
> Eric Aspengren
>