trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
28739 | 11129 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 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 | |||
36964 | 11109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
41017 | 11117 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2054 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6007235.1189832 | 2119374.3616564 | 37.7998064039059 | -122.419081399975 | (37.7998064039059, -122.419081399975) | 5 | 1 | 1 | 28858 | 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 | |||
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 | |||
55261 | 11108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007226.47271 | 2119353.11491 | 37.799747578786 | -122.419109811467 | (37.799747578786, -122.419109811467) | 5 | 1 | 1 | 28858 | 32 | |||
58920 | 11130 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
3630 | 258965 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
5064 | 258966 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
27252 | 17296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007104.29527 | 2109558.64203 | 37.7728474744005 | -122.418837572 | (37.7728474744005, -122.418837572) | 8 | 2 | 9 | 28853 | 19 | |||
28163 | 10573 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | 14 | 2 | 9 | 28853 | 34 | |||
32017 | 116771 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 590X NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009883 | 2111689 | 37.7788530052944 | -122.409376039999 | (37.7788530052944, -122.409376039999) | 14 | 2 | 9 | 28853 | 34 | |||
34758 | 15261 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
40269 | 25702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.401674380603 | (37.7752602760543, -122.401674380603) | 14 | 2 | 9 | 28853 | 34 | |||
40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
41708 | 251371 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
42234 | 25701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012066.85402 | 2110350.08491 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | 14 | 2 | 9 | 28853 | 34 | |||
43589 | 15250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007716.15968 | 2110227.06056 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | 8 | 2 | 9 | 28853 | 34 | |||
51241 | 15259 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6007494.54134 | 2110025.11497 | 37.7741502637452 | -122.417520728591 | (37.7741502637452, -122.417520728591) | 8 | 2 | 9 | 28853 | 19 | |||
51739 | 19375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 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) );