search

ioos / ioos-asset-inventory

Building the IOOS asset inventory with python
0 stars 0 forks source link

Write output into a geojson file #1

Closed MathewBiddle closed 3 years ago

MathewBiddle commented 3 years ago

write output csv as a geojson file. see https://gis.stackexchange.com/questions/130963/write-geojson-into-a-geojson-file-with-python

MathewBiddle commented 3 years ago

See https://github.com/MathewBiddle/assetInventory/blob/master/2019/compiled_assets.geojson

MathewBiddle commented 3 years ago

@kbailey-noaa let me know if this is something you would find useful. I had to drop ~50 stations due to various data inconsistencies (bad coordinates, hf radar assets, etc.). I can clean those up and get them on the map if this is something we'd like to pursue.

Also, github allows you to search through csv files! Take a look at https://github.com/MathewBiddle/assetInventory/blob/master/2019/2019_Combined_asset_Inventory.csv and use the search this file... option. Essentially a free text filter for the file.

Would the map and search capabilities for the csv file be sufficient for this resource? Might be good to capture the various questions we'd like this resource to answer.

kbailey-noaa commented 3 years ago

@MathewBiddle Definitely! I think there are some gliders that snuck in there too (SCCOOS) that need to be filtered. ...I just used the search this file... option and was able to find there are 4 SCCOOS gliders in there! This is really great. Use cases / questions are things like "How many stations measure water level?" and "Of those, how many are funded by IOOS?" The problem with the RA submissions was there is no standard name for water level so I'd get variations, and couldn't search on a single term. This is why I ended up making the 2018 inventory for arcgis use, which splits out the variables. I think we should attempt to use that as a baseline and update that for 2020 submissions. I don't think the RAs are adding many stations, so should be relatively low effort.

kbailey-noaa commented 3 years ago

@MathewBiddle Not sure how to import the 2020 processed data into Google Earth, so was wondering if you'd be able to convert to a .kml or .kmz file?

MathewBiddle commented 3 years ago

Let me see what other formats geopandas can write out. I'll update when I find out more.

MathewBiddle commented 3 years ago

@kbailey-noaa See if this kml works. I'll keep looking into kmz as well.

Right click this link and download as kml.

kbailey-noaa commented 3 years ago

Got it, thanks!!

MathewBiddle commented 3 years ago

@kbailey-noaa, I found a bug in my code where I wasn't capturing some of the ph and salinity data types. It should be fixed now and the respective files have been updated.

MathewBiddle commented 3 years ago

seems to be resolved