Opened 15 years ago

Closed 15 years ago

Last modified 7 years ago

#21 closed enhancement (fixed)

Import shapes BDMAP to BDMAP postgres

Reported by: cedric Owned by: cedric
Priority: major Milestone:
Component: SIG-data Version: EDA2.0
Keywords: Cc:

Description

Import of shapes into new table for comparison and further joining and correction

Change History (10)

comment:1 follow-up: Changed 15 years ago by cedric

  • Status changed from new to accepted 
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP\station arcgis

comment:2 in reply to: ↑ 1 Changed 15 years ago by cedric 

cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP\station arcgis
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 bdmapv2_vf2 stationsp > stationsp.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d BDMAP -h localhost -U postgres -p 5433 -f stationsp.sql 
... ca plante, je pense qu'il faut convertir en utf8, dans notepad encodage>convertir en utf8
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d BDMAP -h localhost -U postgres -p 5433 -f stationsputf8.sql

comment:3 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from accepted to closed

comment:4 Changed 15 years ago by cedric

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:5 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from reopened to closed

... problème de projection...
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP\station arcgis
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 bdmapv2_vf2 stationsp > stationsp.sql
dans notepad encodage>convertir en utf8 > save as stationsputf8.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d BDMAP -h localhost -U postgres -p 5433 -f stationsputf8.sql

comment:6 Changed 15 years ago by cedric

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:7 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from reopened to closed

... problème de projection... Ce dernier code est OK

cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP\station arcgis
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 bdmapv2_vf2 stationsp > stationsp.sql
dans notepad encodage>convertir en utf8 > save as stationsputf8.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d BDMAP -h localhost -U postgres -p 5433 -f stationsputf8.sql

comment:8 Changed 15 years ago by cedric

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:9 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from reopened to closed

comment:10 Changed 7 years ago by cedric

  • Milestone Data integration deleted

Milestone Data integration deleted

Note: See TracTickets for help on using tickets.