trees
3,965 rows where qSpecies_id = 70 sorted by Police Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31693 | 143121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1869 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003430.714 | 2119601.3681 | 37.8002147325944 | -122.432262267287 | (37.8002147325944, -122.432262267287) | 13 | 9 | 1 | 57 | 17 | |||
31758 | 6976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 745X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003866.69137 | 2110390.66671 | 37.774949181297 | -122.430096182274 | (37.774949181297, -122.430096182274) | 7 | 9 | 11 | 29492 | 10 | |||
31878 | 125201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2201 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003579.67641 | 2116899.4218 | 37.7928043289977 | -122.431553796666 | (37.7928043289977, -122.431553796666) | 13 | 9 | 1 | 29490 | 27 | |||
32384 | 46269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2373 REVISED Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 44553 | 6003358.75375 | 2116535.00791 | 37.7917912175406 | -122.432292160763 | (37.7917912175406, -122.432292160763) | 13 | 9 | 1 | 29490 | 27 | |||
32460 | 46703 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 332(North) Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2002 12:00:00 AM | Permit Number 44834 | 6005821.63060952 | 2110714.77999165 | 37.7759496446584 | -122.423356666691 | (37.7759496446584, -122.423356666691) | 7 | 9 | 11 | 28852 | 10 | |||
32479 | 125072 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2559 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002527.91845 | 2116093.19627 | 37.7905309723786 | -122.435135231625 | (37.7905309723786, -122.435135231625) | 13 | 9 | 1 | 29490 | 27 | |||
32695 | 38515 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
32977 | 125002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 69 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001637.34931 | 2120884.52761 | 37.8036361027929 | -122.438559986648 | (37.8036361027929, -122.438559986648) | 13 | 9 | 1 | 57 | 17 | |||
32979 | 125014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999712.95085 | 2121535.70639 | 37.8053144077071 | -122.445266286916 | (37.8053144077071, -122.445266286916) | 13 | 9 | 1 | 57 | 17 | |||
33026 | 125054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1733 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002453.36276 | 2120887.52869 | 37.8036907276167 | -122.435736350154 | (37.8036907276167, -122.435736350154) | 13 | 9 | 1 | 57 | 17 | |||
33190 | 7922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1295X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x6 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | 13 | 9 | 1 | 28858 | 41 | |||
33207 | 124998 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001147.91549 | 2121233.53954 | 37.8045665431681 | -122.440278736772 | (37.8045665431681, -122.440278736772) | 13 | 9 | 1 | 57 | 17 | |||
33344 | 125185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2757 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002077.54743 | 2117675.01873 | 37.7948486633864 | -122.436806769111 | (37.7948486633864, -122.436806769111) | 13 | 9 | 1 | 57 | 27 | |||
33368 | 103490 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001053.62878 | 2117568.22705 | 37.7944971957398 | -122.440342000495 | (37.7944971957398, -122.440342000495) | 13 | 9 | 1 | 57 | 27 | |||
33407 | 125055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1725 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002469.3064 | 2120890.0959 | 37.8036986821095 | -122.435681360206 | (37.8036986821095, -122.435681360206) | 13 | 9 | 1 | 57 | 17 | |||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
34132 | 111168 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003190.19669 | 2119810.74673 | 37.8007759915841 | -122.43310951859 | (37.8007759915841, -122.43310951859) | 13 | 9 | 1 | 57 | 17 | |||
34145 | 23560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2909 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005511.81289 | 2120357.28421 | 37.8024080624664 | -122.425114661564 | (37.8024080624664, -122.425114661564) | 13 | 9 | 1 | 28858 | 17 | |||
34218 | 32423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.60357 | 37.7961002417749 | -122.442810555866 | (37.7961002417749, -122.442810555866) | 13 | 9 | 1 | 57 | 17 | ||
34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
34748 | 125237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007164.82088 | 2113970.50384 | 37.7849647912426 | -122.418941177317 | (37.7849647912426, -122.418941177317) | 7 | 9 | 9 | 28858 | 36 | |||
35606 | 124793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2661 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6000281.59874 | 2118154.61893 | 37.7960632859464 | -122.443055444859 | (37.7960632859464, -122.443055444859) | 13 | 9 | 1 | 57 | 17 | |||
35847 | 249706 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 5999689.68932 | 2117193.09573 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | 13 | 9 | 1 | 57 | 27 | ||||
36070 | 125169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2647 Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6001017.71367 | 2117559.63744 | 37.7944715659634 | -122.440465654581 | (37.7944715659634, -122.440465654581) | 13 | 9 | 1 | 57 | 27 | |||
36081 | 124796 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000021.82645 | 2118165.23175 | 37.7960776112345 | -122.443955068183 | (37.7960776112345, -122.443955068183) | 13 | 9 | 1 | 57 | 17 | |||
36128 | 124795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2643 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000315.12191 | 2118159.5515 | 37.7960787407936 | -122.442939802828 | (37.7960787407936, -122.442939802828) | 13 | 9 | 1 | 57 | 17 | |||
36156 | 22614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.7813650138202 | -122.424863625752 | (37.7813650138202, -122.424863625752) | 7 | 9 | 11 | 28852 | 41 | |||
36351 | 125212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2010 Washington St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6004876.33851 | 2116792.20983 | 37.7925833601806 | -122.427059645199 | (37.7925833601806, -122.427059645199) | 13 | 9 | 1 | 28858 | 27 | |||
36573 | 221400 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 165 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 4ft | 6006595.83672 | 2110769.76227 | 37.776144277484 | -122.420682385305 | (37.776144277484, -122.420682385305) | 7 | 9 | 11 | 28852 | 10 | |||
36643 | 124791 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 5999559.93091 | 2118054.14735 | 37.7957462443483 | -122.445545320468 | (37.7957462443483, -122.445545320468) | 13 | 9 | 1 | 57 | 17 | |||
36994 | 124856 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Casa Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001727.95085 | 2121436.12662 | 37.8051558005727 | -122.438285996516 | (37.8051558005727, -122.438285996516) | 13 | 9 | 1 | 57 | 17 | |||
37590 | 30343 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 27 | 6001958.22163 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | 13 | 9 | 1 | 57 | 17 | |||
37965 | 102748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | Permit Number 20974 | 6001048.4849 | 2118395.31546 | 37.7967678705825 | -122.440419145231 | (37.7967678705825, -122.440419145231) | 13 | 9 | 1 | 57 | 17 | ||
38058 | 125020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1430 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002377.05102 | 2121615.30854 | 37.8056846837514 | -122.4360525401 | (37.8056846837514, -122.4360525401) | 13 | 9 | 1 | 57 | 17 | |||
38163 | 124799 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2898 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999275.03219 | 2118059.61295 | 37.7957449825994 | -122.446531511646 | (37.7957449825994, -122.446531511646) | 13 | 9 | 1 | 57 | 17 | |||
38186 | 124830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 22 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001797.45608 | 2121257.60424 | 37.8046695785138 | -122.438032670081 | (37.8046695785138, -122.438032670081) | 13 | 9 | 1 | 57 | 17 | |||
38210 | 9930 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2336 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6005037.50257 | 2117672.21432 | 37.7950087418189 | -122.426564702407 | (37.7950087418189, -122.426564702407) | 13 | 9 | 1 | 28858 | 27 | |||
38233 | 124804 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2740 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 5999772.92008 | 2118822.28099 | 37.7978674923354 | -122.444863584908 | (37.7978674923354, -122.444863584908) | 13 | 9 | 1 | 57 | 17 | |||
38356 | 42959 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2616 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | 13 | 9 | 1 | 29490 | 27 | |||
38358 | 117643 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000091.76635 | 2121421.98639 | 37.8050237791735 | -122.443947175743 | (37.8050237791735, -122.443947175743) | 13 | 9 | 1 | 57 | 17 | |||
38606 | 125013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999680.43429 | 2121532.52371 | 37.8053038127916 | -122.445378585257 | (37.8053038127916, -122.445378585257) | 13 | 9 | 1 | 57 | 17 | |||
38870 | 124841 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Retiro Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001779.40776 | 2121521.29923 | 37.8053925884559 | -122.438114029041 | (37.8053925884559, -122.438114029041) | 13 | 9 | 1 | 57 | 17 | |||
39246 | 124870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 15 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6001774.83404 | 2121189.88179 | 37.804482344135 | -122.438106101537 | (37.804482344135, -122.438106101537) | 13 | 9 | 1 | 57 | 17 | |||
39710 | 22631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1188 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004326.62137 | 2112603.43226 | 37.7810509280597 | -122.42866295582 | (37.7810509280597, -122.42866295582) | 7 | 9 | 11 | 29490 | 41 | |||
40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
40598 | 124996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Cervantes Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 2ft | 6000861.45694 | 2121438.45328 | 37.8051128678164 | -122.441284762493 | (37.8051128678164, -122.441284762493) | 13 | 9 | 1 | 57 | 17 | |||
40864 | 59299 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1980 12:00:00 AM | 3 | Permit Number 18637 | 6003797.66413 | 2115784.10582 | 37.7897543079647 | -122.430719923706 | (37.7897543079647, -122.430719923706) | 13 | 9 | 1 | 29490 | 27 | ||
41148 | 124860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55 Retiro Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001745.34087 | 2121386.96215 | 37.8050217970778 | -122.438222292145 | (37.8050217970778, -122.438222292145) | 13 | 9 | 1 | 57 | 17 | |||
41459 | 6968 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 731 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003908.8718 | 2110395.3427 | 37.7749644092731 | -122.429950604798 | (37.7749644092731, -122.429950604798) | 7 | 9 | 11 | 29492 | 10 | |||
41680 | 124839 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001764.30069 | 2121488.69691 | 37.8053022119874 | -122.438163971998 | (37.8053022119874, -122.438163971998) | 13 | 9 | 1 | 57 | 17 | |||
42073 | 10282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.7723369589176 | -122.428103893873 | (37.7723369589176, -122.428103893873) | 7 | 9 | 11 | 28852 | 10 | |||
42294 | 124818 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999369.64058 | 2120155.29961 | 37.8015045809211 | -122.446354985487 | (37.8015045809211, -122.446354985487) | 13 | 9 | 1 | 57 | 17 | |||
42304 | 6160 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.422716161482 | (37.7836802135181, -122.422716161482) | 7 | 9 | 11 | 28858 | 41 | |||
42396 | 141866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1198 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004337.1482 | 2112587.4404 | 37.7810076141312 | -122.428625397981 | (37.7810076141312, -122.428625397981) | 7 | 9 | 11 | 29490 | 41 | |||
42670 | 23505 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6005801.9507 | 2119345.52815 | 37.7996464242096 | -122.424038648866 | (37.7996464242096, -122.424038648866) | 13 | 9 | 1 | 28858 | 32 | |||
43833 | 125183 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002040.40043 | 2117703.29752 | 37.7949241983442 | -122.4369373282 | (37.7949241983442, -122.4369373282) | 13 | 9 | 1 | 57 | 27 | |||
44160 | 125030 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002217.62841 | 2121592.79721 | 37.8056138153882 | -122.436602632017 | (37.8056138153882, -122.436602632017) | 13 | 9 | 1 | 57 | 17 | |||
44168 | 125173 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2657 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6002130.9486 | 2117334.79999 | 37.7939175458228 | -122.436597629997 | (37.7939175458228, -122.436597629997) | 13 | 9 | 1 | 29490 | 27 | |||
45356 | 124967 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2822 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999151.61511 | 2118510.72653 | 37.7969765699709 | -122.44699103461 | (37.7969765699709, -122.44699103461) | 13 | 9 | 1 | 57 | 17 | |||
45516 | 125177 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2507 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001544.92744 | 2117276.65467 | 37.7937245746909 | -122.438621147743 | (37.7937245746909, -122.438621147743) | 13 | 9 | 1 | 29490 | 27 | |||
45732 | 124788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1650 Green St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005141.03726 | 2118532.17196 | 37.7973758194907 | -122.426267712085 | (37.7973758194907, -122.426267712085) | 13 | 9 | 1 | 57 | 17 | |||
45882 | 10255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005448.27784 | 2109623.58668 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | 7 | 9 | 11 | 28852 | 10 | |||
46412 | 125041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1431 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002357.41951 | 2121568.78695 | 37.8055558324875 | -122.436117146515 | (37.8055558324875, -122.436117146515) | 13 | 9 | 1 | 57 | 17 | |||
46630 | 6864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 131 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006755.38635 | 2110787.16515 | 37.7762010525614 | -122.420131694419 | (37.7762010525614, -122.420131694419) | 7 | 9 | 11 | 28852 | 10 | |||
47002 | 17859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003647.2236 | 2115215.6899 | 37.7881850576658 | -122.431199843789 | (37.7881850576658, -122.431199843789) | 13 | 9 | 11 | 29490 | 27 | |||
47397 | 125206 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2006 Washington St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6005017.11491 | 2116813.45375 | 37.7926496501144 | -122.426574067046 | (37.7926496501144, -122.426574067046) | 13 | 9 | 1 | 28858 | 27 | |||
47829 | 6263 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1338X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004383.57489 | 2113288.83653 | 37.7829361010006 | -122.428514794701 | (37.7829361010006, -122.428514794701) | 7 | 9 | 11 | 29490 | 41 | |||
48634 | 141848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1247 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004496.4593 | 2112914.2486 | 37.7819139630639 | -122.428097558211 | (37.7819139630639, -122.428097558211) | 7 | 9 | 11 | 29490 | 41 | |||
48848 | 124979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999598.09637 | 2121437.70787 | 37.805038773582 | -122.445656702412 | (37.805038773582, -122.445656702412) | 13 | 9 | 1 | 57 | 17 | |||
49307 | 125178 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2503 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001601.42132 | 2117287.24929 | 37.7937568783267 | -122.438426433743 | (37.7937568783267, -122.438426433743) | 13 | 9 | 1 | 29490 | 27 | |||
49678 | 125021 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1430 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002357.9608 | 2121612.45473 | 37.8056757633955 | -122.436118400137 | (37.8056757633955, -122.436118400137) | 13 | 9 | 1 | 57 | 17 | |||
49696 | 87086 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50031 | 6002046 | 2118096 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | 13 | 9 | 1 | 57 | 17 | |||
49773 | 111913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6003233.77012 | 2119841.33042 | 37.8008624380147 | -122.432960922718 | (37.8008624380147, -122.432960922718) | 13 | 9 | 1 | 57 | 17 | ||||
49876 | 6909 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Fell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005907.98637 | 2110675.1082 | 37.7758455889488 | -122.423055118828 | (37.7758455889488, -122.423055118828) | 7 | 9 | 11 | 28852 | 10 | |||
49910 | 125009 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3798 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002030.9344 | 2121803.5229 | 37.8061818011087 | -122.437263809985 | (37.8061818011087, -122.437263809985) | 13 | 9 | 1 | 57 | 17 | |||
50248 | 6155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005964.03505 | 2113507.44339 | 37.7836256530431 | -122.423062593089 | (37.7836256530431, -122.423062593089) | 7 | 9 | 11 | 28858 | 41 | |||
50483 | 124988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2152 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6000486.93173 | 2120314.4675 | 37.8020053621167 | -122.442500100005 | (37.8020053621167, -122.442500100005) | 13 | 9 | 1 | 57 | 17 | |||
50653 | 125076 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2561 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002473.87214 | 2116413.37038 | 37.7914070190769 | -122.435345140589 | (37.7914070190769, -122.435345140589) | 13 | 9 | 1 | 29490 | 27 | |||
51116 | 125157 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6000407.15137 | 2117170.88634 | 37.7933693730374 | -122.442550344227 | (37.7933693730374, -122.442550344227) | 13 | 9 | 1 | 57 | 27 | |||
51441 | 17864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.7882259541053 | -122.430845453567 | (37.7882259541053, -122.430845453567) | 13 | 9 | 11 | 29490 | 27 | |||
51559 | 249687 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 19 | Front Yard : Yard | Tree | Private 2 | 37 | 5999715.024 | 2117348.66269 | 37.7938180232448 | -122.444957931866 | (37.7938180232448, -122.444957931866) | 13 | 9 | 1 | 57 | 27 | ||||
52537 | 125187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6001987.81775 | 2117744.14272 | 37.7950333598619 | -122.437122197348 | (37.7950333598619, -122.437122197348) | 13 | 9 | 1 | 57 | 27 | |||
52590 | 73289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
52622 | 124825 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 190 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001088.45735 | 2121331.42825 | 37.8048319340008 | -122.44049152176 | (37.8048319340008, -122.44049152176) | 13 | 9 | 1 | 57 | 17 | |||
52811 | 125027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1448 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002258.73025 | 2121599.52736 | 37.8056346302032 | -122.436460875479 | (37.8056346302032, -122.436460875479) | 13 | 9 | 1 | 57 | 17 | |||
53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
53092 | 125170 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2757 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 4ft | 6000593.65782 | 2117804.41769 | 37.7951195131156 | -122.4419505135 | (37.7951195131156, -122.4419505135) | 13 | 9 | 1 | 57 | 27 | |||
53580 | 125155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6000460.41751 | 2117182.59044 | 37.7934045455351 | -122.442366880739 | (37.7934045455351, -122.442366880739) | 13 | 9 | 1 | 57 | 27 | |||
53598 | 139925 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6005197.5444 | 2112663.4649 | 37.7812650136717 | -122.425654271119 | (37.7812650136717, -122.425654271119) | 7 | 9 | 11 | 28852 | 41 | |||
53784 | 23853 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6003700.6561807 | 2113512.2535027 | 37.7835108780695 | -122.430893359317 | (37.7835108780695, -122.430893359317) | 13 | 9 | 11 | 29490 | 41 | |||
53909 | 124980 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3715 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999618.92595 | 2121303.95434 | 37.804672711733 | -122.445574995388 | (37.804672711733, -122.445574995388) | 13 | 9 | 1 | 57 | 17 | |||
54120 | 124991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 299 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000675.70773 | 2121565.63023 | 37.8054514787685 | -122.441936701718 | (37.8054514787685, -122.441936701718) | 13 | 9 | 1 | 57 | 17 | |||
54202 | 107622 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 HAIGHT ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | 6005238.1 | 2109520.1 | 37.7726363924224 | -122.425290219951 | (37.7726363924224, -122.425290219951) | 7 | 9 | 11 | 28852 | 10 | ||||
54642 | 124869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 19 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001772.24863 | 2121209.38367 | 37.8045357440831 | -122.438116446413 | (37.8045357440831, -122.438116446413) | 13 | 9 | 1 | 57 | 17 | |||
55680 | 137663 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 820 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6003458.892 | 2110384.4612 | 37.7749090377732 | -122.431506403609 | (37.7749090377732, -122.431506403609) | 15 | 9 | 11 | 29492 | 10 | |||
55696 | 124779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000978.44845 | 2118912.97952 | 37.7981852516096 | -122.440698637428 | (37.7981852516096, -122.440698637428) | 13 | 9 | 1 | 57 | 17 | |||
55738 | 102747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | Permit Number 20974 | 6001053.30266 | 2118369.08064 | 37.7966961109838 | -122.44040059224 | (37.7966961109838, -122.44040059224) | 13 | 9 | 1 | 57 | 17 | ||
55934 | 10263 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 212 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005030.70582 | 2109564.31462 | 37.7727460760509 | -122.426010766966 | (37.7727460760509, -122.426010766966) | 7 | 9 | 11 | 28852 | 10 | |||
55998 | 99606 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
56006 | 7920 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1295X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | 13 | 9 | 1 | 28858 | 41 |
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) );