[postgis-users] (no subject)
http://djnylen.com/modules/mod_wdbanners/tv.php?html143___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Can´t exit comand after command
Hi, Probably a newbie question, but in putty, when I do certain commands e.g \dt *.* and the results go over more than one page, I can´t seem to exit or end the command. The page ends with the word (END) highlighted and I can´t do anything to start another command. I´ve tried "Ctrl d" but nothing happens Is this a putty problem or a postgresql prob? thanks for anby help, Rob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Attribute query at lat./long. coordinate
On Sun, Nov 27, 2011 at 12:09 PM, Peter Weilandt wrote: > I came across PostGIS in my search for a tool to use in a website. I want > to develop a website that will use a coordinate (lat & long), which is > easily obtained from a user on the client side by clicking on a Google map, > and then transferring this coordinate to the server side where it will be > used to query 4 shapefiles, with each shapefile containing many > (800+) overlapping polygons, extracting the values from 4 fields of the > attribute table for each polygon that contains this coordinate (drill-down > results), saving these values in tabular format for immediate processing, > and then returning derived values to the user on the client side. There is > no map generation required, only extracting data from the attribute > table. This sounds simple in concept, but is PostGIS a tool that can > accomplish the query portion of this process and, if so, are there any > examples showing the code to use for such a query? Peter, I may have been the one who here from your post on the mapserver list. PostGIS most certainly can do what you describe. A simple example: SELECT * FROM polygon_table WHERE St_Intersects( point, polygon_table.geometry); I cheated a little there - you will need to create a point geometry, so expanding that example slightly: SELECT * FROM polygon_table WHERE St_Intersects( ST_Point($x, $y), polygon_table.geometry); The above assumes $x and $y came from your user's point click and are being passed into your SQL query via a server-side programming language such as PHP. You may need to define the spatial reference system (SRID) with: ST_SetSRID( ST_Point($x, $y), 4326 ) HTH, Rich -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Attribute query at lat./long. coordinate
On Nov 27, 2011, at 1:09 PM, Peter Weilandt wrote: > I came across PostGIS in my search for a tool to use in a website. I want to > develop a website that will use a coordinate (lat & long), which is easily > obtained from a user on the client side by clicking on a Google map, and then > transferring this coordinate to the server side where it will be used to > query 4 shapefiles, with each shapefile containing many (800+) overlapping > polygons, extracting the values from 4 fields of the attribute table for each > polygon that contains this coordinate (drill-down results), saving these > values in tabular format for immediate processing, and then returning derived > values to the user on the client side. There is no map generation required, > only extracting data from the attribute table. This sounds simple in concept, > but is PostGIS a tool that can accomplish the query portion of this process > and, if so, are there any examples showing the code to use for such a query? Sure, PostGIS is a very good tool for this, and if you are using PostGIS, you are no longer talking about Shapefiles... ostensibly you are using PostGIS so you can do away with files. Just load your Shapefiles into Postgres (with the help of PostGIS, of course). Send your lat/lng pair to the server, do your queries using ST_Within or ST_Contains (or whatever your heart desires) and send the data back to the client. See http://earth-base.org/trees/ for an example. When the trees polys load on the map, click anywhere on North America and see the results in a popup. -- Puneet Kishor ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Attribute query at lat./long. coordinate
I came across PostGIS in my search for a tool to use in a website. I want to develop a website that will use a coordinate (lat & long), which is easily obtained from a user on the client side by clicking on a Google map, and then transferring this coordinate to the server side where it will be used to query 4 shapefiles, with each shapefile containing many (800+) overlapping polygons, extracting the values from 4 fields of the attribute table for each polygon that contains this coordinate (drill-down results), saving these values in tabular format for immediate processing, and then returning derived values to the user on the client side. There is no map generation required, only extracting data from the attribute table. This sounds simple in concept, but is PostGIS a tool that can accomplish the query portion of this process and, if so, are there any examples showing the code to use for such a query? ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Building GEOS 3.3.1 on Ubuntu
Thanks! I altered http://trac.osgeo.org/geos/wiki/BuildingOnUnixWithAutotools to make it more clear--skip the first step if you aren't using the "straight from SVN" copy. For some reason, autogen.bat was included in the 3.3.1 .tar.gz but not autogen.sh. That threw me off, but now I see that autogen appears to only be needed to make the configuration file? The last time I compiled a C++ program was during my CS undergrad, and it shows. :-) Aren On Sun, Nov 27, 2011 at 12:08 AM, Mike Toews wrote: > Skip the autogen.sh step, since you didn't download via SVN (that's > what the instructions say). Here are your steps for Ubuntu from the > geos-3.3.1 directory: > > ./configure > make > make check > sudo make install > sudo ldconfig > > > -Mike > > On 27 November 2011 18:47, Aren Cambre wrote: > > I realize this is not the GEOS email group, but 3.3.1 appears to be a > prereq > > for running PostGIS 2.0? Ubuntu's most recent GEOS package is 3.2.2. > > I can't get the builds to work. Below is a copy of the documentation bug > > report I filed with the GEOS developers. What can be suggested to them to > > get their instructions fixed? Or am I doing something wrong? > > > > Aren > ___ > 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
