| 00:11:31 | CIA-34: | strk * r2418 /trunk/source/ ( 26 files in 2 dirs ): Add port information for geom::prep package. Next stop: sync to JTS-1.10. |
| 00:18:23 | CIA-34: | strk * r2419 /trunk/source/ ( 2 files in 2 dirs ): Sync BasicPreparedGeometry to JTS-1.10 ( short-circuit in containsProperly ) |
| 00:52:21 | CIA-34: | strk * r2420 /trunk/source/ ( 10 files in 2 dirs ): Bring all geom::prep package in sync with JTS-1.10 |
| 01:40:44 | CIA-34: | strk * r2421 /trunk/source/ ( 2 files in 2 dirs ): Sync GeometricShapeFactory to JTS-1.10 ( createArcPolygon added ) |
| 04:31:03 | dassouki: | using st_centroid i do, UPDATE "layer_centroids" SET x_centroid=x( centroid( centroid ) ); |
| 04:31:06 | dassouki: | the same for y |
| 04:31:08 | dassouki: | is there a better way to do ti |
| 04:33:01 | strk: | better from which point of view ? |
| 04:33:35 | dassouki: | well first perhaps can i do st_pointonsurface? and second instead of getting x and y coordinates, could it just be part of the_geom |
| 04:55:52 | dassouki: | rephrasing would be, what query should i do to get centroids on the surface |
| 04:56:15 | dassouki: | i've been toying around CREATE TABLE fred_city_06_da_centroids AS SELECT ST_PointsOnSurface( ST_Centroid( fred_city_06_da.the_geom ) ) AS the_geom,FROM fred_city_06_da; |
| 05:09:38 | strk: | centroids are not guaranteed to be on the surface I guess |
| 06:44:15 | Guest26664: | hello, is there a way to transform a geometry with parameters? like: cs2cs +init=epsg:31466 +towgs84=590.5,69.5,411.6,-0.769,-0.052,-3.601,8.30 +to +init=epsg:4326 +units=m in.txt -f "%.6f" |
| 06:45:36 | strk: | I'm pretty sure there is. not sure it's documented. check the definition of the transform( ) function |
| 06:45:55 | strk: | IIRC it basically fetches params from spatial_ref_sys and invokes another, so you should be able to just call that other up |
| 06:47:52 | Guest26664: | ah, got it, thx |
| 07:19:35 | dassouki: | strk: http://pastebin.com/d766fe1dd this worked :D |
| 07:19:36 | sigq: | Title: SQL pastebin - collaborative debugging tool ( at pastebin.com ) |
| 11:18:24 | CIA-34: | kneufeld * r4040 /trunk/regress/run_test: |
| 11:18:24 | CIA-34: | dropping a table that's not there causes an ERROR in the logs |
| 11:18:24 | CIA-34: | - 8.1 does not support DROP TABLE IF EXISTS, so first test if the table is there, then drop it. |
| 11:32:06 | CIA-34: | kneufeld * r4041 /branches/1.3/regress/run_test: |
| 11:32:06 | CIA-34: | fix for ERROR in regression logs |
| 11:32:07 | CIA-34: | - first test if the table is there before attempting to drop it |
| 14:45:58 | sigq: | geosfeed: Ticket #250 ( defect created ): geos_contains( multipolygon, polygon ) returns false when it should return true <http://trac.osgeo.org/geos/ticket/250> |
| 15:40:10 | CIA-34: | mloskot * r2422 /trunk/tests/unit/ ( 3 files in 2 dirs ): |
| 15:40:10 | CIA-34: | Added new unit tests for C API: GEOSWithinTest and GEOSContainsTest. This is |
| 15:40:10 | CIA-34: | check and response for problems reporting in Ticket #250. Running the new tests |
| 15:40:10 | CIA-34: | does not reproduce the problem, so it likely has been fixed or the bug is |
| 15:40:11 | CIA-34: | somewhere else ( i.e. Django layers ). |
| 15:42:13 | CIA-34: | mloskot * r2423 /trunk/tests/unit/capi/ ( GEOSContainsTest.cpp GEOSWithinTest.cpp ): Removed unused <memory> header from C API tests. |
| 15:48:42 | CIA-34: | mloskot * r2424 /trunk/tests/unit/capi/ ( 8 files ): test/unit/capi: re-tab all .cpp files to use spaces. |
| 15:49:23 | sigq: | geosfeed: Ticket #250 ( defect updated ): geos_contains( multipolygon, polygon ) returns false when it should return true <http://trac.osgeo.org/geos/ticket/250#comment:1> |
| 19:58:00 | robe2: | I guess its too late to say this but dassouki doing a point on surface of a centroid is kind of silly |
| 19:59:45 | robe2: | it would be itself since a centroid is itself and as strk said a centroid is not necessarily on the surface and in most cases is not |
| 20:01:57 | robe2: | Rather should I say -- a centroid is a point and point oon surface of a point is the point - SELECT ST_Astext( ST_POintOnSurface( 'POINT( 1 2 )' ) ) |