623 reputation
1418
bio website
location Ukraine, Kharkov
age 26
visits member for 2 years
seen 9 hours ago

GIS Engineer.

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

Skype: a.hast


4h
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
Nov
21
answered Is it possible to calculate a value based on values of another row?
Oct
21
comment Snapping points to nearest road
see st_closestpoint in blog.jordogskog.no/2010/02/07/…, I use theses sample - it's work. Try change "group by b.id;" to "group by b.id, b.geom;"
Oct
17
accepted Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS
Oct
15
awarded  Revival