544 reputation
17
bio website
location
age
visits member for 7 months
seen 2 hours ago
stats profile views 46

Dec
20
asked How can I merge segments to one segment in QGIS (picture inside) and than get the center of each road?
Dec
20
comment Openlayers layer hide javascript menu
Attached example : hadav.com/ZIndexTest/Assets/ShowAssetsTable.aspx Ignore the error message, its just example :)
Dec
17
comment Is there a way to get centroid of geographic object in MSSQL?
I probably lost you. I have sql DB with geographic objects. I want to get a lat lon column for each object so I can center the map on it (it doesn't have to show the entire road or zoom to extent) I just need coords to center map on .
Dec
17
comment Is there a way to get centroid of geographic object in MSSQL?
I'm a programmer , not GIS person , So my choice of words might be wrong. I'm looking to get a lat/lon that I can center the map on. preferred the middle of the road.
Dec
17
comment How can I get nearest road to a lat lon in MSSQL?
Basically it was VERY easy. Thank you.
Dec
17
asked Is there a way to get centroid of geographic object in MSSQL?
Dec
17
comment Openlayers layer hide javascript menu
U2ros - Yes it does. Aragon - I'm not sure I can show the app because of NDA. If I won't solve it soon I'll have to do something about it.
Dec
16
asked Openlayers layer hide javascript menu
Dec
16
comment Can osm way records in SQL spatial be merged to one geographic record if they have same Id?
I've used OSM2MSSQL.
Dec
15
asked Can osm way records in SQL spatial be merged to one geographic record if they have same Id?
Dec
15
answered How can I relate between street and city in OSM imported data into SQL?
Dec
15
comment How can I relate between street and city in OSM imported data into SQL?
Thank you bhell. What I did is creating a geographic POLYGON and using STContains on roads.
Dec
15
accepted How can I get nearest road to a lat lon in MSSQL?
Dec
14
comment How can I get nearest road to a lat lon in MSSQL?
Can you please show me query example? Never used spatial before.
Dec
13
awarded  Tumbleweed
Dec
13
comment How can I get nearest road to a lat lon in MSSQL?
I'll try to be clear. I'm using OpenLayers to show OSM map of a specific area. I want to be able to click on the map and "get info" from it that I'll store in MSSQL (2008 or 2012 , doesn't matter for me). My plan is to get the clicked point geometry using draw feature and with that query the DB and bring back result. Question is , How I get the closet geographic object from the DB for that specific Point.
Dec
13
asked How can I get nearest road to a lat lon in MSSQL?
Dec
13
asked How can I relate between street and city in OSM imported data into SQL?
Dec
13
comment Which WMS is easiest to work with when using QGIS?
I've tried setting it on windows using your guide but it doesn't work. I've posted a question about it .
Dec
13
accepted What are the most common functions a GIS web app should have?