[postgis-users] Geocode opinions

[easpengren]

Unfortunately, I have a few uses for this that I'd like to accomplish. And
that likely makes this a little more complicated than it should be (that's
me in a nutshell).

That data involved is fairly large, it's a list of all the registered voters
(and their voting history, gender, Etc.) in a fairly urban county and all of
the parcels in that county, with detailed data concerning the parcels (type
of parcel, value Etc.). I'd like to be able to serve maps with this data, I
plan to use R to do some geospatial analysis with this and routing data (in
conjunction with pgrouter and road data).

I considered a simple join, and I haven't ruled that out. The issues are
speed, and in the case of analysis, accuracy. I'm pretty new to the
geospatial analysis thing, so I'm kind of going in blind with that.

Would I take a big hit in speed if I just use a join? That's why I was more
interested in inserting the parcel geom into the voter geom.

I decided to use the parcel data for the geocoding because the address data
are perfect for geocoding, and it's quite up to date.

If any of this makes sense, what would people suggest would be better,
centroid data or PT_onsurface?

If it doesn't make sense, let me know, I'll try and take a stab at a better
description.


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
> 

-- 
View this message in context: http://www.nabble.com/Geocode-opinions-tp14768068p14768546.html
Sent from the PostGIS - User mailing list archive at Nabble.com.