17. Module: Conceptos de Bases de Datos Espaciales con PostGIS

Spatial Databases allow the storage of the geometries of records inside a Database as well as providing functionality for querying and retrieving the records using these Geometries. In this module we will use PostGIS, an extension to PostgreSQL, to learn how to setup a spatial database, import data into the database and make use of the geographic functions that PostGIS offers.

While working through this section, you may want to keep a copy of the PostGIS cheat sheet available from Boston GIS user group. Another useful resource is the online PostGIS documentation.

También hay algunos tutoriales extensos sobre PostGIS y base de datos espaciales disponibles de Boundless Geo:

• Introducción a PostGIS <http://workshops.boundlessgeo.com/postgis-intro/>`_

• Concejos y trucos de Base de datos espacial <http://workshops.boundlessgeo.com/postgis-spatialdbtips/>`_

Ver también PostGIS en línea <http://postgisonline.org/>

• 17.1. Configurar PostGIS ILSI
  • 17.1.1. Instalando bajo Ubuntu
  • 17.1.2. Instalando bajo Windows
  • 17.1.3. Installing on Other Platforms
  • 17.1.4. Configuring Databases to use PostGIS
  • 17.1.5. Looking at the installed PostGIS functions
  • 17.1.6. Spatial Reference Systems
  • 17.1.7. In Conclusion
  • 17.1.8. What’s Next?
• 17.2. Modelo de Caracteristica SImple ILSI
  • 17.2.1. Qué es OGC
  • 17.2.2. What is the SFS Model
  • 17.2.3. Add a geometry field to table
  • 17.2.4. Add a constraint based on geometry type
  • 17.2.5. Try Yourself
  • 17.2.6. Populate geometry_columns table
  • 17.2.7. Add geometry record to table using SQL
  • 17.2.8. In Conclusion
  • 17.2.9. What’s Next?
• 17.3. Lesson: Importar y Exportar
  • 17.3.1. shp2pgsql
  • 17.3.2. pgsql2shp
  • 17.3.3. ogr2ogr
  • 17.3.4. Administrador de BBDD
  • 17.3.5. In Conclusion
  • 17.3.6. What’s Next?
• 17.4. Consultas Espaciales ILSI
  • 17.4.1. Operadores espaciales
  • 17.4.2. Spatial Indexes
  • 17.4.3. Try Yourself
  • 17.4.4. PostGIS Spatial Functions Demo
  • 17.4.5. In Conclusion
  • 17.4.6. What’s Next?
• 17.5. COnstruccion Geometrica ILSI
  • 17.5.1. Creando linestrings
  • 17.5.2. Try Yourself
  • 17.5.3. Crear Polígonos
  • 17.5.4. Exercise: Linking Cities to People
  • 17.5.5. Looking at Our Schema
  • 17.5.6. Try Yourself
  • 17.5.7. Access Sub-Objects
  • 17.5.8. Data Processing
  • 17.5.9. Corte
  • 17.5.10. Building Geometries from Other Geometries
  • 17.5.11. Limpieza de Geometría
  • 17.5.12. Diferencias entre tablas
  • 17.5.13. Tablespaces
  • 17.5.14. In Conclusion