とらりもんHOME  Index  Search  Changes  Login

PostGIS Cookbook

2018/11/22 Jin Katagi

Solution when you can not run as book wrote

Chap01

P10

You can get firenews.csv from https://github.com/PacktPublishing/PostGIS-Cookbook-Second-Edition/tree/master/Chapter01 .

You cannot unzip data.zip.001 and data.zip.002.

You can extract by using 7zip command:

$ sudo apt install p7zip-full p7zip-rar
$ 7z e data.zip.001
$ 7z e data.zip.002

P12

x $ psql -U me -d postgis_cookbook
o $ psql -d postgis_cookbook # by your user_name
x > CREATE EXTENSION postgis;
  ERROR:  permission denied to create extension "postgis"
o $ psql --username=postgres --dbname=postgis_cookbook -c "CREATE EXTENSION postgis;"
 

The default password of postgres user is "postgres"

P26

If it is the first time to connect PostGIS from QGIS, you should set some setting.

x Layer -> Add Layer -> Add PostGIS layers
o Layer -> Add Layer -> Add PostGIS layers -> New

Type

Name: db@localhost
Service:
Host: localhost
Port: 5432
database: postgis_cookbook

And click test, and type your name and password (if you made database as postgres user, then user name and password are postgres).

P27

You can't find "wborders.shp". Instead, you can see 'TM_WORLD_BORDERS-0.3.shp'.

So, you should rename 'TM_WORLD_BORDERS-0.3.shp' to 'wborders.shp'.

P28

x SELECTST_AsText(the_geom) AS the_geom, bright_t31 FROM chp01.global_24h ORDER BY bright_t31 DESC LIMIT 100;
o SELECT ST_AsText(the_geom) AS the_geom, bright_t31 FROM chp01.global_24h ORDER BY bright_t31 DESC LIMIT 100;

P49

3.

$ rename 's/([0-9]+)/sprintf("%02d",$1)/e' *
Last modified:2018/11/26 17:36:48
Keyword(s):
References: