road_mapping_setup.sql

Java的框架

USE PRRM;

--
-- Dumping data for table `prrm`.`road_mapping`
--

INSERT INTO `ROAD_MAPPING` (`ID`, `ROADNAME`, `CATEGORY`,`BBOX`) VALUES 
(1,'ABBOTSINGH ROAD','MAJOR','BOX(103.678268432617 1.32697486877441,103.722450256348 1.43392181396484)'),
(2,'TAMPINES EXPRESSWAY','EXPRESS','BOX(103.722442626953 1.32542490959167,103.816223144531 1.44399654865265)'),
(3,'ABINGDON ROAD','MAJOR','BOX(103.746528625488 1.39197254180908,103.879776000977 1.3990478515625)'),
(4,'ADAM DRIVE','MAJOR','BOX(103.813896179199 1.2812511920929,103.918525695801 1.40524768829346)'),
(5,'ADAM PARK','MAJOR','BOX(103.925491333008 1.30837535858154,103.991371154785 1.36882376670837)'),
(6,'CENTRAL EXPRESSWAY','EXPRESS','BOX(103.760498046875 1.3068253993988,103.847999572754 1.43196523189545)'),
(7,'PAN ISLAND EXPRESSWAY','EXPRESS','BOX(103.776695251465 1.2735013961792,103.829399108887 1.45562124252319)'),
(8,'ADAM ROAD','MINOR','BOX(103.640617370605 1.33240079879761,103.647560119629 1.33974885940552)'),
(9,'BALESTIER ROAD','MINOR','BOX(103.64030456543 1.3310741186142,103.648483276367 1.34485161304474)'),
(10,'BATTERY ROAD','MINOR','BOX(103.645751953125 1.31918632984161,103.657402038574 1.33101367950439)'),
(11,'BAYSHORE ROAD','MINOR','BOX(103.674186706543 1.33454394340515,103.686752319336 1.34076941013336)'),
(12,'CAUSEWAY','MINOR','BOX(103.675666809082 1.30931091308594,103.68578338623 1.32507848739624)'),
(13,'CHANGI AIRPORT','MINOR','BOX(103.663116455078 1.30334079265594,103.673843383789 1.3178836107254)'),
(14,'CHANTEK FLYOVER','MINOR','BOX(103.689903259277 1.3086986541748,103.69588470459 1.30931103229523)'),
(15,'DELL LANE','MINOR','BOX(103.690063476563 1.30977022647858,103.71257019043 1.32339465618134)'),
(16,'DELTA ROAD','MINOR','BOX(103.711624145508 1.33399271965027,103.720588684082 1.37027323246002)'),
(17,'DUNLOP ROAD','MINOR','BOX(103.720199584961 1.32582461833954,103.728126525879 1.34545755386353)'),
(18,'EAST COAST PARKWAY','MINOR','BOX(103.758773803711 1.32651352882385,103.790817260742 1.36061263084412)'),
(19,'FRENCH ROAD','MINOR','BOX(103.732940673828 1.38851177692413,103.732948303223 1.38851189613342)'),
(20,'FULLERTON ROAD','MINOR','BOX(103.733627319336 1.38610064983368,103.757751464844 1.39367842674255)'),
(21,'GUILLEMARD CRESENT','MINOR','BOX(103.795288085938 1.3557904958725,103.809066772461 1.36956799030304)'),
(22,'GUILLEMARD ROAD','MINOR','BOX(103.847984313965 1.39126718044281,103.847991943359 1.3912672996521)'),
(23,'HAVELOCK ROAD','MINOR','BOX(103.858657836914 1.33925759792328,103.864181518555 1.35923492908478)'),
(24,'HOLLAND AVENUE','MINOR','BOX(103.91170501709 1.38058972358704,103.940986633301 1.38472306728363)'),
(25,'JALAN KAYU','MINOR','BOX(103.975082397461 1.36371243000031,103.98851776123 1.38644528388977)'),
(26,'JURONG ROAD','MINOR','BOX(103.946144104004 1.36956787109375,103.961311340332 1.38024544715881)'),
(27,'LENTOR FLYOVER','MINOR','BOX(103.874847412109 1.36681234836578,103.891387939453 1.37611222267151)'),
(28,'MANDAI FLYOVER','MINOR','BOX(103.802085876465 1.32110285758972,103.822319030762 1.34314095973969)'),
(29,'MANDAI ROAD','MINOR','BOX(103.80394744873 1.33362710475922,103.816543579102 1.33952808380127)'),
(30,'NANYANG FLYOVER','MINOR','BOX(103.810089111328 1.33266377449036,103.818588256836 1.33627665042877)'),
(31,'NEW BRIDGE ROAD','MINOR','BOX(103.809127807617 1.32495641708374,103.821235656738 1.33121871948242)'),
(32,'ONRAET ROAD','MINOR','BOX(103.814514160156 1.3388090133667,103.973747253418 1.38453114032745)'),
(33,'BUKIT TIMAH EXPRESSWAY','EXPRESS','BOX(103.644462585449 1.32677686214447,103.974952697754 1.37931716442108)'),
(34,'PANDAN FLYOVER','MINOR','BOX(103.643035888672 1.33049023151398,103.648170471191 1.33757174015045)'),
(35,'PASIR RIS DRIVE','MINOR','BOX(103.650932312012 1.32906579971313,103.662010192871 1.34139728546143)'),
(36,'SELETAR FLYOVER','MINOR','BOX(103.684761047363 1.34340727329254,103.705200195313 1.34937751293182)'),
(37,'SIMEI ROAD','MINOR','BOX(103.653861999512 1.31099605560303,103.664611816406 1.3204380273819)'),
(38,'TAMPINES FLYOVER','MINOR','BOX(103.664077758789 1.30228674411774,103.665954589844 1.30607175827026)'),
(39,'TAMPINES ROAD','MINOR','BOX(103.732009887695 1.37604200839996,103.73201751709 1.37604212760925)'),
(40,'TELOK BLANGAH ROAD','MINOR','BOX(103.732063293457 1.3496071100235,103.762840270996 1.3758989572525)'),
(41,'ULU PANDAN ROAD','MINOR','BOX(103.751007080078 1.40790557861328,103.778701782227 1.41479992866516)'),
(42,'ULU SEMBAWANG FLYOVER','MINOR','BOX(103.777481079102 1.41508567333221,103.791061401367 1.41915798187256)'),
(43,'UNIVERSITY FLYOVER','MINOR','BOX(103.821098327637 1.42555201053619,103.838928222656 1.44502031803131)'),
(44,'UPPER CHANGI ROAD','MINOR','BOX(103.831024169922 1.42312300205231,103.837074279785 1.42998158931732)'),
(45,'UPPER SERANGOON ROAD','MINOR','BOX(103.834739685059 1.42076528072357,103.844108581543 1.42480194568634)'),
(46,'WEST COAST HIGHWAY','MINOR','BOX(103.847564697266 1.36186063289642,103.870330810547 1.38440096378326)'),
(47,'YIO CHU KANG ROAD','MINOR','BOX(103.87385559082 1.33038997650146,103.900260925293 1.35114431381226)'),
(48,'XILIN AVENUE','MINOR','BOX(103.88818359375 1.34489285945892,103.909225463867 1.3616464138031)'),
(49,'ZENGHUA FLYOVER','MINOR','BOX(103.885932922363 1.35671675205231,103.916694641113 1.36586153507233)'),
(50,'ZION ROAD','MINOR','BOX(103.960731506348 1.36157476902008,103.979598999023 1.37550628185272)');