| 08:20:50 | Devastatr: | hey |
| 08:21:01 | Devastatr: | I cant remember who I was talkign to.. but worked for an airport authority.. |
| 08:24:43 | jlivni: | Devastatr: did you have a question? |
| 08:25:04 | Devastatr: | jlivni: not really.. I just wanted to show something to someone |
| 08:25:31 | Devastatr: | j: was it you that I was talking to earlier? ( about how I was setting up a flight planning webapp? ) |
| 08:26:15 | jlivni: | nope .. not me |
| 08:26:45 | Devastatr: | oh heh ok |
| 08:26:51 | Devastatr: | brb lunch |
| 08:30:26 | bitner: | Devastatr: I'm the airport guy |
| 08:47:30 | darkblue_B: | Devastatr: what did you make? |
| 08:53:52 | jlivni: | sorry darkblue_B ... its for airport guys only |
| 08:56:35 | : | * jlivni heads out for coffee, and to make 'airport guy' business cards |
| 08:56:54 | CIA-6: | pramsey * r2147 /trunk/source/headers/geos/timeval.h: Change to standard header, with ( c ) credit to author. |
| 08:58:42 | CIA-6: | pramsey * r2148 /trunk/source/algorithm/RobustDeterminant.cpp: Added original author to main copyright block. |
| 08:59:39 | : | * darkblue_B makes airport guy logo web site |
| 09:07:24 | bitner: | _!_ |
| 09:07:25 | bitner: | ______( _ )______ |
| 09:07:26 | bitner: | ! ! ! |
| 09:08:57 | nhv: | :- ) |
| 09:38:35 | jlivni: | don't let the tsa catch you with that diagram. |
| 09:46:13 | Devastatr: | bitner: lol |
| 09:46:29 | Devastatr: | bitner: gateway.infiniteloop.ca/~bcrosby/tilecache/ |
| 09:46:45 | Devastatr: | just shows the NDBs and some VORs... have some airways in place in Canada ( blue lines ) |
| 09:47:00 | Devastatr: | working out some issues with tiling ( as in some cases, the ndb icon gets cut off in the middle of a tile ) |
| 09:53:31 | bitner: | Devastatr: are you using metatiles? |
| 09:56:35 | Devastatr: | im not sure |
| 09:59:16 | bitner: | metaTile="yes" in your tilecache config |
| 10:00:34 | Devastatr: | let me check |
| 10:04:17 | darkblue_B: | working fine from here |
| 10:04:33 | darkblue_B: | next step. filtering data by zoom level! |
| 10:04:44 | darkblue_B: | looks like things are coming along though |
| 10:04:50 | Devastatr: | darkblue_B: heh yeah |
| 10:05:06 | darkblue_B: | Devastatr: getting the hang of it? |
| 10:05:34 | Devastatr: | bitner: metaTile is off |
| 10:05:45 | Devastatr: | bitner: should I turn it on? |
| 10:07:48 | bitner: | yes |
| 10:11:29 | Devastatr: | hmm ok |
| 10:11:39 | Devastatr: | let me delete the previously generated tiles |
| 10:13:58 | Devastatr: | that seemed to fix it |
| 10:15:54 | Devastatr: | yeah |
| 14:17:36 | Devastatr: | anyone here experienced with openlayers? |
| 14:42:46 | mloskot: | Devastatr: -> #openlayers |
| 15:57:22 | statim: | given a bunch of points, is it possible to construct a polygon using the outermost points? like a permimeter |
| 15:58:12 | statim: | i have a bunch of points... i really only care to define the area of the extremes. all the ones inside of that i dont need |
| 16:01:22 | mleslie: | Try ST_ConvexHull( ST_Collect( points ) ) |
| 16:05:46 | statim: | mleslie: im trying: select ST_ConvexHull( ST_Collect( ARRAY[point( 1,1 ), point( 1,2 ), point( 2,1 ),point( 2,2 )] ) ); but getting "No function matches the given name and argument types. You may need to add explicit type casts." pointing to the ST_Collect |
| 16:05:57 | statim: | i tried without array as well |
| 16:06:25 | mleslie: | Yeah, ST_Collect is an aggregate that operates on geometries, not arrays. |
| 16:06:57 | mleslie: | Are your points stored in a table, or are you writing them into the query? |
| 16:07:36 | statim: | mleslie: im writing them in right now... eventually ill be pulling from a table, creating them on the fly out of lat/longitude pairs |
| 16:08:37 | mleslie: | Ahh, well I'd suggest start getting them in the table now. It's going to be a pain to aggregate points in a single query. Even if you have a temp table that you insert them into for now. |
| 16:08:50 | statim: | ok |
| 16:12:15 | statim: | mleslie: same thing with: select ST_ConvexHull( ST_Collect( ( select pt from tmppoints ) ) ); is that not the way it expects them? |
| 16:12:45 | mleslie: | Try SELECT ST_ConvexHull( ST_Collect( pt ) ) FROM tmppoints; |
| 16:13:59 | statim: | mleslie: same thing... im not sure our admin installed postgis on here. im assuming this isnt a functional that comes directly with pgsql? |
| 16:14:17 | statim: | function* |
| 16:14:25 | mleslie: | Ahh, try running SELECT postgis_version( ) |
| 16:15:50 | statim: | nope :( oh well... im surprised i havent hit this before... points/circles/etc work. i guess these days a lot of it is in pgsql core, but some is still only in postgis? |
| 16:18:06 | mleslie: | Ahh, postgresql supports points, just not geographic points. None of PostGIS has been ported into PostgreSQL as far as I know. |
| 16:18:45 | statim: | got it. ok well thanks for the help ill see if i can get postgis on here |
| 16:18:57 | mleslie: | Good luck. |
| 16:29:02 | darkblue_B: | ogr2ogr -f KML t.kml PG:dbname=t -sql 'st_convexhull( st_collect( t ) )..' cool |
| 16:29:25 | darkblue_B: | so many ways to make postgis go... |
| 20:59:02 | darkblue_B: | mloskot: is GEOS trunk stable? a replacement for release GEOS? |
| 20:59:23 | darkblue_B: | I see many files have been touched |
| 20:59:46 | mloskot: | I'd call it stable |
| 21:00:24 | mloskot: | it's close to release, one leak left to get fixed but nobody know where it is ,- ) |
| 21:00:24 | mloskot: | http://lists.osgeo.org/pipermail/geos-devel/2008-August/thread.html |
| 21:00:25 | sigq: | Title: The geos-devel August 2008 Archive by thread ( at lists.osgeo.org ) |
| 21:00:39 | darkblue_B: | so.. I can just try to make and install |
| 21:02:01 | darkblue_B: | for python.. its shapely |
| 21:02:23 | darkblue_B: | PostGIS and OGR.. have to refind the binaries? or the same names perhaps... |
| 21:02:53 | mloskot: | for postgis and ogr, you probably can not just drop new binaries in |
| 21:02:59 | mloskot: | but make full rebuild |
| 21:03:01 | mloskot: | of both |
| 21:03:08 | mloskot: | have to run out with dog, later |
| 21:03:12 | darkblue_B: | ok |
| 21:03:14 | darkblue_B: | thx |