KML and Geolocation

[marco_puccetti]

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

CO

Pisa

PI

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

[JonnyPoole]

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.

[marco_puccetti]

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

[#4]

Hi Marco,

take a look at Welcome to the QGIS project!.

Regards,

Przemek

[marco_puccetti]

Thanks!!

Marco

[#6]

Hi Marco,

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

Best regards,

Davide

[marco_puccetti]

Try here: kmlfactbook.org