[postgis-users] Allocating house numbers to a parcel table
sindile.bidla at gmail.com
Wed Mar 21 00:22:58 PDT 2012
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:
> 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
> On Tue, 20 Mar 2012 23:39:46 +1100, Sindile Bidla <sindile.bidla at gmail.com>
> 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users