PostGIS in Action, 2nd Edition
PostGIS in motion, moment Edition teaches readers of all degrees to jot down spatial queries that clear up real-world difficulties. It first offers a historical past in vector-, raster-, and topology-based GIS after which speedy strikes into reading, viewing, and mapping facts. This moment version covers PostGIS 2.0 and 2.1 sequence, PostgreSQL 9.1, 9.2, and 9.3 beneficial properties, and exhibits you the way to combine with different GIS tools.
Purchase of the print ebook features a unfastened e-book in PDF, Kindle, and ePub codecs from Manning Publications.
About the Book
Processing info tied to situation and topology calls for really good knowledge. PostGIS is a loose spatial database extender for PostgreSQL, each piece pretty much as good as proprietary software program. With it, you could simply create location-aware queries in precisely a couple of strains of SQL code and construct the again finish for a mapping, raster research, or routing software with minimum effort.
PostGIS in motion, moment Edition teaches you to resolve real-world geodata difficulties. It first offers a heritage in vector-, raster-, and topology-based GIS after which speedy strikes into examining, viewing, and mapping information. you are going to how to optimize queries for max pace, simplify geometries for larger potency, and create customized features on your personal purposes. you are going to additionally the best way to observe your current GIS wisdom to PostGIS and combine with different GIS tools.
Familiarity with relational database and GIS techniques is beneficial yet now not required.
- An advent to spatial databases
- Geometry, geography, raster, and topology spatial varieties, capabilities, and queries
- Applying PostGIS to real-world problems
- Extending PostGIS to internet and laptop applications
- Updated for PostGIS 2.x and PostgreSQL 9.x
About the Authors
Regina Obe and Leo Hsu are database experts and authors. Regina is a member of the PostGIS middle improvement workforce and the venture steerage Committee.
Table of Contents
- What is a spatial database?
- Spatial info types
- Spatial reference method considerations
- Working with genuine 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 internet applications
PART 1 advent TO POSTGIS
PART 2 placing POSTGIS TO WORK
PART three utilizing POSTGIS WITH different TOOLS
additionally makes it more uncomplicated to troubleshoot while issues get it wrong. PostGIS has a number of features you won’t locate even within the advertisement choices. usually it has extra output codecs than the economic choices and its velocity is on par with and occasionally higher than the economic ones for universal spatial wishes. 1.3.3 possible choices to PostgreSQL and PostGIS Admittedly, PostGIS/PostgreSQL isn’t the one spatial database in lifestyles. many of the high-end advertisement relational database structures offer.
Geometry kind is an OGC variety just like the PostGIS OGC geometry style. like the PostGIS geometry sort, the SQL Server 2008 geometry style treats all facts as planar information. PostGIS and SQL Server geography info kinds aren’t OGC forms, although they fight to stick with a number of the comparable functionality and naming conventions as OGC geometry capabilities. OGC is principally taken with planar geometries and operations. The PostGIS geography sort used to be encouraged by way of the SQL Server 2008 geography facts sort. either geography.
major good thing about utilizing hstore to carry miscellaneous characteristic information is that you simply don’t need to organize bona fide columns for attributes which may be of little use in a while in order that you could import facts. you could first import the information after which cherry-pick which attributes you’d prefer to advertise to columns as your wishes develop. utilizing hstore additionally lets you upload and take away attributes with out fussing with the information constitution. the downside is in the event you do desire attributes to be full-fledged columns. You.
For “temporal,” even if aid within the temporal measurement by no means won a lot attractiveness. The ST prefix is generally put aside for SQL/MM services in different spatial databases, yet PostGIS makes use of the prefix either for SQL/MM and for services specific to PostGIS. We’ll commence with constructors. 4.1 Constructors because the identify implies, services create geometries. There are universal how you can create new geometries. the 1st makes use of uncooked facts in a suitable structure and builds the geometry from.
(ST_GeomFromText('POLYGON((0 zero, 1 1, zero 1, zero 0))')), (ST_Point(1, 2)), (ST_MakeLine(ST_Point(1, 2), ST_Point(1, 2))), (ST_Collect(ST_Point(1, 2), ST_Buffer(ST_Point(1, 2),3))), (ST_LineToCurve(ST_Buffer(ST_Point(1, 2), 3))), Accessor features: getters and setters ninety one (ST_LineToCurve(ST_Boundary(ST_Buffer(ST_Point(1, 2), 3)))), (ST_Multi(ST_LineToCurve(ST_Boundary(ST_Buffer(ST_Point(1, 2),3))))) ) As foo (geom); the consequences are proven in desk 4.2. desk 4.2 result of code in directory 4.2.