me to.
>Thanks again!
>Chuck
>
>On Mon, Aug 1, 2016 at 4:53 PM, James Keener wrote:
>
>> Beyond just PostGIS, postgresql is a much better database on most
>fronts
>> than mysql.
>>
>> If you have two tables, one with geometries and one with densities,
&
Beyond just PostGIS, postgresql is a much better database on most fronts than
mysql.
If you have two tables, one with geometries and one with densities, they both
need to have the same id somewhere. Once you have the join key, you can perform
a join , not a union, to get a result set containing
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 Face
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 b
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 a
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 Rd Frank St Fred Cr Good
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 again;
> Just wondering
I'm actually in the process of building a company that does just that for
municipalities. We also aim to provide gis, technical, and digitization support
and services as well.
We're starting out with cartodb for our web interface and qgis on the desktop.
I have a feeling we're going to heavily
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
>would
>be "What perc
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 email texts don't lead me t
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 links under
>the email
Have you thought about using PostGIS and Python/Ruby/PHP/Perl/&c? 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
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 wrote:
>I am currently
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
curre
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, 201
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: http:
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 m
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 infected
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 wh
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 mea
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 conv
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 S
Explain also gives approx row counts and other info.
On September 4, 2015 9:49:52 AM EDT, Sandro Santilli 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 EXPLAIN SEL
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 A
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 09/04
ank you for a very helpful answer.
>
>Arni
>
>
>Árni Geirsson
>Alta ehf // +354 582 5000 // +354 897 9549
>www.alta.is<http://www.alta.is/> // Alta á
>Twitter<http://twitter.com/alta_ehf> // Alta á
>Facebook<http://www.facebook.com/pages/Alta/161795813838691?
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 Siry
ids), or ctid (but ctid is slow).
>
>Sorting in row_number can be defined in (ORDER BY ...). But is
>unefficient (as you say). But works well for display smaller parts of
>data (thousands of features).
>
>Materialized view can be indexed. But this is about use case and it
>isnt
&g
-unique field is just as acceptable?
Jim
On September 1, 2015 12:09:28 PM EDT, Matthias Kuhn 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
>> 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 f
d 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
>>
>&g
loading 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 firs
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: 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
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 co
at don't have one.
What is the point of having the user select a "primary key" if QGIS is
accepting non-unique fields with no issue? QGIS needs to either
complain about the lack of uniqueness, or drop forcing the user to
select one.
Jim
PS: I know this isn't the place, but the d
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 p
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 downloads
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 E
creasing complexity will reduce the installation
> of qgis-server.
>
> A.
> Il 12/ago/2015 03:29 PM, "James Keener" ha scritto:
>
>> I was also looking for this a bit back and never found a solution. I
>> ended up using other software, unfortunately.
>>
>&g
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 f
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 <
nicolas
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" wrote:
>Hello
>I
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
es
when you move 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://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?
588 Apr 11 13:53 schemaExtension.xsd
> drwxrwxrwx 2 root root4096 Jul 15 16:16 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 wrote:
>
>> That is a message from the mapserver. Do you h
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
wrote:
> I am trying to install QGIS on Ubuntu 15.04 by following the steps
> mentioned in the link
> http://anitagraser.com/2012/03/30/qgis-server-on-u
value
> of OSM - data plus style.
>
> Cheers,
>
> Brent
> --------
> *From:* James Keener
> *To:* Brent Wood ; Qgis-user List
> ; Mapserver-users
> ; OSGeo Discussions
> ; Nzopengis ;
> Live-demo
> *Sent:* Sunday, June 28, 2015 11:5
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
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 wr
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
>>> 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 a
> 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 hav
> 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.
Yeah. I used to intern in Pittsburgh, Pa's Dept of City Planning and there
were 3 people with Arc licenses that were always too busy to help the
neighborhood planners so we just emailed kml files around. (Much of my
summer was also (poorly) copying as-builts into Google Earth, because no
digital pl
I'm actually in the process of starting a company that sells GIS services
and consulting to municipalities. I'm basing it on CartoDB for a web front
end, and then, unless they beg to use ESRI, QGIS for things like topology
and analysis.
I really do think there is room to break into the market, es
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 comp
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
Double check the CSV has the right type, i.e. strings of numbers should
have quotes around them to ensure they're imported as the proper type iirc.
On Tue, May 26, 2015 at 9:46 PM, Nicolas Cadieux <
nicolas.cadi...@archeotec.ca> wrote:
> Hi,
> Idea: export the data to CSV. Import the CSV in Qgis
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::)?
Dependi
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 do
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
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 th
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
Can you let us know the steps you followed?
Which version of GRASS do you have installed? Which operating system
and version are you running?
Jim
On 05/06/2015 01:39 PM, Gabriel Costa Pinto wrote:
> hello everyone!
>
> I can not create a mapset in qgis 2.8
>
> I realize all steps, but in the
> 2015-05-06 17:08 GMT+02:00 Joris Hintjens <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
>
>
>
>
list. Never worked with
>>> postgis until now
>>>
>>>
>>>
>>> 2015-05-06 16:37 GMT+02:00 James Keener :
>>>
>>>> What's your data source? If it's PostGIS a query could do that in a
>>>> mostly straightforward way
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 wrote:
>Hello,
>I want to do a spatial query.
>Which Polygones intersect with a series of points,... That is easy with
>the
>spatial query plugin.
>
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
ow 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:
>
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
72 matches
Mail list logo
