New answers tagged geospatial
Let's start off with what a regular query should look like: SELECT * FROM locations WHERE ST_Within(point_geom, ST_GeomFromText( 'POLYGON((50.4 8.2,50.3 9.3,49.9 9.5,49.7 8.8,49.9 7.8,50.4 8.2))', 4326)); If you want to make a purpose-made function to do a similar task: CREATE OR REPLACE FUNCTION ...
You need the PostgreSQL geometry functions. Specifically: <@ means Contained in or on?, thus calling: SELECT point '(1,1)' <@ circle '((0,0),2)' returns true.
You can use Entity Framework or Nhibernate.Spatial to speak to Sql Server. You'll have to solve the OpenLayers vector feature handling yourself in this case.
You can use Geoserver to connect to Sql Server, (you would need the SqlServer plugin for this) and then publish the data as WFS-T. On the client side you could use the Openlayers Editor
You can instantiate an output driver (e.g PNG/JPEG) and use that driver to create a copy of the wms on file. I don't code in C#, but the following python snippet should help, the methods will be the same/similar. ds=gdal.Open("<GDAL_WMS>etc...</GDAL_WMS>", gdal.GA_ReadOnly) outfile='C:/Temp/test.png' pngdrv=gdal.GetDriverByName('PNG') ...
Top 50 recent answers are included