| 00:11:28 | CIA-4: | strk * r4213 /trunk/doc/html/image_src/ ( Makefile.in st_buffer03.wkt st_buffer04.wkt st_buffer05.wkt ): Add examples of different encdap styles |
| 02:52:38 | CIA-4: | strk * r4214 /trunk/doc/html/image_src/ ( st_buffer03.wkt st_buffer04.wkt st_buffer05.wkt ): Use thin link style for source linestring |
| 03:14:58 | CIA-4: | strk * r4215 /trunk/doc/ ( 5 files in 2 dirs ): Add more styled buffer example images and update reference manual to include them |
| 03:56:20 | CIA-4: | strk * r4216 /trunk/doc/html/image_src/ ( st_buffer01.wkt st_buffer02.wkt ): Make quad_segs images style consistent with others; add original point |
| 03:56:49 | CIA-4: | strk * r4217 /trunk/doc/reference.xml: Put queries right below the diagram showing them |
| 05:33:21 | Skinkie: | Is there any pretty research paper mentioning the use of Egenhofer matrix within Postgis, as so is mentioned on Wikipedia on the article on Postgis? |
| 06:48:57 | dougleftt: | hi all, could someone tell me if this query shows a bug in postgis? http://pastebin.com/d7832ee94 |
| 06:48:58 | sigq: | Title: pastebin - collaborative debugging tool ( at pastebin.com ) |
| 07:11:43 | clj2289: | hi, I have build and installed postgis 1.4 beta, however, I can not find the lwpostgis.sql file, where could it be living? |
| 07:20:02 | dougleftt: | clj2289: what platform? |
| 07:20:11 | clj2289: | ubuntu server 8.04 |
| 07:20:14 | dougleftt: | clj2289: could be /usr/share/postgresql/contrib |
| 07:21:33 | clj2289: | its not there... |
| 07:23:26 | clj2289: | hmm...I wonder if this version is different..in the readme file it says to do: psql -f postgis/postgis.sql -d <your_database> |
| 07:26:11 | strk: | my /usr/share/postgresql/8.3/contrib/ contains postgis.sql |
| 07:26:24 | strk: | it's put there on make install |
| 07:57:31 | TJCRI: | pramsery or strk in the house? |
| 07:57:35 | TJCRI: | pramsey |
| 07:57:39 | strk: | me |
| 07:57:53 | TJCRI: | ok I just verified that issue I had the other day |
| 07:58:10 | strk: | go ahead |
| 07:58:23 | TJCRI: | step 1 - process shapefile with no SRID ( defaults to -1 ) |
| 07:58:30 | TJCRI: | step 2 - run query: select st_astext( st_transform( st_setsrid( 'POINT( -85.6794318 42.9633618 )',4326 ),2898 ) ); |
| 07:58:37 | TJCRI: | this changes lat/long to 2898 |
| 07:58:45 | TJCRI: | and it works |
| 07:58:55 | strk: | gah |
| 07:59:02 | strk: | ah, yes, fine |
| 07:59:08 | TJCRI: | step 3 - select column from tablename where ST_Contains( the_geom, st_transform( st_setsrid( makePoint( -85.6794318, 42.9633618 ), 4326 ), 2898 ) ); |
| 07:59:14 | TJCRI: | ERROR: Operation on two geometries with different SRIDs |
| 07:59:19 | strk: | that's correct |
| 07:59:45 | TJCRI: | now if I upload the shapefile with proper srid 2898, then step 3 works |
| 07:59:45 | strk: | the bug would have been getting no ERROR : ) |
| 08:00:03 | strk: | makes sense |
| 08:00:12 | strk: | so no bug |
| 08:00:22 | TJCRI: | or as in the case the other day I was able to get it to work via updating the srid in the table |
| 08:01:08 | strk: | right |
| 08:01:48 | TJCRI: | ok so no bug? just a nice feature : ) seems like it should work regardless of what srid is set to ( in this case, -1 was the default ) - and I only say this because I am telling it in the st_transform( st_setsrid( makePoint( -85.6794318, 42.9633618 ), 4326 ), 2898 ) statement to convert to similar format as what is in the_geom |
| 08:02:06 | TJCRI: | but just wanted to let you know I was able to repeat it with diff. set of shape files |
| 08:02:22 | strk: | yes, it's all fine |
| 08:02:36 | strk: | just postgis refused to do something on two geoms with different SRIDs |
| 08:02:40 | strk: | ( 2898 and -1 ) |
| 08:02:55 | TJCRI: | right that makes sense |
| 08:03:30 | TJCRI: | ok at the very least I have updated my shp2pgsql to use the -s 2898 from now on : ) |
| 08:03:37 | TJCRI: | the process I do |
| 08:03:41 | TJCRI: | so thanks for your assistance on that |
| 08:29:28 | TJCRI: | I have noticed when doing shp2pgsql I get these errors: psql:filename.sql:1: ERROR: column not found in geometry_columns table |
| 08:29:37 | TJCRI: | anyone know what that might reference to? |
| 08:31:39 | strk: | read first line of filename.sql ? |
| 08:37:21 | TJCRI: | oh thats a good error then - line 1 is: SELECT DropGeometryColumn( '','tablename,'the_geom' ); |
| 08:37:41 | TJCRI: | since it doesnt exist yet it cant select it |
| 11:11:43 | winkey: | is it posible to get the nth polygon from a multipolygon? |
| 11:17:38 | winkey: | st_dump i guess |
| 11:18:58 | pramsey: | st_geometryn also |
| 11:25:08 | winkey: | cool |
| 11:28:13 | winkey: | pramsey thanks |
| 20:39:43 | TheSteve0: | racicot: ping |
| 20:40:00 | racicot: | pong |
| 20:41:17 | racicot: | TheSteve0: what's up... |
| 20:42:05 | TheSteve0: | hey hey |
| 20:42:19 | TheSteve0: | Is that cool marxan web app you built up on the web somewhere |
| 20:43:03 | racicot: | hmmm... that was back when I worked for Ecotrust and I dont control that stuff anymore... let me go look |
| 20:43:15 | racicot: | you using Marxan? |
| 20:43:36 | TheSteve0: | kinda |
| 20:43:44 | TheSteve0: | but I also want to build a better corridor tool |
| 20:43:55 | TheSteve0: | I wanted to see what you had done so I could ask you intelligent questions |