Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129794 | 129794 | 123883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992072.431890001 | 2114857.09467 | 37.7865377268901 | -122.471220147048 | (37.7865377268901, -122.471220147048) | |||
| 172853 | 172853 | 123882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992074.12323 | 2114872.38939 | 37.7865798197895 | -122.47121541022601 | (37.7865798197895, -122.471215410226) | |||
| 175777 | 175777 | 68446 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32303 | 5992072.75481 | 2114889.3953400003 | 37.7866264342674 | -122.47122138404801 | (37.7866264342674, -122.471221384048) | ||
| 136729 | 136729 | 136918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001921.35919 | 2120601.2758299997 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | |||
| 103263 | 103263 | 30665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 142462 | 142462 | 30666 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 13358 | 13358 | 79034 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2002 12:00:00 AM | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.40847122506399 | (37.7780689795412, -122.408471225064) | ||
| 79555 | 79555 | 36268 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 101773 | 101773 | 36269 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 114099 | 114099 | 36271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 119787 | 119787 | 36270 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 160244 | 160244 | 201659 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009071.000519999 | 2109601.78003 | 37.7730764624533 | -122.41203753431299 | (37.7730764624533, -122.412037534313) | |||
| 176463 | 176463 | 201658 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009046.738390001 | 2109625.79413 | 37.773141038252604 | -122.412123157881 | (37.7731410382526, -122.412123157881) | |||
| 173810 | 173810 | 75766 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009894.26848 | 2094011.0737400001 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | ||
| 54906 | 54906 | 249573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006042.707780001 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | |||
| 104103 | 104103 | 7871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6006017.92474 | 2113680.1220400003 | 37.7841028269903 | -122.42288843164101 | (37.7841028269903, -122.422888431641) | ||
| 169666 | 169666 | 219436 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990892.67595 | 2102441.87183 | 37.752380574612204 | -122.474395438619 | (37.7523805746122, -122.474395438619) | |||
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 112704 | 112704 | 50819 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1009 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47342 | 6010039.41742764 | 2112370.40849241 | 37.780732755109604 | -122.40888301650601 | (37.7807327551096, -122.408883016506) | |||
| 164105 | 164105 | 50820 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1009 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | Permit Number 47342 | 6010026.22608 | 2112350.59085 | 37.7806776016324 | -122.408927253305 | (37.7806776016324, -122.408927253305) | ||
| 99288 | 99288 | 90134 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995229.54942 | 2111496.31673 | 37.7774920413779 | -122.460053813186 | (37.7774920413779, -122.460053813186) | ||
| 64598 | 64598 | 123720 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | Width 3ft | 5995264.25203 | 2111440.07761 | 37.7773396195467 | -122.459929691175 | (37.7773396195467, -122.459929691175) | ||
| 89034 | 89034 | 90380 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995315.581431 | 2111451.352271 | 37.7773735286818 | -122.459752944165 | (37.7773735286818, -122.459752944165) | ||
| 130711 | 130711 | 75004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | ||
| 154342 | 154342 | 136919 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5997971.7056 | 2116051.1115099997 | 37.790155644821 | -122.450896340588 | (37.790155644821, -122.450896340588) | |||
| 24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
| 31590 | 31590 | 198270 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014327.719219999 | 2106393.16587 | 37.764559852075 | -122.39362912521099 | (37.764559852075, -122.393629125211) | ||||
| 51615 | 51615 | 198272 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014300.74273 | 2106595.72792 | 37.765114544025295 | -122.393736609482 | (37.7651145440253, -122.393736609482) | ||||
| 65756 | 65756 | 198271 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | ||||
| 32694 | 32694 | 104489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101X Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012893.40207 | 2106545.4722700003 | 37.7648982471715 | -122.398600762736 | (37.7648982471715, -122.398600762736) | |||
| 63498 | 63498 | 136937 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1020 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009944.47498 | 2116838.4179700003 | 37.792995521282 | -122.409526902355 | (37.792995521282, -122.409526902355) | |||
| 133474 | 133474 | 59489 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1029 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51129 | 6011954.00169 | 2103318.43549 | 37.75598513922839 | -122.401623098137 | (37.7559851392284, -122.401623098137) | |
| 77909 | 77909 | 41779 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.79458848646429 | -122.410304149551 | (37.7945884864643, -122.410304149551) | ||
| 93527 | 93527 | 41780 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.79458848646429 | -122.410304149551 | (37.7945884864643, -122.410304149551) | ||
| 176191 | 176191 | 242339 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.6727 | 2100671.2124799998 | 37.748118662255294 | -122.438130887736 | (37.7481186622553, -122.438130887736) | |||
| 136548 | 136548 | 53053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1042 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2006 12:00:00 AM | 5 | 3x3 | Permit Number 49030 | 6015494.75997 | 2104280.44649 | 37.7588235587865 | -122.38944505814501 | (37.7588235587865, -122.389445058145) | |
| 22422 | 22422 | 7875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.9909599996 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | ||
| 58664 | 58664 | 242887 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | |||
| 40310 | 40310 | 242898 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.25969 | 2103043.9270599997 | 37.755120337650105 | -122.408474577742 | (37.7551203376501, -122.408474577742) | |||
| 56748 | 56748 | 242899 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.68817 | 2103026.2265 | 37.7550717598627 | -122.408471847423 | (37.7550717598627, -122.408471847423) | |||
| 147392 | 147392 | 242900 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.375580001 | 2103010.90025 | 37.7550296598983 | -122.408471847422 | (37.7550296598983, -122.408471847422) | |||
| 21230 | 21230 | 28488 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.0400099996 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | ||
| 118685 | 118685 | 47248 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1060 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2011 12:00:00 AM | Permit Number 767222 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 111580 | 111580 | 51380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1061 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.40695965967501 | (37.7773423979358, -122.406959659675) | ||
| 138968 | 138968 | 51379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1061 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.40695965967501 | (37.7773423979358, -122.406959659675) | ||
| 40939 | 40939 | 198418 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013212.31335 | 2089895.25282 | 37.7191980120665 | -122.396330620284 | (37.7191980120665, -122.396330620284) | |||
| 180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
| 186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
| 20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
| 49855 | 49855 | 242329 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005095.8624599995 | 2099583.89393 | 37.745345873425705 | -122.42507512473699 | (37.7453458734257, -122.425075124737) | |||
| 177030 | 177030 | 124216 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.45575789701401 | (37.7796587851836, -122.455757897014) | |||
| 94498 | 94498 | 90379 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995291.794305 | 2111450.466195 | 37.7773697278094 | -122.459835166842 | (37.7773697278094, -122.459835166842) | ||
| 128337 | 128337 | 90378 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995235.890819999 | 2111438.83153 | 37.777334567000295 | -122.460027710853 | (37.7773345670003, -122.460027710853) | ||
| 91430 | 91430 | 51896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
| 102622 | 102622 | 51895 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
| 86022 | 86022 | 17243 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | ||
| 143729 | 143729 | 45539 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 11 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44294 | 5987258.11223173 | 2095792.07894073 | 37.7339107660531 | -122.48647600029699 | (37.7339107660531, -122.486476000297) | ||
| 166295 | 166295 | 242330 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005175.96727 | 2099631.57497 | 37.745481319400795 | -122.424801526695 | (37.7454813194008, -122.424801526695) | |||
| 35758 | 35758 | 242888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005717.8738400005 | 2102519.39452 | 37.753441201753205 | -122.423132926343 | (37.7534412017532, -122.423132926343) | |||
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 76907 | 76907 | 180414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.73110669070989 | -122.42933162228 | (37.7311066907099, -122.42933162228) | |||
| 180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
| 183887 | 183887 | 180412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.42914021505501 | (37.7311646556118, -122.429140215055) | |||
| 97962 | 97962 | 87717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1107 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5996451.82773 | 2091748.4966099998 | 37.7233396801105 | -122.45439871889799 | (37.7233396801105, -122.454398718898) | |||
| 58391 | 58391 | 182082 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386001 | (37.7428517447762, -122.47810825386) | ||
| 92825 | 92825 | 25288 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.43905734896299 | (37.7236715433472, -122.439057348963) | ||
| 62677 | 62677 | 50483 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2003 12:00:00 AM | 5 | Permit Number 47118 | 5987691.11202 | 2115193.54019 | 37.787207107765 | -122.48640295005501 | (37.787207107765, -122.486402950055) | ||
| 133181 | 133181 | 242915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005066.82423 | 2099579.80768 | 37.7453330131246 | -122.425175243547 | (37.7453330131246, -122.425175243547) | |||
| 45566 | 45566 | 123719 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995199.7628 | 2111434.37432 | 37.777320250731705 | -122.460152365551 | (37.7773202507317, -122.460152365551) | |||
| 83744 | 83744 | 94664 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53801 | 6004018.0 | 2095241.0 | 37.7333603312135 | -122.428492699505 | (37.7333603312135, -122.428492699505) | |
| 127224 | 127224 | 475 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1110X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 06:40:00 PM | 3 | 3x3 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.42313807467801 | (37.753364362762, -122.423138074678) | ||
| 91118 | 91118 | 81458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49734 | 5989787.55086775 | 2099004.4958045 | 37.742878352926795 | -122.47796582741002 | (37.7428783529268, -122.47796582741) | ||
| 28936 | 28936 | 49804 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.39399522840799 | (37.7628013312333, -122.393995228408) | |
| 114649 | 114649 | 42200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
| 120533 | 120533 | 42199 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
| 121461 | 121461 | 42201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
| 67427 | 67427 | 31660 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1120 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 11 | Permit Number 35168 | 6009328.60385 | 2117080.0959 | 37.7936245817471 | -122.411674942066 | (37.7936245817471, -122.411674942066) | ||
| 18648 | 18648 | 10186 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.753006821117296 | -122.423101549889 | (37.7530068211173, -122.423101549889) | ||
| 38671 | 38671 | 180422 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003342.53075 | 2094283.93013 | 37.7306941860739 | -122.43075970881901 | (37.7306941860739, -122.430759708819) | |||
| 51014 | 51014 | 180421 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003365.77706 | 2094291.48085 | 37.7307162356701 | -122.430679881378 | (37.7307162356701, -122.430679881378) | |||
| 57854 | 57854 | 180417 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003506.26836 | 2094339.1696799998 | 37.730855136838606 | -122.430197582161 | (37.7308551368386, -122.430197582161) | |||
| 64285 | 64285 | 180415 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003554.97456 | 2094355.58631 | 37.7309029717957 | -122.43003036762899 | (37.7309029717957, -122.430030367629) | |||
| 66122 | 66122 | 180418 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003475.18041 | 2094328.74311 | 37.73082474696329 | -122.430304314596 | (37.7308247469633, -122.430304314596) | |||
| 116442 | 116442 | 180419 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003443.67237 | 2094317.91582 | 37.7307932329079 | -122.43041247068001 | (37.7307932329079, -122.43041247068) | |||
| 135967 | 135967 | 180423 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003317.211680001 | 2094273.79477 | 37.7306649221452 | -122.430846517675 | (37.7306649221452, -122.430846517675) | |||
| 151084 | 151084 | 180420 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003421.2672 | 2094309.3598599997 | 37.7307684709799 | -122.430489318632 | (37.7307684709799, -122.430489318632) | |||
| 166485 | 166485 | 180416 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003534.67772 | 2094349.44618 | 37.730884962851896 | -122.430100099258 | (37.7308849628519, -122.430100099258) | |||
| 11646 | 11646 | 27701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2000 12:00:00 AM | 6 | 6008329.0437900005 | 2093834.9235 | 37.729742566663106 | -122.413488762206 | (37.7297425666631, -122.413488762206) | |||
| 42392 | 42392 | 180477 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008049.06665 | 2092073.68164 | 37.724890849229 | -122.41433210953899 | (37.724890849229, -122.414332109539) | |||
| 159712 | 159712 | 180474 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008093.7443 | 2092086.4118 | 37.724928313173706 | -122.414178563806 | (37.7249283131737, -122.414178563806) | |||
| 179785 | 179785 | 180475 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008076.47647 | 2092081.3673900003 | 37.724913492352 | -122.414237900184 | (37.724913492352, -122.414237900184) | |||
| 187971 | 187971 | 180476 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008061.923909999 | 2092076.5671299999 | 37.724899494409705 | -122.41428786739999 | (37.7248994944097, -122.4142878674) | |||
| 18209 | 18209 | 10188 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1148 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/05/2016 12:00:00 AM | 3 | 2x4 | 6005734.612380001 | 2102244.83146 | 37.75268825965679 | -122.423055527089 | (37.7526882596568, -122.423055527089) | ||
| 39535 | 39535 | 136939 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1149 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008985.04879 | 2116923.16762 | 37.7931744171228 | -122.412852575501 | (37.7931744171228, -122.412852575501) | |||
| 105379 | 105379 | 33347 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 115 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53998 | 5994561.49853007 | 2093647.4167141998 | 37.728445063974796 | -122.461070757188 | (37.7284450639748, -122.461070757188) | |
| 108794 | 108794 | 28590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) |
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");