humlab-sead / sead_browser_client

Online browser client for the SEAD database
2 stars 0 forks source link

Sample coordinates map #296

Open johanvonboer opened 11 months ago

johanvonboer commented 11 months ago

select * from tbl_sample_coordinates join tbl_coordinate_method_dimensions on tbl_sample_coordinates.coordinate_method_dimension_id=tbl_coordinate_method_dimensions.coordinate_method_dimension_id

johanvonboer commented 11 months ago

Do something with this.

johanvonboer commented 11 months ago

Here's the summary of a coordinate for a sample: image

The coordinate system is here specified as being a local coordinate system, and the units are specified as being in meters. However the measurement is specified as 91837.6. It seems very unlikely to me that this coordinate would be 91837.6 meters from a local reference point, so what's going on here? Wrong coordinate system specified?

johanvonboer commented 11 months ago

Another question relating to this; Can a local coordinate system be assumed to be relative to the coordinate of the site itself? In other words, can we trust that the site coordinate is the coordinate being used as the reference point of the local coordinate system?

johanvonboer commented 11 months ago

People don't always start at zero.

johanvonboer commented 11 months ago

Add other basemaps, such as topographic. Add more info to tooltips (such as alt. identifiers for samples)