id sid tid token lemma pos gi-2723 1 1 openstreetmap openstreetmap ADV gi-2723 1 2 over over ADP gi-2723 1 3 wms wms PROPN gi-2723 1 4 přemysl přemysl NOUN gi-2723 1 5 vohnout vohnout ADV gi-2723 1 6 , , PUNCT gi-2723 1 7 jáchym jáchym PROPN gi-2723 1 8 čepický čepický NOUN gi-2723 1 9 czech czech PROPN gi-2723 1 10 centrum centrum NOUN gi-2723 1 11 for for ADP gi-2723 1 12 science science NOUN gi-2723 1 13 and and CCONJ gi-2723 1 14 society society NOUN gi-2723 1 15 , , PUNCT gi-2723 1 16 help help VERB gi-2723 1 17 service service NOUN gi-2723 1 18 remote remote ADJ gi-2723 1 19 sensing sense VERB gi-2723 1 20 vohnout@ccss.cz vohnout@ccss.cz PROPN gi-2723 1 21 , , PUNCT gi-2723 1 22 jachym@bnhelp.cz jachym@bnhelp.cz PROPN gi-2723 1 23 keywords keyword NOUN gi-2723 1 24 : : PUNCT gi-2723 1 25 wms wms PROPN gi-2723 1 26 , , PUNCT gi-2723 1 27 openstreetmap openstreetmap ADJ gi-2723 1 28 , , PUNCT gi-2723 1 29 mapserver mapserver ADV gi-2723 1 30 abstract abstract ADJ gi-2723 1 31 this this DET gi-2723 1 32 paper paper NOUN gi-2723 1 33 discuss discuss VERB gi-2723 1 34 the the DET gi-2723 1 35 issues issue NOUN gi-2723 1 36 which which PRON gi-2723 1 37 we we PRON gi-2723 1 38 faced face VERB gi-2723 1 39 , , PUNCT gi-2723 1 40 while while SCONJ gi-2723 1 41 preparing prepare VERB gi-2723 1 42 wms wms PROPN gi-2723 1 43 server server NOUN gi-2723 1 44 with with ADP gi-2723 1 45 openstreetmap openstreetmap ADJ gi-2723 1 46 data datum NOUN gi-2723 1 47 of of ADP gi-2723 1 48 whole whole ADJ gi-2723 1 49 europe europe PROPN gi-2723 1 50 . . PUNCT gi-2723 2 1 this this DET gi-2723 2 2 article article NOUN gi-2723 2 3 is be AUX gi-2723 2 4 divided divide VERB gi-2723 2 5 into into ADP gi-2723 2 6 three three NUM gi-2723 2 7 sections section NOUN gi-2723 2 8 . . PUNCT gi-2723 3 1 first first ADV gi-2723 3 2 is be AUX gi-2723 3 3 about about ADP gi-2723 3 4 mandatory mandatory ADJ gi-2723 3 5 applications application NOUN gi-2723 3 6 which which PRON gi-2723 3 7 are be AUX gi-2723 3 8 required require VERB gi-2723 3 9 for for ADP gi-2723 3 10 working work VERB gi-2723 3 11 wms wms PROPN gi-2723 3 12 service service NOUN gi-2723 3 13 with with ADP gi-2723 3 14 openstreetmap openstreetmap PROPN gi-2723 3 15 data datum NOUN gi-2723 3 16 . . PUNCT gi-2723 4 1 second second ADJ gi-2723 4 2 is be AUX gi-2723 4 3 focused focus VERB gi-2723 4 4 on on ADP gi-2723 4 5 tuning tune VERB gi-2723 4 6 up up ADP gi-2723 4 7 postgresql postgresql NOUN gi-2723 4 8 . . PUNCT gi-2723 5 1 third third ADJ gi-2723 5 2 is be AUX gi-2723 5 3 focused focus VERB gi-2723 5 4 on on ADP gi-2723 5 5 rendering render VERB gi-2723 5 6 time time NOUN gi-2723 5 7 improvement improvement NOUN gi-2723 5 8 of of ADP gi-2723 5 9 layers layer NOUN gi-2723 5 10 . . PUNCT gi-2723 6 1 prerequisites prerequisite NOUN gi-2723 6 2 there there PRON gi-2723 6 3 is be VERB gi-2723 6 4 need need NOUN gi-2723 6 5 of of ADP gi-2723 6 6 data datum NOUN gi-2723 6 7 first first ADV gi-2723 6 8 of of ADP gi-2723 6 9 all all PRON gi-2723 6 10 . . PUNCT gi-2723 7 1 data datum NOUN gi-2723 7 2 can can AUX gi-2723 7 3 be be AUX gi-2723 7 4 acquired acquire VERB gi-2723 7 5 from from ADP gi-2723 7 6 several several ADJ gi-2723 7 7 repositories repository NOUN gi-2723 7 8 where where SCONJ gi-2723 7 9 are be AUX gi-2723 7 10 made make VERB gi-2723 7 11 live live ADJ gi-2723 7 12 dumps dump NOUN gi-2723 7 13 from from ADP gi-2723 7 14 osm osm NOUN gi-2723 7 15 databases database NOUN gi-2723 7 16 . . PUNCT gi-2723 8 1 there there PRON gi-2723 8 2 is be VERB gi-2723 8 3 possibility possibility NOUN gi-2723 8 4 to to PART gi-2723 8 5 choose choose VERB gi-2723 8 6 data datum NOUN gi-2723 8 7 by by ADP gi-2723 8 8 geographic geographic ADJ gi-2723 8 9 and and CCONJ gi-2723 8 10 country country NOUN gi-2723 8 11 distribution distribution NOUN gi-2723 8 12 . . PUNCT gi-2723 9 1 you you PRON gi-2723 9 2 can can AUX gi-2723 9 3 download download VERB gi-2723 9 4 for for ADP gi-2723 9 5 example example NOUN gi-2723 9 6 shapefiles shapefile NOUN gi-2723 9 7 , , PUNCT gi-2723 9 8 country country NOUN gi-2723 9 9 borders border NOUN gi-2723 9 10 or or CCONJ gi-2723 9 11 ” " PUNCT gi-2723 9 12 osm osm NOUN gi-2723 9 13 dump dump NOUN gi-2723 9 14 ” " PUNCT gi-2723 9 15 . . PUNCT gi-2723 10 1 this this DET gi-2723 10 2 data datum NOUN gi-2723 10 3 can can AUX gi-2723 10 4 be be AUX gi-2723 10 5 obtained obtain VERB gi-2723 10 6 from from ADP gi-2723 10 7 http://downloads.cloudmade.com http://downloads.cloudmade.com NOUN gi-2723 10 8 or or CCONJ gi-2723 10 9 http://geofabrik.de http://geofabrik.de PROPN gi-2723 10 10 , , PUNCT gi-2723 10 11 ... ... PUNCT gi-2723 11 1 we we PRON gi-2723 11 2 used use VERB gi-2723 11 3 data datum NOUN gi-2723 11 4 from from ADP gi-2723 11 5 geofabrik.de geofabrik.de PROPN gi-2723 11 6 . . PUNCT gi-2723 12 1 we we PRON gi-2723 12 2 are be AUX gi-2723 12 3 using use VERB gi-2723 12 4 mapserver mapserver ADV gi-2723 12 5 for for ADP gi-2723 12 6 rendering render VERB gi-2723 12 7 data datum NOUN gi-2723 12 8 from from ADP gi-2723 12 9 postgresql postgresql NOUN gi-2723 12 10 to to ADP gi-2723 12 11 wms wms PROPN gi-2723 12 12 . . PUNCT gi-2723 13 1 there there PRON gi-2723 13 2 are be VERB gi-2723 13 3 some some DET gi-2723 13 4 requirements requirement NOUN gi-2723 13 5 which which PRON gi-2723 13 6 are be AUX gi-2723 13 7 required require VERB gi-2723 13 8 to to PART gi-2723 13 9 keep keep VERB gi-2723 13 10 for for ADP gi-2723 13 11 best good ADJ gi-2723 13 12 result result NOUN gi-2723 13 13 of of ADP gi-2723 13 14 maps map NOUN gi-2723 13 15 . . PUNCT gi-2723 14 1 � � PROPN gi-2723 14 2 mapserver mapserver ADV gi-2723 14 3 of of ADP gi-2723 14 4 version version NOUN gi-2723 14 5 5.4 5.4 NUM gi-2723 14 6 and and CCONJ gi-2723 14 7 higher high ADJ gi-2723 14 8 . . PUNCT gi-2723 15 1 this this PRON gi-2723 15 2 is be AUX gi-2723 15 3 required require VERB gi-2723 15 4 due due ADP gi-2723 15 5 to to ADP gi-2723 15 6 change change NOUN gi-2723 15 7 of of ADP gi-2723 15 8 labels label NOUN gi-2723 15 9 rendering render VERB gi-2723 15 10 machine machine NOUN gi-2723 15 11 . . PUNCT gi-2723 16 1 � � PROPN gi-2723 16 2 application application PROPN gi-2723 16 3 osm2pgsql osm2pgsql PROPN gi-2723 16 4 . . PUNCT gi-2723 17 1 this this PRON gi-2723 17 2 is be AUX gi-2723 17 3 a a DET gi-2723 17 4 little little ADJ gi-2723 17 5 bit bit NOUN gi-2723 17 6 still still ADV gi-2723 17 7 development development NOUN gi-2723 17 8 application application NOUN gi-2723 17 9 . . PUNCT gi-2723 18 1 � � PROPN gi-2723 18 2 postgresql postgresql PROPN gi-2723 18 3 of of ADP gi-2723 18 4 version version NOUN gi-2723 18 5 8.0 8.0 NUM gi-2723 18 6 and and CCONJ gi-2723 18 7 higher high ADJ gi-2723 18 8 with with ADP gi-2723 18 9 postgis postgis PROPN gi-2723 18 10 . . PUNCT gi-2723 19 1 i i PRON gi-2723 19 2 recommend recommend VERB gi-2723 19 3 8.3 8.3 NUM gi-2723 19 4 with with ADP gi-2723 19 5 postgis postgis PROPN gi-2723 19 6 1.3.5 1.3.5 NUM gi-2723 19 7 and and CCONJ gi-2723 19 8 higher high ADJ gi-2723 19 9 . . PUNCT gi-2723 20 1 there there PRON gi-2723 20 2 was be VERB gi-2723 20 3 some some DET gi-2723 20 4 bug bug NOUN gi-2723 20 5 in in ADP gi-2723 20 6 1.3.3 1.3.3 NUM gi-2723 20 7 which which PRON gi-2723 20 8 was be AUX gi-2723 20 9 returning return VERB gi-2723 20 10 bad bad ADJ gi-2723 20 11 bounding bounding NOUN gi-2723 20 12 box box NOUN gi-2723 20 13 . . PUNCT gi-2723 21 1 � � PROPN gi-2723 21 2 optional optional ADJ gi-2723 21 3 mapserver mapserver ADJ gi-2723 21 4 - - PUNCT gi-2723 21 5 utils util NOUN gi-2723 21 6 – – PUNCT gi-2723 21 7 this this DET gi-2723 21 8 project project NOUN gi-2723 21 9 contains contain VERB gi-2723 21 10 mapfiles mapfile NOUN gi-2723 21 11 for for ADP gi-2723 21 12 advanced advanced ADJ gi-2723 21 13 drawing drawing NOUN gi-2723 21 14 of of ADP gi-2723 21 15 layers layer NOUN gi-2723 21 16 from from ADP gi-2723 21 17 openstreetmap openstreetmap NUM gi-2723 21 18 . . PUNCT gi-2723 22 1 you you PRON gi-2723 22 2 need need VERB gi-2723 22 3 n’t not PART gi-2723 22 4 to to PART gi-2723 22 5 use use VERB gi-2723 22 6 this this DET gi-2723 22 7 mapfiles mapfile NOUN gi-2723 22 8 but but CCONJ gi-2723 22 9 it it PRON gi-2723 22 10 ’s ’s AUX gi-2723 22 11 recommended recommend VERB gi-2723 22 12 . . PUNCT gi-2723 23 1 this this PRON gi-2723 23 2 can can AUX gi-2723 23 3 be be AUX gi-2723 23 4 obtained obtain VERB gi-2723 23 5 from from ADP gi-2723 23 6 http://code.google.com/p/mapserver-utils http://code.google.com/p/mapserver-util NOUN gi-2723 23 7 . . PUNCT gi-2723 24 1 because because SCONJ gi-2723 24 2 mapserver mapserver ADJ gi-2723 24 3 5.4 5.4 NUM gi-2723 24 4 and and CCONJ gi-2723 24 5 postgis postgis PROPN gi-2723 24 6 1.3.5 1.3.5 NUM gi-2723 24 7 is be AUX gi-2723 24 8 very very ADV gi-2723 24 9 recent recent ADJ gi-2723 24 10 user user NOUN gi-2723 24 11 will will AUX gi-2723 24 12 probably probably ADV gi-2723 24 13 do do AUX gi-2723 24 14 n’t not PART gi-2723 24 15 find find VERB gi-2723 24 16 it it PRON gi-2723 24 17 in in ADP gi-2723 24 18 repository repository NOUN gi-2723 24 19 of of ADP gi-2723 24 20 almost almost ADV gi-2723 24 21 every every PRON gi-2723 24 22 distribution distribution NOUN gi-2723 24 23 of of ADP gi-2723 24 24 linux linux PROPN gi-2723 24 25 if if SCONJ gi-2723 24 26 you you PRON gi-2723 24 27 are be AUX gi-2723 24 28 not not PART gi-2723 24 29 using use VERB gi-2723 24 30 some some DET gi-2723 24 31 kind kind NOUN gi-2723 24 32 of of ADP gi-2723 24 33 rollingupdates rollingupdate NOUN gi-2723 24 34 distribution distribution NOUN gi-2723 24 35 ( ( PUNCT gi-2723 24 36 like like INTJ gi-2723 24 37 gentoo gentoo NOUN gi-2723 24 38 ) ) PUNCT gi-2723 24 39 . . PUNCT gi-2723 25 1 here here ADV gi-2723 25 2 is be AUX gi-2723 25 3 small small ADJ gi-2723 25 4 howto howto NOUN gi-2723 25 5 create create VERB gi-2723 25 6 your your PRON gi-2723 25 7 own own ADJ gi-2723 25 8 deb deb NOUN gi-2723 25 9 packages package NOUN gi-2723 25 10 in in ADP gi-2723 25 11 debian debian NOUN gi-2723 25 12 . . PUNCT gi-2723 26 1 first first ADV gi-2723 26 2 of of ADP gi-2723 26 3 all all PRON gi-2723 26 4 you you PRON gi-2723 26 5 will will AUX gi-2723 26 6 need need VERB gi-2723 26 7 pbuilder pbuilder ADJ gi-2723 26 8 application application NOUN gi-2723 26 9 . . PUNCT gi-2723 27 1 this this DET gi-2723 27 2 application application NOUN gi-2723 27 3 will will AUX gi-2723 27 4 make make VERB gi-2723 27 5 ” " PUNCT gi-2723 27 6 fake fake ADJ gi-2723 27 7 ” " PUNCT gi-2723 27 8 image image NOUN gi-2723 27 9 of of ADP gi-2723 27 10 system system NOUN gi-2723 27 11 . . PUNCT gi-2723 28 1 after after ADP gi-2723 28 2 small small ADJ gi-2723 28 3 tweaking tweaking NOUN gi-2723 28 4 of of ADP gi-2723 28 5 config config NOUN gi-2723 28 6 file file NOUN gi-2723 28 7 you you PRON gi-2723 28 8 can can AUX gi-2723 28 9 start start VERB gi-2723 28 10 making make VERB gi-2723 28 11 debian debian ADJ gi-2723 28 12 packages package NOUN gi-2723 28 13 . . PUNCT gi-2723 29 1 geinformatics geinformatic NOUN gi-2723 29 2 fce fce VERB gi-2723 29 3 ctu ctu NOUN gi-2723 29 4 2009 2009 NUM gi-2723 29 5 63 63 NUM gi-2723 29 6 http://downloads.cloudmade.com http://downloads.cloudmade.com X gi-2723 30 1 http://geofabrik.de http://geofabrik.de X gi-2723 30 2 http://code.google.com/p/mapserver-utils http://code.google.com/p/mapserver-util VERB gi-2723 30 3 vohnout vohnout ADP gi-2723 30 4 p. p. NOUN gi-2723 30 5 , , PUNCT gi-2723 30 6 čepický čepický PROPN gi-2723 30 7 j. j. PROPN gi-2723 30 8 : : PUNCT gi-2723 30 9 openstreetmap openstreetmap NOUN gi-2723 30 10 over over ADP gi-2723 30 11 wms wms PROPN gi-2723 30 12 aptitude aptitude NOUN gi-2723 30 13 install install NOUN gi-2723 30 14 pbuilder pbuilder NOUN gi-2723 30 15 pbuilder pbuilder NOUN gi-2723 30 16 create create NOUN gi-2723 30 17 --distribution --distribution PUNCT gi-2723 30 18 lenny lenny PROPN gi-2723 30 19 ( ( PUNCT gi-2723 30 20 lenny lenny PROPN gi-2723 30 21 is be AUX gi-2723 30 22 last last ADJ gi-2723 30 23 branch branch NOUN gi-2723 30 24 of of ADP gi-2723 30 25 debian debian NOUN gi-2723 30 26 , , PUNCT gi-2723 30 27 etch etch NOUN gi-2723 30 28 is be AUX gi-2723 30 29 previous previous ADJ gi-2723 30 30 ) ) PUNCT gi-2723 30 31 editor editor NOUN gi-2723 30 32 /etc /etc NOUN gi-2723 30 33 / / SYM gi-2723 30 34 pbuilderrc pbuilderrc NOUN gi-2723 30 35 and and CCONJ gi-2723 30 36 put put VERB gi-2723 30 37 there there ADV gi-2723 30 38 something something PRON gi-2723 30 39 like like ADP gi-2723 30 40 this this PRON gi-2723 30 41 : : PUNCT gi-2723 30 42 mirrorsite mirrorsite PROPN gi-2723 30 43 = = PROPN gi-2723 30 44 http://ftp.cz.debian.org http://ftp.cz.debian.org PROPN gi-2723 30 45 / / SYM gi-2723 30 46 debian/ debian/ NUM gi-2723 30 47 othermirror="deb othermirror="deb CCONJ gi-2723 30 48 http://www.backports.org/debian http://www.backports.org/debian ADJ gi-2723 30 49 lenny lenny PROPN gi-2723 30 50 - - PUNCT gi-2723 30 51 backports backports PROPN gi-2723 30 52 main main ADJ gi-2723 30 53 | | NOUN gi-2723 30 54 \ \ PROPN gi-2723 30 55 deb deb PROPN gi-2723 30 56 file:///var file:///var PROPN gi-2723 30 57 / / SYM gi-2723 30 58 cache cache NOUN gi-2723 30 59 / / SYM gi-2723 30 60 pbuilder pbuilder NOUN gi-2723 30 61 / / SYM gi-2723 30 62 result result NOUN gi-2723 30 63 ./ ./ SYM gi-2723 30 64 " " PUNCT gi-2723 30 65 hookdir=/etc hookdir=/etc NOUN gi-2723 30 66 / / SYM gi-2723 30 67 pbuilder pbuilder ADJ gi-2723 30 68 / / SYM gi-2723 30 69 hook.d hook.d PROPN gi-2723 30 70 bindmounts="/var bindmounts="/var PROPN gi-2723 30 71 / / SYM gi-2723 30 72 cache cache NOUN gi-2723 30 73 / / SYM gi-2723 30 74 pbuilder pbuilder NOUN gi-2723 30 75 / / SYM gi-2723 30 76 result result NOUN gi-2723 30 77 /home /home INTJ gi-2723 30 78 /usr /usr NOUN gi-2723 30 79 / / SYM gi-2723 30 80 src src NOUN gi-2723 30 81 " " PUNCT gi-2723 30 82 extrapackages="debian extrapackages="debian ADJ gi-2723 30 83 - - PUNCT gi-2723 30 84 backports backport NOUN gi-2723 30 85 - - PUNCT gi-2723 30 86 keyring keyring NOUN gi-2723 30 87 proj=4.6.1 proj=4.6.1 NOUN gi-2723 30 88 - - PUNCT gi-2723 30 89 5 5 NUM gi-2723 30 90 ~ ~ NOUN gi-2723 30 91 bpo50 bpo50 NOUN gi-2723 30 92 + + NOUN gi-2723 30 93 1 1 NUM gi-2723 30 94 proj proj NOUN gi-2723 30 95 - - PUNCT gi-2723 30 96 bin bin NOUN gi-2723 30 97 libproj0 libproj0 PROPN gi-2723 30 98 libproj libproj NOUN gi-2723 30 99 - - PUNCT gi-2723 30 100 dev dev NOUN gi-2723 30 101 " " PUNCT gi-2723 30 102 � � PROPN gi-2723 30 103 download download NOUN gi-2723 30 104 package package NOUN gi-2723 30 105 control control NOUN gi-2723 30 106 files file NOUN gi-2723 30 107 from from ADP gi-2723 30 108 svn://svn.debian.org/svn/pkg-grass/packages//trunk svn://svn.debian.org/svn/pkg-grass/packages//trunk VERB gi-2723 30 109 somewhere somewhere ADV gi-2723 30 110 where where SCONJ gi-2723 30 111 you you PRON gi-2723 30 112 can can AUX gi-2723 30 113 find find VERB gi-2723 30 114 them they PRON gi-2723 30 115 easily easily ADV gi-2723 30 116 ( ( PUNCT gi-2723 30 117 for for ADP gi-2723 30 118 example example NOUN gi-2723 30 119 /usr /usr NOUN gi-2723 30 120 / / SYM gi-2723 30 121 local local ADJ gi-2723 30 122 / / SYM gi-2723 30 123 src src NOUN gi-2723 30 124 ) ) PUNCT gi-2723 30 125 . . PUNCT gi-2723 31 1 � � PROPN gi-2723 31 2 download download NOUN gi-2723 31 3 tarballs tarball VERB gi-2723 31 4 to to ADP gi-2723 31 5 directory directory NOUN gi-2723 31 6 from from ADP gi-2723 31 7 previous previous ADJ gi-2723 31 8 point point NOUN gi-2723 31 9 . . PUNCT gi-2723 32 1 � � PROPN gi-2723 32 2 last last ADJ gi-2723 32 3 step step NOUN gi-2723 32 4 is be AUX gi-2723 32 5 to to PART gi-2723 32 6 create create VERB gi-2723 32 7 package package NOUN gi-2723 32 8 by by ADP gi-2723 32 9 pdebuild pdebuild NOUN gi-2723 32 10 --use --use NOUN gi-2723 32 11 - - ADJ gi-2723 32 12 pdebuild pdebuild NOUN gi-2723 32 13 - - PUNCT gi-2723 32 14 internal internal ADJ gi-2723 32 15 if if SCONJ gi-2723 32 16 it it PRON gi-2723 32 17 is be AUX gi-2723 32 18 everything everything PRON gi-2723 32 19 ok ok INTJ gi-2723 32 20 you you PRON gi-2723 32 21 will will AUX gi-2723 32 22 have have VERB gi-2723 32 23 package package NOUN gi-2723 32 24 ready ready ADJ gi-2723 32 25 to to PART gi-2723 32 26 install install VERB gi-2723 32 27 . . PUNCT gi-2723 33 1 postgresql postgresql NOUN gi-2723 33 2 part part NOUN gi-2723 33 3 postgresql postgresql NOUN gi-2723 33 4 is be AUX gi-2723 33 5 configured configure VERB gi-2723 33 6 for for ADP gi-2723 33 7 secure secure ADJ gi-2723 33 8 and and CCONJ gi-2723 33 9 reliable reliable ADJ gi-2723 33 10 handling handling NOUN gi-2723 33 11 of of ADP gi-2723 33 12 data datum NOUN gi-2723 33 13 by by ADP gi-2723 33 14 default default NOUN gi-2723 33 15 , , PUNCT gi-2723 33 16 but but CCONJ gi-2723 33 17 if if SCONJ gi-2723 33 18 you you PRON gi-2723 33 19 want want VERB gi-2723 33 20 to to PART gi-2723 33 21 handle handle VERB gi-2723 33 22 big big ADJ gi-2723 33 23 amounts amount NOUN gi-2723 33 24 of of ADP gi-2723 33 25 data datum NOUN gi-2723 33 26 it it PRON gi-2723 33 27 ’s ’ VERB gi-2723 33 28 better well ADJ gi-2723 33 29 to to PART gi-2723 33 30 do do VERB gi-2723 33 31 some some DET gi-2723 33 32 tweaks tweak NOUN gi-2723 33 33 . . PUNCT gi-2723 34 1 you you PRON gi-2723 34 2 should should AUX gi-2723 34 3 think think VERB gi-2723 34 4 about about ADP gi-2723 34 5 your your PRON gi-2723 34 6 hardware hardware NOUN gi-2723 34 7 in in ADP gi-2723 34 8 the the DET gi-2723 34 9 beginning beginning NOUN gi-2723 34 10 for for ADP gi-2723 34 11 better well ADJ gi-2723 34 12 performance performance NOUN gi-2723 34 13 of of ADP gi-2723 34 14 your your PRON gi-2723 34 15 database database NOUN gi-2723 34 16 management management NOUN gi-2723 34 17 system system NOUN gi-2723 34 18 . . PUNCT gi-2723 35 1 memory memory NOUN gi-2723 35 2 is be AUX gi-2723 35 3 faster fast ADJ gi-2723 35 4 than than SCONJ gi-2723 35 5 hdd hdd NOUN gi-2723 35 6 but but CCONJ gi-2723 35 7 it it PRON gi-2723 35 8 is be AUX gi-2723 35 9 not not PART gi-2723 35 10 possible possible ADJ gi-2723 35 11 to to PART gi-2723 35 12 buy buy VERB gi-2723 35 13 lot lot NOUN gi-2723 35 14 of of ADP gi-2723 35 15 memories memory NOUN gi-2723 35 16 because because SCONJ gi-2723 35 17 there there PRON gi-2723 35 18 is be VERB gi-2723 35 19 limited limited ADJ gi-2723 35 20 number number NOUN gi-2723 35 21 of of ADP gi-2723 35 22 memory memory NOUN gi-2723 35 23 slots slot NOUN gi-2723 35 24 . . PUNCT gi-2723 36 1 ssd ssd NOUN gi-2723 36 2 disks disk NOUN gi-2723 36 3 are be AUX gi-2723 36 4 slower slow ADJ gi-2723 36 5 but but CCONJ gi-2723 36 6 their their PRON gi-2723 36 7 size size NOUN gi-2723 36 8 is be AUX gi-2723 36 9 still still ADV gi-2723 36 10 not not PART gi-2723 36 11 so so ADV gi-2723 36 12 big big ADJ gi-2723 36 13 ( ( PUNCT gi-2723 36 14 max max PROPN gi-2723 36 15 128 128 NUM gi-2723 36 16 gb gb NOUN gi-2723 36 17 ) ) PUNCT gi-2723 36 18 and and CCONJ gi-2723 36 19 they they PRON gi-2723 36 20 are be AUX gi-2723 36 21 more more ADV gi-2723 36 22 expensive expensive ADJ gi-2723 36 23 . . PUNCT gi-2723 37 1 most most ADV gi-2723 37 2 used use VERB gi-2723 37 3 scenario scenario NOUN gi-2723 37 4 is be AUX gi-2723 37 5 disks disk NOUN gi-2723 37 6 connected connect VERB gi-2723 37 7 into into ADP gi-2723 37 8 raid raid NOUN gi-2723 37 9 . . PUNCT gi-2723 38 1 raid1 raid1 NOUN gi-2723 38 2 at at ADV gi-2723 38 3 least least ADJ gi-2723 38 4 but but CCONJ gi-2723 38 5 i i PRON gi-2723 38 6 prefer prefer VERB gi-2723 38 7 raid5 raid5 NOUN gi-2723 38 8 . . PUNCT gi-2723 39 1 raid5 raid5 NOUN gi-2723 39 2 is be AUX gi-2723 39 3 slower slow ADJ gi-2723 39 4 when when SCONJ gi-2723 39 5 writing write VERB gi-2723 39 6 data datum NOUN gi-2723 39 7 to to ADP gi-2723 39 8 disks disk NOUN gi-2723 39 9 but but CCONJ gi-2723 39 10 faster fast ADV gi-2723 39 11 when when SCONJ gi-2723 39 12 reading read VERB gi-2723 39 13 data datum NOUN gi-2723 39 14 from from ADP gi-2723 39 15 disks disk NOUN gi-2723 39 16 . . PUNCT gi-2723 40 1 software software NOUN gi-2723 40 2 tweaking tweaking NOUN gi-2723 40 3 of of ADP gi-2723 40 4 postgresql postgresql NOUN gi-2723 40 5 can can AUX gi-2723 40 6 be be AUX gi-2723 40 7 done do VERB gi-2723 40 8 in in ADP gi-2723 40 9 config config NOUN gi-2723 40 10 file file NOUN gi-2723 40 11 which which PRON gi-2723 40 12 you you PRON gi-2723 40 13 can can AUX gi-2723 40 14 find find VERB gi-2723 40 15 in in ADP gi-2723 40 16 clusterdir clusterdir PROPN gi-2723 40 17 / / SYM gi-2723 40 18 postgresql.conf postgresql.conf PROPN gi-2723 40 19 . . PUNCT gi-2723 41 1 � � PROPN gi-2723 41 2 shared share VERB gi-2723 41 3 buffers buffer NOUN gi-2723 41 4 – – PUNCT gi-2723 41 5 this this DET gi-2723 41 6 parameter parameter NOUN gi-2723 41 7 defines define NOUN gi-2723 41 8 amount amount NOUN gi-2723 41 9 of of ADP gi-2723 41 10 memory memory NOUN gi-2723 41 11 in in ADP gi-2723 41 12 which which PRON gi-2723 41 13 postgresql postgresql NOUN gi-2723 41 14 will will AUX gi-2723 41 15 hold hold VERB gi-2723 41 16 requests request NOUN gi-2723 41 17 . . PUNCT gi-2723 42 1 this this PRON gi-2723 42 2 should should AUX gi-2723 42 3 be be AUX gi-2723 42 4 set set VERB gi-2723 42 5 to to ADP gi-2723 42 6 thousands thousand NOUN gi-2723 42 7 ( ( PUNCT gi-2723 42 8 one one NUM gi-2723 42 9 buffer buffer NOUN gi-2723 42 10 is be AUX gi-2723 42 11 8 8 NUM gi-2723 42 12 kb kb NOUN gi-2723 42 13 ) ) PUNCT gi-2723 42 14 . . PUNCT gi-2723 43 1 some some DET gi-2723 43 2 sources source NOUN gi-2723 43 3 writes write VERB gi-2723 43 4 one one NUM gi-2723 43 5 quarter quarter NOUN gi-2723 43 6 of of ADP gi-2723 43 7 memory memory NOUN gi-2723 43 8 another another DET gi-2723 43 9 writes write VERB gi-2723 43 10 set set VERB gi-2723 43 11 this this PRON gi-2723 43 12 to to ADP gi-2723 43 13 256 256 NUM gi-2723 43 14 mb mb NOUN gi-2723 43 15 ( ( PUNCT gi-2723 43 16 32768 32768 NUM gi-2723 43 17 ) ) PUNCT gi-2723 43 18 . . PUNCT gi-2723 44 1 � � PROPN gi-2723 44 2 maintenance maintenance NOUN gi-2723 44 3 work work NOUN gi-2723 44 4 mem mem X gi-2723 44 5 – – PUNCT gi-2723 44 6 specifies specifie NOUN gi-2723 44 7 amount amount NOUN gi-2723 44 8 of of ADP gi-2723 44 9 memory memory NOUN gi-2723 44 10 which which PRON gi-2723 44 11 is be AUX gi-2723 44 12 used use VERB gi-2723 44 13 for for ADP gi-2723 44 14 maintenance maintenance NOUN gi-2723 44 15 operations operation NOUN gi-2723 44 16 like like ADP gi-2723 44 17 vacuum vacuum NOUN gi-2723 44 18 , , PUNCT gi-2723 44 19 create create VERB gi-2723 44 20 index index NOUN gi-2723 44 21 ... ... PUNCT gi-2723 45 1 this this PRON gi-2723 45 2 should should AUX gi-2723 45 3 be be AUX gi-2723 45 4 set set VERB gi-2723 45 5 to to ADP gi-2723 45 6 bigger big ADJ gi-2723 45 7 amount amount NOUN gi-2723 45 8 than than ADP gi-2723 45 9 default default NOUN gi-2723 45 10 . . PUNCT gi-2723 46 1 very very ADV gi-2723 46 2 usable usable ADJ gi-2723 46 3 if if SCONJ gi-2723 46 4 you you PRON gi-2723 46 5 are be AUX gi-2723 46 6 using use VERB gi-2723 46 7 autovacuum autovacuum PROPN gi-2723 46 8 operation operation NOUN gi-2723 46 9 . . PUNCT gi-2723 47 1 � � PROPN gi-2723 47 2 effective effective ADJ gi-2723 47 3 cache cache NOUN gi-2723 47 4 size size NOUN gi-2723 47 5 – – PUNCT gi-2723 47 6 this this DET gi-2723 47 7 parameter parameter NOUN gi-2723 47 8 has have VERB gi-2723 47 9 impact impact NOUN gi-2723 47 10 on on ADP gi-2723 47 11 planning planning NOUN gi-2723 47 12 operation operation NOUN gi-2723 47 13 of of ADP gi-2723 47 14 postgresql postgresql NOUN gi-2723 47 15 . . PUNCT gi-2723 48 1 bigger big ADJ gi-2723 48 2 amount amount NOUN gi-2723 48 3 will will AUX gi-2723 48 4 trigger trigger VERB gi-2723 48 5 using use VERB gi-2723 48 6 index index NOUN gi-2723 48 7 scans scan NOUN gi-2723 48 8 , , PUNCT gi-2723 48 9 lower low ADJ gi-2723 48 10 will will AUX gi-2723 48 11 use use VERB gi-2723 48 12 sequential sequential ADJ gi-2723 48 13 scans scan NOUN gi-2723 48 14 . . PUNCT gi-2723 49 1 � � PROPN gi-2723 49 2 checkpoint checkpoint NOUN gi-2723 49 3 segments segment NOUN gi-2723 49 4 – – PUNCT gi-2723 49 5 if if SCONJ gi-2723 49 6 you you PRON gi-2723 49 7 will will AUX gi-2723 49 8 see see VERB gi-2723 49 9 this this PRON gi-2723 49 10 in in ADP gi-2723 49 11 your your PRON gi-2723 49 12 log log NOUN gi-2723 49 13 ” " PUNCT gi-2723 49 14 checkpoints checkpoint NOUN gi-2723 49 15 are be AUX gi-2723 49 16 occurring occur VERB gi-2723 49 17 too too ADV gi-2723 49 18 frequently frequently ADV gi-2723 49 19 ( ( PUNCT gi-2723 49 20 29 29 NUM gi-2723 49 21 seconds second NOUN gi-2723 49 22 apart apart ADV gi-2723 49 23 ) ) PUNCT gi-2723 49 24 ” " PUNCT gi-2723 50 1 set set VERB gi-2723 50 2 this this DET gi-2723 50 3 parameter parameter NOUN gi-2723 50 4 bigger big ADJ gi-2723 50 5 then then ADP gi-2723 50 6 3 3 X gi-2723 50 7 . . PUNCT gi-2723 50 8 geinformatics geinformatics PROPN gi-2723 50 9 fce fce VERB gi-2723 50 10 ctu ctu NOUN gi-2723 50 11 2009 2009 NUM gi-2723 50 12 64 64 NUM gi-2723 50 13 vohnout vohnout ADP gi-2723 50 14 p. p. NOUN gi-2723 50 15 , , PUNCT gi-2723 50 16 čepický čepický PROPN gi-2723 50 17 j. j. PROPN gi-2723 50 18 : : PUNCT gi-2723 50 19 openstreetmap openstreetmap NOUN gi-2723 50 20 over over ADP gi-2723 50 21 wms wms PROPN gi-2723 50 22 getting get VERB gi-2723 50 23 data datum NOUN gi-2723 50 24 to to ADP gi-2723 50 25 postgresql postgresql NOUN gi-2723 50 26 data datum NOUN gi-2723 50 27 from from ADP gi-2723 50 28 osm osm NOUN gi-2723 50 29 format format NOUN gi-2723 50 30 are be AUX gi-2723 50 31 put put VERB gi-2723 50 32 into into ADP gi-2723 50 33 postgresql postgresql NOUN gi-2723 50 34 by by ADP gi-2723 50 35 osm2pgsql osm2pgsql ADP gi-2723 50 36 software software NOUN gi-2723 50 37 . . PUNCT gi-2723 51 1 before before SCONJ gi-2723 51 2 user user NOUN gi-2723 51 3 can can AUX gi-2723 51 4 use use VERB gi-2723 51 5 this this DET gi-2723 51 6 software software NOUN gi-2723 51 7 he he PRON gi-2723 51 8 must must AUX gi-2723 51 9 have have VERB gi-2723 51 10 spatial spatial ADJ gi-2723 51 11 enabled enable VERB gi-2723 51 12 database database NOUN gi-2723 51 13 and and CCONJ gi-2723 51 14 must must AUX gi-2723 51 15 have have VERB gi-2723 51 16 existing exist VERB gi-2723 51 17 mercator mercator NOUN gi-2723 51 18 projection projection NOUN gi-2723 51 19 ( ( PUNCT gi-2723 51 20 or or CCONJ gi-2723 51 21 ” " PUNCT gi-2723 51 22 google google PROPN gi-2723 51 23 projection projection NOUN gi-2723 51 24 ” " PUNCT gi-2723 51 25 ) ) PUNCT gi-2723 51 26 in in ADP gi-2723 51 27 /usr /usr NOUN gi-2723 51 28 / / SYM gi-2723 51 29 share share NOUN gi-2723 51 30 / / SYM gi-2723 51 31 proj proj NOUN gi-2723 51 32 / / SYM gi-2723 51 33 epsg epsg PROPN gi-2723 51 34 and and CCONJ gi-2723 51 35 spatial spatial ADJ gi-2723 51 36 ref ref NOUN gi-2723 51 37 sys sys NOUN gi-2723 51 38 table table NOUN gi-2723 51 39 . . PUNCT gi-2723 52 1 this this DET gi-2723 52 2 projection projection NOUN gi-2723 52 3 was be AUX gi-2723 52 4 added add VERB gi-2723 52 5 to to ADP gi-2723 52 6 recent recent ADJ gi-2723 52 7 version version NOUN gi-2723 52 8 of of ADP gi-2723 52 9 epsg epsg NOUN gi-2723 52 10 . . PUNCT gi-2723 53 1 creating create VERB gi-2723 53 2 spatial spatial ADJ gi-2723 53 3 enabled enable VERB gi-2723 53 4 database database NOUN gi-2723 53 5 : : PUNCT gi-2723 53 6 createdb createdb PROPN gi-2723 53 7 osm osm PROPN gi-2723 53 8 createlang createlang PROPN gi-2723 53 9 plpgsql plpgsql PROPN gi-2723 53 10 osm osm PROPN gi-2723 53 11 psql psql PROPN gi-2723 53 12 -f -f NUM gi-2723 53 13 /usr /usr NOUN gi-2723 53 14 / / SYM gi-2723 53 15 share share NOUN gi-2723 53 16 / / SYM gi-2723 53 17 postgresql-8.3 postgresql-8.3 ADJ gi-2723 53 18 - - PUNCT gi-2723 53 19 postgis postgis ADJ gi-2723 53 20 / / SYM gi-2723 53 21 lwpostgis.sql lwpostgis.sql NOUN gi-2723 53 22 osm osm NOUN gi-2723 53 23 psql psql PROPN gi-2723 53 24 -f -f NUM gi-2723 53 25 /usr /usr NOUN gi-2723 53 26 / / SYM gi-2723 53 27 share share NOUN gi-2723 53 28 / / SYM gi-2723 53 29 postgresql-8.3 postgresql-8.3 ADJ gi-2723 53 30 - - PUNCT gi-2723 53 31 postgis postgis ADJ gi-2723 53 32 / / SYM gi-2723 53 33 spatial_ref_sys.sql spatial_ref_sys.sql PROPN gi-2723 53 34 osm osm NOUN gi-2723 53 35 after after ADP gi-2723 53 36 this this DET gi-2723 53 37 log log NOUN gi-2723 53 38 into into ADP gi-2723 53 39 postgresql postgresql NOUN gi-2723 53 40 using use VERB gi-2723 53 41 osm osm NOUN gi-2723 53 42 database database NOUN gi-2723 53 43 and and CCONJ gi-2723 53 44 add add VERB gi-2723 53 45 ’ ' PUNCT gi-2723 53 46 google google PROPN gi-2723 53 47 projection projection NOUN gi-2723 53 48 ’ ' PUNCT gi-2723 53 49 into into ADP gi-2723 53 50 spatial spatial ADJ gi-2723 53 51 ref ref NOUN gi-2723 53 52 sys sys NOUN gi-2723 53 53 table table NOUN gi-2723 53 54 : : PUNCT gi-2723 53 55 psql psql NOUN gi-2723 53 56 -d -d PUNCT gi-2723 53 57 osm osm PROPN gi-2723 53 58 insert insert VERB gi-2723 53 59 into into ADP gi-2723 53 60 spatial_ref_sys spatial_ref_sys PROPN gi-2723 53 61 ( ( PUNCT gi-2723 53 62 srid srid ADJ gi-2723 53 63 , , PUNCT gi-2723 53 64 auth_name auth_name PROPN gi-2723 53 65 , , PUNCT gi-2723 53 66 auth_srid auth_srid PROPN gi-2723 53 67 , , PUNCT gi-2723 53 68 srtext srtext NOUN gi-2723 53 69 , , PUNCT gi-2723 53 70 proj4text proj4text ADJ gi-2723 53 71 ) ) PUNCT gi-2723 53 72 values value NOUN gi-2723 53 73 ( ( PUNCT gi-2723 53 74 900913 900913 NUM gi-2723 53 75 , , PUNCT gi-2723 53 76 ’ ' PUNCT gi-2723 53 77 spatialreference.org spatialreference.org X gi-2723 53 78 ’ ' PUNCT gi-2723 53 79 , , PUNCT gi-2723 53 80 900913 900913 NUM gi-2723 53 81 , , PUNCT gi-2723 53 82 ’ ' PUNCT gi-2723 53 83 projcs["unnamed",geogcs["unnamed projcs["unnamed",geogcs["unnamed ADJ gi-2723 53 84 ellipse",datum["unknown ellipse",datum["unknown PROPN gi-2723 53 85 " " PUNCT gi-2723 53 86 , , PUNCT gi-2723 53 87 spheroid["unnamed",6378137,0]],primem["greenwich",0 spheroid["unnamed",6378137,0]],primem["greenwich",0 PROPN gi-2723 53 88 ] ] X gi-2723 53 89 , , PUNCT gi-2723 53 90 unit["degree",0.0174532925199433]],projection["mercator_2sp unit["degree",0.0174532925199433]],projection["mercator_2sp ADJ gi-2723 53 91 " " PUNCT gi-2723 53 92 ] ] X gi-2723 53 93 , , PUNCT gi-2723 53 94 parameter["standard_parallel_1",0],parameter["central_meridian",0 parameter["standard_parallel_1",0],parameter["central_meridian",0 PROPN gi-2723 53 95 ] ] PUNCT gi-2723 53 96 , , PUNCT gi-2723 53 97 parameter["false_easting",0],parameter["false_northing",0 parameter["false_easting",0],parameter["false_northing",0 PROPN gi-2723 53 98 ] ] PUNCT gi-2723 53 99 , , PUNCT gi-2723 53 100 unit["meter",1 unit["meter",1 PROPN gi-2723 53 101 ] ] PUNCT gi-2723 53 102 , , PUNCT gi-2723 53 103 extension["proj4","+proj extension["proj4","+proj ADJ gi-2723 53 104 = = NOUN gi-2723 53 105 merc merc NOUN gi-2723 53 106 + + NOUN gi-2723 53 107 a=6378137 a=6378137 PROPN gi-2723 53 108 + + ADJ gi-2723 53 109 b=6378137 b=6378137 PROPN gi-2723 53 110 + + NOUN gi-2723 53 111 lat_ts=0.0 lat_ts=0.0 VERB gi-2723 53 112 + + ADJ gi-2723 53 113 lon_0=0.0 lon_0=0.0 NOUN gi-2723 53 114 + + ADJ gi-2723 53 115 x_0=0.0 x_0=0.0 VERB gi-2723 54 1 + + ADJ gi-2723 54 2 y_0=0 y_0=0 ADJ gi-2723 54 3 + + NOUN gi-2723 54 4 k=1.0 k=1.0 ADJ gi-2723 54 5 + + ADJ gi-2723 54 6 units unit NOUN gi-2723 54 7 = = NOUN gi-2723 54 8 m m VERB gi-2723 54 9 + + NOUN gi-2723 54 10 nadgrids=@null nadgrids=@null ADJ gi-2723 54 11 + + ADJ gi-2723 54 12 wktext wktext ADJ gi-2723 54 13 + + NOUN gi-2723 54 14 no_defs no_def NOUN gi-2723 54 15 " " PUNCT gi-2723 54 16 ] ] X gi-2723 54 17 ] ] X gi-2723 54 18 ’ ' PUNCT gi-2723 54 19 , , PUNCT gi-2723 54 20 ’ ' PUNCT gi-2723 54 21 + + ADJ gi-2723 54 22 proj proj NOUN gi-2723 54 23 = = NOUN gi-2723 54 24 merc merc NOUN gi-2723 54 25 + + PROPN gi-2723 54 26 a=6378137 a=6378137 PROPN gi-2723 54 27 + + ADJ gi-2723 54 28 b=6378137 b=6378137 PROPN gi-2723 54 29 + + NOUN gi-2723 54 30 lat_ts=0.0 lat_ts=0.0 VERB gi-2723 54 31 + + ADJ gi-2723 54 32 lon_0=0.0 lon_0=0.0 NOUN gi-2723 54 33 + + ADJ gi-2723 54 34 x_0=0.0 x_0=0.0 VERB gi-2723 54 35 + + ADJ gi-2723 54 36 y_0=0 y_0=0 ADJ gi-2723 54 37 + + NOUN gi-2723 54 38 k=1.0 k=1.0 ADJ gi-2723 54 39 + + ADJ gi-2723 54 40 units unit NOUN gi-2723 54 41 = = NOUN gi-2723 54 42 m m VERB gi-2723 54 43 + + NOUN gi-2723 54 44 nadgrids=@null nadgrids=@null ADJ gi-2723 54 45 + + ADJ gi-2723 54 46 wktext wktext ADJ gi-2723 54 47 + + NOUN gi-2723 54 48 no_defs no_def NOUN gi-2723 54 49 ’ ' PUNCT gi-2723 54 50 ) ) PUNCT gi-2723 55 1 ; ; PUNCT gi-2723 55 2 and and CCONJ gi-2723 55 3 last last ADJ gi-2723 55 4 step step NOUN gi-2723 55 5 before before ADP gi-2723 55 6 inserting insert VERB gi-2723 55 7 data datum NOUN gi-2723 55 8 into into ADP gi-2723 55 9 database database NOUN gi-2723 55 10 is be AUX gi-2723 55 11 to to PART gi-2723 55 12 create create VERB gi-2723 55 13 ’ ' PUNCT gi-2723 55 14 google google PROPN gi-2723 55 15 projection projection NOUN gi-2723 55 16 ’ ' PUNCT gi-2723 55 17 in in ADP gi-2723 55 18 /usr /usr NOUN gi-2723 55 19 / / SYM gi-2723 55 20 share share NOUN gi-2723 55 21 / / SYM gi-2723 55 22 proj proj NOUN gi-2723 55 23 / / SYM gi-2723 55 24 epsg epsg PROPN gi-2723 55 25 . . PUNCT gi-2723 56 1 add add VERB gi-2723 56 2 this this DET gi-2723 56 3 line line NOUN gi-2723 56 4 < < X gi-2723 56 5 900913 900913 NUM gi-2723 56 6 > > X gi-2723 57 1 + + NOUN gi-2723 57 2 proj proj NOUN gi-2723 57 3 = = ADJ gi-2723 57 4 merc merc NOUN gi-2723 57 5 + + PROPN gi-2723 57 6 a=6378137 a=6378137 PROPN gi-2723 57 7 + + ADJ gi-2723 57 8 b=6378137 b=6378137 PROPN gi-2723 57 9 + + NOUN gi-2723 57 10 lat_ts=0.0 lat_ts=0.0 VERB gi-2723 57 11 + + ADJ gi-2723 57 12 lon_0=0.0 lon_0=0.0 NOUN gi-2723 57 13 + + ADJ gi-2723 57 14 x_0=0.0 x_0=0.0 VERB gi-2723 57 15 + + ADJ gi-2723 57 16 y_0=0 y_0=0 ADJ gi-2723 57 17 + + NOUN gi-2723 57 18 k=1.0 k=1.0 ADJ gi-2723 57 19 + + ADJ gi-2723 57 20 units unit NOUN gi-2723 57 21 = = NOUN gi-2723 57 22 m m VERB gi-2723 57 23 + + NOUN gi-2723 57 24 nadgrids=@null nadgrids=@null NUM gi-2723 57 25 + + NOUN gi-2723 57 26 no_defs no_def NOUN gi-2723 57 27 for for ADP gi-2723 57 28 faster fast ADJ gi-2723 57 29 queries query NOUN gi-2723 57 30 it it PRON gi-2723 57 31 ’s ’s AUX gi-2723 57 32 recommended recommend VERB gi-2723 57 33 to to PART gi-2723 57 34 put put VERB gi-2723 57 35 projections projection NOUN gi-2723 57 36 which which PRON gi-2723 57 37 are be AUX gi-2723 57 38 used use VERB gi-2723 57 39 in in ADP gi-2723 57 40 the the DET gi-2723 57 41 beginning beginning NOUN gi-2723 57 42 of of ADP gi-2723 57 43 the the DET gi-2723 57 44 epsg epsg PROPN gi-2723 57 45 file file NOUN gi-2723 57 46 . . PUNCT gi-2723 58 1 it it PRON gi-2723 58 2 ’s ’ VERB gi-2723 58 3 possible possible ADJ gi-2723 58 4 to to PART gi-2723 58 5 start start VERB gi-2723 58 6 importing import VERB gi-2723 58 7 data datum NOUN gi-2723 58 8 into into ADP gi-2723 58 9 database database NOUN gi-2723 58 10 now now ADV gi-2723 58 11 . . PUNCT gi-2723 59 1 this this PRON gi-2723 59 2 is be AUX gi-2723 59 3 done do VERB gi-2723 59 4 with with ADP gi-2723 59 5 osm2pgsql osm2pgsql ADP gi-2723 59 6 application application NOUN gi-2723 59 7 which which PRON gi-2723 59 8 have have VERB gi-2723 59 9 some some DET gi-2723 59 10 parameters parameter NOUN gi-2723 59 11 . . PUNCT gi-2723 60 1 -d -d PRON gi-2723 60 2 will will AUX gi-2723 60 3 specify specify VERB gi-2723 60 4 database database NOUN gi-2723 60 5 , , PUNCT gi-2723 60 6 -p -p PRON gi-2723 60 7 – – PUNCT gi-2723 60 8 prefix prefix NOUN gi-2723 60 9 of of ADP gi-2723 60 10 created create VERB gi-2723 60 11 tables table NOUN gi-2723 60 12 , , PUNCT gi-2723 60 13 -c -c PUNCT gi-2723 60 14 define define NOUN gi-2723 60 15 amount amount NOUN gi-2723 60 16 of of ADP gi-2723 60 17 space space NOUN gi-2723 60 18 for for ADP gi-2723 60 19 caching cache VERB gi-2723 60 20 . . PUNCT gi-2723 61 1 if if SCONJ gi-2723 61 2 you you PRON gi-2723 61 3 run run VERB gi-2723 61 4 out out ADP gi-2723 61 5 of of ADP gi-2723 61 6 memory memory NOUN gi-2723 61 7 try try VERB gi-2723 61 8 turning turn VERB gi-2723 61 9 on on ADP gi-2723 61 10 -s -s PROPN gi-2723 61 11 osm2pgsl osm2pgsl NUM gi-2723 61 12 -d -d PUNCT gi-2723 61 13 osm osm PROPN gi-2723 61 14 -p -p PROPN gi-2723 61 15 osm osm PROPN gi-2723 61 16 -c -c SYM gi-2723 61 17 2048 2048 NUM gi-2723 61 18 < < X gi-2723 61 19 file_with_osm_data file_with_osm_data X gi-2723 61 20 > > X gi-2723 61 21 at at ADP gi-2723 61 22 [ [ X gi-2723 61 23 1 1 X gi-2723 61 24 ] ] PUNCT gi-2723 61 25 is be AUX gi-2723 61 26 written write VERB gi-2723 61 27 some some DET gi-2723 61 28 after after ADP gi-2723 61 29 - - PUNCT gi-2723 61 30 importing import VERB gi-2723 61 31 operations operation NOUN gi-2723 61 32 which which PRON gi-2723 61 33 makes make VERB gi-2723 61 34 better well ADJ gi-2723 61 35 output output NOUN gi-2723 61 36 from from ADP gi-2723 61 37 database database NOUN gi-2723 61 38 . . PUNCT gi-2723 62 1 speeding speed VERB gi-2723 62 2 up up ADP gi-2723 62 3 rendering rendering NOUN gi-2723 62 4 time time NOUN gi-2723 62 5 mapfiles mapfile NOUN gi-2723 62 6 from from ADP gi-2723 62 7 mapserver mapserver ADJ gi-2723 62 8 - - PUNCT gi-2723 62 9 utils util NOUN gi-2723 62 10 are be AUX gi-2723 62 11 nice nice ADJ gi-2723 63 1 but but CCONJ gi-2723 63 2 they they PRON gi-2723 63 3 are be AUX gi-2723 63 4 not not PART gi-2723 63 5 usable usable ADJ gi-2723 63 6 for for ADP gi-2723 63 7 big big ADJ gi-2723 63 8 amount amount NOUN gi-2723 63 9 of of ADP gi-2723 63 10 data datum NOUN gi-2723 63 11 like like ADP gi-2723 63 12 whole whole ADJ gi-2723 63 13 europe europe PROPN gi-2723 63 14 . . PUNCT gi-2723 64 1 if if SCONJ gi-2723 64 2 you you PRON gi-2723 64 3 do do AUX gi-2723 64 4 n’t not PART gi-2723 64 5 have have VERB gi-2723 64 6 some some DET gi-2723 64 7 very very ADV gi-2723 64 8 powerful powerful ADJ gi-2723 64 9 grid grid NOUN gi-2723 64 10 and and CCONJ gi-2723 64 11 want want VERB gi-2723 64 12 to to PART gi-2723 64 13 see see VERB gi-2723 64 14 map map NOUN gi-2723 64 15 before before SCONJ gi-2723 64 16 your your PRON gi-2723 64 17 coffee coffee NOUN gi-2723 64 18 get get VERB gi-2723 64 19 cold cold ADJ gi-2723 64 20 , , PUNCT gi-2723 64 21 you you PRON gi-2723 64 22 must must AUX gi-2723 64 23 do do VERB gi-2723 64 24 some some DET gi-2723 64 25 optimizations optimization NOUN gi-2723 64 26 for for ADP gi-2723 64 27 small small ADJ gi-2723 64 28 scales scale NOUN gi-2723 64 29 ( ( PUNCT gi-2723 64 30 from from ADP gi-2723 64 31 ∞ ∞ PROPN gi-2723 64 32 to to ADP gi-2723 64 33 1 1 NUM gi-2723 64 34 : : SYM gi-2723 64 35 500000 500000 NUM gi-2723 64 36 ) ) PUNCT gi-2723 64 37 . . PUNCT gi-2723 65 1 for for ADP gi-2723 65 2 example example NOUN gi-2723 65 3 osm osm NOUN gi-2723 65 4 line line NOUN gi-2723 65 5 table table NOUN gi-2723 65 6 has have VERB gi-2723 65 7 9.5 9.5 NUM gi-2723 65 8 m m NOUN gi-2723 65 9 records record NOUN gi-2723 65 10 and and CCONJ gi-2723 65 11 in in ADP gi-2723 65 12 scale scale NOUN gi-2723 65 13 1:5 1:5 NUM gi-2723 65 14 000 000 NUM gi-2723 65 15 000 000 NUM gi-2723 65 16 are be AUX gi-2723 65 17 shown show VERB gi-2723 65 18 these these DET gi-2723 65 19 layers layer NOUN gi-2723 65 20 : : PUNCT gi-2723 65 21 geinformatics geinformatic NOUN gi-2723 65 22 fce fce VERB gi-2723 65 23 ctu ctu NOUN gi-2723 65 24 2009 2009 NUM gi-2723 65 25 65 65 NUM gi-2723 65 26 vohnout vohnout ADP gi-2723 65 27 p. p. NOUN gi-2723 65 28 , , PUNCT gi-2723 65 29 čepický čepický PROPN gi-2723 65 30 j. j. PROPN gi-2723 65 31 : : PUNCT gi-2723 65 32 openstreetmap openstreetmap NOUN gi-2723 65 33 over over ADP gi-2723 65 34 wms wms PROPN gi-2723 65 35 coastline coastline PROPN gi-2723 65 36 , , PUNCT gi-2723 65 37 borders border NOUN gi-2723 65 38 , , PUNCT gi-2723 65 39 cities city NOUN gi-2723 65 40 with with ADP gi-2723 65 41 more more ADJ gi-2723 65 42 than than ADP gi-2723 65 43 100k 100k NUM gi-2723 65 44 citizens citizen NOUN gi-2723 65 45 and and CCONJ gi-2723 65 46 highways highway NOUN gi-2723 65 47 ( ( PUNCT gi-2723 65 48 motorways motorway NOUN gi-2723 65 49 ) ) PUNCT gi-2723 65 50 . . PUNCT gi-2723 66 1 if if SCONJ gi-2723 66 2 you you PRON gi-2723 66 3 are be AUX gi-2723 66 4 doing do VERB gi-2723 66 5 select select NOUN gi-2723 66 6 of of ADP gi-2723 66 7 highways highway NOUN gi-2723 66 8 from from ADP gi-2723 66 9 osm osm PROPN gi-2723 66 10 line line NOUN gi-2723 66 11 after after ADP gi-2723 66 12 using use VERB gi-2723 66 13 spatial spatial ADJ gi-2723 66 14 index index NOUN gi-2723 66 15 there there PRON gi-2723 66 16 are be VERB gi-2723 66 17 5.8 5.8 NUM gi-2723 66 18 m m NOUN gi-2723 66 19 of of ADP gi-2723 66 20 records record NOUN gi-2723 66 21 left leave VERB gi-2723 66 22 and and CCONJ gi-2723 66 23 after after ADP gi-2723 66 24 apply apply NOUN gi-2723 66 25 of of ADP gi-2723 66 26 where where SCONJ gi-2723 66 27 clause clause NOUN gi-2723 66 28 ( ( PUNCT gi-2723 66 29 highway=’motorway highway=’motorway NOUN gi-2723 66 30 ’ ' PUNCT gi-2723 66 31 ) ) PUNCT gi-2723 67 1 there there PRON gi-2723 67 2 are be VERB gi-2723 67 3 only only ADV gi-2723 67 4 50k 50k NUM gi-2723 67 5 of of ADP gi-2723 67 6 records record NOUN gi-2723 67 7 so so ADV gi-2723 67 8 biggest big ADJ gi-2723 67 9 optimization optimization NOUN gi-2723 67 10 for for ADP gi-2723 67 11 small small ADJ gi-2723 67 12 optimization optimization NOUN gi-2723 67 13 is be AUX gi-2723 67 14 to to PART gi-2723 67 15 do do AUX gi-2723 67 16 materialized materialize VERB gi-2723 67 17 view view NOUN gi-2723 67 18 . . PUNCT gi-2723 68 1 materialized materialize VERB gi-2723 68 2 views view NOUN gi-2723 68 3 are be AUX gi-2723 68 4 views view NOUN gi-2723 68 5 which which PRON gi-2723 68 6 are be AUX gi-2723 68 7 created create VERB gi-2723 68 8 physically physically ADV gi-2723 68 9 on on ADP gi-2723 68 10 disks disk NOUN gi-2723 68 11 and and CCONJ gi-2723 68 12 act act VERB gi-2723 68 13 like like ADP gi-2723 68 14 real real ADJ gi-2723 68 15 tables table NOUN gi-2723 68 16 . . PUNCT gi-2723 69 1 normal normal ADJ gi-2723 69 2 views view NOUN gi-2723 69 3 are be AUX gi-2723 69 4 only only ADV gi-2723 69 5 ” " PUNCT gi-2723 69 6 links link NOUN gi-2723 69 7 ” " PUNCT gi-2723 69 8 to to ADP gi-2723 69 9 tables table NOUN gi-2723 69 10 so so ADV gi-2723 69 11 if if SCONJ gi-2723 69 12 user user NOUN gi-2723 69 13 is be AUX gi-2723 69 14 doing do VERB gi-2723 69 15 some some DET gi-2723 69 16 queries query NOUN gi-2723 69 17 on on ADP gi-2723 69 18 normal normal ADJ gi-2723 69 19 views view NOUN gi-2723 69 20 than than SCONJ gi-2723 69 21 the the DET gi-2723 69 22 query query NOUN gi-2723 69 23 is be AUX gi-2723 69 24 done do VERB gi-2723 69 25 on on ADP gi-2723 69 26 all all DET gi-2723 69 27 data datum NOUN gi-2723 69 28 in in ADP gi-2723 69 29 those those DET gi-2723 69 30 tables table NOUN gi-2723 69 31 . . PUNCT gi-2723 70 1 example example NOUN gi-2723 70 2 will will AUX gi-2723 70 3 be be AUX gi-2723 70 4 done do VERB gi-2723 70 5 for for ADP gi-2723 70 6 motorways motorway NOUN gi-2723 70 7 : : PUNCT gi-2723 70 8 drop drop VERB gi-2723 70 9 table table NOUN gi-2723 70 10 if if SCONJ gi-2723 70 11 exists exist VERB gi-2723 70 12 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 13 ; ; PUNCT gi-2723 70 14 delete delete ADJ gi-2723 70 15 from from ADP gi-2723 70 16 geometry_columns geometry_columns PROPN gi-2723 70 17 where where SCONJ gi-2723 70 18 f_table_name=’osm_highway_motorways f_table_name=’osm_highway_motorway NOUN gi-2723 70 19 ’ ' PUNCT gi-2723 70 20 ; ; PUNCT gi-2723 70 21 create create VERB gi-2723 70 22 table table NOUN gi-2723 70 23 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 24 as as ADP gi-2723 70 25 select select ADJ gi-2723 70 26 way way NOUN gi-2723 70 27 , , PUNCT gi-2723 70 28 osm_id osm_id ADJ gi-2723 70 29 , , PUNCT gi-2723 70 30 highway highway NOUN gi-2723 70 31 , , PUNCT gi-2723 70 32 ref ref NOUN gi-2723 70 33 , , PUNCT gi-2723 70 34 name name NOUN gi-2723 70 35 , , PUNCT gi-2723 70 36 z_order z_order NOUN gi-2723 70 37 from from ADP gi-2723 70 38 osm_line osm_line DET gi-2723 70 39 where where SCONJ gi-2723 70 40 highway highway NOUN gi-2723 70 41 = = SYM gi-2723 70 42 ’ ' PUNCT gi-2723 70 43 motorway motorway NOUN gi-2723 70 44 ’ ' PUNCT gi-2723 70 45 order order NOUN gi-2723 70 46 by by ADP gi-2723 70 47 z_order z_order NUM gi-2723 70 48 ; ; PUNCT gi-2723 70 49 create create VERB gi-2723 70 50 index index NOUN gi-2723 70 51 osm_highway_motorways_index osm_highway_motorways_index PROPN gi-2723 70 52 on on ADP gi-2723 70 53 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 54 using use VERB gi-2723 70 55 gist gist NOUN gi-2723 70 56 ( ( PUNCT gi-2723 70 57 way way NOUN gi-2723 70 58 ) ) PUNCT gi-2723 70 59 ; ; PUNCT gi-2723 70 60 create create VERB gi-2723 70 61 index index NOUN gi-2723 70 62 osm_highway_motorways_pkey osm_highway_motorways_pkey NOUN gi-2723 70 63 on on ADP gi-2723 70 64 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 65 using use VERB gi-2723 70 66 btree btree NOUN gi-2723 70 67 ( ( PUNCT gi-2723 70 68 osm_id osm_id PROPN gi-2723 70 69 ) ) PUNCT gi-2723 70 70 ; ; PUNCT gi-2723 70 71 insert insert VERB gi-2723 70 72 into into ADP gi-2723 70 73 geometry_columns geometry_columns PROPN gi-2723 70 74 ( ( PUNCT gi-2723 70 75 f_table_catalog f_table_catalog ADJ gi-2723 70 76 , , PUNCT gi-2723 70 77 f_table_schema f_table_schema NOUN gi-2723 70 78 , , PUNCT gi-2723 70 79 f_table_name f_table_name NOUN gi-2723 70 80 , , PUNCT gi-2723 70 81 f_geometry_column f_geometry_column PROPN gi-2723 70 82 , , PUNCT gi-2723 70 83 coord_dimension coord_dimension NOUN gi-2723 70 84 , , PUNCT gi-2723 70 85 srid srid NOUN gi-2723 70 86 , , PUNCT gi-2723 70 87 " " PUNCT gi-2723 70 88 type type NOUN gi-2723 70 89 " " PUNCT gi-2723 70 90 ) ) PUNCT gi-2723 70 91 values value NOUN gi-2723 70 92 ( ( PUNCT gi-2723 70 93 ’ ' PUNCT gi-2723 70 94 ’ ' PUNCT gi-2723 70 95 , , PUNCT gi-2723 70 96 ’ ' PUNCT gi-2723 70 97 public public ADJ gi-2723 70 98 ’ ' PUNCT gi-2723 70 99 , , PUNCT gi-2723 70 100 ’ ' PUNCT gi-2723 70 101 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 102 ’ ' PUNCT gi-2723 70 103 , , PUNCT gi-2723 70 104 ’ ' PUNCT gi-2723 70 105 way way NOUN gi-2723 70 106 ’ ' PUNCT gi-2723 70 107 , , PUNCT gi-2723 70 108 2 2 NUM gi-2723 70 109 , , PUNCT gi-2723 70 110 900913 900913 NUM gi-2723 70 111 , , PUNCT gi-2723 70 112 ’ ' PUNCT gi-2723 70 113 linestring linestre VERB gi-2723 70 114 ’ ' PUNCT gi-2723 70 115 ) ) PUNCT gi-2723 70 116 ; ; PUNCT gi-2723 70 117 grant grant VERB gi-2723 70 118 select select NOUN gi-2723 70 119 on on ADP gi-2723 70 120 osm_highway_motorways osm_highway_motorway NOUN gi-2723 70 121 to to ADP gi-2723 70 122 " " PUNCT gi-2723 70 123 www www PROPN gi-2723 70 124 - - PUNCT gi-2723 70 125 data data NOUN gi-2723 70 126 " " PUNCT gi-2723 70 127 ; ; PUNCT gi-2723 70 128 first first ADJ gi-2723 70 129 two two NUM gi-2723 70 130 lines line NOUN gi-2723 70 131 are be AUX gi-2723 70 132 used use VERB gi-2723 70 133 for for ADP gi-2723 70 134 clearing clear VERB gi-2723 70 135 things thing NOUN gi-2723 70 136 done do VERB gi-2723 70 137 before before ADV gi-2723 70 138 . . PUNCT gi-2723 71 1 third third ADJ gi-2723 71 2 line line NOUN gi-2723 71 3 is be AUX gi-2723 71 4 creating create VERB gi-2723 71 5 materialized materialize VERB gi-2723 71 6 view view NOUN gi-2723 71 7 . . PUNCT gi-2723 72 1 4th 4th ADJ gi-2723 72 2 and and CCONJ gi-2723 72 3 5th 5th ADJ gi-2723 72 4 ( ( PUNCT gi-2723 72 5 if if SCONJ gi-2723 72 6 you you PRON gi-2723 72 7 are be AUX gi-2723 72 8 calculating calculate VERB gi-2723 72 9 only only ADV gi-2723 72 10 semi semi NOUN gi-2723 72 11 - - NOUN gi-2723 72 12 colons colon NOUN gi-2723 72 13 ) ) PUNCT gi-2723 72 14 line line NOUN gi-2723 72 15 are be AUX gi-2723 72 16 creating create VERB gi-2723 72 17 indexes index NOUN gi-2723 72 18 . . PUNCT gi-2723 73 1 indexes index NOUN gi-2723 73 2 are be AUX gi-2723 73 3 good good ADJ gi-2723 73 4 that that SCONJ gi-2723 73 5 it it PRON gi-2723 73 6 makes make VERB gi-2723 73 7 tree tree NOUN gi-2723 73 8 structure structure NOUN gi-2723 73 9 upon upon SCONJ gi-2723 73 10 data datum NOUN gi-2723 73 11 and and CCONJ gi-2723 73 12 this this PRON gi-2723 73 13 make make VERB gi-2723 73 14 searching search VERB gi-2723 73 15 through through ADP gi-2723 73 16 data datum NOUN gi-2723 73 17 faster fast ADV gi-2723 73 18 . . PUNCT gi-2723 74 1 user user NOUN gi-2723 74 2 has have VERB gi-2723 74 3 3 3 NUM gi-2723 74 4 possibilities possibility NOUN gi-2723 74 5 in in ADP gi-2723 74 6 postgis postgis NOUN gi-2723 74 7 with with ADP gi-2723 74 8 indexes index NOUN gi-2723 74 9 . . PUNCT gi-2723 75 1 b b X gi-2723 75 2 - - PUNCT gi-2723 75 3 tree tree NOUN gi-2723 75 4 , , PUNCT gi-2723 75 5 r r NOUN gi-2723 75 6 - - PUNCT gi-2723 75 7 tree tree NOUN gi-2723 75 8 and and CCONJ gi-2723 75 9 gist gist NOUN gi-2723 75 10 . . PUNCT gi-2723 76 1 b b X gi-2723 76 2 - - PUNCT gi-2723 76 3 tree tree NOUN gi-2723 76 4 is be AUX gi-2723 76 5 only only ADV gi-2723 76 6 for for ADP gi-2723 76 7 one one NUM gi-2723 76 8 dimension dimension NOUN gi-2723 76 9 data datum NOUN gi-2723 76 10 . . PUNCT gi-2723 77 1 r r X gi-2723 77 2 - - PUNCT gi-2723 77 3 tree tree NOUN gi-2723 77 4 is be AUX gi-2723 77 5 only only ADV gi-2723 77 6 for for ADP gi-2723 77 7 multidimensional multidimensional ADJ gi-2723 77 8 data datum NOUN gi-2723 77 9 . . PUNCT gi-2723 78 1 gist gist NOUN gi-2723 78 2 is be AUX gi-2723 78 3 combining combine VERB gi-2723 78 4 these these DET gi-2723 78 5 two two NUM gi-2723 78 6 indexes index NOUN gi-2723 78 7 in in ADP gi-2723 78 8 one one NUM gi-2723 78 9 . . PUNCT gi-2723 79 1 this this PRON gi-2723 79 2 is be AUX gi-2723 79 3 reason reason NOUN gi-2723 79 4 why why SCONJ gi-2723 79 5 this this DET gi-2723 79 6 index index NOUN gi-2723 79 7 is be AUX gi-2723 79 8 used use VERB gi-2723 79 9 in in ADP gi-2723 79 10 most most ADJ gi-2723 79 11 cases case NOUN gi-2723 79 12 . . PUNCT gi-2723 80 1 6th 6th ADJ gi-2723 80 2 line line NOUN gi-2723 80 3 inserts insert NOUN gi-2723 80 4 geometry geometry NOUN gi-2723 80 5 into into ADP gi-2723 80 6 geometry geometry NOUN gi-2723 80 7 columns column NOUN gi-2723 80 8 table table NOUN gi-2723 80 9 . . PUNCT gi-2723 81 1 insert insert PROPN gi-2723 81 2 geometries geometry NOUN gi-2723 81 3 into into ADP gi-2723 81 4 geometry geometry NOUN gi-2723 81 5 columns column NOUN gi-2723 81 6 table table NOUN gi-2723 81 7 is be AUX gi-2723 81 8 needed need VERB gi-2723 81 9 because because SCONJ gi-2723 81 10 some some DET gi-2723 81 11 gis gis NOUN gi-2723 81 12 clients client NOUN gi-2723 81 13 is be AUX gi-2723 81 14 looking look VERB gi-2723 81 15 for for ADP gi-2723 81 16 geometries geometry NOUN gi-2723 81 17 only only ADV gi-2723 81 18 into into ADP gi-2723 81 19 this this DET gi-2723 81 20 table table NOUN gi-2723 81 21 . . PUNCT gi-2723 82 1 last last ADJ gi-2723 82 2 line line NOUN gi-2723 82 3 grants grant VERB gi-2723 82 4 select select VERB gi-2723 82 5 privileges privilege NOUN gi-2723 82 6 to to ADP gi-2723 82 7 user user NOUN gi-2723 82 8 which which PRON gi-2723 82 9 is be AUX gi-2723 82 10 used use VERB gi-2723 82 11 in in ADP gi-2723 82 12 mapfile mapfile VERB gi-2723 82 13 to to ADP gi-2723 82 14 access access NOUN gi-2723 82 15 database database NOUN gi-2723 82 16 . . PUNCT gi-2723 83 1 next next ADJ gi-2723 83 2 possibility possibility NOUN gi-2723 83 3 of of ADP gi-2723 83 4 optimization optimization NOUN gi-2723 83 5 is be AUX gi-2723 83 6 to to PART gi-2723 83 7 use use VERB gi-2723 83 8 cluster cluster NOUN gi-2723 83 9 command command NOUN gi-2723 83 10 . . PUNCT gi-2723 84 1 this this DET gi-2723 84 2 command command NOUN gi-2723 84 3 will will AUX gi-2723 84 4 sort sort VERB gi-2723 84 5 data datum NOUN gi-2723 84 6 in in ADP gi-2723 84 7 table table NOUN gi-2723 84 8 by by ADP gi-2723 84 9 selected select VERB gi-2723 84 10 index index NOUN gi-2723 84 11 . . PUNCT gi-2723 85 1 this this PRON gi-2723 85 2 is be AUX gi-2723 85 3 very very ADV gi-2723 85 4 useful useful ADJ gi-2723 85 5 with with ADP gi-2723 85 6 use use NOUN gi-2723 85 7 of of ADP gi-2723 85 8 mapserver mapserver ADV gi-2723 85 9 because because SCONJ gi-2723 85 10 it it PRON gi-2723 85 11 is be AUX gi-2723 85 12 doing do VERB gi-2723 85 13 spatial spatial ADJ gi-2723 85 14 query query NOUN gi-2723 85 15 first first ADV gi-2723 85 16 . . PUNCT gi-2723 86 1 another another DET gi-2723 86 2 optimization optimization NOUN gi-2723 86 3 can can AUX gi-2723 86 4 be be AUX gi-2723 86 5 done do VERB gi-2723 86 6 on on ADP gi-2723 86 7 client client NOUN gi-2723 86 8 side side NOUN gi-2723 86 9 . . PUNCT gi-2723 87 1 openlayers openlayer NOUN gi-2723 87 2 allows allow VERB gi-2723 87 3 to to PART gi-2723 87 4 make make VERB gi-2723 87 5 tiles tile NOUN gi-2723 87 6 . . PUNCT gi-2723 88 1 this this PRON gi-2723 88 2 mean mean VERB gi-2723 88 3 that that SCONJ gi-2723 88 4 it it PRON gi-2723 88 5 cuts cut VERB gi-2723 88 6 map map VERB gi-2723 88 7 window window NOUN gi-2723 88 8 into into ADP gi-2723 88 9 small small ADJ gi-2723 88 10 parts part NOUN gi-2723 88 11 which which PRON gi-2723 88 12 are be AUX gi-2723 88 13 faster fast ADJ gi-2723 88 14 to to PART gi-2723 88 15 render render VERB gi-2723 88 16 . . PUNCT gi-2723 89 1 this this PRON gi-2723 89 2 can can AUX gi-2723 89 3 be be AUX gi-2723 89 4 set set VERB gi-2723 89 5 by by ADP gi-2723 89 6 singletile singletile ADJ gi-2723 89 7 : : PUNCT gi-2723 89 8 false false ADJ gi-2723 89 9 . . PUNCT gi-2723 90 1 this this DET gi-2723 90 2 parameter parameter NOUN gi-2723 90 3 will will AUX gi-2723 90 4 cut cut VERB gi-2723 90 5 whole whole ADJ gi-2723 90 6 map map NOUN gi-2723 90 7 area area NOUN gi-2723 90 8 into into ADP gi-2723 90 9 several several ADJ gi-2723 90 10 tiles tile NOUN gi-2723 90 11 ( ( PUNCT gi-2723 90 12 depends depend VERB gi-2723 90 13 on on ADP gi-2723 90 14 size size NOUN gi-2723 90 15 of of ADP gi-2723 90 16 tile tile NOUN gi-2723 90 17 ) ) PUNCT gi-2723 90 18 and and CCONJ gi-2723 90 19 makes make VERB gi-2723 90 20 query query NOUN gi-2723 90 21 for for ADP gi-2723 90 22 every every DET gi-2723 90 23 tile tile NOUN gi-2723 90 24 separately separately ADV gi-2723 90 25 . . PUNCT gi-2723 91 1 but but CCONJ gi-2723 91 2 be be AUX gi-2723 91 3 careful careful ADJ gi-2723 91 4 about about ADP gi-2723 91 5 partial partial ADJ gi-2723 91 6 labels label NOUN gi-2723 91 7 so so ADV gi-2723 91 8 setup setup NOUN gi-2723 91 9 gutter gutter NOUN gi-2723 91 10 in in ADP gi-2723 91 11 openlayers openlayer NOUN gi-2723 91 12 . . PUNCT gi-2723 92 1 gutter gutter NOUN gi-2723 92 2 will will AUX gi-2723 92 3 expand expand VERB gi-2723 92 4 tile tile NOUN gi-2723 92 5 for for ADP gi-2723 92 6 specified specified ADJ gi-2723 92 7 amount amount NOUN gi-2723 92 8 of of ADP gi-2723 92 9 pixels pixel NOUN gi-2723 92 10 and and CCONJ gi-2723 92 11 it it PRON gi-2723 92 12 will will AUX gi-2723 92 13 draw draw VERB gi-2723 92 14 labels label NOUN gi-2723 92 15 behind behind ADP gi-2723 92 16 borders border NOUN gi-2723 92 17 of of ADP gi-2723 92 18 tile tile NOUN gi-2723 92 19 . . PUNCT gi-2723 93 1 external external ADJ gi-2723 93 2 resources resource NOUN gi-2723 93 3 1 1 NUM gi-2723 93 4 . . PUNCT gi-2723 93 5 rendering render VERB gi-2723 93 6 openstreetmap openstreetmap ADJ gi-2723 93 7 data datum NOUN gi-2723 93 8 with with ADP gi-2723 93 9 mapserver mapserver ADJ gi-2723 93 10 , , PUNCT gi-2723 93 11 online online ADJ gi-2723 93 12 http://trac.osgeo.org/mapserver/wiki/renderingosmdata http://trac.osgeo.org/mapserver/wiki/renderingosmdata PROPN gi-2723 93 13 geinformatics geinformatic NOUN gi-2723 93 14 fce fce VERB gi-2723 93 15 ctu ctu NOUN gi-2723 93 16 2009 2009 NUM gi-2723 93 17 66 66 NUM gi-2723 93 18 http://trac.osgeo.org/mapserver/wiki/renderingosmdata http://trac.osgeo.org/mapserver/wiki/renderingosmdata PUNCT