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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71541 | 71541 | 224269 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6011241.96431 | 2103719.95233 | 37.7570478572995 | -122.404113828986 | (37.7570478572995, -122.404113828986) | ||||
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) | ||||
175102 | 175102 | 224260 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001102.84855 | 2107909.89342 | 37.7679806761809 | -122.43947901285401 | (37.7679806761809, -122.439479012854) | |||
183205 | 183205 | 245009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1466 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999558.6674 | 2109145.6245 | 37.7712856788974 | -122.44490898697701 | (37.7712856788974, -122.444908986977) | |||
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) | ||||
188785 | 188785 | 208967 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 6ft | 5993630.4889400005 | 2097044.9006700001 | 37.737720095508706 | -122.46453586883001 | (37.7377200955087, -122.46453586883) | |||
7960 | 7960 | 23202 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006708.88776 | 2112470.99571 | 37.7808218241176 | -122.420412091366 | (37.7808218241176, -122.420412091366) | |||
9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
36761 | 36761 | 208976 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5994151.01662 | 2096664.6627200001 | 37.7367060496466 | -122.462708592139 | (37.7367060496466, -122.462708592139) | |||
43564 | 43564 | 207757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5994806.26925 | 2105291.62903 | 37.760431240817795 | -122.46106822873399 | (37.7604312408178, -122.461068228734) | ||||
46031 | 46031 | 207784 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 270 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993081.2153199995 | 2096255.53806 | 37.735521023771604 | -122.466377603044 | (37.7355210237716, -122.466377603044) | |||
53478 | 53478 | 207782 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 260 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993076.07579 | 2096352.6988099997 | 37.7357875063795 | -122.466402431535 | (37.7357875063795, -122.466402431535) | |||
56692 | 56692 | 247937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1149 Esmeralda Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.40724215312599 | (37.7433393564296, -122.407242153126) | ||||
69214 | 69214 | 208986 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 372 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5993143.09775 | 2095558.09178 | 37.7336095804246 | -122.46611298742701 | (37.7336095804246, -122.466112987427) | |||
92885 | 92885 | 111536 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
100681 | 100681 | 111529 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
114900 | 114900 | 208965 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 56 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5993745.43898 | 2096960.72106 | 37.7374955851482 | -122.464132325055 | (37.7374955851482, -122.464132325055) | |||
133286 | 133286 | 209001 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 125 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 5994148.93284 | 2096709.76404 | 37.7368297666801 | -122.462719067425 | (37.7368297666801, -122.462719067425) | |||
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) | ||||
137374 | 137374 | 224256 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6001050.217680001 | 2107873.3371599996 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | |||
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) | ||||
139032 | 139032 | 30154 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 410X Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
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) | ||||
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) | ||||
165620 | 165620 | 207802 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 65 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993322.83202 | 2097078.2937 | 37.7377940440554 | -122.465602003431 | (37.7377940440554, -122.465602003431) | |||
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) | ||||
27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
30943 | 30943 | 208922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 201 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5992403.02946 | 2096048.0013299999 | 37.7349120244605 | -122.46870723116899 | (37.7349120244605, -122.468707231169) | |||
44792 | 44792 | 208974 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 5994229.97779 | 2096604.2011400003 | 37.7365445844613 | -122.462431207033 | (37.7365445844613, -122.462431207033) | |||
46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
53873 | 53873 | 207768 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993209.58572 | 2097384.67012 | 37.7386287444209 | -122.466015804002 | (37.7386287444209, -122.466015804002) | |||
73538 | 73538 | 207772 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 60 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993256.95856 | 2097201.9739 | 37.7381298392237 | -122.46583874187 | (37.7381298392237, -122.46583874187) | |||
92343 | 92343 | 113367 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 6X Christopher Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | ||||
113582 | 113582 | 114403 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
149306 | 149306 | 207808 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 15 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993219.0538800005 | 2097526.21938 | 37.7390179494069 | -122.46599335061899 | (37.7390179494069, -122.465993350619) | |||
155663 | 155663 | 208953 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 502 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 8ft | 5993239.50835 | 2095986.2551799999 | 37.734790772481 | -122.46581076936701 | (37.734790772481, -122.465810769367) | |||
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) | ||||
158456 | 158456 | 207762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993165.17049 | 2095669.26931 | 37.7339161197195 | -122.46604475226499 | (37.7339161197195, -122.466044752265) | |||
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) | ||||
175100 | 175100 | 207765 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 356 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5992543.86147 | 2094436.1305 | 37.7304943639181 | -122.46810311696998 | (37.7304943639181, -122.46810311697) | |||
38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
43824 | 43824 | 207767 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5993205.662140001 | 2097402.75145 | 37.7386781648646 | -122.466030683288 | (37.7386781648646, -122.466030683288) | |||
54108 | 54108 | 176348 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.47798295295799 | (37.7196430676648, -122.477982952958) | ||||
56324 | 56324 | 208990 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 51 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5993670.13129 | 2097058.8329 | 37.7377606351295 | -122.46439981849899 | (37.7377606351295, -122.464399818499) | |||
72305 | 72305 | 208950 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5992985.54967 | 2096006.72468 | 37.734832323836706 | -122.46669027215599 | (37.7348323238367, -122.466690272156) | |||
92772 | 92772 | 114075 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
117576 | 117576 | 111525 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
153452 | 153452 | 208949 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 402 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5992933.736169999 | 2096006.17085 | 37.7348278128415 | -122.46686936763099 | (37.7348278128415, -122.466869367631) | |||
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) | ||||
171833 | 171833 | 208958 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 625 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993531.51586 | 2096121.15742 | 37.7351780205546 | -122.464811000239 | (37.7351780205546, -122.464811000239) | |||
187171 | 187171 | 208972 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 136 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 6ft | 5994281.63654 | 2096550.25213 | 37.7363994284866 | -122.462248690521 | (37.7363994284866, -122.462248690521) | |||
33426 | 33426 | 224248 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055213998 | (37.7487943903519, -122.43643055214) | |||
41418 | 41418 | 207775 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | |||
50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
63741 | 63741 | 246757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161978998 | (37.7436943673943, -122.41112161979) | ||||
76846 | 76846 | 208931 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 435 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993027.44059 | 2096068.9282799999 | 37.735005536864904 | -122.46654996171101 | (37.7350055368649, -122.466549961711) | |||
88008 | 88008 | 111551 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 27 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
133032 | 133032 | 209000 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 4ft | 5994206.5655 | 2096669.1829099997 | 37.7367216600723 | -122.462516864768 | (37.7367216600723, -122.462516864768) | |||
149487 | 149487 | 208977 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 300x Marietta Dr | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5999505.82373 | 2097502.74743 | 37.7393141797969 | -122.44425497048401 | (37.7393141797969, -122.444254970484) | |||
164085 | 164085 | 208969 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 30 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 6ft | 5993545.78483 | 2097101.19005 | 37.737869768775795 | -122.46483281598302 | (37.7378697687758, -122.464832815983) | |||
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) | ||||
28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
44163 | 44163 | 224253 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 755 Sanchez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003620.8208099995 | 2103873.1752 | 37.757039798462294 | -122.430481566473 | (37.7570397984623, -122.430481566473) | |||
73320 | 73320 | 224268 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011248.24436 | 2103720.25065 | 37.757049027311204 | -122.40409213106001 | (37.7570490273112, -122.40409213106) | ||||
120548 | 120548 | 111538 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 16 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 28 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
127109 | 127109 | 208991 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993638.39674 | 2097082.374 | 37.73782344378579 | -122.46451124811199 | (37.7378234437858, -122.464511248112) | |||
130074 | 130074 | 207792 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 255 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5993127.3071800005 | 2096365.9249099998 | 37.7358267779692 | -122.46622626692499 | (37.7358267779692, -122.466226266925) | |||
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) | ||||
147084 | 147084 | 208989 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 55 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993734.999890001 | 2097013.08627 | 37.7376387653037 | -122.46417221806699 | (37.7376387653037, -122.464172218067) | |||
148956 | 148956 | 207783 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 260 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5993078.05201 | 2096316.5606 | 37.7356883939084 | -122.466392973362 | (37.7356883939084, -122.466392973362) | |||
170955 | 170955 | 208959 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 601 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 8ft | 5993493.92403 | 2096119.04846 | 37.7351700624345 | -122.46494081468 | (37.7351700624345, -122.46494081468) | |||
188184 | 188184 | 208970 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 6ft | 5993484.40904 | 2097144.7715200002 | 37.7379858937365 | -122.46504818472499 | (37.7379858937365, -122.465048184725) | |||
63161 | 63161 | 208994 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993511.280230001 | 2097168.00802 | 37.7380512447772 | -122.46495696559799 | (37.7380512447772, -122.464956965598) | |||
73251 | 73251 | 208996 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | |||
130507 | 130507 | 207805 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 35 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 10ft | 5993257.8737699995 | 2097404.51842 | 37.738686028527 | -122.46585029007099 | (37.738686028527, -122.465850290071) | |||
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) | ||||
181129 | 181129 | 207771 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 50 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 10ft | 5993253.43088 | 2097238.9026200003 | 37.7382310327445 | -122.465853621172 | (37.7382310327445, -122.465853621172) | |||
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) | ||||
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
24218 | 24218 | 208954 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993495.97502 | 2095994.9515900002 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | |||
29038 | 29038 | 208963 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 6ft | 5993939.166669999 | 2096822.57013 | 37.7371274206966 | -122.463452499655 | (37.7371274206966, -122.463452499655) | |||
36877 | 36877 | 138087 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1611 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | |||
40777 | 40777 | 207799 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5993278.012180001 | 2096833.03373 | 37.7371180362587 | -122.465739151856 | (37.7371180362587, -122.465739151856) | |||
41832 | 41832 | 208941 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992287.573419999 | 2095984.60456 | 37.734731282309106 | -122.469101787134 | (37.7347312823091, -122.469101787134) | |||
44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
67445 | 67445 | 207804 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 55 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5993316.273159999 | 2097156.75234 | 37.738009093546 | -122.46563037885099 | (37.738009093546, -122.465630378851) | |||
75990 | 75990 | 208962 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 6ft | 5993970.2453 | 2096804.3744 | 37.7370792503013 | -122.463343727552 | (37.7370792503013, -122.463343727552) | |||
112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
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) | ||||
161658 | 161658 | 209044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 5996811.85436 | 2095301.80777 | 37.7331168670328 | -122.453410604043 | (37.7331168670328, -122.453410604043) | |||
173563 | 173563 | 208921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992336.36345 | 2096045.4635 | 37.7349012047205 | -122.46893753225001 | (37.7349012047205, -122.46893753225) | |||
65901 | 65901 | 208933 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 405 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 10ft | 5992936.60702 | 2096064.2661700002 | 37.7349874937845 | -122.466863664131 | (37.7349874937845, -122.466863664131) | |||
68451 | 68451 | 207786 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 10ft | 5993081.96122 | 2096160.8531 | 37.735261085532706 | -122.46636814486999 | (37.7352610855327, -122.46636814487) | |||
74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) |
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");