trees
142,615 rows where qLegalStatus_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 | |||
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |
24920 | 81846 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) | 13 | 9 | 10 | 28858 | 21 |
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 | |
40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
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 | |
41337 | 81843 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |
72388 | 82383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 | |
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 | |
82558 | 98222 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
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 | |
87604 | 81841 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
98832 | 81842 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
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 | |
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 | |
111923 | 81845 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.7897041006217 | -122.419274608151 | (37.7897041006217, -122.419274608151) | 13 | 9 | 10 | 28858 | 21 |
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 | |||
116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |||
135831 | 81840 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
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 | |||
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 | ||
147039 | 98216 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.501501543012 | (37.7576365448231, -122.501501543012) | 1 | 8 | 3 | 56 | 35 | ||
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 | |
152631 | 98218 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
153397 | 98220 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
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 |
171772 | 140269 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998144.7463 | 2109987.1343 | 37.7735154534297 | -122.449860434482 | (37.7735154534297, -122.449860434482) | 15 | 5 | 11 | 29492 | 16 | |
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 | |
178823 | 81839 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
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 | |
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 | |
192386 | 98223 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
25159 | 116139 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 11 | 6009237.30915 | 2116708.08381 | 37.7925980056535 | -122.411964529145 | (37.7925980056535, -122.411964529145) | 5 | 1 | 10 | 28857 | 21 | |||
26078 | 103365 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009208.54849 | 2116702.78378 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | 5 | 1 | 10 | 28857 | 21 | ||
26865 | 103362 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009111.87446 | 2116690.26678 | 37.7925420462198 | -122.412397279316 | (37.7925420462198, -122.412397279316) | 5 | 1 | 10 | 28857 | 21 | ||
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 | ||||
56512 | 251807 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 1 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
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 | ||||
122696 | 103363 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.7925553112212 | -122.412292370693 | (37.7925553112212, -122.412292370693) | 5 | 1 | 10 | 28857 | 21 | ||
127023 | 251811 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
128875 | 251813 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 6 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
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 | ||||
144228 | 251810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
153064 | 103364 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.7925702336697 | -122.412185363057 | (37.7925702336697, -122.412185363057) | 5 | 1 | 10 | 28857 | 21 | ||
168582 | 251809 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
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 | |||
2079 | 263595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |
4032 | 263594 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 |
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) );