PointOnSurface() would be much better than Centroid() as a Centroid may fall outside of the polygon.
On Jan 11, 2008 10:21 PM, easpengren <
phat-ass@...> wrote:
I'm sorry, ST_pointonsurface. I should remember not to post when I have a
cold.
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-tp14768068p14769758.html
--
************************************
David William Bitner
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users