Global heatmap in Access. Is it possible ? (1 Viewer)

[TipsyWolf]

hello everyone ! hope u guys r doing well today !

i have a question that i couldn't find any answers for even in google.
is there any way or is it technically possible to create some kinda heatmap.

imagine i have a jpeg uploaded in database. and i have a records. is there a way to store a location (point) on this jpeg, so i can see heatmap of every records to see where i have most points in my jpeg (map).

i want to have a form with map where i can have a heatmap so i can see my records'marks. (filtered or all). i mean is there a way for access to stores not only data , but some locations marks on jpeg ?

just dummy example here

 

[MajP]

Yes.

Solved - User made command button that can be moved with mouse?

haha! We got plenty of liferafts! Thanks MajP, is working good. Attached is idea of the jobs pane. I think when a new dot is moved to the plan/deck then it would ideally open up a new record/job for this new dot that has been added, this would highlight as a new job in the jobs detail pane...

www.access-programmers.co.uk

Class to move about 20 pictures

Hello, I'm building a kind of floor plan. For this I placed 50 image objects on a form. I am able to display certain images (for example a table for 4 persons or a table for 8 persons) on a selected image object. What I want is that these image objects can be moved with MouseDown/MouseMove...

www.access-programmers.co.uk

 

[MajP]

Provide a database with your data and form, and I can help.
You need some way to convert your data to the cartesian plane of the form (left, top, height, width)
Your data could be miles, decibels, gallons, whatever. But need some way to convert X of this and Y of that to Left, and Top.

 

[TipsyWolf]

Provide a database with your data and form, and I can help.

it says "the uploaded file is too large"
its 12mb

 

[MajP]

compact and repair first.

Compact and repair a database - Microsoft Support

Use the Compact and Repair Database command in Accecss to help prevent and correct the following problems: files growing larger with use and files becoming corrupted.

support.microsoft.com

Then zip it and post a zip file.

 

[TipsyWolf]

compact and repair first.

Compact and repair a database - Microsoft Support

Use the Compact and Repair Database command in Accecss to help prevent and correct the following problems: files growing larger with use and files becoming corrupted.

support.microsoft.com

Then zip it and post a zip file.

repaired! its still 12mb.
PeaZip did its magic. zipped from 12mb to 0.5mb.


the database itself is still under construction by me. basically its a risk database (construction site(s))
i work for contruction company and we regester new findings (risks). its gonna be with deadlines, responsible. i have a dashboard with statistics. like red, orange, yellow, green RiskType.

for now its only Tmain and Tactions (it has relationship one to many)
so 1 risk can have many actions (measurments to close this risk)

so for now, i dont have a map of countruction site yet (i just requested it today), but its huge... or maybe its better to use it per sites, cause it has like 20 sites. each has own jpeg. but i think i need a global as well. but not sure how its possible to implement.

u can easlity put a dummy jpeg for examples.
btw, im not pro at access. just noob.

thanks a lot for helping me here.

upd:
so 1 risk (from Tmain) has only 1 mark at heatmap
some text in DB is in non-English, cause im doing it for locals to use.

 

[TipsyWolf]

I will take a look later, I got to run now. I might even have something tailored to specifically to risks where you are assessing risks by plotting Severity and Likelihood.

yeap i have it in my DB

have a nice day

 

[MajP]

If you look at this

Solved - User made command button that can be moved with mouse?

haha! We got plenty of liferafts! Thanks MajP, is working good. Attached is idea of the jobs pane. I think when a new dot is moved to the plan/deck then it would ideally open up a new record/job for this new dot that has been added, this would highlight as a new job in the jobs detail pane...

www.access-programmers.co.uk

In this example you are dropping tasks on to a "floor plan" of a ship, to represent locations of task to take place. Also you can select multiple "floor plans". Similar to your idea of assigning risks to different Project Sites.

I use the term "floor plan" because this idea originated from dropping images of different tables on to a restaurant floor plan.

Imagine instead of tasks you are dropping risks on to a site location. Notice how the tasks get colored based on priority So I think this can be modified very easily. You can even try by changing the names of the 5 floor plans and placing your own images in the FloorDrawing attachments. You should see dots on your images. You can then move the dots (tasks) around on the image.
tblFloor tblFloor

FloorID	FloorName	FloorDescription	FloorDrawing
1​	Profile		1
2​	Sun deck		1
3​	Bridge deck		1
4​	Main deck		1
5​	Lower deck		1

The question is do you want to simply place a risk on the map like I do with a task. I click and drop. Then you can drag and drop as necessary to place it more correctly.
Or do you need to georeference the risk somehow? Example would be you enter location RM167 int the table and it synchronizes to some part of the image representing room 167. I have another example where I do this by storing latitude and longitude of a city and have a conversion to relate it to the forms X, Y (left, top) location. The first method of simply dropping on the "image" is already done in the demo so that is easy. Geo-referencing can get hard unless these sites can be laid out in a perfect grid.

I noticed that in your main table you store the riskcolor. I would assume that is incorrect, not normalized. The color should be stored in a reference table and the color is determined based on some level of risk.

In my example I select a priority for the task and this tables determines the color of the image to show.

tblFloorComponents tblFloorComponents

ComponentTypeID	ComponentDescription	ImageName
7​	Urgent Priority	Red
5​	High Priority	Yellow
6​	Low Priority	Green
2​	Next Season	Purple
4​	Refit Item	Black
8​	Unassigned	Unassigned

Is a colored dot sufficient for what you want to show? Your map would show clusters of dots and likely the severe are red and least severe are green.

 

[TipsyWolf]

If you look at this

Solved - User made command button that can be moved with mouse?

haha! We got plenty of liferafts! Thanks MajP, is working good. Attached is idea of the jobs pane. I think when a new dot is moved to the plan/deck then it would ideally open up a new record/job for this new dot that has been added, this would highlight as a new job in the jobs detail pane...

www.access-programmers.co.uk

In this example you are dropping tasks on to a "floor plan" of a ship, to represent locations of task to take place. Also you can select multiple "floor plans". Similar to your idea of assigning risks to different Project Sites.

I use the term "floor plan" because this idea originated from dropping images of different tables on to a restaurant floor plan.

Imagine instead of tasks you are dropping risks on to a site location. Notice how the tasks get colored based on priority So I think this can be modified very easily. You can even try by changing the names of the 5 floor plans and placing your own images in the FloorDrawing attachments. You should see dots on your images. You can then move the dots (tasks) around on the image.
tblFloor tblFloor

FloorID	FloorName	FloorDescription	FloorDrawing
1​	Profile		1
2​	Sun deck		1
3​	Bridge deck		1
4​	Main deck		1
5​	Lower deck		1

The question is do you want to simply place a risk on the map like I do with a task. I click and drop. Then you can drag and drop as necessary to place it more correctly.
Or do you need to georeference the risk somehow? Example would be you enter location RM167 int the table and it synchronizes to some part of the image representing room 167. I have another example where I do this by storing latitude and longitude of a city and have a conversion to relate it to the forms X, Y (left, top) location. The first method of simply dropping on the "image" is already done in the demo so that is easy. Geo-referencing can get hard unless these sites can be laid out in a perfect grid.

I noticed that in your main table you store the riskcolor. I would assume that is incorrect, not normalized. The color should be stored in a reference table and the color is determined based on some level of risk.

In my example I select a priority for the task and this tables determines the color of the image to show.

tblFloorComponents tblFloorComponents

ComponentTypeID	ComponentDescription	ImageName
7​	Urgent Priority	Red
5​	High Priority	Yellow
6​	Low Priority	Green
2​	Next Season	Purple
4​	Refit Item	Black
8​	Unassigned	Unassigned

Is a colored dot sufficient for what you want to show? Your map would show clusters of dots and likely the severe are red and least severe are green.

very intresting , but very very hard for me as im low skill at access. but i'll have a closer look at it just a bit later, once i finish and run my db, so this is 1st thing in todo list after db goes live.
thank you very much for letting me know it is possible. i'll come back here later. have a nice day, Sir !

 

[MajP]

very intresting , but very very hard for me as im low skill at access.

For now no code is required. But you can modify it to get a better idea of what is possible.

1. Simply find some Site Diagrams and upload to tblFloor. For now do not create new records. But you should be able to edit the existing 5 records with new diagrams.. To Demo I put some site plans instead of ship diagrams and this should be more illustrative
2. Now you should be able to play with it and drag items on to the image and "create" a risk

This is for demo only so these are just the existing "task" fields. I did not mimic your fields. But a lot of these are likely the same types of fields, Risk Name, Risk Date, Priority, etc.

In this image I dropped 4 risks in Dept 123/ Dept 109. 2 are hi pri, 1 is urgent, 1 is low pri. If you click on the "risk" the window pops up and you can edit it.