trees
27,746 rows where qCaretaker_id = 1 sorted by qCareAssistant descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1090 | 260553 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 09/21/2019 12:00:00 AM | 3 | ||||||||||||
2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
6898 | 43451 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.13158 | 2091140.97159 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | 9 | 7 | 6 | 28861 | 25 | |
6925 | 43437 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.91122 | 37.7223551630339 | -122.444242104791 | (37.7223551630339, -122.444242104791) | 9 | 7 | 6 | 28861 | 25 | |
8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
14808 | 43442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.7222544731451 | -122.443973794765 | (37.7222544731451, -122.443973794765) | 9 | 7 | 6 | 28861 | 25 | |
15094 | 43443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.7222365289812 | -122.44393453037 | (37.7222365289812, -122.44393453037) | 9 | 7 | 6 | 28861 | 25 | |
15705 | 260554 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/26/2017 12:00:00 AM | 3 | ||||||||||||
24009 | 43438 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | 9 | 7 | 6 | 28861 | 25 | |
27209 | 43436 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.97046 | 2091192.04874 | 37.7219945825726 | -122.443310340608 | (37.7219945825726, -122.443310340608) | 9 | 7 | 6 | 28861 | 25 | |
27628 | 43446 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.443231082473 | (37.721961717728, -122.443231082473) | 9 | 7 | 6 | 28861 | 25 | |
30190 | 43448 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | 9 | 7 | 6 | 28861 | 25 | |
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
41146 | 43456 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999514.70275 | 2091259.45123 | 37.7221720538917 | -122.443775852197 | (37.7221720538917, -122.443775852197) | 9 | 7 | 6 | 28861 | 25 | |
49365 | 43453 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | 9 | 7 | 6 | 28861 | 25 | |
51635 | 43454 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 11 | Permit Number 43162 | 5999613.63458 | 2091208.86715 | 37.7220388040182 | -122.443430238238 | (37.7220388040182, -122.443430238238) | 9 | 7 | 6 | 28861 | 25 | |
52169 | 111442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 8 | 5999909.42688 | 2091057.17434 | 37.7216391542992 | -122.44239687581 | (37.7216391542992, -122.44239687581) | 9 | 7 | 6 | 28861 | 25 | |||
55608 | 43458 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | 9 | 7 | 6 | 28861 | 25 | |
62163 | 144 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | 15 | 5 | 5 | 28862 | 3 | ||
65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
67117 | 105655 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
71335 | 43459 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.48027 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | 9 | 7 | 6 | 28861 | 25 | |
74404 | 111444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.7215516403644 | -122.442184051271 | (37.7215516403644, -122.442184051271) | 9 | 7 | 6 | 28861 | 25 | ||
74998 | 43439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.7222809168058 | -122.444048388121 | (37.7222809168058, -122.444048388121) | 9 | 7 | 6 | 28861 | 25 | |
79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
82890 | 43444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.7222047208672 | -122.443859538611 | (37.7222047208672, -122.443859538611) | 9 | 7 | 6 | 28861 | 25 | |
83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
92535 | 107891 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
99974 | 43441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | 9 | 7 | 6 | 28861 | 25 | |
102600 | 107890 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
105012 | 43447 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | 9 | 7 | 6 | 28861 | 25 | |
113750 | 43445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.442573589903 | (37.7217053974709, -122.442573589903) | 9 | 7 | 6 | 28861 | 25 | |
116073 | 111445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 7 | 5999980.84773 | 2091017.84349 | 37.7215352313433 | -122.442147171851 | (37.7215352313433, -122.442147171851) | 9 | 7 | 6 | 28861 | 25 | |||
126055 | 43435 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.442711119627 | (37.7217631321556, -122.442711119627) | 9 | 7 | 6 | 28861 | 25 | |
129541 | 111443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | 9 | 7 | 6 | 28861 | 25 | |||
132280 | 43432 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | 9 | 7 | 6 | 28861 | 25 | |
134473 | 43434 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.83279 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | 9 | 7 | 6 | 28861 | 25 | |
135580 | 111441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5 | 5999897.1183 | 2091063.84845 | 37.7216567783095 | -122.442439902078 | (37.7216567783095, -122.442439902078) | 9 | 7 | 6 | 28861 | 25 | |||
136434 | 43457 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.7221892471271 | -122.443818239036 | (37.7221892471271, -122.443818239036) | 9 | 7 | 6 | 28861 | 25 | |
139145 | 43449 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | 9 | 7 | 6 | 28861 | 25 | |
144216 | 111439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6 | 5999870.68262 | 2091075.24274 | 37.7216865575792 | -122.442532100582 | (37.7216865575792, -122.442532100582) | 9 | 7 | 6 | 28861 | 25 | |||
144463 | 43455 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||
146800 | 172952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.424987312212 | (37.8034425497953, -122.424987312212) | 13 | 9 | 1 | 28858 | 32 | ||
147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
149820 | 43450 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.7218800449238 | -122.443027412104 | (37.7218800449238, -122.443027412104) | 9 | 7 | 6 | 28861 | 25 | |
158125 | 229287 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 420 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 2 | 6x6 | 6004863.64618 | 2105856.17124 | 37.7625549619753 | -122.426324583413 | (37.7625549619753, -122.426324583413) | 8 | 4 | 5 | 28859 | 3 | ||
167633 | 81844 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007169.78114 | 2115706.72596 | 37.7897323105397 | -122.419047208268 | (37.7897323105397, -122.419047208268) | 13 | 9 | 10 | 28858 | 21 |
172013 | 43433 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | 9 | 7 | 6 | 28861 | 25 | |
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
184999 | 43452 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.443557397876 | (37.7220903846374, -122.443557397876) | 9 | 7 | 6 | 28861 | 25 | |
186111 | 105656 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 05/09/2014 12:00:00 AM | 3 | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||
186295 | 105654 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 05/09/2014 12:00:00 AM | 3 | 3x3 | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | |
186898 | 43440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.7220175764452 | -122.443378608135 | (37.7220175764452, -122.443378608135) | 9 | 7 | 6 | 28861 | 25 | |
188774 | 107889 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |
188837 | 184929 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 02/20/2015 12:00:00 AM | 3 | 3x3 | 5983789.7803 | 2102191.0584 | 37.7512778353096 | -122.498939496923 | (37.7512778353096, -122.498939496923) | 1 | 8 | 3 | 29491 | 35 | |
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
74389 | 104447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
86887 | 94302 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
99392 | 94300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||
121115 | 94298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
134290 | 94304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
1707 | 262090 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1728 | 262141 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 2 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
3709 | 33773 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2640 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/23/1996 12:00:00 AM | 12 | Permit Number 37820 | 5999639.77056 | 2117940.89784 | 37.7954398489265 | -122.44526091526 | (37.7954398489265, -122.44526091526) | 13 | 9 | 1 | 57 | 17 | |
4376 | 259271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1721x Taylor St | 5 | Side Yard : Yard | Tree | DPW 1 | Private | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
4881 | 259031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
5089 | 262085 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
5261 | 262386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6005187.2243 | 2109578.99326 | 37.7727952246844 | -122.425470396534 | (37.7727952246844, -122.425470396534) | 7 | 9 | 11 | 28852 | 10 | ||||
5343 | 259035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
5519 | 251279 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | |||
5711 | 253201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:09:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
6781 | 259030 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6786 | 262148 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 9 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
6957 | 259032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
7702 | 262097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
8266 | 253200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:07:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
8619 | 262142 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 3 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
9305 | 251160 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
10029 | 260896 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Front Yard : Cutout | Tree | DPW 1 | Private | 3x3 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
10605 | 260507 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Carver St | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 6009420 | 2098346 | 37.742190207281 | -122.410035530349 | (37.742190207281, -122.410035530349) | 10 | 7 | 7 | 28859 | 2 | |||
10888 | 262140 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 1 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
11644 | 259033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
11844 | 262089 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
11958 | 262083 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
12093 | 262143 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
12562 | 262087 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );