Re: [Qgis-user] Shared line-style resources etc

[Phil Wyatt]

Hi Tony,

 

A lot of styling depends on the attributes of the layer so you can really
only pass around QML files for common layers. I have some to match the
Tasmanian LIST system common use layers (roads, hydrology etc)

 

https://listdata.thelist.tas.gov.au/opendata/

 

Are you specifically after some to match common NZ data downloads? I did
some styles a while ago for a project on the Auckland Islands using the 150K
topo data. You are welcome to those if they help at all

 

Cheers - Phil

 

From: Qgis-user  On Behalf Of Tony
Shepherd (FarmMaps NZ)
Sent: Monday, 20 April 2020 11:07 AM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Shared line-style resources etc

 

Hi All

 

Hope that averyone is getting through whatever lockdown conditions you are
under ok.  Day 26 for us in New Zealand. 

 

I'm just wondering of any known shared resources for line styles, point
styles, svg libraries etc?  I have done some searching on the web and found
a few things scattered here and there but nothing really substantial.  I
imagined with QGIS being opensource and loads of plugins being shared that
there may be a similar resource for styles etc.

 

Cheers

Tony

 

Tony Shepherd  |  GeoSpatial / Mapping Manager

Ph 027 435 6193  |  E t...@farmmaps.nz  

FarmMaps NZ, 3 Kerwood Place, Gore 9740

 



 

 

 
 

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Shared line-style resources etc

[Tony Shepherd (FarmMaps NZ)]

Hi All

 

Hope that averyone is getting through whatever lockdown conditions you are
under ok.  Day 26 for us in New Zealand. 

 

I'm just wondering of any known shared resources for line styles, point
styles, svg libraries etc?  I have done some searching on the web and found
a few things scattered here and there but nothing really substantial.  I
imagined with QGIS being opensource and loads of plugins being shared that
there may be a similar resource for styles etc.

 

Cheers

Tony

 

Tony Shepherd  |  GeoSpatial / Mapping Manager

Ph 027 435 6193  |  E   t...@farmmaps.nz

FarmMaps NZ, 3 Kerwood Place, Gore 9740

 



 

 

 
 

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Unable to Clip Raster from WMS Source

[Nicolas Cadieux]

Hi,

You need to export the image first.  Try exporting the project as a .tiff then, 
you will be able to clip the new image.

Nicolas Cadieux
Ça va bien aller!

> Le 19 avr. 2020 à 20:01, Michael Demeyer  a écrit :
> 
> 
> Have connected a WMS server for the NAIP Imagery data (US Department of 
> Agriculture) to a layer in a project, which seems to function properly.  I am 
> trying to export a sub-section of the data using the Clip Raster by Extent 
> function, also specifying the resolution at 30 x 30 meters.
>  
> Below is the input string to GDAL that is created.  I consistently (100% of 
> the time) get an error saying “Failure: No Target Dataset Specified”
>  
> Have tried everything I can think of.  This command works fine for me on 
> local data, but is somehow not working for this WMS source.
>  
> Thanks!
>  
> Michael
>  
> QGIS version: 3.12.1-București
> QGIS code revision: 121cc00ff0
> Qt version: 5.11.2
> GDAL version: 3.0.4
> GEOS version: 3.8.1-CAPI-1.13.3
> PROJ version: Rel. 6.3.1, February 10th, 2020
> Processing algorithm…
> Algorithm 'Clip raster by extent' starting…
> Input parameters:
> { 'DATA_TYPE' : 0, 'EXTRA' : '', 'INPUT' : 
> 'contextualWMSLegend=0&crs=EPSG:4326&dpiMode=7&featureCount=10&format=image/jpeg&layers=0&styles&url=https://services.nationalmap.gov/arcgis/services/USGSNAIPImagery/ImageServer/WMSServer',
>  'NODATA' : None, 'OPTIONS' : '', 'OUTPUT' : 'E:/Flying/Landscape 
> Building/Imagery Test/jpeg test.bil', 'PROJWIN' : '415804, 761404, 3987838, 
> 4379518' }
>  
> GDAL command:
> gdal_translate -projwin 415804.0 4379518.0 761404.0 3987838.0 -of EHdr 
> contextualWMSLegend=0&crs=EPSG:4326&dpiMode=7&featureCount=10&format=image/jpeg&layers=0&styles&url=https://services.nationalmap.gov/arcgis/services/USGSNAIPImagery/ImageServer/WMSServer
>  "E:/Flying/Landscape Building/Imagery Test/jpeg test.bil"
> GDAL command output:
>  
>  
> FAILURE: No target dataset specified.
>  
> Sent from Mail for Windows 10
>  
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Unable to Clip Raster from WMS Source

[Michael Demeyer]

Have connected a WMS server for the NAIP Imagery data (US Department of 
Agriculture) to a layer in a project, which seems to function properly.  I am 
trying to export a sub-section of the data using the Clip Raster by Extent 
function, also specifying the resolution at 30 x 30 meters.

Below is the input string to GDAL that is created.  I consistently (100% of the 
time) get an error saying “Failure: No Target Dataset Specified”

Have tried everything I can think of.  This command works fine for me on local 
data, but is somehow not working for this WMS source.

Thanks!

Michael

QGIS version: 3.12.1-București
QGIS code revision: 121cc00ff0
Qt version: 5.11.2
GDAL version: 3.0.4
GEOS version: 3.8.1-CAPI-1.13.3
PROJ version: Rel. 6.3.1, February 10th, 2020
Processing algorithm…
Algorithm 'Clip raster by extent' starting…
Input parameters:
{ 'DATA_TYPE' : 0, 'EXTRA' : '', 'INPUT' : 
'contextualWMSLegend=0&crs=EPSG:4326&dpiMode=7&featureCount=10&format=image/jpeg&layers=0&styles&url=https://services.nationalmap.gov/arcgis/services/USGSNAIPImagery/ImageServer/WMSServer',
 'NODATA' : None, 'OPTIONS' : '', 'OUTPUT' : 'E:/Flying/Landscape 
Building/Imagery Test/jpeg test.bil', 'PROJWIN' : '415804, 761404, 3987838, 
4379518' }

GDAL command:
gdal_translate -projwin 415804.0 4379518.0 761404.0 3987838.0 -of EHdr 
contextualWMSLegend=0&crs=EPSG:4326&dpiMode=7&featureCount=10&format=image/jpeg&layers=0&styles&url=https://services.nationalmap.gov/arcgis/services/USGSNAIPImagery/ImageServer/WMSServer
 "E:/Flying/Landscape Building/Imagery Test/jpeg test.bil"
GDAL command output:


FAILURE: No target dataset specified.

Sent from Mail for Windows 10

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

[Bo Victor Thomsen]

Hi Michael -


All your questions are pertinent and needs to be redressed.


However one small personal nitpick: If I had a task involving importing 
200 or more  layers into Postgres from some other data-source I would 
never use DBManager import with it's manual point-and-click. That's 
simply to risky



I would use a command-line tool OGR2OGR, which is  included in the QGIS 
installation: https://gdal.org/drivers/vector/pg.html. It can be started 
using the shortcut "OSGeo4W Shell" placed in the same program group as QGIS.




--
Med venlig hilsen / Kind regards

Bo Victor Thomsen


Den 19-04-2020 kl. 16:35 skrev Michael Dufty:

Thanks Jorge,
The DB manager also 'just works' apparently regardless of which boxed 
I tick.  I'd just like to know what is going on or if I'm setting 
myself up for a problem later on if I load up 200 layers with the 
wrong boxes ticked.


Looking more closely, it has got text greyed out if you don't check a 
box, which may mean it is setting it to the defaults shown, and you 
only check the box if you want to change it.


It would be nice to know more rather than guessing.


*From:* Jorge Gustavo Rocha 
*Sent:* Sunday, 19 April 2020 5:41 PM
*To:* qgis-user@lists.osgeo.org 
*Subject:* Re: [Qgis-user] Options when loading layers into PostGIS 
with DBManager


Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers 
from the Layer panel into Postgresql. You don't have to choose any 
parameters. It just works.


Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:


Hi,

I am trying out saving data in PostGIS, and have got stuck on the 
upload “import layer/file” dialog in DB Manager.


Can anyone recommend a good reference on what options should be selected?

It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be 
selected in what circumstances.


In particular

Primary key – should this be ticked and the existing id field 
selected? What happens if it is left unticked?


Geometry column – is this needed? Objects still seem to have geometry 
if it is left out.


Create spatial index – this sounds like a good idea, but the one 
youtube tutorial I found (Klas Karlson) he left it unticked and said 
the layer already had everything. Is it needed for some source 
formats and not others eg shapefile vs geopackage?


Convert field names to lower case doesn’t sound very useful, but I 
presume it is there for a reason, does anyone know the circumstances 
that would be needed?


Cheers,

*Michael Dufty*

*Senior Environmental Engineer*



*MBS ENVIRONMENTAL**
*4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e: mdu...@mbsenvironmental.com.au 


w: www.mbsenvironmental.com.au

Disclaimer:
The information contained in this message is intended for those to 
whom it is addressed. It may contain confidential or privileged 
information and if you are not the intended recipient, you must not 
copy, distribute or take any action in reliance on it. If you 
received this message in error please destroy it and reply to the 
sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 8 
9226 3166 immediately. All care has been taken to ensure that this 
message and any attachments are virus free; we do not accept 
responsibility for any virus infections caused by receipt of this 
message//



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org  
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user

--
Logo    
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*j...@geomaster.pt  | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: *Rua António Cândido Pinto, 67, 4715-400 Braga


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

[Michael Dufty]

Answering my own question again.
It does look like leaving everything alone works pretty well.
Primary key unchecked results in a primary key being set up with the id column 
as shown in grey.  This caused a problem when the layer had a pre-existing 
non-unique id column.  Works fine if the existing id column has unique values, 
or does not exist.
Leaving the geometry column unticked seems to create a geom column (as shown in 
grey).
If a spatial index is needed and wasn’t ticked, a warning will show in db 
manager afterwards and it is easy to create one from there.

Just needs the documentation update to say not to worry about it.  A bit like 
the lack of documentation on how to upgrade an existing install.  It doesn’t 
seem to matter what you do, but you can waste a lot of time trying to look it 
up if too cautious.

Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D6169E.C91D6900]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

From: Michael Dufty 
Sent: Sunday, 19 April 2020 4:43 PM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Options when loading layers into PostGIS with DBManager

Hi,
I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.

Can anyone recommend a good reference on what options should be selected?
It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.

In particular
Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?
Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.
Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?

Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?

Cheers,


Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D6169E.C91D6900]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

[Michael Dufty]

Thanks Jorge,
The DB manager also 'just works' apparently regardless of which boxed I tick.  
I'd just like to know what is going on or if I'm setting myself up for a 
problem later on if I load up 200 layers with the wrong boxes ticked.

Looking more closely, it has got text greyed out if you don't check a box, 
which may mean it is setting it to the defaults shown, and you only check the 
box if you want to change it.

It would be nice to know more rather than guessing.


From: Jorge Gustavo Rocha 
Sent: Sunday, 19 April 2020 5:41 PM
To: qgis-user@lists.osgeo.org 
Subject: Re: [Qgis-user] Options when loading layers into PostGIS with DBManager


Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers from the 
Layer panel into Postgresql. You don't have to choose any parameters. It just 
works.

Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:

Hi,

I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.



Can anyone recommend a good reference on what options should be selected?

It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.



In particular

Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?

Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.

Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?



Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?



Cheers,





Michael Dufty

Senior Environmental Engineer



[cid:part1.109C90E4.CCE4590B@geomaster.pt]

MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177



e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.au

Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message





___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

--
[Logo]
Geomaster
Jorge Gustavo Rocha | Software Engineer
e: j...@geomaster.pt | m: +351 910 333 888
g: 41.54094,-8.40490 | v: 510 906 109
a: Rua António Cândido Pinto, 67, 4715-400 Braga
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS, Problem showing the outputs

[Alexander Bruy]

Hi Hamzeh,

you should contact plugin authors with this issue.

нд, 19 квіт. 2020 о 15:51 Hamzeh Mohammadigheymasi  пише:
>
> Hi
>
>  I am running 3.12.1-București on an Ubuntu 18.04. The goal is to run 
> OpenQuake IRMT plugin. It runs well and gives the outputs, however, I have 
> problems loading the results; more precisely, when I load the outputs, I 
> receive the following error:
>
>
> ValueError: 'Spectral' is not in list
> Traceback (most recent call last):
>   File 
> "/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_gmf_data_as_layer_dialog.py",
>  line 165, in accept
> super().accept()
>   File 
> "/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_output_as_layer_dialog.py",
>  line 875, in accept
> self.load_from_npz()
>   File 
> "/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_gmf_data_as_layer_dialog.py",
>  line 174, in load_from_npz
> self.iface, self.output_type)
>   File 
> "/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_output_as_layer_dialog.py",
>  line 581, in style_maps
> ramp_type_idx = default_color_ramp_names.index('Spectral')
> ValueError: 'Spectral' is not in list
>
>
> Please help me to solve the problem.
>
> Best Regards,
> Hamzeh
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alexander Bruy
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS, Problem showing the outputs

[Hamzeh Mohammadigheymasi]

Hi

 I am running 3.12.1-București on an Ubuntu 18.04. The goal is to run OpenQuake 
IRMT plugin. It runs well and gives the outputs, however, I have problems 
loading the results; more precisely, when I load the outputs, I receive the 
following error:


ValueError: 'Spectral' is not in list
Traceback (most recent call last):
  File 
"/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_gmf_data_as_layer_dialog.py",
 line 165, in accept
super().accept()
  File 
"/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_output_as_layer_dialog.py",
 line 875, in accept
self.load_from_npz()
  File 
"/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_gmf_data_as_layer_dialog.py",
 line 174, in load_from_npz
self.iface, self.output_type)
  File 
"/home/shazam/.local/share/QGIS/QGIS3/profiles/default/python/plugins/svir/dialogs/load_output_as_layer_dialog.py",
 line 581, in style_maps
ramp_type_idx = default_color_ramp_names.index('Spectral')
ValueError: 'Spectral' is not in list


Please help me to solve the problem.

Best Regards,
Hamzeh
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Dumb USGS geotiff questions

[Mike Flannigan]

It may sound like I know what I am talking about,
but you may not want to make that assumption.

Everything is working fine for you.  Older USGS
topo maps (~1980 and earlier) are in NAD27 datum.
Newer maps (~1990 and newer) might be in WGS84,
but I'm not sure about that.

I'm thinking if you change your datum to NAD27
that deviation may go away.

I believe the older files can be changed to WGS84
with GDAL if needed, but I generally just leave them
in NAD27.  In MO, where I normally work, the difference
between NAD27 and WGS84 is pretty small - roughly the
amount shown on your maps.  I would expect it to be
higher where you are working - near Oakland, CA:
http://www.mflan.com/temp/shift.png


Mike



On 4/19/20 4:41 AM, qgis-user-requ...@lists.osgeo.org wrote:

Date: Sat, 18 Apr 2020 14:43:03 -0700
From: Morgan Fletcher
To:qgis-user@lists.osgeo.org
Subject: [Qgis-user] Dumb USGS geotiff questions
Message-ID:

Content-Type: text/plain; charset="utf-8"

(Resending, with screenshots as google drive links, to cut down message
size.)

I am running 3.12.1-București on a mac, os-x 10.14.6. My knowledge of GIS
is rudimentary, I've learned what I need to, to satisfy my curiosity about
my region, using old maps.

I have downloaded all the USGS maps for my region - Oakland, CA, USA, which
corresponds to "CA Concord" - from USGS topoView, in geotiff format.
Opening them in QGIS gives fairly wild offsets; they are not all encoded
the same way, yet have common corners. Features on the map vary with what
modern maps show, but getting their corners right would help me a lot.

If I create a new project, set my CRS to WGS 84 / Pseudo-Mercator
(EPSG:3857) as I think is correct for my base map, Google Maps (EPSG:3857 -
WGS 84 / Pseudo-Mercator - Projected) then Layer > Add Layer > Add Raster
Layer > Raster Dataset > CA_Concord_465520_1943_62500_geo.tif > Add, I get
prompted with:

https://drive.google.com/file/d/1FKVPrHLtXXKK8a-QTTz3IigT9dpj1Hou/view?usp=sharing

I don't know what to choose, here. I chose the first one. I've tried
others. The tif.prj file does say
DATUM["D_North_American_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],
which I am guessing conforms to NAD27. If I add an opacity slider to the
new raster layer, set its opacity, and then use the Zoom to Coordinate
panel to navigate to 37º45'N 122º15'W, I find that the point is off from
what's on the map, see:

https://drive.google.com/file/d/10vYtcM1FZ-vdS3z1FPW2EYbrNy2sj65L/view?usp=sharing

This is similarly true at the top left:

https://drive.google.com/file/d/18naBKuwk6rZ9DP0tFOZxnGKlIpRQgDKM/view?usp=sharing

Also, note how the map shows two lines at top left, it's true at top right.
This is something to do with projection, I think. I've tried to
georeference these lines, to get them to line up right, but which
intersection do I use, when there are two vertical lines intersecting with
the top, horizontal border, to reference 122º 15' 38º 00' ? I've had mixed
results, trying to use deg-min-ss coordinates to georeference these; I get
a map off the west coast of Africa. Using points on the map is more
successful.

All the maps have slightly variant values in their tfw files. Their prj
files are more uniform, but also show variations. I'd like to normalize
them all, so that I can view the USGS topo maps for my region over time.
Advice?

Thanks,

Morgan



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

[Jorge Gustavo Rocha]

Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers
from the Layer panel into Postgresql. You don't have to choose any
parameters. It just works.

Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:
>
> Hi,
>
> I am trying out saving data in PostGIS, and have got stuck on the
> upload “import layer/file” dialog in DB Manager.
>
>  
>
> Can anyone recommend a good reference on what options should be selected?
>
> It seems to fall into a gap between PostGIS documentation and QGIS
> documentation and I can’t find any information on what should be
> selected in what circumstances.
>
>  
>
> In particular
>
> Primary key – should this be ticked and the existing id field
> selected? What happens if it is left unticked?
>
> Geometry column – is this needed? Objects still seem to have geometry
> if it is left out.
>
> Create spatial index – this sounds like a good idea, but the one
> youtube tutorial I found (Klas Karlson) he left it unticked and said
> the layer already had everything.  Is it needed for some source
> formats and not others eg shapefile vs geopackage?
>
>  
>
> Convert field names to lower case doesn’t sound very useful, but I
> presume it is there for a reason, does anyone know the circumstances
> that would be needed?
>
>  
>
> Cheers,
>
>  
>
>  
>
> *Michael Dufty*
>
> *Senior Environmental Engineer*
>
>  
>
>   
>
> *MBS ENVIRONMENTAL**
> *4 Cook Street, West Perth  WA 6005

> t:+61 8 9226-3166
> f:+61 8 9226-3177
>
>  
>
> e:   mdu...@mbsenvironmental.com.au
> 
> w:   www.mbsenvironmental.com.au
> http://www.mbsenvironmental.com.au/>
>
> Disclaimer: 
> The information contained in this message is intended for those to
> whom it is addressed. It may contain confidential or privileged
> information and if you are not the intended recipient, you must not
> copy, distribute or take any action in reliance on it. If you received
> this message in error please destroy it and reply to the sender
> immediately or contact Martinick Bosch Sell Pty Ltd. on +61 8 9226
> 3166 immediately. All care has been taken to ensure that this message
> and any attachments are virus free; we do not accept responsibility
> for any virus infections caused by receipt of this message//
>
>  
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Email Signature
Logo  
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*j...@geomaster.pt | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: * Rua António Cândido Pinto, 67, 4715-400 Braga

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Options when loading layers into PostGIS with DBManager

[Michael Dufty]

Hi,
I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.

Can anyone recommend a good reference on what options should be selected?
It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.

In particular
Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?
Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.
Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?

Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?

Cheers,


Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D61669.130A2F20]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user