Geospatial pertains to the geographic location and characteristics of natural or constructed features and boundaries on, above, or below the earth's surface; esp. referring to data that is geographic and spatial in nature.
0
votes
0answers
25 views
Does the Update Statement target the nested query in the middle [on hold]
My question is would the CoverageGeom in FeatureExtraction.dbo.ProfileAreas in the innermost nested select be updated according to the join in the innermost select with the outer selects code change? ...
-4
votes
0answers
20 views
Testing if the arc between two (lat,lon) seapoints, intersect landmass [closed]
I have the following problem: I have a bunch of points (latitude,longitude) that I know are located in the mediterranean sea. I have to check if the great circle path among each pair intersect the ...
6
votes
2answers
120 views
Accepting user defined functions for custom map reduce functionality in C++
I am implementing map and reduce - style functions for processing geospatial raster datasets.
I would like the ...
3
votes
1answer
57 views
Finding travel distance between airports
I have 2 nested for loops which i want to get rid of. Any thoughts?
I am calculating distance between cities based on their longitude and latitude. There is a custom function ...
2
votes
0answers
25 views
Core location background update and upload to server
I want to upload a user's location to a server to send them a location-sensitive alert, so the location needs to be fairly accurate:
...
5
votes
0answers
65 views
Computing intersections of a Polyline and a line
I wrote a script to compute / interpolate the nodes of a Polyline at a given latitude, input_lat. It works for my purpose but I am wondering if there is a better, ...
9
votes
3answers
200 views
Composing QGIS expression based on a QGIS layer tree
I am developing a plugin for a GIS (Geographic Information Systems) software which uses Python. I have been using Python for over a year (on-off) and have the following code which works. It basically ...
1
vote
2answers
41 views
Performing several hundred raster multiplications
I have several hundred "A" rasters, numbered from 001_A.tif to 100_A.tif.
I also have several hundred "B" rasters, numbered ...
1
vote
1answer
65 views
Parsing data from big json field and geocode services then store to PostgreSQL using psycopg2 instead django-orm
This code works, but my boss told me that it's very bad code, and don't want to deploy it. It is my first time working as a programmer and I have at least 3 months of experience.
...
3
votes
1answer
129 views
PANDAS spatial clustering
I'am writing on a spatial clustering algorithm using pandas and scipy's kdtree. I profiled the code and the .loc part takes most time for bigger datasets. I wonder ...
0
votes
0answers
253 views
D3 Map Visualization with tooltip and graph
I would love if someone had any feedback on how to optimize my code, suggest better color schemes, and improve my table. I created python scrapers to get the data from the CDC and menuism to get the ...
5
votes
1answer
183 views
Geocoding hook for a TYPO3 extension
I'm currently developing a TYPO3 Extension in PHP and developed a Hook.
TYPO3 has the concept of Hooks where you can execute your own code as specific points. As defined in our definition of done, we ...
2
votes
1answer
183 views
DbGeography search query
I have a situation in which I need to get the closest road to a DbGeography point.
This takes 5 - 8 seconds to run in some cases.
I have a ...
3
votes
2answers
84 views
Join JSON objects on common property
is there an easier/more efficient way to join two JSON objects on a common property than this? It's a GeoJSON file (basically an array of objects), and I want to pull in a property from another JSON ...
6
votes
1answer
41 views
Finding closest points without duplicates and given distance threshold
Given a bunch of latitudes and longitudes stored as Points, I would like to determine the points that are closest to each point given some maximum threshold in meters. This is my first stab at this:
<...
1
vote
0answers
225 views
Track user's location and broadcast over Pusher
I am trying to track the user's location and transmit it periodically via Pusher (real time data service, pusher.com).
I am using Google Play Services for location handling. I need the location ...
6
votes
2answers
396 views
Compute spherical distance matrix from list of geographical coordinates
I've got a list of geographic coordinates ([lat, long]) and want to compute the corresponding matrix of distances. Distance shall be spherical distance in km.
<...
6
votes
2answers
334 views
Python program to check if a set of points is at land or at sea
I have written a program that divides an geographical area up in cells with size 0.002 degrees longitude by 0.001 degrees ...
7
votes
1answer
67 views
Querying houses similar to a given house
I was given this task as an interview coding challenge and was wondering If the code is well structured and follows python guidelines. I chose to sort the houses based on a similarity metric and then ...
4
votes
1answer
57 views
Downloading 2 tables from db, does calculation and uploads resulting table
I have written this script that downloads two tables from the db, preforms an intersection on them and adds 2 new columns to the resulting table, and uploads the resulting table to the db. It's a bit ...
1
vote
0answers
37 views
Geocoding users' IPs
My Rails app geocodes users' IP when they are created and also when they update their data only if they change their city. The geocoding is slowing down my tests ridiculously.
This seems to me to be ...
1
vote
1answer
48 views
Determine what hazard type does the building belong using GeoDjango Intersects
Below is my query to identify what hazard type does the buildings belong:
...
3
votes
1answer
78 views
Updating geo coordinates
An error in a live environment was detected when trying to convert string geo coordinates into a double.
The current culture (hu-HU) uses comma instead of point ...
2
votes
0answers
59 views
Identifying Polylines and operating on field values
I'm using Python 2.7.5 in a GIS environment (namely: QGIS 2.8.1, or PyQGIS).
sys.version_info(major=2, minor=7, micro=5, releaselevel='final', serial=0)
The aim is to identify spatially ...
4
votes
1answer
287 views
Latitude/longitude waypoint distance calculations, crosstrack, VMG, ETA, etc
I'm in the process of a complete re-write of a stagnant and ill-conceived project. I would like some feedback on the following Python 2.7-3.4 code, before I go any deeper into it.
I would hope it is ...
1
vote
1answer
28 views
Location information (store/send over network)
I have to calculate a user's location periodically and store & send it over the network on Android. I also have to indicate errors during calculation of location as well. The errors could come ...
2
votes
0answers
164 views
Smoothing matrix for visual representation
I recently started playing around with R and am currently trying to plot GPS data points onto a perspective plot. I have a script that works and I get my desired results out of it and it works ok for ...
2
votes
2answers
487 views
Haversine formula in SQL
This is an implementation of the Haversine formula in Microsoft Transact SQL.
How can I simplify the function?
...
5
votes
1answer
1k views
Using $q in Angular JS to pass navigator geo JSON from factory to controller
This code is used to get the users location and deliver it as a resource to the controller. The aim is to have this data shared across multiple controllers in the application. So far this does deliver ...
11
votes
1answer
88 views
New Moon (not Twilight) Calculator
Photography is one of my hobbies, and, living in Canada, I have the possibility of seeing, and photographing, the Aurora Borealis (Northern Lights).
Now, these happen when there's ionization in the ...
6
votes
1answer
363 views
Google Maps API latitude/longitude pair to Google Fusion Tables query
I'm trying to learn JavaScript, and as a practice tool I recently wrote a simple web app that uses the Google Maps API Geocoder to get the latitude and longitude of a location (user input), manipulate ...
2
votes
0answers
40 views
Directions to refactor class for GPS track points
The story started here (Parsing GPS Data) and continued here (Class for median filter)
I've done a lot work and faced new questions.
In short - I made:
Classes for parsers. TrackParser and ...
2
votes
1answer
85 views
Parsing GPS data
Recently I sent this code snippet as CV attachment and I got simple answer - this code smells and we employ another developer.
I'm new to RoR, so guys can you give me directions to refactor this code ...
3
votes
1answer
65 views
Geocoding library
I've written a Geocoding library that is hosted on Github. It has got 7.9 rating by the scrutinizer. I've checked and the only thing that I think I can improve is ...
2
votes
0answers
36 views
Optimise a spatial join for QGIS 2.0 Python plugin
I got a really great code review for a similar issue, but I seem to be unable to adapt it to another calculation for a QGIS 2.0 Python plugin. I am attaching field values to any features intersecting ...
6
votes
1answer
869 views
Bash script for getting geolocation (latitude, longitude and country code)
I have a bash script, where I need to get the user's geolocation (latitude, longitude and country code). If a GPS device is present, I use gpspipe. But a lot of laptops/computers don't have GPS ...
2
votes
2answers
187 views
Filling modal from JSON (dynamically)
My Java app converts its modal object to JSON (using the GSON Library).
This is just fine, but I have to get it back into a modal in PHP. Now I've created a modal (in my case it's, for example, ...
7
votes
1answer
141 views
Extracting nodes from a road network
My code takes 143.023 seconds for extracting nodes from a road network of city like Göteborg in Sweden. Please check it out if I can optimize it.
...
4
votes
0answers
1k views
Satellite orbit simulation in Matlab using Runge Kutta 4
I have a satellite orbit simulation in Matlab (Using Runge Kutta 4). It seems ugly and I don't know how to fix it.
fx.m file:
function v = fx(t,x,vx)
v = vx;
...
2
votes
0answers
245 views
Plugin that grabs the coordinates of all the cities in our database
I have a plugin that grabs the coordinates of all the cities in our database working in WordPress here.
...
0
votes
3answers
2k views
11
votes
3answers
233 views
Geographic search
I have this table (inradar_ad) with almost 300k entries. I want to know why my query takes 160 secs to run.
I tried limiting with ...
5
votes
1answer
504 views
Finding nearest city from a center place (latitude and longitude) with radius in miles
This is my code for finding the nearest city within a certain radius. I am not sure, is my code is OK or is it wrong? Please review and offer suggestions on my code.
...
8
votes
1answer
225 views
Optimize web-scraping of Moscow grocery website
This code works fine, but I believe it has optimization problems. Please review this.
Also, please keep in mind that it stops after each iteration of the loop ...
12
votes
1answer
267 views
Temperature Interpolation
I want to interpolate temperature in correlation with height. I have temperature data from stations with coordinates and height in this format:
...
5
votes
3answers
849 views
Converting KML/XML to Javascript
So, I have the boundaries of every states in the US, from the google map KML file.
This KML file is actually a XML file.
I'm converting this file to a JS file compatible with google map in order to ...
6
votes
2answers
13k views
Simple application for finding local restaurants
I was asked to create a test APK file by a company HR when I applied for an Android developers job,
Specification:
The goal is to develop a simple application which finds the local
restaurants. ...
1
vote
3answers
100 views
Working and calculating with geographic positions
I was thinking about how to implement a GPS navigation for my quadcopter. I was writing some functions to calculate the angle between two positions (from home point to the target).
I'd like a review ...
5
votes
1answer
319 views
Improving a triangulation test script
I am a relative beginner to Python and as such I've been working on little things here and there in the office that strike me as something interesting that might be fun to try and code a solution.
...
2
votes
1answer
904 views
