PostGISonline, Welcome. UsersWikiTutorials – PostGIS. PostGIS Tutorials some complete with data ¶ PostGIS for Power Users slides video Paul Ramsey -- FOSS4G2011 PostGIS database sandbox and tutorials Provides step by step interactive tutorial for experimenting with PostGIS Spatial SQL in a database sandbox.
You can also type in spatial SQL statements you find in the PostGIS manual and see them rendered on a map. Introduction to PostGIS, Tips for the PostGIS Power User (FOSS4G 2010 - Paul Ramsey) Almost Idiot's Guide to PostGIS (last update for PostGIS 1.5) (2010) Spatial database tips and tricks Covers PostGIS , SQL server 2008 Spatial and Oracle but focus on PostGIS PGDay Europe 2010 PostGIS Talks PostGIS - das Wo?
Integrating PostGIS in Web Applications (PG Con East 2010 - Leo hsu and Regina Obe) This covered using OpenLayers, OpenStreetMap Layers, brief intro to GeoExt, setting up Mapserver and GeoServer as OGC WFS/WMS services. Integrating PostGIS in Web Applications slides (2010) PGCon 2009 Spatial Analysis PostGIS (2009) PostGIS for geospatial analysis and mapping. PostGIS users. Part 1: Getting Started With PostGIS: An almost Idiot's Guide (PostGIS 2.0) PostGIS is an open source, freely available, and fairly OGC compliant spatial database extender for the PostgreSQL Database Management System.
In a nutshell it adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to the database. PostGIS is very similar in functionality to SQL Server 2008 Spatial support, ESRI ArcSDE, Oracle Spatial, and DB2 spatial extender. The latest release version now comes packaged with the PostgreSQL DBMS installs as an optional add-on. As of this writing PostGIS 2.0.0 is the latest stable release. Noteable enhancements in this release: We will assume a windows environment for this tutorial, but most of the tutorial will apply to other supported platforms such as Linux, Unix, BSD, Mac etc.
We will not go into too much detail here since the install wizard (at least the windows one) is pretty good. Note for Vista Users Because of the new added security in Vista, you may run into issues installing PostgreSQL. . Wget . PostGIS : Home. Illegal Byte Sequence. Hi, I am trying to import this shapefile into a database on my new server: While this was no problem on my old server running Windows Vista, i now have problems on my Ubuntu Server.
My last server had the LC_COLLATE AND LC_CTYPE blank, while the new Linux has en_US.UTF-8 which seems to create the problems. I tried creating a new database on the new server with blank COLLATE and CTYPE, but it would not accept blank. Any ideas? Thanks, Andreas The old database had the following settings on Enconding: CREATE DATABASE newpg WITH OWNER = ----- ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = '' LC_CTYPE = '' CONNECTION LIMIT = -1; The database on the new server has the following: CREATE DATABASE priogrid WITH OWNER = ----- ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' CONNECTION LIMIT = -1; The error: Importing shapefile (1267 records)...
Shapefile import failed. 2011/3/14 Andreas Forø Tollefsen <> Andreas --strk; Hallo Andreas Nicklas Great.