Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164458 | 164458 | 81965 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 838 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49958 | 5985125.36626 | 2110132.785 | 37.773161846833204 | -122.494906462717 | (37.7731618468332, -122.494906462717) | |
132731 | 132731 | 118170 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3247 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5985457.87188 | 2111086.97623 | 37.77580124268229 | -122.49382662937599 | (37.7758012426823, -122.493826629376) | |||
41342 | 41342 | 118172 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3239 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5985496.239630001 | 2111086.82124 | 37.7758030618006 | -122.493693896102 | (37.7758030618006, -122.493693896102) | |||
152744 | 152744 | 87311 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 428 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50317 | 5987813.7000400005 | 2113048.96983 | 37.78132587294579 | -122.485821362783 | (37.7813258729458, -122.485821362783) | |
53744 | 53744 | 43786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 354 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43416 | 5989368.92132 | 2112957.36095 | 37.78116484258071 | -122.48043441215599 | (37.7811648425807, -122.480434412156) | |
76495 | 76495 | 52910 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 618 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 4 | Permit Number 48899 | 5990984.29522 | 2111166.9294 | 37.776342552381 | -122.47471536155399 | (37.776342552381, -122.474715361554) | ||
174809 | 174809 | 87744 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50407 | 5991510.9699800005 | 2113358.15112 | 37.7823895504384 | -122.47305329682399 | (37.7823895504384, -122.473053296824) | |
176265 | 176265 | 123810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2001 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992451.93386 | 2112017.5162 | 37.77876296659429 | -122.469700374559 | (37.7787629665943, -122.469700374559) | |||
163442 | 163442 | 123816 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1951 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992563.59234 | 2112023.8382599996 | 37.778786778293 | -122.469314567921 | (37.778786778293, -122.469314567921) | |||
161843 | 161843 | 52455 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48566 | 5992596.93064 | 2110303.01931 | 37.7740638014341 | -122.469073967639 | (37.7740638014341, -122.469073967639) |
41404 | 41404 | 219433 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1650 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992497.08192 | 2104245.61626 | 37.757426010509995 | -122.46897844511001 | (37.75742601051, -122.46897844511) | |||
181939 | 181939 | 82808 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 637 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 4 | 5992833.07706 | 2111118.80762 | 37.776317378073294 | -122.468316464164 | (37.7763173780733, -122.468316464164) | ||
38368 | 38368 | 124531 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 821 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993023.60492 | 2111359.71361 | 37.776989843561 | -122.46767490536301 | (37.776989843561, -122.467674905363) | |||
31240 | 31240 | 53102 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 429@ GEARY BL 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 4 | Permit Number 49065 | 5994018.99484 | 2112572.39265 | 37.7803769568855 | -122.46431963578999 | (37.7803769568855, -122.46431963579) | ||
29033 | 29033 | 123711 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 437 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994213.82065 | 2111401.8338099997 | 37.777174144242295 | -122.46356067075199 | (37.7771741442423, -122.463560670752) | |||
169140 | 169140 | 123713 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 351 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994491.09605 | 2111413.1919400003 | 37.7772213028451 | -122.46260231839399 | (37.7772213028451, -122.462602318394) | |||
30819 | 30819 | 123714 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994520.39053 | 2111414.8777 | 37.7772276185203 | -122.462501102485 | (37.7772276185203, -122.462501102485) | |||
63468 | 63468 | 123701 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 332 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994538.935269999 | 2111469.38772 | 37.7773783564116 | -122.462440905509 | (37.7773783564116, -122.462440905509) | |||
161872 | 161872 | 123700 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5994582.57052 | 2111471.99981 | 37.7773880411684 | -122.462290147524 | (37.7773880411684, -122.462290147524) | |||
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) | |||
23242 | 23242 | 1673 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5994963.861330001 | 2111486.70203 | 37.7774503572538 | -122.460972213003 | (37.7774503572538, -122.460972213003) | ||||
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) | |
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) | |||
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) | ||
158976 | 158976 | 136924 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999084.005580001 | 2119171.9569 | 37.7987882686341 | -122.44727259345301 | (37.7987882686341, -122.447272593453) | |||
184889 | 184889 | 136921 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999088.66759 | 2119114.7453799997 | 37.798631447529296 | -122.447252341645 | (37.7986314475293, -122.447252341645) | |||
156734 | 156734 | 93732 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 29 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53317 | 6001786.6027 | 2120087.22199 | 37.80145540150679 | -122.4379863442 | (37.8014554015068, -122.4379863442) | |
131061 | 131061 | 47491 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 158 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54057 | 6002965.4626 | 2094356.7094599998 | 37.7308726511421 | -122.432068485897 | (37.7308726511421, -122.432068485897) |
157683 | 157683 | 242909 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004814.05925 | 2110039.42445 | 37.7740383656155 | -122.426794013354 | (37.7740383656155, -122.426794013354) | |||
36920 | 36920 | 242908 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004832.66793 | 2110043.51339 | 37.7740506449575 | -122.426729933953 | (37.7740506449575, -122.426729933953) | |||
26512 | 26512 | 242907 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004859.69332 | 2110047.4287099997 | 37.774062923387795 | -122.426636727297 | (37.7740629233878, -122.426636727297) | |||
68773 | 68773 | 86912 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1555 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49877 | 6005411.55149 | 2119563.27815 | 37.800222261013495 | -122.42540507790501 | (37.8002222610135, -122.425405077905) | |
60666 | 60666 | 55294 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1539 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50106 | 6005486.07569 | 2119573.98699 | 37.80025587497521 | -122.425147957212 | (37.8002558749752, -122.425147957212) | |
130025 | 130025 | 86962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49931 | 6005583.80887 | 2119587.99899 | 37.8002998689051 | -122.424810759115 | (37.8002998689051, -122.424810759115) | |
117662 | 117662 | 70482 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 935 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6005101.627719999 | 2092066.92628 | 37.724706289440796 | -122.424520594648 | (37.7247062894408, -122.424520594648) | ||
178463 | 178463 | 180481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006648.24151 | 2092609.1110599998 | 37.7262822326299 | -122.41921257380599 | (37.7262822326299, -122.419212573806) | |||
60514 | 60514 | 180480 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006662.46331 | 2092612.5102799998 | 37.7262923670781 | -122.41916365067499 | (37.7262923670781, -122.419163650675) | |||
56591 | 56591 | 180479 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006678.58577 | 2092618.2192400002 | 37.726308950586706 | -122.419108320791 | (37.7263089505867, -122.419108320791) | |||
162190 | 162190 | 180478 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006697.10383 | 2092625.7247 | 37.7263306017719 | -122.419044836761 | (37.7263306017719, -122.419044836761) | |||
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) | |
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) | |||
176102 | 176102 | 180470 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008144.58637 | 2092721.9532599999 | 37.7266762301091 | -122.414047748408 | (37.7266762301091, -122.414047748408) | |||
163520 | 163520 | 180466 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.76877 | 2092582.87899 | 37.7262966748277 | -122.41389554805299 | (37.7262966748277, -122.413895548053) | |||
59746 | 59746 | 43181 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42986 | 6008214.10647 | 2092327.8769599998 | 37.7255980850788 | -122.413779556209 | (37.7255980850788, -122.413779556209) | |
180617 | 180617 | 180455 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008364.39889 | 2091998.61159 | 37.7247024313603 | -122.413236732598 | (37.7247024313603, -122.413236732598) | |||
181510 | 181510 | 180447 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008436.67038 | 2091759.83513 | 37.7240508590526 | -122.412970023366 | (37.7240508590526, -122.412970023366) | |||
184169 | 184169 | 180446 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008445.91914 | 2091731.3401099998 | 37.723973136934205 | -122.412936037975 | (37.7239731369342, -122.412936037975) | |||
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) | |||
165981 | 165981 | 180444 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008492.89984 | 2091583.10453 | 37.7235687504822 | -122.412763157689 | (37.7235687504822, -122.412763157689) | |||
29241 | 29241 | 180442 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008511.7814 | 2091523.97842 | 37.723407462461296 | -122.412693709355 | (37.7234074624613, -122.412693709355) | |||
136447 | 136447 | 180441 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008527.9291900005 | 2091467.03616 | 37.7232520173547 | -122.412633865781 | (37.7232520173547, -122.412633865781) | |||
39624 | 39624 | 180440 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008537.64455 | 2091440.44703 | 37.72317955448779 | -122.41259840282 | (37.7231795544878, -122.41259840282) | |||
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) | |
133434 | 133434 | 242896 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2240 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009613.5702599995 | 2104303.49439 | 37.758559012408206 | -122.40978664815901 | (37.7585590124082, -122.409786648159) | |||
175743 | 175743 | 52767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | 1x2 | Permit Number 48809 | 6010066.728209999 | 2117984.84058 | 37.7961501685616 | -122.409184831728 | (37.7961501685616, -122.409184831728) | |
169983 | 169983 | 52768 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125@ JACKSON Trenton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48809 | 6010068.15327 | 2117966.12844 | 37.796098869423496 | -122.40917857963801 | (37.7960988694235, -122.409178579638) | ||
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) | ||
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) | ||
37242 | 37242 | 87382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Moss St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50362 | 6010348.37894 | 2111212.00043 | 37.777569339594706 | -122.407732459893 | (37.7775693395947, -122.407732459893) | |
42576 | 42576 | 87381 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Moss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50362 | 6010358.28806 | 2111201.31022 | 37.777540541486395 | -122.407697426806 | (37.7775405414864, -122.407697426806) | |
27696 | 27696 | 87380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Moss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50362 | 6010380.07388 | 2111177.06608 | 37.777475192271396 | -122.407620352208 | (37.7774751922714, -122.407620352208) | |
61338 | 61338 | 87379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50362 | 6010391.21021 | 2111166.9561400004 | 37.77744805610921 | -122.407581114788 | (37.7774480561092, -122.407581114788) | |
150716 | 150716 | 198398 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 30 Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010416.951230001 | 2111773.66634 | 37.7791153812045 | -122.407534853654 | (37.7791153812045, -122.407534853654) | |||
28396 | 28396 | 43970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 460 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 4 | Permit Number 43535 | 6010585.8055300005 | 2112372.51825 | 37.7807691382115 | -122.406992935695 | (37.7807691382115, -122.406992935695) | ||
175168 | 175168 | 198366 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011266.66147 | 2113258.1159200002 | 37.783238858230206 | -122.40469987579701 | (37.7832388582302, -122.404699875797) | |||
187454 | 187454 | 198368 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011301.83803 | 2113291.74738 | 37.7833331683237 | -122.404580546568 | (37.7833331683237, -122.404580546568) | |||
46869 | 46869 | 198371 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011346.201780001 | 2113332.52826 | 37.783447622338706 | -122.404429936189 | (37.7834476223387, -122.404429936189) | |||
153725 | 153725 | 198373 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011376.24194 | 2113360.59546 | 37.783526366981 | -122.404327984568 | (37.783526366981, -122.404327984568) | |||
175717 | 175717 | 198374 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011406.73882 | 2113394.65572 | 37.7836215925909 | -122.40422487458599 | (37.7836215925909, -122.404224874586) | |||
50678 | 50678 | 80637 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 706 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6011239.20103 | 2105002.70461 | 37.7605698551303 | -122.404213664555 | (37.7605698551303, -122.404213664555) | ||
183751 | 183751 | 198375 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011427.189130001 | 2113412.24686 | 37.7836710364202 | -122.40415536240101 | (37.7836710364202, -122.404155362401) | |||
76935 | 76935 | 198376 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011438.043190001 | 2113419.02892 | 37.7836902648328 | -122.404118288736 | (37.7836902648328, -122.404118288736) | |||
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) | |||
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) | |||
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) | |||
60647 | 60647 | 52028 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 4 | Permit Number 48241 | 6011185.5155 | 2096540.2757299999 | 37.737330869824 | -122.403803860554 | (37.737330869824, -122.403803860554) | ||
30973 | 30973 | 198274 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1236 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011932.48905 | 2102621.16084 | 37.7540693755115 | -122.401648489597 | (37.7540693755115, -122.401648489597) | |||
48703 | 48703 | 136949 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6012733.733109999 | 2118974.78929 | 37.7990173826009 | -122.400025954359 | (37.7990173826009, -122.400025954359) | |||
26251 | 26251 | 116376 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50x Madera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012832.143680001 | 2103274.0879599997 | 37.7559123328161 | -122.39858306046801 | (37.7559123328161, -122.398583060468) | |||
77046 | 77046 | 198277 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1850 23rd St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012861.27204 | 2102882.9116700003 | 37.754839870590104 | -122.39845487738899 | (37.7548398705901, -122.398454877389) | |||
24368 | 24368 | 97053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 87 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4 | 2x3 | Permit Number 768205 | 6012721.3609 | 2095242.61214 | 37.7338534369729 | -122.39840267086399 | (37.7338534369729, -122.398402670864) | |
173373 | 173373 | 48915 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 4 | Permit Number 46108 | 6013168.45099 | 2106701.7102200002 | 37.7653425617443 | -122.397660391133 | (37.7653425617443, -122.397660391133) | ||
75545 | 75545 | 198319 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013741.4074800005 | 2108464.54508 | 37.7702148034894 | -122.395802186723 | (37.7702148034894, -122.395802186723) | ||||
173800 | 173800 | 198327 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013747.40215 | 2108665.50559 | 37.7707669296806 | -122.395795534462 | (37.7707669296806, -122.395795534462) | ||||
66247 | 66247 | 198320 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013760.20993 | 2108475.0165 | 37.7702446016405 | -122.39573788252 | (37.7702446016405, -122.39573788252) | ||||
158639 | 158639 | 198326 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013771.76611 | 2108656.94068 | 37.7707447676885 | -122.39571065823601 | (37.7707447676885, -122.395710658236) | ||||
59226 | 59226 | 198321 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013777.96356 | 2108496.99922 | 37.7703059488766 | -122.39567801282601 | (37.7703059488766, -122.395678012826) | ||||
49606 | 49606 | 198325 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013787.22843 | 2108637.88784 | 37.770693312961996 | -122.39565583825899 | (37.770693312962, -122.395655838259) | ||||
71393 | 71393 | 198322 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013789.7693 | 2108510.1655 | 37.7703427572515 | -122.39563809912599 | (37.7703427572515, -122.395638099126) | ||||
175328 | 175328 | 198323 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013802.38344 | 2108531.614 | 37.7704023517081 | -122.39559596947201 | (37.7704023517081, -122.395595969472) |
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");