Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105438 | 105438 | 53937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 174 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 12 | 3x4 | Permit Number 9651 | 5993070.40109 | 2114326.65829 | 37.7851389689099 | -122.467728857293 | (37.7851389689099, -122.467728857293) | |
| 11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 1635 | 1635 | 251542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Vista Ln | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 780127 | 5999350.0 | 2102347.0 | 37.752606437592604 | -122.445141915929 | (37.7526064375926, -122.445141915929) | ||||
| 2188 | 2188 | 124801 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2898 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | Permit Number 780062 | 5999229.08983 | 2118053.40815 | 37.7957253216105 | -122.446690033314 | (37.7957253216105, -122.446690033314) | ||
| 2189 | 2189 | 124797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.795762957336706 | -122.446414930702 | (37.7957629573367, -122.446414930702) | |
| 4840 | 4840 | 64237 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.778793995563895 | -122.48794601676599 | (37.7787939955639, -122.487946016766) | |
| 2037 | 2037 | 124755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2040 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | Permit Number 779873 | 6003722.50351 | 2117641.05418 | 37.794848756005 | -122.431112566798 | (37.794848756005, -122.431112566798) | ||
| 1399 | 1399 | 116632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2332 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 17 | 3x3 | Permit Number 779740 | 5991403.36215 | 2112037.8136299998 | 37.7787580362874 | -122.473329239514 | (37.7787580362874, -122.473329239514) | |
| 2394 | 2394 | 125087 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 2440 | 2440 | 125088 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 10078 | 10078 | 121575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57-59 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | 6x8 | Permit Number 779439 | 5991428.0 | 2114866.0 | 37.786524881607 | -122.473450350287 | (37.786524881607, -122.473450350287) | |
| 10031 | 10031 | 121152 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10032 | 10032 | 122739 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10040 | 10040 | 122740 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 72373 | 72373 | 122576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1910 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 779012 | 5986951.5849 | 2102234.0134 | 37.75158073125021 | -122.48800892313601 | (37.7515807312502, -122.488008923136) | ||
| 9971 | 9971 | 121203 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3041 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778902 | 5999408.34577 | 2119299.99025 | 37.7991583414361 | -122.446159489987 | (37.7991583414361, -122.446159489987) | ||
| 769 | 769 | 110848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | ||
| 7056 | 7056 | 110847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.44110318127599 | (37.7945324365719, -122.441103181276) | |
| 12213 | 12213 | 115358 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 353 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778572 | 6001795.91538 | 2087927.53278 | 37.713153200931295 | -122.435652007258 | (37.7131532009313, -122.435652007258) | |
| 3941 | 3941 | 116781 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778230 | 5997601.127169999 | 2115625.0178 | 37.788964483784106 | -122.452147749912 | (37.7889644837841, -122.452147749912) | |
| 102473 | 102473 | 95360 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 111421 | 111421 | 95362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
| 112944 | 112944 | 95359 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 114297 | 114297 | 95361 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 118079 | 118079 | 95358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 25 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 86461 | 86461 | 116455 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2728 GREEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 778010 | 5999979.0 | 2117809.0 | 37.7950970500966 | -122.444077646155 | (37.7950970500966, -122.444077646155) | ||
| 90833 | 90833 | 110556 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 600 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987238.02071 | 2111776.2872900004 | 37.777797885239295 | -122.48771937722401 | (37.7777978852393, -122.487719377224) | |
| 122094 | 122094 | 110557 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 600 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987235.91404 | 2111803.79765 | 37.7778732980336 | -122.487728686455 | (37.7778732980336, -122.487728686455) | |
| 88642 | 88642 | 51704 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2016 12:00:00 AM | 3 | Permit Number 777735 | 6001742.29918465 | 2107821.21142041 | 37.767773548810204 | -122.437260877297 | (37.7677735488102, -122.437260877297) | ||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 164031 | 164031 | 115561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 4x10 | Permit Number 777606 | 5989293.97789 | 2114922.2794 | 37.7865556002814 | -122.48083757606899 | (37.7865556002814, -122.480837576069) | ||
| 8469 | 8469 | 46251 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.44314853640101 | (37.7950986884031, -122.443148536401) | ||
| 6029 | 6029 | 112618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | |
| 6686 | 6686 | 114571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777013 | 5997418.550890001 | 2115712.12008 | 37.7891931831629 | -122.452785725389 | (37.7891931831629, -122.452785725389) | ||
| 78411 | 78411 | 114572 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3633 WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 777013 | 5997417.0 | 2115685.0 | 37.7891186297883 | -122.452789133032 | (37.7891186297883, -122.452789133032) | ||
| 155131 | 155131 | 115073 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2263 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 24 | 3x3 | Permit Number 777001 | 6003883.69661 | 2116609.10432 | 37.7920244180358 | -122.430481149195 | (37.7920244180358, -122.430481149195) | |
| 108149 | 108149 | 113660 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3060 JACKSON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 776720 | 5999534.0 | 2116404.0 | 37.7912138957856 | -122.44551632933901 | (37.7912138957856, -122.445516329339) | |||
| 2230 | 2230 | 112042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 17 | 3x3 | Permit Number 776583 | 6002409.604230001 | 2117108.01013 | 37.79331067070571 | -122.435617223266 | (37.7933106707057, -122.435617223266) | |
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 103709 | 103709 | 113061 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2775 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776016 | 6000301.4 | 2117440.5 | 37.7941036326689 | -122.442935620895 | (37.7941036326689, -122.442935620895) | |||
| 17186 | 17186 | 1368 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.746187905058896 | -122.445863385507 | (37.7461879050589, -122.445863385507) | ||
| 21467 | 21467 | 1367 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.2299099998 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | ||
| 7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
| 145989 | 145989 | 98513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.723869304698404 | -122.459376132933 | (37.7238693046984, -122.459376132933) | ||
| 109092 | 109092 | 115175 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1899X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x20 | Permit Number 775764 | 5993756.36006 | 2102907.65397 | 37.7538249882276 | -122.464526247261 | (37.7538249882276, -122.464526247261) | |||
| 119956 | 119956 | 111044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1635 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x10 | Permit Number 775721 | 5995557.0 | 2094802.0 | 37.731672507077896 | -122.457712790279 | (37.7316725070779, -122.457712790279) | |||
| 111033 | 111033 | 111337 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.47368930100001 | (37.7473430166558, -122.473689301) | |
| 123109 | 123109 | 103476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | |||
| 138494 | 138494 | 55211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.781268623734604 | -122.44372179014601 | (37.7812686237346, -122.443721790146) | |||
| 8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
| 148084 | 148084 | 106832 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 774880 | 5997571.7488400005 | 2115814.60363 | 37.78948335302721 | -122.45226307989901 | (37.7894833530272, -122.452263079899) | |||
| 104708 | 104708 | 104547 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 156 MADRONE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774728 | 5992588.0 | 2098182.0 | 37.7407821316344 | -122.46822291941099 | (37.7407821316344, -122.468222919411) | |
| 117388 | 117388 | 104548 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 156 MADRONE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x10 | Permit Number 774728 | 5992588.0 | 2098182.0 | 37.7407821316344 | -122.46822291941099 | (37.7407821316344, -122.468222919411) | ||
| 143968 | 143968 | 109131 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 156 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774728 | 5992631.8 | 2098170.8 | 37.740753908855 | -122.468070662321 | (37.740753908855, -122.468070662321) | |
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 110704 | 110704 | 112490 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | ||
| 88002 | 88002 | 109049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774033 | 6000515.3 | 2120331.0 | 37.802052372900896 | -122.442403120222 | (37.8020523729009, -122.442403120222) | ||||
| 105979 | 105979 | 109048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2146 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774033 | 6000515.3 | 2120331.0 | 37.802052372900896 | -122.442403120222 | (37.8020523729009, -122.442403120222) | ||||
| 116505 | 116505 | 105787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 67- 69 CASA WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 9x3 | Permit Number 773990 | 6001454.5 | 2121609.5 | 37.8056162809509 | -122.439244738513 | (37.8056162809509, -122.439244738513) | ||
| 110015 | 110015 | 107354 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 34 Princeton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029478998 | (37.7297306299075, -122.41634029479) | ||||
| 104949 | 104949 | 98318 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | |
| 110814 | 110814 | 98317 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | |
| 107113 | 107113 | 106505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773291 | 6002049.0 | 2102913.0 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | ||||
| 128960 | 128960 | 106506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773291 | 6002049.0 | 2102913.0 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | ||||
| 99604 | 99604 | 106503 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3974 22nd St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773286 | 6002049.0 | 2102947.0 | 37.754407578182004 | -122.435851245675 | (37.754407578182, -122.435851245675) | ||||
| 106187 | 106187 | 106504 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3974 22nd St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773286 | 6002049.0 | 2102947.0 | 37.754407578182004 | -122.435851245675 | (37.754407578182, -122.435851245675) | ||||
| 105643 | 105643 | 104976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | |||
| 122594 | 122594 | 104809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 685 Marina Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | ||||
| 4138 | 4138 | 203734 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | Permit Number 770921 | 5992653.8964 | 2099572.36715 | 37.7446035325326 | -122.468096189498 | (37.7446035325326, -122.468096189498) | ||
| 129412 | 129412 | 104753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | ||||
| 34140 | 34140 | 106242 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | |||
| 40979 | 40979 | 106249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770844 | 6012059.457280001 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | |||
| 74119 | 74119 | 106241 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | |||
| 132893 | 132893 | 106248 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 770844 | 6012033.91664 | 2105711.7719799997 | 37.7625611708892 | -122.401514924078 | (37.7625611708892, -122.401514924078) | |||
| 161959 | 161959 | 106246 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012056.26668 | 2105734.7777299997 | 37.762625586614796 | -122.40143923982299 | (37.7626255866148, -122.401439239823) | |||
| 177303 | 177303 | 106245 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 770844 | 6012052.957359999 | 2105766.02313 | 37.7627111948751 | -122.401452881641 | (37.7627111948751, -122.401452881641) | |||
| 23976 | 23976 | 68013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.9581699995 | 2120820.4060400003 | 37.803337026932894 | -122.446024564694 | (37.8033370269329, -122.446024564694) | ||
| 85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
| 95899 | 95899 | 104723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.71744753798011 | -122.47791752727699 | (37.7174475379801, -122.477917527277) | ||||
| 145385 | 145385 | 102631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | |||
| 41597 | 41597 | 102629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | |||
| 147827 | 147827 | 59324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750286996 | -122.50053376884199 | (37.761245750287, -122.500533768842) | ||
| 140356 | 140356 | 100392 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 100425 | 100425 | 99855 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.44566437565099 | (37.7978680691774, -122.445664375651) | ||||
| 117570 | 117570 | 99856 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.44566437565099 | (37.7978680691774, -122.445664375651) | ||||
| 1917 | 1917 | 125217 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | Permit Number 768908 | 6005070.35193 | 2116772.06135 | 37.79253900653 | -122.426386916319 | (37.79253900653, -122.426386916319) | ||
| 77600 | 77600 | 99908 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 78040 | 78040 | 99901 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 80341 | 80341 | 99902 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 99794 | 99794 | 99904 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 105646 | 105646 | 99900 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 122204 | 122204 | 99905 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 123899 | 123899 | 99903 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 142038 | 142038 | 99899 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||
| 143373 | 143373 | 99907 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 145875 | 145875 | 99906 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 152823 | 152823 | 99897 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Permit Number 768908 | 6004409.826309999 | 2116680.57597 | 37.7922504509529 | -122.42866583257401 | (37.7922504509529, -122.428665832574) | |||
| 88277 | 88277 | 98819 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768816 | 6000868.0 | 2109174.0 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) |
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");