45 questions
1
vote
1
answer
119
views
Apply a Pacific-centered projection and add coordinates to a ggOceanMaps basemap
I want to plot satellite tracking data. I previously did this by manually importing the country outlines and satellite data without using ggOceanMaps:
However, I would like to use the basemap() ...
0
votes
1
answer
95
views
How to fix ORA-00939 Error when trying to insert multipolygons data in Oracle express 21c?
I have the geoJson of this spatial data (Source: https://cartomad-ae-cirad.hub.arcgis.com/datasets/a761169493dd4cbfb2cab7d381cf2945_0/explore).
The points that constitute each polygons of each ...
0
votes
0
answers
252
views
Direct and indirect effects of spatial panel durbin model
I'm asking about the estimation of direct, indirect, and total effects of spatial durbin panel data modeling. As far as I know, there is no direct package of doing the estimations. So I generate the ...
1
vote
0
answers
116
views
Predict function in R returns a different value from fitted.value in model object
I am using lagsarlm in spdep package in r to estimate a spatial Durbin (mixed) model by
m1 <- lagsarlm(f, data = d, wlist, type = "mixed")
where f is my designed model of dependent ...
0
votes
1
answer
203
views
How to conduct spatial data analysis with netCDF land use data and Key Biodiversity Areas (.shp) data
I have a netCDF file ("SSP119.nc") containing information on land-use change from 2015 to 2100, inclusive (source: https://luh.umd.edu/data.shtml). I also have a shapefile containing ...
0
votes
2
answers
903
views
Selecting values from a 4d tensor with a 3d tensor
I've recently run into this problem in pytorch when working with 4D tensors which should be indexed with 3D tensors.
Let's say we have this 4D tensor:
possible_values.size()
torch.Size([2, 5, 5, 4])
...
3
votes
1
answer
381
views
Euclidean Distance for Arrays of 3D points in Python
I have two .csv files of 3D points (numeric coordinate data) and associated attribute data (strings + numeric). I need to calculate the Euclidean distance between each point and every other point, and ...
0
votes
1
answer
259
views
ABP.io + NetTopologySuite = True?
How to handle spatial data with abp.io framework (SQLServer and EF Core)? Any recommendations?
I guess one can have NetTopologySuite in the Domain project, but it does not feel DDD correct to do so.
...
1
vote
0
answers
1k
views
readOGR: error in evaluating the argument 'x' in selecting a method for function 'merge': length(dsn) == 1L is not TRUE
I'm attempting to adapt a function written by a coworker, but I've hit a point where neither of us know how to solve the issue. Generally, the function reads in several different shapefiles kept in ...
0
votes
1
answer
660
views
R Programming Help: Error in .subset2(x, i, exact = exact) : no such index at level 3
I am in need of assistance, any guidance is greatly appreciated!
My goal is to create a function that computes the spatial moving average of adjacent neighbors of a polygon shapefile utilizing the ...
2
votes
0
answers
495
views
How to overcome infinite value to perform multicollinearity test in environmental variables?
Here's the dataset which consists of X = 45 columns collected the data from bioclimate database.
The multicollinearity test model -
from statsmodels.stats.outliers_influence import ...
0
votes
2
answers
1k
views
How to Calculate Euclidean distance from sf data frame points in R
How do I calculate Euclidean distance in km from a spatial point that has been converted from a geometry column into a data frame. (The points are points which were derived from a spatial join of ...
0
votes
0
answers
52
views
Can I create a SpatialPoints object from a variable with NAs?//How to make lat and long variables with NAs compatible with SpatialPoints?
I'm trying to fill coordinate gaps in a data frame based on points randomly created within a reference area.
In the original dataset, I have a column for lat and a column for long values, and the ...
1
vote
2
answers
925
views
How to create a polygon/combine polygons that cross the 180 meridian dateline
I'm trying to create a polygon that has longitudinal limits as 150, -170, i.e. crosses the 180 meridian dateline.
I've tried:
x = c(-170, -170, 150, 150) #long limits
y = c(-25,-57,-57,-25) #lat ...
0
votes
1
answer
95
views
How to fill data gaps with random coordinates from a polygon?
I have a data set of whale sightings with some coordinate gaps but associated with areas of reference, of which I have coordinate limits. I've used these limits to create a polygon restricted to the ...
0
votes
1
answer
249
views
The points of occurrence (gbif) and the maps don't coincide when i use worldclim data
i'm new in the R world and i'm trying to do a species distribution model, but when i plot my result, the points stay out from my map, i tried to change CRS but i didn't solve my problem, now i'll go ...
1
vote
0
answers
101
views
Is there a way to get around this problem in my Road network analysis in R?
so I am having issues with a road network analysis I am conducting, which is aiamed to look at how far away each park entrance is from each postcode centroid in the London borough of Southwark. ...
1
vote
0
answers
99
views
Possible ways of selecting x/y points that are on or close to a path in R
I am trying to extract data from a line of points which are part of a 2D map that consists of 5,000–6,000 points.
I used to be able to do this using the Point Profile Tool in ArcMap but am now looking ...
2
votes
1
answer
729
views
How to label only one point in tmap in r?
In the example below I would like to have only the label for Ghana in the tm_text("name") layer showing.
Any idea how to do this?
Thank you for your help.
library(tmap)
data("World"...
0
votes
0
answers
274
views
Send spatial data using Python and Mysql Connector
Using Mysql Connector and Python I am trying to pass the simplest form of spatial data (Point datatype) to my MySQL database. Using the mysql connector the 'execute' function in Option1 works whereas ...
0
votes
1
answer
558
views
Determination of bearing change between two points (spatial-data)
I am reviewing a paper on transportation mode to understand their methodology (this paper). At some stage, the authors computed the rate of bearing change between the points (GPS points), which ...
7
votes
1
answer
11k
views
Intersection of polygons in R using sf
I want to assess the degree of spatial proximity of each point to other equivalent points by looking at the number of others within 400m (5 minute walk).
I have some points on a map.
I can draw a ...
2
votes
3
answers
5k
views
What is initial bearing and final bearing
I am trying to calculate bearing between two lat/lon points as given in this link. I see that the bearing we get initially using the below equation is initial bearing.
public static double ...
0
votes
3
answers
1k
views
Connecting a set of points to get a non-self-intersecting non-convex polygon
I have an unordered set of 2D points which represents the corners of a building. I need to connect them to get the outline of the building.
The points were obtained by combining different polygons ...
2
votes
2
answers
172
views
I can not publish a workbook contains spatial data on TABLEAU SERVER
I created a map using Tableau Desktop 2018.2.4, that works works well in the Desktop version of Tableau. However, when I try to publish the workbook to Tableau Server 10.2.3, I receive an error saying ...
1
vote
1
answer
6k
views
Convert Geometry to Geography
I want to convert geometry to geography in SQL Server; I followed this article:
https://blogs.msdn.microsoft.com/edkatibah/2008/08/19/working-with-invalid-data-and-the-sql-server-2008-geography-data-...
0
votes
1
answer
707
views
Property type of 'System.Data.Entity.Spatial.DbGeography' which cannot be mapped to a primitive type
Updated from EF 5.0 to 6.2 (designer from database) and getting the error:
Schema specified is not valid. Errors:
The relationship 'CWPP.FK_Coordinates' was not loaded because the type 'CWPP....
3
votes
1
answer
14k
views
Calculating number of pixel(count) raster files in R
I have a huge number of raster files and a polygon that is within the extent of the raster files. I want get the pixel number(count) for each raster files within the polygon.
Additionally I want to ...
4
votes
2
answers
6k
views
What is the difference between STAsText() and ToString() in sql while converting geography to wkt
DECLARE @geographyData geography;
//Convert wkt to geography
SET @geographyData = geography::Parse('LINESTRING(-132.360 50.657, -120.340 47.659)');
//Convert back to wkt from geography
(1) @...
41
votes
3
answers
27k
views
Can I use Entity Framework 6 (not core) in .net core?
Entity Framework Core does not support spatial data, which I need to use in my app.
Can I use Entity Framework 6 in .net core? If so, how can I register DatabaseContext in Startup.cs?
0
votes
1
answer
621
views
Deserialization of DbGeography Entity Framework
I have a class Event with a property of the type DbGeography.
public class Event
{
public long Id { get; set; }
public DateTime Date { get; set; }
public DbGeography Location { get; set; ...
2
votes
1
answer
584
views
smooth (Lon, Lat, Value) data over shapefile
I am trying to plot a data with (Lat, Lon) and a value in each location. What I need to do is to plot the data over a shapefile, represent each value with a different color, and smooth the values, so ...
0
votes
3
answers
1k
views
R: One value per hour in data frame
I've got a GPS dataset with about 5600 rows of coordinates from 5 GPS devices ('nodes') over several days and I want to reduce the number of GPS points to just one point per hour. Because the number ...
0
votes
0
answers
382
views
SSRS won't read my SQL query parameters
I'm trying to plot data to a shapefile in SSRS. I linked my SQL Server successfully and selected my Stored Procedure, but when I go to set my Spatial and Analytical Dataset Fields SSRS tells my
...
2
votes
2
answers
1k
views
unable to plot two spatial objects with identical CRS in R
I have two spatial objects, one is a spatial polygon object and the other one is a .csv file that I turned into a spatial points object. The first one is an official shape file from the chilean ...
1
vote
2
answers
1k
views
C# gdal read mssql spatial to geojson
Gdal.AllRegister();
//为了支持中文路径,请添加下面这句代码
OSGeo.GDAL.Gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "NO");
//为了使属性表字段支持中文,请添加下面这句
OSGeo.GDAL.Gdal.SetConfigOption("...
-1
votes
1
answer
290
views
whether or not to use sqlite/spatialite on Android with only 29k rows
I'm trying to figure out whether or not to use sqlite/spatialite on Android with only 29k rows. I just need to find the nearest locations from the user everytime they move outside 100 meters which ...
0
votes
0
answers
133
views
Databases for storing coordinate based nodes and relationships
I've been reading about Neo4j, and am currently experimenting with it in NodeJs.
Are there any other note worthy graph or spatial databases that are better equip for coordinate based entities and ...
0
votes
0
answers
560
views
Mean Square Error (MSE) function argument "poly"
I'm trying to estimate an initial bandwidth value for kernel smoothing my data, calculating the Mean Square Errors (function "mse2d"), but got stuck with an error in a polygon implementation code in ...
1
vote
4
answers
283
views
Algorithm for identifying non-ambiguous clusters?
Clustering algorithms usually take into account that what might be perceived as a reasonable cluster by a human being is ambiguous and the computed solution is supposed to generalize and predict well.
...
2
votes
1
answer
1k
views
locality sensitive hashing for spatial data
I would like to find out a Locality Sensitive Hashing algorithm in order to split my spatial data into a number of buckets(reducer tasks). The spatial data are actually trajectories so from my ...
2
votes
3
answers
833
views
Managing large spatial data set with attributes in C++
I have a data set with about 700 000 entries, and each entry is a set of 3D coordinates with attributes such as name, timestamp, ID, and so on.
Right now I'm just reading the coordinates and render ...
2
votes
0
answers
187
views
calculate mean for each cell in grid in R [duplicate]
Possible Duplicate:
Sliding window function in R
This might be a silly question, but I couldn't find an answer so far.
I have a data frame like this:
df <- data.frame(lat = (-10: 10),
...
1
vote
1
answer
1k
views
The Spatial Data for layer... in the map... is not valid. Specify Spatial data that is data type SqlGeometry or SqlGeography. Report Builder 3.0
I am editing the data set for a map report programmatically in VS 2010 by changing the dataset queries in a baseline report converted to xml, then displaying the new report, converted to .rdl in ...
2
votes
1
answer
154
views
Need to move SQL Server 2005 Table storing Lat;Lng as varchar to Spatial?
I have read some articles about using spatial optimized tables. Actually I use stored latitude and longitude as varchar comma-separated (lat;lng).
Could you suggest the best way to perform this ...