| 03:31:43 | arax83: | Hello. I have a stupid question : ) Can i use only multilinestrings in my DB ( using one-segment multilinestring as simple linestring )? |
| 13:12:18 | jalmeida: | hi i want to import my shapefile into postgresql |
| 13:12:19 | jalmeida: | but |
| 13:12:19 | jalmeida: | COPY "g_quadra" ( "nr_quadra","nm_quadra","nr_os","shape_area","shape_len",the_geom ) FROM stdin; |
| 13:12:19 | jalmeida: | 765 QL-1 0 4.17984383634e+005 3.21298925487e+003 |
| 13:12:19 | jalmeida: | ... |
| 13:12:28 | jalmeida: | get error in this line |
| 13:12:44 | ue: | jalmeida, is this a shape file or the database backup? |
| 13:13:16 | jalmeida: | shapefile, i exported shapefile on .sql file |
| 13:13:32 | jalmeida: | ue |
| 13:13:58 | ue: | so, you exported from postgis to a .sql file ? |
| 13:16:11 | jalmeida: | shp2pgsql -D D:\DADOS\Apresentacao-20-abril-2007\Area_Interesse\VALVULA.shp postgis > valvula.sql |
| 13:16:20 | jalmeida: | ue |
| 13:16:53 | jalmeida: | ERROR: syntax error at or near "765" |
| 13:16:53 | jalmeida: | SQL state: 42601 |
| 13:16:53 | jalmeida: | Character: 327 |
| 13:17:58 | jalmeida: | is correct ??? |
| 13:17:59 | ue: | ex : shp2pgsql -I -s 32633 POI.shp gis_schema.poi > poi.sql && psql -d gisdb -h localhost -U gis -f poi.sql |
| 13:18:20 | jalmeida: | BEGIN; |
| 13:18:21 | jalmeida: | CREATE TABLE "g_quadra" ( gid serial PRIMARY KEY, |
| 13:18:21 | jalmeida: | "nr_quadra" int4, |
| 13:18:21 | jalmeida: | "nm_quadra" varchar( 8 ), |
| 13:18:21 | jalmeida: | "nr_os" int4, |
| 13:18:21 | jalmeida: | "shape_area" numeric, |
| 13:18:23 | jalmeida: | "shape_len" numeric ); |
| 13:18:25 | jalmeida: | SELECT AddGeometryColumn( '','g_quadra','the_geom','-1','MULTIPOLYGON',2 ); |
| 13:18:29 | jalmeida: | COPY "g_quadra" ( "nr_quadra","nm_quadra","nr_os","shape_area","shape_len",the_geom ) FROM stdin; |
| 13:18:31 | jalmeida: | 765 QL-1 0 4.17984383634e+005 3.21298925487e+003 010600000001000000010300000001000000120000007C85A194B37E07413AE42E6A04825F41E93CB119A37E074173C5C9B304825F412488AF19177E0741A9B08B3908825F41A36A0D4DC27D07413CA7BE6C0A825F4127AD9942997D0741232DE6980B825F4177D5A0E65F7D07411ED9A8FE0C825F41CD290076427D07410C8CA9CE0D825F418F739B61107D074107E3DCF10E825F41A8EDD4F0CC7C0741E5C37F9210825F41CFF6FFF0267C0741D2C4D1AA14825F41E84072800B7B074162FD7D321C825F41E0B6E8BD9D7 |
| 13:18:36 | jalmeida: | 90741D39E217325825F41791FD4DCFA780741EF05E45829825F41682FD2578B780741CC3AC4032C825F411F3C4FF10E780741D9562B2A2F825F410B0C0061F37707412E8190DB2F825F41ED8831C40E8307412E8190DB2F825F417C85A194B37E07413AE42E6A04825F41 |
| 13:18:39 | jalmeida: | \. |
| 13:18:45 | jalmeida: | END; |
| 13:19:37 | ue: | is your shape file valid ? did you specify the right projection ? |
| 13:24:19 | jalmeida: | but my sql don't is right ? |
| 13:25:39 | ue: | check the -I -s options of the shp2pgsql |
| 13:25:56 | ue: | shp2pgsql should produce valid sql statments |
| 13:33:48 | jalmeida: | ok thanks |
| 13:34:22 | jalmeida: | shp2pgsql -I D:\DADOS\Apresentacao-20-abril-2007\Area_Interesse\VALVULA.shp g_valvula postgis > valvula.sql |
| 13:34:32 | jalmeida: | it work's |
| 13:34:46 | jalmeida: | = ) thanks |
| 21:19:26 | atro101: | good evening all; I am very, very new to this whole GIS thing... where can you find commercial quality maps and data ? |
| 21:23:57 | atro101: | is anyone here ? |