trees
1,381 rows where qSpecies_id = 54 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
1544 | 245421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443998 | -122.409836678395 | (37.752691443998, -122.409836678395) | 2 | 4 | 7 | 28859 | 19 | |||
1620 | 16991 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | 15 | 5 | 11 | 29492 | 9 | |||
3102 | 245419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | 2 | 4 | 7 | 28859 | 19 | |||
3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
5046 | 245409 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | 2 | 4 | 7 | 28859 | 19 | |||
5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
5517 | 4664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009692.468 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | 3 | 1 | 10 | 308 | 23 | |||
5587 | 4662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.410475352391 | (37.8006133797513, -122.410475352391) | 3 | 1 | 10 | 308 | 23 | |||
6070 | 519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | 2 | 4 | 7 | 28859 | 19 | |||
7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
8341 | 16938 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004175.1129 | 2110087.9596 | 37.7741354848182 | -122.429007699423 | (37.7741354848182, -122.429007699423) | 7 | 9 | 11 | 28852 | 10 | |||
8801 | 138109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004876.0712 | 2114750.6655 | 37.7869777775164 | -122.426915105637 | (37.7869777775164, -122.426915105637) | 13 | 9 | 11 | 28858 | 27 | |||
9158 | 4659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.8004895753531 | -122.410288343699 | (37.8004895753531, -122.410288343699) | 3 | 1 | 10 | 308 | 23 | |||
9948 | 16864 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | 7 | 9 | 11 | 28852 | 10 | |||
11681 | 245470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.7530025990603 | -122.406625332729 | (37.7530025990603, -122.406625332729) | 10 | 4 | 7 | 28859 | 19 | |||
12248 | 245414 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.7529722724302 | -122.40713647447 | (37.7529722724302, -122.40713647447) | 10 | 4 | 7 | 28859 | 19 | |||
12953 | 4663 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | 3 | 1 | 10 | 308 | 23 | |||
14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
17488 | 245410 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.7529335917078 | -122.407871614204 | (37.7529335917078, -122.407871614204) | 2 | 4 | 7 | 28859 | 19 | |||
17922 | 21738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.433942077336 | (37.7859289122324, -122.433942077336) | 13 | 9 | 11 | 29490 | 13 | |||
19257 | 531 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.7527490975863 | -122.408903610932 | (37.7527490975863, -122.408903610932) | 2 | 4 | 7 | 28859 | 19 | |||
19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 | |||
20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
21641 | 17024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001643.357 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | 15 | 5 | 11 | 29492 | 9 | |||
23530 | 245383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.424260783275 | (37.7369948294896, -122.424260783275) | 2 | 7 | 5 | 28859 | 2 | |||
23592 | 7266 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | 13 | 9 | 11 | 29490 | 13 | |||
23704 | 7163 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.7766622670699 | -122.431275186 | (37.7766622670699, -122.431275186) | 7 | 9 | 11 | 29492 | 10 | |||
23778 | 21585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | 13 | 9 | 11 | 28858 | 27 | |||
23992 | 20166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6002621 | 2112212 | 37.7798794773869 | -122.434535545992 | (37.7798794773869, -122.434535545992) | 15 | 5 | 11 | 29490 | 41 | |||
24027 | 17108 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | 15 | 5 | 11 | 29492 | 9 | |||
24536 | 16993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | 15 | 5 | 11 | 29492 | 10 | |||
24624 | 17680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.435234433978 | (37.7795688238035, -122.435234433978) | 15 | 5 | 11 | 29490 | 41 | |||
26277 | 138359 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.433864291751 | (37.7860784126894, -122.433864291751) | 13 | 9 | 11 | 29490 | 27 | |||
27001 | 7264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.433120195092 | (37.78568958693, -122.433120195092) | 13 | 9 | 11 | 29490 | 13 | |||
27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
28509 | 13126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.429640016754 | (37.8005454550984, -122.429640016754) | 13 | 9 | 1 | 57 | 17 | |||
29405 | 21724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1942X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2003 12:00:00 AM | 17 | 4X4 | 6003291.3026 | 2114524.3217 | 37.786266559771 | -122.432381870835 | (37.786266559771, -122.432381870835) | 13 | 9 | 11 | 29490 | 27 | ||
30158 | 244277 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
30570 | 9642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.434877632371 | (37.7792542228164, -122.434877632371) | 15 | 5 | 11 | 29490 | 41 | |||
32007 | 7200 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | 15 | 9 | 11 | 29492 | 41 | |||
32198 | 143018 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 404 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010387.0782 | 2120648.4016 | 37.8034815958882 | -122.408264308054 | (37.8034815958882, -122.408264308054) | 3 | 1 | 10 | 308 | 23 | |||
33065 | 15307 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.7714348870341 | -122.419572183108 | (37.7714348870341, -122.419572183108) | 8 | 2 | 9 | 28853 | 19 | ||
33663 | 14813 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.7785794305459 | -122.431524477475 | (37.7785794305459, -122.431524477475) | 15 | 9 | 11 | 29492 | 41 | |||
34326 | 138368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002679.2262 | 2114443.3671 | 37.786009553219 | -122.434493703661 | (37.786009553219, -122.434493703661) | 13 | 9 | 11 | 29490 | 27 | |||
34430 | 13280 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.443221023077 | (37.7990441048198, -122.443221023077) | 13 | 9 | 1 | 57 | 17 | ||
34952 | 21609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | 13 | 9 | 11 | 28858 | 13 | ||
35150 | 138369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.7859979081747 | -122.434539711553 | (37.7859979081747, -122.434539711553) | 13 | 9 | 11 | 29490 | 27 | |||
37007 | 13191 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002470.5921 | 2119469.4635 | 37.7997980716779 | -122.435575217756 | (37.7997980716779, -122.435575217756) | 13 | 9 | 1 | 57 | 17 | |||
37114 | 13143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | 13 | 9 | 1 | 57 | 17 | |||
38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
39112 | 14585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918 | (37.7700327707282, -122.44520049918) | 15 | 5 | 11 | 29492 | 9 | |||
39698 | 17058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.440245097963 | (37.7727028580257, -122.440245097963) | 15 | 5 | 11 | 29492 | 9 | |||
39745 | 142504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | 3 | 1 | 10 | 308 | 23 | ||
40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
41692 | 138365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.7860352620012 | -122.434254240878 | (37.7860352620012, -122.434254240878) | 13 | 9 | 11 | 29490 | 27 | |||
42174 | 15298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 6006986.0945 | 2109290.5977 | 37.7721048323796 | -122.419227425547 | (37.7721048323796, -122.419227425547) | 8 | 2 | 9 | 28853 | 19 | ||||
42302 | 16867 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.423214402753 | (37.7748765923478, -122.423214402753) | 7 | 9 | 11 | 28852 | 10 | |||
43116 | 18005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.7870944645688 | -122.439833960351 | (37.7870944645688, -122.439833960351) | 13 | 6 | 1 | 29490 | 27 | |||
43162 | 138126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003024.8426 | 2114663.3242 | 37.7866331126192 | -122.433313688795 | (37.7866331126192, -122.433313688795) | 13 | 9 | 11 | 29490 | 27 | |||
43362 | 13125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | 13 | 9 | 1 | 57 | 17 | ||
43620 | 12248 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004985.728 | 2110723.6115 | 37.7759266811529 | -122.426248902156 | (37.7759266811529, -122.426248902156) | 7 | 9 | 11 | 28852 | 10 | |||
44629 | 13097 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005336.846 | 2119866.4127 | 37.8010503698402 | -122.42568517574 | (37.8010503698402, -122.42568517574) | 13 | 9 | 1 | 57 | 17 | |||
45674 | 9652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.7734299424642 | -122.42238619159 | (37.7734299424642, -122.42238619159) | 7 | 9 | 11 | 28852 | 10 | ||
46647 | 494 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.7528808308555 | -122.406751179708 | (37.7528808308555, -122.406751179708) | 10 | 4 | 7 | 28859 | 19 | |||
46681 | 15435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | 8 | 4 | 7 | 28859 | 19 | |||
47554 | 25267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.460649859339 | (37.7249427634406, -122.460649859339) | 9 | 8 | 4 | 28861 | 40 | |||
47862 | 17675 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.7794417346192 | -122.435215744209 | (37.7794417346192, -122.435215744209) | 15 | 5 | 11 | 29490 | 41 | |||
48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 2 | 7 | 7 | 28859 | 2 | |||
48736 | 22785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.440094040754 | (37.7793954847522, -122.440094040754) | 15 | 5 | 11 | 29490 | 41 | |||
50824 | 21628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/1994 12:00:00 AM | 6 | 4X4 | 6004654.6857 | 2114664.3643 | 37.7867282957499 | -122.427674898563 | (37.7867282957499, -122.427674898563) | 13 | 9 | 11 | 28858 | 13 | ||
51830 | 13226 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2265 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 6001595.9478 | 2119347.0943 | 37.7994123621689 | -122.438593032687 | (37.7994123621689, -122.438593032687) | 13 | 9 | 1 | 57 | 17 | ||||
52733 | 4510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1805X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998343.9349 | 2109273.4537 | 37.7715672642721 | -122.449119990901 | (37.7715672642721, -122.449119990901) | 15 | 5 | 11 | 29492 | 9 | |||
55100 | 138362 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002806.585 | 2114457.2427 | 37.7860548808328 | -122.434054069465 | (37.7860548808328, -122.434054069465) | 13 | 9 | 11 | 29490 | 27 | |||
56244 | 28068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3445 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5996452.8473 | 2112841.7002 | 37.78125639187 | -122.455919329089 | (37.78125639187, -122.455919329089) | 11 | 6 | 2 | 54 | 16 | |||
56271 | 514 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.7529262972422 | -122.407932936557 | (37.7529262972422, -122.407932936557) | 2 | 4 | 7 | 28859 | 19 | |||
57601 | 7155 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 710 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003553.4142 | 2110901.6518 | 37.776334472306 | -122.431216355856 | (37.776334472306, -122.431216355856) | 7 | 9 | 11 | 29492 | 10 | |||
57901 | 492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010397.1581 | 2102215.0511 | 37.7528684941587 | -122.406929439613 | (37.7528684941587, -122.406929439613) | 10 | 4 | 7 | 28859 | 19 | |||
58363 | 16974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 785 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003248.3505 | 2109954.9799 | 37.7737178528926 | -122.432204032613 | (37.7737178528926, -122.432204032613) | 15 | 9 | 11 | 29492 | 10 | |||
58460 | 138112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6004508.5013 | 2114699.1479 | 37.7868155327596 | -122.428183141793 | (37.7868155327596, -122.428183141793) | 13 | 9 | 11 | 28858 | 27 | |||
59417 | 6235 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | 7 | 9 | 11 | 28858 | 41 | ||
60844 | 7158 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003514.1332 | 2110837.5014 | 37.7761561050706 | -122.431347659332 | (37.7761561050706, -122.431347659332) | 15 | 9 | 11 | 29492 | 10 | |||
61537 | 487 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | 10 | 4 | 7 | 28859 | 19 | |||
61639 | 498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770282 | (37.7529579449469, -122.40743770282) | 2 | 4 | 7 | 28859 | 19 | |||
63562 | 7252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003031.0875 | 2114271.6252 | 37.7855579606737 | -122.433264083866 | (37.7855579606737, -122.433264083866) | 13 | 9 | 11 | 29490 | 13 | |||
63571 | 4684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.8016265338502 | -122.411938460907 | (37.8016265338502, -122.411938460907) | 3 | 1 | 10 | 308 | 23 | |||
63639 | 17679 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | 15 | 5 | 11 | 29490 | 41 | |||
64439 | 15768 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.7218034493139 | -122.437092531149 | (37.7218034493139, -122.437092531149) | 9 | 7 | 6 | 28861 | 25 | ||
65948 | 497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.7528893415843 | -122.406517264254 | (37.7528893415843, -122.406517264254) | 10 | 4 | 7 | 28859 | 19 | |||
66541 | 6994 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003272.598 | 2110360.763 | 37.7748334078832 | -122.432149140862 | (37.7748334078832, -122.432149140862) | 15 | 9 | 11 | 29492 | 10 | |||
66624 | 138367 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002691.6152 | 2114444.3582 | 37.7860129777854 | -122.434450912019 | (37.7860129777854, -122.434450912019) | 13 | 9 | 11 | 29490 | 27 | |||
66771 | 17128 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | 15 | 5 | 11 | 29492 | 9 | ||
67143 | 7179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.7771965235218 | -122.431551070298 | (37.7771965235218, -122.431551070298) | 15 | 9 | 11 | 29492 | 10 | |||
67458 | 17129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1999 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997503.109 | 2109154.2513 | 37.7711918386222 | -122.452019838592 | (37.7711918386222, -122.452019838592) | 15 | 5 | 11 | 29492 | 9 | |||
67867 | 513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.7529230716135 | -122.407992859485 | (37.7529230716135, -122.407992859485) | 2 | 4 | 7 | 28859 | 19 | |||
68359 | 21709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x9 | 6003440.4648 | 2114551.568 | 37.7863498280943 | -122.431867754773 | (37.7863498280943, -122.431867754773) | 13 | 9 | 11 | 29490 | 27 | |||
70476 | 7391 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.7778930152772 | -122.40623154915 | (37.7778930152772, -122.40623154915) | 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) );