Help creating a heatmap using Easting & Northing data

[phil.mumford]

Hi,

I need to create some  heatmaps using Eastings and Northings data from the attached spreadsheet, I have attached a screenshot (capture) which is what I am trying to create.

I have also attached capture 1 which is a key and shows how the reading are being shown, these readings are taken from the COD column on the spreadsheet.

Any advice on an easy way to create the heatmap would be very much appreciated.

Thanks in advance.

Phil

[tcorey]

Does your spreadsheet have three columns of data? X, Y, PPM?

If so, create a TIN surface, add the csv as a data file, xyz format. Run an elevation analysis, specifying the ppm ranges the same way you would elevations.

[phil.mumford]

Thanks for the fast reply.

Do you have an easy to follow guide I could use?

[tcorey]

Post your CSV file.

[Pointdump]

Phil,
Are you wanting to create a Heat Map or Choropleth Map?

This is a Heat Map

This is a Choropleth Map

Dave

[phil.mumford]

Thanks for your reply's.

Pointdump -  A heatmap is what I'm after.

Tcorey - I have attached a .csv file which contain long & lat, and the readings (COG), I know how to creat TIM surfaces and things like that but a guide to creating this map would be great.

Thanks

[Pointdump]

Phil,
Not sure about your CSV file. The Latitudes look a bit large:

Time,Latitude,Longitude,COG
,,,
72952,5321.36159N,00259.02351W,167.84
72953,5321.36141N,00259.02248W,111.07
72954,5321.36156N,00259.02143W,105.35

What do the Time and COG columns represent? I divided the Lat Column by 100 and made a Heat Map in QGIS. As for how to make one using C3D/M3D tools, I dunno.

Dave

[phil.mumford]

Thanks for the reply Pointdump.

The long & Lat are fine, I can convert these to easting & northings no worries.

The time is just when the point was picked up (this could used as a point number) and the COG is the ppm reading which show as certain colours depending on the reading.

I've not used QGIS, is it easy to use and can it be brought in to CAD?

Cheers

[Pointdump]

Phil,
Heat Map in QGIS is a Styling. Very easy. But I don't know any way to export that Style to AutoCAD. I tried just now to Export as DXF. No go.
You can make a Density Map (Choropleth) using Map Tools, but I have no idea how to make a Heat Map.
"The long & Lat are fine, I can convert these to easting & northings no worries."
I'm dying to know how to convert Latitudes in the 5000's to Northings.
Dave

[phil.mumford]

Thanks for your help anyway.

[ACADuser]

Why not use a surface style using elevation analysis? If I'm understanding this correctly the COD values would represent the elevations in the surface.  You could then specify a custom range and color to display your data as desired. Finally adda surface legend table that corresponds to the data.

[ACADuser]

I forgot to include this image with my reply. This should give a good visual of the surface style mentioned.

[autoMick]

As Dave @Pointdump suggests - I would use QGIS. You can create your heat map and import your dwg/linework into that platform if you need.

If doing in Civil3d I would be doing a lot of surface smoothing and possibly adding in proximal breaklines - if the trends are supposed to follow identifiable features.

That last image shows that the data look almost exactly what you would get from a single-beam sonar hydrographic survey - which are always a pain to present well with this sort of asymmetry in the survey spacing. The key to getting good maps in this case is nice straight parallel survey lines which run perpendicular to the expected 'features', avoid cross-lines/grids, proximal breaklines where relevant/justifiable,  and surface smoothing.

Also - just a caution - make sure you understand exactly what your software is doing when interpolating between the data points - what scale will the output be presented at? Are you just identifying hots spots generally/visually? or are you doing some sort of detailed spatial analysis?

Cheers

Mick

[phil.mumford]

Thanks for the detailed reply AutoMick, I'll give it a go.

[Karsten.Saenger]

Hi @phil.mumford ,

additional ideas:

• Use Recap and import your CSV file as point cloud (after you scaled the data accordingly as Recap can only work with 3 decimals)
• The point cloud can then be used in other programs (Civil 3D, InfraWorks) for represantation, classification or as data source for surface creation

• Convert the CSV points to Shape or SDF file (i.e. Import points into Civil 3D then MAPEXPORT)
• Use the Shape point file in Infraworks and create a feature theme based on attributes or directly theme a point cloud

Regards,

Karsten.

[phil.mumford]

Hi Karsten,

Thanks very much for the detailed reply, I will try this asap.

Thanks again.