By Rupert
Transform 900913 to 4326
Stumbled upon an error in reprojecting data from 900913 (Google Speherical Mercator) to 4326 (WGS84). I’m recalling this from my head now, the error was something related to “NAD sth”. Workaround was to convert it as follows:
1. 900913
2. 32650 (UTM for your area)
3. 4326
I’ll get the SQL from my ofcmate and paste it here…
| Print article | This entry was posted by rupert on September 4, 2008 at 12:37 am, and is filed under Uncategorized. Follow any responses to this post through RSS 2.0. You can skip to the end and leave a response. Pinging is currently not allowed. |
Postgres PostGIS CheatSheet v2
about 1 year ago - No comments
This is a quick-command list of Postres. If you want detailed instructions, please visit the Postgres Manual. How do I Show all databases? 1. Using “psql -l” 2. Using postgres=# \l List of databases Name | Owner | Encoding ——————+———-+———- postgis | postgres | UTF8 postgres | postgres | UTF8 template0 | postgres | UTF8
Postgres PostGis PostInstall
about 2 years ago - No comments
1. Edit pg_hba.conf # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.1.0 255.255.255.0 md5 # IPv6 local connections: #host all all ::1/128 trust 2. Edit postgres.conf 55 56 listen_addresses = ‘*’ # what IP address(es) to listen on;
Installing Postgresql, Postgis, pgRouting on Debian
about 2 years ago - Comments Off
Operating System: Debian sid Versions: postgres 8.3.1 postgis 1.3.3 pgRouting1.02 1. Install base system and ssh #vi /etc/apt/sources.list to include deb http://debian.cn99.com/debian etch main deb-src http://debian.cn99.com/debian etch main #apt-get update #apt-get upgrade libc6 2. Install the required packages for postgres8.3 and postgis1.3.3 #apt-get install sudo nmap telnet #apt-get install python2.5 python2.5-dev python-setuptools #apt-get install g++
Installing Postgres8.3,8.4, Postgis1.3.3,1.4.1, pgRouting on MacOSX Leopard
about 2 years ago - No comments
References: http://developer.apple.com/internet/opensource/postgres.html http://www2.russbrooks.com:8080/2007/11/4/install-postgresql-on-mac-os-x-10-5-leopard Warning: Most of the packages listed below is installed by source. 1. Download the current postgres source. 8.3: $./configure –with-prefix=/usr/local/pgsql –with-python 8.4: $./configure –prefix=/usr/local/pgsql –with-python $make $sudo make install 2. Don’t delete the postgres folder. You might need this later on for future compilations. See pgadmin3 admin pack below. 3.
Installing PostGres8.3 and Postgis1.3.2 on Windows
about 2 years ago - No comments
It seems very nice for the new PostGres8.3 installer to bundle up third party libraries installation with the new admin pack feature. Using this feature, you can install PostGis, nPgsql, etc. The installation was painless and smooth this time. I have to backup all my data though using pg_dump. To lessen the learning curve on
Making GeoJSON outputs from PostGIS
about 2 years ago - No comments
I have an internet/web application sitting on top of OpenLayers, ExtJS, ColdFusion and PostGreSQL/PostGIS. I can query the geometry from PostGIS thru ColdFusion without any problems. If you are in ColdFusion 7, then you need a postgresql driver installed, but I do suggest you use ColdFusion 8 as the driver is built-in. To display the
GIS 2.0
about 2 years ago - No comments
It’s been a long time since my previous blog post because I was caught up with numerous meetings and presentations with the recent development of “The Interface“. Developing the new beast during a 2.5 week code sprint is both enjoyable and a personal satisfaction. I have to give credit to Yahoo UI and ExtJS for
OGR Quick Reference
about 3 years ago - No comments
Here is a list of the most widely used OGR commands I use.. OGR2OGR 1. POSTGRES -> MAPINFO $ ogr2ogr -f "Mapinfo File" busline_buffer10m.tab PG:"host=localhost user=postgres dbname=cybersoftbj" -sql "select * from table_name" -a_srs WGS84 -nln layer_name -nlt MULTIPOLYGON 2. MAPINFO -> POSTGRES ogr2ogr -f "PostgreSQL" PG:"host=127.0.0.1 user=rupert dbname=australia password=*****" AUS_ROAD.TAB -nln AUS_ROAD -a_srs EPSG:4269 -t_srs
Buffering points
about 3 years ago - No comments
Here is a post in buffering points and combining them using GeomUnion. Works in GEOS3.0.0, so note that your POSTGIS installation in windows contains a lower version of GEOS. DROP FUNCTION combineGeometry(); CREATE FUNCTION combineGeometry() RETURNS Void AS’ DECLARE –define datatypes here updateCount integer DEFAULT 0; geom_record RECORD; geom_current RECORD; geom_final RECORD; mytotal integer
Buffering Lines
about 3 years ago - 2 comments
Here is a sample script in using buffer in Postgis. I buffered the line by 10 and 20 meters. Take note that I have to transform the geometry to the corresponding EPSG, so I could specify “meters”. DROP TABLE busline_buffer1; DELETE FROM geometry_columns WHERE f_table_name = ‘busline_buffer1′; CREATE TABLE busline_buffer1( gid serial, CONSTRAINT pk_buffer1
about 1 year ago
SELECT
AsText(
Transform(
Transform(
GeomFromText( ‘POINT( 12946153.81080 4849895.22611 )’, 900913),
32650
),
4326
)
)