All Questions
11 questions
0
votes
0
answers
184
views
MySQL retrieving GEOMETRY Points (indexed) from a table which are within a GEOJSON polygon
I am trying to retrieve all of the points from a table which are within a GEOJSON polygon. I am running everything below through a Python function.
So, I created a table from a CSV file of open data ...
- 55
2
votes
1
answer
858
views
Writing a vector with geopandas to MySQL is written as TEXT not as POLYGON
I am currently trying to write some vector files into a MySQL database. It works great for most vector files, but for some I got the eror:
(pymysql.err.DataError) (1406, "Data too long for column ...
- 551
2
votes
1
answer
1k
views
Storing Shapely polygons in MySQL
I have to store some polygons in a MySQL database. The polygons are in Plate Carrée (ESPG 32662) projection, but I also tried to first converting them to the usual latitude-longitude projection (ESPG ...
- 121
3
votes
0
answers
918
views
Overpass API python wrapper to run requests on the endpoint of overpass-turbo
we have with Overpass API python wrapper a thin Python wrapper around the OpenStreetMap Overpass API https://github.com/mvexel/overpass-api-python-wrapper
we have some Simple example:
import ...
- 39
1
vote
0
answers
739
views
Retrieve geolocation and image url from Blob in MySQL
I have a web form that collects three items: name, notes, and a geotagged img and stores it in mysql. The image is stored as a blob.
I would like to scrape/access the blob's geo-location properties ...
- 11
4
votes
1
answer
10k
views
Parsing WKB with python geos: ParseException: Unknown WKB type 16
I am pulling a WKB strings from the MYSQL table in pandas / geopandas, Python 2.7. As it is MySQL, the only way to read geometry is to parse it on the client.
However, when parsing, geos raises an ...
- 2,054
1
vote
0
answers
368
views
Parse geometry from MYSQL on the client side
I am working with the existing production Mysql database, that contains some geometry (wkb, I think) as a blob.
While documentation offers to use ST_AsText(boundaries.geometry) AS geom, Servers says "...
- 2,054
6
votes
1
answer
453
views
How do I update joined data from MySQL programmatically?
I have a point vector layer (Sensores) in my QGIS project, I also have a MySQL database layer (SensoresDB) containing only data. I have joined these two layers in order to geographically reference my ...
1
vote
3
answers
1k
views
Querying dataset with shapefile?
I will be using a very large dataset (yfcc100m dataset, a dataset containing metadata of Flickr's photos/video) which contains fields longitude and latitude. I'm planning to store the dataset into a ...
- 11
6
votes
4
answers
5k
views
Simple WMS server
Is there a way to implement a WMS server using only php or python cgi and mysql? I can't use geoserver or mapserver and postgres and any other software as they are not provided by the administrator.
- 8,382
1
vote
1
answer
1k
views
How to add MS SQL table using python console?
I have MS SQL Server 2008 R2 database. How to add MS SQL Table using python console in QGIS?
- 11