Changes between Version 1 and Version 2 of WKTRasterTutorial01


Ignore:
Timestamp:
Jun 10, 2010, 1:17:33 PM (14 years ago)
Author:
pracine
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • WKTRasterTutorial01

    v1 v2  
    4949The 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:
    5050
    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:
    5658
    5759        SELECT id, ST_AsBinary(the_geom)
     
    8890The 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 :-).
    8991
    90 3) The same way we loaded the caribou point sql command file, we will load this sql file using psql:
     92The same way we loaded the caribou point sql command file, we will load this sql file using psql:
    9193
    9294        >psql -f C:\Temp\Pierre\Data\SRTM\srtm.sql demodb