create table test (gid int4 , NAME varchar, ADDRESS varchar, PARCEL int4, ZIP int4);
select AddGeometryColumn('myGISdb','test','the_geom','-1','POINT',2);
begin;insert into test values ('0','Draper Library','12441 S 900 E # 200','28293760012000','840209792',GeometryFromText('POINT (1898379.16227277 798270.789434837)',-1) );
insert into test values ('1','East Millcreek Library','2266 Evergreen Ave','16341260060000','84109',GeometryFromText('POINT (1909938.38042299 861037.257413086)',-1) );
insert into test values ('2','Holladay Library','2150 E Murray Holladay Rd','22101270160000','84117',GeometryFromText('POINT (1908991.29178322 850123.055483487)',-1) );
insert into test values ('3','Hunter Library','4740 W 4100 S','15313540110000','84120',GeometryFromText('POINT (1860340.4379154 855912.992856402)',-1) );
insert into test values ('4','Kearns Library','5350 S 4220 W','21074570030000','84118',GeometryFromText('POINT (1863788.68154377 845584.309241637)',-1) );
insert into test values ('5','Magna Library','8339 W 3500 S','14322010150000','84044',GeometryFromText('POINT (1836469.1816462 861358.38058832)',-1) );
insert into test values ('6','Park Library','4870 S 2700 W','21091350120000','84118',GeometryFromText('POINT (1873165.787153 849079.460779454)',-1) );
insert into test values ('7','Riverton LIbrary','1830 W 12600 S','27341260020000','84065',GeometryFromText('POINT (1877501.62049074 797640.750930232)',-1) );
insert into test values ('8','Smith Library','810 E 3300 S','16293550010000','84106',GeometryFromText('POINT (1898162.21046078 862226.104400965)',-1) );
insert into test values ('9','South Jordan Library','10300 S Beckstead Ln','27152020020000','84095',GeometryFromText('POINT (1879091.1460346 812755.594397615)',-1) );
insert into test values ('10','South Salt Lake Library','220 E Morris Ave','16193260200000','84115',GeometryFromText('POINT (1893902.03425714 867504.903554712)',-1) );
insert into test values ('11','Tyler Library','315  S Wood St','21362780070000','84047',GeometryFromText('POINT (1891019.6166513 827668.762006943)',-1) );
insert into test values ('12','West Jordan Library','1970 W 7800 S','21273570220000','84088',GeometryFromText('POINT (1877210.86323609 829401.736328595)',-1) );
insert into test values ('13','West Valley Library','2880 W 3650 S','15331280310000','84119',GeometryFromText('POINT (1872217.08836292 859837.478719166)',-1) );
insert into test values ('14','Whitmore Library','2197 Fort Union Blvd','22223760040000','841213188',GeometryFromText('POINT (1909070.06309399 834536.067138108)',-1) );
insert into test values ('15','Bingham Creek Library','4834 W 9000 S','26012800030000','840882213',GeometryFromText('POINT (1859453.97766927 821833.119010417)',-1) );
insert into test values ('16','Sandy Library','10100 S Petunia Wy','28093530040000','84092',GeometryFromText('POINT (1902348.98727363 814133.168803756)',-1) );
end;