Re: [Qgis-user] Additional data

al to >point me to. >Thanks again! >Chuck > >On Mon, Aug 1, 2016 at 4:53 PM, James Keener <j...@jimkeener.com> wrote: > >> Beyond just PostGIS, postgresql is a much better database on most >fronts >> than mysql. >> >> If you have two tables, one

Re: [Qgis-user] QGIS communication platforms

You feel that to participate in the community of an open source tool I must sign up to a proprietary service who will track and advertise to me (of which none of the advertising revenue goes to qgis)? What happens in a few years when something else becomes the new hotness? What happens when

Re: [Qgis-user] PostGIS Queries

I would need double check if overlaps uses an index. If it does you can use explain to figure out which table is being fill y scanned and adjust the order in the statement accordingly. If it doesn't, then you can use something that does (e.g. &&) and ensure that the smaller table is the one

Re: [Qgis-user] Backing up GIS Data

Tapes are still common, actually. They're cheap per GB and are quite large and reusable. There is pg_dump available to dump the database itself for backup purposes. As for if the disk snapshot (I'm assuming it's a snapshot and not just a copy of the disk while running!! CHECK THIS!) will be

Re: [Qgis-user] Processing road data

Isn't that the format the data is already in? What needs to be split? On Wed, Jul 6, 2016 at 12:46 PM, Tyler Veinot wrote: > Hi; > I have an dbf file that identifies the condition of roads defined by > intersecting streets i.e > > *Street* *From* *To* *Condition* > Bods

Re: [Qgis-user] QGIS Viewer

How are users accessing the data? If they're connecting to a database, can you simply not give them update permission? If it's files, can you can keep read-only master copies on a public store/shared drive? Jim On Thu, Jun 30, 2016 at 12:20 PM, Tyler Veinot wrote: > Hi

Re: [Qgis-user] Drive time analysis

There s a pgrouting plugin for qgis to let you query a PostGIS database with pgrouting installed. Otherwise I normally just write the SQL myself. Jim On April 8, 2016 4:47:15 AM EDT, johnrobot wrote: >Hi >I am looking into drive time analysis using QGIS. A typical question

Re: [Qgis-user] unsubscribe

It's on the bottom of every email you get from the list. It says unsubscribe and then the link to the mailing list management page. On April 5, 2016 5:22:19 PM EDT, Sander van den Ende wrote: >Please provide me with instructions to unscubscribe. The links under >the

Re: [Qgis-user] unsubscribe

The link sure does "To unsubscribe from Qgis-user, get a password reminder, or change your subscription options enter your subscription email address:" On April 5, 2016 5:22:19 PM EDT, Sander van den Ende wrote: >Please provide me with instructions to unscubscribe. The

Re: [Qgis-user] Assistance with high-level use case of QGIS for commercial use

Have you thought about using PostGIS and Python/Ruby/PHP/Perl/? I'm not 100% sure how you would respond to a file upload with the QGIS python API. Jim On 02/26/2016 05:26 PM, Dave Tobias wrote: > I'm new to QGIS and have been a very long time user of a commercial GIS > solution. Their fee to

Re: [Qgis-user] Technical questions regarding QGIS

Perhaps I'm being dense but none of those questions apply to a user land application (except maybe scriptability) and none of those listed are gis applications. Part of me wonders if this is an elaborate form of spam. Jim On January 14, 2016 11:40:43 PM EST, Eninna Luli

[Qgis-user] Georeferencing old areal photography

Hello! I have many scans of old slides from areal photography from 30s/40s, 50s/60s, and 60s/70s. Being interested in rail lines, I (and I was going to trick^Wask my dad and brother to help) trace out the rail lines found in each areal photograph, with the goal being to align our traces with

Re: [Qgis-user] postgis/gresql views

I guess I don't fully understand your problem. Is this a labeling issue or a postgres issue? Also, labels can be the output of an expression. I don't know if that's what you mean as you're also talking about aggregate functions. Can you more clearly define your problem? Jim On December 9,

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

To reopen a really old thread, I like the exclamation point/warning icon with the tool tip in 2.12. Figured I'd give some good feedback instead of complaining ever now and then :) Jim ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info:

[Qgis-user] Project file format

If I wanted to embark on a fools errand of storing a project in a database, in a structured manner, is there a spec for the project file format, or is it what it is? -- Sent from my Android device with K-9 Mail. Please excuse my brevity.___ Qgis-user

Re: [Qgis-user] qgis possible malware false positive

Just to be sure: You did get your binary from https://qgis.org/en/site/forusers/download.html ? My first instinct would be to have IT tell you exactly which malware was found. If they believe QGIS _itself_ is maleware, then you need to do different things than if they simply believe it's

Re: [Qgis-user] Rule based styling issue

Is it possible that when you leave the expression editor and recompute the styling the colors accidentally get reversed (e.g. the one for 0 is now 1)? I've had this happen to me a few times. Would it be possible to take a couple screen shots of the workflow so that we can see exactly what you

Re: [Qgis-user] Rule based styling issue

Interesting. I haven't noticed this behavior before. I'll see if I can reproduce it on my end. If you deselected the empty style in your pictures, does the problem still occur? (I know, stupid question; I'd expect it not to matter) Jim PS: Note I'm not a dev, but I'm willing to help look into

Re: [Qgis-user] Maximum string length 254

The 254 character limit is inherent to the shapefile format, not QGIS. https://en.wikipedia.org/wiki/Shapefile#Limitations Whoever is providing the shapefile must have it stored in another format. Could you get the raw data? Could you get a SpatiaLite database instead of shapefiles? Could you

Re: [Qgis-user] I want to get out of this forum

Every message you receive from this mailing list contains a link that allows you to manage your subscription. You can choose to receive an email for each message, one email with all messages for the day, or no emails and leave completely. As with all mailing lists, this is self-serve. Jim On

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

I wonder if we could make use of the stats the query planner uses. http://www.postgresql.org/docs/9.1/static/monitoring-stats.html http://www.postgresql.org/docs/9.1/static/planner-stats.html I don't know how tightly this would couple us to any single version of postgresql though. Jim On

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

Sorry for the double email. Also, I wonder how much we could extract from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM view WHERE field1 = 1;) and if we could tease information out of that. This all seems more complicated than it needs to be though. Jim On 09/04/2015 02:42

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

Explain also gives approx row counts and other info. On September 4, 2015 9:49:52 AM EDT, Sandro Santilli <s...@keybit.net> wrote: >On Fri, Sep 04, 2015 at 08:31:39AM -0400, James Keener wrote: >> Sorry for the double email. Also, I wonder how much we could extract >> from

Re: [Qgis-user] Adding a Mac to a group of PCs

ould simply move >the data so that everything is on the same share and and then, relative >paths will solve the problem. >Again, thank you for a very helpful answer. > >Arni > > >Árni Geirsson >Alta ehf // +354 582 5000 // +354 897 9549 >www.alta.is<http://www.alta.is/> /

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

On September 1, 2015 12:09:28 PM EDT, Matthias Kuhn <matth...@opengis.ch> wrote: >On 09/01/2015 05:54 PM, James Keener wrote: >> We also need to ask what qgis is doing with this and why we need to >> bug the user about it at all. >> >> Why do we not big the user a

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

gt;a "pretty solution". > >Je; > >On Tue, Sep 01, 2015 at 11:36:53AM -0400, James Keener wrote: >> Please stop saying this. It's fine for certain situations, but it is >not a >> permanently unique identifier for a row. It may change when the >underlying >&g

Re: [Qgis-user] Call for release name suggestions 2015

We could always use silly names. Qgisor Qgisisimo Qgisinator Qgisette Qgisador Qgis: a new hope Qgis: the next generation Qgis5 Qgis: or how I learned to stop worrying and love gis Qgisamation Qgisactica Qgis: everywhere Qgis 1138 Qgis 2001: a geospatial oddesy Qgis who Quails Gulls Iiwis and

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

Why are you assuming the user who created the view is the one using QGIS? Jim On 09/01/2015 08:50 AM, Andreas Neumann wrote: > Hi, > > I agree with Jürgen - better let the user choose the pkey column. If the > user knows how to create a Postgis View he also knows how to select a > primary key

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

or drop forcing the user to select one. Jim PS: I know this isn't the place, but the db manager gives absolutely, positively terrible feedback about this. On 09/01/2015 04:59 AM, Jürgen E. Fischer wrote: > Hi James, > > On Mon, 31. Aug 2015 at 15:05:05 -0400, James Keener wrote: >> I

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

the view and the ones who are loading them. >> >> You are welcome to improve the situation/GUI, but please don't go >back >> to the old behavior where it is an assumption that the first column >in >> the list is always the primary key. >> >> Andreas >>

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

you are correct that it can be different persons - the one who >> creates the view and the ones who are loading them. >> >> You are welcome to improve the situation/GUI, but please don't go >back >> to the old behavior where it is an assumption that the first column >i

Re: [Qgis-user] Adding a Mac to a group of PCs

Re: postgresql in my experience it's neither cumbersome nor slow. Feel free to email me for help if you would like to explore that route. Are the paths in you qgs file relative or absolute? If their relative, is the issue that the path separator is different? If that is the issue, I would file

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

ing layers. > >But you are correct that it can be different persons - the one who >creates the view and the ones who are loading them. > >You are welcome to improve the situation/GUI, but please don't go back >to the old behavior where it is an assumption that the first column in

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

Please stop saying this. It's fine for certain situations, but it is not a permanently unique identifier for a row. It may change when the underlying table is altered. Sure, it's unique if you read the results and keep them in memory and never talk about it again, but qgis does that on its own

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

I don't mind the behavior as much as it's entirely unclear, especially when the window is small and you have to scroll to see the drop down, what is the problem. There should be an error message (or even an error/warning icon with the tool tip saying there is on PK), along with possible remedies

Re: [Qgis-user] Getting There, From Here (How to get this Shapefile into a tablet!)

Depending on how much space you're willing to give it, you could pre compute tiles and have a single-folder webpage (via the qgis2web plugin) you could load on your device and view it on its web browser. There is the Android Osmand application for viewing OSM data (via network of offline

Re: [Qgis-user] How to reference a map with qGIS

When you export from composer, it's just a tiff, not a geotiff (someone else correct me if I'm wrong!) A quick-and-dirty solution may be to fake the tiff that was exported from the composer and georefernce it against your project, and save that as a geotiff. Jim On August 22, 2015 9:22:29 PM

Re: [Qgis-user] QGis server project files stored in DB?

environment where there is 1 user only and it is webadmin , qgis user and perhaps also publisher. Not always it ha also the capability to admin a DBMS like postgres. I feat that this option increasing complexity will reduce the installation of qgis-server. A. Il 12/ago/2015 03:29 PM, James

Re: [Qgis-user] QGis server project files stored in DB?

I was also looking for this a bit back and never found a solution. I ended up using other software, unfortunately. As for being less flexible, it is exactly as flexible as a qgs file would be, it's just that they could be manipulated and created more easily. I would love to see the parts of the

Re: [Qgis-user] Slow to open huge rasters

Spinning disks can be significantly slower than an SSD :( However, I've opened 10GB, 3-band rasters off spinning platter disks in seconds, so :-\ Some calculations on band cutoffs and things can take a while if I ask it to calculate those. On Thu, Jul 30, 2015 at 9:50 AM, Nicolas Cadieux

Re: [Qgis-user] Question on default file formats

More tools support it. Spatialite wasn't supported in esri until very recently and other tools may not support anything but shape files. It's become a lingual franca, and like English: it's terrible, but works well enough. Jim On July 28, 2015 11:38:24 AM AST, Árni Geirsson a...@alta.is wrote:

Re: [Qgis-user] TIGER projection question

the map). Is that the correct interpretation? Sorry for the double email. Jim On 07/26/2015 11:03 AM, James Keener wrote: http://gis.stackexchange.com/questions/27702/what-is-the-srid-of-census-gov-shapfiles claims that the projection is EPSG 4269, however the map at http://spatialreference.org/ref

[Qgis-user] Maps over multiple projected coordinate systems

If I want to use a PCS to do distance calculations over a large area. For instance, lets say I want to calculate a 650km buffer around Pittsburgh, Pa. The buffer would go outside the state plane for Pittsburgh and outside the UTM zone. I decided to punt and just put everything in UTM Zone 17N and

[Qgis-user] TIGER projection question

http://gis.stackexchange.com/questions/27702/what-is-the-srid-of-census-gov-shapfiles claims that the projection is EPSG 4269, however the map at http://spatialreference.org/ref/epsg/4269/ shows the projection as not valid for North America. Am I not reading the map at SpatialReference.org right?

Re: [Qgis-user] QGIS Ubuntu: qgis_mapserv.fcgi doesn't load

That is a message from the mapserver. Do you have any qgs file in the directory with it? Jim On Thu, Jul 16, 2015 at 10:42 AM, Kavita Chitnis kvchit...@gmail.com wrote: I am trying to install QGIS on Ubuntu 15.04 by following the steps mentioned in the link

Re: [Qgis-user] QGIS Ubuntu: qgis_mapserv.fcgi doesn't load

vienna -rw-r--r-- 1 root root1488 Apr 11 13:53 wms_metadata.xml On Thu, Jul 16, 2015 at 10:44 AM, James Keener j...@jimkeener.com wrote: That is a message from the mapserver. Do you have any qgs file in the directory with it? Jim On Thu, Jul 16, 2015 at 10:42 AM, Kavita Chitnis kvchit

Re: [Qgis-user] Live DVD advice

Could you use QGIS Server? It'd take a qgs file and the data it needs (which can be any input type QGIS uses, including shapefiles and spatialite dbs along with PostGIS). Jim On 06/27/2015 07:46 PM, Brent Wood wrote: Hi, I'm looking to build a LiveDVD/USB key with QGIS, OSM base layer and

Re: [Qgis-user] Live DVD advice

*From:* James Keener j...@jimkeener.com *To:* Brent Wood pcr...@pcreso.com; Qgis-user List qgis-user@lists.osgeo.org; Mapserver-users mapserver-us...@lists.osgeo.org; OSGeo Discussions disc...@lists.osgeo.org; Nzopengis nzopen...@googlegroups.com; Live-demo live-d

Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04

I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House

Re: [Qgis-user] labelling by attribute

Andreas, Thank you very much for your feedback! Jim signature.asc Description: OpenPGP digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] labelling by attribute

0.00xx percent of what ESRI has available in its budget. And have an amazing piece of software to show for it! Thanks we try our best. But seriously, I've shown people who've only used Arc QGIS and they love it! They find the interface easier to understand and use, and some of them also

Re: [Qgis-user] labelling by attribute

0.00xx percent of what ESRI has available in its budget. And have an amazing piece of software to show for it! However, I agree with you, that rule-based or categorized labels would be very useful to have in QGIS. In fact we know this for a long time already - since version 2.0 people have

Re: [Qgis-user] Local Government for QGIS

They feel as thought they are adhering to a standard - of course a standard put forth by a software company. A proprietary software company with whom they have no reason to believe their data from now will be accessible in 10 years, let along 50. Yes it's free but it's very professional. A

Re: [Qgis-user] map with specific information for particular POIs

You could create a new point layer and add attributes for phone number, person in charge, c. Then you can add points and the associated metadata to the map. Did you intend for this to be internal or public facing in the end? Jim On 06/01/2015 02:35 AM, Kevin Suhr wrote: Hi Folks My company

Re: [Qgis-user] How to assign geographical objects to records and find records that have no geographical object

If you can't get record order to be the same, you can assign each an id and join on it. I haven't yet attempted to copy-paste attributes between tables. You may have to add the expected columns to the destination shapefile though. I'm not at a computer at the moment, but I wonder if there is a

Re: [Qgis-user] failed - OpenStreetMap import

Can you provide more information on what you did and what plugins you were using, if any? Jim On 05/26/2015 12:27 AM, K Imran M wrote: Hi, When I try to create the SpatialLite DB file, I receive this error 'failed to import OSM data: database file cannot be overwritten' What I have done

Re: [Qgis-user] Security aigainst spyware certificate

Is SQGIS a specific build? Additionally, what kinds of certification would your boss be looking for? (I've never seen one _I_ found trustworthy, as they all look a little scammy, but that's just me.) Are Chrome and Firefox certified (or are you guys using Internet Explorer ::shudder::)?

Re: [Qgis-user] Calling OSM as a Base Layer in Geoserver

Open layers has many good tutorials (on my phone so I can't kink right now). While it is JavaScript, it isn't a lot and you shouldn't need to modify the tutorial too much of you just want to overlay layers. Jim On May 16, 2015 8:10:01 AM EDT, abhijit.ekb...@gmail.com wrote: ‎Hi I know this is

Re: [Qgis-user] Lizmap Web Client

I've had luck using the QGIS server[1] on the back and QGIS-Web-Client[2], MapBender[3], and generic OpenLayers[4] on the front end. QGIS server uses the qgs project files and the same rendering engine as QGIS, so things will look as awesome as they do in QGIS. I'm not sure if it's proper for

Re: [Qgis-user] base maps

Would you be able to import the OpenStreetMaps data and manipulate it as you wish if you chose not to use the default OSM layer as your basemap? Jim ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Spatial Query with buffer?

What's your data source? If it's PostGIS a query could do that in a mostly straightforward way. Jim On May 6, 2015 10:32:38 AM EDT, Joris Hintjens joris...@gmail.com wrote: Hello, I want to do a spatial query. Which Polygones intersect with a series of points,... That is easy with the spatial

Re: [Qgis-user] Spatial Query with buffer?

-05-06 16:37 GMT+02:00 James Keener j...@jimkeener.com: What's your data source? If it's PostGIS a query could do that in a mostly straightforward way. Jim On May 6, 2015 10:32:38 AM EDT, Joris Hintjens joris...@gmail.com wrote: Hello, I want to do a spatial query. Which Polygones

Re: [Qgis-user] Spatial Query with buffer?

Hintjens joris...@gmail.com mailto:joris...@gmail.com: All my data is in shape. Have a look at postgis is on my urgent to do list. Never worked with postgis until now 2015-05-06 16:37 GMT+02:00 James Keener j...@jimkeener.com mailto:j

[Qgis-user] Problem with loading layers from a project

I'm trying to load a project via python (original project and the single shp file (the extension should be .zip), along with the project after saving, are attached). When I load the project, there are no layers, and if I write the project out, it doesn't contain the original layer either. Python

Re: [Qgis-user] QGIS FreeBSD port and qgis-server

to set options in it, which other ports are needed to compile this one, c. Rainer, the port maintainer, replied and said he was fixing the issue. Jim On 04/19/2015 05:07 AM, Jürgen E. Fischer wrote: Hi James, On Sun, 19. Apr 2015 at 01:02:23 -0400, James Keener wrote: I am interested in being

[Qgis-user] QGIS FreeBSD port and qgis-server

Hello, I am interested in being able to use the qgis mapserver on FreeBSD 10.1. I enabled the mapserver option via `make config-recursive` and built the port via `make install`. I cannot seem to find the fcgi executable in the build output or in the pkg-plist file. I see WITH_MAPSERVER:BOOL=TRUE