Nothing fancy. Just a scratchboard for Open Source Geospatial manipulations. Involves (although not limited to) Linux, R, gdal, Quantum GIS, Geoserver etc.
Wednesday, August 25, 2010
Monday, August 23, 2010
Configuring postgresql in debian
After the installation from the debian packages, you should run :
sudo pg_createcluster 8.3 main
To make the server listen to the network edit /etc/postgresql/8.3/main/postgresql.conf and modify it to read :
listen_addresses = '*' # what IP address(es) to listen on;
and edit /etc/postgresql/8.3/main/pg_hba.conf and add a line for each user you would like to authorize the user called "myuser" who is located on network 201.171.245.62/32 for using the database "mydb" :
host mydb my user 201.171.245.62/32 md5
and then grant privileges to that user on the table geometry_columns :
psql mydb
GRANT select, insert, update, delete ON TABLE public.geometry_columns TO myuser;
sudo pg_createcluster 8.3 main
To make the server listen to the network edit /etc/postgresql/8.3/main/postgresql.conf and modify it to read :
listen_addresses = '*' # what IP address(es) to listen on;
and edit /etc/postgresql/8.3/main/pg_hba.conf and add a line for each user you would like to authorize the user called "myuser" who is located on network 201.171.245.62/32 for using the database "mydb" :
host mydb my user 201.171.245.62/32 md5
and then grant privileges to that user on the table geometry_columns :
psql mydb
GRANT select, insert, update, delete ON TABLE public.geometry_columns TO myuser;
debian : locales problem
export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales
Monday, August 9, 2010
Saturday, August 7, 2010
OpenStreetMap+PostGIS+Geoserver in Ubuntu
After a fresh install one needs to create access to PostgreSQL. Use the instructions in https://wiki.ubuntu.com/PostgreSQL Create the database "osm" createdb osm Prepare the database psql osm -c "ALTER TABLE spatial_ref_sys OWNER TO acizmeli" psql osm -c "ALTER TABLE geometry_columns OWNER TO acizmeli" psql -d osm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql (debian) psql -d osm -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql (debian) psql -d osm -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql createlang plpgsql osm Enable the projection SRS 900913 in PostGIS (Spherical Mercator) wget http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/900913.sql psql -f 900913.sql osm Downlod the OSM data files (for Turkey) http://downloads.cloudmade.com/asia/turkey#downloads_breadcrumbs Download the world coastline database (as described in http://wiki.openstreetmap.org/wiki/Mapnik) wget http://tile.openstreetmap.org/world_boundaries-spherical.tgz (50 MB) wget http://tile.openstreetmap.org/processed_p.tar.bz2 (357 MB) wget http://tile.openstreetmap.org/shoreline_300.tar.bz2 (48 MB) wget http://www.naturalearthdata.com/download/10m/cultural/10m-populated-places.zip (1.5 MB) wget http://www.naturalearthdata.com/download/110m/cultural/110m-admin-0-boundary-lines.zip (38 KB) Extract the Marmara region from the high resolution land polygon and assign the missing projection information "EPSG:3785" ogr2ogr -s_srs "EPSG:3785" -a_srs "EPSG:3785" -where "tile_x >= 228 AND tile_x <= 233 AND tile_y >= 248 AND tile_y <= 251" Marmara_land_polygon_EPSG_3785.shp processed_p.shp Edit the OSM data in JOSM and fix the following features : * Give the Küçükçekmece dam the attribute landuse=reservoir * Create the polygon for the Durugöl dam (which did not exist) Import the OSM data in PostGIS osm2pgsql -d osm OSM/turkey.osm Worked the coastline edges of the mahalle polygons in OpenJump for it to match those of Marmara_land_polygon. A shapefile output from OpenJump does not put projection info in the output file. To set it manually : ogr2ogr -a_srs EPSG:900913 mahalle_EPSG_900913_reworked.shp /WIN_C/Users/user/Desktop/mahalle_EPSG_900913_reworked.shp gdalwarp -wo SOURCE_EXTRA=125 -srcnodata "11 10 50" -dstalpha -t_srs '+proj=ortho +datum=WGS84' geoworld.tif ortho.tif
Subscribe to:
Posts (Atom)