FME_SQL_DELIMITER ;

-DROP TABLE CITY_PARKS; 
-DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME='CITY_PARKS'; 
CREATE TABLE "SUPPORT"."CITY_PARKS" 
   ("PARKID" NUMBER(*,0), 
	"REFPARKID" NUMBER(*,0), 
	"PARKNAME" VARCHAR2(40 BYTE), 
	"NEIGHBORHOODNAME" VARCHAR2(40 BYTE), 
	"EWSTREET" VARCHAR2(30 BYTE), 
	"NSSTREET" VARCHAR2(30 BYTE), 
	"DOGPARK" VARCHAR2(1 BYTE), 
	"WASHROOMS" VARCHAR2(1 BYTE), 
	"SPECIALFEATURES" VARCHAR2(1 BYTE),
    "POINTS" SDO_GEOMETRY, 
    "POLYGONS" SDO_GEOMETRY 
); 
INSERT into USER_SDO_GEOM_METADATA (table_name,column_name,diminfo,srid) VALUES ('CITY_PARKS','POINTS', sdo_dim_array(sdo_dim_element('X',3000000,10000000,0.005),sdo_dim_element('Y',3200000,10100000,0.005)), 2277); 
INSERT into USER_SDO_GEOM_METADATA (table_name,column_name,diminfo,srid) VALUES ('CITY_PARKS','POLYGONS', sdo_dim_array(sdo_dim_element('X',3000000,10000000,0.005),sdo_dim_element('Y',3200000,10100000,0.005)), 2277);