{"product_id":"postgis-in-action-second-edition-regina-o-obe-9781617291395","title":"Postgis in Action, Second Edition","description":"\u003cb\u003eSummary\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003ci\u003ePostGIS in Action, Second Edition\u003c\/i\u003e 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. \u003cp\u003e\u003c\/p\u003e Foreword by Paul Ramsey. \u003cp\u003e\u003c\/p\u003e Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the Book\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e 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. \u003cp\u003e\u003c\/p\u003e \u003ci\u003ePostGIS in Action, Second Edition\u003c\/i\u003e 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. \u003cp\u003e\u003c\/p\u003e Familiarity with relational database and GIS concepts is helpful but not required. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eWhat's Inside\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAn introduction to spatial databases\u003c\/li\u003e \u003cli\u003eGeometry, geography, raster, and topology spatial types, functions, and queries\u003c\/li\u003e \u003cli\u003eApplying PostGIS to real-world problems\u003c\/li\u003e \u003cli\u003eExtending PostGIS to web and desktop applications\u003c\/li\u003e \u003cli\u003eUpdated for PostGIS 2.x and PostgreSQL 9.x\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the Authors\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003cb\u003eRegina Obe\u003c\/b\u003e and \u003cb\u003eLeo Hsu\u003c\/b\u003e are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eTable of Contents\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003col\u003e \u003cli\u003eWhat is a spatial database?\u003c\/li\u003e \u003cli\u003eSpatial data types\u003c\/li\u003e \u003cli\u003eSpatial reference system considerations\u003c\/li\u003e \u003cli\u003eWorking with real data\u003c\/li\u003e \u003cli\u003eUsing PostGIS on the desktop\u003c\/li\u003e \u003cli\u003eGeometry and geography functions\u003c\/li\u003e \u003cli\u003eRaster functions\u003c\/li\u003e \u003cli\u003ePostGIS TIGER geocoder\u003c\/li\u003e \u003cli\u003eGeometry relationships\u003c\/li\u003e \u003cli\u003eProximity analysis\u003c\/li\u003e \u003cli\u003eGeometry and geography processing\u003c\/li\u003e \u003cli\u003eRaster processing\u003c\/li\u003e \u003cli\u003eBuilding and using topologies\u003c\/li\u003e \u003cli\u003eOrganizing spatial data\u003c\/li\u003e \u003cli\u003eQuery performance tuning\u003c\/li\u003e \u003cli\u003eExtending PostGIS with pgRouting and procedural languages\u003c\/li\u003e \u003cli\u003eUsing PostGIS in web applications\u003c\/li\u003e \u003c\/ol\u003e \u003cp\u003e\u003c\/p\u003e PART 1 INTRODUCTION TO POSTGIS PART 2 PUTTING POSTGIS TO WORK PART 3 USING POSTGIS WITH OTHER TOOLS\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Regina O. Obe,Leo S. Hsu\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1617291390\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781617291395\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Manning Publications\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 05\/03\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 600\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.20lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.20h x 7.30w x 1.20d","brand":"Regina O. Obe","offers":[{"title":"Paperback","offer_id":48088654610687,"sku":"9781617291395","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_4926ea87-6981-46a1-8900-7adcb2ca9d64.jpg?v=1769105936","url":"https:\/\/www.whiterainbookhouse.com\/products\/postgis-in-action-second-edition-regina-o-obe-9781617291395","provider":"WR Book House","version":"1.0","type":"link"}