Subaru-PFS / spt_target_uploader

A web application to validate and upload target lists with pointing simulations for PFS observation
https://pfs-etc.naoj.hawaii.edu/uploader/
MIT License
1 stars 0 forks source link

64-bit integers are not displayed correctly in the Tabulator widget #28

Closed monodera closed 7 months ago

monodera commented 1 year ago

64-bit integers after a certain number are not correctly displayed in the target list. This related to a Bokeh datamodel, so it would be difficult to fix. We may need to consider to use a different widget if those can handle them properly exists.

Input list:

ob_code obj_id ra dec equinox exptime priority resolution
obj0_eet900 109471469256015134 146.925596 1.228884 J2000 900 9 M
obj1_eet900 110931472826814909 147.282679 2.445355 J2000 900 7 M
obj2_eet900 109481470008251431 147.000815 1.234118 J2000 900 8 M
obj3_eet900 109891465704899386 146.570465 1.582479 J2000 900 4 M
obj4_eet900 109891465718875969 146.57187 1.579617 J2000 900 6 M
obj5_eet900 109921478271454299 147.82713 1.603211 J2000 900 2 M
obj6_eet900 110871474784583379 147.478434 2.394059 J2000 900 3 M
obj7_eet900 109471464933044585 146.493297 1.228462 J2000 900 4 M
obj8_eet900 109731462327942764 146.232787 1.443574 J2000 900 1 M

Output table: Screenshot 2023-10-04 at 11 01 32

monodera commented 1 year ago

It seems that browsers cannot handle large integer properly, so no Bokeh, Perspective, and Tabulator support for them. Reference: https://discourse.bokeh.org/t/hovertool-long-int-accuracy-loss/4953/10

It may be okay for the display purpose to convert them to string, but sorting wouldn't behave as expected for numbers.

monodera commented 1 year ago

mentioned in #102 but we need to fix or put a workaround.

monodera commented 7 months ago

addressed in issue/184-checkduplication-on-obj_id branch.

monodera commented 7 months ago

Example:

Screenshot 2024-05-01 at 19 20 55