| 06:16:01 | CIA-6: | mcayland * r2819 /trunk/ ( configure.ac liblwgeom/Makefile.in ): Fix liblwgeom requiring gcc to compile. By using macros and variables supplied by libtool, we can now detect the PIC flags and whether the compiler will accept additional gcc warning flags for developers |
| 09:31:33 | iwillig: | i have a database with the coordinates in two different columns ( utm_x, and utm_y ) and i am trying to run a command that takes these two points and generates a geometry. |
| 09:31:38 | iwillig: | this is my command |
| 09:31:39 | iwillig: | http://dpaste.com/60193/ |
| 09:31:40 | sigq: | Title: dpaste: #60193 ( at dpaste.com ) |
| 09:32:26 | iwillig: | and this is my error, http://dpaste.com/60194/ |
| 09:32:27 | sigq: | Title: dpaste: #60194 ( at dpaste.com ) |
| 09:32:55 | iwillig: | i am not sure what i am doing wrong, as I am new to postgresql and postgis |
| 09:33:40 | bitner: | try "update public.bioblitz_site set the_geom=setsrid( makepoint( utm_x,utm_y ),26919 );" |
| 09:33:53 | bitner: | makepoint is easier to use than creating wkt |
| 09:34:12 | iwillig: | oh, thanks bitner |
| 09:35:03 | bitner: | although your error looks like you have a constraint on your the_geom column that still might not work |
| 09:35:28 | iwillig: | yeah, i did not add that constraint, so am not sure where it came from |
| 09:35:34 | iwillig: | but let me try that |
| 09:35:48 | bitner: | how did you create the table? |
| 09:35:55 | iwillig: | mm |
| 09:44:52 | iwillig: | with the AddGeometryColumn command |
| 09:44:52 | iwillig: | following the postgis documentation |
| 09:44:52 | iwillig: | http://postgis.refractions.net/docs/ch04.html |
| 09:44:53 | sigq: | Title: Chapter 4. Using PostGIS ( at postgis.refractions.net ) |
| 09:45:00 | iwillig: | oh, sorry, the table was created with Django |
| 09:45:04 | iwillig: | bitner: that is a good point |
| 09:46:33 | bitner: | one thing that addgeometrycolumn does is to create a handful of constraints |
| 09:47:07 | bitner: | to make sure data in the table matches metadata in the geometry_columns table |
| 09:50:06 | bitner: | you could change your constraint and the entry for the dimensions field in the geometry_columns table |
| 09:55:06 | iwillig: | okay, i will try that thanks bitner |
| 12:49:32 | iwillig: | can some point me to the documentation on re-projecting information in PostGIS |
| 12:49:34 | iwillig: | thanks |
| 12:50:49 | iwillig: | never mind |
| 17:03:06 | hobu: | not in dbfs |
| 17:07:06 | mleslie: | prakriti: If you output to a file, instead of piping straight into psql, you can simply edit the data type in the CREATE TABLE statement. Alternately, you can create the table manually, and use the -A ( I think ) option to append data to it. |
| 17:17:43 | prakriti: | ic |
| 17:17:45 | prakriti: | makes sence |
| 17:17:53 | prakriti: | sense |
| 17:17:54 | prakriti: | thanks |