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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5529 | 5529 | 49969 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007906.3079699995 | 2112391.06257 | 37.780669751438296 | -122.416263956709 | (37.7806697514383, -122.416263956709) | ||
| 5544 | 5544 | 94108 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006327.235669999 | 2111080.72521 | 37.7769829645232 | -122.42163364139799 | (37.7769829645232, -122.421633641398) | |
| 5734 | 5734 | 28721 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004471.9612 | 2114982.8802 | 37.7875925229583 | -122.428329791837 | (37.7875925229583, -122.428329791837) | ||
| 5770 | 5770 | 26813 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001062.3024 | 2114325.3961 | 37.7855937173461 | -122.440079345712 | (37.7855937173461, -122.440079345712) | |||
| 5890 | 5890 | 14472 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 235 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 2X2 | 5998919.6038 | 2112167.2256 | 37.7795457275321 | -122.44733704131501 | (37.7795457275321, -122.447337041315) | ||
| 5917 | 5917 | 14486 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5998954.4612 | 2111920.5161 | 37.7788703187651 | -122.447198694655 | (37.7788703187651, -122.447198694655) | |||
| 5948 | 5948 | 13140 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1997 12:00:00 AM | 18 | 3X3 | 6003874.8006 | 2119664.6973 | 37.8004137877384 | -122.430730076432 | (37.8004137877384, -122.430730076432) | ||
| 6043 | 6043 | 10681 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002358.7398 | 2110530.7348 | 37.7752482530433 | -122.435322523233 | (37.7752482530433, -122.435322523233) | |||
| 6080 | 6080 | 55912 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 801 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770168 | 6007877.21664 | 2120606.58742 | 37.803225923789604 | -122.416946850615 | (37.8032259237896, -122.416946850615) | |
| 6168 | 6168 | 14501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 6 | 8 | 5999062.4864 | 2111159.5057 | 37.776786951926105 | -122.446770221959 | (37.7767869519261, -122.446770221959) | ||
| 6177 | 6177 | 14545 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999282.0507 | 2110078.3239 | 37.7738308435165 | -122.445932905938 | (37.7738308435165, -122.445932905938) | |||
| 6197 | 6197 | 23919 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | |||
| 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 | |||||||||
| 6285 | 6285 | 14483 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5998945.3239 | 2112016.2894 | 37.7791327654133 | -122.447237198812 | (37.7791327654133, -122.447237198812) | |||
| 6469 | 6469 | 5298 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 2X3 | 6001159.4674 | 2114123.3993 | 37.785044617067 | -122.439728696784 | (37.785044617067, -122.439728696784) | ||
| 6479 | 6479 | 10680 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1133 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002410.4328 | 2110539.1175 | 37.7752742053449 | -122.435144305311 | (37.7752742053449, -122.435144305311) | |||
| 6577 | 6577 | 28805 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999050.9428 | 2111235.5005 | 37.7769949546715 | -122.446815624115 | (37.7769949546715, -122.446815624115) | ||
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 6584 | 6584 | 10679 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002427.1981 | 2110540.5146 | 37.775278993428394 | -122.43508641032301 | (37.7752789934284, -122.435086410323) | |||
| 6595 | 6595 | 27496 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2005 12:00:00 AM | 6 | 8 | 5999036.5134 | 2111342.759 | 37.7772886346083 | -122.44687325959801 | (37.7772886346083, -122.446873259598) | ||
| 6627 | 6627 | 28722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004480.9191 | 2114982.5069999998 | 37.7875920051185 | -122.42829877265699 | (37.7875920051185, -122.428298772657) | ||
| 6731 | 6731 | 110156 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.41429181903601 | (37.7968393702849, -122.414291819036) | |
| 6768 | 6768 | 14500 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 8 | 8 | 5999057.6765 | 2111195.0982 | 37.7768844050144 | -122.446789422429 | (37.7768844050144, -122.446789422429) | ||
| 6832 | 6832 | 14547 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 810 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999284.7278 | 2110047.5378 | 37.7737464656007 | -122.4459214308 | (37.7737464656007, -122.4459214308) | |||
| 6853 | 6853 | 26814 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001067.2461 | 2114300.6778 | 37.785526128691295 | -122.440060468908 | (37.7855261286913, -122.440060468908) | |||
| 6864 | 6864 | 99895 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.5989599996 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | ||
| 6971 | 6971 | 53051 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1024 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51546 | 6009165.99693 | 2118045.4874299997 | 37.7962661873755 | -122.412305843439 | (37.7962661873755, -122.412305843439) | |
| 6985 | 6985 | 10684 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1161 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6002309.8411 | 2110524.4478 | 37.775228213443704 | -122.435491224879 | (37.7752282134437, -122.435491224879) | ||
| 7026 | 7026 | 94109 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.42156263632799 | (37.7769909819764, -122.421562636328) | |
| 7179 | 7179 | 14495 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 339 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 5998997.0731 | 2111620.7655 | 37.778049715609704 | -122.44702970697399 | (37.7780497156097, -122.447029706974) | |||
| 7216 | 7216 | 92890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | ||
| 7316 | 7316 | 27494 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 6 | 8 | 5999041.3232 | 2111309.0904 | 37.7771964640696 | -122.446854197732 | (37.7771964640696, -122.446854197732) | ||
| 7377 | 7377 | 26815 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001070.2123 | 2114280.9031 | 37.7854720013115 | -122.44004878829399 | (37.7854720013115, -122.440048788294) | |||
| 7432 | 7432 | 8194 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001422.3613 | 2111092.2721 | 37.7767368720245 | -122.43860190684799 | (37.7767368720245, -122.438601906848) | |||
| 7551 | 7551 | 108147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.43273393652399 | (37.800534134189, -122.432733936524) | ||
| 7718 | 7718 | 28806 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999054.7907 | 2111214.8184 | 37.7769383867596 | -122.446800824554 | (37.7769383867596, -122.446800824554) | ||
| 7767 | 7767 | 5249 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1135 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001356.9176 | 2112269.0905 | 37.7799643946727 | -122.438912650424 | (37.7799643946727, -122.438912650424) | ||
| 7929 | 7929 | 5252 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1149 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001343.3807 | 2112375.6934 | 37.7802563289851 | -122.43896712240499 | (37.7802563289851, -122.438967122405) | |||
| 7993 | 7993 | 14466 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998899.6369 | 2112323.9149 | 37.7799748148245 | -122.44741739632799 | (37.7799748148245, -122.447417396328) | |||
| 7997 | 7997 | 107779 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.798998111943604 | -122.44102375853599 | (37.7989981119436, -122.441023758536) | |
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 8029 | 8029 | 1717 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Battery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012534.63593 | 2117926.51881 | 37.7961279804624 | -122.400641221934 | (37.7961279804624, -122.400641221934) | |||
| 8104 | 8104 | 21713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 3 | 4X4 | 6003349.0279 | 2114538.6375 | 37.786309140387395 | -122.432183179125 | (37.7863091403874, -122.432183179125) | ||
| 8113 | 8113 | 75258 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.41221149286699 | (37.7840518741506, -122.412211492867) | |||
| 8122 | 8122 | 65944 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1051 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774496 | 6007126.88528 | 2114657.80083 | 37.7868498044193 | -122.419121190999 | (37.7868498044193, -122.419121190999) | |
| 8294 | 8294 | 7346 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2225 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2005 12:00:00 AM | 1 | 3X3 | 6002798.59801 | 2115979.15257 | 37.7902332041481 | -122.43419054146001 | (37.7902332041481, -122.43419054146) | ||
| 8333 | 8333 | 94110 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006363.6521 | 2111083.4813 | 37.7769925854655 | -122.421507861308 | (37.7769925854655, -122.421507861308) | |
| 8352 | 8352 | 5316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1823 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 5 | 2X3 | 6001019.2169 | 2114657.038 | 37.786501867674495 | -122.44025220015699 | (37.7865018676745, -122.440252200157) | ||
| 8411 | 8411 | 26812 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001060.3249 | 2114356.0469 | 37.785677763980395 | -122.44008838592801 | (37.7856777639804, -122.440088385928) | |||
| 8486 | 8486 | 27495 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999043.2471 | 2111289.3703 | 37.7771424276553 | -122.446846123038 | (37.7771424276553, -122.446846123038) | ||
| 8528 | 8528 | 28094 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 560 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001682.4646 | 2110397.1642 | 37.7748430729481 | -122.437652340718 | (37.7748430729481, -122.437652340718) | |||
| 8717 | 8717 | 26816 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001075.1559 | 2114260.1397 | 37.7854152717832 | -122.440030195581 | (37.7854152717832, -122.440030195581) | |||
| 8908 | 8908 | 33111 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.797185891667105 | -122.442801853125 | (37.7971858916671, -122.442801853125) | |
| 8944 | 8944 | 5220 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | ||
| 9214 | 9214 | 6542 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6017765.684627299 | 2096901.7583544997 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | ||
| 9500 | 9500 | 17808 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1900X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004382.775 | 2115429.5647 | 37.7888139592602 | -122.4286702126 | (37.7888139592602, -122.4286702126) | |||
| 9619 | 9619 | 17809 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004377.7264 | 2115455.3687 | 37.7888845248195 | -122.428689520238 | (37.7888845248195, -122.428689520238) | |||
| 10247 | 10247 | 46477 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10249 | 10249 | 46478 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 Erie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | ||
| 10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
| 10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 10662 | 10662 | 109045 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773398 | 6004900.5728400005 | 2093457.84722 | 37.728514095441604 | -122.42531455034799 | (37.7285140954416, -122.425314550348) | |
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 10783 | 10783 | 109058 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.190219999 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) |
| 11829 | 11829 | 19801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
| 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 | |||||||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 12587 | 12587 | 40943 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 337 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773706 | 6001124.10704 | 2092689.0932900002 | 37.726189192361005 | -122.438314913304 | (37.726189192361, -122.438314913304) | |
| 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 | |||||||||
| 12794 | 12794 | 95013 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.40564982910401 | (37.7118779294401, -122.405649829104) | ||||
| 12972 | 12972 | 92206 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.7684400002 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | |
| 13331 | 13331 | 128972 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 388 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | Width 3ft | 6005916.284109999 | 2111770.5884 | 37.778853979769394 | -122.42310429823 | (37.7788539797694, -122.42310429823) | ||
| 13334 | 13334 | 128971 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 388 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | Width 3ft | 6005955.06013 | 2111776.3287 | 37.778871929336795 | -122.422970564553 | (37.7788719293368, -122.422970564553) | ||
| 13338 | 13338 | 187686 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 388 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | 6005900.60365 | 2111761.43845 | 37.7788279713562 | -122.42315789265301 | (37.7788279713562, -122.423157892653) | |||
| 13383 | 13383 | 6551 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6017377.10796 | 2097187.95737 | 37.7394532248805 | -122.382441492395 | (37.7394532248805, -122.382441492395) | ||
| 13449 | 13449 | 108720 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.25551 | 2106680.42507 | 37.765205936725295 | -122.40250878917 | (37.7652059367253, -122.40250878917) |
| 13468 | 13468 | 6601 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.38530586818099 | (37.7413960662634, -122.385305868181) | ||
| 13649 | 13649 | 6451 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017878.64833 | 2096818.1638599997 | 37.738465537256495 | -122.38068166932399 | (37.7384655372565, -122.380681669324) | ||
| 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) | |||
| 13731 | 13731 | 34850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1016 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1997 12:00:00 AM | 8 | Permit Number 38472 | 6015493.82496 | 2104313.14645 | 37.7589132940426 | -122.38945057548099 | (37.7589132940426, -122.389450575481) | ||
| 13805 | 13805 | 25987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1867 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6013610.36867 | 2096507.3445599999 | 37.7373756146805 | -122.39541765280701 | (37.7373756146805, -122.395417652807) | |||
| 13847 | 13847 | 7403 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1052 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010579.4997 | 2111206.152 | 37.7775662166508 | -122.40693251939 | (37.7775662166508, -122.40693251939) | |||
| 13892 | 13892 | 108722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011765.777319999 | 2106711.15345 | 37.765290283256995 | -122.402512604068 | (37.765290283257, -122.402512604068) |
| 13976 | 13976 | 6449 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3X3 | 6017844.2154 | 2096842.4719 | 37.7385303819825 | -122.380802412295 | (37.7385303819825, -122.380802412295) | ||
| 13979 | 13979 | 25990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013804.269309999 | 2096361.3192200002 | 37.736985442024 | -122.39473701982 | (37.736985442024, -122.39473701982) | |||
| 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) | |||
| 14037 | 14037 | 6456 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2004 12:00:00 AM | 3 | 3X3 | 6017977.7328 | 2096742.9894400002 | 37.738264590924395 | -122.38033385651899 | (37.7382645909244, -122.380333856519) | ||
| 14064 | 14064 | 19797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 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) | |||
| 14138 | 14138 | 25914 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013877.589480001 | 2096388.75827 | 37.737064860262706 | -122.394485438074 | (37.7370648602627, -122.394485438074) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 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 | |||||||||
| 14271 | 14271 | 25992 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013845.47996 | 2096331.5621599997 | 37.7369060264874 | -122.39459245198299 | (37.7369060264874, -122.394592451983) | |||
| 14306 | 14306 | 6663 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1997 12:00:00 AM | 6 | 3X3 | 6015993.25804 | 2098345.2218299997 | 37.742554297736504 | -122.387306987444 | (37.7425542977365, -122.387306987444) | ||
| 14311 | 14311 | 4044 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | ||
| 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) |
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");