矢量数据存入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) INDEXT