Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10851 | 10851 | 52794 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 10944 | 10944 | 35742 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 10980 | 10980 | 52793 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 13065 | 13065 | 52792 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 14122 | 14122 | 35743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 128890 | 128890 | 83492 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2040 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50186 | 5981220.21812771 | 2101179.004699 | 37.748347964766396 | -122.50775007916 | (37.7483479647664, -122.50775007916) | ||
| 48473 | 48473 | 92109 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | |
| 46879 | 46879 | 52639 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1634 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2006 12:00:00 AM | 3 | Permit Number 48720 | 5981612.27437325 | 2103952.63979264 | 37.7559866741692 | -122.506600058306 | (37.7559866741692, -122.506600058306) | |
| 105121 | 105121 | 69026 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33030 | 5981605.36463184 | 2100817.40426398 | 37.7473777946481 | -122.506391463775 | (37.7473777946481, -122.506391463775) | ||
| 95536 | 95536 | 69021 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2095 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33025 | 5981665.37116425 | 2100840.03174895 | 37.747443456100704 | -122.506185646516 | (37.7474434561007, -122.506185646516) | ||
| 68181 | 68181 | 47745 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850953998 | (37.7810419369254, -122.50462850954) | |
| 63294 | 63294 | 47746 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982405.06542 | 2113061.4232400004 | 37.781043413721704 | -122.50453319829201 | (37.7810434137217, -122.504533198292) | |
| 27615 | 27615 | 47743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.78104415210971 | -122.50448647782 | (37.7810441521097, -122.50448647782) | |
| 161972 | 161972 | 47744 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982434.29257 | 2113064.02501 | 37.7810522765206 | -122.504432281557 | (37.7810522765206, -122.504432281557) | |
| 42735 | 42735 | 69006 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | |
| 36146 | 36146 | 69007 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | |
| 91660 | 91660 | 87934 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 98152 | 98152 | 87936 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 141514 | 141514 | 87935 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 32269 | 32269 | 69005 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2087 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33006 | 5982594.36064133 | 2100924.19223319 | 37.7477291823956 | -122.50297954562099 | (37.7477291823956, -122.502979545621) | |
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 86977 | 86977 | 122462 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 75380 | 75380 | 40197 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.50048820674401 | (37.7773644306872, -122.500488206744) | |
| 156274 | 156274 | 40198 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 4 | Permit Number 41381 | 5983564.00887 | 2111698.1064299997 | 37.7773682442298 | -122.500423071675 | (37.7773682442298, -122.500423071675) | |
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | |
| 58725 | 58725 | 82802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 108701 | 108701 | 72276 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 183050 | 183050 | 69147 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.50014569422399 | (37.7405848112735, -122.500145694224) | |
| 149292 | 149292 | 64781 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3801 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | Permit Number 25773 | 5983728.64713 | 2111021.26009 | 37.7755194830569 | -122.499803502734 | (37.7755194830569, -122.499803502734) | |
| 115944 | 115944 | 69045 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1490 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33052 | 5984059.2399452 | 2105030.87804217 | 37.7590909914126 | -122.498217402727 | (37.7590909914126, -122.498217402727) | |
| 118316 | 118316 | 69032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1306 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33038 | 5984326.99960905 | 2106268.60698724 | 37.76250514437871 | -122.49738275102699 | (37.7625051443787, -122.497382751027) | ||
| 171218 | 171218 | 69041 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1481 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 2 | Permit Number 33048 | 5984315.00463023 | 2105104.8689211 | 37.7593091431589 | -122.497338322577 | (37.7593091431589, -122.497338322577) | |
| 43449 | 43449 | 69150 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.49728998800501 | (37.7402963417492, -122.497289988005) | |
| 157979 | 157979 | 89252 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 433 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.4922700003 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | ||
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 176744 | 176744 | 32595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.49318190152901 | (37.7613297510328, -122.493181901529) | |
| 66939 | 66939 | 32596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1474 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.759613297357895 | -122.492881221287 | (37.7596132973579, -122.492881221287) | |
| 54735 | 54735 | 32597 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | |
| 29717 | 29717 | 32611 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | |
| 182568 | 182568 | 33177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) |
| 54592 | 54592 | 32576 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | |
| 172410 | 172410 | 69309 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1554 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 3 | Permit Number 33388 | 5986865.46516485 | 2104681.03924788 | 37.7582945739882 | -122.488486559119 | (37.7582945739882, -122.488486559119) | |
| 169430 | 169430 | 42275 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1522 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | ||
| 178425 | 178425 | 42274 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1522 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 5 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | |
| 188506 | 188506 | 84809 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 648 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | 3 | Permit No. 49264 | 5987557.75332 | 2111531.90689 | 37.7771455293989 | -122.486595377302 | (37.7771455293989, -122.486595377302) | ||
| 130691 | 130691 | 30907 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2363 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37373 | 5987310.298054401 | 2099201.63941585 | 37.743275562979605 | -122.486545838163 | (37.7432755629796, -122.486545838163) | |
| 102768 | 102768 | 88618 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1815 Taraval St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51591 | 5987609.0 | 2098941.0 | 37.7425773238376 | -122.485493894781 | (37.7425773238376, -122.485493894781) | ||
| 25175 | 25175 | 34531 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 635 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38240 | 5988437.8449 | 2111647.649 | 37.7775145896121 | -122.483559386935 | (37.7775145896121, -122.483559386935) | ||
| 147943 | 147943 | 95925 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 467 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767622 | 5988731.71404 | 2112146.6899 | 37.7789019165926 | -122.482579385158 | (37.7789019165926, -122.482579385158) |
| 143720 | 143720 | 42161 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2010 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42456 | 5989367.84309334 | 2111281.28093807 | 37.776562731283796 | -122.480315427669 | (37.7765627312838, -122.480315427669) | ||
| 55875 | 55875 | 61446 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2005 12:00:00 AM | 4 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | |
| 135718 | 135718 | 43234 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1442 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 0 | Permit Number 43021 | 5989629.54713999 | 2105535.31198119 | 37.760801073285705 | -122.478989743073 | (37.7608010732857, -122.478989743073) | |
| 66650 | 66650 | 38870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 2 | Permit Number 43029 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | |
| 159224 | 159224 | 38871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | 2 | Permit Number 40696 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | ||
| 82592 | 82592 | 38845 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.76288358166779 | -122.47823721882601 | (37.7628835816678, -122.478237218826) | ||
| 134013 | 134013 | 43231 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1371 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.47819025383801 | (37.7622050471688, -122.478190253838) | |
| 166292 | 166292 | 43230 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1371 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.47819025383801 | (37.7622050471688, -122.478190253838) | |
| 49623 | 49623 | 43808 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1420 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43438 | 5991181.63114 | 2110671.05879 | 37.77499245989021 | -122.473996541351 | (37.7749924598902, -122.473996541351) | |
| 99254 | 99254 | 38032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 102562 | 102562 | 38030 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 108435 | 108435 | 38031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 114634 | 114634 | 38033 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | ||
| 97169 | 97169 | 49152 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46274 | 5991742.04430079 | 2098660.96480908 | 37.7420483520093 | -122.47118277506901 | (37.7420483520093, -122.471182775069) | ||
| 89712 | 89712 | 47995 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 118955 | 118955 | 47994 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 78673 | 78673 | 40783 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 89337 | 89337 | 40785 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 96644 | 96644 | 40784 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 122873 | 122873 | 40786 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 141966 | 141966 | 69085 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33095 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | ||
| 90488 | 90488 | 57281 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | Permit Number 14578 | 5992015.46997478 | 2098642.50003897 | 37.7420134642029 | -122.470236020298 | (37.7420134642029, -122.470236020298) | ||
| 99110 | 99110 | 38000 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40212 | 5992064.31245936 | 2098735.51233127 | 37.742271675931896 | -122.47007391125601 | (37.7422716759319, -122.470073911256) | ||
| 106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 157585 | 157585 | 37646 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992418.62314 | 2111328.39102 | 37.7768688906569 | -122.46976542425399 | (37.7768688906569, -122.469765424254) | ||
| 73555 | 73555 | 37647 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | ||
| 54318 | 54318 | 37648 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.776868890669206 | -122.46971547615499 | (37.7768688906692, -122.469715476155) | ||
| 80857 | 80857 | 38028 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | |||
| 128574 | 128574 | 38029 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | ||
| 116845 | 116845 | 48626 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45923 | 5992496.87532412 | 2104233.57360814 | 37.757392932598 | -122.468978283216 | (37.757392932598, -122.468978283216) | ||
| 113357 | 113357 | 18570 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.005846401 | 2088553.4079402 | 37.7143316913291 | -122.46828327353701 | (37.7143316913291, -122.468283273537) | ||
| 48290 | 48290 | 67377 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.776979766827104 | -122.467939896695 | (37.7769797668271, -122.467939896695) | |
| 17788 | 17788 | 18608 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | ||
| 21649 | 21649 | 18607 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | ||
| 110717 | 110717 | 93721 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 143761 | 143761 | 93722 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 17486 | 17486 | 18596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.46642881780501 | (37.7141961040887, -122.466428817805) | ||
| 99913 | 99913 | 38034 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | ||
| 105407 | 105407 | 25463 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 3 | 3X3 | 5993157.11936 | 2088546.32287 | 37.714357782974204 | -122.46555529463001 | (37.7143577829742, -122.46555529463) | ||
| 109001 | 109001 | 55144 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1995 12:00:00 AM | Permit Number 11048 | 5993686.04342696 | 2105701.01392221 | 37.7614907777587 | -122.46497227391501 | (37.7614907777587, -122.464972273915) | ||
| 99237 | 99237 | 48566 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45985 | 5993535.88564574 | 2090091.48019383 | 37.7186222534444 | -122.464358255955 | (37.7186222534444, -122.464358255955) | ||
| 121149 | 121149 | 84942 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49348 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.46431934241699 | (37.7637090714706, -122.464319342417) | |||
| 19205 | 19205 | 17244 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | ||
| 126722 | 126722 | 34910 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | |||
| 17804 | 17804 | 26068 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | ||
| 18943 | 18943 | 26157 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 260 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5994051.6997 | 2088243.7899 | 37.713578655736 | -122.462441364614 | (37.713578655736, -122.462441364614) | ||
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 34675 | 34675 | 31971 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | |
| 29132 | 29132 | 31972 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248530995 | -122.46029586964701 | (37.786521248531, -122.460295869647) | |
| 54142 | 54142 | 38882 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) |
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");