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;








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?










share|improve this question
























  • 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


















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?










share|improve this question
























  • 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














0












0








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?










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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


















  • 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











1 Answer
1






active

oldest

votes


















0














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






share|improve this answer























    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
    );



    );













    draft saved

    draft discarded


















    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









    0














    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






    share|improve this answer



























      0














      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






      share|improve this answer

























        0












        0








        0







        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






        share|improve this answer













        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







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Mar 8 at 5:13









        kartoza-geekkartoza-geek

        5461310




        5461310



























            draft saved

            draft discarded
















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

            រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

            Ромео және Джульетта Мазмұны Қысқаша сипаттамасы Кейіпкерлері Кино Дереккөздер Бағыттау мәзірі