2011-09-30

Slitaz -- pgadmin-1.10.0 / 1.14.0




Warning:

This version of pgAdmin has only been tested with PostgreSQL version 8.4 and below and may not function correctly with this server. Please upgrade pgAdmin.



tux@slitaz:~$ tazpkg info pgadmin

Tazpkg information
================================================================================
Package    : pgadmin
Version    : 1.10.0
Category   : utilities
Short desc : PostgreSQL administration an management tools
Maintainer : erjo@slitaz.org
Depends    : postgresql wxWidgets gtk+ libxslt libcomerr3 libkrb5 xorg-libXxf86vm
Build deps : libcrypto postgresql postgresql-dev libxslt-dev libxml2-dev wxWidgets-dev
Web site   : http://www.pgadmin.org
================================================================================

tux@slitaz:~$ tazpkg info postgresql

Tazpkg information
================================================================================
Package    : postgresql
Version    : 9.0.4
Category   : misc
Short desc : SQL database system.
Maintainer : pascal.bellard@slitaz.org
Depends    : postgresql-client slitaz-base-files
Build deps : zlib-dev readline-dev ncurses-dev bison flex perl libxslt
Web site   : http://www.postgresql.org/
================================================================================

tux@slitaz:~$

2011-09-15

Slitaz -- QGIS - GDAL


Quantum GIS (QGIS)
GDAL - Geospatial Data Abstraction Library

1.
tux@slitaz:~$ uname -a
Linux slitaz 2.6.37-slitaz #2 SMP Sat May 21 19:25:28 CEST 2011 i686 GNU/Linux

2.
tux@slitaz:~$ df -h
Filesystem                Size      Used Available Use% Mounted on
tmpfs                     2.9G    511.4M      2.4G  17% /
tmpfs                     1.6G         0      1.6G   0% /dev/shm


3.
tux@slitaz:~$ tazpkg list | tail -2
297 packages installed.


4.
tux@slitaz:~$ tazpkg info qgis

Tazpkg information
================================================================================
Package    : qgis
Version    : 1.7.0
Category   : misc
Short desc : Geographic Information System (GIS)
Maintainer :
Web site   : http://www.qgis.org
================================================================================

tux@slitaz:~$

5.
tux@slitaz:~$ tazpkg info gdal

Tazpkg information
================================================================================
Package    : gdal
Version    : 1.8.1
Category   : misc
Short desc : Geospatial Data Abstraction Library
Maintainer :
Web site   : http://www.gdal.org/
================================================================================

tux@slitaz:~$ gdal-config --version
1.8.1

6.
tux@slitaz:~$ gdal-config --dep-libs
-L/usr/lib -lgeos_c -lsqlite3 -lodbc -lodbcinst -lexpat -lxerces-c -lpthread -ljasper -lhdf5 -lmfhdfalt -ldfalt -logdi -lgif -ljpeg -lpng -lnetcdf -L/usr/lib/postgresql -lpq -lz -lpthread -lm -lrt -ldl -lcurl

7.
tux@slitaz:~$ gdal-config --formats
gxf gtiff hfa aigrid aaigrid ceos ceos2 iso8211 xpm sdts raw dted mem jdem envisat elas fit vrt usgsdem l1b nitf bmp pcidsk airsar rs2 ilwis rmf leveller sgi srtmhgt idrisi gsg ingr ers jaxapalsar dimap gff cosar pds adrg coasp tsx terragen blx msgn til r northwood saga xyz hf2 kmlsuperoverlay ozi wcs wms grib bsb jpeg2000 hdf5 hdf4 ogdi gif jpeg png netcdf pcraster rik rasterlite postgisraster

8.
tux@slitaz:~$ gdalinfo --formats
Supported Formats:
  VRT (rw+v): Virtual Raster
  GTiff (rw+v): GeoTIFF
  NITF (rw+v): National Imagery Transmission Format
  RPFTOC (rov): Raster Product Format TOC format
  HFA (rw+v): Erdas Imagine Images (.img)
  SAR_CEOS (rov): CEOS SAR Image
  CEOS (rov): CEOS Image
  JAXAPALSAR (ro): JAXA PALSAR Product Reader (Level 1.1/1.5)
  GFF (rov): Ground-based SAR Applications Testbed File Format (.gff)
  ELAS (rw+): ELAS
  AIG (rov): Arc/Info Binary Grid
  AAIGrid (rwv): Arc/Info ASCII Grid
  SDTS (rov): SDTS Raster
  OGDI (ro): OGDI Bridge
  DTED (rwv): DTED Elevation Raster
  PNG (rwv): Portable Network Graphics
  JPEG (rwv): JPEG JFIF
  MEM (rw+): In Memory Raster
  JDEM (ro): Japanese DEM (.mem)
  GIF (rwv): Graphics Interchange Format (.gif)
  BIGGIF (rov): Graphics Interchange Format (.gif)
  ESAT (ro): Envisat Image Format
  BSB (rov): Maptech BSB Nautical Charts
  XPM (rwv): X11 PixMap Format
  BMP (rw+v): MS Windows Device Independent Bitmap
  DIMAP (rov): SPOT DIMAP
  AirSAR (ro): AirSAR Polarimetric Image
  RS2 (ro): RadarSat 2 XML Product
  PCIDSK (rw+v): PCIDSK Database File
  PCRaster (rw): PCRaster Raster File
  ILWIS (rw+v): ILWIS Raster Map
  SGI (rw+): SGI Image File Format 1.0
  SRTMHGT (rwv): SRTMHGT File Format
  Leveller (rw+): Leveller heightfield
  Terragen (rw+): Terragen heightfield
  GMT (rw): GMT NetCDF Grid Format
  netCDF (rw): Network Common Data Format
  HDF4 (ro): Hierarchical Data Format Release 4
  HDF4Image (rw+): HDF4 Dataset
  ISIS3 (rov): USGS Astrogeology ISIS cube (Version 3)
  ISIS2 (rov): USGS Astrogeology ISIS cube (Version 2)
  PDS (rov): NASA Planetary Data System
  TIL (ro): EarthWatch .TIL
  ERS (rw+): ERMapper .ers Labelled
  JPEG2000 (rwv): JPEG-2000 part 1 (ISO/IEC 15444-1)
  L1B (ro): NOAA Polar Orbiter Level 1b Data Set
  FIT (rwv): FIT Image
  GRIB (rov): GRIdded Binary (.grb)
  RMF (rw+): Raster Matrix Format
  WCS (ro): OGC Web Coverage Service
  WMS (ro): OGC Web Map Service
  MSGN (ro): EUMETSAT Archive native (.nat)
  RST (rw+): Idrisi Raster A.1
  INGR (rw+v): Intergraph Raster
  GSAG (rw): Golden Software ASCII Grid (.grd)
  GSBG (rw+): Golden Software Binary Grid (.grd)
  GS7BG (ro): Golden Software 7 Binary Grid (.grd)
  COSAR (ro): COSAR Annotated Binary Matrix (TerraSAR-X)
  TSX (ro): TerraSAR-X Product
  COASP (ro): DRDC COASP SAR Processor Raster
  R (rwv): R Object Data Store
  PNM (rw+): Portable Pixmap Format (netpbm)
  DOQ1 (ro): USGS DOQ (Old Style)
  DOQ2 (ro): USGS DOQ (New Style)
  ENVI (rw+v): ENVI .hdr Labelled
  EHdr (rw+v): ESRI .hdr Labelled
  GenBin (ro): Generic Binary (.hdr Labelled)
  PAux (rw+): PCI .aux Labelled
  MFF (rw+): Vexcel MFF Raster
  MFF2 (rw+): Vexcel MFF2 (HKV) Raster
  FujiBAS (ro): Fuji BAS Scanner Image
  GSC (ro): GSC Geogrid
  FAST (ro): EOSAT FAST Format
  BT (rw+): VTP .bt (Binary Terrain) 1.3 Format
  LAN (rov): Erdas .LAN/.GIS
  CPG (ro): Convair PolGASP
  IDA (rw+): Image Data and Analysis
  NDF (ro): NLAPS Data Format
  EIR (rov): Erdas Imagine Raw
  DIPEx (ro): DIPEx
  LCP (rov): FARSITE v.4 Landscape File (.lcp)
  GTX (rw+v): NOAA Vertical Datum .GTX
  LOSLAS (rov): NADCON .los/.las Datum Grid Shift
  NTv2 (rw+v): NTv2 Datum Grid Shift
  RIK (ro): Swedish Grid RIK (.rik)
  USGSDEM (rw): USGS Optional ASCII DEM (and CDED)
  GXF (ro): GeoSoft Grid Exchange Format
  HTTP (ro): HTTP Fetching Wrapper
  BAG (ro): Bathymetry Attributed Grid
  HDF5 (ro): Hierarchical Data Format Release 5
  HDF5Image (ro): HDF5 Dataset
  NWT_GRD (ro): Northwood Numeric Grid Format .grd/.tab
  NWT_GRC (ro): Northwood Classified Grid Format .grc/.tab
  ADRG (rw+v): ARC Digitized Raster Graphics
  SRP (rov): Standard Raster Product (ASRP/USRP)
  BLX (rw): Magellan topo (.blx)
  Rasterlite (rw): Rasterlite
  PostGISRaster (ro): PostGIS Raster driver
  SAGA (rw+v): SAGA GIS Binary Grid (.sdat)
  KMLSUPEROVERLAY (rwv): Kml Super Overlay
  XYZ (rwv): ASCII Gridded XYZ
  HF2 (rwv): HF2/HFZ heightfield raster
  OZI (rov): OZI

9.
tux@slitaz:~$ ogrinfo --formats
Supported Formats:
  -> "ESRI Shapefile" (read/write)
  -> "MapInfo File" (read/write)
  -> "UK .NTF" (readonly)
  -> "SDTS" (readonly)
  -> "TIGER" (read/write)
  -> "S57" (read/write)
  -> "DGN" (read/write)
  -> "VRT" (readonly)
  -> "REC" (readonly)
  -> "Memory" (read/write)
  -> "BNA" (read/write)
  -> "CSV" (read/write)
  -> "NAS" (readonly)
  -> "GML" (read/write)
  -> "GPX" (read/write)
  -> "KML" (read/write)
  -> "GeoJSON" (read/write)
  -> "Interlis 1" (read/write)
  -> "Interlis 2" (read/write)
tux@slitaz:~$
.

2011-09-12

Slitaz -- postgis-1.5.3 -2

1.
postgres@slitaz:~$ tazpkg list-files postgis
Installed files with: postgis
================================================================================
/usr/bin/pgsql2shp
/usr/bin/shp2pgsql
/usr/lib/postgresql/postgis-1.5.so
/usr/share/postgresql/contrib/postgis-1.5/postgis.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_14_to_15.sql
/usr/share/postgresql/contrib/postgis-1.5/postgis_upgrade_15_minor.sql
/usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql
/usr/share/postgresql/contrib/postgis-1.5/uninstall_postgis.sql
================================================================================
9 files installed with postgis.

2.
postgres@slitaz:~$ createdb -E utf-8 -T template0 --owner=postgis gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/postgis.sql -d gis
postgres@slitaz:~$ psql -f /usr/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql -d gis

3.
postgres@slitaz:~$ psql -U postgis -d gis
psql (9.0.4)
Type "help" for help.

gis=# \set
AUTOCOMMIT = 'on'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
VERBOSITY = 'default'
VERSION = 'PostgreSQL 9.0.4 on i486-slitaz-linux-gnu, compiled by GCC i486-slitaz-linux-gcc (SliTaz) 4.5.2, 32-bit'
DBNAME = 'gis'
USER = 'postgis'
PORT = '5432'
ENCODING = 'UTF8'

4.
gis=# select lanname from pg_language;
 lanname
----------
 internal
 c
 sql
 plpgsql
(4 rows)

5.
gis=# \d
               List of relations
 Schema |       Name        | Type  |  Owner 
--------+-------------------+-------+----------
 public | geography_columns | view  | postgres
 public | geometry_columns  | table | postgres
 public | spatial_ref_sys   | table | postgres
(3 rows)

6.
gis=# \d spatial_ref_sys
         Table "public.spatial_ref_sys"
  Column   |          Type           | Modifiers
-----------+-------------------------+-----------
 srid      | integer                 | not null
 auth_name | character varying(256)  |
 auth_srid | integer                 |
 srtext    | character varying(2048) |
 proj4text | character varying(2048) |
Indexes:
    "spatial_ref_sys_pkey" PRIMARY KEY, btree (srid)

7.
gis=# select count(*) from spatial_ref_sys;
 count
-------
  3749
(1 row)

8.
gis=# select * from spatial_ref_sys limit 2;
 srid | auth_name | auth_srid |                                                                                                                                                                    srtext                                                                                                                                                                     |                                           proj4text                                          
------+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------
 3819 | EPSG      |      3819 | GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3819"]] | +proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs
 3821 | EPSG      |      3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]]                                                                 | +proj=longlat +ellps=aust_SA +no_defs  
(2 rows)

9.
gis=# select srid,srtext from spatial_ref_sys where srid=3821;
 srid |                                                                                                                                    srtext                                                                                                                                   
------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3821 | GEOGCS["TWD67",DATUM["Taiwan_Datum_1967",SPHEROID["GRS 1967 Modified",6378160,298.25,AUTHORITY["EPSG","7050"]],AUTHORITY["EPSG","1025"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","3821"]]
(1 row)

gis=#
.

Slitaz -- postgis-1.5.3

PostGIS 1.5.3 Release

The 1.5.3 release of PostGIS is now available. This is a minor release addressing a few issues that have been filed since the 1.5.2 release in addition to fixes that allow it to compile against PostgreSQL 9.1beta.

1.
 postgres@slitaz:~$ psql -U postgis -d gis
psql (9.0.4)
Type "help" for help.

2.
gis=# select version();
                                                 version                                               
---------------------------------------------------------------------------------------------------------
 PostgreSQL 9.0.4 on i486-slitaz-linux-gnu, compiled by GCC i486-slitaz-linux-gcc (SliTaz) 4.5.2, 32-bit
(1 row)

3.
gis=# select postgis_full_version();
                                         postgis_full_version                                        
-------------------------------------------------------------------------------------------------------
 POSTGIS="1.5.3" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS
(1 row)

4.
gis=# \! tazpkg info postgis

Tazpkg information
================================================================================
Package    : postgis
Version    : 1.5.3
Category   : misc
Short desc : geographic objects support for PostgreSQL
Maintainer :
Depends    : proj geos
Build deps : proj geos
Web site   : http://postgis.org/
================================================================================

5.
gis=# \q
postgres@slitaz:~$
.

2011-09-07

Slitaz -- QGIS 1.7



Quantum GIS Documentation
Version 1.7.0 Wrocław
Please read this entire document for important information about this release.
You find a PDF manual of the current version on the QGIS website.

Whats new in Version 1.7.0 'Wrocław'?

This release is named after the town of Wrocław in Poland. The Department of Climatology and Atmosphere Protection, University of Wrocław kindly hosted our developer meeting in November 2010. Please note that this is a release in our 'cutting edge' release series. As such it contains new features and extends the programmatic interface over QGIS 1.0.x and QGIS 1.6.0. As with any software, there may be bugs and issues that we were not able to fix in time for the release. We therefore recommend that you test this version before rolling it out en-masse to your users.
This release includes over 277 bug fixes and many new features and enhancements. Once again it is impossible to document everything here that has changed so we will just provide a bullet list of key new features here.
[..]


 Available QGIS Data Provider Plugins

  1. WFS data provider
  2. Delimited text data provider
  3. GDAL provider
  4. GPS eXchange format provider
  5. Memory provider
  6. OGR data provider (compiled against GDAL/OGR library version 1.6.3, running against GDAL/OGR library version 1.6.3)
  7. Open Street Map data provider
  8. PostgreSQL/PostGIS data provider
  9. SpatiaLite data provider
  10. OGC Web Map Service version 1.3 data provider

Available Qt Database Plugins

  1. QSQLITE
  2. QMYSQL3
  3. QMYSQL
  4. QODBC3
  5. QODBC
  6. QPSQL7
  7. QPSQL

Available Qt Image Plugins
Qt Image Plugin Search Paths
/usr/lib/qt/plugins
/usr/bin

  1. bmp
  2. gif
  3. ico
  4. jpeg
  5. jpg
  6. mng
  7. pbm
  8. pgm
  9. png
  10. ppm
  11. svg
  12. svgz
  13. tif
  14. tiff
  15. xbm
  16. xpm