Changes between Version 133 and Version 134 of UsersWikiMain
- Timestamp:
- 09/07/19 13:58:02 (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiMain
v133 v134 67 67 == Examples of Spatial SQL == 68 68 69 === Finding Features === 69 70 * [wiki:UsersWikiExamplesFindNearby Find Nearby Features] 70 71 * [wiki:UsersWikiExamplesFindNearbyLatLon Find Nearby Features in Lat/Lon (EPSG:4326)] 71 72 * [wiki:UsersWikiExamplesAntiNear Find Features far from nearest neighbor - Anti-Near Neighbor] 73 * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon] 74 * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring] 75 76 === Overlay === 77 72 78 * [wiki:UsersWikiExamplesJoinTables Join Spatial and Non-Spatial Tables] 73 79 * [wiki:UsersWikiExamplesOverlayTables Overlay Geometries in one table with Geometries in another] 74 * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon] 80 81 === Cleaning Geometry === 82 75 83 * [wiki:UsersWikiCleanPolygons Clean Invalid Polygon Topology] 76 * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring] 84 * [wiki:UsersWikiExamplesSpikeAnalyzer Determining spikes in polygons] 85 * [wiki:UsersWikiExamplesSpikeRemover Searching for spikes and removes them] 86 * [wiki:UsersWikiExamplesPolygonOverlaps Function finding overlapping polygons in a table and removing sliver overlappings] 87 * [wiki:UsersWikiCheckInvalidGeometriesFromGeometryColumns Function to test all tables from GeometryColumns for invalid geometries] 88 89 === Splitting Geometry === 90 77 91 * [wiki:UsersWikiSplitPolygonWithLineString Splitting a Polygon with a Linestring] 78 92 * [wiki:UsersWikiSplitPolygonWithPoints Splitting a table of Linestrings by a table of Points onto or close to the lines] 93 94 === Simplifying === 95 96 * [wiki:UsersWikiSimplifyPreserveTopology Simplifying a multipolygon layer, keeping existing connections between polygons (Not using topology extension)] 97 * [wiki:UsersWikiSimplifyWithTopologyExt Simplifying a multipolygon layer, using PostGIS Topology] 98 * [wiki:UsersWikiBufferCoast Illustration of the dilation/erosion technique for simplifying coastlines] 99 100 === Creating Polygons 101 79 102 * [wiki:UsersWikiBuildPolygonsWithLines Polygonize / building areas from non-noded linework] 103 104 === Generating Shapes === 105 80 106 * [wiki:UsersWikiCreateFishnet Create a fishnet grid (rectangular cells)] 81 107 * [wiki:UsersWikiGenerateHexagonalGrid Generating a hexagonal grid] 82 108 * [wiki:UsersWikiComputeMultiCentroid MultiPoint centroids from Multi geometries] 109 * [wiki:UserWikiRandomPoint Functions for creating random points inside a polygon] 110 * [wiki:UserWikiDotDensity Function used for creating dot density maps] 111 112 === Direction === 113 83 114 * [wiki:UsersWikiCardinalDirection Determine cardinal direction from azimuth direction] 115 116 === Linear Referencing === 117 118 * [wiki:UsersWikiExamplesInterpolateWithOffset Geocode a point along a line with a left/right offset] 119 120 === Topology === 121 122 * [wiki:UsersWikiTopologyExample Shell script showing basic construction of polygons from linestrings using topology] 123 * [wiki:PostgisTopology_Data_Model Schema explaining postgis topology data model] 124 * [wiki:UsersWikiExamplesNetworkTopology Create a network topology from a set of noded linestrings] 125 126 === Tools === 127 84 128 * [wiki:UsersWikiOGR Examples OGR Examples] 85 * [wiki:UsersWikiExamplesNetworkTopology Create a network topology from a set of noded linestrings]86 * [wiki:UsersWikiExamplesInterpolateWithOffset Geocode a point along a line with a left/right offset]87 * [wiki:UsersWikiExamplesSpikeAnalyzer Determining spikes in polygons]88 * [wiki:UsersWikiExamplesSpikeRemover Searching for spikes and removes them]89 129 * [wiki:UsersWikiBatchLoadShapefilesForWindowsUsingShp2pgsql Batch Load Shapefiles with shp2pgsql.exe on windows] 90 130 * [wiki:UsersWikiExamplesOverlayTables2 Set of functions for spatial overlay of 2 polygon tables] 91 * [wiki:UsersWikiExamplesPolygonOverlaps Function finding overlapping polygons in a table and removing sliver overlappings] 92 * [wiki:UsersWikiCheckInvalidGeometriesFromGeometryColumns Function to test all tables from GeometryColumns for invalid geometries] 93 * [wiki:UserWikiRandomPoint Functions for creating random points inside a polygon] 94 * [wiki:UserWikiDotDensity Function used for creating dot density maps] 95 * [wiki:UsersWikiSimplifyPreserveTopology Simplifying a multipolygon layer, keeping existing connections between polygons (Not using topology extension)] 96 * [wiki:UsersWikiSimplifyWithTopologyExt Simplifying a multipolygon layer, using PostGIS Topology] 97 * [wiki:UsersWikiTopologyExample Shell script showing basic construction of polygons from linestrings using topology] 98 * [wiki:UsersWikiBufferCoast Illustration of the dilation/erosion technique for simplifying coastlines] 99 * [wiki:PostgisTopology_Data_Model Schema explaining postgis topology data model] 131 100 132 101 133 == Extending PostGIS ==