bpeng / tickets

0 stars 0 forks source link

Delta #13

Open bpeng opened 7 years ago

bpeng commented 7 years ago

This is the meta data part of the work that will replace the Oracle delta DB https://github.com/GeoNet/delta

It's CSV files of where things like seismic stations are https://github.com/GeoNet/delta/blob/master/network/stations.csv

The idea is that this repo will be updated as the network changes

So could you take a look at this and think about what we should do to be able to make web services for GeoJSON, KML, and maybe protobuf?

Service for searching, listing, and Editing (Put query)?

I think as should end up serving this info from somewhere below api.geonet.org.nz eventually but maybe just work in devx for now?

I'm not sure if we need to get the csv into a DB or if we should just sync it to s3 and then parse and reformat in code.

  • S3 is a good choice, as this is not frequently updated, but have to download and edit the whole file, and is error prone
  • Database is good for data integrity and allows editing per record,
  • github repo is easy to edit, but the update is not sync immediately.

it's useful to notice that the networks is an "internal code" and there is an "external" code so most of the seismic stations end up in the "NZ" network.

this has an example of reading CSV in Go https://github.com/GeoNet/fits-loader/blob/master/observation.go using encoding/csv

bpeng commented 7 years ago

http://info.geonet.org.nz/display/equip/Network+Location+Queries

http://magma.geonet.org.nz/ws-delta/site?type=cgps&status=Operational http://magma.geonet.org.nz/ws-delta/site?type=seismicStation&status=Operational&networkName=all-weak-motion http://magma.geonet.org.nz/ws-delta/site?type=seismicStation&status=Operational&networkName=all-strong-motion http://magma.geonet.org.nz/ws-delta/site?type=tsunami&status=Operational

bpeng commented 7 years ago

https://raw.githubusercontent.com/bpeng/delta/wip-geojson/data/gnss/marks.geojson https://raw.githubusercontent.com/bpeng/delta/wip-geojson/data/gnss/stations.geojson

bpeng commented 7 years ago
bpeng commented 7 years ago

New service https://github.com/GeoNet/tickets/issues/1050

bpeng commented 7 years ago

other layers https://github.com/GeoNet/haz/pull/138

http://api.geonet.org.nz/network/sensor?type=accelerometer

accelerometer   (Acclerometer)
barometer   (Barometer)
broadbandseismometer  (Broadband Seismometer)
buildingarraysensor  (Building Array)
hydrophone  (Hydrophone)
microphone  (Microphone)
pressuresensor  (Pressure Sensor)
shortperiodboreholeseismometer  (Short Period Borehole Seismometer)
shortperiodseismometer  (Short Period Seismometer)
strongmotionsensor  (Strong Motion Sensor)

gpsantenna  (GPS Antenna)
metsensor   (Met Sensor)
bpeng commented 7 years ago

Strong response: https://s3-ap-southeast-2.amazonaws.com/info-dev.geonet.org.nz/shaking/pga.geojson https://s3-ap-southeast-2.amazonaws.com/info-dev.geonet.org.nz/shaking/pgv.geojson