Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128646 | 128646 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
130011 | 130011 | 209032 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 38 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6000749.17916 | 2095580.7996200002 | 37.7341078183059 | -122.43981824973301 | (37.7341078183059, -122.439818249733) | ||||
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) | ||||
130703 | 130703 | 224266 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011271.09407 | 2103721.28577 | 37.75705314619071 | -122.404013180481 | (37.7570531461907, -122.404013180481) | ||||
133399 | 133399 | 224230 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004850.154069999 | 2096702.7007099998 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | ||||
134583 | 134583 | 209010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000785.06362 | 2095352.2063400003 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | ||||
134672 | 134672 | 207755 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.46113126040702 | (37.7604304368423, -122.461131260407) | ||||
134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
135102 | 135102 | 224232 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004847.66693 | 2096700.7431599998 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | ||||
135905 | 135905 | 224240 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6004759.95311 | 2096625.2597 | 37.7372031562031 | -122.426026066958 | (37.7372031562031, -122.426026066958) | ||||
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) | ||||
138334 | 138334 | 207756 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | ||||
138343 | 138343 | 105902 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 40 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
138466 | 138466 | 114076 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
138770 | 138770 | 209034 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 38 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6000740.95615 | 2095584.22378 | 37.7341167521787 | -122.439846924607 | (37.7341167521787, -122.439846924607) | ||||
139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
141204 | 141204 | 111548 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 26 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
141792 | 141792 | 119265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000208.0 | 2096491.0 | 37.7365761953737 | -122.44175457190599 | (37.7365761953737, -122.441754571906) | |||||
143929 | 143929 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
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) | ||||
146980 | 146980 | 247819 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009694.17454 | 2096850.5592099999 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | ||||
147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
148610 | 148610 | 209028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6000760.3597 | 2095574.5612700002 | 37.7340913256606 | -122.439779148088 | (37.7340913256606, -122.439779148088) | ||||
148899 | 148899 | 247820 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009707.559769999 | 2096850.2861400002 | 37.7380994142676 | -122.40893572671699 | (37.7380994142676, -122.408935726717) | ||||
150050 | 150050 | 209031 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000753.40861 | 2095578.70975 | 37.734102320756996 | -122.43980347745001 | (37.734102320757, -122.43980347745) | ||||
150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
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) | ||||
153590 | 153590 | 248107 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 138 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | ||||
153783 | 153783 | 191723 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x Carolina St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.39981689974701 | (37.7560429683291, -122.399816899747) | ||||
154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
154936 | 154936 | 224219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004118.53569 | 2095824.9734900002 | 37.734969479450896 | -122.428186723249 | (37.7349694794509, -122.428186723249) | ||||
155920 | 155920 | 224236 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004818.97924 | 2096691.85028 | 37.737389334736 | -122.425826725021 | (37.737389334736, -122.425826725021) | ||||
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) | ||||
156972 | 156972 | 224267 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6011260.203430001 | 2103721.90369 | 37.7570542343818 | -122.40405088815001 | (37.7570542343818, -122.40405088815) | ||||
157173 | 157173 | 209039 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000750.66308 | 2095345.5130200002 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | ||||
158274 | 158274 | 176343 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | 6008484.74111 | 2088383.4213400001 | 37.714782633086294 | -122.412565284366 | (37.7147826330863, -122.412565284366) | ||||
158564 | 158564 | 209026 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6000767.091 | 2095571.9190599998 | 37.7340844539158 | -122.439755686569 | (37.7340844539158, -122.439755686569) | ||||
158665 | 158665 | 191729 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | ||||
159119 | 159119 | 209012 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 410 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6000789.00569 | 2095372.0781 | 37.7335369844496 | -122.439665598801 | (37.7335369844496, -122.439665598801) | ||||
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) | ||||
160722 | 160722 | 209027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000763.850930001 | 2095573.2374 | 37.7340878893448 | -122.439766982962 | (37.7340878893448, -122.439766982962) | ||||
162554 | 162554 | 224231 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004851.9976 | 2096696.37519 | 37.7374036249796 | -122.42571288706301 | (37.7374036249796, -122.425712887063) | ||||
164177 | 164177 | 224220 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6004122.93683 | 2095831.8247900002 | 37.734988540591395 | -122.42817199506099 | (37.7349885405914, -122.428171995061) | ||||
164405 | 164405 | 191733 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009990.5053900005 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | ||||
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) | ||||
165522 | 165522 | 209035 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6000759.78323 | 2095371.55913 | 37.733533896164104 | -122.43976659178101 | (37.7335338961641, -122.439766591781) | ||||
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) | ||||
169268 | 169268 | 246758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6009165.3759699995 | 2098887.8964 | 37.743663861508395 | -122.41095421008801 | (37.7436638615084, -122.410954210088) | ||||
169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
170494 | 170494 | 209008 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 406 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6000788.7045 | 2095325.02184 | 37.7334077617457 | -122.439663267741 | (37.7334077617457, -122.439663267741) | ||||
172222 | 172222 | 201510 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6018594.17439 | 2094891.11142 | 37.73321369166371 | -122.378073969944 | (37.7332136916637, -122.378073969944) | ||||
172652 | 172652 | 247821 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009717.95526 | 2096849.3331900002 | 37.7380973799798 | -122.40889971695 | (37.7380973799798, -122.40889971695) | ||||
173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
174300 | 174300 | 248219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6007128.325540001 | 2099340.74379 | 37.744792840734206 | -122.418029950029 | (37.7447928407342, -122.418029950029) | ||||
176149 | 176149 | 209037 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000749.92806 | 2095352.54396 | 37.7334811239592 | -122.43979930099701 | (37.7334811239592, -122.439799300997) | ||||
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) | ||||
178073 | 178073 | 224242 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004773.2240699995 | 2096631.25513 | 37.7372203683314 | -122.425980609816 | (37.7372203683314, -122.425980609816) | ||||
179355 | 179355 | 207758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 5994815.677630001 | 2105291.72467 | 37.7604320448236 | -122.461035696659 | (37.7604320448236, -122.461035696659) | ||||
179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
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) | ||||
180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) | ||||
181003 | 181003 | 191736 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Helena St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 57 | 6010895.577219999 | 2096228.10312 | 37.7364575084979 | -122.40478434551399 | (37.7364575084979, -122.404784345514) | ||||
181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | ||||
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) | ||||
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) | ||||
182567 | 182567 | 246763 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009290.72604 | 2098884.53398 | 37.74366165725821 | -122.410520540796 | (37.7436616572582, -122.410520540796) | ||||
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) | ||||
183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
183396 | 183396 | 176347 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6011214.18105 | 2087815.3375799998 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | ||||
185207 | 185207 | 246760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | ||||
185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
185838 | 185838 | 209018 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | ||||
186126 | 186126 | 246762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.41062704033101 | (37.743665689828, -122.410627040331) | ||||
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) | ||||
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) | |||
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 | ||||||||
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 | ||||||||
20653 | 20653 | 2618 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
78801 | 78801 | 2617 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
80756 | 80756 | 2614 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
116419 | 116419 | 2615 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
126390 | 126390 | 2619 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.42692897924101 | (37.7877373561683, -122.426928979241) | |||
138324 | 138324 | 2616 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
8841 | 8841 | 23183 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006719.9876 | 2112427.32903 | 37.780702551515496 | -122.42037059124901 | (37.7807025515155, -122.420370591249) | ||
18477 | 18477 | 4843 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.739800668952604 | -122.419974789699 | (37.7398006689526, -122.419974789699) | |||
19139 | 19139 | 29600 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | ||
20364 | 20364 | 4837 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 127 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006404.24922 | 2097646.68025 | 37.7401005434118 | -122.420413452032 | (37.7401005434118, -122.420413452032) | |||
887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) |
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");