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
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.
Thanks for the fast reply.
Do you have an easy to follow guide I could use?
Post your CSV file.
Phil,
Are you wanting to create a Heat Map or Choropleth Map?
Dave
Dave Stoll
Las Vegas, Nevada
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
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
Dave Stoll
Las Vegas, Nevada
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
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
Dave Stoll
Las Vegas, Nevada
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.
I forgot to include this image with my reply. This should give a good visual of the surface style mentioned.
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
Hi @phil.mumford ,
additional ideas:
Regards,
Karsten.
Hi Karsten,
Thanks very much for the detailed reply, I will try this asap.
Thanks again.
Can't find what you're looking for? Ask the community or share your knowledge.