1-- script to generate cities table for PostGis 2-- used in examples 3 4-- Source: http://www.realestate3d.com/gps/latlong.htm 5 6create user ggl password 'ggl' createdb; 7create database ggl owner=ggl template=postgis; 8 9 10drop table if exists cities; 11create table cities(id serial primary key, name varchar(25)); 12 13select addgeometrycolumn('','cities','location','4326','POINT',2); 14insert into cities(location, name) values(GeometryFromText('POINT( -71.03 42.37)', 4326), 'Boston'); 15insert into cities(location, name) values(GeometryFromText('POINT( -87.65 41.90)', 4326), 'Chicago'); 16insert into cities(location, name) values(GeometryFromText('POINT( -95.35 29.97)', 4326), 'Houston'); 17insert into cities(location, name) values(GeometryFromText('POINT(-118.40 33.93)', 4326), 'Los Angeles'); 18insert into cities(location, name) values(GeometryFromText('POINT( -80.28 25.82)', 4326), 'Miami'); 19insert into cities(location, name) values(GeometryFromText('POINT( -73.98 40.77)', 4326), 'New York'); 20insert into cities(location, name) values(GeometryFromText('POINT(-112.02 33.43)', 4326), 'Phoenix'); 21insert into cities(location, name) values(GeometryFromText('POINT( -77.04 38.85)', 4326), 'Washington DC'); 22