Bonjour,
Je rencontre un probleme lorsque je veux inserer des données shapfiles de la ville de marseille dans PostGis.
J'utilise OpenJump pour le chargement, il ouvre toute les couches .shp (points,buildings..)
lorsqu'il faut creer la table , il apparait une erreur que voici ()
org.postgresql.util.PSQLException:Erreur:format du message invalide
Insert into pacapoints(geometry,osm_id,timestamp,name,type)
VALUES(GeometreFromText('POINT(4.808.......)(Illegal State Exception)
...........
j'ai pris comme SRID = 4326..
voila mon fichier shapefiles en attaché (points.shp)
qui génère ce fichier sql :
DROP TABLE MARSEILLE_POINTS;
CREATE TABLE MARSEILLE_POINTS (
osm_id NUMBER,
timestamp VARCHAR2(20),
name VARCHAR2(48),
type VARCHAR2(16),
GEOM MDSYS.SDO_GEOMETRY);
DELETE FROM USER_SDO_GEOM_METADATA
WHERE TABLE_NAME = 'MARSEILLE_POINTS' AND COLUMN_NAME = 'GEOM' ;
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('MARSEILLE_POINTS', 'GEOM',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', -180.000000000, 180.000000000, 0.500000000),
MDSYS.SDO_DIM_ELEMENT('Y', -90.000000000, 90.000000000, 0.500000000)
),
8307);
COMMIT;
le fichier ctl corresondant est :
OAD DATA
INFILE *
TRUNCATE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE MARSEILLE_POINTS
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS (
osm_id,
timestamp NULLIF timestamp = BLANKS,
name NULLIF name = BLANKS,
type NULLIF type = BLANKS,
GEOM COLUMN OBJECT
(
SDO_GTYPE INTEGER EXTERNAL,
SDO_SRID INTEGER EXTERNAL,
SDO_POINT COLUMN OBJECT
(X FLOAT EXTERNAL,
Y FLOAT EXTERNAL)
)
)
BEGINDATA
152590|2008-11-04T09:09:38Z||crossing| 2001|8307|4.808354600|43.953819200|
152595|2008-11-04T09:09:41Z||crossing| 2001|8307|4.808364800|43.953729100|
152695|2009-12-11T13:12:51Z||traffic_signals| 2001|8307|4.829568100|43.931901100|
152696|2009-12-11T13:12:51Z||traffic_signals| 2001|8307|4.829205500|43.931840100|
152697|2009-12-11T13:12:50Z||traffic_signals| 2001|8307|4.829050600|43.931931400|
152699|2009-12-11T13:12:51Z||traffic_signals| 2001|8307|4.829428500|43.932252200|
154692|2008-02-28T19:49:15Z|Avignon-Sud|motorway_junctio| 2001|8307|4.913014900|43.899630200|
273941|2009-09-10T07:31:48Z|Nice-Saint Augustin|motorway_junctio| 2001|8307|7.197110500|43.674912500|
273949|2008-02-16T11:31:36Z|Nice-Promenade des Anglais|motorway_junctio| 2001|8307|7.201118300|43.669389600|
......................................etc
Merci de me donner un coup de main
Erik