Vis kilden til Urbgeo/gisdb ver 0.0/insertp3.sql

<pre class="code">
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Halden',4,6559522.9520112,293261.86504675,11.38738053313,59.124597214985);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Sarpsborg',4,6578137.0263677,278412.98901358,11.109622183931,59.283905547983);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Fredrikstad',4,6570847.4913584,268022.65719326,10.935513836649,59.213038881077);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Moss',4,6596421.0333215,253785.32380895,10.657697138293,59.434016658203);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Hølen',4,6607887.5523684,259338.17199124,10.742383260176,59.53991665838);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Hvitsten',4,6614734.7475969,254856.49584833,10.655449915465,59.598627769264);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Oslo',4,6649335.1563121,262210.96649389,10.746091593385,59.9127277694);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Hamar',4,6746310.7125997,286047.51757271,11.067952735163,60.794505547509);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Kongsvinger',4,6676061.3615235,333851.04042022,12.003572216512,60.187477770526);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Lillehammer',4,6784078.0653425,255814.00474074,10.46627765979,61.115141657226);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Gjøvik',4,6747735.6378698,265596.19254571,10.691572140531,60.795749991269);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Drammen',4,6632656.6721135,230612.02083056,10.204535940639,59.744077767589);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Holmsbu',4,6611323.6559819,241731.53634345,10.427835989874,59.560188879686);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Kongsberg',4,6626648.6796162,198833.3179791,9.6501579651967,59.668552763621);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Svelvik',4,6617345.6052232,241066.27740005,10.408747097218,59.61368054627);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Holmestrand',4,6603688.677656,234940.76131014,10.317583190087,59.487611101497);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Horten',4,6595211.1152749,243787.12596345,10.483436000265,59.417213879915);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Tønsberg',4,6578860.7610577,238341.48877183,10.407635986828,59.267508324131);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Sandefjord',4,6564464.5509299,226708.31486726,10.222335947255,59.13132776782);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Larvik',4,6556598.8570772,214905.93957645,10.02711089412,59.053216655648);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Porsgrunn',4,6567946.9721396,194442.97217596,9.6560996389433,59.140538874874);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Skien',4,6575838.4196851,192376.35566916,9.6090135042212,59.209605541044);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Kragerø',4,6538943.0099868,178147.68536614,9.4149328435351,58.869302760982);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Notodden',4,6616362.8891075,175769.95547497,9.2585327291744,59.559355536396);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Risør',4,6522884.382909,166080.53729079,9.2306799420369,58.716619424884);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Tvedestrand',4,6513984.2312355,147820.72905283,8.9310602365337,58.62266664112);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Arendal',4,6496930.9983453,136644.03943965,8.7669461706371,58.461213859101);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Grimstad',4,6484478.1102273,125262.14538658,8.5933681718304,58.340463853707);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Lillesand',4,6475602.2159861,111644.55934336,8.3771900620963,58.249452734344);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Kristiansand',4,6466407.0181003,88128.047402775,7.9957309576836,58.146149936786);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Mandal',4,6456621.8276071,54832.541930688,7.453465435251,58.026819337155);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Farsund',4,6468629.8447648,17591.242877351,6.8046483655693,58.094785913836);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Flekkefjord',4,6492097.1185796,11912.178102218,6.6602612717546,58.297138664445);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Egersund',4,6515248.0558912,-23960.457742471,6.0030720809312,58.461344044884);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Sandnes',4,6560720.1008521,-33563.529611082,5.7334325516682,58.852866167579);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Stavanger',4,6573688.9949027,-31757.931794651,5.7333213930776,58.970052279512);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Haugesund',4,6626568.0510899,-51111.949377127,5.26800276991,59.41377705351);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Bergen',4,6734371.7345753,-31975.837944241,5.3241560376233,60.392990985693);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Florø',4,6870054.5737789,-27643.11208833,5.0287744315266,61.599082491524);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Ålesund',4,6958028.2846714,44947.674564371,6.1549114534442,62.472255229237);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Molde',4,6980727.8631589,100005.95711474,7.1591191912944,62.737516535344);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Kristiansund',4,7018671.3741864,133627.8841843,7.7279437838472,63.110452701669);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Røros',4,6943364.5381969,314217.90555982,11.383388864752,62.574274991823);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Trondheim',4,7041816.7081716,270338.38481843,10.395066528837,63.430502767668);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Levanger',4,7074059.1084711,317401.94270289,11.298730526423,63.746505547069);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Steinkjer',4,7103378.3424614,328738.22028369,11.495380535896,64.014841658262);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Namsos',4,7153542.3619174,331623.7254026,11.497841646968,64.465583324841);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Bodø',4,7463027.320969,473071.10574631,14.375127778021,67.282669435757);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Narvik',4,7594127.0435103,599751.94251831,17.433158334111,68.442108324516);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Svolvær',4,7569157.1254068,481943.04311525,14.563627777961,68.235252768989);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Harstad',4,7632968.8816921,562308.87986634,16.544144443902,68.801116657834);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Tromsø',4,7731293.0038353,653038.96377385,18.944763939386,69.645591657295);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Hammerfest',4,7862774.6999221,819889.52358198,23.682074736064,70.663358115803);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Vardø',4,7886993.3619745,1097801.1033939,31.110664383822,70.370486115459);
insert into ub_point_0 (loc_name,loc_type,nord,ost, lng,lat) values ('Vadsø',4,7841923.1734189,1056173.013509,29.748722157222,70.074357189956);
</pre>