Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-9350

Possible to provide a drawing of the Stripe 82 sky region for context?

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: SUIT
    • Labels:
    • Story Points:
      2
    • Sprint:
      SUIT Sprint 2017-4, SUIT Sprint 2017-5, SUIT Sprint 2017-6
    • Team:
      Science User Interface

      Description

      I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

      If this is an easy task, in what format would we need to specify the coordinates of the online?

      I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.

      ==============================================

      How to generate the region files attached here:

      1)Get four corners data for all the coadds FOVs for SDSS:
      curl -o sdssFourCorners.json -d 'query=SELECT+corner1Ra,corner1Decl,corner2Ra,corner2Decl,corner3Ra,corner3Decl,corner4Ra,corner4Decl+FROM+sdss_stripe82_00.DeepCoadd;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
      2)Convert the json file to csv using a tool on line:
      http://www.convertcsv.com/json-to-csv.htm
      3)Sort the csv file by corner1Ra
      4)Remove "^M"
      5)Convert the csv file to a region file by adding "polygon(" and ") #color=green" and a header "fk5"
      6)For only plot 1% or 10% FOVs:
      awk 'NR == 1 || NR % 100 == 0' input.reg > output_1pct.reg
      awk 'NR == 1 || NR % 10 == 0' input.reg > output_10pct.reg

      The region file can be loaded to Firefly.

        Attachments

          Issue Links

            Activity

            No builds found.
            gpdf Gregory Dubois-Felsmann created issue -
            Hide
            tatianag Tatiana Goldina added a comment - - edited

            We can overlay DS9 regions.

            Show
            tatianag Tatiana Goldina added a comment - - edited We can overlay DS9 regions.
            Hide
            gpdf Gregory Dubois-Felsmann added a comment -

            I think this is now more interesting, as now that the WISE data are on PDAC it will be good to be able to show the overlap region graphically when people are doing spatial joins between the two Object tables.

            Show
            gpdf Gregory Dubois-Felsmann added a comment - I think this is now more interesting, as now that the WISE data are on PDAC it will be good to be able to show the overlap region graphically when people are doing spatial joins between the two Object tables.
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Field Original Value New Value
            Epic Link DM-8350 [ 27954 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Sprint SUIT Sprint 2017-3 [ 357 ]
            Labels pdac FireflyCCB pdac
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Sprint SUIT Sprint 2017-3 [ 357 ] SUIT Sprint 2017-4 [ 603 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Rank Ranked lower
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Assignee Xiuqin Wu [ xiuqin ] Yi Mei [ ymei ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Description I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?
            I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?

            I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Story Points 2
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Sprint SUIT Sprint 2017-4 [ 603 ] SUIT Sprint 2017-4, SUIT Sprint 2017-5 [ 603, 604 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Rank Ranked higher
            Hide
            ymei Yi Mei [X] (Inactive) added a comment -

            I have attached the region file which contains 1% of the SDSS Strip 82 coadds and a png file to plot those coadds on an globe image.

            Let me know anything more need to be done.

            Show
            ymei Yi Mei [X] (Inactive) added a comment - I have attached the region file which contains 1% of the SDSS Strip 82 coadds and a png file to plot those coadds on an globe image. Let me know anything more need to be done.
            ymei Yi Mei [X] (Inactive) made changes -
            Reviewers Xiuqin Wu [ xiuqin ]
            Status In Progress [ 3 ] In Review [ 10004 ]
            ymei Yi Mei [X] (Inactive) made changes -
            Attachment SDSSStripe82Coadds_1%.png [ 29492 ]
            Attachment sdssFourCorners_sorted1pctawk.reg [ 29493 ]
            Hide
            ymei Yi Mei [X] (Inactive) added a comment -

            The shape of Stripe 82 coadds is not easy to draw the footprint outline. We can discuss about that.

            Show
            ymei Yi Mei [X] (Inactive) added a comment - The shape of Stripe 82 coadds is not easy to draw the footprint outline. We can discuss about that.
            ymei Yi Mei [X] (Inactive) made changes -
            Attachment sdssFourCorners_sorted10pctawk.reg [ 29497 ]
            Hide
            xiuqin Xiuqin Wu [X] (Inactive) added a comment -

            Please put inn more information explaining how you generated the region file.

            Show
            xiuqin Xiuqin Wu [X] (Inactive) added a comment - Please put inn more information explaining how you generated the region file.
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Sprint SUIT Sprint 2017-4, SUIT Sprint 2017-5 [ 603, 604 ] SUIT Sprint 2017-4, SUIT Sprint 2017-5, SUIT Sprint 2017-6 [ 603, 604, 609 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Rank Ranked higher
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Epic Link DM-8350 [ 27954 ] DM-8727 [ 28563 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Link This issue relates to DM-10431 [ DM-10431 ]
            ymei Yi Mei [X] (Inactive) made changes -
            Description I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?

            I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.
            I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?

            I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.



            How to generate the region files attached here:

            1)Get four corners data for all the coadds FOVs for SDSS:

            curl -o sdssFourCorners.json -d 'query=SELECT+corner1Ra,corner1Decl,corner2Ra,corner2Decl,corner3Ra,corner3Decl,corner4Ra,corner4Decl+FROM+sdss_stripe82_00.DeepCoadd;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync

            2)Convert the json file to csv using a tool on line:
            http://www.convertcsv.com/json-to-csv.htm

            3)Sort the csv file by corner1Ra

            4)Remove "^M"

            5)Convert the csv file to a region file by adding "polygon(" and ") #color=green" and a header "fk5"

            6)For only plot 1% or 10% FOVs:
            awk 'NR == 1 || NR % 100 == 0' input.reg > output_1pct.reg
            awk 'NR == 1 || NR % 10 == 0' input.reg > output_10pct.reg
            ymei Yi Mei [X] (Inactive) made changes -
            Description I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?

            I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.



            How to generate the region files attached here:

            1)Get four corners data for all the coadds FOVs for SDSS:

            curl -o sdssFourCorners.json -d 'query=SELECT+corner1Ra,corner1Decl,corner2Ra,corner2Decl,corner3Ra,corner3Decl,corner4Ra,corner4Decl+FROM+sdss_stripe82_00.DeepCoadd;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync

            2)Convert the json file to csv using a tool on line:
            http://www.convertcsv.com/json-to-csv.htm

            3)Sort the csv file by corner1Ra

            4)Remove "^M"

            5)Convert the csv file to a region file by adding "polygon(" and ") #color=green" and a header "fk5"

            6)For only plot 1% or 10% FOVs:
            awk 'NR == 1 || NR % 100 == 0' input.reg > output_1pct.reg
            awk 'NR == 1 || NR % 10 == 0' input.reg > output_10pct.reg
            I am wondering if it would be straightforward to provide a "footprint" outline of the Stripe 82 area on the sky for use in highly zoomed-out context images in PDAC.

            If this is an easy task, in what format would we need to specify the coordinates of the online?

            I think we can do a calculation of four corners of all the coadded images and produce a sd9 region file for the outline.


            ==============================================

            How to generate the region files attached here:

            1)Get four corners data for all the coadds FOVs for SDSS:
            curl -o sdssFourCorners.json -d 'query=SELECT+corner1Ra,corner1Decl,corner2Ra,corner2Decl,corner3Ra,corner3Decl,corner4Ra,corner4Decl+FROM+sdss_stripe82_00.DeepCoadd;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
            2)Convert the json file to csv using a tool on line:
            http://www.convertcsv.com/json-to-csv.htm
            3)Sort the csv file by corner1Ra
            4)Remove "^M"
            5)Convert the csv file to a region file by adding "polygon(" and ") #color=green" and a header "fk5"
            6)For only plot 1% or 10% FOVs:
            awk 'NR == 1 || NR % 100 == 0' input.reg > output_1pct.reg
            awk 'NR == 1 || NR % 10 == 0' input.reg > output_10pct.reg

            The region file can be loaded to Firefly.
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Labels FireflyCCB pdac pdac
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Status In Review [ 10004 ] Reviewed [ 10101 ]
            Hide
            xiuqin Xiuqin Wu [X] (Inactive) added a comment -

            Done

            Show
            xiuqin Xiuqin Wu [X] (Inactive) added a comment - Done
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Reviewed [ 10101 ] Done [ 10002 ]
            gpdf Gregory Dubois-Felsmann made changes -
            Link This issue relates to DM-14398 [ DM-14398 ]

              People

              Assignee:
              ymei Yi Mei [X] (Inactive)
              Reporter:
              gpdf Gregory Dubois-Felsmann
              Reviewers:
              Xiuqin Wu [X] (Inactive)
              Watchers:
              David Ciardi [X] (Inactive), Gregory Dubois-Felsmann, Tatiana Goldina, Xiuqin Wu [X] (Inactive), Yi Mei [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.