geography_开发者

Java issue with Lat/Long and distance

I am trying to get a portion of code to work (similar to what I have below), so that OBJECT_LOC and CONVERTED_LOC are exactly the same.I thought the code was pretty straightforward with what I was doi[详细]

2023-04-11 21:01 分类：问答

Calculating surface fragments (continents) on an expanding sphere (Earth)

Let\'s suppose plate tectonics is wrong and our planet Earth has expanded over time, the continents being the remnants of a crust that once covered the entire surface of a smaller planet, the oceans f[详细]

2023-03-22 13:37 分类：问答

Convert "geometry" into "geography"

I\'m on a test project to learn about geolocation tools. But being a neophyte, a few concepts in PostGIS escape me.[详细]

2023-03-19 18:15 分类：问答

Python: speeding up geographic comparison

I\'ve written some code that includes a nested loop where the inner loop is executed about 1.5 million times. I have a function in this loop that I\'m trying to optimize. I\'ve done some work, and got[详细]

2023-03-19 06:46 分类：问答

how to get the index of a point from geography?

How can i get the index of a point which is in my LineString? I am using SQL Server 2008 R2. I do have a geography type where a LineString is saved in.[详细]

2023-03-14 18:17 分类：问答

SQL Server 2008 R2 Geography Distance?

I have created a table with the following columns: Text:varchar(255) Location:geography They contain a few city\'s from The Netherlands as data (got the coordinates from google maps):[详细]

2023-03-13 12:59 分类：问答

How to get all parks of the world with address and lat/lng

I am trying to import a list of all parks in the world and data about them.I need the following information:[详细]

2023-03-01 18:55 分类：问答

Simulate HTTP requests from different location - ASP.Net

I\'ve an asp.net application which shows some information to the users relevant to the country they are from. So I want to do functional testing on my application. How I can simulate HTTP requests to[详细]

2023-02-28 06:20 分类：问答

SQLServer Spatial query is returning error An expression of non-boolean type specified in a context where a condition is expected, near ')'

I am trying to learn how to do radius search on records using the new SqlServer 2008 managed spacial type and methods (geography) for doing geospatial calculations.I am following the samples on this w[详细]

2023-02-19 21:54 分类：问答

Population-weighted center of a state

I have a list of states, major cities in each state, their populations, and lat/long coordinates for each. Using this, I need to calculate the latitude and longitude that corresponds to the center of[详细]

2023-02-08 22:14 分类：问答