Timeline for Building polygon shadows in PostGIS
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 18, 2018 at 7:29 | comment | added | John Powell | I think this is the most interesting question I have seen for a while. Now that is is possible to do arbitrary rotations, translations and 3D intersections in Postgis, I am certain this can be done. I have just recently started using both the sfgcal functions in Postgis and Cesium to do some fun line of sight type work. Unfortunately, I am severely swamped right now at work, but, I will think about this while walking the dog and attempt to come up with an answer in the next few days, if it isn't answered first. Sady, I don't think there is too much experience in this area of Postgis yet. | |
| Apr 18, 2018 at 7:00 | comment | added | LMB | @JohnPowellakaBarça, Thanks for the suggestion. Actually we will not be presenting the shadows at all. They will only be used as input for determining the 'cost' i.e. shadowness of a route. | |
| Apr 17, 2018 at 15:08 | comment | added | John Powell | Have you thought of using Cesium to do the shadows? While I am certain it can be done in Postgis, it might be more natural in Cesium. I guess it depends on how you are presenting it? | |
| Apr 14, 2018 at 20:55 | comment | added | LMB | The Netherlands. See: pdok.nl/nl/ahn3-downloads (only in Dutch) | |
| Apr 14, 2018 at 19:08 | comment | added | John Powell | 50cm DSM, weeps with jealousy, which country or region, out of interest | |
| Apr 14, 2018 at 19:06 | comment | added | John Powell | I believe that this should be approximately possible using st_azimuth, st_extrude and some vector calcs to project the intersection of the building roof area on the ground based on time of day. I don't have a laptop in front on me, but it is an interesting problem and related to some work I am already doing. | |
| Apr 12, 2018 at 16:25 | answer | added | J.R | timeline score: 2 | |
| Apr 12, 2018 at 16:05 | history | asked | LMB | CC BY-SA 3.0 |