trees
203 rows where qCaretaker_id = 14 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38877 | 101808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3149 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/03/2015 12:00:00 AM | 3 | 3x3 | 6008718.2 | 2100791.7 | 37.7488661984732 | -122.412634998086 | (37.7488661984732, -122.412634998086) | 2 | 4 | 7 | 28859 | 19 | ||
152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
108684 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
109449 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | |||||
83447 | 109986 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
89248 | 109987 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
72030 | 109988 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
152463 | 109989 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
47883 | 109990 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
63694 | 109991 | Undocumented 4 | Quercus spp :: Oak 254 | 501X Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
177165 | 109994 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
117136 | 109995 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
19884 | 109998 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
116486 | 109999 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
192954 | 110534 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 2 | 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 | |||
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 | |||
100634 | 110538 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 6 | 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 | |||
167224 | 110540 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 8 | 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 | |||
28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
67675 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
124026 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
157876 | 111096 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 15 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
45020 | 111128 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | ||
175403 | 111129 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 2 | 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 | |||
152081 | 111131 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 4 | 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 | |||
185385 | 111132 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 5 | 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 | |||
74558 | 111133 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 6 | 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 | |||
128478 | 111134 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 7 | 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 | |||
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 | ||
168033 | 111379 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
119304 | 111381 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
101614 | 113808 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
88456 | 113809 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
87682 | 113810 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |||
154938 | 113811 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
124997 | 113812 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 1 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
73737 | 113813 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
179503 | 113815 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4101x 25TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 8 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
177608 | 113816 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
87336 | 113817 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
90434 | 113818 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
120864 | 113819 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
23754 | 113821 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 4101x 25TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
177877 | 113822 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 4101x 25TH ST | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
175720 | 113865 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
78158 | 113866 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
111013 | 113867 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
75284 | 113868 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
158369 | 113869 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
65235 | 113871 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
147322 | 113872 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
117870 | 113873 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
41067 | 113874 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
21486 | 114737 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW for City Agency 14 | DPW | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||
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 | |
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 | ||
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 | |
171772 | 140269 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998144.7463 | 2109987.1343 | 37.7735154534297 | -122.449860434482 | (37.7735154534297, -122.449860434482) | 15 | 5 | 11 | 29492 | 16 | |
153711 | 140270 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998125.7967 | 2109984.6626 | 37.7735075825336 | -122.44992580546 | (37.7735075825336, -122.44992580546) | 15 | 5 | 11 | 29492 | 16 | ||
112619 | 140272 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998087.0735 | 2109979.7192 | 37.7734917934815 | -122.450059397698 | (37.7734917934815, -122.450059397698) | 15 | 5 | 11 | 29492 | 16 | ||
132168 | 140273 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998068.9478 | 2109976.9729 | 37.773483215641 | -122.450121898862 | (37.773483215641, -122.450121898862) | 15 | 5 | 11 | 29492 | 16 | ||
158827 | 140274 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998046.1533 | 2109973.9519 | 37.7734736163349 | -122.450200530187 | (37.7734736163349, -122.450200530187) | 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) );