Stack Overflow
Stack Overflow

Questions tagged [geography]

Geography is the science that deals with the study of the Earth and its lands, features, inhabitants, and phenomena.

The use of traditional spatial techniques used in cartography and topography and their application to computers is called geomatics, which encompasses a large area of fields involved with analysis, such as , Geographic information systems (), Remote sensing, and Global positioning systems ().

The above excerpt is quoted from Wikipedia.

There is a Stack Exchange site devoted to Geographic Information Systems.

498 questions
7
votes
4 answers

How to correct Polygon Ring Orientation using C# Entity Framework 5 DbGeography Spatial Data

I'm working with the new Entity-Framework 5 using the Spatial data type DbGeography as part of my model for storing in one instance, a POINT and in another instance a POLYGON. When setting the value of my POLYGON all saves with no error however this…
cronline
  • 141
  • 2
  • 4
7
votes
0 answers

Instagram API Real Time geography subscriptions - too few requests

I've implemented the real time functionality on the Instagram API by subscribing to 5 geographies. These geographies pretty much cover the area of Bucharest, so I'm thinking I should get a lot of action from Instagram's servers. Here's the way I…
Adi Dabu
  • 71
  • 5
6
votes
2 answers

Finding a geography point within a range of another - SQL Server

I have a table in SQL Server that has geography datatype column in it. I want to query this table to find rows that fall near (within a range) of another given geography point. Does anyone have any ideas as to the best way to do this? I have 2…
Ben Cameron
  • 4,335
  • 6
  • 51
  • 77
6
votes
1 answer

ogr2ogr does not create tables

im trying to import some shapes to SQL using ogr2ogr command following this guide https://alastaira.wordpress.com/ogr2ogr-patterns-for-sql-server/ Im using this command: ogr2ogr -overwrite -f MSSQLSpatial [connection string] [shapefile] -nln…
LaPregunta
  • 191
  • 1
  • 2
  • 6
6
votes
2 answers

SQL Server : Geography search performance - query nearest stores

I have a performance query nearest stores: We have a table that contains around 50,000 records (stores/point of sale locations) in one country. Each record has location columns of type "geography" [LOCATION_geo] [geography] Also for performance I…
Tarek El-Mallah
  • 4,015
  • 1
  • 31
  • 46
5
votes
1 answer

Calculate Earth convex hull polygon area given latitude and longitude

I have searched for explanations and algorhitms how to calculate Earth's polygon surface area. I've found this and this Lets say I got already convex hull points [56.992666,24.126051], [58.00282,25.930147], [58.787955,25.565078],…
Skyzer
  • 584
  • 3
  • 11
  • 27
5
votes
2 answers

Which method is better in order to get the direction?

I want to get the direction in Android. There are two methods. One is the orientation sensor. The value of data value[0] is the azimuth: angle between the magnetic north direction and the y-axis, around the z-axis (0 to 359). 0=North, 90=East,…
flypen
  • 2,515
  • 4
  • 34
  • 51
5
votes
2 answers

SQL Server geography testing if a point is within a bounds - what does STWithin() do?

I am testing various SQL geography type methods - specifically, I want to understand the difference between STContains() and STWithin(). According to the docs: StWithin() - Returns 1 if a geography instance is spatially within another geography…
bdcoder
  • 3,280
  • 8
  • 35
  • 55
5
votes
2 answers

PostGIS: register a "geometry" column without AddGeometryColumn

The usual way to create a geometry column is AddGeometryColumn, however I have to work with pre-existing columns, so I can't use that function (as far as I know). Thanks to the PostGIS docs, I can already register the column in the…
wildpeaks
  • 7,273
  • 2
  • 30
  • 35
5
votes
4 answers

How to restrict app usability to a certain geographical area ANDROID

I want to define a geographical boundary outside of which, the app will refuse to work. I already know how to do this with a square bound by two lat/long pairs: if ((dLAT.doubleValue() > 35.309171) || (dLAT.doubleValue() < 35.226442) ||…
Nerdy Bunz
  • 6,040
  • 10
  • 41
  • 100
5
votes
1 answer

Spatial results tab saying:One or more spatial objects were too large to display

I've saved country borders in my sql server 2012 as geography data from geojson files. It turns out that when I query all the boundaries that have an administration level 2, not all the polygons are shown in the "spatial results" tab. Clearly this…
Carlo Luther
  • 2,402
  • 7
  • 46
  • 75
5
votes
1 answer

In R how to convert Longitude and Latitude to a format that can be used in ggplot2 or ggmap

I got a raw Longitude/Latitude data whose format cannot be processed by R map. So I wonder if there are some R functions or algorithms to help me to convert those raw data into a readable format. (Maybe UTM) Here is the raw data I…
Ye Xu
  • 83
  • 3
  • 10
5
votes
1 answer

C# SQLGeography: diagnosing invalid geometries

We have a large amount of geography stored in MapInfo tables that we would now like to store in SQL Server. We have written C# utilities to read the geography from the MapInfo files and import them into SQL server. For the most part, this is…
jmcstwm
  • 51
  • 3
5
votes
4 answers

How to extract Geographic data from open street map or Google maps

i need to retrieve all the city names from a specific country using openstreet map or google maps. is there any API available? or is there any other way of getting this world geographic data?
RameshVel
  • 64,778
  • 30
  • 169
  • 213
5
votes
3 answers

How to set a point as default value for a geography column?

I have this SQL command that creates a table with a GEOGRAPHY-type column for spatial data that is meant to store a latitude/longitude pair (a point). How can I set a default value for that column? For example, a point at (0,0)? CREATE TABLE…
Rob
  • 11,492
  • 14
  • 59
  • 94
1 2 3
…
33 34