<html><body><div style="color:#000; background-color:#fff; font-family:garamond, new york, times, serif;font-size:14pt">Hello, I've just got postgresql93-server installed, with postgis21-postgresql93 on a CentOS system.<br style=""><br style="" class="">I then used shp2pgsql to load in some shape files using this procedure:<br style="" class=""><br style="" class=""><a style="" class="" href="http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/shp2pgsql.html">http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/shp2pgsql.html</a><br style="" class=""><br style="" class="">The shapefiles were obtained from NWS:<br style="" class=""><a style="" class="" href="http://www.nws.noaa.gov/geodata/catalog/wsom/html/pubzone.htm">http://www.nws.noaa.gov/geodata/catalog/wsom/html/pubzone.htm</a><br style="" class=""><br style="" class="">Everything appears to have been written to the database properly:<br style="" class=""><br style=""
class="">polydata=# select state,time_zone,zone,name,lon,lat from polys where state='CO' limit 10;<br style="" class=""> state | time_zone | zone | name | lon | lat <br style="" class="">-------+-----------+------+----------------------------------+----------------+---------------<br style="" class=""> CO | M | 048 | Logan County | -103.110114271 | 40.7246902558<br style="" class=""> CO | M |
044 | Morgan County | -103.809823690 | 40.2627093692<br style="" class=""> CO | M | 050 | Sedgwick County | -102.351810279 | 40.8758426210<br style="" class=""> CO | M | 049 | Washington County | -103.201287262 | 39.9710250432<br style="" class=""> CO | M | 090 | Yuma County | -102.424258955 |
40.0029195574<br style="" class=""> CO | M | 099 | Springfield Vicinity/Baca County | -102.560453567 | 37.3192132374<br style="" class=""> CO | M | 097 | Las Animas Vicinity/Bent County | -103.071690129 | 37.9551177349<br style="" class=""> CO | M | 092 | Cheyenne County | -102.603398004 | 38.8279341557<br style="" class=""> CO | M | 089 | Crowley County | -103.784878922 | 38.3266440954<br style="" class=""> CO |
M | 091 | Kit Carson County | -102.602884309 | 39.3054124576<br style="" class="">(10 rows)<br style="" class=""><br style="" class="">polydata=#<br><br>My goal is to construct a query providing lat/lon such that the result returned is the single row poly containing that point.<br><br>Does anyone know how I would construct this query?<br style="" class=""><div style="" class="">
<br>Thanks!<br><br>Regards,<br>Joseph Spenner<br><br style="" class=""></div></div></body></html>