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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86515 | 86515 | 48833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.43421140278099 | (37.7535333013465, -122.434211402781) | |||
86777 | 86777 | 38531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | ||
87234 | 87234 | 61737 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | ||
87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
87658 | 87658 | 67603 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216001 | (37.7642517131045, -122.39677434216) | ||
87712 | 87712 | 50320 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3615 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | |||
88063 | 88063 | 33257 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | ||
88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
88327 | 88327 | 64256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | ||
88609 | 88609 | 67673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969015996 | -122.393277319642 | (37.733518969016, -122.393277319642) | ||
88651 | 88651 | 51518 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.731737008800394 | -122.44720311183701 | (37.7317370088004, -122.447203111837) | |||
88842 | 88842 | 66113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | ||
88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
89217 | 89217 | 34443 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.740509693537504 | -122.427643467723 | (37.7405096935375, -122.427643467723) | ||
89262 | 89262 | 33122 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.798541206544705 | -122.438525775033 | (37.7985412065447, -122.438525775033) | ||
89405 | 89405 | 31180 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | ||
89699 | 89699 | 50067 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 408 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46795 | 6003569.75244558 | 2105901.71860795 | 37.7626068007008 | -122.430802940638 | (37.7626068007008, -122.430802940638) | ||
90037 | 90037 | 68758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32681 | 6004133.43114203 | 2105726.5811326997 | 37.762157835439 | -122.42884089299999 | (37.762157835439, -122.428840893) | ||
90206 | 90206 | 51723 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1148 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2005 12:00:00 AM | Permit Number 47992 | 6008632.05923166 | 2101854.75826991 | 37.7517802835227 | -122.41300802824699 | (37.7517802835227, -122.413008028247) | ||
90373 | 90373 | 64794 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | ||
90541 | 90541 | 61342 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | ||
90603 | 90603 | 61344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.42721871600901 | (37.7748381087345, -122.427218716009) | ||
90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
90974 | 90974 | 37857 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | ||
91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
91732 | 91732 | 34299 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | ||
92174 | 92174 | 50672 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
92505 | 92505 | 36515 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.41911373442801 | (37.735074223818, -122.419113734428) | ||
92717 | 92717 | 49840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 626@ CASTRO 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2003 12:00:00 AM | Permit Number 46623 | 6002452.84285908 | 2100074.93808821 | 37.7465445086172 | -122.434249340793 | (37.7465445086172, -122.434249340793) | |||
92979 | 92979 | 66117 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.77602792540829 | -122.430248650411 | (37.7760279254083, -122.430248650411) | ||
93188 | 93188 | 40860 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42377 | 6007537.55147065 | 2099272.41006031 | 37.744628235414204 | -122.416610080854 | (37.7446282354142, -122.416610080854) | ||
93386 | 93386 | 41149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | |||
93635 | 93635 | 35001 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
93807 | 93807 | 43210 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 350 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 43001 | 6008795.91385 | 2094346.1745799999 | 37.7311725561519 | -122.41191084861299 | (37.7311725561519, -122.411910848613) | |
93949 | 93949 | 36079 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2170 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39193 | 6008724.90392173 | 2105792.20395445 | 37.7625968269406 | -122.412965325481 | (37.7625968269406, -122.412965325481) | ||
94027 | 94027 | 64512 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913003 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | ||
94117 | 94117 | 67164 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
94212 | 94212 | 36529 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3653 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39401 | 6008503.02776352 | 2097873.6031148 | 37.7408416720866 | -122.413172749536 | (37.7408416720866, -122.413172749536) | ||
94356 | 94356 | 33643 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 473 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37737 | 6005146.14820368 | 2110741.54826683 | 37.7759849973486 | -122.42569524360201 | (37.7759849973486, -122.425695243602) | |||
94386 | 94386 | 43365 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4245 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43115 | 6002281.52408985 | 2101178.21709517 | 37.7495641270708 | -122.434920630419 | (37.7495641270708, -122.434920630419) | ||
94512 | 94512 | 37474 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | ||
94760 | 94760 | 67088 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | ||
95100 | 95100 | 49583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
95313 | 95313 | 34169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39486 | 6005390.32082668 | 2104325.33751818 | 37.758381409843295 | -122.424394116765 | (37.7583814098433, -122.424394116765) | ||
95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
95504 | 95504 | 38702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1508 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40610 | 6001927.2408902 | 2111561.6017671 | 37.7780542409849 | -122.436888988053 | (37.7780542409849, -122.436888988053) | ||
95511 | 95511 | 49584 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | ||
95514 | 95514 | 63606 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | ||
95639 | 95639 | 69196 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1463 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33243 | 6009335.03931842 | 2100741.36404906 | 37.7487625875096 | -122.410498405401 | (37.7487625875096, -122.410498405401) | ||
95772 | 95772 | 67793 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4381 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31435 | 6001427.36985446 | 2101130.88060421 | 37.7493856180132 | -122.437870927363 | (37.7493856180132, -122.437870927363) | ||
96037 | 96037 | 67840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3848 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31508 | 6004878.46361538 | 2100495.10573235 | 37.7478355684339 | -122.425891704855 | (37.7478355684339, -122.425891704855) | ||
96226 | 96226 | 32739 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.45718507236099 | (37.7148491391882, -122.457185072361) | ||
96266 | 96266 | 50321 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3615 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | |||
96566 | 96566 | 52598 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | |||
96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
96769 | 96769 | 36919 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
96770 | 96770 | 39100 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3376 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40789 | 6006536.85037285 | 2102635.06060624 | 37.7538049769481 | -122.42030893490299 | (37.7538049769481, -122.420308934903) | ||
96828 | 96828 | 68073 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31811 | 5993016.05828809 | 2103198.83445662 | 37.7545817907356 | -122.46710752853501 | (37.7545817907356, -122.467107528535) | ||
97186 | 97186 | 30761 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781002 | 37.7300780049156 | -122.39085502491999 | (37.7300780049156, -122.39085502492) | ||
97815 | 97815 | 67367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.47138413483101 | (37.7764470789457, -122.471384134831) | ||
97900 | 97900 | 36509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.41568718150499 | (37.7342833425639, -122.415687181505) | ||
98056 | 98056 | 111844 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||||
98224 | 98224 | 40633 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
98266 | 98266 | 30758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | ||
98289 | 98289 | 38068 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001654.0 | 2114215.0 | 37.7853242650019 | -122.438024337369 | (37.7853242650019, -122.438024337369) | |||
98885 | 98885 | 38501 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.797409229816104 | -122.42046789447399 | (37.7974092298161, -122.420467894474) | ||
99215 | 99215 | 64665 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 933 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/1991 12:00:00 AM | Permit Number 25595 | 6006330.05327332 | 2104167.32767008 | 37.7580005727281 | -122.42113288094 | (37.7580005727281, -122.42113288094) | ||
99531 | 99531 | 37020 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1061 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39632 | 6008655.69574399 | 2102373.47059511 | 37.7532058777371 | -122.412962961361 | (37.7532058777371, -122.412962961361) | ||
99576 | 99576 | 68703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2081 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32615 | 6003689.8407303 | 2107120.9618086996 | 37.7659613518454 | -122.430474597791 | (37.7659613518454, -122.430474597791) | ||
99648 | 99648 | 67774 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31407 | 6003128.8589186 | 2108744.804056 | 37.7703882320696 | -122.43253091541 | (37.7703882320696, -122.43253091541) | ||
99774 | 99774 | 69125 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | ||
100021 | 100021 | 51951 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | Permit Number 48175 | 6001005.9274955 | 2106259.83007157 | 37.7634444939099 | -122.439695940154 | (37.7634444939099, -122.439695940154) | |||
100490 | 100490 | 46891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1442 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44947 | 5993067.98197095 | 2105653.75631803 | 37.7613253640923 | -122.46710643924999 | (37.7613253640923, -122.46710643925) | |||
100570 | 100570 | 66876 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30186 | 6001155.37730733 | 2104574.8455135 | 37.7588264440048 | -122.439058274593 | (37.7588264440048, -122.439058274593) | ||
100643 | 100643 | 61746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21752 | 6004713.22212882 | 2100726.95185307 | 37.7484628246013 | -122.426479608106 | (37.7484628246013, -122.426479608106) | ||
100685 | 100685 | 61745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21751 | 6005058.850293 | 2101091.32092731 | 37.7494828305195 | -122.42531035662901 | (37.7494828305195, -122.425310356629) | ||
100858 | 100858 | 67803 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 211 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776671 | 6003788.24539392 | 2100967.25400369 | 37.7490703054266 | -122.429695296026 | (37.7490703054266, -122.429695296026) | ||
101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
101308 | 101308 | 43731 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | ||
101652 | 101652 | 45035 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2306 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43925 | 6002524.20413383 | 2117822.12502906 | 37.7952779539251 | -122.435271803602 | (37.7952779539251, -122.435271803602) | |||
101744 | 101744 | 39506 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
101869 | 101869 | 66237 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.72010089980329 | -122.45740432201 | (37.7201008998033, -122.45740432201) | ||
101954 | 101954 | 53006 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3647@ VALENCIA 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2006 12:00:00 AM | Permit Number 48989 | 6005992.69388586 | 2104306.67920181 | 37.7583641756106 | -122.42230951546999 | (37.7583641756106, -122.42230951547) | ||
101981 | 101981 | 41993 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.46447296226299 | (37.7278059137082, -122.464472962263) | ||
102320 | 102320 | 35681 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41986 | 6000920.86314017 | 2101102.84545022 | 37.749279824800794 | -122.43962042595899 | (37.7492798248008, -122.439620425959) | |||
102349 | 102349 | 34758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | |
102450 | 102450 | 67937 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.734595316364796 | -122.427417358908 | (37.7345953163648, -122.427417358908) | ||
102710 | 102710 | 43223 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1303 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | Permit Number 44301 | 6009289.62355935 | 2101563.81507978 | 37.7510183090213 | -122.410713527989 | (37.7510183090213, -122.410713527989) | ||
102717 | 102717 | 42112 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
102879 | 102879 | 33133 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3016 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37363 | 6001491.05795368 | 2118756.44455004 | 37.7977846260596 | -122.438913636839 | (37.7977846260596, -122.438913636839) | ||
103248 | 103248 | 43143 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 140 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42956 | 6005786.06556581 | 2093081.91758291 | 37.7275318626033 | -122.42222665307399 | (37.7275318626033, -122.422226653074) | ||
103259 | 103259 | 33256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | |||
103294 | 103294 | 43707 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
103358 | 103358 | 66155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | ||
103431 | 103431 | 32273 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36859 | 5998193.43438826 | 2108958.37890696 | 37.7706935405733 | -122.449617870473 | (37.7706935405733, -122.449617870473) | |||
103463 | 103463 | 61742 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 33 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24596 | 6004949.79749465 | 2101033.09819364 | 37.7493168026727 | -122.425683321129 | (37.7493168026727, -122.425683321129) | ||
103621 | 103621 | 33192 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 53 Idora Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37399 | 5996322.19797653 | 2099597.08028102 | 37.7448825563847 | -122.455413791656 | (37.7448825563847, -122.455413791656) | ||
103637 | 103637 | 66324 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.733164213776796 | -122.439505779041 | (37.7331642137768, -122.439505779041) | ||
103932 | 103932 | 56190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 769105 | 6003484.93305407 | 2101537.01707568 | 37.750617561594204 | -122.43078480700399 | (37.7506175615942, -122.430784807004) | ||
104133 | 104133 | 64176 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.727002217924706 | -122.466730800624 | (37.7270022179247, -122.466730800624) |
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");