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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14011 | 14011 | 4036 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011851.38946 | 2100896.5951099996 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | |||
| 14312 | 14312 | 115576 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 900X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6015313.29826 | 2096960.63807 | 37.7387148347127 | -122.389561431329 | (37.7387148347127, -122.389561431329) | |||
| 14402 | 14402 | 7408 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1070X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010493.6316 | 2111129.8248 | 37.7773518347 | -122.40722418556801 | (37.7773518347, -122.407224185568) | |||
| 14541 | 14541 | 25985 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1899 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6013478.7737300005 | 2096605.16178 | 37.737636880348894 | -122.395879493351 | (37.7376368803489, -122.395879493351) | |||
| 14688 | 14688 | 108710 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011387.70807 | 2106529.33414 | 37.764769934605205 | -122.40380746863998 | (37.7647699346052, -122.40380746864) |
| 14843 | 14843 | 25988 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1863 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 07:57:00 AM | 3 | 3X3 | 6013632.3496 | 2096491.11087 | 37.737332262873295 | -122.395340517063 | (37.7373322628733, -122.395340517063) | ||
| 14899 | 14899 | 75407 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 194X Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1995 12:00:00 AM | 4 | 5x5 | 6010525.12192 | 2111307.03338 | 37.7778401704149 | -122.40712774406299 | (37.7778401704149, -122.407127744063) | ||
| 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) | |||
| 15059 | 15059 | 7393 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1058 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010566.1424 | 2111194.703 | 37.777534032927605 | -122.406977919834 | (37.7775340329276, -122.406977919834) | |||
| 15136 | 15136 | 6556 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1295 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1997 12:00:00 AM | 3 | 3X3 | 6017308.64895 | 2097239.18487 | 37.7395901034918 | -122.382681759772 | (37.7395901034918, -122.382681759772) | ||
| 15186 | 15186 | 25911 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2014 12:00:00 AM | 3 | 3X3 | 6013940.91022 | 2096342.20585 | 37.7369405568534 | -122.39426324976101 | (37.7369405568534, -122.394263249761) | ||
| 15246 | 15246 | 7387 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1034 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010706.5406 | 2111333.1971 | 37.7779221608577 | -122.40650199464899 | (37.7779221608577, -122.406501994649) | |||
| 15329 | 15329 | 83441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 3x3 | 6014074.068940001 | 2105534.94834 | 37.7621892769404 | -122.39444634273899 | (37.7621892769404, -122.394446342739) | |
| 15435 | 15435 | 7420 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1095 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6010426.8513 | 2110979.2324 | 37.7769346055078 | -122.407444582017 | (37.7769346055078, -122.407444582017) | |||
| 15446 | 15446 | 62467 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 710 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22636 | 6011241.19795 | 2104960.20112 | 37.760453261625 | -122.404203766595 | (37.760453261625, -122.404203766595) | |
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15495 | 15495 | 7411 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1085 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010439.592999999 | 2110990.8158 | 37.7769671239898 | -122.40740132117901 | (37.7769671239898, -122.407401321179) | |||
| 15575 | 15575 | 25986 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1889 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6013508.76181 | 2096582.47787 | 37.737576263320896 | -122.39577422051201 | (37.7375762633209, -122.395774220512) | |||
| 16209 | 16209 | 27243 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1877 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6013583.54144 | 2096526.75062 | 37.737427407546605 | -122.395511766876 | (37.7374274075466, -122.395511766876) | |||
| 16441 | 16441 | 34987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | Permit Number 41601 | 6011225.3523699995 | 2111221.4707400003 | 37.7776443970062 | -122.404699365001 | (37.7776443970062, -122.404699365001) | |||
| 16490 | 16490 | 35340 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 806 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2014 12:00:00 AM | 2 | 3x9 | Permit Number 771129 | 6013025.881440001 | 2103324.95192 | 37.7560627857975 | -122.39791661515699 | (37.7560627857975, -122.397916615157) |
| 16561 | 16561 | 108719 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 479 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773098 | 6014398.610859999 | 2104906.56094 | 37.760481897828996 | -122.393279892377 | (37.760481897829, -122.393279892377) |
| 16641 | 16641 | 19305 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 345 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/2002 12:00:00 AM | 20 | 3X3 | 6010549.63293 | 2110708.85281 | 37.7761990776491 | -122.407000778664 | (37.7761990776491, -122.407000778664) | ||
| 16835 | 16835 | 31840 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1175 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774358 | 6009887.2147 | 2110463.0079 | 37.7754869546364 | -122.40927492061 | (37.7754869546364, -122.40927492061) | |
| 16883 | 16883 | 6447 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.6700099998 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | ||
| 16989 | 16989 | 5648 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.6422099997 | 37.748518548492996 | -122.424698417605 | (37.748518548493, -122.424698417605) | ||
| 17150 | 17150 | 5176 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1993 12:00:00 AM | 3 | 3x3 | 6001777.7698 | 2109730.6414 | 37.7730183862506 | -122.43727492563801 | (37.7730183862506, -122.437274925638) | ||
| 17210 | 17210 | 559 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2933 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009274.565719999 | 2102151.76119 | 37.7526318334984 | -122.410807118757 | (37.7526318334984, -122.410807118757) | |||
| 17317 | 17317 | 5713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005337.04528 | 2098854.62727 | 37.743357094669705 | -122.424189297907 | (37.7433570946697, -122.424189297907) | |||
| 17370 | 17370 | 4879 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 72 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1992 12:00:00 AM | 20 | 3X3 | 6000878.308119999 | 2097936.4399200003 | 37.7405832050459 | -122.43954062270001 | (37.7405832050459, -122.4395406227) | ||
| 17388 | 17388 | 14569 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1040 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1992 12:00:00 AM | 3 | 3X3 | 5999387.9901 | 2109254.1467 | 37.771573911131505 | -122.445507169781 | (37.7715739111315, -122.445507169781) | ||
| 17432 | 17432 | 5700 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1574 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1999 12:00:00 AM | 6 | 3X3 | 6005230.11909 | 2099176.7707599998 | 37.744235589305504 | -122.42458193203001 | (37.7442355893055, -122.42458193203) | ||
| 17569 | 17569 | 28711 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 440 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002289.61591 | 2105651.86805 | 37.7618481595902 | -122.435212593097 | (37.7618481595902, -122.435212593097) | |
| 17714 | 17714 | 27405 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 565 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 772904 | 6002394.6431 | 2104905.5260400004 | 37.759804848628505 | -122.434795972256 | (37.7598048486285, -122.434795972256) | ||
| 17752 | 17752 | 26195 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 557 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6002393.72921 | 2104942.16524 | 37.759905399136706 | -122.43480175309799 | (37.7599053991367, -122.434801753098) | |||
| 17787 | 17787 | 4371 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1006 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6000975.48263 | 2096188.08245 | 37.7357881547849 | -122.439079358629 | (37.7357881547849, -122.439079358629) | ||
| 17796 | 17796 | 14560 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1014 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 6 | 3X3 | 5999375.3597 | 2109336.577 | 37.77179952275971 | -122.44555678736401 | (37.7717995227597, -122.445556787364) | ||
| 17877 | 17877 | 25991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1821 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | 3 | 3X3 | 6013865.62853 | 2096292.13024 | 37.736798874724705 | -122.394520028611 | (37.7367988747247, -122.394520028611) | ||
| 18042 | 18042 | 19073 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 207 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5994916.47783 | 2087386.7478599998 | 37.7112751808846 | -122.45939037256299 | (37.7112751808846, -122.459390372563) | |||
| 18182 | 18182 | 4251 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4051 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1999 12:00:00 AM | 3 | 3X3 | 6003561.43732 | 2100376.51565 | 37.7474354302209 | -122.43043745653799 | (37.7474354302209, -122.430437456538) | ||
| 18330 | 18330 | 19101 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 286 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994132.39945 | 2087476.81693 | 37.7114773763557 | -122.462106852145 | (37.7114773763557, -122.462106852145) | ||
| 18411 | 18411 | 651 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3254 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2013 12:00:00 AM | 3 | 3x3 | 6007303.38124 | 2102084.9566099998 | 37.7523376805636 | -122.417619101966 | (37.7523376805636, -122.417619101966) | ||
| 18543 | 18543 | 5714 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1632 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/05/2012 12:00:00 AM | 3 | 4X4 | 6005246.5883 | 2098847.7434900003 | 37.7433330854531 | -122.424501585686 | (37.7433330854531, -122.424501585686) | ||
| 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) | ||
| 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) | ||
| 18692 | 18692 | 4870 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 43 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | 6 | 2X2 | 6000851.2827699995 | 2098123.40175 | 37.741095020030606 | -122.439647465779 | (37.7410950200306, -122.439647465779) | ||
| 18751 | 18751 | 27419 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6004586.23606 | 2099113.6008599997 | 37.744025754982204 | -122.426803843839 | (37.7440257549822, -122.426803843839) | |||
| 18771 | 18771 | 26176 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 491 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1998 12:00:00 AM | 3 | 3X3 | 6002367.6851 | 2105408.3391400003 | 37.761183921211604 | -122.434925166173 | (37.7611839212116, -122.434925166173) | ||
| 18869 | 18869 | 564 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2951 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2013 12:00:00 AM | 3 | 3x3 | 6009194.66362 | 2102148.83507 | 37.7526193185392 | -122.41108322860799 | (37.7526193185392, -122.411083228608) | ||
| 18893 | 18893 | 7422 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 8 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 19014 | 19014 | 26269 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2766 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 10 | 6x3 | 6008916.8205 | 2102350.42962 | 37.7531572668935 | -122.412058307761 | (37.7531572668935, -122.412058307761) | ||
| 19031 | 19031 | 24375 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 157 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/1995 12:00:00 AM | 3 | 3X3 | 6005685.52651 | 2108441.07828 | 37.76969892539 | -122.423665789951 | (37.76969892539, -122.423665789951) | ||
| 19077 | 19077 | 7640 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3284 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/1997 12:00:00 AM | 18 | 3X3 | 6008438.31331 | 2099539.68172 | 37.7454127227234 | -122.41351431286199 | (37.7454127227234, -122.413514312862) | ||
| 19371 | 19371 | 24367 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 128 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1995 12:00:00 AM | 3 | 3X3 | 6005866.15692 | 2108517.99575 | 37.7699203168954 | -122.423046461931 | (37.7699203168954, -122.423046461931) | ||
| 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) | |||
| 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) | ||
| 19594 | 19594 | 5690 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1542 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005216.26062 | 2099398.74761 | 37.7448443044129 | -122.42464563910299 | (37.7448443044129, -122.424645639103) | |||
| 19609 | 19609 | 26187 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 544 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 772904 | 6002327.02209 | 2105030.51765 | 37.7601442059996 | -122.435038779317 | (37.7601442059996, -122.435038779317) | ||
| 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) | ||
| 19769 | 19769 | 5716 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1634 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005250.99581 | 2098818.0906700003 | 37.7432519144591 | -122.424484236873 | (37.7432519144591, -122.424484236873) | |||
| 19791 | 19791 | 94114 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.776796051568105 | -122.421586361388 | (37.7767960515681, -122.421586361388) | |
| 19831 | 19831 | 14602 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1260 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999494.0179 | 2108475.6497 | 37.769442407658794 | -122.44508443819299 | (37.7694424076588, -122.445084438193) | |||
| 19872 | 19872 | 24354 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 171 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2000 12:00:00 AM | 3 | 3X3 | 6005631.29748 | 2108432.71018 | 37.7696728873349 | -122.423852771601 | (37.7696728873349, -122.423852771601) | ||
| 19966 | 19966 | 26189 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 558 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | Permit Number 772904 | 6002332.94084 | 2104952.9933599997 | 37.7599316791142 | -122.43501276463999 | (37.7599316791142, -122.43501276464) | ||
| 20023 | 20023 | 19099 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 280 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 6 | 3X4 | 5994211.21795 | 2087475.1642900002 | 37.7114773763499 | -122.46183431709801 | (37.7114773763499, -122.461834317098) | ||
| 20061 | 20061 | 10090 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 707 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 2X2 | Permit Number 777732 | 6005659.80497 | 2104809.7574 | 37.7597267272239 | -122.423496559112 | (37.7597267272239, -122.423496559112) | |
| 20155 | 20155 | 29899 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 584 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2008 12:00:00 AM | 3 | 3x3 | 6002334.75253 | 2104838.51742 | 37.7596174587106 | -122.434998311621 | (37.7596174587106, -122.434998311621) | ||
| 20160 | 20160 | 27378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1485 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2003 12:00:00 AM | 3 | 3X3 | 6005287.60025 | 2099703.3648200002 | 37.7456847424685 | -122.42442062241001 | (37.7456847424685, -122.42442062241) | ||
| 20188 | 20188 | 26185 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 536 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | Permit Number 772904 | 6002326.06883 | 2105085.46733 | 37.760295030403796 | -122.43504600627199 | (37.7602950304038, -122.435046006272) | ||
| 20217 | 20217 | 24370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 170 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6005596.0231800005 | 2108503.96371 | 37.7698665410346 | -122.423979852088 | (37.7698665410346, -122.423979852088) | ||
| 20418 | 20418 | 5151 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2002 12:00:00 AM | 3 | 3X3 | 6001783.9539 | 2109206.4501 | 37.7715794389957 | -122.437215994595 | (37.7715794389957, -122.437215994595) | ||
| 20440 | 20440 | 25339 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 221 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2001 12:00:00 AM | 3 | 3X3 | 5994735.55505 | 2087387.95343 | 37.711268087013 | -122.460015770114 | (37.711268087013, -122.460015770114) | ||
| 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) | ||
| 20497 | 20497 | 5491 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 730 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6004960.448369999 | 2104097.58597 | 37.7577317737189 | -122.425864595473 | (37.7577317737189, -122.425864595473) | ||
| 20508 | 20508 | 5739 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1747 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6005368.013730001 | 2098244.45158 | 37.7416834392278 | -122.424038834141 | (37.7416834392278, -122.424038834141) | |||
| 20682 | 20682 | 26190 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 570 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | Permit Number 772904 | 6002334.13017 | 2104929.66491 | 37.7598676923594 | -122.435006982882 | (37.7598676923594, -122.435006982882) | ||
| 20684 | 20684 | 4190 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3859 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004814.55251 | 2100443.91383 | 37.7476913952396 | -122.426109062696 | (37.7476913952396, -122.426109062696) | |||
| 20797 | 20797 | 19068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 197 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1997 12:00:00 AM | 6 | 3X3 | 5995078.75797 | 2087384.27088 | 37.71127770888 | -122.458829316129 | (37.71127770888, -122.458829316129) | ||
| 21003 | 21003 | 4174 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3809 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6005074.45285 | 2100459.68403 | 37.7477493826385 | -122.425211462866 | (37.7477493826385, -122.425211462866) | ||
| 21089 | 21089 | 14565 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1025 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | 22 | 3X3 | 5999322.9758 | 2109286.4848 | 37.7716589915577 | -122.44573438309799 | (37.7716589915577, -122.445734383098) | ||
| 21172 | 21172 | 26178 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 452 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2012 12:00:00 AM | 3 | 3x3 | 6002295.77959 | 2105586.45339 | 37.7616688968205 | -122.435186596394 | (37.7616688968205, -122.435186596394) | ||
| 21304 | 21304 | 5736 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1735 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005366.76903 | 2098271.84228 | 37.74175857761 | -122.424045085308 | (37.74175857761, -122.424045085308) | |||
| 21316 | 21316 | 26179 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 456 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | Permit Number 772904 | 6002297.11401 | 2105570.20774 | 37.761624365983 | -122.435180819163 | (37.761624365983, -122.435180819163) | ||
| 21319 | 21319 | 5526 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 879 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005088.52719 | 2103266.35336 | 37.755456640933104 | -122.42536249410699 | (37.7554566409331, -122.425362494107) | |||
| 21362 | 21362 | 26191 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 580 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 772904 | 6002334.37304 | 2104860.5809 | 37.75967801814971 | -122.435001202052 | (37.7596780181497, -122.435001202052) | ||
| 21390 | 21390 | 4433 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1238 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2008 12:00:00 AM | 3 | 3X3 | 6004437.55444 | 2101698.90078 | 37.7511159830235 | -122.427502095444 | (37.7511159830235, -122.427502095444) | ||
| 21451 | 21451 | 26180 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 3 | 3x3 | Permit Number 772904 | 6002298.3386699995 | 2105467.88483 | 37.7613434816312 | -122.43516926466299 | (37.7613434816312, -122.435169264663) | |
| 21561 | 21561 | 5596 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101-1103 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1994 12:00:00 AM | 8 | 3X3 | 6005167.29973 | 2101906.50174 | 37.7517272549302 | -122.424993326899 | (37.7517272549302, -122.424993326899) | ||
| 21571 | 21571 | 5603 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1126 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 3 | 3x3 | 6005088.2583099995 | 2101777.30613 | 37.7513680486157 | -122.425257470357 | (37.7513680486157, -122.425257470357) | ||
| 21678 | 21678 | 24374 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 214 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2001 12:00:00 AM | 3 | 3X3 | 6005312.220819999 | 2108489.8837599996 | 37.7698118541611 | -122.424960516937 | (37.7698118541611, -122.424960516937) | ||
| 21682 | 21682 | 24352 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/1995 12:00:00 AM | 3 | 3X3 | 6005552.77434 | 2108427.90971 | 37.7696552731946 | -122.42412403948799 | (37.7696552731946, -122.424124039488) | ||
| 21763 | 21763 | 29900 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 462 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2006 12:00:00 AM | 3 | 3x3 | 6002297.37769 | 2105522.3804 | 37.7614930586819 | -122.435176486218 | (37.7614930586819, -122.435176486218) | ||
| 21773 | 21773 | 22838 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 112 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2000 12:00:00 AM | 3 | 2X2 | 5999650.5418300005 | 2098943.83579 | 37.7432793203754 | -122.44385811046301 | (37.7432793203754, -122.443858110463) | ||
| 21801 | 21801 | 26184 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 532 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002322.81714 | 2105110.08666 | 37.76036244449121 | -122.435059013157 | (37.7603624444912, -122.435059013157) | |||
| 21958 | 21958 | 29924 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 288X Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5994099.1729 | 2087478.19658 | 37.711479251434604 | -122.462221790909 | (37.7114792514346, -122.462221790909) | |||
| 22033 | 22033 | 14574 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999367.196 | 2108956.8623 | 37.7707564564018 | -122.445557716473 | (37.7707564564018, -122.445557716473) | |||
| 22168 | 22168 | 657 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.752342620515705 | -122.41768158684602 | (37.7523426205157, -122.417681586846) | |||
| 22169 | 22169 | 5735 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1731 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2008 12:00:00 AM | 50 | 3x3 | 6005365.9005 | 2098299.94514 | 37.7418356926592 | -122.424050086446 | (37.7418356926592, -122.424050086446) |
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");