trees
203 rows where qCaretaker_id = 14 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3669 | 103667 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
6238 | 103666 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
9915 | 173655 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100 Lawton St | 1 | Median : Cutout | Tree | DPW for City Agency 14 | |||||||||||||||
14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
15258 | 103665 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
16355 | 103663 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18064 | 103664 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18674 | 103662 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
72776 | 111589 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | Permit Number 774260 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
82558 | 98222 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
88826 | 111588 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
105081 | 97214 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
114447 | 97215 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 20 | 4x12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | |||
116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
147039 | 98216 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.501501543012 | (37.7576365448231, -122.501501543012) | 1 | 8 | 3 | 56 | 35 | ||
152631 | 98218 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
153397 | 98220 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
155237 | 97217 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 4 | Back Yard : Cutout | Tree | DPW for City Agency 14 | 18 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
176309 | 97216 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 3 | Back Yard : Cutout | Tree | DPW for City Agency 14 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | |||||
187982 | 173659 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 200 Lawton St | 1 | Median : Cutout | Tree | DPW for City Agency 14 | 5993693.06683 | 2104628.21116 | 37.7585455452803 | -122.46487007072 | (37.7585455452803, -122.46487007072) | 1 | 8 | 4 | 56 | 12 | |||||
192386 | 98223 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
128716 | 108973 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3485X SAN BRUNO AVE | 1 | Median : Yard | Tree | DPW for City Agency 14 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
50286 | 113709 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
52668 | 113708 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
56181 | 110400 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.7799614584413 | -122.477285287094 | (37.7799614584413, -122.477285287094) | 11 | 6 | 2 | 55 | 26 | ||
56631 | 110401 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.7798774049655 | -122.4772748837 | (37.7798774049655, -122.4772748837) | 11 | 6 | 2 | 55 | 26 | ||
95680 | 110403 | Undocumented 4 | Ficus laurel :: 247 | 419X 18TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 22 | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | ||
114523 | 110402 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
130117 | 113705 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | ||
139329 | 110406 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
143725 | 113706 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
148472 | 113707 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
180245 | 110414 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
10068 | 49666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | 13 | 9 | 1 | 57 | 17 | ||
11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
15243 | 98997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | ||||
16686 | 99005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
24920 | 81846 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) | 13 | 9 | 10 | 28858 | 21 |
32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
41337 | 81843 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
42721 | 49663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 7 | Permit Number 46510 | 6000228.83335 | 2120782.17575 | 37.8032748487093 | -122.443426854966 | (37.8032748487093, -122.443426854966) | 13 | 9 | 1 | 57 | 17 | ||
43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
45985 | 99003 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
51749 | 49665 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000243.34961 | 2120687.49551 | 37.8030157099616 | -122.443369816371 | (37.8030157099616, -122.443369816371) | 13 | 9 | 1 | 57 | 17 | ||
56816 | 98996 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2190X North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000702 | 2120685 | 37.8030350020674 | -122.441782472194 | (37.8030350020674, -122.441782472194) | 13 | 9 | 1 | 57 | 17 | |||
68320 | 137118 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2150 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 0 | Width 4ft | Permit Number 771149 | 6000490.48443 | 2120659.70119 | 37.8029534840902 | -122.442512606897 | (37.8029534840902, -122.442512606897) | 13 | 9 | 1 | 57 | 17 | |
72388 | 82383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 | |
75069 | 47415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45326 | 6000240.55787 | 2120707.38669 | 37.8030701666099 | -122.443380906816 | (37.8030701666099, -122.443380906816) | 13 | 9 | 1 | 57 | 17 | ||
76830 | 99000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
76955 | 99004 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
78526 | 254583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1439 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 08/02/2016 06:38:00 AM | 3x3 | 6005488 | 2119883 | 37.8011044543754 | -122.425163298445 | (37.8011044543754, -122.425163298445) | 13 | 9 | 1 | 57 | 17 | ||
87127 | 99008 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
87604 | 81841 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
94774 | 99002 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
95484 | 98999 | DPW Maintained 1 | Tristania conferta :: 61 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |
98832 | 81842 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
100260 | 49664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.06693 | 37.8031515390838 | -122.443390413534 | (37.8031515390838, -122.443390413534) | 13 | 9 | 1 | 57 | 17 | ||
111923 | 81845 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.7897041006217 | -122.419274608151 | (37.7897041006217, -122.419274608151) | 13 | 9 | 10 | 28858 | 21 |
112996 | 49662 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000225.92137 | 2120807.31261 | 37.803343701723 | -122.44343873861 | (37.803343701723, -122.44343873861) | 13 | 9 | 1 | 57 | 17 | ||
117347 | 49668 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 04/18/2011 12:00:00 AM | Permit Number 46510 | 6000239.54014865 | 2120711.44405841 | 37.8030812490195 | -122.443384720262 | (37.8030812490195, -122.443384720262) | 13 | 9 | 1 | 57 | 17 | ||
120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
122270 | 95039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
129349 | 95041 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
135831 | 81840 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
137242 | 49667 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 8 | Permit Number 46510 | 6000232.67943 | 2120757.93136 | 37.8032084994456 | -122.443411803017 | (37.8032084994456, -122.443411803017) | 13 | 9 | 1 | 57 | 17 | ||
141424 | 95044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
141911 | 98998 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
142881 | 95042 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 11 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
147165 | 98995 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2190X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000922.9 | 2115860.7 | 37.7898013277865 | -122.44067180053 | (37.7898013277865, -122.44067180053) | 13 | 6 | 1 | 29490 | 27 | ||||
149567 | 13091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1439X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/02/2016 06:38:00 AM | 3 | 4x5 | 6005488.54173 | 2119878.23932 | 37.8010914133698 | -122.425161084884 | (37.8010914133698, -122.425161084884) | 13 | 9 | 1 | 57 | 17 | ||
152225 | 129875 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 771149 | 6000472.54237 | 2120960.44245 | 37.8037782163629 | -122.442596301384 | (37.8037782163629, -122.442596301384) | 13 | 9 | 1 | 57 | 17 | |
152727 | 99006 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
161524 | 99001 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
162433 | 99007 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
178823 | 81839 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
190761 | 49658 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 3630 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 1 | Permit Number 46510 | 6000258.18089 | 2120685.13581 | 37.8030100766084 | -122.443318322984 | (37.8030100766084, -122.443318322984) | 13 | 9 | 1 | 57 | 17 | ||
193628 | 129872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977331 | -122.443006850904 | (37.803723977331, -122.443006850904) | 13 | 9 | 1 | 57 | 17 | ||
12201 | 140276 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998008.2541 | 2109969.0086 | 37.7734578744037 | -122.450331271992 | (37.7734578744037, -122.450331271992) | 15 | 5 | 11 | 29492 | 16 | ||
21624 | 140275 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998028.0276 | 2109971.4803 | 37.773465792675 | -122.450263051124 | (37.773465792675, -122.450263051124) | 15 | 5 | 11 | 29492 | 16 | ||
26910 | 111776 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
30910 | 110537 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
31418 | 110533 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
36748 | 246841 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : | Tree | DPW for City Agency 14 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | 15 | 5 | 11 | 29492 | 10 | |||
39489 | 111135 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 2 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 |
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) );