| 01:29:43 | plasmab: | : ) |
| 01:30:06 | plasmab: | nothing |
| 01:30:13 | plasmab: | think my client went nuts |
| 01:30:20 | plasmab: | i accidentally typed /join |
| 01:30:47 | plasmab: | :( |
| 01:30:47 | plasmab: | sorry |
| 07:12:15 | c0re: | does anyone know if ST_ExteriorRing still works with a MULTIPOLYGON? |
| 07:16:50 | c0re: | nm... |
| 12:22:16 | david__: | Does anyone have recommendations on a Python/Postgres module? |
| 12:22:54 | david__: | I am using William K's binaries on Leopard with the system python, I don't want to install anything that will break that |
| 12:32:56 | springmeyer: | david__: psycopg2 is what I use as a driver/adapter - that what you mean by a module? |
| 12:33:13 | springmeyer: | http://postgis.refractions.net/support/wiki/index.php?PostgisAndPython |
| 12:33:14 | sigq: | Title: PostGIS Wiki : Postgis And Python ( at postgis.refractions.net ) |
| 12:39:52 | david__: | Thanks. |
| 12:42:19 | bitner: | zanberdo: what does select postgis_full_version( ); give you |
| 12:42:27 | zanberdo: | I have a postgis database I"m trying to query using an st_within clause but I continue to get the error function st_within( geometry, geometry ) does not exist. I can use within ( omitting st_ ). I have postgresql 8.2 and postgis 1.3.3-1 |
| 12:42:35 | zanberdo: | checking |
| 12:43:07 | zanberdo: | heh.. and error by the looks of it. |
| 12:43:16 | zanberdo: | typo |
| 12:43:17 | zanberdo: | my bad |
| 12:44:50 | zanberdo: | POSTGIS="1.3.3" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS ( procs from 1.1.2 need upgrade ) |
| 12:49:08 | bitner: | can you look in your public schema and see if postgis st_ functions are in your db |
| 12:50:53 | : | * bitner heads home for the weekend, ciao |
| 12:57:31 | zanberdo: | bitner: I will check it out. Thank you so much for your help today. I've added spatial indicies to the relevant tables and I"m seeing a tremendous improvement already. I will continue looking into the st_ functions as well. |
| 13:01:56 | zanberdo: | you are likely gone for the weekend, but in case you are not, the answer is there are no st_ function in the public schemas for my database. Though it's occured to me that the original database was created a year ago and migrated to 8.2. I wonder if the first time I created it the language didn't have the st_ function. |
| 13:02:08 | zanberdo: | I will play with it and see what I can come up with. |
| 13:02:13 | zanberdo: | thanks again! ciao |
| 14:43:24 | zanberdo: | I have written a query that will return the_geom from a table where the_geom is within the results of a subquery. This works so long as the subquery returns only a single matching record. However, the subquery might return multiple records. What might be the proper approach to handle this scenario? I'm just looking for guidance not expecting too much hand-holding... |
| 14:44:34 | zanberdo: | I'm thinking that ulitmately the results of the initial query needs to be a single table that include all data from all the records that match in the subquery... |
| 14:45:45 | zanberdo: | so for instance, my current query looks like: select the_geom from foo where within( the_geom, ( select the_geom from bar where some_condition ) ); |
| 14:45:59 | zanberdo: | the select bar where some_condition can return multiple rows... |
| 14:46:26 | zanberdo: | postgresql returns an error "more than one row returned by a subquery used as an expression", which makes sense |