How to get an ECW file into a database which QGIS can read? The 2019 Stack Overflow Developer Survey Results Are In Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar ManaraLoading a raster using QGIS into a PostGIS2.0 enabled databaseCan QGIS read an ODBC connection?How to import ECW into my postgis database with raster2pgsql (windows)How to import GeoTIFF via postGIS into GeoServer?Viewing .ecw-file in QGIS?Cannot read postgis RASTER into ArcGIS using the interoperability extension, either directly by Query LayerQGIS as Spatial Database RAD or Hierarchical Attribute Viewer/Editor?How to pull a shapefile into R from PostGIS database (in Windows)?What's the benefit of heterogeneous geometry column in PostGIS?Importing / copying data from PostGIS to ArcGIS / ArcMAPHow to get ECW support on QGIS 2.16 - Ubuntu 16.04?
How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?
Is every episode of "Where are my Pants?" identical?
Why doesn't a hydraulic lever violate conservation of energy?
Didn't get enough time to take a Coding Test - what to do now?
Why can't wing-mounted spoilers be used to steepen approaches?
Windows 10: How to Lock (not sleep) laptop on lid close?
"... to apply for a visa" or "... and applied for a visa"?
What can I do if neighbor is blocking my solar panels intentionally?
What was the last x86 CPU that did not have the x87 floating-point unit built in?
Why not take a picture of a closer black hole?
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
What's the point in a preamp?
Would an alien lifeform be able to achieve space travel if lacking in vision?
Can each chord in a progression create its own key?
Could an empire control the whole planet with today's comunication methods?
What is the padding with red substance inside of steak packaging?
Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?
Sort list of array linked objects by keys and values
How do spell lists change if the party levels up without taking a long rest?
Am I ethically obligated to go into work on an off day if the reason is sudden?
Presidential Pardon
Homework question about an engine pulling a train
Does Parliament hold absolute power in the UK?
Loose spokes after only a few rides
How to get an ECW file into a database which QGIS can read?
The 2019 Stack Overflow Developer Survey Results Are In
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraLoading a raster using QGIS into a PostGIS2.0 enabled databaseCan QGIS read an ODBC connection?How to import ECW into my postgis database with raster2pgsql (windows)How to import GeoTIFF via postGIS into GeoServer?Viewing .ecw-file in QGIS?Cannot read postgis RASTER into ArcGIS using the interoperability extension, either directly by Query LayerQGIS as Spatial Database RAD or Hierarchical Attribute Viewer/Editor?How to pull a shapefile into R from PostGIS database (in Windows)?What's the benefit of heterogeneous geometry column in PostGIS?Importing / copying data from PostGIS to ArcGIS / ArcMAPHow to get ECW support on QGIS 2.16 - Ubuntu 16.04?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have ECW imagery I want to store in my spatial database. I am using QGIS and a PostGIS database. How do I do it?
Everything I have read so far (its actually unreadable to me) seems way too complicated when I was hoping for a drag'n'drop, cut'n'paste or "import to database" kind of solution. I'm a geographer not an IT boffin.
Anything out there, or should I buy an Esri license?
qgis postgis ecw
add a comment |
I have ECW imagery I want to store in my spatial database. I am using QGIS and a PostGIS database. How do I do it?
Everything I have read so far (its actually unreadable to me) seems way too complicated when I was hoping for a drag'n'drop, cut'n'paste or "import to database" kind of solution. I'm a geographer not an IT boffin.
Anything out there, or should I buy an Esri license?
qgis postgis ecw
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32
add a comment |
I have ECW imagery I want to store in my spatial database. I am using QGIS and a PostGIS database. How do I do it?
Everything I have read so far (its actually unreadable to me) seems way too complicated when I was hoping for a drag'n'drop, cut'n'paste or "import to database" kind of solution. I'm a geographer not an IT boffin.
Anything out there, or should I buy an Esri license?
qgis postgis ecw
I have ECW imagery I want to store in my spatial database. I am using QGIS and a PostGIS database. How do I do it?
Everything I have read so far (its actually unreadable to me) seems way too complicated when I was hoping for a drag'n'drop, cut'n'paste or "import to database" kind of solution. I'm a geographer not an IT boffin.
Anything out there, or should I buy an Esri license?
qgis postgis ecw
qgis postgis ecw
edited Mar 4 at 2:53
Vince
14.8k32850
14.8k32850
asked Mar 4 at 2:24
Matt DMatt D
13
13
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32
add a comment |
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32
add a comment |
1 Answer
1
active
oldest
votes
What operating system are you using? I suspect you are using windows.
If so you should go to
Start Menu>Programs >QGIS>Osgeo shell. This will open a shell where you can use the raster2pgsql command as specified in the tutorials. In order to get the path where your raster is use the file explorer and copy the path. Remember to quote the full path as it might be having spaces eg “C:/users/Documents/test.tif”
Alternatively look at this answer Loading a raster using QGIS into a PostGIS2.0 enabled database
If the above solutions do not work for you please consider investing the money you were to use for an Esri License to sponsor a QGIS developer to write a GUI for you and the whole community will benefit. Get in touch
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314229%2fhow-to-get-an-ecw-file-into-a-database-which-qgis-can-read%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
What operating system are you using? I suspect you are using windows.
If so you should go to
Start Menu>Programs >QGIS>Osgeo shell. This will open a shell where you can use the raster2pgsql command as specified in the tutorials. In order to get the path where your raster is use the file explorer and copy the path. Remember to quote the full path as it might be having spaces eg “C:/users/Documents/test.tif”
Alternatively look at this answer Loading a raster using QGIS into a PostGIS2.0 enabled database
If the above solutions do not work for you please consider investing the money you were to use for an Esri License to sponsor a QGIS developer to write a GUI for you and the whole community will benefit. Get in touch
add a comment |
What operating system are you using? I suspect you are using windows.
If so you should go to
Start Menu>Programs >QGIS>Osgeo shell. This will open a shell where you can use the raster2pgsql command as specified in the tutorials. In order to get the path where your raster is use the file explorer and copy the path. Remember to quote the full path as it might be having spaces eg “C:/users/Documents/test.tif”
Alternatively look at this answer Loading a raster using QGIS into a PostGIS2.0 enabled database
If the above solutions do not work for you please consider investing the money you were to use for an Esri License to sponsor a QGIS developer to write a GUI for you and the whole community will benefit. Get in touch
add a comment |
What operating system are you using? I suspect you are using windows.
If so you should go to
Start Menu>Programs >QGIS>Osgeo shell. This will open a shell where you can use the raster2pgsql command as specified in the tutorials. In order to get the path where your raster is use the file explorer and copy the path. Remember to quote the full path as it might be having spaces eg “C:/users/Documents/test.tif”
Alternatively look at this answer Loading a raster using QGIS into a PostGIS2.0 enabled database
If the above solutions do not work for you please consider investing the money you were to use for an Esri License to sponsor a QGIS developer to write a GUI for you and the whole community will benefit. Get in touch
What operating system are you using? I suspect you are using windows.
If so you should go to
Start Menu>Programs >QGIS>Osgeo shell. This will open a shell where you can use the raster2pgsql command as specified in the tutorials. In order to get the path where your raster is use the file explorer and copy the path. Remember to quote the full path as it might be having spaces eg “C:/users/Documents/test.tif”
Alternatively look at this answer Loading a raster using QGIS into a PostGIS2.0 enabled database
If the above solutions do not work for you please consider investing the money you were to use for an Esri License to sponsor a QGIS developer to write a GUI for you and the whole community will benefit. Get in touch
answered Mar 8 at 5:13
kartoza-geekkartoza-geek
5461310
5461310
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314229%2fhow-to-get-an-ecw-file-into-a-database-which-qgis-can-read%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
convert your ecw file to tiff first > gdal.org/frmt_ecw.html example gdal_translate -of ECW -co TARGET=0 -a_srs EPSG:4326 input.ecw output.tif
– Mapperz♦
Mar 4 at 3:09
OK then....... I have a tiff but still none the wiser how to get it into my PostGIS database, I've read about something called "raster2pgsql" but no idea what that is, where it is or how to use it. Most stuff I've read seems to presume once you know this phrase you know how to use it? Do I type it in somewhere? or download it and run it? "Gdal" also pops up a lot but again no idea what that is, I don't write script or code just reading about that stuff is gobbledygook to me. Whatever happened to tools/ buttons like "import to database". Very Frustrating
– Matt D
Mar 4 at 23:32