[postgis-users] OSM and US DEM in PostGIS

[Siddarth Madala]

I have loaded the OSM data and uploaded the rasters into the database.
However I cannot find a way to query all data within a radius of a (long,
lat) coordinate pair while seeding each returned part of the data with its
corresponding elevation value from the rasters. Any query with ST_DWithin
or similar does not return any rows even though the database is populated.
It could be a projection issue. If you would be able to point me in the
direction of any tutorials/walkthroughs of how to do this, I would
appreciate it.

On Sun, Jun 20, 2021 at 9:45 PM James Keener <jim at jimkeener.com> wrote:

> Can you explain the issue you're having and what you've tried? I've loaded
> the DEM data into postgis before and have been able to query it and use it
> in QGIS.
>
> Jim
>
> On Sun, Jun 20, 2021 at 3:57 PM Siddarth Madala <sidmadala at gmail.com>
> wrote:
>
>> I was looking for some assistance with the following problem. My use case
>> of PostGIS is to store the United States' OpenStreetMap (OSM) data. This is
>> a solved problem with a significant amount of documentation available.
>> However, my use case differs in that I want to add US DEM elevation rasters
>> to the database to enable my application to query and receive a graph
>> seeded with these elevation values depending on my users' location. This
>> problem has almost no good documentation, and most solutions are outdated
>> or fail on my test server. Other services that provide elevation on demand
>> are either too costly or do not provide a small enough resolution for my
>> use case. Thus, I hope that anyone can aid me in the setup and deployment
>> on this bespoke database.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210624/8b177f79/attachment.html>