[Qgis-user] QGIS 2.2 Postgis 2.1.2
Hello, Since some months ago I have been working with QGIS 1.8, PostgreSQL 9.1, PostGIS 2.0 on Windows 7, without bigger problems of connection with local databases. Recently I decided to install a new system with this features: Ubuntu 14.04 LTS QGIS 2.2.0 Valmiera PostgreSQL 9.3.4 POSTGIS=2.1.2 r12389 GEOS=3.4.2-CAPI-1.8.2 r3921 GDAL=GDAL 1.10.1, released 2013/08/26 Each package works very good independently, but when I try to make a connection from QGIS to Postgis I get this error: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix doman socket /var/run/posgressql/s.PGSQL.5432 Of course when I try to see the tables in the database with psql or pgadmin3 everything is fine and working, so the problem is no with service. I checked the port, user and password too, and everything is fine. On the other hand, I have a similar issue when I try to add some tables to a database from a geojson file. If I use ogr2ogr directly it doesn't work, and i get an error similar to the other with qgis. However with this problem I have an alternative, that is to convert the geojson file to ESRI shape with ogr2ogr, and then insert the shp in the database with shp2pgsql. It works fine for me, but with qgis I don't have any alternative. I'm worried if there are compatibility problems with the versions of QGIS and Postgres/Postgis that I'm using. Thanks for your help -- Augusto Sisa Camargo Colombia. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] pyQGIS : How to retreive layers 's edits ?
Hello, Thanks. i succeed in accessing and displaying geometries and attributs. I 'm abble to edit the layer. But now i would like to retreive informations about edit layers. How to detect edit layers and modifications (WKT edit layer? ). How to get a list about editing ? in a 2nd time, i would like send layer 's edits to the server. Could you throw light for me? Thanks. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/pyQGIS-read-attributes-with-qgis-2-2-tp5146541p5146934.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] pyQGIS : How to retreive layers 's edits ?
Hello, Thanks. i succeed in accessing and displaying geometries and attributs. I 'm abble to edit the layer. But now i would like to retreive informations about edit layers. How to detect edit layers and modifications (WKT edit layer? ). How to get a list about editing ? in a 2nd time, i would like send layer 's edits to the server. Could you throw light for me? Thanks. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/pyQGIS-How-to-retreive-layers-s-edits-tp5146935.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] show record from table in ms-access using python
I have a ms-access database and i try to make QGIS plugin that take record from table and show it in Qt, database have format like this : NO Skala 1 Skala2 Rekomendasi 1. 10001000Skala Sama 2. 10005000Skala Bisa digunakan 3. 50001 Skala Tidak Cocok 4. 50005 Skala Terlalu Besar what i try to make is, when i input skala1 (ex:1000) and skala2 (ex:5000) it automatic take Skala Bisa Digunakan from database and put it in Qt, i try to use code like : def Compskala(self): skal1 = self.ui.lineSkl_1.text() #(input) skal2 = self.ui.lineSkl_2.text() #(input) bandskal = ''#(from table) if skal1 and skal2: bandskal = ' How to direct this to table?' but i really didn't know what i must do next to direct my code to take record from table Can someone help me? Sorry for my bad english ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] FW: PostGIS Raster view in QGIS 2.2?
Thankx for the infos. I might have some capacities to support the testing. Maybe in testing different scenarios? Regards Christian Christian Hickel +49 6151 16-2447 hic...@geod.tu-darmstadt.de http://tinyurl.com/32abubx -Original Message- From: Alex Mandel [mailto:tech_...@wildintellect.com] Sent: Wednesday, June 18, 2014 8:53 PM To: Christian Hickel; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] FW: PostGIS Raster view in QGIS 2.2? DB Manager works, sometimes. A few of use are trying to find a repeatable case of what does and what does not work. It seems more dependent on exactly how the layer is imported into Postgis rather than what system you are on. Thanks, Alex On 06/18/2014 09:21 AM, Christian Hickel wrote: Dear Paolo, thankx for the help. Then something is wrong with my Installation because that was not working at all. I'll keep on trying. Regards Christian Christian Hickel +49 6151 16-2447 hic...@geod.tu-darmstadt.de http://tinyurl.com/32abubx -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Paolo Cavallini Sent: Wednesday, June 18, 2014 5:43 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] PostGIS Raster view in QGIS 2.2? Il 18/06/2014 13:20, Christian Hickel ha scritto: I am wondering i fit is still possible to view a PostGIS RasterLayer in QGIS in an easy way. In the past I used the wktrasterplugin. Unfortunatly it is not supported anymore. Is there any simple way to load a PostGIS raster now in QGIS 2.2? Once loaded in PG, you can drop it to the canvas from DB Manager. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Asking for NDVI_Landsat 8
Dear Mariana, If You have the tif files, you do not have to merge the bands, you just only need these files. Otherwise, maybe (if the images do not have 8 bit format, but you will see when DDVI values will have non-regular values, i.e. outside the -1-+1 range) you have to apply an atmospheric correction (I had to ...) with the TOA plugin in QGIS. In this case you need the *.met file for the correction, too. Kind regards, Szilard 2014-06-18 19:43 GMT+02:00 Mariana Buzzi marianabuzz...@gmail.com: Dear QGIS users, I wanted to consult on the calculation of NDVI with Landsat 8. I Download a USGS Landsat image 8, so I have all the bands that make up the image. The question is: should I perform a merge with the bands 4 and 5 and then calculate the NDVI with the raster calculator? How should I do it? Of course, thank you very much! ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] create polygon: underlying image is covered
Ja ja,I thought this was an issue to fix in 2.4. Thank you André for your answer... and thank you Thomas for asking. Carlos 2014-06-17 22:52 GMT-05:00 Andre Joost andre+jo...@nurfuerspam.de: Am 17.06.2014 23:19, schrieb Thomas Recknagel: I want to vectorize land forms from an ortho image, so I make a new polygon shape file and create new objects inside it. When I follow the outline of the land form, I have the problem that the new polygon covers the underlying layer (it is red and only slightly transparent), so I cant see the structures of the ortho image anymore. Is there a way to create new polygons, but only have the border of the polygon drawn while creating it? I couldnt find such an option in QGIS. Settings - Options - Digitizing You can change the colour of the rubber line. I have changed the alpha channel to 100. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] OpenSource software for Drones
Lene, While I had been following DIY UAV effort for may years, I just seriously started about 18 months ago. My goal was to be able to reliably provide ortho-rectified high resolution imagery. Here are some of things I've learned: 1. It is possible to buy some off-the-shelf systems (e.g. www.aeryon.com/products/avs/aeryon-scout.html) but they can cost $20K to $60k and are not open (on the other hand, they are very reliable). 3DR (the commercial store for DiyDrones) has cost-effective, open systems. They just released their Iris/Pixhawk systems. 2. The DIY Drones ecosystem is mostly populated with people who just want to build, fly, and experiment with their own UAV platforms (frame, powertrain and flight controller), but there a few people interested in acquiring and processing UAV imagery as well. Personally, I look at a UAV as [just] a camera positioning system ;) 3. Most of the software development effort in UAV image processing comes from the computer vision space (e.g OpenCV). Google structure from motion for more info on that type of processing chain. I'm unsure if that method pays enough attention to rigorous image geometry to produce accurate ortho-rectified imagery. Maybe; at any rate I want DEMs and geotiffs as an end result (I think) and that chain tends to produce non-georeferenced 3D models. And if you've got a few hours to burn reading current research, google UAV SLAM... 5. MicMac (http://logiciels.ign.fr/?-Micmac,3-) seems to use photogrammetric principles, is set up to use UAV imagery, and is Open Source, but as I mentioned before the learning curve is steep. Their user forum (http://forum-micmac.forumprod.com/) has links to the user doc (280 page PDF!) and some sample data to work thru the examples in the user doc. Another possibility is OSSIM/OTB, and while their algorithms are excellent, I don't think the software is set up to deal with hundreds of images (bundle adjustment, etc), and it doesn't produce DEMs (yet). 6. Lots of R D to be done yet. For example, using RTK/Post-processing to calculate accurate camera centers (so no ground control points necessary). Some models of the cheap UBLOX GPS receivers can generate pseudo-range info, so RTKLib is a possibility. Good Luck! Best Regards, Brent Fraser On 6/19/2014 9:29 AM, Lene Fischer wrote: Thanks for all the good links -- I´ll now have something to look into Regards *Lene Fischer* Associate Professor *Department of Geosciences and Natural Resource Management* University of Copenhagen MOB +45 40115084 l...@ign.ku.dk mailto:l...@ign.ku.dk SCIENCE_bomaerke_UK *Fra:*qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] *På vegne af *Stefan Sylla *Sendt:* 19. juni 2014 04:39 *Til:* qgis-user@lists.osgeo.org *Emne:* Re: [Qgis-user] OpenSource software for Drones Even though its not QGIS-related, but check this out: http://wiki.paparazziuav.org/wiki/Main_Page View this message in context: Re: OpenSource software for Drones http://osgeo-org.1560.x6.nabble.com/OpenSource-software-for-Drones-tp5146615p5146635.html Sent from the Quantum GIS - User mailing list archive http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Unable to open OGR .vrt file
Hi Even/Andre, After going through the OGR Virtual Format documentation again I realized that the GeometryField sub-element has an optional attribute called reportSrcColum. When set to FALSE (by default is set to TRUE) the source geometry fields (longitude and latitude columns in .csv file) will only be used to build the geometry of the features of the VRT layer but they will not be copied over to the attribute table in QGIS. In contrast if I use the default value the source geometry fields will only be copied over without building the geometry. Have I understood correctly? Modifying the following line it worked: GeometryField encoding=PointFromColumns reportSrcColumn=false x=longitude y=latitude/ Thanks again for your help Andrea ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Unable to open OGR .vrt file
Am 19.06.2014 23:59, schrieb Andrea Acinelli: Thanks for spotting that. After correcting the quotation the virtual layer loaded but without showing any features on the canvas or the attribute table. Same here. it is loaded as empty non-spatial table, because the source file has not been found. Not sure why there is no error message for that. After, as Even suggested, I modified the .vrt file including the relativeToVRT=1 attribute inSrcDataSource and layer gets loaded with all the features Same here. Ogr2ogr behaves a bit different than QGIS in that point. You can as well enter full path and file name to get it working. but all the points gets rendered on top of each at lat=0, long=0. Not for me. Meanwhile I have found the original dataset at: http://firms.modaps.eosdis.nasa.gov/active_fire/text/Global_24h.csv And the points appear all over the world. Maybe there is another typo in your dataset. Alternatively, you can try ogr2ogr Global_24h.shp Global_24h.vrt and see if that shows the points correctly. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 2.2 Postgis 2.1.2
Am 20.06.2014 09:20, schrieb Augusto Sisa: Recently I decided to install a new system with this features: Ubuntu 14.04 LTS QGIS 2.2.0 Valmiera PostgreSQL 9.3.4 POSTGIS=2.1.2 r12389 GEOS=3.4.2-CAPI-1.8.2 r3921 GDAL=GDAL 1.10.1, released 2013/08/26 From which repository? Ubuntugis unstable is still very fresh for Ubuntu 14.04. And they already have GDAL 1.11 available. Greetings, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Unable to open OGR .vrt file
Andre/Even, Maybe I didn't explained it properly but by adding the reportSrcColumn=false attribute in GeometryField all points are displayed correctly all over the world in QGIS. GeometryField encoding=PointFromColumns reportSrcColumn=false x=longitude y=latitude/ Just wondering if what I described in the previous post is the expected behaviour. What do you think? Thanks a million Andrea ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Unable to open OGR .vrt file
Am 20.06.2014 17:22, schrieb Andrea Acinelli: Andre/Even, Maybe I didn't explained it properly but by adding the reportSrcColumn=false attribute in GeometryField all points are displayed correctly all over the world in QGIS. GeometryField encoding=PointFromColumns reportSrcColumn=false x=longitude y=latitude/ Just wondering if what I described in the previous post is the expected behaviour. What do you think? Well, it worked for me without reportSrcColumn, and I have never used that. Not sure why. Maybe because I am on Windows? Greetings, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 2.2 Postgis 2.1.2
On 06/20/2014 07:27 AM, Andre Joost wrote: Am 20.06.2014 09:20, schrieb Augusto Sisa: Recently I decided to install a new system with this features: Ubuntu 14.04 LTS QGIS 2.2.0 Valmiera PostgreSQL 9.3.4 POSTGIS=2.1.2 r12389 GEOS=3.4.2-CAPI-1.8.2 r3921 GDAL=GDAL 1.10.1, released 2013/08/26 From which repository? Ubuntugis unstable is still very fresh for Ubuntu 14.04. And they already have GDAL 1.11 available. Greetings, André Joost I'm actually wondering if Pgadmin is connecting via localhost but the other programs are trying to connect by real IP. In which case it's a pg conf issue. Might also be what type of auth it expects. What does sudo nestat -lptn show What is the ogr2ogr command you used (leave out the password) Thanks, Alex ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Unable to open OGR .vrt file
Hi, Thanks Andre. Your help is very much appreciated. Your last comment: Maybe there is another typo in your dataset. Alternatively, you can try ogr2ogr Global_24h.shp Global_24h.vrt and see if that shows the points correctly. I tried the ogr2ogr utility that came with PostGIS by Postgresql.app and the resulting shapefile loads correctly in QGIS. The .vrt file I converted is the unedited one (see below) without the relativeToVRT=1 and reportSrcColumn=false attributes: OGRVRTDataSource OGRVRTLayer name=Global_24h SrcDataSourceGlobal_24h.csv/SrcDataSource GeometryTypewkbPoint/GeometryType LayerSRSEPSG:4326/LayerSRS GeometryField encoding=PointFromColumns x=longitude y=latitude/ /OGRVRTLayer /OGRVRTDataSource The virtual file above seems to load correctly on windows as in your case. Can I ask other mac users to test the above .vrt file, the .csv can be downloaded from http://firms.modaps.eosdis.nasa.gov/active_fire/text/Global_24h.csv and see if they need to insert the additional attributes display the points? Thanks Andrea NOTE: This is my first support request and I noticed that I didn't reply properly. Almost all my mails represent a new thread. How do I replay so that my replays appear indented from the previous post etc..___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Unable to open OGR .vrt file
Am 21.06.2014 03:26, schrieb Andrea Acinelli: NOTE: This is my first support request and I noticed that I didn't reply properly. Almost all my mails represent a new thread. How do I replay so that my replays appear indented from the previous post etc.. It depends on how you get the mailing list. I read it in Thunderbird as a newsgroup via gmane, and a simple Reply sets the headers correctly. If you get the mailing list as simple mails, maybe Reply to all is the correct method. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
