Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2915 | 2915 | 125433 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780237 | 6000667.51729 | 2117651.20267 | 37.794703033474995 | -122.441683948183 | (37.794703033475, -122.441683948183) | |
| 3701 | 3701 | 1557 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 545 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 8 | 3X3 | 5995578.89655 | 2112509.35885 | 37.7802936727782 | -122.458918678629 | (37.7802936727782, -122.458918678629) | ||
| 5043 | 5043 | 189151 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 351 Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017468.01148 | 2098526.96006 | 37.7431348775871 | -122.38222031223499 | (37.7431348775871, -122.382220312235) | |||
| 9302 | 9302 | 5677 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1466 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | 3 | 3X3 | 6005192.4040864995 | 2099806.5348922 | 37.745962647671796 | -122.42475713514798 | (37.7459626476718, -122.424757135148) | ||
| 9980 | 9980 | 5639 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1273 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 106 | 6X6 | 6005219.14783 | 2100952.73682 | 37.7491113654052 | -122.424746185103 | (37.7491113654052, -122.424746185103) | |||
| 15007 | 15007 | 3510 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018015.123459999 | 2098106.997 | 37.742011946302206 | -122.380299345034 | (37.7420119463022, -122.380299345034) | ||
| 15163 | 15163 | 3493 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 3 | 3X3 | 6017614.96408 | 2098401.28975 | 37.742797927679206 | -122.381703445764 | (37.7427979276792, -122.381703445764) | ||
| 15517 | 15517 | 3699 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 401X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016428.13019 | 2099338.24362 | 37.7453050064279 | -122.3858725148 | (37.7453050064279, -122.3858725148) | |||
| 15789 | 15789 | 3512 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018049.38641 | 2098082.73153 | 37.741947208609 | -122.380179187546 | (37.741947208609, -122.380179187546) | |||
| 16037 | 16037 | 3502 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/1998 12:00:00 AM | 3 | 3X3 | 6017776.09784 | 2098280.32735 | 37.742474685272605 | -122.381137876511 | (37.7424746852726, -122.381137876511) | ||
| 16174 | 16174 | 3520 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018169.02375 | 2097993.05748 | 37.7417075815435 | -122.379759286875 | (37.7417075815435, -122.379759286875) | ||
| 17175 | 17175 | 5404 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 378 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1999 12:00:00 AM | 16 | 3x3 | 6004843.86824 | 2106164.84267 | 37.7634013822954 | -122.42641496707701 | (37.7634013822954, -122.426414967077) | ||
| 17344 | 17344 | 5518 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 849 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1998 12:00:00 AM | 9 | 4X4 | 6005079.63126 | 2103419.6005599997 | 37.7558769193029 | -122.425404164166 | (37.7558769193029, -122.425404164166) | ||
| 17446 | 17446 | 5723 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1670 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/27/1998 12:00:00 AM | 18 | 3X3 | 6005263.963280001 | 2098615.04936 | 37.742695141477 | -122.42442495986 | (37.742695141477, -122.42442495986) | ||
| 17514 | 17514 | 5590 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1083 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/1990 12:00:00 AM | 18 | 3x3 | 6005159.4457 | 2102050.19328 | 37.7521213549276 | -122.42503070990101 | (37.7521213549276, -122.425030709901) | ||
| 18848 | 18848 | 28374 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 884 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005007.6879 | 2103215.1576900003 | 37.7553115020308 | -122.42563841777799 | (37.7553115020308, -122.425638417778) | |||
| 20127 | 20127 | 5634 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1257 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1997 12:00:00 AM | 18 | 3X3 | 6005215.51559 | 2101038.9322900004 | 37.749347833153 | -122.42476487661301 | (37.749347833153, -122.424764876613) | ||
| 20542 | 20542 | 5747 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1765 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1996 12:00:00 AM | 20 | 3X3 | 6005375.85282 | 2098122.03474 | 37.7413477528889 | -122.424003025841 | (37.7413477528889, -122.424003025841) | ||
| 20556 | 20556 | 5535 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 900X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X6 | 6005026.93997 | 2102900.52226 | 37.754448674468705 | -122.425549446969 | (37.7544486744687, -122.425549446969) | |||
| 21106 | 21106 | 5652 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1328 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2004 12:00:00 AM | 8 | 4X4 | 6005154.95046 | 2100611.44692 | 37.7481706358831 | -122.42494390195299 | (37.7481706358831, -122.424943901953) | ||
| 21125 | 21125 | 5403 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 372 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1999 12:00:00 AM | 8 | 3X3 | 6004842.3599 | 2106185.15313 | 37.7634570647172 | -122.42642163016501 | (37.7634570647172, -122.426421630165) | ||
| 21168 | 21168 | 5641 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1284 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 12 | 3X2 | 6005137.94606 | 2100872.53029 | 37.7488865501777 | -122.42502127603201 | (37.7488865501777, -122.425021276032) | ||
| 21190 | 21190 | 5640 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1281 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1997 12:00:00 AM | 3 | 4X4 | 6005220.37087 | 2100924.60238 | 37.7490341837912 | -122.42473995460699 | (37.7490341837912, -122.424739954607) | ||
| 21365 | 21365 | 5815 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1466X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 14 | 3X3 | 6005195.194490001 | 2099842.5587299997 | 37.7460617184842 | -122.424750048586 | (37.7460617184842, -122.424750048586) | ||
| 21759 | 21759 | 5545 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 937 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6005113.2293 | 2102897.95475 | 37.7544464999301 | -122.425250853145 | (37.7544464999301, -122.425250853145) | ||
| 21885 | 21885 | 5653 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1331 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1997 12:00:00 AM | 6 | 3x3 | 6005239.6311800005 | 2100605.43631 | 37.748158914998 | -122.42465065100599 | (37.748158914998, -122.424650651006) | ||
| 21896 | 21896 | 5456 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 573 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6004993.16703 | 2105051.3382900003 | 37.7603524017606 | -122.425819327205 | (37.7603524017606, -122.425819327205) | |||
| 22039 | 22039 | 5588 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1077 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1990 12:00:00 AM | 6 | 3x3 | 6005154.78082 | 2102086.1715 | 37.7522198792618 | -122.425049401425 | (37.7522198792618, -122.425049401425) | ||
| 22158 | 22158 | 5636 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1265 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005218.82041 | 2100995.2058599996 | 37.7492279571106 | -122.42475033817 | (37.7492279571106, -122.42475033817) | |||
| 22210 | 22210 | 5419 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 431 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 12 | 4X4 | 6004950.08194 | 2105826.48665 | 37.76247834061721 | -122.426023520063 | (37.7624783406172, -122.426023520063) | ||
| 23067 | 23067 | 3507 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6017965.040030001 | 2098144.3870599996 | 37.7421118483876 | -122.380475117526 | (37.7421118483876, -122.380475117526) | |||
| 23296 | 23296 | 5547 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 945 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/1989 12:00:00 AM | 8 | 3X3 | 6005116.50636 | 2102823.73281 | 37.754242888921794 | -122.42523423906201 | (37.7542428889218, -122.425234239062) | ||
| 23680 | 23680 | 244887 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 163 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999854.6506 | 2109116.5264 | 37.7712226704839 | -122.44388308070499 | (37.7712226704839, -122.443883080705) | |||
| 26592 | 26592 | 125427 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2928 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 5999992.9617099995 | 2117466.6208099998 | 37.7941577637301 | -122.44400472425 | (37.7941577637301, -122.44400472425) | |||
| 27089 | 27089 | 220577 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 4256 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000785.1959 | 2102896.48874 | 37.7541970145069 | -122.440218172849 | (37.7541970145069, -122.440218172849) | |||
| 28246 | 28246 | 220573 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1027 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009453.66032 | 2103181.05755 | 37.7554680910955 | -122.410260442478 | (37.7554680910955, -122.410260442478) | |||
| 28939 | 28939 | 220571 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 704 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007751.9682 | 2095656.53748 | 37.734711903726 | -122.41561270548 | (37.734711903726, -122.41561270548) | |||
| 30302 | 30302 | 175150 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 141 Goethe St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994849.69598 | 2086516.03158 | 37.708880557851 | -122.45955816357299 | (37.708880557851, -122.459558163573) | |||
| 30935 | 30935 | 125429 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000677.56887 | 2117585.07036 | 37.7945220242189 | -122.441644420247 | (37.7945220242189, -122.441644420247) | |||
| 32669 | 32669 | 32077 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 3827 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35450 | 6003391.4377 | 2105919.76676 | 37.7626462521437 | -122.431420955128 | (37.7626462521437, -122.431420955128) | |
| 43024 | 43024 | 125425 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2928 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000023.6468 | 2117473.30633 | 37.7941778707649 | -122.443899031423 | (37.7941778707649, -122.443899031423) | |||
| 43118 | 43118 | 220565 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 824 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6004994.41271 | 2103503.72322 | 37.7561030853021 | -122.425704865097 | (37.7561030853021, -122.425704865097) | |||
| 45633 | 45633 | 125435 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2671 Leavenworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007321.894719999 | 2121819.7071 | 37.8065255894616 | -122.41895465634899 | (37.8065255894616, -122.418954656349) | ||||
| 46085 | 46085 | 125424 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2190 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999755.540019999 | 2120902.07303 | 37.803577052387205 | -122.445073321194 | (37.8035770523872, -122.445073321194) | |||
| 46996 | 46996 | 220570 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 126 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005060.58541 | 2099334.9640099998 | 37.744660375967996 | -122.42517939752899 | (37.744660375968, -122.425179397529) | |||
| 47873 | 47873 | 220582 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1970 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008663.552080001 | 2106884.85799 | 37.765593558930796 | -122.41325479099301 | (37.7655935589308, -122.413254790993) | |||
| 48353 | 48353 | 220572 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 572 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007801.488369999 | 2096211.01853 | 37.7362371710113 | -122.415480739843 | (37.7362371710113, -122.415480739843) | |||
| 48893 | 48893 | 72852 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 864 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 4 | 6012111.42682 | 2104322.01833 | 37.7587495400776 | -122.401149183293 | (37.7587495400776, -122.401149183293) | ||
| 52172 | 52172 | 220574 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 45 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000987.51728 | 2101437.32538 | 37.7502020200252 | -122.439413908224 | (37.7502020200252, -122.439413908224) | |||
| 54457 | 54457 | 220562 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 180 Fair Oaks St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005403.74239 | 2102621.49562 | 37.753703815502206 | -122.42422652175199 | (37.7537038155022, -122.424226521752) | |||
| 55141 | 55141 | 220568 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1493 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005289.524259999 | 2099654.6110799997 | 37.7455509844911 | -122.424410502356 | (37.7455509844911, -122.424410502356) | |||
| 56379 | 56379 | 125428 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2928 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 5999973.68437 | 2117464.48653 | 37.7941508038799 | -122.444071272288 | (37.7941508038799, -122.444071272288) | |||
| 56621 | 56621 | 244894 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 157 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999856.5482 | 2109090.9093 | 37.7711524406356 | -122.443874676044 | (37.7711524406356, -122.443874676044) | |||
| 60311 | 60311 | 175149 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 185 Bertita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000379.58344 | 2089864.5539900002 | 37.718391276103794 | -122.440686171946 | (37.7183912761038, -122.440686171946) | |||
| 67298 | 67298 | 220586 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 110 Henry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002743.62955 | 2107408.58103 | 37.7666974380494 | -122.433767904159 | (37.7666974380494, -122.433767904159) | |||
| 68377 | 68377 | 220559 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 199 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005086.476480001 | 2103971.64406 | 37.7573930881476 | -122.425419775506 | (37.7573930881476, -122.425419775506) | |||
| 69803 | 69803 | 220581 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2080 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007873.203480001 | 2106220.08996 | 37.7637238567005 | -122.41594136000201 | (37.7637238567005, -122.415941360002) | |||
| 71791 | 71791 | 125430 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000675.19389 | 2117597.6628799997 | 37.7945564646566 | -122.44165354208201 | (37.7945564646566, -122.441653542082) | |||
| 78131 | 78131 | 99508 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2828 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000030.0 | 2117468.0 | 37.7941636633745 | -122.44387666730499 | (37.7941636633745, -122.443876667305) | ||||
| 78337 | 78337 | 47513 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 200 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.72793597542061 | -122.43806471993601 | (37.7279359754206, -122.438064719936) | ||
| 82348 | 82348 | 3475 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 83635 | 83635 | 1598 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 716 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/27/2015 12:00:00 AM | 3 | 3X3 | 5995689.23492 | 2111209.34792 | 37.7767305290971 | -122.45844284127399 | (37.7767305290971, -122.458442841274) | ||
| 85993 | 85993 | 121345 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 399X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6017829.0 | 2098352.0 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | |||
| 90955 | 90955 | 3471 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 94255 | 94255 | 91418 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1150 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/26/2008 12:00:00 AM | 3x3 | 6005120.0 | 2101662.0 | 37.7510532378739 | -122.425139500126 | (37.7510532378739, -122.425139500126) | |||
| 100711 | 100711 | 104170 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 4537 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769080 | 6000821.1 | 2101080.3 | 37.749212241765896 | -122.43996379159901 | (37.7492122417659, -122.439963791599) | ||||
| 103353 | 103353 | 47514 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 200 Santa Rosa Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.72793597542061 | -122.43806471993601 | (37.7279359754206, -122.438064719936) | ||
| 103721 | 103721 | 99507 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2828 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000030.0 | 2117468.0 | 37.7941636633745 | -122.44387666730499 | (37.7941636633745, -122.443876667305) | ||||
| 104511 | 104511 | 3483 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 106063 | 106063 | 86515 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1217 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 01:26:00 PM | 3 | 3x3 | 5987669.6515379995 | 2107004.041134 | 37.7647197926712 | -122.48587586950899 | (37.7647197926712, -122.485875869509) | ||
| 111073 | 111073 | 3476 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 116124 | 116124 | 109730 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 4201 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775045 | 6001939.5 | 2105236.4 | 37.7606874972289 | -122.436393767062 | (37.7606874972289, -122.436393767062) |
| 116520 | 116520 | 47515 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 200 Santa Rosa Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45391 | 6001209.62107748 | 2093323.4940375 | 37.72793597542061 | -122.43806471993601 | (37.7279359754206, -122.438064719936) | ||
| 117404 | 117404 | 81672 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 17 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50248 | 6006951.93475538 | 2100077.40806786 | 37.7468056256291 | -122.41869210859899 | (37.7468056256291, -122.418692108599) | ||
| 119212 | 119212 | 99506 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2828 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000030.0 | 2117468.0 | 37.7941636633745 | -122.44387666730499 | (37.7941636633745, -122.443876667305) | ||||
| 122226 | 122226 | 125432 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000671.91395 | 2117623.1086 | 37.7946261450435 | -122.44166671804899 | (37.7946261450435, -122.441666718049) | |||
| 123264 | 123264 | 3490 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 123399 | 123399 | 5784 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 529 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003264.5891464995 | 2108312.4032751 | 37.769208661335504 | -122.432030542626 | (37.7692086613355, -122.432030542626) | |||
| 124702 | 124702 | 36591 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 1322 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39449 | 6009503.36363014 | 2101463.13072945 | 37.7507538338304 | -122.40996728350201 | (37.7507538338304, -122.409967283502) | ||
| 125658 | 125658 | 101244 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 4248-4250 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2012 12:00:00 AM | 3x3 | Permit Number 769397 | 6002254.0 | 2101219.0 | 37.7496745444618 | -122.435018725879 | (37.7496745444618, -122.435018725879) | ||
| 131185 | 131185 | 125431 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000672.22122 | 2117609.68414 | 37.7945893025098 | -122.441664690989 | (37.7945893025098, -122.441664690989) | |||
| 136317 | 136317 | 220558 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 100 Alemany Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 6009447.19791 | 2095939.1403700002 | 37.7355830167279 | -122.409771634864 | (37.7355830167279, -122.409771634864) | |||
| 136618 | 136618 | 220576 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 4248 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002235.87131 | 2101222.78245 | 37.749683900790295 | -122.43508168597299 | (37.7496839007903, -122.435081685973) | |||
| 141059 | 141059 | 3473 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 301X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 143739 | 143739 | 109565 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 56 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
| 144065 | 144065 | 99505 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2828 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000030.0 | 2117468.0 | 37.7941636633745 | -122.44387666730499 | (37.7941636633745, -122.443876667305) | ||||
| 148489 | 148489 | 203442 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1315 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994845.11154 | 2106585.71345 | 37.763986697050704 | -122.461027689985 | (37.7639866970507, -122.461027689985) | |||
| 151064 | 151064 | 220583 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 432 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6004144.54051 | 2101440.53438 | 37.7503899918234 | -122.428496954298 | (37.7503899918234, -122.428496954298) | |||
| 151857 | 151857 | 125426 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2928 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 6000010.5484 | 2117469.0719 | 37.794165496980604 | -122.443944048787 | (37.7941654969806, -122.443944048787) | |||
| 152175 | 152175 | 220569 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1493 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005287.8454599995 | 2099674.63115 | 37.74560586022589 | -122.42441773111601 | (37.7456058602259, -122.424417731116) | |||
| 153940 | 153940 | 220585 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 4201 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001948.84946 | 2105253.2195 | 37.760734210734796 | -122.436362635325 | (37.7607342107348, -122.436362635325) | |||
| 155115 | 155115 | 125434 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1302 Columbus Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007306.78534 | 2121812.18532 | 37.8065040857636 | -122.419006411423 | (37.8065040857636, -122.419006411423) | ||||
| 155225 | 155225 | 220575 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 4537 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6000809.16265 | 2101101.43994 | 37.74926960741921 | -122.440006586656 | (37.7492696074192, -122.440006586656) | |||
| 155315 | 155315 | 220579 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 17 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006961.59304 | 2100069.04845 | 37.7467832157815 | -122.418658118381 | (37.7467832157815, -122.418658118381) | |||
| 164899 | 164899 | 220580 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 3676 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006502.6084199995 | 2101457.78327 | 37.750570513641 | -122.420343797747 | (37.750570513641, -122.420343797747) | |||
| 172586 | 172586 | 41270 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 3219 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | 7 | Permit Number 41953 | 6013574.0809 | 2090117.634 | 37.719828750850795 | -122.395095686375 | (37.7198287508508, -122.395095686375) | ||
| 173708 | 173708 | 220563 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 180 Fair Oaks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005403.99517 | 2102602.99511 | 37.7536530316709 | -122.424224331908 | (37.7536530316709, -122.424224331908) | |||
| 173774 | 173774 | 220584 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 3823 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003420.93714 | 2105922.0191900004 | 37.7626541086221 | -122.431319088 | (37.7626541086221, -122.431319088) | |||
| 174208 | 174208 | 220564 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 367 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004224.9310099995 | 2106773.34876 | 37.7650371870506 | -122.42859904892299 | (37.7650371870506, -122.428599048923) | |||
| 174417 | 174417 | 220557 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 420 Dolores St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004878.61123 | 2105553.35269 | 37.761724340040296 | -122.42625126438101 | (37.7617243400403, -122.426251264381) |
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");