Example queries =============== schema ------ These queries demonstrate the different output formats available https://www.uclageo.com/gm_database/api/index.php/schema/list?format=html https://www.uclageo.com/gm_database/api/index.php/schema/list?format=json https://www.uclageo.com/gm_database/api/index.php/schema/list?format=csv These queries demonstrate use of the tables and table_list query string parameters https://www.uclageo.com/gm_database/api/index.php/schema/list?format=html&tables=intensity_measure,resp_spectra https://www.uclageo.com/gm_database/api/index.php/schema/list?format=html&tables=intensity_measure,resp_spectra&table_list=false flatfile -------- The query below returns 500 entries for the event, motion, intensity_measure, response_spectra, motion, event, station, component, event_type, and site tables sites with V\ :sub:`S30` \ less than 300 m/s (i.e., between 0 and 300 m/s). `flatfile query 1 link `_ :: https://www.uclageo.com/gm_database/api/index.php/flatfile?format=html&limit=500&tables=intensity_measure,response_spectra,motion,event,station,component,event_type,site&vs30=0-300 One issue you might notice about this query is that each motion_id is repeated 4 times. That may seem strange because there was only one motion at each site. The issue is that there are many different components in the database. In this case, the components are H1, H2, V, and RotD50. If we are only interested in one of the components, we can enter it like this. `flatfile query 2 link `_ :: https://www.uclageo.com/gm_database/api/index.php/flatfile?format=html&limit=500&tables=event,motion,intensity_measure,response_spectra,motion,event,station,component,event_type,site&vs30=0-300&component_abbreviation=RotD50 Now we have a table that lists only the RotD50 component. What if we want to make it more complicated, and specify a range of PGA and sort the values in descending order of PGA? We would then do this. `flatfile query 3 link `_ :: https://www.uclageo.com/gm_database/api/index.php/flatfile?format=html&limit=500&tables=event,motion,intensity_measure,response_spectra,motion,event,station,component,event_type,site&vs30=0-300&component_abbreviation=RotD50&PGA=0.1-0.2&sortby=PGA&order=DESC We could go on and on like this all day because there are so many different possibilities here. I think you get the picture though because that last one was pretty complicated. Feel free to reach out to us if you have any questions about forming these URLs.