topic KML and Geolocation in Management & Governance

KML and Geolocation

marco_puccetti — Tue, 07 Apr 2015 14:51:28 GMT

Hello! i need to obtain an Italy Map that contains for each region the amount of IMPORT field.

This is the Table structure:

NDG

TIPO_PAG

CITTA

PROVINCIA

ABI

DATA INCASSO

IMPORTO

LATITUDE

LONGITUDE

1223456

Pisa

5164

07/04/2015

20.000,00

43.716135

10.3966024

When i attach these data to the map the region linking is not done, but the Sum(IMPORTO) is linked to every region.

I have also used this statement to have a correct coordinate linking:

LOAD

NDG,

TIPO_PAG,

CITTA,

PROVINCIA,

ABI,

"DATA INCASSO",

IMPORTO,

LATITUDE,

LONGITUDE,

GeoMakePoint(LATITUDE,LONGITUDE) AS LOCATION

FROM [lib://Downloads/GEOMAPS.xlsx]

(ooxml, embedded labels, table is Foglio1);

What have i to do to render for each region (City) with circles the amount of data?

Is it necessary to mantain a certain table structure to obtain this?

Thanks

Re: KML and Geolocation

JonnyPoole — Tue, 07 Apr 2015 20:23:19 GMT

it looks right...a few things to check:

1. did you add 'LOCATION' as the dimension for the map ?

2. after #1, did you drag IMPORTO into the same map ? when you do this it should prompt you to select sum,avg, min etc...

3. then just make sure the background / show property on the right is set to 'ON'

I would suggest doing steps 1-3 after dragging in a brand new map object onto the dashboard. its trickier to change an existing map.

Re: KML and Geolocation

marco_puccetti — Tue, 07 Apr 2015 21:00:36 GMT

Ok, I've noticed that some KML's map i have found were corrupted or not properly formed, so i ask you if you let me have some maps (in KML format) I can use for Italy Region and Province locations.

Thanks

Re: KML and Geolocation

Tue, 07 Apr 2015 22:01:48 GMT

Hi Marco,

take a look at Welcome to the QGIS project!.

Regards,

Przemek

Re: KML and Geolocation

marco_puccetti — Wed, 08 Apr 2015 08:02:50 GMT

Thanks!!

Marco

Re: KML and Geolocation

Mon, 25 Jan 2016 14:53:25 GMT

Hi Marco,

did you finally got the KML file? I'm looking for the same

Best regards,

Davide

Re: KML and Geolocation

marco_puccetti — Tue, 26 Jan 2016 09:40:07 GMT

Try here: kmlfactbook.org