Changes between Version 139 and Version 140 of UsersWikiMain


Ignore:
Timestamp:
Aug 5, 2020, 9:08:21 AM (4 years ago)
Author:
mdavis
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiMain

    v139 v140  
    1212PostGIS is an extension  to the  [http://www.postgresql.org PostgreSQL] object-relational database system that allows [http://en.wikipedia.org/wiki/Geographic_information_system GIS] (Geographic Information System) objects to be stored in the database.
    1313PostGIS does for PostgreSQL what Oracle Spatial does for Oracle, ArcSDE does for Microsoft SQL !Server/Oracle.
     14
     15PostGIS uses [http://geos.osgeo.org GEOS] to implement many spatial functions.
     16GEOS is a C++ port of the [http://en.wikipedia.org/wiki/JTS_Topology_Suite JTS Topology Suite].
    1417
    1518 * [http://s3.cleverelephant.ca/foss4gna2012-postgis2.pdf (slides) FOSS4G NA 2012 What's New in PostGIS 2.0] Paul Ramsey
    … …  
    6467 * [http://www.postgis.us/chapters_edition_1 PostGIS in Action (1st Edition)] by Regina Obe and Leo Hsu - It's out and available via various distributors including Manning Publications and Amazon. If you want just the E-Book, purchase directly from Manning.  The E-book is about 50% off the hard-copy price. With the purchase of Hard-copy, there is a free-coupon to get the E-Book version. Book includes PostGIS 1.3-1.5, PostgreSQL 8.3-9.0 (with upcoming highlights of PostgreSQL 9.1 and PostGIS 2.0).   All code and data downloads available for free on the book site even if you don't buy the book.  [http://www.postgis.us/chapter_01_edition_1 Chapter 1 (a primer on PostGIS )] and [http://www.postgis.us/chapter_appendix_c_edition_1 Appendix C (a primer on SQL)] are free downloads.
    6568
     69== Frequently Asked Questions ==
     70
     71 * [wiki:UsersWikiNewbieAddgeometrycolumn function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist]
     72 * [wiki:UsersWikiNewbieDistanceMeasurement What is the measurement returned by ST_Distance?]
     73 * [wiki:UsersWikiNewbiePostGISFunctionMeasurement What unit of measurement do PostGIS functions use?]
     74 * [wiki:UsersWikiNewbieMeasurementInMeters How to get distance measurement in meters?]
    6675
    6776== Examples of Spatial SQL ==
    … …  
    134143 * [wiki:UsersWikiBatchLoadShapefilesForWindowsUsingShp2pgsql Batch Load Shapefiles with shp2pgsql.exe on windows]
    135144 * [wiki:UsersWikiExamplesOverlayTables2 Set of functions for spatial overlay of 2 polygon tables]
     145 * [wiki:UsersWikiNbSqlFunctionsEditor Netbeans SQL Editor with (PostGIS) functions autocompletion and documentation]
     146 * [wiki:UsersWikiQGIS Using QGis to display PostGis Layers]
    136147
     148== Useful PL/PGSQL Functions ==
     149 * [wiki:UsersWikiplpgsqlfunctions PL/PGSQL Functions]
     150 * [wiki:UsersWikiGeographyFunctions Functions that work specifically for the geography type]
     151 * [wiki:UsersWikiwktrasterfunctions WKT Raster Helper Functions]
     152 * [wiki:UsersWikiNearest Neighbor Search Nearest Neighbor Search]
     153 * [wiki:UsersWikiCascadeUnion PL/PGSQL Pseudo Cascade Union Aggregate Function (use for pre-PostGIS 1.4)]
    137154
    138155== Extending PostGIS ==
    … …  
    148165 * [wiki:pgRouting] routing with PostGIS
    149166
    150 == Frequently Asked Questions ==
    151 
    152  * [wiki:UsersWikiNewbieAddgeometrycolumn function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist]
    153  * [wiki:UsersWikiNewbieDistanceMeasurement What is the measurement returned by ST_Distance?]
    154  * [wiki:UsersWikiNewbiePostGISFunctionMeasurement What unit of measurement do PostGIS functions use?]
    155  * [wiki:UsersWikiNewbieMeasurementInMeters How to get distance measurement in meters?]
    156 
    157 == Extras ==
    158 
    159  * [wiki:UsersWikiNbSqlFunctionsEditor Netbeans SQL Editor with (PostGIS) functions autocompletion and documentation]
    160  * [wiki:UsersWikiQGIS Using QGis to display PostGis Layers]
    161 
    162167== Notes ==
    163168
    164169 * [wiki:UsersWikiSpatialAlgorithmWebSites Spatial Algorithm Web Sites]
    165170
    166 == Useful Additional PL/PGSQL Functions ==
    167  * [wiki:UsersWikiplpgsqlfunctions PL/PGSQL Functions]
    168  * [wiki:UsersWikiGeographyFunctions Functions that work specifically for the geography type]
    169  * [wiki:UsersWikiwktrasterfunctions WKT Raster Helper Functions]
    170  * [wiki:UsersWikiNearest Neighbor Search Nearest Neighbor Search]
    171  * [wiki:UsersWikiCascadeUnion PL/PGSQL Pseudo Cascade Union Aggregate Function (use for pre-PostGIS 1.4)]
    172171
    173 == What is GEOS ==
    174 
    175 [http://geos.osgeo.org GEOS] is a C++ port of the [http://en.wikipedia.org/wiki/JTS_Topology_Suite JTS Topology Suite]. It is used by PostGIS to implement Topological functions.