Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6493 | 6493 | 113456 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 6X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008347.73797 | 2116436.02263 | 37.791801043527705 | -122.41502322146098 | (37.7918010435277, -122.415023221461) | |||
| 8372 | 8372 | 99719 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2164 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007186.17673 | 2119740.01598 | 37.8008076423232 | -122.41927671165199 | (37.8008076423232, -122.419276711652) | |||
| 9933 | 9933 | 11201 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 100 Idora Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | |||
| 10964 | 10964 | 105517 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 701 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002660.53162 | 2089394.02729 | 37.7172289446341 | -122.43276829961799 | (37.7172289446341, -122.432768299618) | |||
| 11721 | 11721 | 25295 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 7x3 | 6000605.77697 | 2091736.4285900001 | 37.7235438977056 | -122.440038466696 | (37.7235438977056, -122.440038466696) | |||
| 12071 | 12071 | 105515 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 701 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002668.24171 | 2089385.75875 | 37.7172066783264 | -122.43274105916402 | (37.7172066783264, -122.432741059164) | |||
| 15157 | 15157 | 17447 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 1967 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 3X3 | 6012920.44639 | 2096678.64853 | 37.7378075824587 | -122.39781506373801 | (37.7378075824587, -122.397815063738) | |||
| 15762 | 15762 | 17448 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 1967 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 3X3 | 6012936.47341 | 2096667.4525099997 | 37.7377777330535 | -122.397758865084 | (37.7377777330535, -122.397758865084) | |||
| 16250 | 16250 | 17449 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 1967 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 3X3 | 6012949.377309999 | 2096657.76915 | 37.7377518631542 | -122.39771357075001 | (37.7377518631542, -122.39771357075) | |||
| 17996 | 17996 | 444 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 700X 23rd Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8-HOA | 5988817.90932 | 2110395.2754599997 | 37.774098034723 | -122.48215285967599 | (37.774098034723, -122.482152859676) | |||
| 18788 | 18788 | 103624 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.787503918723395 | -122.48671414227199 | (37.7875039187234, -122.486714142272) | |||
| 19347 | 19347 | 16022 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 123 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001242.37794 | 2094603.6924599998 | 37.731452969281605 | -122.43804314267099 | (37.7314529692816, -122.438043142671) | |||
| 23029 | 23029 | 949 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 1468 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 6 | 3X6 | 6002168.03285 | 2093561.19975 | 37.7286431202677 | -122.434768461095 | (37.7286431202677, -122.434768461095) | ||
| 24315 | 24315 | 179898 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1039 Woolsey St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008631.84124 | 2091237.7754900001 | 37.722628347396395 | -122.41225846448098 | (37.7226283473964, -122.412258464481) | |||
| 24688 | 24688 | 179805 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1475 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5998972.41815 | 2089460.5797700002 | 37.7172018201812 | -122.445521103537 | (37.7172018201812, -122.445521103537) | |||
| 24986 | 24986 | 40659 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 455 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41650 | 6011224.7709800005 | 2106227.9373 | 37.763933262942096 | -122.404349812908 | (37.7639332629421, -122.404349812908) | ||
| 25346 | 25346 | 241066 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1801 Castro St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6002659.6635 | 2100292.45655 | 37.7471534999337 | -122.43354972053999 | (37.7471534999337, -122.43354972054) | ||||
| 25618 | 25618 | 241059 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6005916.7260300005 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | |||
| 26218 | 26218 | 136713 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 290 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6011569.99478 | 2119432.50864 | 37.8002092172264 | -122.40408513072799 | (37.8002092172264, -122.404085130728) | |||
| 26280 | 26280 | 136663 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3109 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.803297110532895 | -122.426737318298 | (37.8032971105329, -122.426737318298) | |||
| 26605 | 26605 | 136684 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 57 Russell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6007021.76535 | 2118934.77129 | 37.7985873825495 | -122.41978847538 | (37.7985873825495, -122.41978847538) | |||
| 27262 | 27262 | 215313 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 323 Tara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997655.0678900005 | 2090049.20462 | 37.718742752762395 | -122.45011694135201 | (37.7187427527624, -122.450116941352) | |||
| 27542 | 27542 | 179833 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6002155.36157 | 2093545.0803599998 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | |||
| 28607 | 28607 | 136666 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.78199 | 2117450.1617400004 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | |||
| 28744 | 28744 | 215305 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 Gennessee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 5997468.9434 | 2093863.63233 | 37.7292056228286 | -122.451035210326 | (37.7292056228286, -122.451035210326) | |||
| 28764 | 28764 | 215310 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 536 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 5995931.84882 | 2088877.77404 | 37.715427518948204 | -122.455988739984 | (37.7154275189482, -122.455988739984) | |||
| 28867 | 28867 | 123109 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 534 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.77815059899579 | -122.469336449069 | (37.7781505989958, -122.469336449069) | |||
| 29385 | 29385 | 241060 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.735075558995206 | -122.421928139697 | (37.7350755589952, -122.421928139697) | |||
| 29390 | 29390 | 136672 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2650 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000710.42284 | 2117422.0356799997 | 37.7940762455768 | -122.44151903679199 | (37.7940762455768, -122.441519036792) | |||
| 29950 | 29950 | 215317 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 323 Tara St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997677.83985 | 2090093.68651 | 37.7188661927949 | -122.450041432477 | (37.7188661927949, -122.450041432477) | |||
| 30084 | 30084 | 241069 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 415 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6002146.1874 | 2103426.00537 | 37.755728332400295 | -122.435549412575 | (37.7557283324003, -122.435549412575) | |||
| 30785 | 30785 | 136674 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2127 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6003286.01413 | 2117511.22224 | 37.7944675271099 | -122.43261360184401 | (37.7944675271099, -122.432613601844) | |||
| 31077 | 31077 | 136678 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1369 Hyde St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007492.70889 | 2117096.59509 | 37.7935667274799 | -122.41802847783899 | (37.7935667274799, -122.418028477839) | |||
| 31256 | 31256 | 179891 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 101 Dartmouth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008528.3332400005 | 2093531.3526 | 37.728920213986896 | -122.41277834095 | (37.7289202139869, -122.41277834095) | |||
| 31591 | 31591 | 215344 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | |||
| 31638 | 31638 | 197905 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 654 Minnesota St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6015150.562390001 | 2105371.1757099996 | 37.7617993767681 | -122.39071168490901 | (37.7617993767681, -122.390711684909) | |||
| 31860 | 31860 | 72392 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563866999 | (37.7745919608967, -122.48266563867) | ||
| 32346 | 32346 | 136702 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1728 Jones St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008349.7073800005 | 2118393.0746400002 | 37.7971747364841 | -122.41515499910801 | (37.7971747364841, -122.415154999108) | |||
| 32736 | 32736 | 179803 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5998958.13876 | 2089448.3119700002 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | |||
| 34105 | 34105 | 136710 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 801 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6007938.82451 | 2120606.36693 | 37.8032287836485 | -122.41673363846 | (37.8032287836485, -122.41673363846) | |||
| 34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
| 34505 | 34505 | 37656 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 3528 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40066 | 5992389.15211 | 2110029.68945 | 37.7733013036895 | -122.46977279943 | (37.7733013036895, -122.46977279943) | |
| 34935 | 34935 | 215318 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 323 Tara St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997681.5922 | 2090099.0466200002 | 37.7188811251298 | -122.450028848265 | (37.7188811251298, -122.450028848265) | |||
| 34977 | 34977 | 179846 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.728610658338596 | -122.44099467805599 | (37.7286106583386, -122.440994678056) | |||
| 35510 | 35510 | 197913 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 75 Conkling St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6011758.2488400005 | 2095732.0102900001 | 37.7351435225424 | -122.40176684758 | (37.7351435225424, -122.40176684758) | |||
| 36816 | 36816 | 215284 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1442 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993065.75738 | 2105645.52263 | 37.7613026281332 | -122.467113534456 | (37.7613026281332, -122.467113534456) | |||
| 36841 | 36841 | 136693 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2164 Hyde St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007181.34298 | 2119779.0106099998 | 37.8009144395066 | -122.41929620626001 | (37.8009144395066, -122.41929620626) | |||
| 37249 | 37249 | 136688 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 777 Bay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007087.93893 | 2121181.13167 | 37.80475904754471 | -122.41971896677099 | (37.8047590475447, -122.419718966771) | |||
| 37411 | 37411 | 136643 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2781 Filbert St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5999657.45024 | 2118405.07114 | 37.7967153546854 | -122.44523312981501 | (37.7967153546854, -122.445233129815) | |||
| 37484 | 37484 | 136656 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1425 Jefferson St | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6002391.3756099995 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | |||
| 37521 | 37521 | 215286 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5992803.42046 | 2104269.10188 | 37.757508190570995 | -122.467920721889 | (37.757508190571, -122.467920721889) | |||
| 37647 | 37647 | 136662 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1307 Bay St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.803611411885704 | -122.428569697738 | (37.8036114118857, -122.428569697738) | |||
| 37711 | 37711 | 179796 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1795 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 1ft | 5997861.23879 | 2088411.17322 | 37.714256892113 | -122.449286343701 | (37.714256892113, -122.449286343701) | |||
| 37771 | 37771 | 179849 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 801 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5998875.31966 | 2090008.53873 | 37.7187008461546 | -122.445896113635 | (37.7187008461546, -122.445896113635) | |||
| 37819 | 37819 | 179856 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 950 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5998506.12303 | 2089417.33041 | 37.7170564357799 | -122.44712974785101 | (37.7170564357799, -122.447129747851) | |||
| 38212 | 38212 | 241051 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 961 San Bruno Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011090.2221 | 2103848.38169 | 37.757392016143996 | -122.40464765488001 | (37.757392016144, -122.40464765488) | |||
| 38363 | 38363 | 215283 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1448 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993067.04344 | 2105615.39 | 37.7612199660593 | -122.467106895686 | (37.7612199660593, -122.467106895686) | |||
| 39082 | 39082 | 179800 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 228 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998609.2887699995 | 2088802.95321 | 37.7153753906268 | -122.44672897396099 | (37.7153753906268, -122.446728973961) | |||
| 39946 | 39946 | 54662 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 353 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10486 | 6012290.80379 | 2086856.8935900002 | 37.7108039630942 | -122.39930277173 | (37.7108039630942, -122.39930277173) | ||
| 40377 | 40377 | 136676 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2121 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6003331.47965 | 2117519.24553 | 37.79449213524921 | -122.43245685900801 | (37.7944921352492, -122.432456859008) | |||
| 40586 | 40586 | 179854 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | ||||
| 41138 | 41138 | 136654 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1490 Jefferson St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002110.7904900005 | 2121588.8719099998 | 37.805596965701206 | -122.436972078008 | (37.8055969657012, -122.436972078008) | |||
| 41146 | 41146 | 67619 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.41749276338899 | (37.7983521792584, -122.417492763389) | |
| 41249 | 41249 | 72670 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/1997 12:00:00 AM | 11 | 5994586.71732 | 2114106.61682 | 37.784622230609706 | -122.462466948558 | (37.7846222306097, -122.462466948558) | ||
| 41852 | 41852 | 136668 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2640 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000716.04305 | 2117375.3670099997 | 37.793948425839 | -122.44149623986 | (37.793948425839, -122.44149623986) | |||
| 41893 | 41893 | 179840 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 212 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6002632.59127 | 2093895.12097 | 37.729586356211705 | -122.433186306304 | (37.7295863562117, -122.433186306304) | |||
| 41915 | 41915 | 120845 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 295 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5989915.85655 | 2113416.7886200002 | 37.782458071772794 | -122.478575916409 | (37.7824580717728, -122.478575916409) | |||
| 42625 | 42625 | 179912 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 295 Rome St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5998434.108080001 | 2088860.2602 | 37.7155227337561 | -122.447338595604 | (37.7155227337561, -122.447338595604) | |||
| 43154 | 43154 | 179883 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 39 Amherst St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6007323.0576599995 | 2093363.44581 | 37.7283914539998 | -122.416933184515 | (37.7283914539998, -122.416933184515) | |||
| 43440 | 43440 | 62484 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.9858799998 | 37.7266678079605 | -122.44026018915702 | (37.7266678079605, -122.440260189157) | |
| 43736 | 43736 | 179902 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1039 Woolsey St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008644.6149699995 | 2091242.09558 | 37.722640926223704 | -122.412214613536 | (37.7226409262237, -122.412214613536) | |||
| 43739 | 43739 | 215343 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 450 Circular Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999604.29165 | 2093616.1275099998 | 37.728648052142205 | -122.44363538078899 | (37.7286480521422, -122.443635380789) | |||
| 44189 | 44189 | 215312 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 323 Tara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997649.01848 | 2090038.45407 | 37.7187128880716 | -122.450137077175 | (37.7187128880716, -122.450137077175) | |||
| 44384 | 44384 | 136704 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1728 Jones St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008348.418219999 | 2118399.20524 | 37.7971914971435 | -122.415159894117 | (37.7971914971435, -122.415159894117) | |||
| 44530 | 44530 | 64384 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 290 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53175 | 6011583.39503 | 2119434.8519599997 | 37.800216400116796 | -122.404038925378 | (37.8002164001168, -122.404038925378) | |
| 44596 | 44596 | 179862 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 274 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6004589.52556 | 2091551.8255 | 37.7232630025659 | -122.42625421327699 | (37.7232630025659, -122.426254213277) | |||
| 45200 | 45200 | 179880 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1151 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6007526.36673 | 2092824.84352 | 37.7269240023301 | -122.416192203412 | (37.7269240023301, -122.416192203412) | |||
| 45568 | 45568 | 136640 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2901 Steiner St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002002.26446 | 2118153.31636 | 37.7961576653005 | -122.43710151924 | (37.7961576653005, -122.43710151924) | |||
| 46385 | 46385 | 136652 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1490 Jefferson St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6002131.53394 | 2121592.77416 | 37.8056088592346 | -122.43690057202 | (37.8056088592346, -122.43690057202) | |||
| 46836 | 46836 | 136715 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6003190.857480001 | 2120979.91426 | 37.803986257417 | -122.43319081820499 | (37.803986257417, -122.433190818205) | |||
| 46852 | 46852 | 179890 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | |||
| 47517 | 47517 | 215292 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 4ft | 5994414.4538199995 | 2100572.1696900004 | 37.747450256423 | -122.46208106771299 | (37.747450256423, -122.462081067713) | |||
| 47614 | 47614 | 52756 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 176@ GEARY Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 7 | Permit Number 48800 | 5995950.25747 | 2113100.8388099996 | 37.7819390591214 | -122.457676787394 | (37.7819390591214, -122.457676787394) | ||
| 47665 | 47665 | 179861 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 243 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6004531.11595 | 2091836.4635299998 | 37.72404125429011 | -122.426476381783 | (37.7240412542901, -122.426476381783) | |||
| 47686 | 47686 | 100528 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1728 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4.5x6 | 6008351.1313 | 2118382.01094 | 37.7971444383282 | -122.41514928842699 | (37.7971444383282, -122.415149288427) | |||
| 48018 | 48018 | 136642 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3035 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6000450.1684 | 2118732.62208 | 37.797659939602106 | -122.442513681577 | (37.7976599396021, -122.442513681577) | |||
| 48335 | 48335 | 215303 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.45084726458401 | (37.7322337966419, -122.450847264584) | ||||
| 48607 | 48607 | 215324 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1288 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5993647.638119999 | 2106753.8190200003 | 37.764379290686996 | -122.46518157307501 | (37.764379290687, -122.465181573075) | |||
| 48617 | 48617 | 136649 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1490 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6002175.88564 | 2121598.89549 | 37.8056281874435 | -122.436747525379 | (37.8056281874435, -122.436747525379) | |||
| 48759 | 48759 | 215334 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 800 Foerster St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998241.14099 | 2096403.03655 | 37.736222403240795 | -122.448548482343 | (37.7362224032408, -122.448548482343) | |||
| 48829 | 48829 | 136697 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1047 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007352.71781 | 2120177.3681 | 37.802017878890005 | -122.418731441927 | (37.80201787889, -122.418731441927) | |||
| 49400 | 49400 | 123124 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 798 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992601.67217 | 2110090.43708 | 37.773480381816 | -122.469042091828 | (37.773480381816, -122.469042091828) | |||
| 49469 | 49469 | 136700 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1955 Jones St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6008170.72961 | 2119215.5457900004 | 37.799422977755796 | -122.41583257802601 | (37.7994229777558, -122.415832578026) | |||
| 50338 | 50338 | 136677 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2121 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6003353.41971 | 2117521.18244 | 37.7944986976029 | -122.432381082137 | (37.7944986976029, -122.432381082137) | |||
| 50598 | 50598 | 215337 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 800 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998231.9169 | 2096387.5163099999 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | |||
| 50617 | 50617 | 179869 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 299 Madison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6005754.24665 | 2092349.7952 | 37.725519819773 | -122.42228465702699 | (37.725519819773, -122.422284657027) | |||
| 50707 | 50707 | 179820 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 25 Dichiera Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998698.8772599995 | 2087810.60096 | 37.712655734647 | -122.446347971688 | (37.712655734647, -122.446347971688) | |||
| 51292 | 51292 | 179897 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1039 Woolsey St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6008627.84918 | 2091236.6223 | 37.7226249569704 | -122.412272182734 | (37.7226249569704, -122.412272182734) | |||
| 51755 | 51755 | 215309 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 201 Montana St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5994986.287409999 | 2089298.5620400002 | 37.716528585915796 | -122.45928745236401 | (37.7165285859158, -122.459287452364) | |||
| 52047 | 52047 | 241056 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 4864 17th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5997871.31028 | 2105665.38567 | 37.7616333843862 | -122.450494663794 | (37.7616333843862, -122.450494663794) |
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");