Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

PostGIS in Action, Second Edition
PostGIS in Action, Second Edition
PostGIS in Action, Second Edition
Ebook1,460 pages11 hours

PostGIS in Action, Second Edition

Rating: 4 out of 5 stars

4/5

()

Read preview

About this ebook

Summary

PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. This second edition covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1, 9.2, and 9.3 features, and shows you how to integrate with other GIS tools.

Foreword by Paul Ramsey.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the Book

Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort.

PostGIS in Action, Second Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools.

Familiarity with relational database and GIS concepts is helpful but not required.

What's Inside

  • An introduction to spatial databases
  • Geometry, geography, raster, and topology spatial types, functions, and queries
  • Applying PostGIS to real-world problems
  • Extending PostGIS to web and desktop applications
  • Updated for PostGIS 2.x and PostgreSQL 9.x


About the Authors

Regina Obe and Leo Hsu are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee.

Table of Contents

  1. What is a spatial database?
  2. Spatial data types
  3. Spatial reference system considerations
  4. Working with real data
  5. Using PostGIS on the desktop
  6. Geometry and geography functions
  7. Raster functions
  8. PostGIS TIGER geocoder
  9. Geometry relationships
  10. Proximity analysis
  11. Geometry and geography processing
  12. Raster processing
  13. Building and using topologies
  14. Organizing spatial data
  15. Query performance tuning
  16. Extending PostGIS with pgRouting and procedural languages
  17. Using PostGIS in web applications


PART 1 INTRODUCTION TO POSTGIS PART 2 PUTTING POSTGIS TO WORK PART 3 USING POSTGIS WITH OTHER TOOLS
LanguageEnglish
PublisherManning
Release dateApr 21, 2015
ISBN9781638353157
PostGIS in Action, Second Edition
Author

Leo S. Hsu

Leo Hsu is co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 25 years of professional experience developing and thinking about databases for organizations large and small. He also holds a lectureship at Tufts University, teaching SQL to graduate level students. He has coauthored several database books with his wife Regina Obe.

Related to PostGIS in Action, Second Edition

Related ebooks

Computers For You

View More

Related articles

Reviews for PostGIS in Action, Second Edition

Rating: 4 out of 5 stars
4/5

1 rating0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    PostGIS in Action, Second Edition - Leo S. Hsu

    |1abook_preview_excerpt.htmlrW-+/c(*YF AJ:cc@fL=?y9zu>`GKrߗȈLR}flØu;ŷo,wvoşWM&tU9InYUΓyoXok"/an%&仦ziy:֛:_,۸ ,2V*sUϳ:/Iu˼eV'iYɴI.ɒ??<<Z&YE6d7+F@w2++[mnuUս 3EiS2u6"II.uZ}=f40:wJb P/yx~%oY"_5$y_*͋o\o՟m<߭o_=KkrZ iIlm`=*$Buy7d*M[M{[ٽ`il5I:-U޶hf&q$+@>/e*J eV39)2 FRțl[WnrhaFa &B:6 U2 ֏Crs)C:l.4>eNh'k$Rj--FBӢ\ɧy!| /s"s,XZ̈́~-'5k'} FɱlM3p:mfA/t"_9ŧQ9uؖeQ72W7go/>z~gGXM[JnY?M%ϓ=s|.x$?lT1U~J.p]%].B } *k 䵁ܑكpA0l]Y=,V#C9*b?=:LV!ToxL׸zf-6/M&fmӵ= meBv*3V5SaUߑȡ^g?;L~l7mU][w0yU+6c8o+rŜ\[ӱlYUT|' w!$. lr8mb" VUsPBO/IrY]-#fѥ}=a7D2Oɩ|seX< |%:rgBj .Հ} =:C,=r}_ຯ)yoTGsAO˻lA0 = 8!?gI|Lv;bF6#M6'h r}HDݩ2*md˄W#MerC27Dp{LOy0w [m Gx[wHYjP-)׼\1I+7#>;͇XIMѽD/~Sٜ1 k4}FkP7rƶk 2lMuWoǾ.ySA /j*DŽlxgqE51]|YUt;!խm8uLIL76ƍ7z1|rDIQ6Wfxυanu2^\]6ߨa#&lK'zeXDzr)e"lJV zDjB{6N W:.EQM3yG ~& gX>v]R93] 444G STk4E$-Ο~(~TNq*T?iSQFz.0Y6OjVJ Of:"4zV.y3ޠo3D%9s#}.\t!e:S*%[p <<o>rWۧqn:ZՎ 1TKʻq%q8yUZ f/ȳwWal/ie$/ގh,QsUkЅS>!?=ƞai,߮vT1 Wݛz,uQ_u>KNYti}BwP˞64̶U0n-7iu33:ϔ)u5Hr8&ڍ6l 2+g:)?S%! !Yuh?S);;7ʍ϶9Ufxx:QG~G~X,Mix2{1Bzȃk`HIٰ?n~NVn >YQU&S~y6#6JuZu䍙kG?\{ ^z=h!OӛYbz24۱.҂2Oz Y<;\x"zo'coj]8gwkNm67>ӫblByNsC3sQ`!o"%n D;7YoA+ e6ḟ}ɺ.NGMFmhtBC˪RMU Lg97ua =$Zv)u0kG-WnĆ9B}Fۭz.agzn>rڌU_t[{z2~W8:mgoi!rn76l F4Þa1wʊO?Ec+lq|\E}hIu+J{}qfǺgvwb޿}=}/UQnÑܩ&L;(OB(C\`OMh"`=ruL)~T=u@PiZ{V'սRҰS C?kz;v;[=9(̊s^x"KTZ"+GW_.EQ d!48a|~{>YTiHs_bڴJ礷q(oL_e QXʷa@a'A-k>[]z+k5=V:V1|x|dypE N&B^$-jN:AC"^:>!pjll% -@Nٿ8̻QYyG3.C+4YV Cf >/K4μWfG^= g1OI؛'&]>f6| qR&Ǽ:'J. .S]k5Sd~D}Ma9TV_{trv^?/`jyDJMu><OۄԾ}uj*do~r 0[R_Yo '3AG9d_)?ӿY_1z2~̊dT4dGgW7ޞL޽98V>mUde^€mMjĞƴ<ٱ*S՗>^u_oK#MWz?STtg3틡R 0I$~t`g('}&aGPGGAq< g~?[5UYT[!sD,6v4j8җ9 lMaw[GάYgcqID(ddU҈&U8(P7Xݖ#C|@M_eĆ<pj&f;ő}^9>2hXcu`x }iػ5J69Fzivy3TVYyK)HNQD02/@֋HQaSDމҘ|<0B@O)PayfA)|<<G ApՏog=T>92HmjJ8h==9O\縝i1apDςy)V=:E-5ʄF˛"L #k~~;Zlu@njm|<($-ٴ9{/+u28oD" ,.8G(l}\-rii(,zϑdd=hvOy<$gccAu$:}NO)ԚO[- TaRl⑌ƫiUQ)%q &yVr;lr l ƲWd/&N{oTzQ爎mOgGT;;/3X&)iATvu?/|4F r82x酇z)GANEpv]VYIR}Fkp]f-&= ()Ry.J1װ_l;׋ӹpD5`cKR <#p"yci4XP[卸x94mk幹=-}-Y7ra@ё<5(T'36 +}ሰJ '_n`LEW og*$778!0dTGQ1ѣ|a?1 G؛tUnAmxH}A|oc(|1Xz5H3&|x{1,AoF&|09McThze2tƛ'DA+]F X?a^KUB&7F͢=e;]x $E+*š>pg%ocKȹ$R~.mzbӨ.y,X[#m{hLv8: &v7l|LzsDP"5_2Pr-,[e(KFV@j#7USK˒l,w(/IfѤmpoH!߽>-hGΑo|P3u;+1-b}ҠN~M6'?_ߐ~~uw%f`Do"ϧ" 8@)uJ6:giAY'XA'!!#덾H".:a;8=ݍ@Zo%ȂW#+6bEł-meh3E߷a@bذ:#Y֟LKDrpb]<9"E,D >UuX$/hrrVtlGة.sLiX2Ճ;-CABhcΊ puq>ᣧqGŅ]@7O֋}=5rGWFƝB õr[F ooEeE̳L>e&\meYEGC!mPAO:[એ W)~%;$q | 6~>48-omkp$sagyy8x<7YS$ysusJ}I޴aJ (6!(\Sm *gUfvfL]^bYw\9v8rInNΝr!H]>?EAJMIH0{;L.r.Ilrv,#6Ky[֮FD9 PQQa=F@]Jt%4*-9^gՠ ;,[k+^k4W@O 3}}Z6$G#Ba&L(d0WniM6w'AE͘5L2?8\&>?]ÿ(fa(,%uz?0'--a /.ybٓzs'+Y8mu$q/( G]. @r1(+2bͥ{N6Fs"{x Ѯ%j^[lݜ7HOF[f`8yܶL3ұc>D\b-:c-49ꫣKΔ^%(6Udg4'% H}?-3ӒȦ^Pud?9e9}f̑鉳M]MSsK+CW_eR9^e"\@9(<̽F[6rZO7:uMb0;R̳!_ dTG[&~vBGR<`|E`QfY`MDHkT9p\X,ܷ a _DE,>~YLUHXja%ofz˜8ɴ'\i++TU'FGrn( mb~ N5:$"(6Kl"/¥//3Τ_-vılմ* 뙨k0ZJI47.ISaL'@boIbÎQ~&ᡐ whYf+!Mj7LڝMeV9E [#Hyr$PԄ ]KH`WxAoSYA:t@GM|bpۆF~8"uHx{%2KV ~^P Nº&he2GB[ٕkwٚ944U+qiID{h8B$5dA[P)R/%҄Bc۵܉q0ٶ'KT 4ΈneUpm e #{X-zf 9'`mɌ@t!ne=Z40oP|[h̠z^&DWT7"=ax>(F8mpw( #um}3}515E9RAdylZ=s^NlUVf|nkt>^fܨU9'sYE|"Cw][d},ԿF;x0=~J ,hʨRo7w?wzAX}Wo_'ﮯ>_"mnnZUGk o_x1#΂\݈"Zy׽(,%yEm4{z0h5gCvWZq ڼ2gTVzHZuo]]'gKxF-`8+@?Ҋ2lp@O?a6)_[9.K䬯R}M &{}^xr}+T"Oa7U' 935-=#(m-UVFu;1jH7Ṡe;}{sI>;Fs., mVf 2\ c qbC|Mgܐzun'˃)bE ̬{XJTzs@+ҩ\Q-x3 !n,[Ձ "7']S#,,sRxE]>ZV3*gEaA V̥͉;=e:Y^ʚϫ,P2huojnRSEW4(^aE:#"yqfւJrS,HЯ6dTΉ쳪4,2~-yr;h['=yVӞ?^R,_SeVi~g#'JZ35BT9[fr8.͟9Nw=* {_9BXݪg}|7{H!UO #ՂtenLkU5 8+Y Q?/ f܄H?թ)i #.䠀C(pK26mf$4k۫Ь S]fUͳ ۑ8TsbgXjVEZ\i2U1/:zRZgɨmw{"JhRوtHy]U;?g杯 R͵ v,ͻ?2=CNrl4(< K /^{6ǯfKMPǁ)2|y-:3C\Q#~@Qk3 Ch_$g2YٺrNS. cN쮐) y NEn* l:fD1`:߄/T1%IwV6TCݡf u{kFMA`pW+9&V<^d:zID> E,0Ɨ^J5XwH|`US%~ X\r/wBFI)."7`ey%FC|q\5$>o Ú8S-T(:]Ms<|Q \ $NG< ("v[[d.)*w*Ԛwi?!=fqH|I+E'ɫ 5fC_w .~X]k#XXT> J>H[25aVY-;C—zH~~ =%:Y&ߤu먚?F.)|[8rīH%3u%':ޠ)h5}W|||xDT,HԞ'*.j=T׭M a|~2ԕILT&j}@OP~D ZZ0_(m<Ր^jH–o1p_1i`*aSh61f~j1f/G"_i7Q,VV ~f1/\;J)MC*4=^,СF%IVԮ5ʓ>#)y7>sV6.;=7kc~F6yeLo%H 874%ɷ?/v͓'.@^2;A/Uy0Ӳnt%Cd]-\Q=3[~,5\"BE >&q ZlUp ! ddP@m%k: ]BL1 ӄ{5=me3HݪhQk .Mu9e)ً4A1];6=&Ɏ |YۭuH4)<_lrIf=O rog~?Mʍf9g 7Y{xSOۋ+M=bbˋAسrf;ڭ:݄A O+*e.'Q84sTUdD T993NM?d(jW]ꨕEKYY {\6u!dY-mV¬LHgz`N$2q js۸ʪD,=t{郗FN G$!޴z$iAݣk4ETk`{uĜא< 50]-)ɰ}`А`I-RXo::ph/VY/')Q'M jlWAT)*&y~MӏvobiV59x _<, IaRyay׊w:L5D]=i9l30}!@C7c#Y'73KIJ(l\D"5r셆r5F!g#;#OW"`e5<8vFl:Ml`>!`w8+DD5G^HY$+ |.P0ݸ rqj=o[8L: DM@BזT)n=Q rp[PH_kȣ:`p+ũo`NHe͢LSo+ˏ"_^Ge0q/+*SJlN6ln8頢yߛ."9y/eo}؆YL[&+jDmmu0L?7?$rXy8Zow_qD); Z UdkԨC,>P/|LSu3A3YIi2\a)9>CGqB<Ű6tA +,@}:Ż8ݡjBv+B]lL**E"MV:OY!tD[bbS3׸G)c J틌 =p!;L7 *f*nȤEXEL(4Q: "mlKFf嚗ᐐ(E=R/2 Jc/Rv YB )Vr-U"դ`:dse/,[,W[&MMa@cE!n"u2Ҍ=A4MYK:F,-kU%cFYu6$(]bK#?.C#}2ĩ+'Uv5J*(U7Uv/:Bc2>ͻY3d7I]h -[:E*h*TnԿEwEXe>RNK\սojqgKe@sG䗋b\O?_  {4Ʋ#W,U?VqtJ;{ .YP؂aL3F3(9kFL̮x qаt"vX a@5qZ=3`X=g%2szSЭi_I.9+ABzq0>cKII oݚU"ֿ}`'|X m}*:3-m']T@3?ʇ1'l?TEo+ܕ=գ -ub_CqҌ̫Z K3};+s(.m!L:4E4.B??LhIM/ y3&o<&%l+F;-Iռܞgj¨Sf uGE&D R_vEw,wFgeF_̲P% ӆ2,&xDbBh@(Ey 早9u\<sn=P*HGՕ#իf6TOT+);YlV@O<$iE:]TZMK5=[o=rq4C݅lƌ{iGwkβ]:|Tt.54l);| 8 s)Th2 ϳ j5zș 1 uw2}LDrVHUCبM̩Z*x`]X,guzۚФj!AM@ie4 v*gQ -Dd~> 1%OFR퓵+ ~|6 S󨹔*DS& P躡Hz4JtzCB#K0J | G,L0wtB`NoPRFќqp1eVIu9-|04tuzin9&S /J9m  {ZMGY,&}풽(xcY%ڶ+kdr8f7+3<>zwlx,0PE es#hm妙]Mɖ,i"dZyܙ{ pIY)V鯕^T|y6'(K$~n,pSk-)F'}hUsUzZTiixhpad^/ٳB`ࢗL.+lMAQɶ 9tKW/ $pH2c0>+H\Zucу}[`L#o/g> dmZrkC-lj"|" 0\Rcm$r"Iޛ/ʳAa8"$Ta:P~61XE)3\Bwk/wG~[ Ә+ W}>,3gR`:,`;$-cՃԽ hHof@(IܨCy$KlԳ}{**ZZ\bߐ~$q5;P.jQ{jLc4yw39/(y6"e]5Kk܅KnȽIv{vVE4$P6  )L^{/?ܰz>v5Qm/245߃ÇܵD,ƪ3V\ 'n@r]âa^'sJjUy!C1U󝂪 R@ z2;Nn0/5+,gz٘3!3Tb(>jؿzP[ [B3hT婰Z,M8TV-OMUl36oF|kp4SQ5{0^'\05{(+Sb֓/J4 gUީN=:PLy1(-%0?NGrq]RG$4RZ^sj Umqeltk@-3[yʹj'rЯ3a%"XH +BOS4 Aw܈IގCPgLf'Pw1?{]C*r>CYo60f`#ͮD4t.a]'l̂U G$hoEM.K$j\3B MW+x籯7,HJ 'r@rܡowF/i`㬽LMQ99uckNߟg_՚L'0E1t.LDoIJvG~o:S $Q^hCVcw =>#ƘGշv%t!^BXkHOEB)&t᫽qLE(΢W+srYO%mo~%Ciqm~WirZ9BmPw]t-$qn-&Vdp0F!Jڴ!x8+-={*[1'\h|=ϭ(!ߘnw *L_ OpżDڹ\WO&AY*4C1@eEPaW'ٕ[]wc[)UNUf3 ZX! ^^%C&bZEE;ECSpQ7HfѯZG/bdQTϩqׄUE $B%|x(" !M΢3_H\}]!N2txk1ᕭ&4]‰{ރ#ֵ֧yE`ʃy.j-uY^;9gd_g \i:&OK/Jҵ~!U([?Q٦zNMKo@jgM>@ F0{NFo:=;H,EH6+Ѩh."JxzS@.C?bg [5*b6Y5! 1U|4 r$Zp/4Yc.W!CP1.o Pf}7yOaeNvi'Φ+X fK @R%j@޽A틀y{9jԞEwGYHƦJZ~~,Bkad. m/},?on<) fkF#^M6r$&V;ΖOn'񤲇=ǥa-)]ZOVVN-2۟\&Bޙ:zeX4oǞ:%&ql-a_" /w-ȋ,(-U۵~B3|٬j3]kEv_XsWx(^(=̭-osU\X'ۢr ^+M}ja"4(O4!<&2YBdMT]>05_ZG \͜WBFF<[+D]P#a enJV悁Bϼ+O-D[((w2Qy=`j""; MgUx.X-]ٚ*]XS#$ s:n*tL3DQ1#GG$ɭ Lc Xd8}dO)DB.gS( eOUGV ͒.]%H!ũ&{2rpojٔrE)ݡBf-RJK@+4ɌԙFmE5̋AڥJ!.CIrwc'/FɬvW n>gYj>zV~[14g5j;s?vȔamB׊JzMM΁D{M Q$h&(=pXĤC[)d-QM4ك^gH Y>'wXUCе*@|D8x(kL E (39%F"훦f:̱Kǧ.0Eqe@% $4n!uĊ򦌲 HU-fYg0VͻsX5OZ/ UBuŠ[˸)Uþ%=ui!gr>U>Ww& ~`#LLʖXc/ly @FeZ|3AwN'=ͬCmFj:C!2{n ~[TǤuxs7[F#k-²Mz&8;#]H!5-ˁpp911`e3-Bdʍu=BљKJ1_<vЭx?r,UMerˊJ}X؍ߦi+~_ŢbX"FnG5ZAD׼2`~-.V~dn_K;|G %_u5 4(ѫ y2X9镃<6eRVOJ*Ԑ\.{QY* _NVwDVL6Aa0ºpky\0JFd(bݻYy pڃ|JYt{:mL0,Mi5H 5Ց>e3pf*))]^@IY\[:YCDRWU&G?R8B;j&&Yxєp9C]] X Ҩ4^C^BjuUdLf<(80IV'1hiKTm*@nXIs8R6Y %1sh>j%9gLTxar!ޯNϱssG&3 zӂD,{jݫ|,39rf8o,:!Bb:v1}]>>DOh,Vjj"8 Ŋ'!=pFn{6$k7k'+{+;/wT(H.Og]/ +/)l|)y^dHѵS)tuW>3FsCmb8 }QV3P?L^]%Tq :ihyO51Kv^k4A@JJ,oOo' cfA(] /橸J(Jht2D)kd"wQjE4JU : G #P+bO)#x ! >Y?)9O߯\x4#M_âyw~Rn5< [S0Z^!xt@aWe#1.Ekx|:eMHiqTnr^Vv<)M>#kg?I_"R(3{6пu}%KyțSRۀW 4ps_\⤝F9O2q;X,7XE(GmLUY!lѴhlx?h0y)'C,{#ϥf/v0$?n/AދS$s0q$K{(|ELMB JKibf -m퐿ʽF &TFk) DBdܚTowE4L᏶>+s|6- Zw+8`1kԹd^חnO0PQl| 0iھ$oxϴ(L5 #8g#X? .a>}Fsi'Ə"/bAHn[m<6ofuVS9[E.^LuXW!w7^$Qz>m;d+s]_}m p;eKBnJ"ҋSnyGŇ{GFZ2HK5KԫNS;x1 3+nUn0$6u>v$ Nic-A3m FHł,|/opaeHO!t^?F\=kB cܬO^5\=klS C)Aּ6?doUQGVT!z!LeBy֙Jctwf C Rr`NE)+TڽYLn[MjiOmM+yQ(Ԯ0݅,tRN**z\pyceSinLͶd~cc{X3DmV!Hw+] !eQkB>FF]"\ m>?LΪeR:=eFlֱ*39u°(gLΗ_>ZPK"j=WT䭻7*Dxzbmsx ^=iMxu1EBDODS?j}-:)CaZDe֔r"]z0T\wY/'o::rlvcwWT`V ax~hwI(͕^X_vExV? SCqd;1 abɑb&DO=vxiۡJ`{Ihz usL)!\MwrKV5I:jLiJ{AOxxO_{@<;Jѫ8<S x` HMۑe^Qfǿ4̇j~L!Ts@7T f* R/Gޫn(72Z;O<,e|5$-rS}Tq3֓+(srֲ{KD8¿_>'/ٶV Tn9a Eъ5L ;d퀦YsYXo׌a9Esh7^묭qR7LM L5_CkM@o*0@띅Fǯ=b ecqyVu*ؘ+XŎM m^.u6dN~1({A{rrug!=곸$&8 9ڭ^S2WsrS+ܾD0"3;S}Yt`ûIq?u+{[q{^սG)W?Z%p7e7* 65|_u"vݍ5fw!coHSD2N/(>ѫUb|~(/ҴȆD {5/e&dްYk4F_̰tP#1Ppb+l5*[33d.o87q\=ÕuDј T)韢xY_<ϒ{++;SS=WWq>ּU`HZEfHlbS7bIrjL[-b:T"x9XGƯ(h~vftYQuvnn {s РBXϜ[/ϣ w|oW~JUˌ /*r{K]_8̺I6n2G5,+gai]|Rԋk `{o& J#I̵zz6V!AeN8,|5C̏&Nk5uO$>4}A0zU7 .к@=# 1nWo6޻zC-!M]$Zh܏YVeE{BrQMRe@49Odi-Z(l#?*AK>G.
    Enjoying the preview?
    Page 1 of 1