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 <si...@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.bi...@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: si...@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
