PostGIS in motion, moment Edition teaches readers of all degrees to write down spatial queries that remedy real-world difficulties. It first delivers a heritage in vector-, raster-, and topology-based GIS after which fast strikes into interpreting, viewing, and mapping information. This moment variation covers PostGIS 2.0 and 2.1 sequence, PostgreSQL 9.1, 9.2, and 9.3 positive factors, and exhibits you the way to combine with different GIS tools.
Purchase of the print booklet contains a loose publication in PDF, Kindle, and ePub codecs from Manning Publications.
About the Book
Processing information tied to position and topology calls for really expert information. PostGIS is a unfastened spatial database extender for PostgreSQL, each piece nearly as good as proprietary software program. With it, you could simply create location-aware queries in exactly a number of strains of SQL code and construct the again finish for a mapping, raster research, or routing program with minimum effort.
PostGIS in motion, moment Edition teaches you to resolve real-world geodata difficulties. It first supplies a history in vector-, raster-, and topology-based GIS after which speedy strikes into reading, viewing, and mapping information. you are going to how you can optimize queries for optimum velocity, simplify geometries for higher potency, and create customized services on your personal purposes. you will additionally methods to practice your latest GIS wisdom to PostGIS and combine with different GIS tools.
Familiarity with relational database and GIS ideas is beneficial yet now not required.
- An creation to spatial databases
- Geometry, geography, raster, and topology spatial varieties, services, and queries
- Applying PostGIS to real-world problems
- Extending PostGIS to net and laptop applications
- Updated for PostGIS 2.x and PostgreSQL 9.x
About the Authors
Regina Obe and Leo Hsu are database specialists and authors. Regina is a member of the PostGIS center improvement group and the undertaking guidance Committee.
Table of Contents
- What is a spatial database?
- Spatial facts types
- Spatial reference procedure considerations
- Working with actual data
- Using PostGIS at the desktop
- Geometry and geography functions
- Raster functions
- PostGIS TIGER geocoder
- Geometry relationships
- Proximity analysis
- Geometry and geography processing
- Raster processing
- Building and utilizing topologies
- Organizing spatial data
- Query functionality tuning
- Extending PostGIS with pgRouting and procedural languages
- Using PostGIS in net applications
PART 1 creation TO POSTGIS
PART 2 placing POSTGIS TO WORK
PART three utilizing POSTGIS WITH different TOOLS
Read or Download PostGIS in Action, 2nd Edition PDF
Best Computer Science books
Programming vastly Parallel Processors discusses uncomplicated ideas approximately parallel programming and GPU structure. ""Massively parallel"" refers back to the use of a big variety of processors to accomplish a collection of computations in a coordinated parallel means. The e-book info numerous options for developing parallel courses.
No country – specially the U.S. – has a coherent technical and architectural technique for combating cyber assault from crippling crucial serious infrastructure providers. This ebook initiates an clever nationwide (and foreign) discussion among the final technical group round right equipment for decreasing nationwide probability.
Cloud Computing: idea and perform offers scholars and IT pros with an in-depth research of the cloud from the floor up. starting with a dialogue of parallel computing and architectures and disbursed platforms, the booklet turns to modern cloud infrastructures, how they're being deployed at major businesses equivalent to Amazon, Google and Apple, and the way they are often utilized in fields akin to healthcare, banking and technology.
Platform Ecosystems is a hands-on consultant that gives a whole roadmap for designing and orchestrating vivid software program platform ecosystems. in contrast to software program items which are controlled, the evolution of ecosystems and their myriad members has to be orchestrated via a considerate alignment of structure and governance.
Extra resources for PostGIS in Action, 2nd Edition
There are 3 very important issues to remove from this instance: 1 2 three The windowing functionality ROW_NUMBER() will create sequentially numbered rows for every partition outlined within the PARTITION by means of of the OVER clause and restart numbering on the subsequent partition (here we’re partitioning through the parcel id), and the rows may be numbered via what we specify within the ORDER by means of of the OVER clause, hence Distance to a highway. We’re utilizing a left sign up for, which promises that every one documents in our the place should be included—in this example all police stations—but basically roads inside of one kilometer of every police station could be thought of. We then order the ultimate outcome via parcel identification after which the proximity of street, that is our row_num (the results of our ROW_NUMBER() windowing call). desk five. nine result of question in directory five. eight Pid land_type row_num road_name dist_km 000001038 police station 1 000001202 police station 1 000002997 police station 1 major Rd zero. 25 000003927 police station 1 major Rd zero. 07 000006442 police station 1 000010131 police station 1 major Rd zero. 23 000010131 police station 2 Curvy St zero. 34 000013872 police station 1 000015423 police station 1 Elephantine Rd zero. forty five desk five. nine lists partial effects from our question. notice that for police stations farther than one kilometer from a highway, we nonetheless come again a record—but the road slots are stuffed in with NULLs. a few police stations have multiple highway inside of one kilometer (for instance, 000010131), and for that one we get files again with the 1st together with the nearest street and the second one the subsequent closest. Now that we’ve lined the fundamentals of proximity research, we’ll circulate directly to bounding bins and easy geometry comparators. even supposing we didn’t rigidity it during this part, what makes proximity queries quick are the box-based short-circuit comparisons. Bounding containers and their geometry operators are utilized by spatial indexes to minimize the set of files that have to be extra heavily scrutinized via the precise comparability operators. We’ll conceal this within the subsequent part. Bounding field and geometry comparators five. 6 139 Bounding field and geometry comparators keep in mind from the former bankruptcy that each geometry has a bounding field, outlined because the smallest oblong field that perfectly encloses the geometry. Bounding bins play a severe position whilst geometries engage. Now that we’ve lined the fundamentals of proximity research, we’ll circulate directly to bounding bins and easy geometry comparators. five. 6. 1 The bounding field Let’s reveal with a brief instance. think we have now multipolygons, one representing the country of Washington and one representing the nation of Florida. If the bounding field of Washington is exactly above and to the left of (northwest of) Florida, then we all know evidently that the particular geometries proportion a similar courting in addition. in fact, if the bounding containers cost is fake, we can’t verify. have in mind now that either states have quite a few islands placing off their coasts. as a way to solution the questions unequivocally, we’d need to pretty well stopover at each aspect in Washington and examine it to each aspect in Florida.