Difference between revisions of "Spatial Pattern Analysis with CartoDB"

From CUOSGwiki
Jump to navigationJump to search
Line 65: Line 65:
   
   
"#!/usr/bin/env bash
+
#!/usr/bin/env bash
 
POSTGIS_SQL_PATH='pg_config --sharedir'/contrib/postgis-2.0
 
POSTGIS_SQL_PATH='pg_config --sharedir'/contrib/postgis-2.0
 
createdb -E UTF8 template_postgis
 
createdb -E UTF8 template_postgis
Line 77: Line 77:
 
psql -d template_postgis -f topology/topology.sql
 
psql -d template_postgis -f topology/topology.sql
 
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
 
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;""
+
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
   
 
Back in the terminal, we are back where we started: sudo cd postgis-2.0.2
 
Back in the terminal, we are back where we started: sudo cd postgis-2.0.2
   
 
Run the following command
 
Run the following command
 
sudo chmod 777 es.sh
 
sudo chmod 777 es.sh
 
   
 
Change user to postgres
 
Change user to postgres
 
sudo su postgres
 
sudo su postgres
 
   
 
Rune the following command
 
Rune the following command
 
./es.sh
 
./es.sh
 
   
 
Install Ruby 1.9.1
 
Install Ruby 1.9.1
 
sudo get-apt install ruby1.9.1
 
sudo get-apt install ruby1.9.1
 
   
 
Install Node.js
 
Install Node.js
sudo apt-get install nodejs=0.8.26-1chl1~precise1
+
sudo apt-get install nodejs=0.8.26-1chl1~precise1
   
 
Install NPM
 
Install NPM
sudo apt-get install npm=1.3.0-1chl1~precise1
+
sudo apt-get install npm=1.3.0-1chl1~precise1
   
 
Install Redis
 
Install Redis
 
sudo apt-get install redis-server
Components of CartoDB, like Windshaft or the SQL API depend on Redis.
 
sudo apt-get install redis-server
 
   
 
Install EASY INSTALL
 
Install EASY INSTALL
sudo apt-get install python-setuptools
+
sudo apt-get install python-setuptools
   
 
Install Python dependencies
 
Install Python dependencies
 
cd cartodb20
 
cd cartodb20
sudo easy_install pip
+
sudo easy_install pip
sudo pip install -r python_requirements.txt
+
sudo pip install -r python_requirements.txt
   
 
Install Varnish
 
Install Varnish
sudo apt-get install varnish
+
sudo apt-get install varnish
   
 
Install Mapnik
 
Install Mapnik
sudo apt-get install libmapnik-dev python-mapnik2 mapnik-utils
+
sudo apt-get install libmapnik-dev python-mapnik2 mapnik-utils
   
   
 
Install CartoDB SQL API
 
Install CartoDB SQL API
The CartoDB SQL API component powers the SQL queries over HTTP. To install it:
 
git clone git://github.com/CartoDB/CartoDB-SQL-API.git
 
cd CartoDB-SQL-API
 
git checkout master
 
npm install
 
   
cd CartoDB-SQL-API
+
git clone git://github.com/CartoDB/CartoDB-SQL-API.git
 
cd CartoDB-SQL-API
cd config/environments/
 
 
git checkout master
mv development.js.example development.js
 
 
npm install
   
 
cd CartoDB-SQL-API
cd
 
 
cd config/environments/
 
mv development.js.example development.js
   
  +
cd
cd CartoDB-SQL-API
 
node app.js development
 
   
  +
cd CartoDB-SQL-API
Install Windshaft-cartodb
 
 
node app.js development
The Windshaft-cartodb component powers the CartoDB Maps API. To install it:
 
git clone git://github.com/CartoDB/Windshaft-cartodb.git
 
cd Windshaft-cartodb
 
git checkout master
 
npm install
 
   
 
Install Windshaft-cartodb
 
git clone git://github.com/CartoDB/Windshaft-cartodb.git
 
cd Windshaft-cartodb
 
git checkout master
 
npm install
   
 
cd config/environments/
cd Windshaft-cartodb
 
 
mv development.js.example development.js
cd config/environments/
 
mv development.js.example development.js
 
   
cd
+
cd
   
cd Windshaft-cartodb
+
cd Windshaft-cartodb
node app.js development
+
node app.js development
   
 
== User Interface ==
 
== User Interface ==

Revision as of 00:10, 25 December 2013

Introduction

Install Guide

   git clone --recursive https://github.com/CartoDB/cartodb20.git

ADD CartoDB Personal Package Archives (PPAs)

Add CartoDB GIS PPA

   sudo add-apt-repository ppa:cartodb/gis

Add CartoDB Mapnik PPA

   sudo add-apt-repository ppa:cartodb/mapnik

Add Mapnik Boost PPA

   sudo add-apt-repository ppa:mapnik/boost

Add Chris Lea’s Nodejs Legacy PPA

   sudo add-apt-repository ppa:chris-lea/node.js-legacy

Add CartoDB Redis PPA

   sudo add-apt-repository ppa:cartodb/redis

Add CartoDB PostgreSQL PPA

   sudo add-apt-repository  ppa:cartodb/postgresql

Install unp

   sudo apt-get install unp

Install zip

   sudo apt-get install zip

Install GEOS

   sudo apt-get install libgeos-c1 libgeos-dev

Install GDAL

   sudo apt-get install gdal-bin libgdal1-dev

Install JSON-C

   sudo apt-get install libjson0 python-simplejson libjson0-dev

Install PROJ

   sudo apt-get install proj-bin proj-data libproj-dev

Install PostgreSQL

   sudo apt-get install postgresql-9.1 postgresql-client-9.1 postgresql-contrib-9.1 postgresql-server-dev-9.1

plpython is required for Python support

   sudo apt-get install postgresql-plpython-9.1

Install PostGIS

   cd /usr/local/src
   sudo wget http://download.osgeo.org/postgis/source/postgis-2.0.2.tar.gz
   sudo tar xzf postgis-2.0.2.tar.gz
   cd postgis-2.0.2
   ./configure --with-raster --with-topology
   make
   make install

We are going to use the file manager and navigate to the following folder starting from the computer folder and ending with postgis-2.0.2

   /usr/local/sr/postgis-2.0.2

Create a new empty document, name/label it es.sh

Open the folder, paste and save the following, and finally close it.


   #!/usr/bin/env bash
   POSTGIS_SQL_PATH='pg_config --sharedir'/contrib/postgis-2.0
   createdb -E UTF8 template_postgis
   createlang -d template_postgis plpgsql
   psql -d postgres -c \
   "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis'"
   psql -d template_postgis -f postgis/postgis.sql
   psql -d template_postgis -f spatial_ref_sys.sql
   psql -d template_postgis -f postgis/legacy.sql
   psql -d template_postgis -f taster/rt_pg/rtpostgis.sql
   psql -d template_postgis -f topology/topology.sql
   psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
   psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"

Back in the terminal, we are back where we started: sudo cd postgis-2.0.2

Run the following command

   sudo chmod 777 es.sh

Change user to postgres

   sudo su postgres

Rune the following command

  ./es.sh

Install Ruby 1.9.1

   sudo get-apt install ruby1.9.1

Install Node.js

   sudo apt-get install nodejs=0.8.26-1chl1~precise1

Install NPM

   sudo apt-get install npm=1.3.0-1chl1~precise1

Install Redis

   sudo apt-get install redis-server

Install EASY INSTALL

   sudo apt-get install python-setuptools

Install Python dependencies

  cd cartodb20
  sudo easy_install pip
  sudo pip install -r python_requirements.txt

Install Varnish

  sudo apt-get install varnish

Install Mapnik

  sudo apt-get install libmapnik-dev python-mapnik2 mapnik-utils


Install CartoDB SQL API

  git clone git://github.com/CartoDB/CartoDB-SQL-API.git
  cd CartoDB-SQL-API
  git checkout master
  npm install
  cd CartoDB-SQL-API
  cd config/environments/
  mv development.js.example development.js
  cd
  cd CartoDB-SQL-API 
  node app.js development

Install Windshaft-cartodb

   git clone git://github.com/CartoDB/Windshaft-cartodb.git
   cd Windshaft-cartodb
   git checkout master
   npm install
   cd config/environments/
   mv development.js.example development.js
   cd
   cd Windshaft-cartodb
   node app.js development

User Interface

Results

References