Skip to main content
7 events
when toggle format what by license comment
Mar 7, 2012 at 3:09 vote accept Craig
Mar 7, 2012 at 3:09 comment added Craig In the example data you linked to the procedure element was giving the stn_id (station id) and nested in the om:Result was a ms:Value which is the data that I am trying to set. But thanks to the other sample files (sos.map and obs.shp) I saw that changing my SQL to include the line "av.value::NUMERIC AS Value" gave me the output I wanted. Thanks for pointing me that way
Mar 6, 2012 at 22:52 comment added geographika @craig It looks like it should be. I've update my answer - try running with the test data to check it works with postGIS.
Mar 6, 2012 at 22:50 history edited geographika CC BY-SA 3.0
added 880 characters in body
Mar 6, 2012 at 20:47 comment added Craig Actually that 80 is the total_alkalinity_value for this response, but that can't be the right place for it. In the other examples I've seen the data value is within the "om:result" element
Mar 6, 2012 at 20:01 comment added Craig I was missing the sos_timeitem metadata but I had the rest. With that one added I now get a samplingTime element in the response (I've updated the question to show this) but still no data value. I also added sos_procedure_item even though it is optional so it should work without it. That only served to change the procedure to "80" instead of "ALKALINITY_SENSOR"
Mar 6, 2012 at 8:03 history answered geographika CC BY-SA 3.0