<!DOCTYPE html><html><head>
<style type="text/css">"body { font-family:'Times New Roman'; font-size:13px"}</style>
</head>
<body><div>Sindile,</div><div><br></div><div>Questions: What is the source of the house numbers? Does a "particular street segment " contain house numbering</div><div>in attributes - From_Left/To_Left/From_Right/To_Right (or equivalent naming)?</div><div><br></div><div>S</div><div>On Tue, 20 Mar 2012 23:39:46 +1100, Sindile Bidla <sindile.bidla@gmail.com> wrote:<br></div><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><p> I have two tables (street and parcel) in my Postgis database and I would like to perform the following:<br>
1. Select a particular street segment<br>
2. Select all parcels to the left or right of 1<br>
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.</p>
<p>This is to allow me to allocate house numbers to my parcel table.</p>
</blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>SpatialDB Advice and Design, Solutions Architecture and Programming,<br>Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>Website: www.spatialdbadvisor.com<br> Email: simon@spatialdbadvisor.com<br> Voice: +61 362 396397<br>Mobile: +61 418 396391<br>Skype: sggreener<br>Longitude: 147.20515 (147° 12' 18" E)<br>Latitude: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></body></html>