[postgis-users] Allocating house numbers to a parcel table

Simon Greener simon at spatialdbadvisor.com
Tue Mar 20 15:47:57 PDT 2012


Questions: What is the source of the house numbers? Does a "particular street segment " contain house numbering
in attributes - From_Left/To_Left/From_Right/To_Right (or equivalent naming)?

On Tue, 20 Mar 2012 23:39:46 +1100, Sindile Bidla <sindile.bidla at gmail.com> wrote:

> I have two tables (street and parcel) in my Postgis database and I would like to perform the following:
> 1. Select a particular street segment
> 2. Select all parcels to the left or right of 1
> 3. Update a field in parcels selected in 2 with numbers (odd numbers if to the left of 1 or even numbers if to the right of 1.
> This is to allow me to allocate house numbers to my parcel table.

Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: simon at spatialdbadvisor.com
Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120321/4bbae252/attachment.html>

More information about the postgis-users mailing list