Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80969 | 80969 | 108934 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591001 | (37.7386556931549, -122.42007742591) |
| 112534 | 112534 | 108521 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.751194650539205 | -122.47418561882401 | (37.7511946505392, -122.474185618824) |
| 117298 | 117298 | 108904 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.41282871497101 | (37.7361673058735, -122.412828714971) |
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 23389 | 23389 | 43452 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.44355739787599 | (37.7220903846374, -122.443557397876) | |
| 24577 | 24577 | 43433 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | |
| 26060 | 26060 | 43443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.722236528981206 | -122.44393453036999 | (37.7222365289812, -122.44393453037) | |
| 28704 | 28704 | 43445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.44257358990299 | (37.7217053974709, -122.442573589903) | |
| 33677 | 33677 | 43434 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.8327900001 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | |
| 39173 | 39173 | 43441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | |
| 39824 | 39824 | 43966 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 08/20/2005 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.781989200774206 | -122.41983486151199 | (37.7819892007742, -122.419834861512) | |
| 45283 | 45283 | 43435 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.44271111962699 | (37.7217631321556, -122.442711119627) | |
| 45429 | 45429 | 111443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | |||
| 52424 | 52424 | 43437 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.9112200001 | 37.7223551630339 | -122.44424210479099 | (37.7223551630339, -122.444242104791) | |
| 54575 | 54575 | 111440 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 12 | 5999883.47669 | 2091070.55057 | 37.72167440322979 | -122.442487538293 | (37.7216744032298, -122.442487538293) | |||
| 63781 | 63781 | 43439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.72228091680579 | -122.44404838812099 | (37.7222809168058, -122.444048388121) | |
| 65476 | 65476 | 43457 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.722189247127105 | -122.443818239036 | (37.7221892471271, -122.443818239036) | |
| 66622 | 66622 | 43448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | |
| 68075 | 68075 | 43459 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.4802700002 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | |
| 70864 | 70864 | 43453 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | |
| 71753 | 71753 | 43458 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | |
| 74074 | 74074 | 43442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.72225447314511 | -122.443973794765 | (37.7222544731451, -122.443973794765) | |
| 75670 | 75670 | 43444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.722204720867204 | -122.443859538611 | (37.7222047208672, -122.443859538611) | |
| 82264 | 82264 | 107888 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) |
| 93570 | 93570 | 111448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | |||
| 96833 | 96833 | 107891 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 96890 | 96890 | 111446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 101787 | 101787 | 107890 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 111981 | 111981 | 43455 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||
| 113461 | 113461 | 111447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 123447 | 123447 | 43449 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | |
| 133363 | 133363 | 43450 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.72188004492379 | -122.443027412104 | (37.7218800449238, -122.443027412104) | |
| 134509 | 134509 | 43456 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999514.70275 | 2091259.45123 | 37.722172053891704 | -122.44377585219699 | (37.7221720538917, -122.443775852197) | |
| 135134 | 135134 | 43451 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.131580001 | 2091140.9715900002 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | |
| 137253 | 137253 | 43440 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.722017576445204 | -122.44337860813499 | (37.7220175764452, -122.443378608135) | |
| 141680 | 141680 | 107889 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | |
| 147696 | 147696 | 43438 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | |
| 153063 | 153063 | 43436 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.9704599995 | 2091192.0487400002 | 37.721994582572606 | -122.44331034060801 | (37.7219945825726, -122.443310340608) | |
| 155143 | 155143 | 43447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | |
| 162227 | 162227 | 111441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5 | 5999897.1183 | 2091063.84845 | 37.721656778309494 | -122.442439902078 | (37.7216567783095, -122.442439902078) | |||
| 162642 | 162642 | 43446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.44323108247299 | (37.721961717728, -122.443231082473) | |
| 180178 | 180178 | 111442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 8 | 5999909.42688 | 2091057.1743400001 | 37.721639154299204 | -122.44239687581002 | (37.7216391542992, -122.44239687581) | |||
| 181064 | 181064 | 43454 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 11 | Permit Number 43162 | 5999613.63458 | 2091208.86715 | 37.722038804018204 | -122.443430238238 | (37.7220388040182, -122.443430238238) | |
| 182202 | 182202 | 111445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 7 | 5999980.8477300005 | 2091017.84349 | 37.721535231343296 | -122.442147171851 | (37.7215352313433, -122.442147171851) | |||
| 183638 | 183638 | 111439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6 | 5999870.68262 | 2091075.2427400001 | 37.721686557579204 | -122.44253210058201 | (37.7216865575792, -122.442532100582) | |||
| 187095 | 187095 | 43432 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | |
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
| 1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 4588 | 4588 | 200921 | Permitted Site 1 | Tristania conferta :: 79 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | |
| 5209 | 5209 | 169218 | Permitted Site 1 | Potential Site :: Potential Site 29 | 824 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006905.3054599995 | 2113639.6299099997 | 37.7840416758297 | -122.419815533287 | (37.7840416758297, -122.419815533287) | ||
| 5210 | 5210 | 83637 | Permitted Site 1 | Tree(s) :: 17 | 840 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/19/2005 12:00:00 AM | 3x3 | 6006834.966315799 | 2113631.30048912 | 37.784014842491395 | -122.420058290383 | (37.7840148424914, -122.420058290383) | ||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5217 | 5217 | 169168 | Permitted Site 1 | Potential Site :: Potential Site 29 | 701 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6007051.56678 | 2113380.55802 | 37.7833385660552 | -122.41929113679599 | (37.7833385660552, -122.419291136796) | ||
| 5218 | 5218 | 169214 | Permitted Site 1 | Potential Site :: Potential Site 29 | 724 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | Width 4ft | 6007369.544319999 | 2113705.88387 | 37.7842497348906 | -122.41821413029301 | (37.7842497348906, -122.418214130293) | ||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
| 5223 | 5223 | 74484 | Permitted Site 1 | Tree(s) :: 17 | 749 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778449 | 6007035.08305 | 2113498.23336 | 37.783660745502296 | -122.41935651480301 | (37.7836607455023, -122.419356514803) |
| 5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
| 5227 | 5227 | 169217 | Permitted Site 1 | Potential Site :: Potential Site 29 | 800 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006932.37231 | 2113646.73425 | 37.7840627073778 | -122.41972239586501 | (37.7840627073778, -122.419722395865) | ||
| 5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5234 | 5234 | 169170 | Permitted Site 1 | Potential Site :: Potential Site 29 | 750 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006877.9642199995 | 2113290.02776 | 37.7830802133315 | -122.419885308057 | (37.7830802133315, -122.419885308057) | ||
| 5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5238 | 5238 | 169219 | Permitted Site 1 | Potential Site :: Potential Site 29 | 840 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006827.36035 | 2113629.7400599997 | 37.7840101293977 | -122.42008449353001 | (37.7840101293977, -122.42008449353) | ||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
| 22149 | 22149 | 16024 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 776129 | 6001188.36813 | 2094689.80455 | 37.731686341545206 | -122.43823603107799 | (37.7316863415452, -122.438236031078) |
| 26614 | 26614 | 98657 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002607.56666 | 2119218.5959900003 | 37.7991170337862 | -122.43508328318701 | (37.7991170337862, -122.435083283187) | ||
| 31571 | 31571 | 98656 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.799126161900396 | -122.435006269744 | (37.7991261619004, -122.435006269744) | ||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 44207 | 44207 | 98648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | ||
| 52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
| 53064 | 53064 | 98650 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002693.158 | 2119231.9709099997 | 37.799158617543604 | -122.43478806542801 | (37.7991586175436, -122.434788065428) | ||
| 61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
| 62828 | 62828 | 5490 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 714 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/28/2015 12:00:00 AM | 1 | 4X4 | Permit Number 774286 | 6004953.58017 | 2104162.27117 | 37.757908995925206 | -122.425892952911 | (37.7579089959252, -122.425892952911) |
| 69128 | 69128 | 98649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.799162328147794 | -122.434737597267 | (37.7991623281478, -122.434737597267) | ||
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 71504 | 71504 | 98651 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.799148474973705 | -122.434853527066 | (37.7991484749737, -122.434853527066) | ||
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 74427 | 74427 | 67860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.43439798360501 | (37.7992088356751, -122.434397983605) |
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 85658 | 85658 | 96467 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 89325 | 89325 | 96464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 89333 | 89333 | 104727 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1079 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | Permit Number 770313 | 6004450.0 | 2102615.0 | 37.7536320814231 | -122.427524315639 | (37.7536320814231, -122.427524315639) | ||
| 92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 94772 | 94772 | 98675 | Permitted Site 1 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96184 | 96184 | 102636 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2176 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/08/2013 12:00:00 AM | 3 | 5x5 | Permit Number 769974 | 6006850.0 | 2105688.0 | 37.7622052831774 | -122.41944256138001 | (37.7622052831774, -122.41944256138) |
| 101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 103701 | 103701 | 96466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 105652 | 105652 | 98659 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | ||
| 109180 | 109180 | 102635 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2176 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/08/2013 12:00:00 AM | 3 | 5x5 | Permit Number 769974 | 6006850.0 | 2105688.0 | 37.7622052831774 | -122.41944256138001 | (37.7622052831774, -122.41944256138) |
| 109229 | 109229 | 93013 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2395 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6000915.0 | 2119261.0 | 37.7991372104515 | -122.440943166878 | (37.7991372104515, -122.440943166878) |
| 110539 | 110539 | 14250 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767173 | 6004759.8459002 | 2108188.2274393 | 37.7689523618819 | -122.426849682313 | (37.7689523618819, -122.426849682313) |
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");