| 09:05:14 | jlivni: | screen -r m |
| 18:37:07 | bobby__: | I am trying to run TinyERP, and I am not able to connect a database for it |
| 18:37:16 | bobby__: | anyone with an idea on the matter? |
| 18:44:18 | darkblueB: | ha1331_: there is a handy site called spatialreference.org |
| 18:44:41 | darkblueB: | which is a working reference, but you might get the idea quickly |
| 18:45:32 | ha1331_: | darkblueB: is there similar site or handbook than postg |
| 18:46:28 | ha1331_: | resql handbook. I actually don't need postgis for that complicated things, atleast for now. I just need to have column for points that come from gps receiver( s ) |
| 18:46:48 | ha1331_: | everything I read comes with instructions how to use mapservers and such |
| 18:46:48 | darkblueB: | boston gis postgis cheatsheet |
| 18:47:22 | darkblueB: | http://www.bostongis.com/postgis_quickguide.bqg |
| 18:47:24 | sigq: | Title: PostGIS ver. 1.3.1 Quick Guide - Cheatsheet ( at www.bostongis.com ) |
| 18:47:30 | darkblueB: | thats really condensed |
| 18:48:57 | ha1331_: | when I create the table and the column for the co-ordinates, what do I need to know? I'm thinking the type for the column should be point? |
| 18:49:31 | darkblueB: | POINT, LINESTRING, MULTIPOLYGON are the basic choices |
| 18:49:37 | darkblueB: | most often in 2D |
| 18:50:18 | darkblueB: | the geometry column is often called the_geom |
| 18:50:58 | ha1331_: | ok, I've noticed this much, seems to be the choise for all the examples I've seen |
| 18:51:26 | ha1331_: | is there reason for this? |
| 18:52:16 | darkblueB: | its convenient.. |
| 18:54:15 | ha1331_: | ok, what is "WGS84 longlat |
| 18:54:18 | ha1331_: | " |
| 18:58:38 | dassouki: | ha1331_: let's say you do a union of two layers so u can call the geom column "st_union_population_transit |
| 18:58:46 | dassouki: | so u know it's a union between pop and transit |
| 18:59:18 | dassouki: | my rule of thumb is if i generated it from other layers, then it gets renamed, for eample the_geom_centroids |
| 18:59:38 | dassouki: | that's just me; however, numerous examples if not all show the_geom |
| 19:07:33 | ha1331_: | dassouki: could you tel me howto create column for GPS lon/lat? |
| 19:10:42 | ha1331_: | hmm, it seems to me that GPS uses WGS84 coordinate system. |
| 19:11:35 | dassouki: | ha1331_: to change ur coordinate system look in teh geometries table |
| 19:12:03 | dassouki: | and then change the "-1" to "4326" which corresponds to epsg 4326/ wgs84 |
| 19:12:47 | ha1331_: | dassouki: Dont need to change anything, it's new. So should I do: SELECT AddGeometryColumn( .public., .mytable., .the_geom., 2264, .POINT., 2 )SELECT AddGeometryColumn( .public., .mytable., .the_geom., 4326, .POINT., 2 ); ? |
| 19:13:17 | ha1331_: | ahh... silly paste |
| 19:13:43 | ha1331_: | SELECT AddGeometryColumn( .public., .mytable., .the_geom., 4326, .POINT., 2 ) |
| 19:13:48 | ha1331_: | is what I ment |
| 19:14:03 | dassouki: | ha1331_: pgadmin might make your life a bit easier too |
| 19:14:26 | ha1331_: | dassouki: I'm using it |
| 19:15:01 | dassouki: | http://postgis.refractions.net/pipermail/postgis-users/2004-January/003760.html |
| 19:15:02 | sigq: | Title: [postgis-users] How to create table new_table as select * from old_table ( at postgis.refractions.net ) |
| 19:19:45 | ha1331_: | dassouki: dassouki I don't need to populate the table with anything or even alter existing table. Just need to create new table with column for points : ) |
| 19:22:48 | ha1331_: | data for the column would be coming from GPS-device, that uses WGS84 coordinate system. |
| 19:34:55 | dassouki: | ha1331_: create my_table |
| 19:35:16 | dassouki: | alter my_table addcolumn x_coord Real;? |
| 19:35:24 | dassouki: | is that whatyou're looking for |
| 19:35:34 | dassouki: | and then u add perhap an oid or gid or id as ur key |
| 19:36:22 | ha1331_: | dassouki: now I'm confused. Shouldn't the postgis columns be added using AddGeometryColumn( )? |
| 19:39:16 | ha1331_: | SELECT AddGeometryColumn( 'public', 'gpsdata', 'the_geom', 4326, 'POINT',2 ); would that do what I need? |
| 19:40:22 | ha1331_: | I'm truly sorry for the dumb questions, I started to familiarice my self with postgis like 4 hours ago... |
| 19:40:43 | ha1331_: | lot's of information there, bít over my head most of it. |
| 19:42:44 | dassouki: | ha1331_: sounds right, |
| 19:43:05 | ha1331_: | dassouki: ok, thanks : ) |