CitiLogics / citilogics-geoloop-panel

Animated Maps in Grafana
MIT License
44 stars 6 forks source link

SQL Support #17

Open dogugun opened 5 years ago

dogugun commented 5 years ago

We are trying to use the tool with SQL Server as data source, with numeric field, latitute and longitude, and with the below json. The json is copied from the example. However we could not display any points on the map. Is there a walkthrough or a sample case for SQL Server?

https://raw.githubusercontent.com/dogugun/fastq/master/geojsonbulut

jruivo-dev commented 4 years ago

Did you find a way to use SQL?

dogugun commented 4 years ago

Nope, we had to switch to grafana's default map add-on.

kimbuz commented 4 years ago

Hi! is there any posibility to make it work with MSSQL or MySQL databases? I have an issue in the measurement assigment. The hole map is black. Also I see there is an issue on the png of the color selection. I can't find a column name that GeoLoop would take as measurement.

image

pbalba commented 4 years ago

Hi! Has anybody managed to get it working? We're trying to set it up with clickhouse db with no luck...