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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127427 | 127427 | 106795 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
153234 | 153234 | 209020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | ||||
189014 | 189014 | 209015 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6000779.78636 | 2095479.1538 | 37.73383046469421 | -122.439705146498 | (37.7338304646942, -122.439705146498) | ||||
28820 | 28820 | 209004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 156 Kensington Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994803.6888 | 2098556.09355 | 37.7419370183784 | -122.460589057359 | (37.7419370183784, -122.460589057359) | |||
71759 | 71759 | 208946 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 10ft | 5992719.83793 | 2096001.79663 | 37.7348034547201 | -122.467608563598 | (37.7348034547201, -122.467608563598) | |||
124116 | 124116 | 224234 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004836.880530001 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | ||||
181724 | 181724 | 224226 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004846.937969999 | 2096712.6297900002 | 37.7374479705325 | -122.42573153718 | (37.7374479705325, -122.42573153718) | ||||
182141 | 182141 | 209011 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6000782.1941599995 | 2095354.33843 | 37.7334878877384 | -122.439687876799 | (37.7334878877384, -122.439687876799) | ||||
186323 | 186323 | 224264 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004254.57068 | 2108904.38845 | 37.770890184456796 | -122.42864845406 | (37.7708901844568, -122.42864845406) | |||
36905 | 36905 | 224255 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999122.55283 | 2104753.1321799997 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | |||
61025 | 61025 | 224257 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.767908557750204 | -122.439611299541 | (37.7679085577502, -122.439611299541) | |||
61204 | 61204 | 224222 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004869.898159999 | 2096730.73115 | 37.7374989702074 | -122.42565344095199 | (37.7374989702074, -122.425653440952) | ||||
63720 | 63720 | 224229 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | ||||
69421 | 69421 | 224263 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004229.44428 | 2108900.2308400003 | 37.770877346636205 | -122.42873507047399 | (37.7708773466362, -122.428735070474) | |||
130326 | 130326 | 209005 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 172 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994782.01847 | 2098589.82391 | 37.7420283868014 | -122.460666429624 | (37.7420283868014, -122.460666429624) | |||
164592 | 164592 | 191726 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Missouri St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | ||||
175511 | 175511 | 208978 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Junipero Serra Blvd | 109 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991241.872330001 | 2091923.37185 | 37.723519677182495 | -122.47242112456001 | (37.7235196771825, -122.47242112456) | |||
43329 | 43329 | 111546 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 24 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
68974 | 68974 | 224228 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004840.27089 | 2096702.3446900002 | 37.7374193532181 | -122.425753856564 | (37.7374193532181, -122.425753856564) | ||||
90816 | 90816 | 119631 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 265 Fowler Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 3x5 | 5997384.0 | 2099137.0 | 37.7436801569324 | -122.451709113802 | (37.7436801569324, -122.451709113802) | |||
109383 | 109383 | 106792 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
136867 | 136867 | 224241 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004764.42793 | 2096634.9587599998 | 37.7372300405369 | -122.42601128568998 | (37.7372300405369, -122.42601128569) | ||||
137042 | 137042 | 207787 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 292 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5993086.25016 | 2096104.5741400002 | 37.7351068050182 | -122.466349227661 | (37.7351068050182, -122.466349227661) | |||
152307 | 152307 | 208936 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5991855.38456 | 2095971.03212 | 37.7346690339426 | -122.470595009771 | (37.7346690339426, -122.470595009771) | |||
177154 | 177154 | 224221 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1000 San Jose Ave | 63 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005093.2410699995 | 2097044.1609999998 | 37.7383721957242 | -122.424903531393 | (37.7383721957242, -122.424903531393) | ||||
33664 | 33664 | 207789 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.46619907325199 | (37.735400404893, -122.466199073252) | |||
76953 | 76953 | 208935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5991812.79149 | 2095969.62922 | 37.7346627188958 | -122.47074216493401 | (37.7346627188958, -122.470742164934) | |||
94946 | 94946 | 95436 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2675 25th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 16 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
102874 | 102874 | 111513 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 16 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
146709 | 146709 | 224254 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 190 Storrie St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6000752.12131 | 2105271.59361 | 37.760716590308704 | -122.440502889194 | (37.7607165903087, -122.440502889194) | |||
149384 | 149384 | 207754 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5993663.7534300005 | 2106217.17575 | 37.7629067380829 | -122.46508685559999 | (37.7629067380829, -122.4650868556) | |||
162672 | 162672 | 207760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 333 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993144.47081 | 2095802.99513 | 37.734282103340796 | -122.46612603120501 | (37.7342821033408, -122.466126031205) | |||
174806 | 174806 | 185917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.749233870008794 | -122.494681880668 | (37.7492338700088, -122.494681880668) | |||
182600 | 182600 | 209016 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6000787.61929 | 2095495.57167 | 37.7338759901863 | -122.43967924239901 | (37.7338759901863, -122.439679242399) | ||||
701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
30634 | 30634 | 207776 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993235.98614 | 2096867.2882599998 | 37.7372096663776 | -122.46588694193001 | (37.7372096663776, -122.46588694193) | |||
32381 | 32381 | 207778 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.46600517310699 | (37.7369852648432, -122.466005173107) | |||
47668 | 47668 | 208973 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 136 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5994259.725980001 | 2096572.0955299998 | 37.7364581434207 | -122.46232602774799 | (37.7364581434207, -122.462326027748) | |||
62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
171861 | 171861 | 224261 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6001117.5941 | 2107921.40745 | 37.768013130033204 | -122.439428835199 | (37.7680131300332, -122.439428835199) | |||
179858 | 179858 | 224235 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004831.6413199995 | 2096688.95275 | 37.7373820943173 | -122.425782740103 | (37.7373820943173, -122.425782740103) | ||||
1070 | 1070 | 19942 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
6891 | 6891 | 7808 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | |||
7805 | 7805 | 19939 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
8002 | 8002 | 19938 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
14348 | 14348 | 19941 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
14547 | 14547 | 19940 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
48059 | 48059 | 43994 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | ||
63465 | 63465 | 224224 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004854.036780001 | 2096713.3958700001 | 37.737450475157296 | -122.42570704776199 | (37.7374504751573, -122.425707047762) | ||||
69718 | 69718 | 208957 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 625 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993588.443419999 | 2096129.23717 | 37.73520348755321 | -122.46461476908001 | (37.7352034875532, -122.46461476908) | |||
72350 | 72350 | 209029 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6000758.12976 | 2095576.10922 | 37.7340954490409 | -122.43978696861299 | (37.7340954490409, -122.439786968613) | ||||
106180 | 106180 | 106794 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
119339 | 119339 | 121341 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 401X Cargo Way | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 3x3 | 6017217.0 | 2098844.0 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | |||
132331 | 132331 | 208961 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5993977.82871 | 2104681.32491 | 37.75870779624321 | -122.463889098911 | (37.7587077962432, -122.463889098911) | |||
159705 | 159705 | 191732 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | ||||
165006 | 165006 | 208952 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 10ft | 5993062.868430001 | 2096011.9995 | 37.734851268974296 | -122.466423339872 | (37.7348512689743, -122.466423339872) | |||
166974 | 166974 | 209007 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 172 Kensington Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5994745.50567 | 2098641.39451 | 37.7421678860404 | -122.460796414937 | (37.7421678860404, -122.460796414937) | |||
171841 | 171841 | 176342 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.721003982019504 | -122.40245197087799 | (37.7210039820195, -122.402451970878) | |||
29388 | 29388 | 207794 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478658999 | (37.736371894833, -122.46616478659) | |||
35751 | 35751 | 224259 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6001093.91519 | 2107903.0746400002 | 37.767961445086605 | -122.43950942341999 | (37.7679614450866, -122.43950942342) | |||
40215 | 40215 | 207788 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993135.10109 | 2096167.2284099997 | 37.7352816566244 | -122.46618488553001 | (37.7352816566244, -122.46618488553) | |||
63892 | 63892 | 224237 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | ||||
74972 | 74972 | 208988 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 85 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 5993834.637730001 | 2096941.34521 | 37.7374475244853 | -122.463822519421 | (37.7374475244853, -122.463822519421) | |||
162142 | 162142 | 207781 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 256 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993074.748819999 | 2096403.4667 | 37.7359268257591 | -122.466410707985 | (37.7359268257591, -122.466410707985) | |||
48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
51382 | 51382 | 207780 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 250 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993075.61435 | 2096444.65306 | 37.7360399631594 | -122.46641070800501 | (37.7360399631594, -122.466410708005) | |||
61748 | 61748 | 224243 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004771.77471 | 2096643.7523700001 | 37.737254601020005 | -122.425986510284 | (37.73725460102, -122.425986510284) | ||||
131911 | 131911 | 207759 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 315 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993145.97421 | 2095838.45755 | 37.7343795610583 | -122.46612340966999 | (37.7343795610583, -122.46612340967) | |||
144679 | 144679 | 106811 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
151150 | 151150 | 126581 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 556 Pine St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | |||
151444 | 151444 | 208979 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992891.21268 | 2101728.13425 | 37.7505364203394 | -122.467432335147 | (37.7505364203394, -122.467432335147) | |||
156141 | 156141 | 208964 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 60 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 6ft | 5993779.53053 | 2096936.1958400002 | 37.737430209820296 | -122.46401267564801 | (37.7374302098203, -122.464012675648) | |||
156854 | 156854 | 209023 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6000780.47253 | 2095565.1582 | 37.7340666518368 | -122.439708938014 | (37.7340666518368, -122.439708938014) | ||||
26913 | 26913 | 224258 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001075.26018 | 2107893.8305599997 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | |||
32753 | 32753 | 224251 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6008204.54136 | 2098121.72815 | 37.741506207147005 | -122.414222358085 | (37.741506207147, -122.414222358085) | |||
39683 | 39683 | 191728 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201017999 | (37.754962860065, -122.39634201018) | ||||
51100 | 51100 | 209006 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 172 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994773.63128 | 2098602.47798 | 37.7420626491773 | -122.46069634646099 | (37.7420626491773, -122.460696346461) | |||
61471 | 61471 | 224223 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004855.412690001 | 2096718.43509 | 37.7374643894683 | -122.425702649156 | (37.7374643894683, -122.425702649156) | ||||
99243 | 99243 | 122535 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 199x Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6007478.0 | 2099565.0 | 37.7454282725128 | -122.41683672388399 | (37.7454282725128, -122.416836723884) | |||
130593 | 130593 | 191727 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | ||||
179310 | 179310 | 208987 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5993980.02644 | 2096844.0619400002 | 37.7371887859367 | -122.46331278907499 | (37.7371887859367, -122.463312789075) | |||
183947 | 183947 | 208992 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5993607.99739 | 2097104.1803400002 | 37.7378815660919 | -122.46461793558001 | (37.7378815660919, -122.46461793558) | |||
25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
60463 | 60463 | 207807 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 25 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 10ft | 5993231.15579 | 2097483.74028 | 37.7389020106052 | -122.46594842230199 | (37.7389020106052, -122.465948422302) | |||
70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
90554 | 90554 | 114400 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
177301 | 177301 | 245010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1480 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999484.2143 | 2109133.9912 | 37.7712494874058 | -122.44516568603999 | (37.7712494874058, -122.44516568604) | |||
181562 | 181562 | 224233 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004845.23458 | 2096693.0180000002 | 37.737394024725205 | -122.42573603111 | (37.7373940247252, -122.42573603111) | ||||
186405 | 186405 | 224262 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 91 Stanton St | 2 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6000293.691000001 | 2103856.2070400002 | 37.7568041715846 | -122.44198679486 | (37.7568041715846, -122.44198679486) | |||
30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
41325 | 41325 | 224244 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004777.47133 | 2096641.4622900002 | 37.73724863492671 | -122.425966651467 | (37.7372486349267, -122.425966651467) | ||||
52363 | 52363 | 208968 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 6ft | 5993576.11533 | 2097077.3704400002 | 37.737806114757795 | -122.46472622025298 | (37.7378061147578, -122.464726220253) |
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");