Class Giscuit_Db_Table_GeometryTables

Description

Class for geometry tables table

  • copyright: Copyright (c) 2012 VEC

Located in /Db/Table/GeometryTables.php (line 28)

Zend_Db_Table_Abstract
   |
   --Giscuit_Db_Table_Abstract
      |
      --Giscuit_Db_Table_GeometryTables
Variable Summary
 array $columnTypes
 string $_name
 string $_primary
 string $_schema
Method Summary
 static getPostgisVersion () string
 deleteTable (string $tableName, [string $schema = NULL]) void
 getAllSpatialRefSys ([ $options = array()]) array
 getAllTables ([ $options = array()]) array
 getItems ([ $options = array()]) Zend_Db_Table_Rowset
 getProjTextBySrid (integer $srid) Zend_Db_Table_Row
Variables
array $columnTypes = array(
'int2' => 'smallint' ,
'int4' => 'integer' ,
'int8' => 'bigint' ,
'float4' => 'real' ,
'float8' => 'double precision' ,
'numeric' => 'numeric' ,
'varchar' => 'character varying' ,
'bpchar' => 'character' ,
'text' => 'text' ,
'bytea' => 'bytea' ,
'timestamp' => 'timestamp without time zone' ,
'timestamptz' => 'timestamp with time zone' ,
'interval' => 'interval' ,
'date' => 'date' ,
'time' => 'time without time zone' ,
'timetz' => 'time with time zone' ,
'bool' => 'boolean' ,
'geometry' => 'geometry'
)
(line 57)

Table column types

  • access: public
string $_name = 'geometry_columns' (line 36)

Table name

  • access: protected
string $_primary = 'f_table_name' (line 43)

Table primary key name

  • access: protected

Redefinition of:
Giscuit_Db_Table_Abstract::$_primary
Table primary key name
string $_schema = 'public' (line 50)

Table schema name

  • access: protected
Methods
static getPostgisVersion (line 314)

Get current PostGIS version

  • access: public
string getPostgisVersion ()
deleteTable (line 294)

Delete specified table

  • access: public
void deleteTable (string $tableName, [string $schema = NULL])
  • string $tableName: Name of the table
  • string $schema: Database schema
getAllSpatialRefSys (line 226)

Get all spatial reference systems

  • access: public
array getAllSpatialRefSys ([ $options = array()])
  • array $options
getAllTables (line 143)

Get all database tables

  • return: All tables
  • access: public
array getAllTables ([ $options = array()])
  • array $options: Available options:
    • schema string - Database schema
    • withGeometryTables bool - Include geometry tables
    • whereTables string - Get results that match this comma separated list of tables
getItems (line 88)

Get geometry columns

  • access: public
Zend_Db_Table_Rowset getItems ([ $options = array()])
  • array $options: Available options:
    • asArray bool - Get results as array
    • withHistorySchema bool - Also check the hisdtory schema tables
    • whereTables string - Get results that match this comma separated list of tables
    • whereName string - Get results where table name matches this parameter
getProjTextBySrid (line 273)

Get projection by srid

  • access: public
Zend_Db_Table_Row getProjTextBySrid (integer $srid)
  • integer $srid: Srid value

Inherited Methods

Inherited From Giscuit_Db_Table_Abstract

 Giscuit_Db_Table_Abstract::__construct()
 Giscuit_Db_Table_Abstract::count()
 Giscuit_Db_Table_Abstract::getPrimaryKey()
 Giscuit_Db_Table_Abstract::joinMultilangField()
 Giscuit_Db_Table_Abstract::moveItem()
 Giscuit_Db_Table_Abstract::whereActive()
 Giscuit_Db_Table_Abstract::whereCurrentUser()
 Giscuit_Db_Table_Abstract::whereId()

Documentation generated on Fri, 23 Nov 2012 13:01:44 +0000 by phpDocumentor 1.4.3