PostGIS in Action PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing you to create location-aware queries with just a few lines of SQL code, and provides a back-end for mapping applications with minimal effort. PostGIS in Action teaches readers of all levels to write spatial queries that solve real-world problems. An introduction to spatial databases Geometry types, functions, and queries Applying PostGIS to real-world problems Extending PostGIS to web and desktop applications Familiarity with relational database concepts is helpful but not required. About the Author Regina Obe and Leo Hsu are database consultants. “After spending a couple weeks looking through the book, I have to say that I am very impressed with the quality and completeness. “What truly unifies this book is the clarity and purpose of writing.
GRASS GIS - Home PostgreSQL: The world's most advanced open source database Welcome to MapServer — MapServer 6.2.0 documentation Documentation Skip site navigation (1) Skip section navigation (2) Peripheral Links Documentation There is a wealth of PostgreSQL information available online. This section contains current and archived manuals for PostgreSQL users, as well as frequently asked questions. You can learn what's new in the latest release, and view a listing of books written about PostgreSQL (some of which are available in their entirety online). Online Manuals 9.5 (with/without comments) 9.4 (with/without comments) 9.3 (with/without comments) 9.2 (with/without comments) 9.1 (with/without comments) Translated Manuals More manuals
MapWindow Open Source GIS - Home Page Performance Tuning PostgreSQL by Frank Wiles PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? The problem is that every database is not only different in its design, but also its requirements. The default configuration PostgreSQL ships with is a very solid configuration aimed at everyone's best guess as to how an "average" database on "average" hardware should be setup. Understanding the process The first step to learning how to tune your PostgreSQL database is to understand the life cycle of a query. Transmission of query string to database backend Parsing of query string Planning of query to optimize retrieval of data Retrieval of data from hardware Transmission of results to client The first step is the sending of the query string ( the actual SQL command you type in or your application uses ) to the database backend. General Tuning Hardware Issues ANALYZE books;
Maptitude Mapping Software Maptitude GIS and mapping software gives you the tools, maps, and data you need to analyze and understand how geography affects you and your organization. Maptitude is the most capable, and least expensive, full-featured mapping software available. Designed for data visualization and geographic analysis, Maptitude comes with a comprehensive library of maps and data for your country. Choose your country below to learn more: More Countries» Maptitude Demo: Marketing and Sales Mapping Maptitude is a powerful combination of mapping software and geographic data that provides everything that you need to make informed decisions and get the maximum return on your sales and marketing budget. Territory Mapping Maptitude gives you a suite of tools that you can use to create districts for your business mapping needs. Business Mapping Your client, territory, and business information are your greatest asset, with over 80% of company data having a mappable component.
Manifold® System - GIS and Mapping