Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | July 16, 2015

    Annie Liontas: IMG "You Want Me to Smell My Fingers?": Five Unforgettable Greek Idioms



    The word "idiom" originates in the Greek word ídios ("one's own") and means "special feature" or "special phrasing." Idioms are peculiar because,... Continue »
    1. $18.20 Sale Hardcover add to wish list

      Let Me Explain You

      Annie Liontas 9781476789088

    spacer
Qualifying orders ship free.
$50.25
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
25 Local Warehouse General- General
8 Remote Warehouse Computers Reference- General

More copies of this ISBN

PostGIS in Action

by

PostGIS in Action Cover

 

Synopses & Reviews

Publisher Comments:

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.

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

    PART 1 INTRODUCTION TO POSTGIS
  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. PART 2 PUTTING POSTGIS TO WORK
  11. Proximity analysis
  12. Geometry and geography processing
  13. Raster processing
  14. Building and using topologies
  15. Organizing spatial data
  16. Query performance tuning
  17. PART 3 USING POSTGIS WITH OTHER TOOLS
  18. Extending PostGIS with pgRouting and procedural languages
  19. Using PostGIS in web applications

Synopsis:

PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code, and provides a back-end for mapping, raster analysis, and routing applications with minimal effort.

PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools.

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

About the Author

Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.

Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.

Product Details

ISBN:
9781617291395
Author:
Obe, Regina O.
Publisher:
Manning Publications
Author:
Hsu, Leo S.
Author:
O., Regina
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping
Subject:
;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Subject:
ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector
Edition Description:
Second Edition
Publication Date:
20150531
Binding:
TRADE PAPER
Language:
English
Pages:
600
Dimensions:
9.25 x 7.38 in

Related Subjects

Computers and Internet » Computer Languages » Python
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » General
Computers and Internet » Internet » Web » Web Programming
Computers and Internet » Personal Computers » General

PostGIS in Action New Trade Paper
0 stars - 0 reviews
$50.25 In Stock
Product details 600 pages Manning Publications - English 9781617291395 Reviews:
"Synopsis" by ,

PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code, and provides a back-end for mapping, raster analysis, and routing applications with minimal effort.

PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools.

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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.