Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 674 | 674 | 251361 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
| 709 | 709 | 251360 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 781 | 781 | 251370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 390 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 2775 | 2775 | 253211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1858 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993493.0 | 2102864.0 | 37.753689940286606 | -122.465433828694 | (37.7536899402866, -122.465433828694) | ||||
| 3037 | 3037 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005929.0 | 2099335.0 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | ||||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 3812 | 3812 | 253561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | ||||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13687 | 13687 | 50152 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14108 | 14108 | 50151 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14733 | 14733 | 50153 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 14932 | 14932 | 50157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 15084 | 15084 | 50154 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 15431 | 15431 | 50155 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 215 REVISED Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.789084506842705 | -122.39483553069999 | (37.7890845068427, -122.3948355307) | |||
| 18564 | 18564 | 49087 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896516997 | 37.761118154139204 | -122.401300553818 | (37.7611181541392, -122.401300553818) | |||
| 18639 | 18639 | 61241 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.42961302050301 | (37.7580658175007, -122.429613020503) | ||
| 18641 | 18641 | 41156 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 455 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | |||
| 18688 | 18688 | 67850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 485 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769001 | 2098756.82734478 | 37.742941332905396 | -122.433177202226 | (37.7429413329054, -122.433177202226) | ||
| 18918 | 18918 | 109119 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 19019 | 19019 | 92526 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 275 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743.0 | 2109634.0 | 37.7731465224788 | -122.41317441235701 | (37.7731465224788, -122.413174412357) | ||
| 19406 | 19406 | 44045 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | |||
| 19413 | 19413 | 106117 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 405 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.721782813937395 | -122.433585385445 | (37.7217828139374, -122.433585385445) | |||
| 19494 | 19494 | 68790 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | ||
| 19619 | 19619 | 35520 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.754456203079705 | -122.422896805421 | (37.7544562030797, -122.422896805421) | ||
| 19635 | 19635 | 36019 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.744060284741295 | -122.419391331569 | (37.7440602847413, -122.419391331569) | ||
| 20468 | 20468 | 62857 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.740515170519295 | -122.412571078994 | (37.7405151705193, -122.412571078994) | ||
| 34307 | 34307 | 59035 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3367 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1980 12:00:00 AM | Permit Number 18327; Original species unknown. Removed and replaced without permit in 2000 | 6005902.92482081 | 2103717.90003873 | 37.7567424611364 | -122.42257813887699 | (37.7567424611364, -122.422578138877) | |||
| 38345 | 38345 | 66411 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2009 12:00:00 AM | 3x3 | Permit Number 52018 | 6006829.83812508 | 2097883.34846014 | 37.740774355435704 | -122.41895871773701 | (37.7407743554357, -122.418958717737) | ||
| 40003 | 40003 | 87230 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.760900766943294 | -122.489529520217 | (37.7609007669433, -122.489529520217) | ||
| 43358 | 43358 | 30913 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | ||
| 50091 | 50091 | 91455 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317.0 | 2117738.0 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | ||
| 51125 | 51125 | 44239 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 317 Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.751362099 | 2110406.95147967 | 37.7754389967998 | -122.40271728497801 | (37.7754389967998, -122.402717284978) | |||
| 51512 | 51512 | 104107 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.779581080700396 | -122.39259103594802 | (37.7795810807004, -122.392591035948) | |||
| 53179 | 53179 | 44191 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 61502 | 61502 | 32855 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37205 | 6000624.61627289 | 2102511.57259046 | 37.7531309843157 | -122.440745886867 | (37.7531309843157, -122.440745886867) | ||
| 63421 | 63421 | 40717 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 360 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41696 | 6008594.61699406 | 2097088.56935412 | 37.7386912826447 | -122.41280058004801 | (37.7386912826447, -122.412800580048) | ||
| 65302 | 65302 | 98961 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | ||||
| 66026 | 66026 | 52506 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | ||
| 66034 | 66034 | 84750 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 170 King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851.0 | 2111791.0 | 37.779410171003704 | -122.392196759897 | (37.7794101710037, -122.392196759897) | |||
| 69959 | 69959 | 51970 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.770941970108105 | -122.446512330156 | (37.7709419701081, -122.446512330156) | |||
| 70841 | 70841 | 84234 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | ||
| 75302 | 75302 | 37321 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 445 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41123 | 6003410.55922166 | 2103870.78228446 | 37.7570213149701 | -122.431208559798 | (37.7570213149701, -122.431208559798) | ||
| 77319 | 77319 | 66310 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | ||
| 77371 | 77371 | 44053 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | |||
| 77372 | 77372 | 91458 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 808 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295.0 | 2117692.0 | 37.795414833399796 | -122.404914113244 | (37.7954148333998, -122.404914113244) | ||
| 77543 | 77543 | 64364 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | ||
| 77593 | 77593 | 91453 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 680 WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317.0 | 2117738.0 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | ||
| 77673 | 77673 | 94289 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147.0 | 2103917.0 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | ||
| 77705 | 77705 | 35507 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | ||
| 77776 | 77776 | 39397 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 77965 | 77965 | 114296 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
| 78339 | 78339 | 36958 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 22 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39588 | 5994276.09301697 | 2115432.47686212 | 37.788244789102 | -122.46363785633001 | (37.788244789102, -122.46363785633) | ||
| 78621 | 78621 | 110937 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 98x WILMOT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003200.0 | 2115008.0 | 37.7875894402279 | -122.43273231813299 | (37.7875894402279, -122.432732318133) | ||||
| 78688 | 78688 | 91312 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 78724 | 78724 | 45340 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1335 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2001 12:00:00 AM | Permit Number 44170 | 6006996.02252299 | 2107706.14751942 | 37.767754866633 | -122.419080678059 | (37.767754866633, -122.419080678059) | |||
| 78995 | 78995 | 94288 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 901 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147.0 | 2103917.0 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | ||
| 79035 | 79035 | 40433 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 101 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1999 12:00:00 AM | Permit Number 41526 | 6007627.96125429 | 2098166.4451197 | 37.7415965860949 | -122.416219146331 | (37.7415965860949, -122.416219146331) | ||
| 79134 | 79134 | 44241 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 317 Harriet St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.751362099 | 2110406.95147967 | 37.7754389967998 | -122.40271728497801 | (37.7754389967998, -122.402717284978) | |||
| 79342 | 79342 | 63413 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 272 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23996 | 6001428.027807799 | 2104243.75473301 | 37.7579328590275 | -122.438091607798 | (37.7579328590275, -122.438091607798) | ||
| 79536 | 79536 | 46347 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1507 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44593 | 6002034.30683113 | 2099698.46160484 | 37.74548702850729 | -122.435669660946 | (37.7454870285073, -122.435669660946) | |||
| 79544 | 79544 | 68440 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 754 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49886 | 5993219.88276902 | 2113506.20153873 | 37.782894848692 | -122.467152027766 | (37.782894848692, -122.467152027766) | ||
| 79578 | 79578 | 84950 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1305 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
| 79609 | 79609 | 84752 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 170 King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851.0 | 2111791.0 | 37.779410171003704 | -122.392196759897 | (37.7794101710037, -122.392196759897) | |||
| 79674 | 79674 | 57165 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2616 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | |||
| 79735 | 79735 | 88396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.3051849995 | 2111648.444046 | 37.777498983924204 | -122.484616395841 | (37.7774989839242, -122.484616395841) | |||
| 79796 | 79796 | 66312 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.733577020231294 | -122.43763147167299 | (37.7335770202313, -122.437631471673) | ||
| 80099 | 80099 | 104103 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 55X Clarence Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.779581080700396 | -122.39259103594802 | (37.7795810807004, -122.392591035948) | |||
| 80157 | 80157 | 63415 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 278 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23998 | 6001429.88159377 | 2104210.13980699 | 37.757840666022 | -122.438082788745 | (37.757840666022, -122.438082788745) | ||
| 80703 | 80703 | 64626 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 116 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1988 12:00:00 AM | Permit Number 25535 | 6005375.93887889 | 2103023.58522731 | 37.7548062901099 | -122.424351269312 | (37.7548062901099, -122.424351269312) | ||
| 80743 | 80743 | 50587 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 843 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 3x3 | Permit Number 50206 | 6007574.72347532 | 2104752.94672334 | 37.759678635742205 | -122.416869761057 | (37.7596786357422, -122.416869761057) | ||
| 81117 | 81117 | 48370 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 81714 | 81714 | 84264 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 706 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51836 | 5988196.19681756 | 2111153.20352169 | 37.7761429127735 | -122.48435904478998 | (37.7761429127735, -122.48435904479) | ||
| 81793 | 81793 | 109519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4801X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999644.57626 | 2104777.09851 | 37.759295701171105 | -122.44429784106501 | (37.7592957011711, -122.444297841065) | |||||
| 81928 | 81928 | 31103 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34833 | 5999457.19750616 | 2094476.41110403 | 37.7310017996631 | -122.444205686044 | (37.7310017996631, -122.444205686044) | ||
| 81936 | 81936 | 64594 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3351 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31334 | 6006004.81140663 | 2103137.43294391 | 37.75515438070621 | -122.422184539111 | (37.7551543807062, -122.422184539111) | ||
| 81974 | 81974 | 46348 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1507 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44593 | 6002034.30683113 | 2099698.46160484 | 37.74548702850729 | -122.435669660946 | (37.7454870285073, -122.435669660946) | |||
| 81987 | 81987 | 44778 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 938 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941004 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | |||
| 82054 | 82054 | 85221 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1414 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011703.0 | 2101780.0 | 37.7517469232523 | -122.40238298191002 | (37.7517469232523, -122.40238298191) | |||||
| 82083 | 82083 | 50589 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 843 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 3x3 | Permit Number 50206 | 6007574.72347532 | 2104752.94672334 | 37.759678635742205 | -122.416869761057 | (37.7596786357422, -122.416869761057) | ||
| 82141 | 82141 | 91313 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 82149 | 82149 | 98423 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||
| 82206 | 82206 | 30729 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 45 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.42162786237301 | (37.7736338888904, -122.421627862373) | ||
| 82311 | 82311 | 60664 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 249 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20298 | 6004405.0967778 | 2096932.39684696 | 37.738026423282896 | -122.427274839887 | (37.7380264232829, -122.427274839887) | ||
| 82344 | 82344 | 67375 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 925 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30870 | 5992766.01724048 | 2111352.45754002 | 37.776955044154896 | -122.468565444785 | (37.7769550441549, -122.468565444785) | ||
| 82358 | 82358 | 44194 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 82562 | 82562 | 33757 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37810 | 6003402.50922955 | 2107448.70310464 | 37.766844969098 | -122.431491817447 | (37.766844969098, -122.431491817447) | |||
| 82694 | 82694 | 50226 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1200 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50896 | 5994559.80956371 | 2107356.04846138 | 37.7660854146632 | -122.46207032542802 | (37.7660854146632, -122.462070325428) | ||
| 82887 | 82887 | 44189 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 82999 | 82999 | 109123 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 83045 | 83045 | 65808 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28776 | 5991285.24152373 | 2099744.65687546 | 37.7449974586831 | -122.472841240296 | (37.7449974586831, -122.472841240296) | ||
| 83085 | 83085 | 93868 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4045 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53365 | 6002857.0 | 2102387.0 | 37.752915816888205 | -122.43301696909501 | (37.7529158168882, -122.433016969095) | ||
| 83127 | 83127 | 109613 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013158.0 | 2117662.0 | 37.7954364211004 | -122.39846567276699 | (37.7954364211004, -122.398465672767) | ||||
| 83327 | 83327 | 36915 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 514 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39561 | 6001810.86453824 | 2102841.54122149 | 37.7541044834193 | -122.43666722972 | (37.7541044834193, -122.43666722972) | ||
| 83581 | 83581 | 43568 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
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");