矢量数据存入postgis中

CREATE INDEX INDEX_OPER_DATA_SPATIAL_COMMm ON first(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS(‘LAYER_GTYPE=POLYLINE’) NOPARALLEL;

shp2sdo XQ OXQ -i IDD -s 3857 -g GWM_GEOMETRY -d

D:\abc>sqlplus scott/tiger@orcl

@OXQ.sql

SQL>quit   

D:\abc>sqlldr scott/tiger@orcl OXQ.ctl

CREATE INDEX JIANGSU_ID ON OXQ(GWM_GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS(‘LAYER_GTYPE=POLYGON’) NOPARALLEL;

4326
shp2sdo XQ XXQ -i IDD -s 4326 -g GWM_GEOMETRY -d
D:\abc>sqlplus scott/tiger@orcl
@XXQ.sql
SQL>quit  
D:\abc>sqlldr scott/tiger@orcl XXQ.ctl
sqlplus scott/tiger@orcl
CREATE INDEX indexqqq ON XXQ(GWM_GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX 

execute sdo_migrate.to_current(‘XXQ’);

oracle中 将4326坐标系可以， 3857不可以。

转载自：https://blog.csdn.net/wt346326775/article/details/51111305