| 00:14:31 | smartnude: | I have a problem with encoding I think.. I got some shape files that I want to convert to sql, when using the shp2pgsql.exe tool I get an error about invalid byte sequence for UTF8: 0xff... I've specified in the cmdline -W latin1, anything else I need to do to make it export the shape data correctly ? |
| 06:16:53 | Seanasy: | Is any work being done on the TIGER geocoder? |
| 06:17:40 | Seanasy: | Specifically, to use recent shapefile data? |
| 06:19:46 | winkey: | every machine seems to have the .sql files in a different place it would be a serious plus if there was something like postgis-config that had an option to spit out the path to those files |
| 11:35:59 | m_e_: | hey guys is there a way to check if a point is within a multypolygon? |
| 11:54:21 | pramsey: | st_contains( multipolygon,point ) |
| 11:55:16 | m_e_: | thx pramasey... now i get another error: different srids. :( is there a way to check which srid is beeing used? |
| 11:55:28 | pramsey: | select st_srid( the_geom ) |
| 11:57:34 | m_e_: | alright : ) so ( i hope ) last question: is there a way to change the srid easily? |
| 12:02:11 | pramsey: | yes, but you must do so carefully |
| 12:02:39 | pramsey: | st_transform( geom,srd ) will change the coordinates of a geometry to a defined output srid |
| 12:02:50 | pramsey: | st_setsrid( geom,srid ) will change the srid, while leaving the coordinates untouched |
| 12:02:53 | pramsey: | srid is metadata |
| 12:03:12 | pramsey: | so use st_srid( ) to make your srid match your coordinates, in the case of a mismatch |
| 12:03:31 | pramsey: | and use st_transform( ) only to change coordinates if you have to ( and your starting srid must be correct to begin with ) |
| 12:04:04 | pramsey: | also note that if you build an index on the_geom a query using st_transform( the_geom ) won't use that index ( because the coordinates are not hte same ) |
| 12:04:07 | pramsey: | got it? |
| 12:05:55 | m_e_: | yep i think ive got it! thanks a lot man : ) |
| 12:06:30 | tomkralidis: | can one pass an arbitrary point to st_contains, instead of a col? |
| 12:16:47 | pramsey: | yes |
| 12:17:03 | pramsey: | st_contains( the_geom, st_setsrid( st_makepoint( x, y ),srid ) ) |
| 12:22:13 | tomkralidis: | thx |
| 12:22:30 | CIA-34: | kneufeld * r4099 /trunk/GNUmakefile: added a status line to the main makefile that indicates if PostGIS was built successfully. |
| 23:27:04 | Joe|w3design_: | Helo, is anyone around at the moment? |