623 reputation
1519
bio website
location Ukraine, Kharkov
age 26
visits member for 2 years
seen yesterday

GIS Engineer.

I use QGIS, ArcGIS, PostgreSQL/PostGIS, Geoserver, Leaflet.

Skype: a.hast


Aug
19
awarded  Constituent
Aug
12
awarded  Caucus
Aug
7
answered How to use Leaflet Marker Cluster on markers from Leaflet-layerJSON (Overpass API)
Aug
5
comment Is it possible to drag&drop line precisely 6 meters to right or left?
Try QGIS plugin Affine Transformations. [gis.stackexchange.com/questions/13433/… [1]: gis.stackexchange.com/questions/13433/…
Aug
1
awarded  Yearling
Jul
2
awarded  Curious
May
22
suggested suggested edit on Updating column in Field Calculator using values of another column?
Mar
5
comment How create geographic column in postgis table?
in my work I used query above, it was not necessary in the 'primary key' for the 'union' table. But I don't have idea how add 'primary key':/
Mar
5
answered How create geographic column in postgis table?
Feb
8
answered Is there a way to syncronize the current view extent in QGIS with Google Earth?
Feb
7
comment Importing multiple shapefiles into single PostGIS table
Try QGIS plugin for merging shapefiles Merge shapes, - there is option add file name to column (gis.stackexchange.com/questions/22175/…)
Feb
7
comment Importing multiple shapefiles into single PostGIS table
Try merge shapefiles in QGIS: Vector - Data Management Tools - Merge shapefiles to one, then import this shapefile in PostGIS.
Feb
4
answered how to snap two line vertex in two different layers used in QGIS
Feb
3
comment Import CSV file into Postgis DB with Location-field formatting?
if you want create postgis geometry field see example twiav-tt.blogspot.com/2012/07/…
Feb
3
comment Import CSV file into Postgis DB with Location-field formatting?
split the field to lang/lat - yes, it is correct
Feb
3
comment Import CSV file into Postgis DB with Location-field formatting?
You created three columns in table (name,created_date,location), but when you perform a query import data with delimiter "," request attempts import data from four columns: |"Coffe"|01/02/2007|(40.74053344654042|-74.00778384953068)|. You need change '",' and '/2007,' on another delimiter (for example ;) and change field type 'location double precision' to 'location text'
Dec
21
awarded  Popular Question
Nov
25
revised Is it possible to calculate a value based on values of another row?
added 256 characters in body
Nov
25
comment Is it possible to calculate a value based on values of another row?
@MortenSickel, add solution in PostGIS. I hope this will help you
Nov
25
revised Is it possible to calculate a value based on values of another row?
added 885 characters in body