Aug
4
comment SQL Server geometry vs. geography in Esri map service
@mapBaker, This perfectly make sense - we planned to end up with DB view. But I still wonder which spatial type will suit/perform better - geometry or geography.
Aug
4
comment SQL Server geometry vs. geography in Esri map service
@Vince, we're just starting and have about 300 points so far. What is your suggestion to avoid on-the-fly projection? I haven't found native SQL Server 2008 function which project data from WGS84 to projected CS.
Aug
4
comment SQL Server geometry vs. geography in Esri map service
@mapBaker, thanks for the answer - it proves that SQL Server geometries can successfuly be used in Esri services. However, it doesn't answer my question as you already have geometries in SQL Server and we have only coordinates.
Aug
4
comment SQL Server geometry vs. geography in Esri map service
What are "potential issues" with using geometry with geographic coordinates?
Aug
4
asked SQL Server geometry vs. geography in Esri map service
Feb
28
awarded Self-Learner
Feb
23
awarded Yearling
Feb
23
awarded Yearling
Dec
12
awarded Notable Question
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
Feb
26
awarded Tumbleweed
Nov
13
awarded Student
Nov
13
asked Is antumbra part of shadow darker than penumbra part of shadow?
1 2 3 4 5