oracle spatial表供geoserver使用

oracle spatial表供geoserver使用.sql

--http://gis.stackexchange.com/questions/103760/tif-tfw-to-geotiff

--http://stackoverflow.com/questions/32324726/how-to-get-projectionespg-number-from-fif-or-tfw-file




INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)

 VALUES ('V_POWER_CUT_NET_DFG_CABLE', 'SHAPE',

    MDSYS.SDO_DIM_ARRAY

      (MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.000000050),

       MDSYS.SDO_DIM_ELEMENT('Y', -180, 180, 0.000000050),

       MDSYS.SDO_DIM_ELEMENT('Z', 0,0, 0.000000050) 

     ),

     4326);


Create index POWER_CUT_NET_G_SEGMENT_sidx on POWER_CUT_NET_G_SEGMENT(SHAPE) Indextype is mdsys.spatial_index