trees
953 rows where qSpecies_id = 60 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11333 | 222507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.408160091111 | (37.7518194273238, -122.408160091111) | 2 | 4 | 7 | 28859 | 19 | |||
18692 | 175790 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 79 Colby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | 9 | 3 | 7 | 309 | 28 | |||
152007 | 188318 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2000 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6012048.56124 | 2104706.10168 | 37.759800640718 | -122.401393594734 | (37.759800640718, -122.401393594734) | 10 | 3 | 8 | 28856 | 29 | |||
24479 | 188293 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 1 | : | Tree | Private 2 | 19 | Width 5ft | 6008175.89918 | 2108871.24729 | 37.7710203298423 | -122.415082093787 | (37.7710203298423, -122.415082093787) | 8 | 2 | 9 | 28853 | 19 | |||
32161 | 123707 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 698 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5993511.46751 | 2111432.07 | 37.7772166713285 | -122.465992510852 | (37.7772166713285, -122.465992510852) | 11 | 6 | 2 | 54 | 11 | |||
42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
46413 | 218271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.7382161345768 | -122.467513887457 | (37.7382161345768, -122.467513887457) | 1 | 8 | 4 | 59 | 40 | |||
84711 | 188335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | 10 | 3 | 8 | 28856 | 29 | |||
101610 | 188297 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 5 | : | Tree | Private 2 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.7710877753987 | -122.415284140848 | (37.7710877753987, -122.415284140848) | 8 | 2 | 9 | 28853 | 19 | |||
114027 | 188337 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6014186.28626 | 2095457.72756 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | 10 | 3 | 8 | 58 | 1 | |||
123298 | 218270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1456 Portola Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 5992782.12061 | 2097251.65776 | 37.7382388559447 | -122.46748409202 | (37.7382388559447, -122.46748409202) | 1 | 8 | 4 | 59 | 40 | |||
126466 | 188296 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 4 | : | Tree | Private 2 | 13 | Width 5ft | 6008131.89677 | 2108889.41859 | 37.7710677511061 | -122.415235586466 | (37.7710677511061, -122.415235586466) | 8 | 2 | 9 | 28853 | 19 | |||
138799 | 188294 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.7710377146367 | -122.415127922313 | (37.7710377146367, -122.415127922313) | 8 | 2 | 9 | 28853 | 19 | |||
155717 | 125880 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Emerson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | 15 | 6 | 1 | 54 | 31 | |||
163055 | 188336 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 3 | : | Tree | Private 2 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.397047567891 | (37.7613339848017, -122.397047567891) | 10 | 3 | 8 | 28856 | 29 | |||
176870 | 221340 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1370 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6003881.33957 | 2100275.34472 | 37.7471757545597 | -122.429324042781 | (37.7471757545597, -122.429324042781) | 2 | 7 | 5 | 63 | 22 | |||
179500 | 222596 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 73 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6002296.29369 | 2096683.33913 | 37.73722308157 | -122.43454820456 | (37.73722308157, -122.43454820456) | 2 | 7 | 5 | 63 | 7 | |||
190121 | 188295 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 3 | : | Tree | Private 2 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.7710477268126 | -122.415178587438 | (37.7710477268126, -122.415178587438) | 8 | 2 | 9 | 28853 | 19 | |||
191335 | 125879 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Emerson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5998729.92991 | 2113444.41319 | 37.7830417124478 | -122.448085187582 | (37.7830417124478, -122.448085187582) | 15 | 6 | 1 | 54 | 31 | |||
5527 | 204642 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995680.91746 | 2091957.81811 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | 9 | 8 | 4 | 28861 | 24 | |||
13532 | 170412 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 418 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6002130.67335 | 2093947.3581 | 37.7297013021565 | -122.434925220129 | (37.7297013021565, -122.434925220129) | 9 | 7 | 6 | 28861 | 25 | ||
14860 | 144376 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 390 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5986872.03276 | 2113312.07102 | 37.7819933565565 | -122.489098375585 | (37.7819933565565, -122.489098375585) | 11 | 6 | 2 | 55 | 26 | |||
30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
34267 | 188311 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | 14 | 3 | 8 | 28856 | 29 | |||
34470 | 188309 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012912.61356 | 2106204.46931 | 37.763962999013 | -122.398510384468 | (37.763962999013, -122.398510384468) | 14 | 3 | 8 | 28856 | 29 | |||
37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
44831 | 125887 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006289.37196 | 2113344.72886 | 37.7831972322057 | -122.421925487583 | (37.7831972322057, -122.421925487583) | 7 | 9 | 11 | 28858 | 41 | |||
48460 | 175792 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.7285379877196 | -122.409369173844 | (37.7285379877196, -122.409369173844) | 10 | 3 | 7 | 309 | 28 | |||
49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
51674 | 221343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | 15 | 5 | 11 | 29492 | 9 | |||
52915 | 188310 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.65853 | 2106249.78561 | 37.7640873186114 | -122.398520326465 | (37.7640873186114, -122.398520326465) | 14 | 3 | 8 | 28856 | 29 | |||
58365 | 188334 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013355.93912 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | 10 | 3 | 8 | 28856 | 29 | |||
60860 | 221365 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.436110461831 | (37.748183708409, -122.436110461831) | 2 | 4 | 5 | 28862 | 22 | |||
62112 | 188324 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 8 | : | Tree | Private 2 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | 10 | 3 | 8 | 28856 | 29 | |||
84156 | 125883 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008823.04151 | 2115295.32129 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | 5 | 1 | 10 | 28858 | 21 | |||
100034 | 204626 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5992297.08253 | 2095382.05199 | 37.7330773733083 | -122.469025074045 | (37.7330773733083, -122.469025074045) | 9 | 8 | 4 | 59 | 40 | |||
100735 | 143858 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3239 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985412.69263 | 2113173.41466 | 37.781527360227 | -122.494136727521 | (37.781527360227, -122.494136727521) | 11 | 6 | 2 | 55 | 26 | ||
103366 | 188308 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012915.64836 | 2106174.80894 | 37.7638817272787 | -122.398497806527 | (37.7638817272787, -122.398497806527) | 14 | 3 | 8 | 28856 | 29 | |||
105411 | 204627 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.468920554843 | (37.7330750773552, -122.468920554843) | 9 | 8 | 4 | 59 | 40 | |||
105952 | 143860 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3215 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985515.03599 | 2113176.32631 | 37.781541342893 | -122.493782888366 | (37.781541342893, -122.493782888366) | 11 | 6 | 2 | 55 | 26 | ||
114774 | 175791 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009517.43373 | 2093353.53583 | 37.7284874341444 | -122.409346391343 | (37.7284874341444, -122.409346391343) | 10 | 3 | 7 | 309 | 28 | |||
116464 | 125885 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | 7 | 10 | 9 | 28858 | 36 | |||
118525 | 125882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005138.85638 | 2116964.61432 | 37.7930715805281 | -122.426163602963 | (37.7930715805281, -122.426163602963) | 13 | 9 | 1 | 28858 | 27 | |||
123531 | 204625 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992281.41366 | 2095382.38172 | 37.7330773733209 | -122.469079268988 | (37.7330773733209, -122.469079268988) | 9 | 8 | 4 | 59 | 40 | |||
125221 | 188314 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 209 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6012920.39435 | 2106015.17263 | 37.7634436657274 | -122.39847018925 | (37.7634436657274, -122.39847018925) | 14 | 3 | 8 | 28856 | 29 | |||
125660 | 188325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 9 | : | Tree | Private 2 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.398989421832 | (37.7567499739592, -122.398989421832) | 10 | 3 | 8 | 28856 | 29 | |||
131270 | 204613 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1440 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5991174.12963 | 2105607.55819 | 37.7610890166517 | -122.473653042854 | (37.7610890166517, -122.473653042854) | 1 | 8 | 4 | 56 | 12 | |||
136865 | 188317 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6011501.39155 | 2104667.35812 | 37.7596637153197 | -122.403283270917 | (37.7596637153197, -122.403283270917) | 10 | 3 | 8 | 28856 | 29 | |||
165247 | 125886 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006255.84548 | 2113363.12878 | 37.7832458630397 | -122.422042783457 | (37.7832458630397, -122.422042783457) | 7 | 9 | 11 | 28858 | 41 | |||
167838 | 175794 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009502.30517 | 2093401.60497 | 37.7286185741876 | -122.409402082759 | (37.7286185741876, -122.409402082759) | 10 | 3 | 7 | 309 | 28 | |||
168476 | 143859 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3227 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985458.68749 | 2113171.92516 | 37.7815259617825 | -122.493977499883 | (37.7815259617825, -122.493977499883) | 11 | 6 | 2 | 55 | 26 | ||
169522 | 222502 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.7640790394267 | -122.422923695486 | (37.7640790394267, -122.422923695486) | 8 | 4 | 5 | 28859 | 19 | |||
170046 | 204628 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.468860552987 | (37.733067423224, -122.468860552987) | 9 | 8 | 4 | 59 | 40 | |||
176416 | 221350 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.7532902001979 | -122.413127394812 | (37.7532902001979, -122.413127394812) | 2 | 4 | 7 | 28859 | 19 | |||
176596 | 188338 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343 | (37.7344825828894, -122.39339227343) | 10 | 3 | 8 | 58 | 1 | |||
185299 | 175793 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | 10 | 3 | 7 | 309 | 28 | |||
188055 | 188331 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 612 Texas St | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.395282104281 | (37.7585970807056, -122.395282104281) | 10 | 3 | 8 | 28856 | 29 | |||
2325 | 204652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 01:08:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.7193758368067 | -122.451924066956 | (37.7193758368067, -122.451924066956) | 9 | 8 | 6 | 28861 | 24 | ||
6272 | 222570 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.436434178217 | (37.7496020939667, -122.436434178217) | 2 | 4 | 5 | 28862 | 22 | |||
10040 | 188312 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012939.88574 | 2105717.83125 | 37.7626283178769 | -122.398381909999 | (37.7626283178769, -122.398381909999) | 14 | 3 | 8 | 28856 | 29 | |||
10903 | 204646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 111 Ashton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994133.91606 | 2090657.47285 | 37.7202107871682 | -122.462332152117 | (37.7202107871682, -122.462332152117) | 9 | 8 | 6 | 28861 | 24 | |||
12817 | 221354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.414009391436 | (37.7572740646699, -122.414009391436) | 2 | 4 | 7 | 28859 | 19 | |||
12850 | 222577 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002861.59805 | 2105354.01605 | 37.7610627942241 | -122.433213052158 | (37.7610627942241, -122.433213052158) | 15 | 4 | 5 | 28862 | 3 | |||
15684 | 204670 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999483.78605 | 2094717.68964 | 37.7316658109241 | -122.4441310961 | (37.7316658109241, -122.4441310961) | 9 | 7 | 4 | 63 | 40 | |||
19519 | 222582 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001750.89139 | 2104845.17495 | 37.7596025695234 | -122.437018068443 | (37.7596025695234, -122.437018068443) | 2 | 4 | 5 | 28862 | 3 | |||
20379 | 221335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1641 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010542.34793 | 2100138.19824 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | 2 | 7 | 7 | 28859 | 2 | |||
22794 | 188356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017138.82287 | 2095616.15283 | 37.7351241988078 | -122.383156012747 | (37.7351241988078, -122.383156012747) | 10 | 3 | 8 | 58 | 1 | |||
22864 | 175789 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1038 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007776.24891 | 2093611.02457 | 37.7290967338157 | -122.415383996168 | (37.7290967338157, -122.415383996168) | 9 | 3 | 7 | 309 | 5 | |||
23954 | 221341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.425437478672 | (37.7469275767478, -122.425437478672) | 2 | 7 | 5 | 63 | 22 | |||
24389 | 221356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008902.61993 | 2103693.22479 | 37.7568434827621 | -122.412202312603 | (37.7568434827621, -122.412202312603) | 2 | 4 | 7 | 28859 | 19 | |||
24772 | 221325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006242.86506 | 2104074.32841 | 37.7577403028851 | -122.42142781086 | (37.7577403028851, -122.42142781086) | 2 | 4 | 5 | 28859 | 19 | |||
25487 | 222564 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007476.41433 | 2100201.58357 | 37.7471760989928 | -122.416887300207 | (37.7471760989928, -122.416887300207) | 2 | 7 | 7 | 28859 | 2 | |||
27809 | 188319 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101 | (37.7571363191045, -122.39902607101) | 10 | 3 | 8 | 28856 | 29 | |||
28920 | 204622 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.464883245465 | (37.7599558699739, -122.464883245465) | 1 | 8 | 4 | 56 | 12 | |||
29975 | 175763 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.7248656727096 | -122.40377805363 | (37.7248656727096, -122.40377805363) | 10 | 3 | 7 | 309 | 28 | |||
31225 | 204651 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 27 Majestic Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.450979745524 | (37.7179774953307, -122.450979745524) | 9 | 8 | 6 | 28861 | 24 | |||
31303 | 188306 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572754 | (37.7637653298293, -122.38970572754) | 14 | 3 | 8 | 28856 | 29 | |||
31918 | 222594 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | 2 | 7 | 5 | 63 | 7 | |||
32080 | 175788 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008132.91971 | 2093497.94914 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | 9 | 3 | 7 | 309 | 28 | |||
32334 | 221326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | 2 | 4 | 5 | 28859 | 19 | |||
34465 | 222549 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.7406038022373 | -122.417680295405 | (37.7406038022373, -122.417680295405) | 2 | 7 | 7 | 28859 | 2 | |||
34856 | 188343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6012604.8118 | 2096159.09388 | 37.7363634115335 | -122.398869919026 | (37.7363634115335, -122.398869919026) | 10 | 3 | 8 | 58 | 1 | |||
35216 | 204656 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Sargent St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993464.3561 | 2089166.28112 | 37.7160777557502 | -122.464538359982 | (37.7160777557502, -122.464538359982) | 9 | 8 | 6 | 64 | 24 | |||
35674 | 222588 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | 15 | 5 | 5 | 28862 | 3 | |||
37364 | 175787 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.23514 | 2093495.17198 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | 9 | 3 | 7 | 309 | 28 | |||
37578 | 221355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008404.74116 | 2103860.62661 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | 2 | 4 | 7 | 28859 | 19 | |||
39230 | 222571 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.438130138611 | (37.7501768003212, -122.438130138611) | 2 | 4 | 5 | 28862 | 22 | |||
39796 | 222546 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | 2 | 7 | 5 | 63 | 7 | |||
40262 | 221321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | 2 | 4 | 5 | 28859 | 19 | |||
41211 | 188316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.400058184238 | (37.7578394396596, -122.400058184238) | 10 | 3 | 8 | 28856 | 29 | |||
42439 | 221348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.417896696594 | (37.7380362287807, -122.417896696594) | 2 | 7 | 7 | 28859 | 2 | |||
43425 | 222591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.7702761156764 | -122.430341981792 | (37.7702761156764, -122.430341981792) | 15 | 9 | 11 | 29492 | 10 | |||
43444 | 188313 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012940.76459 | 2105761.15041 | 37.7627473116745 | -122.398381910012 | (37.7627473116745, -122.398381910012) | 14 | 3 | 8 | 28856 | 29 | |||
45916 | 175782 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.7290892244848 | -122.419690364741 | (37.7290892244848, -122.419690364741) | 9 | 7 | 7 | 309 | 5 | |||
47063 | 124082 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993384.86337 | 2110069.41246 | 37.7734678747583 | -122.466331413768 | (37.7734678747583, -122.466331413768) | 11 | 6 | 2 | 54 | 11 | |||
47848 | 175757 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003296.85898 | 2090487.74665 | 37.7202681261541 | -122.430646818702 | (37.7202681261541, -122.430646818702) | 9 | 7 | 6 | 28861 | 5 | |||
50057 | 188346 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1716 Revere Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.392227779994 | (37.7329022519179, -122.392227779994) | 10 | 3 | 8 | 58 | 1 | |||
50910 | 222561 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | 2 | 7 | 7 | 28859 | 2 | |||
52734 | 222578 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.7595393031055 | -122.433700841745 | (37.7595393031055, -122.433700841745) | 2 | 4 | 5 | 28862 | 3 |
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) );