418 reputation
25
bio website bhell.net
location Sweden
age
visits member for 2 years, 1 month
seen Mar 11 at 13:15

Nov
22
awarded  Yearling
Sep
30
awarded  Explainer
Nov
22
awarded  Yearling
Sep
17
answered Anything similar to TMS or WMTS for WFS?
May
22
comment Leaflet proj4leaflet with multiple projections
You are missing one problem: One coordinate unit in plate carrée (say one degree) does not have the same length in N-S and E-W direction. In Sweden (where I live), a degree in longitude is about half the length of one degree in latitude. That means that a 1x1 degree square is not at all a square in reality. To cover a (real) square with plate carrée squares here, you actually need about two such squares next to each other (for simplification consider "Web Mercator" to resemble reality in this case). This means that the tiles will not align.
May
21
revised Leaflet proj4leaflet with multiple projections
Major update of post based on additional information to the question.
May
21
comment Leaflet proj4leaflet with multiple projections
I'll add some more stuff to my previous answer.
May
20
revised Leaflet proj4leaflet with multiple projections
Corrected spelling of library, and added a little more info to the title
May
20
awarded  Editor
May
20
revised Leaflet proj4leaflet with multiple projections
Structured better, added link to feature request
May
20
suggested approved edit on Leaflet proj4leaflet with multiple projections
May
20
answered Leaflet proj4leaflet with multiple projections
Feb
11
comment How to create contour from NetCDF?
ArcGIS can read NetCDF directly as raster data, so there is no need to modify the dataset by interpolation, kriging etc.: help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/…
Feb
10
comment How to create contour from NetCDF?
NetCDF is a standard raster format, so I don't understand what you mean with creating a raster of it. It would help if you could clarify what you tried and what you could not achieve.
Dec
17
answered Using OpenLayers with OSM as map
Dec
14
awarded  Commentator
Dec
14
comment How can I get nearest road to a lat lon in MSSQL?
According to the documentation, STDistance works with geography, not geometry points. As distances are calculated differently for geographical and cartesian coordinates, the result may be unexpected (I don't have access to a DB right now to test myself). If you stick to one coordinate system (which you should because of computation overhead for re-projecting), there is no need for another DBMS here. PostGIS, Oracle Spatial and SQL Server Spatial are all very capable solutions, and have all their own advantages and disadvantages.
Dec
14
comment How can I get nearest road to a lat lon in MSSQL?
The stackexchange thread which I linked to has a complete example. As I mentioned, this is not a trivial query, and it will depend on how your data model looks like.
Dec
13
comment How can I get nearest road to a lat lon in MSSQL?
In that case you could filter your data with the shown map extent first, and then run the STDistance query on the result.
Dec
13
comment How can I relate between street and city in OSM imported data into SQL?
You would need a Cities table with at least attributes for name and spatial extent (as a polygon). Then you would perform a join between Streets and Cities based on spatial overlap/contains. The query result is all roads with a corresponding city name attribute. For a single city the documentation example for STOverlaps should be very close to your needed query.