trees
203 rows where Supervisor Districts = 10 and qSpecies_id = 53 sorted by qLegalStatus_id
This data as json, CSV (advanced)
qLegalStatus_id ✖
- DPW Maintained 76
- Permitted Site 70
- Undocumented 57
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4699 | 23132 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | 3 | 1 | 10 | 308 | 23 | ||
| 13713 | 9943 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
| 14581 | 4695 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 4x8 | 6008940.69941 | 2120350.97779 | 37.802583847399 | -122.4132485365 | (37.802583847399, -122.4132485365) | 3 | 1 | 10 | 308 | 23 | |||
| 18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
| 20324 | 4630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6010279.42625 | 2119026.32466 | 37.7990217431564 | -122.408522353672 | (37.7990217431564, -122.408522353672) | 3 | 1 | 10 | 308 | 4 | |||
| 21080 | 11033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1503 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007448.9758793 | 2117473.8836265 | 37.7946002066648 | -122.418206559463 | (37.7946002066648, -122.418206559463) | 5 | 1 | 10 | 28858 | 32 | |||
| 23258 | 4604 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6010907.72336 | 2118541.73775 | 37.7977263519913 | -122.406314062528 | (37.7977263519913, -122.406314062528) | 3 | 1 | 10 | 308 | 23 | |||
| 27435 | 11036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1521 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007446.95336 | 2117561.22726 | 37.79483991673 | -122.41821975317 | (37.79483991673, -122.41821975317) | 5 | 1 | 10 | 28858 | 32 | |||
| 35445 | 253642 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.408234880635 | (37.7988770104459, -122.408234880635) | 3 | 1 | 10 | 308 | 4 | ||||
| 36315 | 4701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456692 | (37.8025035109944, -122.41317456692) | 3 | 1 | 10 | 308 | 23 | |||
| 37409 | 112110 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 37710 | 4753 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
| 39012 | 4754 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
| 39764 | 11100 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007273.5320198 | 2119093.4977666 | 37.7990373853425 | -122.418928545127 | (37.7990373853425, -122.418928545127) | 5 | 1 | 10 | 28858 | 32 | |||
| 41372 | 95268 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
| 44901 | 4596 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
| 47614 | 4599 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
| 48551 | 18500 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 519X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.7894906186413 | -122.408711019419 | (37.7894906186413, -122.408711019419) | 5 | 1 | 10 | 28857 | 21 | |||
| 50702 | 11103 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | 5 | 1 | 10 | 28858 | 32 | |||
| 52578 | 112111 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 52589 | 11046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007462.42749 | 2117742.73439 | 37.7953391611566 | -122.418179084924 | (37.7953391611566, -122.418179084924) | 5 | 1 | 10 | 28858 | 32 | |||
| 52658 | 4626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010254.83162 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | 3 | 1 | 10 | 308 | 4 | |||
| 54052 | 4709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.66291 | 2120633.4675 | 37.8033402849031 | -122.414452158528 | (37.8033402849031, -122.414452158528) | 3 | 1 | 10 | 308 | 23 | ||
| 54854 | 18511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 626 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6010143.9604039 | 2115933.8512359 | 37.7905229751065 | -122.408772822924 | (37.7905229751065, -122.408772822924) | 5 | 1 | 10 | 28857 | 21 | |||
| 55005 | 112827 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
| 64595 | 20258 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x8 | 6009991.46116 | 2120547.45752 | 37.8031822677113 | -122.409626234652 | (37.8031822677113, -122.409626234652) | 3 | 1 | 10 | 308 | 23 | |||
| 71188 | 4619 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6010602.31813 | 2118839.00805 | 37.7985254951528 | -122.407391821594 | (37.7985254951528, -122.407391821594) | 3 | 1 | 10 | 308 | 23 | |||
| 73509 | 21808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
| 74171 | 110682 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 370 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x4 | 6011146.7308 | 2119712.42854 | 37.8009541508763 | -122.405569522927 | (37.8009541508763, -122.405569522927) | 3 | 1 | 10 | 308 | 23 | |||
| 77953 | 4657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
| 79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
| 83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 87782 | 21807 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
| 88644 | 4629 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.408591136664 | (37.7990784717377, -122.408591136664) | 3 | 1 | 10 | 308 | 4 | |||
| 89782 | 4755 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
| 93249 | 9942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
| 94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
| 103171 | 4672 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | 3 | 1 | 10 | 308 | 4 | |||
| 108315 | 251688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008132 | 2115128 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | 13 | 1 | 10 | 28858 | 21 | ||||
| 109285 | 11031 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1469 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6007466.43149 | 2117407.25122 | 37.7944182331434 | -122.418141434433 | (37.7944182331434, -122.418141434433) | 5 | 1 | 10 | 28858 | 32 | |||
| 113684 | 13012 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 6010380.84909 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | 3 | 1 | 10 | 308 | 23 | |||
| 119311 | 4652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
| 119461 | 11088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
| 122874 | 94039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009288 | 2119899 | 37.801362320674 | -122.412014738208 | (37.801362320674, -122.412014738208) | 3 | 1 | 10 | 308 | 4 | |||
| 124571 | 98660 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008942.64461 | 2120384.58796 | 37.8026762417443 | -122.41324418324 | (37.8026762417443, -122.41324418324) | 3 | 1 | 10 | 308 | 23 | |||
| 126231 | 112107 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 127504 | 4686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009336.3456 | 2120034.69791 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | 3 | 1 | 10 | 308 | 23 | |||
| 132857 | 11053 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007388.39144 | 2117874.05515 | 37.795695567741 | -122.418444578472 | (37.795695567741, -122.418444578472) | 5 | 1 | 10 | 28858 | 32 | |||
| 138724 | 19491 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
| 138743 | 11090 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1903 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6x6 | 6007250.95739 | 2118862.55474 | 37.7984020026002 | -122.418990272151 | (37.7984020026002, -122.418990272151) | 5 | 1 | 10 | 28858 | 32 | |||
| 139551 | 112828 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
| 140945 | 4683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) | 3 | 1 | 10 | 308 | 4 | |||
| 141238 | 11085 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1865 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6007279.7286506 | 2118687.2113849 | 37.7979221737821 | -122.418878272086 | (37.7979221737821, -122.418878272086) | 5 | 1 | 10 | 28858 | 32 | |||
| 142924 | 18508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
| 143163 | 4654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
| 145382 | 56574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100x Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6010338.9406 | 2121168.3232 | 37.8049064763082 | -122.408467587357 | (37.8049064763082, -122.408467587357) | 3 | 1 | 10 | 308 | 23 | ||||
| 145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 148636 | 112826 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
| 151930 | 18509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
| 151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
| 154973 | 21805 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
| 155532 | 13054 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 562 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6009643.06131 | 2120540.81886 | 37.80314451067 | -122.41083141813 | (37.80314451067, -122.41083141813) | 3 | 1 | 10 | 308 | 23 | |||
| 160977 | 4597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
| 162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
| 166051 | 18510 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
| 166466 | 11087 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
| 168362 | 95269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |||
| 170847 | 4631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 430 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010350.91598 | 2119042.69079 | 37.799070683936 | -122.408276129064 | (37.799070683936, -122.408276129064) | 3 | 1 | 10 | 308 | 23 | |||
| 173250 | 11082 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007286.9943087 | 2118635.1241552 | 37.7977795644032 | -122.418849434729 | (37.7977795644032, -122.418849434729) | 5 | 1 | 10 | 28858 | 32 | |||
| 175319 | 11028 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1449 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007474.68946 | 2117365.61582 | 37.7943043774737 | -122.418109907661 | (37.7943043774737, -122.418109907661) | 5 | 1 | 10 | 28858 | 32 | |||
| 175894 | 13036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2015 08:35:00 AM | 3 | 3X3 | 6010019.32094 | 2120615.54911 | 37.80337079145 | -122.409534633266 | (37.80337079145, -122.409534633266) | 3 | 1 | 10 | 308 | 23 | ||
| 177573 | 4627 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 420 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010403.3977 | 2118996.04309 | 37.7989455393885 | -122.408091232197 | (37.7989455393885, -122.408091232197) | 3 | 1 | 10 | 308 | 23 | |||
| 182166 | 11086 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
| 184105 | 112108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
| 193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
| 2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
| 3804 | 117402 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
| 11284 | 117186 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
| 12765 | 117400 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
| 13581 | 113413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 16X LEROY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 1x1 | 6008359 | 2116497 | 37.7919691052865 | -122.414988572568 | (37.7919691052865, -122.414988572568) | 5 | 1 | 10 | 28858 | 21 | |||
| 20131 | 113298 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
| 20147 | 103506 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1348 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 28305 | 121625 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
| 28626 | 100399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 4x4 | 6011664 | 2118384 | 37.7973355180624 | -122.403686018548 | (37.7973355180624, -122.403686018548) | 3 | 1 | 10 | 308 | 23 | ||
| 28662 | 99265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | |||||
| 35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
| 41004 | 99266 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
| 43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
| 46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
| 46917 | 122714 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
| 47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
| 52074 | 117185 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
| 56447 | 117399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
| 58111 | 258045 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
| 59611 | 106127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1609 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6009609.6 | 2119208.8 | 37.7994852403002 | -122.410853080764 | (37.7994852403002, -122.410853080764) | 3 | 1 | 10 | 308 | 4 | ||||
| 68154 | 113299 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
| 72817 | 121043 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2125 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
| 73387 | 113573 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007813 | 2120272 | 37.8023036186348 | -122.417145352251 | (37.8023036186348, -122.417145352251) | 5 | 1 | 10 | 308 | 32 | |||
| 74524 | 95408 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1257 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | No record of tree being permitted for planting. | 6006989.2 | 2119073.6 | 37.7989667366731 | -122.419911018667 | (37.7989667366731, -122.419911018667) | 5 | 1 | 10 | 28858 | 32 |
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) );