summaryrefslogtreecommitdiffstats
path: root/webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql
diff options
context:
space:
mode:
Diffstat (limited to 'webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql')
-rw-r--r--webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql b/webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql
new file mode 100644
index 0000000000..9e6d7b76ed
--- /dev/null
+++ b/webapp/django/contrib/gis/tests/geoapp/sql/city.oracle.sql
@@ -0,0 +1,8 @@
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Houston', SDO_GEOMETRY('POINT (-95.363151 29.763374)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Dallas', SDO_GEOMETRY('POINT (-96.801611 32.782057)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Oklahoma City', SDO_GEOMETRY('POINT (-97.521157 34.464642)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Wellington', SDO_GEOMETRY('POINT (174.783117 -41.315268)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Pueblo', SDO_GEOMETRY('POINT (-104.609252 38.255001)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Lawrence', SDO_GEOMETRY('POINT (-95.235060 38.971823)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Chicago', SDO_GEOMETRY('POINT (-87.650175 41.850385)', 4326));
+INSERT INTO GEOAPP_CITY ("NAME", "POINT") VALUES ('Victoria', SDO_GEOMETRY('POINT (-123.305196 48.462611)', 4326)); \ No newline at end of file