trees
484 rows where qSpecies_id = 56 sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62684 | 106004 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 695X CAMPBELL AVE | unknown : Yard | Tree | Rec/Park 5 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.410348471622 | (37.716271678506, -122.410348471622) | 9 | 7 | 8 | 309 | 39 | ||||||
119017 | 105441 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 425 WAWONA ST | unknown : Yard | Tree | Private 2 | 5991587.6 | 2097036.5 | 37.7375790508831 | -122.471598439568 | (37.7375790508831, -122.471598439568) | 1 | 8 | 4 | 29491 | 40 | ||||||
444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
2742 | 261944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 9 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
3394 | 261943 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 8 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
4881 | 259031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
5342 | 260946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
5343 | 259035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6781 | 259030 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6957 | 259032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
11269 | 247818 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1158x Jarboe Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 46 | 6009634.53348 | 2096844.36766 | 37.7380790724954 | -122.409187798594 | (37.7380790724954, -122.409187798594) | 10 | 7 | 7 | 28859 | 2 | ||||
11415 | 260944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
11644 | 259033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
12354 | 264690 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 99 Verna St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5998312 | 2096103 | 37.7354026257891 | -122.448281895759 | (37.7354026257891, -122.448281895759) | 9 | 7 | 4 | 59 | 40 | ||||
13646 | 259034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
14474 | 260945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
14634 | 259029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
17462 | 261945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 10 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
17551 | 261946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 11 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
79539 | 95436 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2675 25th Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
136862 | 105901 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
140615 | 96803 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 300X Melrose Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 48 | 5998134.5 | 2095546.7 | 37.7338650092742 | -122.448855518806 | (37.7338650092742, -122.448855518806) | 9 | 7 | 4 | 59 | 40 | ||||
189511 | 105902 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 40 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
20018 | 256139 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 888 Moultrie St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 6007515 | 2095179 | 37.7333873668614 | -122.416398174089 | (37.7333873668614, -122.416398174089) | 2 | 7 | 7 | 28859 | 2 | ||||
45655 | 121204 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 52 | 6008473.20212 | 2119153.5676 | 37.7992698007193 | -122.41478152415 | (37.7992698007193, -122.41478152415) | 5 | 1 | 10 | 308 | 32 | ||||
7245 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
7655 | 224252 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 401x Powhattan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 3ft | 6008209.41115 | 2098117.01266 | 37.741493532991 | -122.414205186423 | (37.741493532991, -122.414205186423) | 2 | 7 | 7 | 28859 | 2 | |||
8712 | 207757 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5994806.26925 | 2105291.62903 | 37.7604312408178 | -122.461068228734 | (37.7604312408178, -122.461068228734) | 15 | 5 | 4 | 56 | 12 | ||||
10388 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
18334 | 224251 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 401X Powhattan Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6008204.54136 | 2098121.72815 | 37.741506207147 | -122.414222358085 | (37.741506207147, -122.414222358085) | 2 | 7 | 7 | 28859 | 2 | |||
21127 | 176347 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6011214.18105 | 2087815.33758 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | 9 | 7 | 8 | 309 | 39 | ||||
28767 | 176346 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | 9 | 7 | 8 | 309 | 39 | ||||
33046 | 209043 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 690 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 10ft | 5996832.93686 | 2095303.59062 | 37.7331229707542 | -122.453337845278 | (37.7331229707542, -122.453337845278) | 9 | 7 | 4 | 59 | 40 | |||
37863 | 224257 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.7679085577502 | -122.439611299541 | (37.7679085577502, -122.439611299541) | 15 | 5 | 5 | 29492 | 3 | |||
44889 | 191727 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | 10 | 3 | 8 | 28856 | 29 | ||||
50310 | 176345 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | 9 | 7 | 8 | 309 | 18 | ||||
58428 | 209046 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.7322909323756 | -122.442419949729 | (37.7322909323756, -122.442419949729) | 9 | 7 | 4 | 63 | 40 | |||
59460 | 207755 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.461131260407 | (37.7604304368423, -122.461131260407) | 15 | 5 | 4 | 56 | 12 | ||||
61319 | 119631 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 265 Fowler Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 3x5 | 5997384 | 2099137 | 37.7436801569324 | -122.451709113802 | (37.7436801569324, -122.451709113802) | 9 | 7 | 4 | 59 | 40 | |||
66487 | 207756 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | 15 | 5 | 4 | 56 | 12 | ||||
66615 | 185931 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985001.315 | 2101504.3546 | 37.749463324704 | -122.494699314147 | (37.749463324704, -122.494699314147) | 1 | 8 | 3 | 29491 | 35 | |||
75661 | 176344 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008453.92432 | 2088393.60062 | 37.7148088537086 | -122.412672519523 | (37.7148088537086, -122.412672519523) | 9 | 7 | 8 | 309 | 18 | ||||
82973 | 126581 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 556 Pine St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | 5 | 1 | 10 | 28857 | 6 | |||
83967 | 176343 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 76 | 6008484.74111 | 2088383.42134 | 37.7147826330863 | -122.412565284366 | (37.7147826330863, -122.412565284366) | 9 | 7 | 8 | 309 | 18 | ||||
87323 | 173856 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | ||||
91988 | 224256 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6001050.21768 | 2107873.33716 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | 15 | 5 | 5 | 29492 | 3 | |||
103049 | 185917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.7492338700088 | -122.494681880668 | (37.7492338700088, -122.494681880668) | 1 | 8 | 3 | 29491 | 35 | |||
110371 | 112189 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 12 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
111543 | 209044 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 690 Mangels Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 10ft | 5996811.85436 | 2095301.80777 | 37.7331168670328 | -122.453410604043 | (37.7331168670328, -122.453410604043) | 9 | 7 | 4 | 59 | 40 | |||
111670 | 104402 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000011.7 | 2094912.1 | 37.7322297190532 | -122.442319949129 | (37.7322297190532, -122.442319949129) | 9 | 7 | 4 | 63 | 40 | |||||
112183 | 224260 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6001102.84855 | 2107909.89342 | 37.7679806761809 | -122.439479012854 | (37.7679806761809, -122.439479012854) | 15 | 5 | 5 | 29492 | 3 | |||
114012 | 112188 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 45 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
134306 | 224258 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6001075.26018 | 2107893.83056 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | 15 | 5 | 5 | 29492 | 3 | |||
142172 | 207758 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 5994815.67763 | 2105291.72467 | 37.7604320448236 | -122.461035696659 | (37.7604320448236, -122.461035696659) | 15 | 5 | 4 | 56 | 12 | ||||
144814 | 224259 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 3ft | 6001093.91519 | 2107903.07464 | 37.7679614450866 | -122.43950942342 | (37.7679614450866, -122.43950942342) | 15 | 5 | 5 | 29492 | 3 | |||
160808 | 169607 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 118 Saint Mary's Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | |||
185364 | 224261 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 6001117.5941 | 2107921.40745 | 37.7680131300332 | -122.439428835199 | (37.7680131300332, -122.439428835199) | 15 | 5 | 5 | 29492 | 3 | |||
185421 | 191728 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201018 | (37.754962860065, -122.39634201018) | 10 | 3 | 8 | 28856 | 29 | ||||
192427 | 185929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | 1 | 8 | 3 | 29491 | 35 | |||
20382 | 253206 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2253 09th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5993186 | 2100608 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | 1 | 8 | 4 | 29491 | 40 | ||||
74910 | 114400 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1X HIGUERA AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | |||
188995 | 119265 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000208 | 2096491 | 37.7365761953737 | -122.441754571906 | (37.7365761953737, -122.441754571906) | 2 | 7 | 5 | 63 | 7 | |||||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
891 | 207770 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 40 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5993240.61068 | 2097284.1687 | 37.7383545825079 | -122.465901234858 | (37.7383545825079, -122.465901234858) | 1 | 8 | 4 | 59 | 40 | |||
4728 | 208915 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 55X Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | Permit Number 782933 | 5992083 | 2096107 | 37.7350555268004 | -122.469817969126 | (37.7350555268004, -122.469817969126) | 1 | 8 | 4 | 59 | 40 | ||
4988 | 224247 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 701X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 46 | 6008745.22263 | 2098103.60695 | 37.7414868060782 | -122.412351580256 | (37.7414868060782, -122.412351580256) | 10 | 7 | 7 | 28859 | 2 | ||||
10506 | 208985 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 372 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 59 | Width 3ft | 5993088 | 2095554 | 37.7335951664771 | -122.466303177465 | (37.7335951664771, -122.466303177465) | 9 | 8 | 4 | 59 | 40 | |||
13030 | 208963 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 85 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 6ft | 5993873 | 2096938 | 37.737440549971 | -122.463689641388 | (37.737440549971, -122.463689641388) | 1 | 8 | 4 | 59 | 40 | |||
16272 | 207772 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 60 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5993256.95856 | 2097201.9739 | 37.7381298392237 | -122.46583874187 | (37.7381298392237, -122.46583874187) | 1 | 8 | 4 | 59 | 40 | |||
17188 | 260389 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x6 | 5993303.46118 | 2096918.61416 | 37.7373544866644 | -122.465657379584 | (37.7373544866644, -122.465657379584) | 1 | 8 | 4 | 59 | 40 | ||||
18898 | 208916 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 55X Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | Width 10ft | Permit Number 782933 | 5992083 | 2096107 | 37.7350555268004 | -122.469817969126 | (37.7350555268004, -122.469817969126) | 1 | 8 | 4 | 59 | 40 | ||
21658 | 208914 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 45 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 10ft | 5991964.75621 | 2096031.6123 | 37.7348416956868 | -122.470221288386 | (37.7348416956868, -122.470221288386) | 1 | 8 | 4 | 59 | 40 | |||
27522 | 208948 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 340 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5992820.42769 | 2095999.68162 | 37.7348034547075 | -122.467260639285 | (37.7348034547075, -122.467260639285) | 9 | 8 | 4 | 59 | 40 | |||
31382 | 208940 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 10ft | 5992201.32921 | 2095978.53427 | 37.7347096311457 | -122.469399518468 | (37.7347096311457, -122.469399518468) | 9 | 8 | 4 | 59 | 40 | |||
33889 | 209004 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 156 Kensington Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994803.6888 | 2098556.09355 | 37.7419370183784 | -122.460589057359 | (37.7419370183784, -122.460589057359) | 1 | 8 | 4 | 59 | 40 | |||
35915 | 208975 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 5994177.11325 | 2096643.32557 | 37.7366489660835 | -122.462616818123 | (37.7366489660835, -122.462616818123) | 9 | 8 | 4 | 59 | 40 | |||
36671 | 208936 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 5991855.38456 | 2095971.03212 | 37.7346690339426 | -122.470595009771 | (37.7346690339426, -122.470595009771) | 9 | 8 | 4 | 59 | 40 | |||
37827 | 208942 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5992406.13159 | 2095989.66706 | 37.7347520323855 | -122.468692262863 | (37.7347520323855, -122.468692262863) | 9 | 8 | 4 | 59 | 40 | |||
40308 | 208955 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 8ft | 5993530.97918 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | 9 | 8 | 4 | 59 | 40 | |||
41955 | 207763 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5993266.97338 | 2095443.21542 | 37.7333013044925 | -122.465676373776 | (37.7333013044925, -122.465676373776) | 9 | 8 | 4 | 59 | 40 | |||
42039 | 207775 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | 1 | 8 | 4 | 59 | 40 | |||
42550 | 208970 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 20 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 6ft | 5993484.40904 | 2097144.77152 | 37.7379858937365 | -122.465048184725 | (37.7379858937365, -122.465048184725) | 1 | 8 | 4 | 59 | 40 | |||
44214 | 208933 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 405 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 10ft | 5992936.60702 | 2096064.26617 | 37.7349874937845 | -122.466863664131 | (37.7349874937845, -122.466863664131) | 1 | 8 | 4 | 59 | 40 | |||
44574 | 208991 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 45 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5993638.39674 | 2097082.374 | 37.7378234437858 | -122.464511248112 | (37.7378234437858, -122.464511248112) | 1 | 8 | 4 | 59 | 40 | |||
45573 | 208969 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 30 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 6ft | 5993545.78483 | 2097101.19005 | 37.7378697687758 | -122.464832815983 | (37.7378697687758, -122.464832815983) | 1 | 8 | 4 | 59 | 40 | |||
47282 | 207782 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 260 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 10ft | 5993076.07579 | 2096352.69881 | 37.7357875063795 | -122.466402431535 | (37.7357875063795, -122.466402431535) | 1 | 8 | 4 | 59 | 40 | |||
49183 | 208959 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 601 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 8ft | 5993493.92403 | 2096119.04846 | 37.7351700624345 | -122.46494081468 | (37.7351700624345, -122.46494081468) | 1 | 8 | 4 | 59 | 40 | |||
49989 | 207806 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 35 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5993241.00806 | 2097448.11917 | 37.7388047723291 | -122.465911770435 | (37.7388047723291, -122.465911770435) | 1 | 8 | 4 | 59 | 40 | |||
51052 | 207773 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 80 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 58 | Width 10ft | 5993272.22832 | 2097088.94625 | 37.7378203744176 | -122.465777737259 | (37.7378203744176, -122.465777737259) | 1 | 8 | 4 | 59 | 40 | |||
55299 | 208919 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 10ft | 5992247.91507 | 2096042.07051 | 37.734886777798 | -122.469243079632 | (37.734886777798, -122.469243079632) | 1 | 8 | 4 | 59 | 40 | |||
56798 | 208958 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 625 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 8ft | 5993531.51586 | 2096121.15742 | 37.7351780205546 | -122.464811000239 | (37.7351780205546, -122.464811000239) | 1 | 8 | 4 | 59 | 40 | |||
56919 | 208997 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5993343.64638 | 2097250.7379 | 37.7382687332076 | -122.465542562746 | (37.7382687332076, -122.465542562746) | 1 | 8 | 4 | 59 | 40 | |||
59512 | 207781 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 256 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993074.74882 | 2096403.4667 | 37.7359268257591 | -122.466410707985 | (37.7359268257591, -122.466410707985) | 1 | 8 | 4 | 59 | 40 | |||
61500 | 208994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 21 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5993511.28023 | 2097168.00802 | 37.7380512447772 | -122.464956965598 | (37.7380512447772, -122.464956965598) | 1 | 8 | 4 | 59 | 40 | |||
62369 | 209003 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 96 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 3ft | 5994450.97172 | 2101378.39351 | 37.7496660456507 | -122.462013248027 | (37.7496660456507, -122.462013248027) | 1 | 8 | 4 | 29491 | 40 | |||
62726 | 207808 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 15 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5993219.05388 | 2097526.21938 | 37.7390179494069 | -122.465993350619 | (37.7390179494069, -122.465993350619) | 1 | 8 | 4 | 59 | 40 | |||
64758 | 191722 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014479.64038 | 2101959.5389 | 37.7523945096015 | -122.392793471535 | (37.7523945096015, -122.392793471535) | 10 | 3 | 8 | 28856 | 1 | ||||
65378 | 208922 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 201 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5992403.02946 | 2096048.00133 | 37.7349120244605 | -122.468707231169 | (37.7349120244605, -122.468707231169) | 1 | 8 | 4 | 59 | 40 | |||
65949 | 207807 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 25 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 10ft | 5993231.15579 | 2097483.74028 | 37.7389020106052 | -122.465948422302 | (37.7389020106052, -122.465948422302) | 1 | 8 | 4 | 59 | 40 | |||
71372 | 208972 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 136 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 6ft | 5994281.63654 | 2096550.25213 | 37.7363994284866 | -122.462248690521 | (37.7363994284866, -122.462248690521) | 9 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );