Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151779 | 151779 | 241988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Franconia St | 18 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010085.85388 | 2099710.92257 | 37.745975284649 | -122.40782942930299 | (37.745975284649, -122.407829429303) | |||
| 12485 | 12485 | 94989 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010751.8878 | 2087184.0277 | 37.711616318234206 | -122.404644660956 | (37.7116163182342, -122.404644660956) | ||||
| 138606 | 138606 | 94563 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Oak St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | Permit Number 53745 | 6005493.0 | 2110231.0 | 37.7746027492624 | -122.42445906794902 | (37.7746027492624, -122.424459067949) | |||
| 47213 | 47213 | 180192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Campbell Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6011017.70209 | 2088215.1538900002 | 37.714462435764105 | -122.40379844036 | (37.7144624357641, -122.40379844036) | ||||
| 3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4040 | 4040 | 253539 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 7 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4116 | 4116 | 253537 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 5 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 36699 | 36699 | 218742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998867.6092 | 2095887.4020200002 | 37.734842393562104 | -122.44634545 | (37.7348423935621, -122.44634545) | |||
| 43628 | 43628 | 218738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998805.22806 | 2095928.00663 | 37.734950321189 | -122.446564042812 | (37.734950321189, -122.446564042812) | |||
| 61847 | 61847 | 218740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998836.63311 | 2095909.61295 | 37.734901610308704 | -122.446454142063 | (37.7349016103087, -122.446454142063) | |||
| 132146 | 132146 | 218741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998851.10975 | 2095900.2680400002 | 37.73487677824821 | -122.44640341939 | (37.7348767782482, -122.44640341939) | |||
| 149374 | 149374 | 218737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998790.02414 | 2095935.97535 | 37.7349713329455 | -122.446617181062 | (37.7349713329455, -122.446617181062) | |||
| 153368 | 153368 | 218739 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998821.443390001 | 2095918.27736 | 37.7349245331257 | -122.446507281187 | (37.7349245331257, -122.446507281187) | |||
| 5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
| 10437 | 10437 | 115185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | ||||
| 10548 | 10548 | 15906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | ||
| 10742 | 10742 | 115189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999437.68927 | 2089235.07738 | 37.716609193035396 | -122.443896694081 | (37.7166091930354, -122.443896694081) | ||||
| 10802 | 10802 | 112326 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:24:00 PM | 3 | 3x3 | 5998237.3346 | 2088425.37851 | 37.7143174021005 | -122.447987437577 | (37.7143174021005, -122.447987437577) | ||
| 10887 | 10887 | 15908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.210469999 | 2087081.2429799999 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | ||
| 10898 | 10898 | 112312 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:44:00 PM | 3 | 3x3 | 5998649.95946 | 2088647.23333 | 37.7149501426196 | -122.446577201695 | (37.7149501426196, -122.446577201695) | ||
| 10954 | 10954 | 15902 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.7453700001 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | ||
| 10960 | 10960 | 112316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 09:14:00 AM | 3 | 3x3 | 5998526.38122 | 2088580.63045 | 37.714760206699204 | -122.446999548499 | (37.7147602066992, -122.446999548499) | ||
| 10967 | 10967 | 112330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 01:58:00 PM | 3 | 3x3 | 5998125.15209 | 2088363.53994 | 37.7141411943457 | -122.448370732221 | (37.7141411943457, -122.448370732221) | ||
| 11003 | 11003 | 30034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001399.41366 | 2091990.2767900003 | 37.7242860560331 | -122.437313179168 | (37.7242860560331, -122.437313179168) | ||
| 11166 | 11166 | 112236 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/2015 08:45:00 AM | 3 | 5999186.55259 | 2088995.9330400003 | 37.7159382286299 | -122.444747565144 | (37.7159382286299, -122.444747565144) | |||
| 11224 | 11224 | 112322 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:56:00 PM | 3 | 3x3 | 5998335.48775 | 2088476.67454 | 37.7144638594022 | -122.447651873544 | (37.7144638594022, -122.447651873544) | ||
| 11251 | 11251 | 115187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999459.81391 | 2089256.7158599999 | 37.716669869389 | -122.443821774256 | (37.716669869389, -122.443821774256) | ||||
| 11252 | 11252 | 112315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:16:00 PM | 3 | 3x3 | 5998550.09979 | 2088594.3048900003 | 37.7147991086711 | -122.446918551062 | (37.7147991086711, -122.446918551062) | ||
| 11265 | 11265 | 112313 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:23:00 PM | 3 | 3x3 | 5998619.49642 | 2088631.19842 | 37.714904374305604 | -122.446681341371 | (37.7149043743056, -122.446681341371) | ||
| 11509 | 11509 | 15905 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/13/1994 12:00:00 AM | 12 | TR20 | 5998282.5187800005 | 2087066.12192 | 37.71058777596279 | -122.44773347081998 | (37.7105877759628, -122.44773347082) | ||
| 11513 | 11513 | 112244 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:23:00 AM | 3 | 5999075.356319999 | 2088897.5178 | 37.7156616565467 | -122.445124838863 | (37.7156616565467, -122.445124838863) | |||
| 11515 | 11515 | 112327 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:20:00 PM | 3 | 3x3 | 5998214.4608 | 2088412.1030400002 | 37.7142796431617 | -122.448065542797 | (37.7142796431617, -122.448065542797) | ||
| 11532 | 11532 | 15904 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | TR20 | 5998273.75241 | 2087065.5939900002 | 37.7105858253457 | -122.44776373121 | (37.7105858253457, -122.44776373121) | ||
| 11633 | 11633 | 30033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001409.17078 | 2092014.85305 | 37.7243540915456 | -122.43728120918199 | (37.7243540915456, -122.437281209182) | ||
| 11893 | 11893 | 112323 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:50:00 PM | 3 | 3x3 | 5998308.396509999 | 2088461.81998 | 37.714421523820796 | -122.447744442568 | (37.7144215238208, -122.447744442568) | ||
| 11901 | 11901 | 30035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001391.73475 | 2091959.7367599998 | 37.7242017634957 | -122.437337538205 | (37.7242017634957, -122.437337538205) | ||
| 11999 | 11999 | 112324 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:32:00 PM | 3 | 3x3 | 5998283.0477 | 2088450.2631 | 37.7143883424342 | -122.447831226251 | (37.7143883424342, -122.447831226251) | ||
| 12086 | 12086 | 30036 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001380.52526 | 2091907.5611599998 | 37.7240578638665 | -122.437372553325 | (37.7240578638665, -122.437372553325) | ||
| 12254 | 12254 | 112240 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:38:00 AM | 3 | 5999143.09775 | 2088953.6674799998 | 37.7158196970968 | -122.444894728405 | (37.7158196970968, -122.444894728405) | |||
| 12438 | 12438 | 112308 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 02:04:00 PM | 3 | 3x3 | 5998782.969959999 | 2088720.9540000001 | 37.715160159502396 | -122.44612276258002 | (37.7151601595024, -122.44612276258) | ||
| 12558 | 12558 | 112328 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:14:00 PM | 3 | 3x3 | 5998191.630340001 | 2088400.91043 | 37.714247605705296 | -122.448143648024 | (37.7142476057053, -122.448143648024) | ||
| 12577 | 12577 | 15907 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998292.86326 | 2087073.3238400002 | 37.7106081420281 | -122.447698236291 | (37.7106081420281, -122.447698236291) | ||
| 12661 | 12661 | 112310 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:58:00 PM | 3 | 3x3 | 5998739.5143099995 | 2088696.4519999998 | 37.7150904008744 | -122.446271201979 | (37.7150904008744, -122.446271201979) | ||
| 12735 | 12735 | 115192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999381.87795 | 2089181.7631299999 | 37.7164596204897 | -122.44408577653499 | (37.7164596204897, -122.444085776535) | ||||
| 12770 | 12770 | 112309 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 02:01:00 PM | 3 | 3x3 | 5998760.629790001 | 2088707.7894700002 | 37.715122736896205 | -122.44619903316001 | (37.7151227368962, -122.44619903316) | ||
| 12816 | 12816 | 112331 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 01:54:00 PM | 3 | 3x3 | 5998098.06062 | 2088348.6855900001 | 37.71409885876079 | -122.44846330124399 | (37.7140988587608, -122.448463301244) | ||
| 12834 | 12834 | 112320 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 03:02:00 PM | 3 | 3x3 | 5998366.80541 | 2088493.52458 | 37.7145119155785 | -122.447544839824 | (37.7145119155785, -122.447544839824) | ||
| 12844 | 12844 | 30032 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001428.828369999 | 2092060.2753299999 | 37.724479928297896 | -122.43721650653099 | (37.7244799282979, -122.437216506531) | ||
| 12917 | 12917 | 112325 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:28:00 PM | 3 | 3x3 | 5998267.37148 | 2088441.00492 | 37.7143620255669 | -122.447884743106 | (37.7143620255669, -122.447884743106) | ||
| 12942 | 12942 | 112238 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 08:30:00 AM | 3 | 5999164.96486 | 2088975.3114099998 | 37.715880374360204 | -122.444820700722 | (37.7158803743602, -122.444820700722) | |||
| 13000 | 13000 | 112314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:18:00 PM | 3 | 3x3 | 5998572.09352 | 2088605.5152 | 37.7148311461116 | -122.44684333807699 | (37.7148311461116, -122.446843338077) | ||
| 13036 | 13036 | 112329 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:10:00 PM | 3 | 3x3 | 5998165.78515 | 2088385.61312 | 37.7142041252815 | -122.448231877823 | (37.7142041252815, -122.448231877823) | ||
| 13071 | 13071 | 112311 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:54:00 PM | 3 | 3x3 | 5998675.77838 | 2088661.28113 | 37.7149901894291 | -122.44648897100201 | (37.7149901894291, -122.446488971002) | ||
| 13110 | 13110 | 112242 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:31:00 AM | 3 | 5999099.9806 | 2088915.2496599997 | 37.7157117496696 | -122.445041000443 | (37.7157117496696, -122.445041000443) | |||
| 13125 | 13125 | 112321 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:59:00 PM | 3 | 3x3 | 5998349.45615 | 2088484.30117 | 37.7144855986971 | -122.447604142043 | (37.7144855986971, -122.447604142043) | ||
| 23474 | 23474 | 180020 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001294.8535400005 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | |||
| 23615 | 23615 | 180300 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001840.8677900005 | 2092960.9802599999 | 37.7269764741671 | -122.43585655983 | (37.7269764741671, -122.43585655983) | |||
| 23923 | 23923 | 180093 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999825.21966 | 2089601.0341900003 | 37.717636125294206 | -122.44258345996799 | (37.7176361252942, -122.442583459968) | |||
| 25341 | 25341 | 180280 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.730056572136704 | -122.432867327564 | (37.7300565721367, -122.432867327564) | |||
| 25355 | 25355 | 180096 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999764.69095 | 2089543.44622 | 37.717474551281704 | -122.44278854676399 | (37.7174745512817, -122.442788546764) | |||
| 27205 | 27205 | 180297 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001879.66047 | 2093045.2388099998 | 37.7272100325946 | -122.43572848019699 | (37.7272100325946, -122.435728480197) | |||
| 28906 | 28906 | 180049 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000848.655230001 | 2090751.2328 | 37.7208525973406 | -122.439128305154 | (37.7208525973406, -122.439128305154) | |||
| 29276 | 29276 | 180062 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000649.61116 | 2090402.60873 | 37.7198840266041 | -122.439791356397 | (37.7198840266041, -122.439791356397) | |||
| 30468 | 30468 | 180034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001097.83369 | 2091228.63345 | 37.7221776071819 | -122.43830115639601 | (37.7221776071819, -122.438301156396) | |||
| 31090 | 31090 | 180050 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000834.87553 | 2090725.84202 | 37.7207820959038 | -122.43917411838801 | (37.7207820959038, -122.439174118388) | |||
| 31509 | 31509 | 180054 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000783.664419999 | 2090626.8381700001 | 37.7205073395271 | -122.43934404620501 | (37.7205073395271, -122.439344046205) | |||
| 31681 | 31681 | 180089 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999997.23135 | 2089763.94995 | 37.7180932587717 | -122.442000582366 | (37.7180932587717, -122.442000582366) | |||
| 32210 | 32210 | 180306 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001696.41333 | 2092647.43732 | 37.7261073495475 | -122.436333505406 | (37.7261073495475, -122.436333505406) | |||
| 33314 | 33314 | 180058 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000718.4568 | 2090503.6472599998 | 37.7201653741024 | -122.43956062093599 | (37.7201653741024, -122.439560620936) | |||
| 33418 | 33418 | 180274 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002921.14547 | 2094140.96014 | 37.7302777397151 | -122.432206295294 | (37.7302777397151, -122.432206295294) | |||
| 33919 | 33919 | 180071 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000421.866669999 | 2090169.28245 | 37.719230399348795 | -122.440561861357 | (37.7192303993488, -122.440561861357) | |||
| 34228 | 34228 | 218724 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995542.9319 | 2099985.30545 | 37.7459037813392 | -122.458136423557 | (37.7459037813392, -122.458136423557) | |||
| 34599 | 34599 | 180281 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002702.132669999 | 2094050.3830099998 | 37.7300166152669 | -122.43295698278799 | (37.7300166152669, -122.432956982788) | |||
| 34779 | 34779 | 180046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000892.57758 | 2090835.74953 | 37.72108716032729 | -122.438982533116 | (37.7210871603273, -122.438982533116) | |||
| 34829 | 34829 | 180308 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001657.6308 | 2092560.9693 | 37.7258677242939 | -122.43646138808201 | (37.7258677242939, -122.436461388082) | |||
| 36534 | 36534 | 180276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002837.82705 | 2094112.9620299998 | 37.7301961388438 | -122.432492339061 | (37.7301961388438, -122.432492339061) | |||
| 36582 | 36582 | 180286 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1416x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002358.56722 | 2093739.38526 | 37.729143192803896 | -122.434122505942 | (37.7291431928039, -122.434122505942) | |||
| 36706 | 36706 | 112246 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5999047.56745 | 2088876.5109400002 | 37.715602390323 | -122.44521938006399 | (37.715602390323, -122.445219380064) | ||||
| 36746 | 36746 | 180279 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002763.71136 | 2094082.1093 | 37.7301072210706 | -122.43274636337699 | (37.7301072210706, -122.432746363377) | |||
| 38485 | 38485 | 180041 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6000958.05426 | 2090960.37345 | 37.7214330746668 | -122.438765125611 | (37.7214330746668, -122.438765125611) | |||
| 41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
| 41522 | 41522 | 180104 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999356.341630001 | 2089157.3690099998 | 37.7163911829698 | -122.444172290429 | (37.7163911829698, -122.444172290429) | |||
| 42007 | 42007 | 180098 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999719.616830001 | 2089501.32474 | 37.7173563255146 | -122.44294132361 | (37.7173563255146, -122.44294132361) | |||
| 42505 | 42505 | 180295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6001915.65954 | 2093123.81591 | 37.7274278322296 | -122.435609650978 | (37.7274278322296, -122.435609650978) | |||
| 42878 | 42878 | 180299 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001853.52362 | 2092985.7243400002 | 37.7270451347108 | -122.43581457857599 | (37.7270451347108, -122.435814578576) | |||
| 42890 | 42890 | 180042 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000946.28599 | 2090939.0206400002 | 37.72137377516479 | -122.438804275824 | (37.7213737751648, -122.438804275824) | |||
| 43112 | 43112 | 180044 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000922.20318 | 2090893.2066400002 | 37.721246610132106 | -122.438884241716 | (37.7212466101321, -122.438884241716) | |||
| 43357 | 43357 | 180061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000666.70399 | 2090425.0511 | 37.7199466212073 | -122.43973388071001 | (37.7199466212073, -122.43973388071) | |||
| 43625 | 43625 | 180079 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000270.676519999 | 2090025.31664 | 37.71882649133779 | -122.44107414397699 | (37.7188264913378, -122.441074143977) | |||
| 44736 | 44736 | 218728 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5995477.81623 | 2099995.17452 | 37.745927137623895 | -122.458362297293 | (37.7459271376239, -122.458362297293) | |||
| 45442 | 45442 | 180019 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001306.24608 | 2091632.60198 | 37.7232986651911 | -122.437609642494 | (37.7232986651911, -122.437609642494) | |||
| 45965 | 45965 | 180296 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6001890.92675 | 2093072.4710799998 | 37.7272854461671 | -122.435691480293 | (37.7272854461671, -122.435691480293) | |||
| 46429 | 46429 | 180266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003123.6487300005 | 2094209.53901 | 37.7304775213983 | -122.431511108549 | (37.7304775213983, -122.431511108549) | |||
| 46615 | 46615 | 180033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001110.15786 | 2091253.57403 | 37.722246789330896 | -122.43826034064699 | (37.7222467893309, -122.438260340647) | |||
| 46925 | 46925 | 180031 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001136.72316 | 2091302.93534 | 37.7223838352188 | -122.438172045228 | (37.7223838352188, -122.438172045228) | |||
| 47023 | 47023 | 180106 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999293.95899 | 2089098.2812 | 37.7162253821619 | -122.44438367066499 | (37.7162253821619, -122.444383670665) | |||
| 47880 | 47880 | 180029 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001164.3216699995 | 2091355.63442 | 37.722530104558295 | -122.438080416893 | (37.7225301045583, -122.438080416893) | |||
| 48488 | 48488 | 180305 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001711.8087 | 2092678.4747900001 | 37.7261934461482 | -122.436282504856 | (37.7261934461482, -122.436282504856) | |||
| 49739 | 49739 | 180292 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002054.37525 | 2093322.2219599998 | 37.7279804881067 | -122.435144295884 | (37.7279804881067, -122.435144295884) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");