Don't forget the PG tip When opening a PostGIS datasource using the OGR C# wrapper in .Net, the connection string must have "PG:" prefix, as follows: ... Imports OSGeo.OGR ... Dim drv As OSGeo.OGR.Driver... read more Posted by Crispin Flower 15 November 2011 Categories: OGR/GDAL PostgreSQL/PostGIS Comments(0)
Using ECWs without world files in MapInfo If you have ECW map images without world files, they may work fine in ArcGIS but MapInfo won't put them in the right place as it can't read the header information in the ECW. You could opening them... read more Posted by Crispin Flower 12 November 2011 Categories: GIS (general) MapInfo Professional Comments(0)
Getting MapServer to work on IIS7.5 Server 2008 Text below is reproduced from: http://mas-kono-tes.blogspot.com/2011/03/getting-mapserver-to-work-on-iis75.html and gives a reasonable overview of how to install mapserver - especially how to... read more Posted by 12 November 2011 Categories: CGI IIS MapServer Comments(0)
Mapserver 6 and regular expressions In earlier versions of mapserver you might have a regular expression that looked like: EXPRESSION ('[HAB_TYPE]' =~/^A1.1/) If you try this with mapserver 6 however (especially on large datasets)... read more Posted by 08 November 2011 Categories: MapServer OGR/GDAL Comments(0)
Using ECWs without world files in MapInfo If you have ECW map images without world files, they may work fine in ArcGIS but MapInfo won't put them in the right place as it can't read the header information in the ECW. You could opening them... read more Posted by Crispin Flower 30 September 2011 Categories: MapInfo Professional Comments(0)
How to search the contents of files using regular expressions Originally posted by Mike Lush, then augmented by Keith Westcott. You're unlikely to think about this until you need to, but there is no obvious way of searching within a bunch of files for text ... read more Posted by Crispin Flower 09 December 2010 Categories: Regular expressions Comments(0)
GIS conversion web site This site can convert just about anything to just anything else. E.g. I used it to do MapInfo to KML and GPX. I think it uses ogr2ogr under the... read more Posted by Crispin Flower 30 November 2010 Categories: GIS (general) Comments(0)
How to query remote databases in MS Access It is possible to point a query at a table in a remote database that is not linked to the current database; for example this would transfer the some of the fields from a remote copy of the Northwind... read more Posted by Crispin Flower 07 April 2010 Categories: MS Access Comments(0)
Setting up ODBC data sources on 64-bit Windows Server 2008 / Windows 7 Windows Server 2008 x64 and Windows 7 x64 have both 32 bit ODBC data sources and 64 bit ODBC data sources. They are managed separately. Setting up a 32 bit ODBC connection in Windows Server 2008 x64. ... read more Posted by Crispin Flower 30 December 2009 Categories: MS Access Comments(0)
PostgreSQL simple backup and restore To backup in verbose text format (from Windows/DOS command line): pg_dump -C -f backupfile.sql -h localhost -p 5433 -U postgres databasename To restore backup in verbose text format (from... read more Posted by Crispin Flower 18 December 2009 Categories: PostgreSQL/PostGIS Comments(0)