PointOnSurface() would be much better than Centroid() as a Centroid may fall outside of the polygon.
On Jan 11, 2008 10:21 PM, easpengren <[EMAIL PROTECTED]> 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 > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- ************************************ David William Bitner
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
