| 03:30:02 | epifanio: | hi |
| 03:30:07 | epifanio: | i'm having a strange issue with some layers loaded into postgis |
| 03:30:14 | epifanio: | i've a mapserver application that use these layer |
| 03:30:26 | epifanio: | they are correctly displayed, the query system seems to work properly |
| 03:30:36 | epifanio: | but when i try to perform a query in the psql shall i get : http://rafb.net/p/zr0Wuy60.html |
| 03:30:37 | sigq: | Title: Nopaste - No description ( at rafb.net ) |
| 03:30:48 | epifanio: | it give me that the column do not exist |
| 03:31:03 | epifanio: | but why the query tool of my mapserver application give me the right results? that's a mistery for me :-/ |
| 03:31:14 | epifanio: | if i try to visualize the layer's table with phppgadmin |
| 03:31:23 | epifanio: | i can brouse the table and in it i can see the missed column, but tring to get info on the column : ( click on the column name ) it give me the the column then tring to click on visualize, i get again the error : http://rafb.net/p/aJyc7X38.html |
| 03:31:25 | sigq: | Title: Nopaste - No description ( at rafb.net ) |
| 03:31:54 | epifanio: | i've not clue about :-( |
| 03:45:30 | epifanio: | ok i done ... the problem was that the column in upeer case need the double quote in the query |
| 07:16:08 | prakriti: | select ST_NumGeometries( the_geom ) FROM table where name = 'blah'; gives me 17 rows with ST_NumGeometries = 1 |
| 07:16:11 | prakriti: | if I: |
| 07:16:37 | prakriti: | select ST_NumGeometries( GeomUnion( the_geom ) ) FROM table where name = 'blah' group by name; |
| 07:16:43 | prakriti: | i get NULL for num |
| 07:17:13 | prakriti: | Any ideas, do I misunderstand the use of GeomUnion? |
| 07:17:28 | prakriti: | or ST_Union |
| 13:41:56 | pimpaa: | hello |
| 14:22:27 | brough: | did anyone have any thoughts on my question about establishing if a geom is 'coveredby' a combination of other geoms, without costing the earth? was it even a coherent question. |
| 14:22:39 | : | * brough scrolls up 24 hours. |
| 14:22:50 | brough: | hmm. |
| 15:11:34 | brough: | I'm drawing you all a pic! |
| 15:22:30 | brough: | http://pastie.org/208289 |
| 15:22:31 | sigq: | Title: #208289 by brough - Pastie ( at pastie.org ) |
| 15:22:49 | brough: | ^^ I made it colourful. :- ) |
| 15:29:05 | tazle: | brough: what is your goal? |
| 15:30:23 | brough: | tazle: to return '1' in the last example, where the target_geom is not covered by any single geom but is nonetheless completely covered. |
| 15:31:02 | brough: | the 'availables' also have a room_id attribute but that's not important to the example. |
| 15:32:09 | tazle: | brough: on a higher level |
| 15:40:30 | brough: | it's tricky. this works well but only if the period someone wants to book is a single geom, ie doesn't cross two price bands. logical think is a price_bands table and available_periods table but prob slower. |
| 15:47:58 | brough: | so "if target_geom is compeletly coveredby by a set of records of room_id 'foo' SELECT 1 ['cause that means it's available]" |
| 16:42:35 | apivonka: | needing information for new user... |
| 16:43:47 | apivonka: | I have imported state gis data into posgis and am able to export/dump to shape files.. yet is there a way to dump to pdf/svg? |
| 16:56:12 | brough: | can't you go shp > pdf or shp > svg probably more resources for that. |
| 16:57:04 | brough: | can't you go shp > pdf or shp > svg probably more resources for that. |
| 16:58:30 | apivonka: | brough, sorry disconnected, can you repeat |
| 17:00:15 | brough: | can't you go shp > pdf or shp > svg probably more resources for that. |
| 17:00:47 | apivonka: | haven't found anything yet.. |
| 17:00:59 | apivonka: | I'm new to all this ( yet very interested in learning ). |
| 17:03:46 | brough: | apivonka: if not ( looks like you probably can, you'll have to have a look around ) then you could export to shp file and create the svg outside of postgis. |
| 17:03:48 | apivonka: | I've seen that function in the db, yet no real example of how to execute it with the pgsql ... |
| 17:04:36 | apivonka: | I do have another question if you don't mine |
| 17:06:03 | apivonka: | Like I said earlier, I have state gis data which can tell the road surface.. I've been able to export different types using pgsql2shp ,yet only one type at a time ---Is there a way to export layers to shp and identify those layers |
| 17:06:57 | apivonka: | brough --btw, thanks for the information |
| 17:07:32 | brough: | no prob. not much help though. : ) |
| 17:30:45 | brough: | yeah. doesn't look like I can avoid using a union. |
| 17:34:06 | brough: | oops wrong channel. :? |