583 reputation
1317
bio website
location Ukraine, Kharkov
age 25
visits member for 1 year, 8 months
seen 1 hour ago

GIS Engineer.

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

Skype: a.hast


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
Oct
14
comment QGIS 2.0: Automating tasks, text files and shapefiles
All it is possible in PostgreSQL/PostGIS (from import text file to receive shapefile). Please provide sample of text file
Oct
13
answered Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS
Oct
11
revised Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS
added 2 characters in body