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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183009 | 183009 | 52766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48808 | 6010071.7871900005 | 2117939.89762 | 37.7960270495675 | -122.409164153622 | (37.7960270495675, -122.409164153622) | ||
93514 | 93514 | 85000 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
103100 | 103100 | 85005 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
108541 | 108541 | 85003 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
108757 | 108757 | 85001 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
114225 | 114225 | 85004 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
116656 | 116656 | 84999 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
121996 | 121996 | 85002 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
5982 | 5982 | 39271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999943.4858099995 | 2117805.21945 | 37.7950846436855 | -122.444200258451 | (37.7950846436855, -122.444200258451) | ||
5769 | 5769 | 39272 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999918.5789 | 2117802.13868 | 37.7950747637355 | -122.44428621834999 | (37.7950747637355, -122.44428621835) | ||
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) | ||
185690 | 185690 | 136955 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Grant Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010930.30149 | 2117074.44992 | 37.793698797424796 | -122.406132508429 | (37.7936987974248, -122.406132508429) | |||
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) | ||
33823 | 33823 | 136938 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1277 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.97542 | 2116946.31505 | 37.7932169703383 | -122.41414853544201 | (37.7932169703383, -122.414148535442) | |||
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) | |||
157353 | 157353 | 136943 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1771 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006301.75363 | 2116945.84778 | 37.7930857115761 | -122.42213857116 | (37.7930857115761, -122.42213857116) | |||
179035 | 179035 | 136942 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1771 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006278.23872 | 2116942.55045 | 37.793075331599496 | -122.42221969987699 | (37.7930753315995, -122.422219699877) | |||
185956 | 185956 | 33282 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37445 | 6008545.83527 | 2116894.20233 | 37.793070222573 | -122.41437023629601 | (37.793070222573, -122.414370236296) | |
43937 | 43937 | 33280 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37445 | 6008548.04554 | 2116881.1658799998 | 37.7930345518418 | -122.414361665778 | (37.7930345518418, -122.414361665778) | |
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) | |||
48325 | 48325 | 136956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012358.49357 | 2116085.98474 | 37.7910644861899 | -122.401121320516 | (37.7910644861899, -122.401121320516) | |||
179406 | 179406 | 136936 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009249.138119999 | 2116000.66803 | 37.790656277621004 | -122.411873588818 | (37.790656277621, -122.411873588818) | |||
25717 | 25717 | 53974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 4 | Permit Number 9690 | 6009227.8600699995 | 2115996.16493 | 37.790642719446204 | -122.41194689162901 | (37.7906427194462, -122.411946891629) | |
9823 | 9823 | 63407 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.3402400003 | 37.790357690994504 | -122.442690122255 | (37.7903576909945, -122.442690122255) | |
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) | ||
25281 | 25281 | 115053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1280 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 773966 | 6007807.56108 | 2115848.6869799998 | 37.790157994733704 | -122.41685060786699 | (37.7901579947337, -122.416850607867) | ||
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) | |||
147120 | 147120 | 136940 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1346 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007479.452769999 | 2115804.0792400003 | 37.7900170520819 | -122.417982676281 | (37.7900170520819, -122.417982676281) | |||
134228 | 134228 | 136941 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1346 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007472.04375 | 2115803.24983 | 37.7900143577375 | -122.41800825210501 | (37.7900143577375, -122.418008252105) | |||
151354 | 151354 | 136935 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 935 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007697.83158 | 2115657.05879 | 37.7896256581417 | -122.417216679615 | (37.7896256581417, -122.417216679615) | |||
38984 | 38984 | 82050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50668 | 5996119.951719999 | 2115777.79007 | 37.78929899740071 | -122.457283443584 | (37.7892989974007, -122.457283443584) | |
28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
118574 | 118574 | 51928 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3004 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2006 12:00:00 AM | Permit Number 48129 | 6000409.40252895 | 2115520.08466126 | 37.7888368315168 | -122.44242398406 | (37.7888368315168, -122.44242398406) | |||
32574 | 32574 | 52874 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3476@ LAUREL Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2006 12:00:00 AM | 4 | Permit Number 48886 | 5998188.79133 | 2115538.04458 | 37.7887593241423 | -122.45010824850701 | (37.7887593241423, -122.450108248507) | ||
89541 | 89541 | 85045 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2051 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49390 | 6001416.0 | 2115465.0 | 37.7887429058152 | -122.43893735552 | (37.7887429058152, -122.43893735552) | |||
111201 | 111201 | 85046 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2051 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49390 | 6001416.0 | 2115465.0 | 37.7887429058152 | -122.43893735552 | (37.7887429058152, -122.43893735552) | |||
141871 | 141871 | 84922 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2051 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2007 12:00:00 AM | Permit Number 49340 | 6001416.0 | 2115465.0 | 37.7887429058152 | -122.43893735552 | (37.7887429058152, -122.43893735552) | |||
183248 | 183248 | 136920 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996591.90102 | 2115549.28793 | 37.788698686447894 | -122.45563404108499 | (37.7886986864479, -122.455634041085) | |||
8919 | 8919 | 49958 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 REVISED Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
79457 | 79457 | 31951 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
121961 | 121961 | 31952 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
89527 | 89527 | 12448 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1989X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/2006 12:00:00 AM | 3 | 3X3 | 6004432.626396201 | 2115327.1853143997 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | ||
3809 | 3809 | 95203 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | Permit Number 769992 | 5998598.6333800005 | 2115400.1597599997 | 37.7884041728517 | -122.44868032474 | (37.7884041728517, -122.44868032474) | ||
125580 | 125580 | 109829 | Private 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | |||
135056 | 135056 | 79729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3739 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50670 | 5996913.4675199995 | 2115314.2216 | 37.7880717051817 | -122.45450448628799 | (37.7880717051817, -122.454504486288) | |
6520 | 6520 | 121576 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3553-3555 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5997856.717119999 | 2115116.32362 | 37.787582382260396 | -122.451226746117 | (37.7875823822604, -122.451226746117) | |||
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) | ||
55227 | 55227 | 92817 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997687.50186 | 2114976.0364200003 | 37.787187500742 | -122.45180207032499 | (37.787187500742, -122.451802070325) | |
121952 | 121952 | 81838 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50027 | 6007847.58999161 | 2114760.86418186 | 37.787173350858296 | -122.41663501680901 | (37.7871733508583, -122.416635016809) | ||
167210 | 167210 | 100856 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 769158 | 5993666.6182699995 | 2115051.6302900002 | 37.7871639517517 | -122.46571883909701 | (37.7871639517517, -122.465718839097) | ||
71414 | 71414 | 41629 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 433 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51282 | 5997644.2427199995 | 2114968.05541 | 37.78716310932511 | -122.45195116082701 | (37.7871631093251, -122.451951160827) | |
31127 | 31127 | 92816 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997688.97866 | 2114964.50163 | 37.787155913848 | -122.451796128513 | (37.787155913848, -122.451796128513) | |
92244 | 92244 | 12608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993288.45121 | 2114872.37286 | 37.786649939560796 | -122.46701416661199 | (37.7866499395608, -122.467014166612) | |||
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) | ||
176029 | 176029 | 198305 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012839.768519999 | 2114446.84253 | 37.786590622517096 | -122.39934099648501 | (37.7865906225171, -122.399340996485) | |||
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) | |||
180922 | 180922 | 198304 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012859.7617 | 2114427.83429 | 37.7865395445998 | -122.39927048966801 | (37.7865395445998, -122.399270489668) | |||
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) | |||
177790 | 177790 | 36989 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39610 | 5993273.5401 | 2114815.16246 | 37.7864919948194 | -122.46706159406999 | (37.7864919948194, -122.46706159407) | |
125579 | 125579 | 1467 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995559.29766 | 2114744.3111900003 | 37.786429126950104 | -122.45914836167401 | (37.7864291269501, -122.459148361674) | |||
46044 | 46044 | 120186 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 172 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987746.67951 | 2114854.71533 | 37.7862800304413 | -122.48618581827 | (37.7862800304413, -122.48618581827) | |||
130307 | 130307 | 36947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 121 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | 6x9 | Permit Number 39582 | 5994567.08556 | 2114703.52353 | 37.78626004419979 | -122.46257818064801 | (37.7862600441998, -122.462578180648) | |
110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
128148 | 128148 | 12774 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989637.59951 | 2114741.75598 | 37.7860799008728 | -122.479635529609 | (37.7860799008728, -122.479635529609) | ||
128791 | 128791 | 12775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989652.1071 | 2114741.09637 | 37.786078932501 | -122.47958528952 | (37.786078932501, -122.47958528952) | ||
78031 | 78031 | 12721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1535 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5990655.40582 | 2114718.61196 | 37.7860754253896 | -122.476112538286 | (37.7860754253896, -122.476112538286) | ||
118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
128353 | 128353 | 432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 30 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
108155 | 108155 | 12781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1914 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1997 12:00:00 AM | 40 | 3X3 | 5989486.1909300005 | 2114733.67338 | 37.786048911885096 | -122.48015876501101 | (37.7860489118851, -122.480158765011) | ||
171454 | 171454 | 120759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989240.60328 | 2114727.2324 | 37.786016953821004 | -122.481007950527 | (37.786016953821, -122.481007950527) | |||
159263 | 159263 | 120760 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989219.70066 | 2114726.96958 | 37.7860150171 | -122.481080247842 | (37.7860150171, -122.481080247842) | |||
70304 | 70304 | 120354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988430.28754 | 2114697.53592 | 37.7858882787477 | -122.483809211099 | (37.7858882787477, -122.483809211099) | |||
67039 | 67039 | 120355 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988402.72558 | 2114696.23379 | 37.78588309898829 | -122.48390447116999 | (37.7858830989883, -122.48390447117) | |||
171220 | 171220 | 198312 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 81 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014325.56305 | 2114147.83058 | 37.7858523015842 | -122.394179529164 | (37.7858523015842, -122.394179529164) | |||
37498 | 37498 | 198311 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014300.67476 | 2114126.83927 | 37.7857932808859 | -122.394264166169 | (37.7857932808859, -122.394264166169) | |||
98139 | 98139 | 64711 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2609 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775401 | 5987378.59458857 | 2114604.15746818 | 37.7855706107791 | -122.48744086841299 | (37.7855706107791, -122.487440868413) | |||
163390 | 163390 | 198310 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 299 Bryant St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015446.63596 | 2114020.379 | 37.7855645967725 | -122.390291988402 | (37.7855645967725, -122.390291988402) | |||
120956 | 120956 | 36978 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 154 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776042 | 5993376.985780001 | 2114464.02156 | 37.785533828452394 | -122.466678167054 | (37.7855338284524, -122.466678167054) | |
159205 | 159205 | 198306 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 502 Beale St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6015908.341130001 | 2113925.9394400003 | 37.78533088635999 | -122.38868801426202 | (37.78533088636, -122.388688014262) | |||
76896 | 76896 | 123612 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 195 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994884.90954 | 2114300.75291 | 37.7851724431019 | -122.461449389986 | (37.7851724431019, -122.461449389986) | |||
137904 | 137904 | 35593 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 168 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1999 12:00:00 AM | 7 | Permit Number 41773 | 5990252.30789 | 2114278.94729 | 37.784844846933105 | -122.47747498791901 | (37.7848448469331, -122.477474987919) | ||
98632 | 98632 | 114614 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2400X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773266 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||
99754 | 99754 | 114624 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2400X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773266 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||
124534 | 124534 | 113994 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2400X POST ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 773266 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||
132456 | 132456 | 198307 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015819.881580001 | 2113595.44766 | 37.784418527738204 | -122.388970977841 | (37.7844185277382, -122.388970977841) | |||
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) | ||
74713 | 74713 | 198308 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015701.627180001 | 2113485.85575 | 37.7841110576194 | -122.389372445082 | (37.7841110576194, -122.389372445082) | |||
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) | ||
162847 | 162847 | 198309 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015688.10696 | 2113472.66106 | 37.7840740783932 | -122.389418298834 | (37.7840740783932, -122.389418298834) | |||
169667 | 169667 | 198381 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011515.1376 | 2113488.48882 | 37.78388529271079 | -122.403856459201 | (37.7838852927108, -122.403856459201) | |||
161806 | 161806 | 198380 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011497.44668 | 2113474.8432400003 | 37.7838468368044 | -122.403916703013 | (37.7838468368044, -122.403916703013) | |||
152803 | 152803 | 198382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011448.39911 | 2113467.1712 | 37.7838230308611 | -122.404085850185 | (37.7838230308611, -122.404085850185) | |||
96104 | 96104 | 81837 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768975 | 6006713.98460137 | 2113562.35080559 | 37.7838187064507 | -122.42047194804199 | (37.7838187064507, -122.420471948042) |
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) | |||
181380 | 181380 | 198379 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011483.05552 | 2113458.79622 | 37.783801971433 | -122.403965361713 | (37.783801971433, -122.403965361713) | |||
45489 | 45489 | 198383 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011433.08529 | 2113455.1444200003 | 37.783789152501996 | -122.404137983874 | (37.783789152502, -122.404137983874) | |||
115957 | 115957 | 198378 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011469.09396 | 2113447.40875 | 37.783769924074605 | -122.40401286211001 | (37.7837699240746, -122.40401286211) | |||
152817 | 152817 | 198384 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011417.757619999 | 2113442.45107 | 37.783753443101 | -122.404190118502 | (37.783753443101, -122.404190118502) | |||
31158 | 31158 | 198377 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011450.02335 | 2113431.79039 | 37.7837259742093 | -122.404077740098 | (37.7837259742093, -122.404077740098) |
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");