postgis.us
Open in
urlscan Pro
50.78.240.109
Public Scan
URL:
http://postgis.us/
Submission: On April 22 via api from GB — Scanned from US
Submission: On April 22 via api from GB — Scanned from US
Form analysis 2 forms found in the DOM
<form>
<select name="lang" id="lang" style="font-family:Arial;font-size:11px;" onchange="javascript:PostTranslate(this);">
<option value="">Select Language</option>
<option value="">English Version to Apply</option>
<option value="en|zh-TW">Chinese</option>
<option value="en|fr">French</option>
<option value="en|it">Italian</option>
<option value="en|ja">Japanese</option>
<option value="en|ko">Korean</option>
<option value="en|es">Spanish</option>
<option value="en|sv">Swedish</option>
<option value="en|vi">Vietnamese</option>
</select>
</form>Name: aspnetForm — POST ./
<form name="aspnetForm" method="post" action="./" id="aspnetForm">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMTg5NzEwMzU2MQ9kFgJmD2QWAmYPZBYCAgQPFgIeBFRleHQFF3Bvc3RnaXMudXMvRGVmYXVsdC5hc3B4ZGS6NyzRPjt+kp9QJAdZzAAjdZ9dsmkny4NlbxjUmpGWUA==">
</div>
<div>
<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="CA0B0334">
</div><br><br>
<h2><a href="https://www.manning.com/obe3/?a_aid=PostGISInAction&a_bid=5e00124f">PostGIS in Action 1st, 2nd and 3rd Edition Books</a></h2>
<p>PostGIS is a spatial database extender for the PostgreSQL Open Source Object-Relational database management system. PostGIS follows the
<a href="http://postgis.net/docs/manual-dev/using_postgis_dbmanagement.html#RefObject" target="_blank">OGC/SQL-MM standards</a>.</p>
<div itemscope="" itemtype="http://schema.org/Book">
<p>A lot in PostGIS has changed since we wrote the Second Edition of PostGIS In Action.
<a href="http://www.manning.com/obe3/?a_aid=PostGISInAction&a_bid=5e00124f" target="_blank"><span itemprop="name">PostGIS in Action</span>,<span itemprop="bookEdition">3rd Edition</span></a> is a significant update to the second edition
that covers new features in 2.5, 3.0, 3.1, and 3.2 as well as newer PostgreSQL 11-13 enhancements. In addition PostgreSQL has changed as well and has added many new speed improvements, new datatypes (jsonb), and newer constructs (introduction
of partitioned tables). We cover some of these in performance tuning, PL languages and the Appendixes. <a href="http://www.manning.com/obe3/?a_aid=PostGISInAction&a_bid=5e00124f" target="_blank">PostGIS in Action,3rd Edition</a> provides a
guided tour of these new enhancements and things to watch out for when migrating from PostGIS 2.x to 3.x. For new users, you'll get a good primer on basic functionality of PostGIS as well as a growth path to take advantage of its more unique
and gourmet features. Special focus on PostGIS 3 series and PostgreSQL 12+. </p>
<div itemprop="about">
<p>We introduce you to both PostGIS as well as PostgreSQL, the powerful DBMS that PostGIS spatially extends. You will learn:</p>
<ul>
<li>The basics of Geographic Infomation Systems (GIS), spatial data processing,and how these extend the kinds of questions you can answer with a relational database</li>
<li>How to load both vector and raster data into the database and working with topology.</li>
<li>Using Foreign Data Wrappers to query data external to the database, including spatial ones.</li>
<li>How spatial reference systems play a role in GIS</li>
<li>The power of Spatial SQL to simplify and expand the possibilities of location aware applications, statistical analysis based on location, and raster analysis.</li>
<li>How PostGIS/PostgreSQL fits into the standard body of GIS and relational databases. </li>
<li>What workflows PostGIS is good for and how to perform them efficiently</li>
<li>How to view PostGIS data in desktop applications</li>
<li>How to integrate PostGIS in your web applications</li>
</ul> The appendices cover topics germane to PostGIS and PostgreSQL: <ul>
<li>Helpful resources for learning more about PostgreSQL, GIS, Free tools and Commerical tools that work with PostGIS</li>
<li>Getting free GIS data</li>
<li>Getting up and running with PostgreSQL and PostGIS</li>
<li>The fundamentals of Structured Query Lanuage (SQL)</li>
<li>PostgreSQL unique features, backup and restore, and security management</li>
</ul>
</div>
<p>This website is a companion to the <em>PostGIS in Action</em> books. We provide PostGIS and PostgreSQL resources, code downloads, data downloads used in the book as well as providing chapter summaries of what is covered in each chapter. On the
<a href="/chapters">chapter listing page</a> you will see a paper clip to download code and data for that chapter. You will also see the download link on each chapter page.</p>
<p>
</p>
<p>Note the E-Book version is half the price of the hard-copy and Manning will reimburse you the price you paid for E-Book if you choose to later buy the hard-copy. </p>
<div id="ctl00_divBookAds">
<div id="ctl00_bgCampaigns_manningdeals" class="screen_only" style="border-width:1px;background-color:#fffef0;color:black"> Save <b>50%</b> off on
<a href="https://www.manning.com/books/postgis-in-action-third-edition?utm_source=PostGISInAction&utm_medium=affiliate&utm_campaign=mlobe3&a_aid=PostGISInAction&a_bid=ddcb237c" target="_blank">Third Edition of PostGIS In Action</a>
enter <b>mlobe3</b> in the Promotional Code box when you check out. Offer ends November 25th, 2021</div>
<div id="ctl00_bgCampaigns_upcomingbook" class="screen_only" style="background-color:yellow">
<!-- START AMAZON ADS -->
<script type="text/javascript">
amzn_assoc_placement = "adunit0";
amzn_assoc_tracking_id = "postgisus-20";
amzn_assoc_ad_mode = "manual";
amzn_assoc_ad_type = "smart";
amzn_assoc_marketplace = "amazon";
amzn_assoc_region = "US";
amzn_assoc_title = "Our Books";
amzn_assoc_linkid = "e3617a9a8ede9183f4ff66df23c061aa";
amzn_assoc_asins = "0989421732,1617291390,1491963417,1449373194";
amzn_assoc_size = "600x200";
amzn_assoc_search_bar = "false";
</script>
<script src="//z-na.amazon-adsystem.com/widgets/onejs?MarketPlace=US"></script>
<div id="amzn_assoc_ad_div_adunit0_0">
<style type="text/css">
div#amzn-native-ad-0 {
max-width: 1021px;
font-family: "Arial";
font-size: 13px;
color: #111;
position: relative;
clear: right;
display: none;
box-sizing: border-box
}
div#amzn-native-ad-0 * {
margin: 0;
padding: 0;
border: 0;
top: 0;
bottom: 0;
right: 0;
left: 0;
background: 0;
text-transform: none;
-webkit-user-select: none;
-moz-user-select: none;
-ms-user-select: none;
box-sizing: content-box;
-webkit-box-sizing: content-box;
-moz-box-sizing: content-box;
text-align: left;
-webkit-font-smoothing: initial;
-moz-osx-font-smoothing: initial;
direction: ltr
}
div#amzn-native-ad-0 * div:focus,
div#amzn-native-ad-0 * a:focus,
div#amzn-native-ad-0 * span:focus {
outline: 0
}
div#amzn-native-ad-0 * {
box-sizing: border-box
}
div#amzn-native-ad-0 input.amzn-native-search,
div#amzn-native-ad-0 input.amzn-native-search:before,
div#amzn-native-ad-0 input.amzn-native-search:after {
-webkit-user-select: text;
-khtml-user-select: text;
-moz-user-select: text;
-ms-user-select: text;
user-select: text
}
div#amzn-native-ad-0 .amzn-native-header {
margin-bottom: 20px;
line-height: 20px;
text-align: left
}
div#amzn-native-ad-0 .amzn-native-header .amzn-native-header-text {
font-size: 20px;
font-family: Arial, sans-serif
}
div#amzn-native-ad-0 .amzn-native-header .amzn-native-brand.amzn-native-brand-top {
display: none
}
div#amzn-native-ad-0 .amzn-native-header .amzn-native-brand {
display: inline-block;
float: right;
padding-top: 0
}
div#amzn-native-ad-0 .amzn-native-content {
overflow: hidden
}
div#amzn-native-ad-0 .amzn-native-content.amzn-native-content-adfeedback {
overflow: visible
}
div#amzn-native-ad-0 .amzn-native-content.amzn-native-content-adfeedback:after {
content: " ";
display: block;
clear: both
}
div#amzn-native-ad-0 .amzn-native-content .amzn-native-carousel-leftarrow {
display: none
}
div#amzn-native-ad-0 .amzn-native-content .amzn-native-carousel-rightarrow {
display: none
}
div#amzn-native-ad-0 div.amzn-native-products-list {
list-style-type: none
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product {
float: left;
width: 25%;
margin-bottom: 10px;
height: 300px;
border: 1px solid #ccc;
cursor: pointer;
display: list-item;
text-align: left;
list-style: none;
text-overflow: ellipsis;
position: relative;
box-sizing: border-box;
background-color: #fff
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product div.amzn-native-product-asin {
display: none
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product div.amzn-native-product-deal {
display: none
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product div.amzn-native-product-concept {
display: none
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-image-container {
padding: 5px 5px 0 5px;
height: 165px;
width: 100%;
display: table;
table-layout: fixed
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-image-container div {
display: table-cell;
vertical-align: middle;
width: 100%;
height: 100%
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product a.amzn-native-product-title {
z-index: 2
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product a.amzn-native-product-title span.amzn-native-product-link-catcher {
position: absolute;
width: 100%;
height: 100%;
top: 0;
left: 0;
z-index: 2
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container {
padding-top: 20px;
padding-left: 4%;
padding-right: 4%;
overflow: hidden
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container a {
color: #0066c0;
line-height: 20px;
word-wrap: normal;
text-decoration: none;
text-overflow: ellipsis;
overflow: hidden;
display: inline-block;
width: 100%;
font-weight: normal;
box-shadow: none
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container.amzn-native-product-title-container-black a {
color: #111
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product img {
background: 0;
box-shadow: none;
display: block;
margin: auto;
max-width: 100% !important;
max-height: 150px !important;
height: auto !important;
width: auto !important;
float: none;
border: 0 !important;
padding: 0 !important;
opacity: 1
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-attr-container {
position: absolute;
top: auto;
bottom: 5px;
left: auto;
right: auto;
margin-left: 4%;
margin-right: 4%;
width: 92%
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-offer-price {
font-weight: bold;
font-family: Arial;
padding-right: 5px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-list-price {
text-decoration: line-through;
font-family: Arial;
font-size: 10px;
color: #4a4a4a;
padding-right: 5px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-bs-highlight {
display: none;
padding-top: 10px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-bs-highlight .amzn-native-product-bs-text {
font-family: Arial;
font-size: 14px;
color: #e47911
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-prime {
display: inline-block;
background-position: -2px -31px;
background-size: 265px 75px;
height: 15px;
vertical-align: top;
width: 52px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-prime-container {
margin-top: 7px;
height: 19px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-prime-container .amzn-native-product-prime {
background-position: -2px -32px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-free-shipping {
display: none;
font-size: 12px;
color: #777
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-free-shipping.compact {
font-size: 11px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-price {
line-height: 18px !important
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-svg-icons {
width: 100%
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating {
padding-top: 10px;
line-height: 18px !important
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating .amzn-native-product-stars-holder {
display: inline-block;
background-position: -2.5px -2.2px;
background-size: 227.8px 64px;
height: 13px;
margin-top: 1px;
position: relative;
vertical-align: baseline;
width: 68.5px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating .amzn-native-product-stars-holder span.amzn-native-product-stars {
background-position: -82.8px -2.4px;
background-size: 227.8px 64px;
display: inline-block;
height: 13px;
left: 0;
position: absolute;
top: 0;
width: 0
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating.amzn-native-product-large-rating .amzn-native-product-stars-holder {
background-position: -2.5px -3.2px;
background-size: 240px 75px;
height: 14px;
width: 72px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating.amzn-native-product-large-rating .amzn-native-product-stars-holder span.amzn-native-product-stars {
background-position: -86.8px -3.4px;
background-size: 240px 75px;
height: 15px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating.amzn-native-product-large-rating.below-price {
padding-top: 7px;
padding-bottom: 0
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating.amzn-native-product-large-rating.above-price {
padding-bottom: 7px;
padding-top: 0
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-review-count {
vertical-align: top
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product:hover .amzn-native-product-title-container a {
color: #f90;
font-weight: normal
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product:hover .amzn-native-product-title-container.amzn-native-product-title-container-black a {
color: #0066c0
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product:hover img {
opacity: .7
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product:hover .amzn-native-product-image-container {
opacity: .7
}
div#amzn-native-ad-0 .amzn-native-brand {
padding-top: 10px;
text-align: right;
clear: right;
font-size: 11px;
line-height: 13px
}
div#amzn-native-ad-0 .amzn-native-brand a {
width: inherit;
box-shadow: none
}
div#amzn-native-ad-0 .amzn-native-brand .amzn-native-brand-bottom {
display: block
}
div#amzn-native-ad-0 .amzn-native-brand .amzn-native-brand-text a.amzn-native-brand-link {
color: #777;
vertical-align: top;
font-family: Arial, Helvetica, sans-serif;
font-size: 10px;
font-weight: bold;
padding-bottom: 1px;
display: inline-block;
text-decoration: none;
line-height: 11px
}
div#amzn-native-ad-0 .amzn-native-brand span.amzn-native-da-adchoices {
background-position: -2px -92px;
background-size: 382px 108px;
height: 16px;
vertical-align: top;
width: 16px
}
div#amzn-native-ad-0 .amzn-native-brand-content {
display: inline-block
}
div#amzn-native-ad-0 .amzn-sprite {
background-position: 9999px 9999px;
display: inline-block;
width: 0;
height: 0;
vertical-align: middle
}
div#amzn-native-ad-0.amzn-native-dark .amzn-native-header .amzn-native-header-text {
color: #FFF
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content {
overflow: hidden
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-leftarrow {
vertical-align: middle;
width: 50px;
height: 100px;
position: absolute;
top: 30%;
cursor: pointer;
z-index: 3;
background-size: 318px 90px;
background-position: -277px 5px;
background-repeat: no-repeat;
opacity: .6
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-leftarrow.amzn-native-carousel-leftarrowdefault {
-webkit-tap-highlight-color: transparent
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-leftarrow.amzn-native-carousel-leftarrowhover {
opacity: 1
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-rightarrow {
vertical-align: middle;
width: 50px;
height: 100px;
position: absolute;
top: 30%;
cursor: pointer;
z-index: 3;
right: 0;
left: auto;
background-size: 318px 90px;
background-position: -218px 5px;
background-repeat: no-repeat;
opacity: .6
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-rightarrow.amzn-native-carousel-rightarrowdefault {
opacity: .6;
-webkit-tap-highlight-color: transparent
}
div#amzn-native-ad-0.amzn-native-carousel .amzn-native-content .amzn-native-carousel-rightarrow.amzn-native-carousel-rightarrowhover {
opacity: 1
}
div#amzn-native-ad-0.amzn-native-carousel div.amzn-native-products-list {
white-space: nowrap;
display: inline-block;
display: -moz-inline-box;
-webkit-transition: margin .5s ease-in-out;
-moz-transition: margin .5s ease-in-out;
-o-transition: margin .5s ease-in-out;
transition: margin .5s ease-in-out
}
div#amzn-native-ad-0.amzn-native-carousel div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container a {
white-space: normal
}
div#amzn-native-ad-0.amzn-native-carousel-mobile .amzn-native-content {
overflow-x: scroll;
-webkit-overflow-scrolling: touch
}
div#amzn-native-ad-0.amzn-native-carousel-mobile div.amzn-native-products-list {
white-space: nowrap;
display: inline-block;
display: -moz-inline-box;
-webkit-transition: margin .5s ease-in-out;
-moz-transition: margin .5s ease-in-out;
-o-transition: margin .5s ease-in-out;
transition: margin .5s ease-in-out
}
div#amzn-native-ad-0.amzn-native-no-borders div.amzn-native-products-list div.amzn-native-product {
border: 0
}
div#amzn-native-ad-0.amzn-native-ad-search-mobile div.amzn-native-products-list div.amzn-native-product:hover .amzn-native-product-title-container a {
color: #0066c0
}
div#amzn-native-ad-0.amzn-native-ad-search-mobile div.amzn-native-products-list div.amzn-native-product:hover img {
opacity: 1
}
div#amzn-native-ad-0.amzn-native-ad-top-branding .amzn-native-header .amzn-native-brand.amzn-native-brand-top {
padding-top: 5px;
display: block
}
div#amzn-native-ad-0.amzn-native-ad-top-branding .amzn-native-brand.amzn-native-brand-bottom {
display: none
}
div#amzn-native-ad-0.amzn-native-ad-search-box .amzn-native-header .amzn-native-brand.amzn-native-brand-top {
display: block
}
div#amzn-native-ad-0.amzn-native-ad-search-box .amzn-native-brand.amzn-native-brand-bottom {
display: none
}
div#amzn-native-ad-0 .amzn-native-header {
margin-bottom: 10px
}
div#amzn-native-ad-0 .amzn-native-header .amzn-native-header-text {
font-size: 16px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product {
height: 200px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-image-container {
height: 120px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product img {
max-height: 115px !important
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container a {
line-height: 17px !important;
font-size: 12px !important
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-title-container {
padding-top: 10px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-offer-price {
font-size: 12px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-bs-highlight {
padding-top: 5px
}
div#amzn-native-ad-0 div.amzn-native-products-list div.amzn-native-product .amzn-native-product-rating {
padding-top: 5px;
line-height: 17px !important
}
</style>
<style type="text/css">
div#amzn-native-ad-0 .amzn-sprite {
background-image: url("//wms-na.amazon-adsystem.com/panda/20070822/US/img/amzn-nsa-sprite-2x.png");
}
</style>
<div id="amzn-native-ad-0" class="amzn-native-container " data-ad-meta="Native_Compact-manual" style="display: block; width: 600px;">
<div class="amzn-native-header">
<span class="amzn-native-header-text">Our Books</span>
<div class="amzn-native-brand amzn-native-brand-top">
<span class="amzn-native-brand-content">
<span class="amzn-native-brand-text">
<a rel="nofollow" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://affiliate-program.amazon.com/home/ads/ref=sm_n_ma_dka_US_logo?adId=logo&creativeASIN=logo&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290425&ac-ms-src=nsa-ads&cid=nsa-ads" target="_blank" class="amzn-native-brand-link amzn-native-brand-logo-link">
Ads by Amazon
</a>
<a rel="nofollow" class="amzn-native-adchoices-link" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/adprefs/ref=sm_n_ma_dka_US_ac?tag=postgisus-20&linkCode=w43" target="_blank" title="AdChoices">
<span class="amzn-sprite amzn-native-da-adchoices"></span>
</a>
</span>
</span>
</div>
</div>
<div class="amzn-native-content " style="height: 228px;">
<div class="amzn-sprite amzn-native-carousel-leftarrow"></div>
<div class="amzn-native-products-list" style="display: block;">
<div class="amzn-native-product amzn-native-product-asin-container" data-item-type="ASIN" title="pgRouting: A Practical Guide" tabindex="0" style="margin-left: 0px; width: 23.75%; display: block; height: 226px;">
<div class="amzn-native-product-asin" style="display: block;">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image" src="https://m.media-amazon.com/images/I/41Z9brwO5PL._AC_SL115_.jpg">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container ">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/dp/0989421732/ref=sm_n_ma_dka_US_pr_ran_0_0?adId=0989421732&creativeASIN=0989421732&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290414" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text">pgRouting: A Practical Guide</span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full ">
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price" style="display: inline-block;">$35.99</span><!--
--><span class="amzn-native-product-list-price" style="display: none;"></span><!--
--><span class="amzn-sprite amzn-native-product-prime amzn-native-product-prime-inline-with-price" style="display: inline-block;"></span><!--
-->
</div>
<div class="amzn-native-product-bs-highlight" style="display: none;">
<span class="amzn-native-product-bs-text">Bestseller</span>
</div>
<div class="amzn-native-product-rating below-price" style="display: block;">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite" style="width: 88%;"></span>
</span>
<span class="amzn-native-product-review-count">(9)</span>
</div>
</div>
</div>
<div class="amzn-native-product-deal">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image">
</div>
</div>
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price"></span>
<span class="amzn-native-percent-off"></span>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full">
<div class="amzn-native-product-deal-attr-container">
<div class="amzn-native-product-deal-badge">DEAL OF THE DAY</div>
<div class="amzn-native-product-deal-badge-skew"></div>
<div class="amzn-native-product-deal-timer-container"> ENDS IN <div class="amzn-native-product-deal-timer"></div>
</div>
</div>
<div class="amzn-native-product-rating">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite"></span>
</span>
<span class="amzn-native-product-review-count"></span>
</div>
</div>
</div>
<div class="amzn-native-product-concept">
<div tabindex="1" class="amzn-native-product-image-container">
<div class="amzn-native-concept-image">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
</div>
</div>
<div class="amzn-native-product amzn-native-product-asin-container" data-item-type="ASIN" title="PostGIS in Action, 2nd Edition" tabindex="0" style="margin-left: 1.66667%; width: 23.75%; display: block; height: 226px;">
<div class="amzn-native-product-asin" style="display: block;">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image" src="https://m.media-amazon.com/images/I/41O0J7pV3UL._AC_SL115_.jpg">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container ">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/dp/1617291390/ref=sm_n_ma_dka_US_pr_ran_0_1?adId=1617291390&creativeASIN=1617291390&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290416" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text">PostGIS in Action, 2nd Edition</span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full ">
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price" style="display: inline-block;">$30.74</span><!--
--><span class="amzn-native-product-list-price" style="display: none;">$49.99</span><!--
--><span class="amzn-sprite amzn-native-product-prime amzn-native-product-prime-inline-with-price" style="display: inline-block;"></span><!--
-->
</div>
<div class="amzn-native-product-bs-highlight" style="display: none;">
<span class="amzn-native-product-bs-text">Bestseller</span>
</div>
<div class="amzn-native-product-rating below-price" style="display: block;">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite" style="width: 92%;"></span>
</span>
<span class="amzn-native-product-review-count">(34)</span>
</div>
</div>
</div>
<div class="amzn-native-product-deal">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image">
</div>
</div>
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price"></span>
<span class="amzn-native-percent-off"></span>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full">
<div class="amzn-native-product-deal-attr-container">
<div class="amzn-native-product-deal-badge">DEAL OF THE DAY</div>
<div class="amzn-native-product-deal-badge-skew"></div>
<div class="amzn-native-product-deal-timer-container"> ENDS IN <div class="amzn-native-product-deal-timer"></div>
</div>
</div>
<div class="amzn-native-product-rating">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite"></span>
</span>
<span class="amzn-native-product-review-count"></span>
</div>
</div>
</div>
<div class="amzn-native-product-concept">
<div tabindex="1" class="amzn-native-product-image-container">
<div class="amzn-native-concept-image">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
</div>
</div>
<div class="amzn-native-product amzn-native-product-asin-container" data-item-type="ASIN" title="PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database" tabindex="0"
style="margin-left: 1.66667%; width: 23.75%; display: block; height: 226px;">
<div class="amzn-native-product-asin" style="display: block;">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image" src="https://m.media-amazon.com/images/I/51NVQOHq1YL._AC_SL115_.jpg">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container ">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/dp/1491963417/ref=sm_n_ma_dka_US_pr_ran_0_2?adId=1491963417&creativeASIN=1491963417&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290418" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text">PostgreSQL: Up and Running: A Practic…</span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full ">
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price" style="display: inline-block;">$39.99</span><!--
--><span class="amzn-native-product-list-price" style="display: none;"></span><!--
--><span class="amzn-sprite amzn-native-product-prime amzn-native-product-prime-inline-with-price" style="display: inline-block;"></span><!--
-->
</div>
<div class="amzn-native-product-bs-highlight" style="display: none;">
<span class="amzn-native-product-bs-text">Bestseller</span>
</div>
<div class="amzn-native-product-rating below-price" style="display: block;">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite" style="width: 88%;"></span>
</span>
<span class="amzn-native-product-review-count">(70)</span>
</div>
</div>
</div>
<div class="amzn-native-product-deal">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image">
</div>
</div>
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price"></span>
<span class="amzn-native-percent-off"></span>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full">
<div class="amzn-native-product-deal-attr-container">
<div class="amzn-native-product-deal-badge">DEAL OF THE DAY</div>
<div class="amzn-native-product-deal-badge-skew"></div>
<div class="amzn-native-product-deal-timer-container"> ENDS IN <div class="amzn-native-product-deal-timer"></div>
</div>
</div>
<div class="amzn-native-product-rating">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite"></span>
</span>
<span class="amzn-native-product-review-count"></span>
</div>
</div>
</div>
<div class="amzn-native-product-concept">
<div tabindex="1" class="amzn-native-product-image-container">
<div class="amzn-native-concept-image">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
</div>
</div>
<div class="amzn-native-product amzn-native-product-asin-container" data-item-type="ASIN" title="PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database" tabindex="0"
style="margin-left: 1.66667%; width: 23.75%; display: block; height: 226px;">
<div class="amzn-native-product-asin" style="display: block;">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image" src="https://m.media-amazon.com/images/I/51EJYNLSKxL._AC_SL115_.jpg">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container ">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/dp/1449373194/ref=sm_n_ma_dka_US_pr_ran_0_3?adId=1449373194&creativeASIN=1449373194&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290420" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text">PostgreSQL: Up and Running: A Practical…</span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full ">
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price" style="display: inline-block;">$3.40</span><!--
--><span class="amzn-native-product-list-price" style="display: inline-block;">$29.99</span><!--
--><span class="amzn-sprite amzn-native-product-prime amzn-native-product-prime-inline-with-price" style="display: none;"></span><!--
-->
</div>
<div class="amzn-native-product-bs-highlight" style="display: none;">
<span class="amzn-native-product-bs-text">Bestseller</span>
</div>
<div class="amzn-native-product-rating below-price" style="display: block;">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite" style="width: 78%;"></span>
</span>
<span class="amzn-native-product-review-count">(28)</span>
</div>
</div>
</div>
<div class="amzn-native-product-deal">
<div tabindex="-1" class="amzn-native-product-image-container">
<div>
<img class="amzn-native-product-image">
</div>
</div>
<div class="amzn-native-product-price">
<span class="amzn-native-product-offer-price"></span>
<span class="amzn-native-percent-off"></span>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
<div tabindex="-1" class="amzn-native-product-attr-container amzn-native-product-attr-container-full">
<div class="amzn-native-product-deal-attr-container">
<div class="amzn-native-product-deal-badge">DEAL OF THE DAY</div>
<div class="amzn-native-product-deal-badge-skew"></div>
<div class="amzn-native-product-deal-timer-container"> ENDS IN <div class="amzn-native-product-deal-timer"></div>
</div>
</div>
<div class="amzn-native-product-rating">
<span class="amzn-native-product-stars-holder amzn-sprite">
<span class="amzn-native-product-stars amzn-sprite"></span>
</span>
<span class="amzn-native-product-review-count"></span>
</div>
</div>
</div>
<div class="amzn-native-product-concept">
<div tabindex="1" class="amzn-native-product-image-container">
<div class="amzn-native-concept-image">
</div>
</div>
<div tabindex="-1" class="amzn-native-product-title-container">
<a rel="nofollow" tabindex="-1" class="amzn-native-product-title" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/http://postgis.us/#" target="_blank">
<span class="amzn-native-product-link-catcher"></span>
<span class="amzn-native-product-title-text"></span>
</a>
</div>
</div>
</div>
</div>
<div class="amzn-sprite amzn-native-carousel-rightarrow"></div>
</div>
<div class="amzn-native-brand amzn-native-brand-bottom">
<span class="amzn-native-brand-content">
<span class="amzn-native-brand-text">
<a rel="nofollow" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://affiliate-program.amazon.com/home/ads/ref=sm_n_ma_dka_US_logo?adId=logo&creativeASIN=logo&linkId=e3617a9a8ede9183f4ff66df23c061aa&tag=postgisus-20&linkCode=w43&ref-refURL=http%3A%2F%2Fpostgis.us%2F&slotNum=0&imprToken=290372f706667514e2ad5842e8127db0&adType=smart&adMode=manual&adFormat=grid&impressionTimestamp=1650649290426&ac-ms-src=nsa-ads&cid=nsa-ads" target="_blank" class="amzn-native-brand-link amzn-native-brand-logo-link">
Ads by Amazon
</a>
<a rel="nofollow" class="amzn-native-adchoices-link" href="https://aax-us-east.amazon-adsystem.com/x/c/QjovBMoudOZPVBlDqmsRs3oAAAGAUl1WNAEAAAFKAYSFzow/https://www.amazon.com/adprefs/ref=sm_n_ma_dka_US_ac?tag=postgisus-20&linkCode=w43" target="_blank" title="AdChoices">
<span class="amzn-sprite amzn-native-da-adchoices"></span>
</a>
</span>
</span>
</div>
</div>
<style type="text/css">
</style>
</div>
<!-- END AMAZON ADS -->
<p><img src="images/pgrouting_ellie.png" style="border:0;height:150px;float:left;" title="Ellie pgRouting Practical Guide"> <b><a href="http://locatepress.com/pgrouting" target="_blank">pgRouting: A Practical Guide</a></b> is now available in
Hardcopy from
<a href="https://www.amazon.com/gp/product/0989421732/ref=as_li_tl?ie=UTF8&tag=postgisus-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0989421732&linkId=0386507e2461c6f4183d2ec783cbf034" target="_blank">Hardcopy from Amazon</a>.
<a href="http://locatepress.com">E-Book or Bulk discounts on Hard-copy from Locate Press</a>.</p>
</div>
<table>
<tbody>
<tr valign="top">
<td>
<a href="https://www.manning.com/?utm_source=PostGISInAction&utm_medium=affiliate&utm_campaign=all_pbooks_45off_8_11_21&a_aid=PostGISInAction&a_bid=ff5aeae6" target="_blank" alt="PostGIS in Action,3rd edition"><img src="https://images.manning.com/360/480/resize/book/3/f343c75-f744-466e-93eb-2f281cf4d494/Obe-PostGIS-3ed-MEAP-HI.png" style="height:180px" title="PostGIS in Action 3rd Edition" alt="PostGIS in Action,3rd edition MEAP"></a>
<a href="https://www.dpbolvw.net/click-7057843-11260198?url=http%3A%2F%2Fshop.oreilly.com%2Fproduct%2F0636920052715.do%3Fcmp%3Daf-strata-books-videos-product_cj_9781491963418_%2525zp&cjsku=SKU-KIT-0636920052715-IP-BUNDLE" target="_blank"><img src="https://akamaicovers.oreilly.com/images/0636920052715/cat.gif" border="0" alt="PostgreSQL: Up and Running" style="height:190px"></a><img
src="https://www.awltovhc.com/image-7057843-11260198" width="1" height="1" border="0">
<a href="https://manning.com/garrard/?a_aid=PostGISInAction&a_bid=c3bae5be" target="_blank" alt="Geoprocessing with Python" title="Geoprocessing with Python"><img src="https://manning.com/garrard/garrard_cover150.jpg"></a>
<a href="https://www.manning.com/books/d3js-in-action-second-edition?a_aid=PostGISInAction&a_bid=b9d040c9" target="_blank" alt="D3.js in Action"><img src="https://images.manning.com/255/340/resize/book/0/3472f21-a554-4233-ac59-7cbc29f9db26/Meeks-D3-2ed-HI.png" title="D3.js in Action 2nd Edition" alt="D3.js in Action 2nd Edition" style="height:180px"></a>
<a href="https://www.amazon.com/PostGIS-Cookbook-organize-manipulate-analyze/dp/1788299329?linkCode=wey&tag=postgisus-20" target="_blank"><img src="https://images-na.ssl-images-amazon.com/images/I/41tOZeQ8k8L._SX404_BO1,204,203,200_.jpg" title="PostGIS Cookbook 2nd Edition" alt="PostGIS Cookbook 2nd edition" style="height:180px"></a>
<a href="https://www.amazon.com/gp/product/0989421716/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0989421716&linkCode=as2&tag=postgisus-20&linkId=EYR6CGJAYNJLKXJD"><img border="0" src="https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=0989421716&Format=_SL250_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=postgisus-20" style="height:180px"></a><img
src="https://ir-na.amazon-adsystem.com/e/ir?t=postgisus-20&l=as2&o=1&a=0989421716" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;">
</td>
</tr>
</tbody>
</table>
</div>
</div>
</form>Text Content
* Home * PostGIS * The Book (3rd) * Funding PostGIS Work * Boston GIS Site for Open Source/OGC GIS topics POSTGIS IN ACTION (3RD) WHERE THE ADVENTURE BEGINS TRANSLATE: SELECT LANGUAGE ENGLISH VERSION TO APPLY CHINESE FRENCH ITALIAN JAPANESE KOREAN SPANISH SWEDISH VIETNAMESE BOOK SPOTS * Buy Our books * Chapters * Book Reviews * About the Authors * Author Presentations * PostGIS In Action Forum (3ed) * Translations * Desktop Tools * Web Tools * Code and Book data (3rd edition) * Code and Book data (2nd edition) * Chapter code download (1st edition) * Full Code and Book data (1st edition) POSTGIS RELATED SITES * PostGIS Website * Fund our PostGIS work * Planet PostGIS * PostGIS Community Wiki * PostGIS on Twitter * Case Studies: Who is using PostGIS? * Study Guides * PostGIS Manuals * PostGIS Windows Downloads * OSGEO (Open Source Geospatial Foundation) * PostgreSQL Database * Postgres OnLine Journal Twitter POSTGIS IN ACTION 1ST, 2ND AND 3RD EDITION BOOKS PostGIS is a spatial database extender for the PostgreSQL Open Source Object-Relational database management system. PostGIS follows the OGC/SQL-MM standards. A lot in PostGIS has changed since we wrote the Second Edition of PostGIS In Action. PostGIS in Action,3rd Edition is a significant update to the second edition that covers new features in 2.5, 3.0, 3.1, and 3.2 as well as newer PostgreSQL 11-13 enhancements. In addition PostgreSQL has changed as well and has added many new speed improvements, new datatypes (jsonb), and newer constructs (introduction of partitioned tables). We cover some of these in performance tuning, PL languages and the Appendixes. PostGIS in Action,3rd Edition provides a guided tour of these new enhancements and things to watch out for when migrating from PostGIS 2.x to 3.x. For new users, you'll get a good primer on basic functionality of PostGIS as well as a growth path to take advantage of its more unique and gourmet features. Special focus on PostGIS 3 series and PostgreSQL 12+. We introduce you to both PostGIS as well as PostgreSQL, the powerful DBMS that PostGIS spatially extends. You will learn: * The basics of Geographic Infomation Systems (GIS), spatial data processing,and how these extend the kinds of questions you can answer with a relational database * How to load both vector and raster data into the database and working with topology. * Using Foreign Data Wrappers to query data external to the database, including spatial ones. * How spatial reference systems play a role in GIS * The power of Spatial SQL to simplify and expand the possibilities of location aware applications, statistical analysis based on location, and raster analysis. * How PostGIS/PostgreSQL fits into the standard body of GIS and relational databases. * What workflows PostGIS is good for and how to perform them efficiently * How to view PostGIS data in desktop applications * How to integrate PostGIS in your web applications The appendices cover topics germane to PostGIS and PostgreSQL: * Helpful resources for learning more about PostgreSQL, GIS, Free tools and Commerical tools that work with PostGIS * Getting free GIS data * Getting up and running with PostgreSQL and PostGIS * The fundamentals of Structured Query Lanuage (SQL) * PostgreSQL unique features, backup and restore, and security management This website is a companion to the PostGIS in Action books. We provide PostGIS and PostgreSQL resources, code downloads, data downloads used in the book as well as providing chapter summaries of what is covered in each chapter. On the chapter listing page you will see a paper clip to download code and data for that chapter. You will also see the download link on each chapter page. Note the E-Book version is half the price of the hard-copy and Manning will reimburse you the price you paid for E-Book if you choose to later buy the hard-copy. Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021 Our Books Ads by Amazon pgRouting: A Practical Guide $35.99 Bestseller (9) DEAL OF THE DAY ENDS IN PostGIS in Action, 2nd Edition $30.74$49.99 Bestseller (34) DEAL OF THE DAY ENDS IN PostgreSQL: Up and Running: A Practic… $39.99 Bestseller (70) DEAL OF THE DAY ENDS IN PostgreSQL: Up and Running: A Practical… $3.40$29.99 Bestseller (28) DEAL OF THE DAY ENDS IN Ads by Amazon pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press. © Leo Hsu and Regina Obe 2022