Changes between Version 133 and Version 134 of UsersWikiMain

Timestamp:

Sep 7, 2019, 1:58:02 PM (5 years ago)

Author:

mdavis

Comment:

—

UsersWikiMain

@@ -67 +67 @@
 == Examples of Spatial SQL ==
 
+=== Finding Features ===
  * [wiki:UsersWikiExamplesFindNearby Find Nearby Features]
  * [wiki:UsersWikiExamplesFindNearbyLatLon Find Nearby Features in Lat/Lon (EPSG:4326)]
  * [wiki:UsersWikiExamplesAntiNear Find Features far from nearest neighbor - Anti-Near Neighbor]
+ * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon]
+ * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring]
+
+=== Overlay ===
+
  * [wiki:UsersWikiExamplesJoinTables Join Spatial and Non-Spatial Tables]
  * [wiki:UsersWikiExamplesOverlayTables Overlay Geometries in one table with Geometries in another]
- * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon]
+
+=== Cleaning Geometry ===
+
  * [wiki:UsersWikiCleanPolygons Clean Invalid Polygon Topology]
- * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring]
+ * [wiki:UsersWikiExamplesSpikeAnalyzer Determining spikes in polygons]
+ * [wiki:UsersWikiExamplesSpikeRemover Searching for spikes and removes them]
+ * [wiki:UsersWikiExamplesPolygonOverlaps Function finding overlapping polygons in a table and removing sliver overlappings]
+* [wiki:UsersWikiCheckInvalidGeometriesFromGeometryColumns Function to test all tables from GeometryColumns for invalid geometries]
+
+=== Splitting Geometry ===
+
  * [wiki:UsersWikiSplitPolygonWithLineString Splitting a Polygon with a Linestring]
  * [wiki:UsersWikiSplitPolygonWithPoints Splitting a table of Linestrings by a table of Points onto or close to the lines]
+
+=== Simplifying ===
+
+ * [wiki:UsersWikiSimplifyPreserveTopology Simplifying a multipolygon layer, keeping existing connections between polygons (Not using topology extension)]
+ * [wiki:UsersWikiSimplifyWithTopologyExt Simplifying a multipolygon layer, using PostGIS Topology]
+ * [wiki:UsersWikiBufferCoast Illustration of the dilation/erosion technique for simplifying coastlines]
+
+=== Creating Polygons
+
  * [wiki:UsersWikiBuildPolygonsWithLines Polygonize / building areas from non-noded linework]
+
+=== Generating Shapes ===
+
  * [wiki:UsersWikiCreateFishnet Create a fishnet grid (rectangular cells)]
  * [wiki:UsersWikiGenerateHexagonalGrid Generating a hexagonal grid]
  * [wiki:UsersWikiComputeMultiCentroid MultiPoint centroids from Multi geometries]
+ * [wiki:UserWikiRandomPoint Functions for creating random points inside a polygon]
+ * [wiki:UserWikiDotDensity Function used for creating dot density maps]
+
+=== Direction ===
+
  * [wiki:UsersWikiCardinalDirection Determine cardinal direction from azimuth direction]
+
+=== Linear Referencing ===
+
+ * [wiki:UsersWikiExamplesInterpolateWithOffset Geocode a point along a line with a left/right offset]
+
+=== Topology ===
+
+ * [wiki:UsersWikiTopologyExample Shell script showing basic construction of polygons from linestrings using topology]
+ * [wiki:PostgisTopology_Data_Model Schema explaining postgis topology data model]
+ * [wiki:UsersWikiExamplesNetworkTopology Create a network topology from a set of noded linestrings]
+
+=== Tools ===
+
  * [wiki:UsersWikiOGR Examples OGR Examples]
- * [wiki:UsersWikiExamplesNetworkTopology Create a network topology from a set of noded linestrings]
- * [wiki:UsersWikiExamplesInterpolateWithOffset Geocode a point along a line with a left/right offset]
- * [wiki:UsersWikiExamplesSpikeAnalyzer Determining spikes in polygons]
- * [wiki:UsersWikiExamplesSpikeRemover Searching for spikes and removes them]
  * [wiki:UsersWikiBatchLoadShapefilesForWindowsUsingShp2pgsql Batch Load Shapefiles with shp2pgsql.exe on windows]
  * [wiki:UsersWikiExamplesOverlayTables2 Set of functions for spatial overlay of 2 polygon tables]
- * [wiki:UsersWikiExamplesPolygonOverlaps Function finding overlapping polygons in a table and removing sliver overlappings]
- * [wiki:UsersWikiCheckInvalidGeometriesFromGeometryColumns Function to test all tables from GeometryColumns for invalid geometries]
- * [wiki:UserWikiRandomPoint Functions for creating random points inside a polygon]
- * [wiki:UserWikiDotDensity Function used for creating dot density maps]
- * [wiki:UsersWikiSimplifyPreserveTopology Simplifying a multipolygon layer, keeping existing connections between polygons (Not using topology extension)]
- * [wiki:UsersWikiSimplifyWithTopologyExt Simplifying a multipolygon layer, using PostGIS Topology]
- * [wiki:UsersWikiTopologyExample Shell script showing basic construction of polygons from linestrings using topology]
- * [wiki:UsersWikiBufferCoast Illustration of the dilation/erosion technique for simplifying coastlines]
- * [wiki:PostgisTopology_Data_Model Schema explaining postgis topology data model]
+
 
 == Extending PostGIS ==