Tagged Questions
-1
votes
1answer
23 views
QGIS and Python - create line with multiple points in postgis
How can I create a line, with Python functions, with many points that are records in Postgis?
Thank you
2
votes
1answer
84 views
Need help assigning values to field using OGR in python
I've got a similar question to this one How to programatically populate a shapefile field with polygon areas in OGR?, but the solution doesn't seem to be working for me. I am trying to import a ...
2
votes
1answer
212 views
RT Sql Layer plugin giving an error
I am trying to use the aforementioned plugin with QGIS 1.7 and Postgres 9.0/PostGIS 1.5.
Added a PostGIS spatial layer w/out a problem and then clicked on the RT Sql layer button which displayed the ...
0
votes
1answer
61 views
How can i select many rows from a table?
I want to create an action that select many rows from PostGIS table to show many lines in QGIS.
How can i select many rows from table with python to add these rows in a layer?
Thank you
1
vote
2answers
179 views
unable to call shp2pgsql using python
I am unable to call shp2pgsql using python as I have to pass various options like (-s -a -i)
and I am not getting the required output ..
Method I am using is
p1 = subprocess.Popen(["cmd", "/C", ...
2
votes
0answers
64 views
Extracting x,y,z values from a postgis linestring to python using ogr
I am trying to load a postgis linestring into python (using ST_DumpPoints) and extracting x,y,z coordinates, which is working but extremely slow..and if i mean slow, i really mean it (yes, it takes ...
4
votes
1answer
149 views
How to interpolate polyline or line from points?
We have a lot of points, but with no timestamps to create ways. For now, I've created a sample of the way the points traverse. It's in here, this way can be compared with a Google one.
I haven't ...
1
vote
2answers
142 views
Automating batch load of multiple GPX files into PostGIS
I've got 50+ GPX files that I would like to "batch load" into a PostGIS database. All of the track_points data would be loaded into a "track_points" table (with typical GPS fields like lat, long, ...
0
votes
0answers
89 views
how to plot point on openlayer google street layer programmatically
I want to plot points on google street layer using python programming and postgresql database.
Mainly I want to extract data from database and plot it on the google street layer on Quantum GIS 1.8 ...
3
votes
3answers
364 views
How do I apply Dijkstra's algorithm in Python with PostGIS data?
I have currently parsed OSM data, from a PBF file, into a pgRouting database with the use of osm2po, an excellent parsing tool. I don't however want to use the algorithms provided by pgRouting and ...
1
vote
0answers
64 views
Why is not ST_GeomFromEWKB() working?
The following SQL is working fine from the terminal:
SELECT MIN(ST_Distance(
ST_Transform(ST_GeomFromText('POINT(-3.163916 55.926528)',4326),32630),
...
3
votes
2answers
133 views
Setup a map server that runs from USB to whatever computer it is connected?
I would like to have a USB that I can bring with me to any computer. That USB should hold a map server, so that the client computer wont need internet and avoid using OSM or Google maps or any other ...
1
vote
0answers
143 views
How to debug 'Layer is not valid error' from Python plugin?
I'm trying to understand what goes wrong with a QGIS python plugin.
Basically I'm trying to render a series of POINT.
The query works fine, at least giving it by hand from inside PostGIS DB:
"SELECT ...
0
votes
0answers
75 views
Can I do full SQL expressions through the “WHERE” clause in UpdateCursor?
Run as a standalone python script for a shapefile in a toolbox on ArcMap.
For example:
psql_url_pop = '''SELECT shapefile.NAME_# + shapefile.WIKI_URL FROM public.shapefile'''
rows = ...
4
votes
2answers
217 views
How to programmatically create exports from PostGIS database into different file formats (e.g. shapefile, dxf, dgn,…)?
Is there a kind of wrapper/library written in python which would enable me to programatically create exports from postgis database into different file formats (most common being, shapefile, dxf, ...
