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

[Sindile Bidla]

Dear Simon,

Each of the street segments have no attributes related to house numbers.
The only relationship is whether the parcels are to the left or right of a
particular street segment - furthermore house numbers were never allocated
to any of the parcels.

On 21 March 2012 00:47, Simon Greener <simon at spatialdbadvisor.com> wrote:

> **
> Sindile,
>
> 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)?
>
> S
> 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
> NAC:W80CK 7SWP3
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120321/57418564/attachment.html>