On Fri, Jan 17, 2020 at 11:00 AM Amith Patil <amitn.r...@gmail.com> wrote: > > Hi, > > I have a scenario where i have to download the tif file from server and store > it in the postgres DB as png with the given lat,long values. > > Anyone has any idea on how to proceed? Im doing this for the first time, > hence i have very limited knowledge on this. >
Unfortunately that's a very wide question with no short answer. For example, do you need help with downloading files from a server, converting TIF to PNG, reading lat/long from GeoTIFF? This isn't really the mailing list to help you with any of that. Do you have an existing database that you want to put this data into, or are you designing a new database? If it's the latter, then the table structure will depend on how you are going to use the data afterwards. If you're going to be querying by lat/long values, you may want to use the postgis extensions for geographic data types. SQLAlchemy can help you with inserting binary data into a database table (eg. by using the LargeBinary column data type). If you haven't done anything like this before, you could perhaps start by following the tutorial at https://docs.sqlalchemy.org/en/13/orm/tutorial.html. Then try adding a LargeBinary column to the User table and store some binary data in it. Hope that helps, Simon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAFHwexf%2BoD0yq3Q%2B-onk1kT6YcjGAM205JFBWaZdiecaL6OSbg%40mail.gmail.com.
