trees
1,626 rows where qSpecies_id = 53 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95868 | 19217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1103X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002080.8485 | 2110141.50629 | 37.7741637433971 | -122.436255949697 | (37.7741637433971, -122.436255949697) | 15 | 5 | 11 | 29492 | 10 | |||
102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
20699 | 17025 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.7729910525637 | -122.43798896281 | (37.7729910525637, -122.43798896281) | 15 | 5 | 11 | 29492 | 9 | |||
81702 | 93042 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
153620 | 93043 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
121725 | 22672 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1115X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003756.1555 | 2112617.12958 | 37.7810562358648 | -122.430637458337 | (37.7810562358648, -122.430637458337) | 15 | 9 | 11 | 29490 | 41 | |||
119516 | 23795 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1119 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003757.7161484 | 2112550.5292093 | 37.7808734562577 | -122.430627305455 | (37.7808734562577, -122.430627305455) | 15 | 9 | 11 | 29490 | 41 | |||
82935 | 39773 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 |
116920 | 39774 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 | |
45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
158220 | 9662 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6006086.53311 | 2110106.07673 | 37.7742932396102 | -122.422397038566 | (37.7742932396102, -122.422397038566) | 7 | 9 | 11 | 28852 | 10 | |||
63433 | 4418 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004420.05713 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | 2 | 4 | 5 | 28862 | 22 | |||
66815 | 23796 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1133 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003746.01833 | 2112690.85168 | 37.7812580840725 | -122.430677790145 | (37.7812580840725, -122.430677790145) | 15 | 9 | 11 | 29490 | 41 | |||
89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
32743 | 22671 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003752.72615 | 2112639.82159 | 37.7811183481869 | -122.430650941901 | (37.7811183481869, -122.430650941901) | 15 | 9 | 11 | 29490 | 41 | |||
10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
140782 | 120966 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
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 | ||||
98424 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 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 | |||
110239 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
118707 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
121115 | 94298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
134290 | 94304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
67395 | 20160 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
74795 | 20161 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
94472 | 20162 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
38950 | 93145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
105841 | 93144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2016 12:00:00 AM | 3 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||
149202 | 93146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
166398 | 9620 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1165X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 50 | 3X3 | 6002862.99505 | 2112096.1743 | 37.779575183286 | -122.433690098242 | (37.779575183286, -122.433690098242) | 15 | 9 | 11 | 29490 | 41 | ||
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
44254 | 20167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
151621 | 482 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.7532012773937 | -122.406450377502 | (37.7532012773937, -122.406450377502) | 10 | 4 | 7 | 28859 | 19 | |||
31123 | 18463 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
59584 | 18467 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
22613 | 7891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | 13 | 9 | 11 | 28858 | 41 | |||
172889 | 7892 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006000.38049 | 2113895.86172 | 37.7846942050769 | -122.422964467171 | (37.7846942050769, -122.422964467171) | 13 | 9 | 11 | 28858 | 41 | |||
60815 | 14812 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1190X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003455.90906 | 2111772.60341 | 37.7787203633271 | -122.431615848033 | (37.7787203633271, -122.431615848033) | 15 | 9 | 11 | 29490 | 41 | |||
31137 | 4747 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1199X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3X4 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | |||
138529 | 4746 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1199X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X4 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | |||
36076 | 111627 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
183049 | 111628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
141056 | 121371 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
147215 | 121369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
28345 | 6727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
122954 | 6709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
142509 | 6722 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
43961 | 17044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
61483 | 17037 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | 15 | 5 | 11 | 29492 | 10 | |||
188552 | 17045 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
28468 | 23821 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
30119 | 23811 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
43323 | 23820 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
48251 | 23814 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
61535 | 5622 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.7500355321086 | -122.425175538874 | (37.7500355321086, -122.425175538874) | 2 | 4 | 5 | 28862 | 22 | |||
25241 | 8179 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1205X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
65361 | 17049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1209 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001136.98076 | 2109644.95458 | 37.7727466639243 | -122.439485345621 | (37.7727466639243, -122.439485345621) | 15 | 5 | 11 | 29492 | 9 | |||
19484 | 77283 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | 15 | 5 | 11 | 29492 | 10 | |||
14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
43860 | 8182 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | 15 | 5 | 11 | 29492 | 41 | |||
135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
100953 | 8184 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1225 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001879.34509 | 2111133.55167 | 37.7768762007109 | -122.437024023016 | (37.7768762007109, -122.437024023016) | 15 | 5 | 11 | 29492 | 10 | |||
83236 | 7211 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1225X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003292.0475526 | 2111699.258462 | 37.7785096871743 | -122.432177469127 | (37.7785096871743, -122.432177469127) | 15 | 9 | 11 | 29492 | 41 | |||
94460 | 101975 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1230 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769454 | 6013882 | 2105282.2 | 37.7614846061652 | -122.395092936828 | (37.7614846061652, -122.395092936828) | 10 | 3 | 8 | 28856 | 29 | |||
74073 | 7223 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | 15 | 9 | 11 | 29490 | 41 | |||
92133 | 62276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 124 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 13 | 21x6 | Permit Number 22414 | 6003841.87853288 | 2108837.79837285 | 37.7706839798213 | -122.430071215032 | (37.7706839798213, -122.430071215032) | 7 | 9 | 11 | 29492 | 10 | |
124630 | 54736 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1993 12:00:00 AM | 12 | 5x5 | Permit Number 31998 | 5994208.55249488 | 2107032.01090972 | 37.7651754625969 | -122.463261729084 | (37.7651754625969, -122.463261729084) | 11 | 5 | 11 | 56 | 12 | |
170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
140268 | 54410 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1248 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 10182 | 5993332.64911234 | 2106987.54521442 | 37.765002872173 | -122.46628801063 | (37.765002872173, -122.46628801063) | 11 | 8 | 11 | 56 | 12 | |||
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 | |||
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 | ||
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 | |||
150358 | 258047 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | 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 | ||
168220 | 258046 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 2 | 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 | ||
103514 | 4559 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 10x6 | 6005144.0595933 | 2101075.0968609 | 37.7494430966122 | -122.425014546007 | (37.7494430966122, -122.425014546007) | 2 | 4 | 5 | 28862 | 22 | |||
27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 | ||||
192632 | 5633 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
91220 | 120660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
49452 | 86740 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | |||||
33408 | 6246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | 7 | 9 | 11 | 28858 | 41 | |||
192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 |
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) );