[postgis-users] Geocode opinions

[David William Bitner]

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 at thinkheavyindustries.com>
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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080112/e610d408/attachment.html>