Questions tagged [geography]

Questions using this tag are likely to be off-topic because this is the Geographic Information Systems (GIS) Stack Exchange and its scope does not stretch to general geography

Filter by
Sorted by
Tagged with
1
vote
0answers
32 views

Rendering 3D map in pgAdmin 4 to view Data? [on hold]

I found this error 3D geometrics not rendered in view data (pgAdmin 4). In GeoDjango I've updated my PointField model with dim=3. After successful migration, I cannot see my data in map. My Django ...
-4
votes
2answers
57 views

Straight line through the earth (not core) from America to which country? [closed]

If you were to draw a straight line, or dig a tunnel, through America, where would you end up? To clarify: Let's say you have a globe that sits upright on a table so that the south pole is on the ...
0
votes
0answers
36 views

Dealing with non-nested geographic units using the RQGIS and tigris R packages

I recently came across this tutorial suggesting that the RQGIS and tigris R packages could be used to overcome issues with non-nested geographies: https://rpubs.com/corey_sparks/256942 I'm trying to ...
1
vote
1answer
37 views

Area between two longitudes? [closed]

I am trying to compute the area between two longitudes (using the angle between them) but am having a hard time. I can do that more easily between latitudes but longitude reveals to be tricky. Anyone ...
1
vote
0answers
269 views

Use Natural Earth data set in Cesium

I have saved NaturalEarth data set in my desktop. Then I created a view as below. <script> var viewer = new Cesium.Viewer('cesiumContainer', { ...
1
vote
2answers
468 views

Using SqlGeometry.MakeValid to get a counter-clockwise polygon in SQL Server

The data I've loaded from a shapefile into a geometry column in SQL Server (using NetTopologySuite) is not producing valid GeoJSON when I export it because it doesn't follow the right-hand rule. I ...
4
votes
0answers
779 views

When does WKT orientation matter for polygon and multipolygon in geography spatial (left/right hand rule, counter-clockwise, clockwise)

I've decide to use sql server on Azure for my gis database. I'll be dealing with spatial Geography not Geometry. While inserting some country boundaries using the spatial data in SQL Server, some ...
0
votes
1answer
53 views

Kriging: Large standard error very close to known value points

I am attempting to create surfaces of strata via Kriging in Arc GIS from borehole data. In addition to the predicted surface I also want surfaces showing 95% confidence above and below the predicted ...
2
votes
1answer
147 views

How to use use_spheroid=false in ST_DWithin?

I have created 2 geography columns and indexed them using GIST. I am looking to use ST_DWithin for a larger dataset and to make it faster trying to use the use_spheroid=false. SELECT pois.objectid, ...
3
votes
1answer
184 views

Number of Eastern Africa countries [closed]

Are Rwanda and Burundi part of "Eastern Africa countries" or "East African countries". Some sources are differing.
0
votes
1answer
66 views

Alternative ST_NumGeometries in type geography

In PostGIS (2.1.8) I use function ST_NumGeometries for nums of count geometry. This function have one argument 'geometry' type. I need this function for geography type. I looked for but I didn't find ...
0
votes
1answer
85 views

Malaria Mortality Rate GIS Data [closed]

Can anyone direct me to GIS data for malaria mortality rate? I am looking for countries in South Asia, but not looking for country level numbers but smaller level numbers like district level.
1
vote
1answer
207 views

In PostGIS how can I do an ST_Intersection() search with a GEOMETRYCOLLECTION Geography field?

I have a Postgres table "files" with a lat/lon location field of type geography(GeometryCollection,4326). Right now the field only contains lat/lon polygons. I have succeeded in creating a gist index ...
1
vote
1answer
1k views

Calculate vertices' coordinates of a rectangle, given midline and broadth of rectangle

I have latitude and longitude of two points making the midline of a rectangle. Now I want to determine coordinates of 4 vertices of that rectangle. I know how to calculate on plane geometry by using ...
6
votes
3answers
4k views

Which is the most accurate method of measuring distance?

I aim to analyse the accuracy of the various methods of geodesic calculations (distance between two points on Earth)based on the three assumed models of Earth - flat, spherical & ellipsoidal. I ...
2
votes
1answer
1k views

Distance from point stored in geometry with SRID 4326

I have stored 2.5 million data points (addresses) using the geometry data type in column latlong with SRID 4326. The latlon - column has a GIST index defined. I would select all addresses within a ...
2
votes
1answer
56 views

Half of Earth with most landmass [closed]

About 71% of the Earth's surface is covered with water and the remaining 29% is landmass*. If you could theoretically cut the planet in half, with the objective of producing a half with the most ...
2
votes
0answers
50 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
1
vote
1answer
275 views

PostGIS - st_intersects using polygons that cross antimeridan/equator

New to using PostGIS and have two situations that I'm working with. In the one case, I have a polygon that crossed the antemeridian and was detecting whether a two separate points located within that ...
0
votes
1answer
214 views

Use QuadTree for better complexity on search features

I want to improve the complexity of search specific feature when using this function : map.forEachFeatureAtPixel(e.pixel, function (feature, layer) { // Do something.. }); The improvment ...
1
vote
1answer
109 views

“polygon” on sphere postgis geography

I have a set of points defined by their longitude and latitude, and I would like to check if they lie within a "polygon" on sphere. By polygon on sphere, I mean area in between 4 lines going between 4 ...
3
votes
2answers
885 views

GeoJson to Spatial Geography in sql server 2012, fix orientation of polygon

I've download from Mapzen many geoJson files related to countries with their respective administration level. Then I've parsed all the geoJson files and saved them to my sql server 2012 as geography ...
0
votes
1answer
31 views

Territories that are not connected

I am looking for territories that are divided between two or more countries in a non-contiguous way. E.g, country A receives the western part of the territory, then country B receives a part to its ...
1
vote
0answers
74 views

Quantifying amount of sunlight falling in a region

I am trying to objectively quantify or provide some form of indication that could point toward the amount of sunlight Anyone knows if there are any datasets (either instrumental or remotely sensed ...
5
votes
2answers
305 views

Is there any online viewer which displays the polygons assuming great circle lines for the edges?

My question is similar to this one: Are there any online WKT editors? The links given in answers have been very useful to me. However, it seems that when the tools in question display maps, they ...
6
votes
2answers
2k views

“Official” delineation of North American mountain ranges

I need to subset mosaics of remotely sourced data to the extents of several prominent North American mountain ranges, starting with the Sierra Nevada. After searching for the boundaries of the range ...
0
votes
1answer
71 views

Location based service with normal image

We have an image for a park which has been rendered like this: Now we want to add some geographic service based on the data: building an Android Application with the following features: Display the ...
0
votes
1answer
154 views

ArcPad custom edit form validation behaviour

I have a custom ArcPad form, which includes the geography tab. Users use this tab to update coordinates using the GPS. When user press OK in the edit form, I want to first check that they have not ...
3
votes
2answers
4k views

Order sql server spatial geometry distance by the nearest

I have a geometry column in a table, I want to get the N nearest neighbours; here is a specific example with the geography type DECLARE @PTO Geography = Geography::STPointFromText('POINT(-57.432546 -...
2
votes
0answers
140 views

Needing to find parent zip code of a bunch of missing zip codes in the US [closed]

We're using MapPoint to export zip code / territory combinations. Unfortunately, the export doesn't include PO Box zip codes which mean that we're missing a lot of zip codes The PO Box zip codes are ...
3
votes
1answer
144 views

GIS through Games: Ideas or Links [closed]

I'm managing a project - http://nepanode.anl.gov aimed at improving data awareness and sharing around Environmental impact analysis. I'm struggling to come up with ways to engage users and show them ...
2
votes
2answers
16k views

Equations to convert from global cartesian coordinates to geographic coordinates

First, I needed to convert geographic coordinates (like those received from GPS) to global cartesian coordinates. I found an earlier question (How do I calculate a xyz-position of a gps-position ...
6
votes
2answers
5k views

Maximizing Code Performance for Shapely

I've written this code in order to calculate the percent cover of grassland within a national park, within 20km^2 of points of recorded occurrences for a species. It is designed to only consider the ...
3
votes
1answer
3k views

PostGIS get geometries within a radius of n meters using WGS84 [duplicate]

select * from zones z where st_intersects(z.geom, st_Buffer(ST_SetSRID(ST_Point(2.336031, 48.863172), 3857),1)); It looks like the 1 in the st_buffer is being interpreted as degrees, I need to find ...
2
votes
2answers
8k views

Geometry datatype to latitude /Longitude MS SQL Server

I need to convert Sql Server geometry datatype to latitude /Longitude I have just imported a shapefile to my table (geometry) This query does not work:- select geom.Lat as [Latitude], geom....
2
votes
0answers
44 views

Characterizing territory according to its relief using ArcGIS Desktop?

I want to characterize the territory according to its relief with ArcGis 10. I'm trying to define a wide territory by its relief, but I would like to do it in an automatic or semiautomatic form with ...
0
votes
1answer
1k views

The ratio Pixel distance to geographical distance?

I have had this problem for several days and I have no idea to solve it. The problem is that I am trying to find out the length and width of ships from a Bing map. I got the location point (lon, lat)...
2
votes
1answer
344 views

What is the radius of earth [duplicate]

What is the real radius of earth? Google says 6378.1 km Wiki says 6371 km And there are references for 6378.7 km I'm using maximum radius 6378.7 km in distance calculation in spherical law of ...
0
votes
1answer
67 views

Postgis add Geography to function()?

i was wondering im getting different results when using geography() on different positions within a query. So, whats the most accurate way of forcing geography() over a functions with geometry ...
2
votes
1answer
215 views

Learning classical geography - recommended literature etc

I've been working in the field of GIS for a few years now, and there are some disciplines of knowledge where I lack a good degree of education. My educational background is that I've studied computer ...
5
votes
1answer
2k views

PostGIS convert GeoJSON to geography

While there are functions to convert geography to GeoJSON: text ST_AsGeoJSON(geography geog, integer maxdecimaldigits=15, integer options=0); I do not see any way to go the opposite direction (...
10
votes
7answers
3k views

What is the easternmost point in the US?

In his blog for The Atlantic magazine, James Fallows claimed that Eastport, ME was the easternmost point in the US. A writer commented that no, the easternmost point in the US was somewhere in Alaska, ...
6
votes
2answers
871 views

Min. weighted average distance from multiple points

I am a complete beginner in mapping-related topics. Still, I´ve been wondering if anyone know this problem. It might be well known, I just don´t know its name. Initial situation: nx : x geographical ...
1
vote
1answer
56 views

Countries with a small number of sides

Please accept my appologies if this question is off-topic here; this is the closest match to the topic of my question. I am looking for countries and states whose map is a polygon with a small number ...
3
votes
1answer
685 views

GeoDjango: read geometry column in geography field

I have a Django application that needs to work with an existent PostGIS database, apart from its own database. I've configured multidatabase support, created a database router, created models for the ...
0
votes
1answer
1k views

Convert an area to meters² in PostGIS

I have this query : SELECT ST_AREA(geom::geography) FROM region The (geom) contains polygons from a shapefile imported into PostGIS with shp2pgsql. I've appended ::geography, else the result of the ...
9
votes
3answers
851 views

Where can I publish my paper for free?

Is there any magazine (or some other such place) where university students can publish a GIS/Geo related article freely (in English or French)?
3
votes
1answer
1k views

Maximum size on the bounding box with ST_MakeEnvelope and && and geography column in PostGIS?

I've done quite a few google searches, but haven't managed to find anything that has helped me directly. I've got a few features in a PostGIS table with a geography column. The features are focused ...
3
votes
2answers
3k views

Shapefiles for US city and Zip level

I already have the information for US states and Counties. I have the information in the JSON files. I want the information for ALL US city and Zip Code information. I can't really navigate the US ...
5
votes
2answers
214 views

PostGIS 2.0 geographic polygon has max longitudinal range

My problem is that I have a load of geographic point data (srid 4326) in a table. A user may do a bounding box search - essentially create a polygon as follows: l_poly geography(Polygon,4326):= '...