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=#
.
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
- WFS data provider
- Delimited text data provider
- GDAL provider
- GPS eXchange format provider
- Memory provider
- OGR data provider (compiled against GDAL/OGR library version 1.6.3, running against GDAL/OGR library version 1.6.3)
- Open Street Map data provider
- PostgreSQL/PostGIS data provider
- SpatiaLite data provider
- OGC Web Map Service version 1.3 data provider
Available Qt Database Plugins
- QSQLITE
- QMYSQL3
- QMYSQL
- QODBC3
- QODBC
- QPSQL7
- QPSQL
Available Qt Image Plugins
Qt Image Plugin Search Paths
/usr/lib/qt/plugins
/usr/bin
- bmp
- gif
- ico
- jpeg
- jpg
- mng
- pbm
- pgm
- png
- ppm
- svg
- svgz
- tif
- tiff
- xbm
- xpm