trees
8,298 rows where qLegalStatus_id = 4 sorted by qCaretaker_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135817 | 105173 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | Arts Commission | 13 | 4x4 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | |
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
103033 | 105163 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1600X OAKDALE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 17 | 4x4 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | ||
42129 | 111073 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1450 IRVING ST | 2 | Sidewalk: Property side : Cutout | Tree | Fire Dept 16 | 3x3 | 5991201 | 2106639 | 37.7639226370674 | -122.473635352969 | (37.7639226370674, -122.473635352969) | 11 | 8 | 11 | 56 | 12 | ||||
193863 | 111072 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout | Tree | Fire Dept 16 | 3x3 | 5991277 | 2106586 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | 11 | 8 | 11 | 56 | 12 | ||||
24943 | 98739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
29904 | 98737 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 24 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
58440 | 112748 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 135X TRENTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
59327 | 112509 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW | 2x2 | 6004423 | 2113018 | 37.7821946822097 | -122.42835909049 | (37.7821946822097, -122.42835909049) | 7 | 9 | 11 | 29490 | 41 | |||
85896 | 128382 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 127 Trenton St | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | 05/21/2018 12:00:00 AM | 3 | Width 3ft | 6010062.26131 | 2118004.30718 | 37.7962033688491 | -122.409201662523 | (37.7962033688491, -122.409201662523) | 3 | 1 | 10 | 308 | 4 | ||
85966 | 112510 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW | 2x2 | 6004423 | 2113018 | 37.7821946822097 | -122.42835909049 | (37.7821946822097, -122.42835909049) | 7 | 9 | 11 | 29490 | 41 | |||
99464 | 112750 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
148106 | 98740 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
155752 | 115341 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard | Tree | Housing Authority 15 | Private | 3x3 | 6006572 | 2087815 | 37.7131143345755 | -122.419136228821 | (37.7131143345755, -122.419136228821) | 9 | 7 | 8 | 309 | 39 | |||
162723 | 114914 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6017974 | 2095171 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | 10 | 3 | 8 | 58 | 1 | |||
177021 | 112749 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 135X TRENTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
188776 | 98742 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | |
189757 | 98741 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | |
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 | ||||||||||||
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 | ||
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 | ||||||||||||
8033 | 242084 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 06:05:00 AM | 1 | Width 3ft | 6002781.49194 | 2101209.46423 | 37.7496782989261 | -122.433193959528 | (37.7496782989261, -122.433193959528) | 2 | 4 | 5 | 28862 | 22 | ||
12041 | 242082 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002677.73551 | 2101204.84944 | 37.7496597414097 | -122.433552423029 | (37.7496597414097, -122.433552423029) | 2 | 4 | 5 | 28862 | 22 | |||
14883 | 242086 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 05:57:00 AM | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||||||||||||
15773 | 242083 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002726.52973 | 2101207.22034 | 37.7496690197098 | -122.433383860397 | (37.7496690197098, -122.433383860397) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||||||||||||
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 | ||||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
33609 | 98909 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 1 | 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 | |||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | |||
83791 | 98908 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 2 | 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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
11498 | 115743 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
88348 | 105149 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1X COTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 7 | 3x3 | 6002672 | 2093020 | 37.7271857072251 | -122.432987568669 | (37.7271857072251, -122.432987568669) | 9 | 7 | 6 | 28861 | 25 | |||
91738 | 114025 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
96177 | 114027 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
97775 | 114024 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 |
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) );