Changes between Version 1 and Version 2 of WKTRasterTutorial01
- Timestamp:
- 06/10/10 13:17:33 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WKTRasterTutorial01
v1 v2 49 49 The favorite tool of the PostGIS community to display geometries loaded into PostGIS is OpenJUMP. This java open source software is very easy to install and work very well with PostGIS. Once OpenJUMP have been downloaded and installed, you can view the caribou points by following these steps: 50 50 51 1) Start OpenJUMP and select "Layer->Run Datastore Query" from the menu. 52 53 2) Create a connection to PostGIS by clicking the icon on the right of the connection field and adding a new connection with the name of your choice, the "localhost" server, at port "5432", on your database instance (here "demodb") with your PostgreSQL username and password. Click OK to establish the connection. 54 55 3) In the query field, type the following command: 51 1. Start OpenJUMP and select "Layer->Run Datastore Query" from the menu. 52 53 54 2. Create a connection to PostGIS by clicking the icon on the right of the connection field and adding a new connection with the name of your choice, the "localhost" server, at port "5432", on your database instance (here "demodb") with your PostgreSQL username and password. Click OK to establish the connection. 55 56 57 3. In the query field, type the following command: 56 58 57 59 SELECT id, ST_AsBinary(the_geom) … … 88 90 The result of the gdal2wktraster.py command is a 1.8 GB .sql file produced in 1 minute on my brand new Lenovo X201 labtop (Intel Core i5, 1.17 GHz, 3 GB or RAM :-). 89 91 90 3)The same way we loaded the caribou point sql command file, we will load this sql file using psql:92 The same way we loaded the caribou point sql command file, we will load this sql file using psql: 91 93 92 94 >psql -f C:\Temp\Pierre\Data\SRTM\srtm.sql demodb