Nov
10
comment PostgreSQL optimization: Select road edges where start and end vertex is in some set
In first SELECT I compare with e.target and in second with e.source
Nov
10
comment PostgreSQL optimization: Select road edges where start and end vertex is in some set
You can't reference table e in second select as it's not in FROM part.
Nov
10
comment PostgreSQL - PostGIS query optimization
I read there's no performance gain when joining using JOIN. ST_MarkeEnvelope is PostGIS function to create rectange of specific extent. The columns used for joining are indexed.
Nov
10
asked PostgreSQL optimization: Select road edges where start and end vertex is in some set
Nov
10
asked PostgreSQL - PostGIS query optimization
Sep
3
awarded Taxonomist
Aug
25
awarded Popular Question
Jul
2
awarded Curious
Jul
2
awarded Notable Question
Feb
26
awarded Tumbleweed
Feb
23
awarded Yearling
Feb
23
awarded Yearling
Feb
19
asked How to set up ArcGIS Online application to let non-logged users add data?
Nov
13
awarded Student
Nov
13
asked Is antumbra part of shadow darker than penumbra part of shadow?
Nov
10
comment How to accurately place geographic object into photo?
I'm after several SketchUp Photo Match tutorials and still have no idea how to properly match the landscape photo (with no significant lines to match) to SketchUp scene. The same with overlay: SketchUp scene is in different scale than photo. I'm stuck how to align scene with the photo. Do you have any hints?
Nov
9
comment Length of solid part of object shadow
The behaviour of light is actually of my concern. But not in local scale (scattering). Rather between Sun and object. That's why I ask if I can use the same relations as between Sun and Earth to Sun and object.
Nov
9
comment Length of solid part of object shadow
I made an edit and fixed simplified equation. There's L=2*108*Ro. Sorry. Btw, can you explain the term "solid angle of the sun"?
Nov
9
awarded Editor
Nov
9
revised Length of solid part of object shadow
fixed simplified equation - added D_o symbol (object diameter)
1 2 3 4 5