trees
27,746 rows where qCaretaker_id = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56242 | 12380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/17/2013 12:00:00 AM | 3 | 3x3 | 6004345.46385 | 2113763.00934 | 37.7842359045501 | -122.428680455521 | (37.7842359045501, -122.428680455521) | 13 | 9 | 11 | 29490 | 41 | |||
130779 | 14676 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
166760 | 2744 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3X3 | 5995591.7347 | 2110770.58853 | 37.7755202080066 | -122.458748349075 | (37.7755202080066, -122.458748349075) | 11 | 6 | 2 | 54 | 11 | ||
185346 | 3876 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001972.79866 | 2108696.56564 | 37.7701901557853 | -122.436526269672 | (37.7701901557853, -122.436526269672) | 15 | 5 | 5 | 29492 | 9 | |||
65097 | 110683 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
101109 | 110690 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
101272 | 110684 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
140351 | 110689 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
143278 | 110685 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
160617 | 110687 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
187514 | 110688 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
171910 | 91184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | 7 | 9 | 9 | 28852 | 36 | |
26353 | 12949 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Lindsay Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016403.18992 | 2095651.77267 | 37.7351813255446 | -122.385701866655 | (37.7351813255446, -122.385701866655) | 10 | 3 | 8 | 58 | 1 | |||
860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
46006 | 9300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 12 | 3X3 | 6011786.56982 | 2090691.56369 | 37.7213050795375 | -122.401314833019 | (37.7213050795375, -122.401314833019) | 10 | 7 | 8 | 309 | 28 | ||
92947 | 9299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011744.95061 | 2090679.05023 | 37.7212683980005 | -122.401457820749 | (37.7212683980005, -122.401457820749) | 10 | 7 | 8 | 309 | 28 | |||
2955 | 13425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.52143 | 37.7942082021958 | -122.394990759026 | (37.7942082021958, -122.394990759026) | 12 | 2 | 9 | 28855 | 6 | ||
13225 | 13427 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6014172.84776 | 2117212.91542 | 37.7942598232708 | -122.394922634488 | (37.7942598232708, -122.394922634488) | 12 | 2 | 9 | 28855 | 6 | |||
29193 | 13426 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2003 12:00:00 AM | 8 | 4x4 | 6014161.01916 | 2117188.17749 | 37.7941912409866 | -122.394961829643 | (37.7941912409866, -122.394961829643) | 12 | 2 | 9 | 28855 | 6 | ||
60823 | 13430 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6014204.72202 | 2117228.65304 | 37.7943048073789 | -122.394813447799 | (37.7943048073789, -122.394813447799) | 12 | 2 | 9 | 28855 | 6 | |||
68686 | 13428 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2003 12:00:00 AM | 6 | 4x4 | 6014180.24954 | 2117205.51401 | 37.7942399123011 | -122.394896504683 | (37.7942399123011, -122.394896504683) | 12 | 2 | 9 | 28855 | 6 | ||
91640 | 13420 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1991 12:00:00 AM | 30 | 4x4 | 6014066.39965 | 2117110.59561 | 37.7939729575322 | -122.395283788713 | (37.7939729575322, -122.395283788713) | 12 | 2 | 9 | 28855 | 6 | ||
101042 | 13424 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2003 12:00:00 AM | 20 | 4x4 | 6014140.16579 | 2117170.60528 | 37.7941418322359 | -122.395032753763 | (37.7941418322359, -122.395032753763) | 12 | 2 | 9 | 28855 | 6 | ||
110833 | 13423 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2002 12:00:00 AM | 20 | 4x4 | 6014116.98151 | 2117144.48589 | 37.7940688252683 | -122.395111144077 | (37.7940688252683, -122.395111144077) | 12 | 2 | 9 | 28855 | 6 | ||
118223 | 13429 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6014197.04513 | 2117235.79144 | 37.7943239809064 | -122.394840511095 | (37.7943239809064, -122.394840511095) | 12 | 2 | 9 | 28855 | 6 | |||
121357 | 13419 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/1991 12:00:00 AM | 20 | 4x4 | 6014048.53109 | 2117080.60856 | 37.7938896263516 | -122.395343514492 | (37.7938896263516, -122.395343514492) | 12 | 2 | 9 | 28855 | 6 | ||
139303 | 13422 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 4x4 | 6014092.01898 | 2117123.77404 | 37.7940105671925 | -122.39519606617 | (37.7940105671925, -122.39519606617) | 12 | 2 | 9 | 28855 | 6 | ||
157457 | 27316 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6014028.45913 | 2117061.6774 | 37.7938365294714 | -122.395411639052 | (37.7938365294714, -122.395411639052) | 12 | 2 | 9 | 28855 | 6 | |||
163365 | 13418 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6014042.20206 | 2117087.71971 | 37.7939087999011 | -122.395365912104 | (37.7939087999011, -122.395365912104) | 12 | 2 | 9 | 28855 | 6 | |||
184834 | 13421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 30 | 4x4 | 6014072.44813 | 2117102.953 | 37.7939523091002 | -122.395262324595 | (37.7939523091002, -122.395262324595) | 12 | 2 | 9 | 28855 | 6 | ||
20190 | 90411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | 8 | 2 | 9 | 28853 | 19 | ||
21325 | 90408 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
129046 | 90410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
131860 | 90409 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
103003 | 15076 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 11 | 5995952.59829 | 2089005.63171 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | 9 | 8 | 6 | 28861 | 24 | |||
165898 | 15067 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 9 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | 9 | 8 | 6 | 28861 | 24 | |||
9426 | 107555 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
14319 | 107554 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |||
32524 | 107556 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
36574 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
38316 | 107558 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
40220 | 107562 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
46702 | 107564 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
56372 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
60676 | 107559 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
96373 | 107561 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
98721 | 107560 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
119862 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
168696 | 107563 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
180086 | 107557 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
100787 | 253125 | DPW Maintained 1 | Acer japonicum :: Japanese Maple 124 | 1 Oak Park Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5996419 | 2103319 | 37.7551075738744 | -122.455348004876 | (37.7551075738744, -122.455348004876) | 1 | 5 | 4 | 63 | 12 | ||||
19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
36901 | 91180 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
65819 | 91179 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
141293 | 91178 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
192979 | 89262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Polk St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||||
96809 | 189798 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | 8 | 4 | 8 | 28853 | 19 | |||
189326 | 139587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | 15 | 5 | 1 | 29490 | 16 | |||
45014 | 22801 | DPW Maintained 1 | Tree(s) :: 17 | 1 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/1997 12:00:00 AM | 3 | 2x2 | 5998832.3639753 | 2099992.0164602 | 37.7461106679667 | -122.446762549602 | (37.7461106679667, -122.446762549602) | 2 | 7 | 5 | 63 | 22 | ||
138186 | 1 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 10 10th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.468982710496 | (37.7866097734767, -122.468982710496) | 11 | 6 | 1 | 54 | 11 | |||
121742 | 1389 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017228.6912616 | 2095462.3520099 | 37.7347068580177 | -122.382834602513 | (37.7347068580177, -122.382834602513) | 10 | 3 | 8 | 58 | 1 | ||
14982 | 26911 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Caine Ave | 7 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997609.86555 | 2089654.44991 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | 9 | 8 | 6 | 28861 | 24 | |||
21304 | 26912 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 8 | Median : Cutout | Tree | DPW 1 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | 9 | 8 | 6 | 28861 | 24 | |||
36869 | 26909 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 5 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997629.54091 | 2089680.97756 | 37.7177302258428 | -122.450178650143 | (37.7177302258428, -122.450178650143) | 9 | 8 | 6 | 28861 | 24 | |||
78290 | 26905 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997683.40035 | 2089758.81084 | 37.7179470200262 | -122.449998089654 | (37.7179470200262, -122.449998089654) | 9 | 8 | 6 | 28861 | 24 | |||
82134 | 26913 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 9 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 5997584.35365 | 2089616.43233 | 37.7175504135998 | -122.45033019131 | (37.7175504135998, -122.45033019131) | 9 | 8 | 6 | 28861 | 24 | |||
82713 | 26914 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.450354374056 | (37.7175236335794, -122.450354374056) | 9 | 8 | 6 | 28861 | 24 | |||
84206 | 26910 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 6 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997620.43146 | 2089669.09204 | 37.7176970696553 | -122.450209281034 | (37.7176970696553, -122.450209281034) | 9 | 8 | 6 | 28861 | 24 | |||
103542 | 26915 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 11 | Median : Cutout | Tree | DPW 1 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.14436 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | 9 | 8 | 6 | 28861 | 24 | ||
121848 | 26906 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 5997668.87346 | 2089736.17467 | 37.7178840350953 | -122.450046671911 | (37.7178840350953, -122.450046671911) | 9 | 8 | 6 | 28861 | 24 | |||
154978 | 26908 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 4 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997639.65043 | 2089696.09364 | 37.7177723096208 | -122.45014479517 | (37.7177723096208, -122.45014479517) | 9 | 8 | 6 | 28861 | 24 | |||
189000 | 26907 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Caine Ave | 3 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997653.71656 | 2089718.57825 | 37.7178348520782 | -122.450097794787 | (37.7178348520782, -122.450097794787) | 9 | 8 | 6 | 28861 | 24 | |||
64315 | 14623 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837712 | 37.7313920698281 | -122.380024515102 | (37.7313920698281, -122.380024515102) | 10 | 3 | 8 | 58 | 1 | ||
44764 | 255383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Niagara Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/2018 05:26:00 AM | 3 | 3x3 | 6000028 | 2088914 | 37.7157612418296 | -122.44183326031 | (37.7157612418296, -122.44183326031) | 9 | 7 | 6 | 28861 | 25 | ||
123010 | 255382 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Niagara Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/2018 05:26:00 AM | 3 | 3x3 | 6000028 | 2088914 | 37.7157612418296 | -122.44183326031 | (37.7157612418296, -122.44183326031) | 9 | 7 | 6 | 28861 | 25 | ||
127914 | 255380 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/2018 05:26:00 AM | 3 | 3x3 | 6000028 | 2088914 | 37.7157612418296 | -122.44183326031 | (37.7157612418296, -122.44183326031) | 9 | 7 | 6 | 28861 | 25 | ||
183367 | 255381 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Niagara Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/2018 05:26:00 AM | 3 | 3x3 | 6000028 | 2088914 | 37.7157612418296 | -122.44183326031 | (37.7157612418296, -122.44183326031) | 9 | 7 | 6 | 28861 | 25 | ||
34680 | 4896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.54536 | 37.7318123626362 | -122.379724285267 | (37.7318123626362, -122.379724285267) | 10 | 3 | 8 | 58 | 1 | ||
37266 | 4898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | 10 | 3 | 8 | 58 | 1 | |||
71509 | 4895 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1993 12:00:00 AM | 12 | 3X4 | 6018140.88218 | 2094365.07214 | 37.7317442992597 | -122.379604608867 | (37.7317442992597, -122.379604608867) | 10 | 3 | 8 | 58 | 1 | ||
180093 | 4897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018099.28954 | 2094405.02636 | 37.731851711586 | -122.37975117949 | (37.731851711586, -122.37975117949) | 10 | 3 | 8 | 58 | 1 | |||
8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
150275 | 28300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 5995887 | 2088090 | 37.713261901345 | -122.456086835381 | (37.713261901345, -122.456086835381) | 9 | 8 | 6 | 28861 | 24 | |||
49778 | 3797 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016837.41936 | 2095915.09048 | 37.7359283617946 | -122.384218895383 | (37.7359283617946, -122.384218895383) | 10 | 3 | 8 | 58 | 1 | |||
117699 | 3796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 6016917.42909 | 2095896.09045 | 37.7358806149833 | -122.383940944619 | (37.7358806149833, -122.383940944619) | 10 | 3 | 8 | 58 | 1 | |||
39460 | 187613 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 10 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
130728 | 187615 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
164933 | 187614 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 11 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
167452 | 187612 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
14287 | 4591 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x2 | 6011425.16703 | 2118064.77563 | 37.796445660597 | -122.404489964152 | (37.796445660597, -122.404489964152) | 3 | 1 | 10 | 308 | 4 | |||
117005 | 4592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.07939 | 2118088.92644 | 37.7965106267297 | -122.404575013953 | (37.7965106267297, -122.404575013953) | 3 | 1 | 10 | 308 | 4 | ||
10670 | 258171 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008455.21796 | 2093605.41918 | 37.7291194808141 | -122.413036341511 | (37.7291194808141, -122.413036341511) | 9 | 3 | 7 | 309 | 28 | |||
14858 | 171814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008473.26376 | 2093533.30473 | 37.7289224829841 | -122.412968858728 | (37.7289224829841, -122.412968858728) | 9 | 3 | 7 | 309 | 28 | ||
18349 | 171813 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6008462.06709 | 2093570.22923 | 37.7290232412306 | -122.413010176287 | (37.7290232412306, -122.413010176287) | 9 | 3 | 7 | 309 | 28 | ||
33986 | 24963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004800.73696 | 2107633.50365 | 37.7674315357679 | -122.42666873509 | (37.7674315357679, -122.42666873509) | 8 | 4 | 5 | 28862 | 3 | |||
83756 | 24968 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004810.58196 | 2107534.13104 | 37.7671592390347 | -122.426627605497 | (37.7671592390347, -122.426627605497) | 8 | 4 | 5 | 28862 | 3 | |||
90075 | 24962 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.7675239950663 | -122.42665331172 | (37.7675239950663, -122.42665331172) | 8 | 4 | 5 | 28862 | 3 | ||
107384 | 24965 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.426654596838 | (37.767327900586, -122.426654596838) | 8 | 4 | 5 | 28862 | 3 | |||
116655 | 24966 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.7672974198587 | -122.426623750096 | (37.7672974198587, -122.426623750096) | 8 | 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) );