Data API Help

HTML Form

Link

dataAPI

Query method Parameters
  1. Choose format type
  2. Date Range - Number of days back (integer) or timeframe (yyyy-mm-dd hh:mm:ss) to gather data
  3. Select Category Type or Sensor ID
  4. Click Submit to get data

Direct URL

Link

/dataAPI/catdata.php?format=___&bytype___&cid=___&days=___

Examples
  • /dataAPI/retrievedata.php?format=cvs&bytype=category&cid=1&bydate=back&days=31
  • /dataAPI/retrievedata.php?format=xml&bytype=sensor&sid=100&bydate=back&days=3
  • /dataAPI/retrievedata.php?format=json&bytype=sensor&sid=100&bydate=range&tstart=2016-01-28 20:01:00&tend=2016-05-30 20:01:00
Description
parameter type default description
format string tsv Specify the output format.
  • format=tsv
  • format=csv
  • format=xml
  • format=html
  • format=json
bydate string back Choose a way to limit the data by date
  • bydate=back

    Number of days back to gather data. Need to set accompanying 'days=' param

  • bydate=range

    Limit data between two dates. Need to set the start/end dates with 'tstart=' & 'tend=' params

  • days
integer 1 Limit number of days to include before the current time. Needed with param bydate=back
  • tstart
  • tend
date-time null Limit to data on or after the specified start time and on or before the specified end time. Needed with parpm bydate=range.

tstart=yyyy-mm-dd hh:mm:ss&tend=yyyy-mm-dd hh:mm:ss

bytype string null Select the how to identify records. The allowed values are:
  • bytype=category

    Use the category ID to get data over multiple sensors. Set with 'cid=' param.

  • bytype=sensor

    Use to select a single sensor. Set with 'sid=' param.

  • cid
integer null Select the specific category ID. Needs 'bytype=category' param
  • sid
integer null Select the specific sensor ID to collect data. Needs 'bytype=sensor'.

List of Categories

Streams
Sensor ID Sensor Name Latitude Longitude SensorType
1445Guadalupe River at Alamitos Fish Ladder- Low Flow Only37.246852874756-121.869926452641
1450Upper Penitencia Creek below Mabury- Low Flow Only37.371725-121.8614921
1451Mabury Diversion- Low Flow Only001
1456Hale Creek below Magdalena Ct- High Flow Only37.358940124512-122.099807739261
1459Permanente Creek at Rancho San Antonio- High Flow Only001
1460Adobe Creek at Middlefield Rd- High Flow Only37.422370910645-122.110519409181
1463Thompson Creek at Quimby Rd.-High Flow Only37.32362-121.8078791
1467West Little Llagas Creek at Edmundson Ave- High Flow Only37.111588-121.6440731
1469East Little Llagas at Church Ave- High Flow Only001
1471Available001
1475Test001
1477Calabazas Creek at Wilcox School- High Flow Only37.36528396606445-121.987106323242191
1479Alm-Cal Cnl at Flume001
1484Lower Silver Creek below King Rd- High Flow Only37.360103-121.8648361
1485Canoas Creek at Almaden Exp.- High Flow Only37.288520812988-121.881164550781
1487Alm-Cal Cnl Bertram001
1489Upper Penitencia Creek at Piedmont Rd37.390598297119-121.842979431151
1490Los Gatos Creek below Lexington Reservoir37.218933105469-121.985244750981
1491Upper Silver Creek at Yerba Buena- High Flow Only37.295749664307-121.807861328121
1492Los Gatos Creek at Lark Ave37.251795-121.9648811
1494Los Gatos Creek at Lincoln Ave37.312442779541-121.90457153321
1495Coyote Creek below Coyote Percolation Pond- Low Flow Only37.23477935791-121.760719299321
1497Coyote Percolation Pond (Stage Only)37.234296-121.7598661
1498Coyote Creek at Madrone37.168483734131-121.649520874021
1501Available001
1502Lower Silver Creek at Ocala Ave- (Gage removed for Project)37.343059539795-121.81291198731
1504Guadalupe River at Tasman Dr- Stage Only37.40990447998-121.959411621091
1506Guadalupe River at Montague Expwy- Stage Only37.395332336426-121.940193176271
1523West Permanente Creek below Deer Farm- High Flow Only001
1525Uvas Creek abv W. Luchessa Ave36.992496490479-121.573501586911
1531Guadalupe River at Gold St- Stage Only37.422370910645-121.975944519041
1532Stevens Creek above Hwy 85 near Central Ave001
1533Guadalupe River at Hwy 101- Stage Only001
1534Guadalupe River at Trimble Rd- Stage Only37.379306793213-121.937950134281
1537Matadero at Waverly001
1538U. Penitencia at Dorel- Radar001
1540Calabazas Creek at Rainbow Drive- High Flow Only37.30070877075195-122.026702880859381
1542Guadalupe Creek below Guadalupe Reservoir37.199615478516-121.881607055661
1544Alamitos Creek below Almaden Reservoir37.168605804443-121.828292846681
1545Berryessa Creek at Calaveras Blvd- Gage removed for Project37.432662963867-121.892288208011
1546Calero Creek below Calero Reservoir37.186122894287-121.793075561521
1547El Camino Stormdrain- Stage Only37.368602752686-121.9969253541
1548Upper Penitencia Creek at Dorel Dr- Low Flow Only37.395233154297-121.828147888181
1549Permanente Creek at Berry Ave- High Flow Only37.361498-122.0868911
1550Masson Fish Ladder- Low Flow Only37.233222-121.8989321
1878San Franciscuito Ck. nr. Stanford - USGS001
2050San Tomas Creek above Williams Rd37.30655670166-121.964103698731
2054Los Gatos Creek below Kirk Dam- Low Flow Only37.260414123535-121.957092285161
2056Coyote Creek at E. William- High Flow Only37.336986541748-121.868286132811
2058Ross Creek at Cherry Ave37.263134002686-121.886772155761
2060Coyote Creek at Hwy 237- Stage Only001
2062Coyote Creek at Edenvale37.270919799805-121.797668457031
2076Coyote Inflow001
2078Available001
2086Llagas Creek at Southside Dr- Stage Only001
5010Fisher Creek at Monterey Rd001
5015Almaden-Calero Canal at Almaden Reservoir (GOES)001
5023Guadalupe River above Almaden Expwy (GOES)37.280822-121.8798491
5044Stevens Creek below Stevens Creek Reservoir (GOES)37.306155-122.0732381
5045Stevens Creek above Stevens Creek Reservoir (GOES)- Stage Only37.27952-122.07371
5048Alamitos Creek above Almaden Reservoir (GOES)-Partial Inflow001
5062Los Gatos Creek above Lexington Reservoir (GOES)- Partial High Flow Inflow Only001
5069Llagas Creek below Chesbro Reservoir (GOES)001
5070Alamitos Creek at Graystone (GOES)001
5074Sunnyvale East Channel above Hwy 101 (GOES)- High Flow Only37.394555-122.0103731
5077Coyote Ck above Coyote Reservoir - USGS001
5078Bodfish Creek at Whitehurst Rd001
5084Uvas Creek Outlet Flows (GOES)001
5085Llagas Creek at Southside Dr. - USGS001
5096Saratoga Creek at Saratoga - USGS001
5097Coyote Creek at Hwy 237 - USGS001
5098Matadero Creek at Palo Alto - USGS001
5100Lower Penitencia Creek at Machado Ave (GOES)- High Flow Only37.422065-121.9068521
5101Matadero Ck at Palo Alto - USGS001
5109Guadalupe River at Highway 101 - USGS001
5112San Francisquito Ck at Stanford Univ - USGS001
5122San Tomas at Mission (GOES)- High Flow Only001
5125Adobe Creek at Foothill College (GOES)37.358125-122.1282271
15060Coyote at 237 --- USGS001
Rainfall
Sensor ID Sensor Name Latitude Longitude SensorType
1453City of San Jose (6131)37.349563598633-121.904380798342
1454Maryknoll Fields (6144)37.332221984863-122.080833435062
1457Trappers Trail (6142)37.34611129760742-122.180831909179692
1461Edmundson Ave (6143)37.111392974854-121.644142150882
1465Canada de los Osos (6145)37.037498474121094-121.420829772949222
1500Rancho San Antonio Park (6140)37.33000183105469-122.118057250976562
1503Morgan Hill RF 136002
1508Castro Valley (6015)36.958431243896484-121.604705810546882
1509Valley Christian (6077)37.239463806152-122.070114135742
1510Stevens Creek (6100)37.28751754760742-122.07873535156252
1511West Yard (6108)37.30821990966797-121.994377136230472
1512Mount Hamilton (6067)37.34865188598633-121.630142211914062
1513Calero Watershed (6128)37.16970443725586-121.75742340087892
1514Curtner Ranch (6023)37.467124938964844-121.877624511718752
1515Mountain View (6121)37.394256591796875-122.059707641601562
1516Evergreen (6132)37.29868698120117-121.757041931152342
1517Biel Ranch (6008)37.46715545654297-121.530876159667972
1518Shanti Ashrama (6098)37.308494567871094-121.471496582031252
1519Coit Ranch (6018)37.15058898925781-121.419624328613282
1520Laguna Seca RF 37002
1521Sunnyvale WTP (6048)37.355289459229-122.059364318852
1522Available002
1524Rinconada WTP (6079)37.255252838134766-121.982597351074222
1526Guadalupe (6123)37.1899299621582-121.891975402832032
1527Vasona Pump (6125)37.258674621582-121.959892272952
1528West Little Llagas (6139)37.135669708252-121.671585083012
1529Church Ave Perc Ponds (6134)37.06863021850586-121.597099304199222
1530Uvas Canyon County Park (6135)37.0847282409668-121.792182922363282
1551Palm Ave (6141)37.171112060546875-121.727500915527342
1868San Bruno Mt (San Mateo)002
1876Huddart Park (SMC)37.439716339111-122.288909912112
1880Los Trancos (SMC)37.326511383057-122.180641174322
1882Towneridge002
1884Saratoga Gap002
1889Windy Hill (JPA)37.35799407959-122.239906311042
1890Wunderlich (JPA)37.402240753174-122.241722106932
2053Guadalupe Slough (6016)37.45333480835-122.032058715822
2057Uvas Reservoir (6104)37.06549835205078-121.68881988525392
2065Alamitos (6001)37.247108459472656-121.870643615722662
2066Johnson Ranch (6036)37.220951080322266-121.931190490722662
2067U.T.C (6102)37.23379135131836-121.690513610839842
2068Banjo Point (6138)37.195983886719-121.984779357912
2069Haskins Ranch (6034)37.39568328857422-121.765296936035162
2070Penitencia WTP (6099)37.39820098876953-121.835159301757812
2071Cow Ridge (6127)37.2689208984375-121.613166809082032
2072Loma Prieta (6044)37.11088180541992-121.844276428222662
2073Leroy Anderson Dam (6041)37.1645622253418-121.626968383789062
2075Coyote Reservoir (6021)37.11514663696289-121.55031585693362
2079Coe Park (6017)37.18645477294922-121.546295166015622
2080Almaden (6004)37.15724182128906-121.844429016113282
2081Mount Umunhum (6069)37.158260345459-121.906417846682
2096Dahl Ranch RF 24002
2099Palo Alto (6129)37.455562591552734-122.100601196289062
20001Pulgas Raingauge (CDEC)37.475-122.2982
20002La Honda Raingauge (CDEC)37.3053-122.25392
20003Las Cumbres Raingauge (CDEC)37.208-122.0632
20004Schuliies Road Raingauge (CDEC)37.133-121.9672
20005Burrell Station (CDEC)37.133-121.9672
20006Ormsby Road Raingauge (CDEC)37.0669-121.8242
20007Mt Hamilton Raingauge (CDEC)002
20008Diablo Canyon Raingauge (CDEC)37.329-121.3022
20009Poverty Raingauge (CDEC)37.443056-121.7705562
Water Temperature
Sensor ID Sensor Name Latitude Longitude SensorType
1452Penitencia Creek Water Temperature-0010
Discharge
Sensor ID Sensor Name Latitude Longitude SensorType
7010Bear Creek at Sand Hill Rd (JPA - High Flow)37.40993-122.2417813
7020Los Trancos at Arastradero Rd (JPA - High Flow)37.38312-122.1929513
7030Searsville Lake Outflow (JPA - High Flow)37.40721-122.2379313
15077Coyote Ck ab Coyote Reservoir - USGS37.07778-121.4933313
15085Llagas Creek at Southside Dr. - USGS36.9875-121.5261213
15096Saratoga Creek at Big Basin Way (USGS)37.25443-122.03957513
15097Coyote Creek at Hwy 237 - USGS37.42222-121.9263813
15101Matadero Ck at Palo Alto - USGS37.42167-122.1344513
15109Guadalupe River at Highway 101 - USGS37.37389-121.9319413
15112San Francisquito Ck at Stanford Univ - USGS37.42334-122.1883313
Reservoirs
Sensor ID Sensor Name Latitude Longitude SensorType
1462Anderson Res- Backup gage0020
1464Stevens Creek Reservoir37.298730804-122.07682723420
1468Vasona Reservoir37.2469984063-121.96586832320
1470Chesbro Reservoir37.1166945208-121.69327994120
1472Uvas Reservoir37.0643350317-121.6922004120
1480Anderson Reservoir37.1648293935-121.6263282140
1488Available37.1648293935-121.6263282140
2074Coyote Reservoir37.1193390685-121.54954459720
2090Almaden Reservoir37.164665-121.82874920
2092Guadalupe Reservoir37.199047-121.87927620
2094Calero Reservoir37.1830332965-121.79271714820
4007Lexington Reservoir (GOES)37.2014664631-121.9889036120