trees
208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172328 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.7959478507639 | -122.422745597666 | (37.7959478507639, -122.422745597666) | 13 | 9 | 10 | 28858 | 32 | |||
176793 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 9 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
176820 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | 13 | 9 | 1 | 57 | 17 | ||
180419 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 2040 Jackson St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | 13 | 9 | 1 | 28858 | 27 | ||
181978 | 107824 | Significant Tree 6 | Tree(s) :: 17 | 10 STARR KING WAY | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 774657 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||
184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
185953 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2829 Divisadero St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.442112369006 | (37.7957189625051, -122.442112369006) | 13 | 9 | 1 | 57 | 17 | ||
186789 | 105088 | Significant Tree 6 | :: 45 | 344 Fulton St | 8 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
74407 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
79081 | 121163 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 7 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
83376 | 121162 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 6 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
99672 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
106415 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
123818 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
194054 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
12590 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 778992 | 6001431 | 2120732 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | 13 | 9 | 1 | 57 | 17 | ||
15591 | 262378 | Significant Tree 6 | Yucca spp :: Yucca 289 | 2172 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002662 | 2118213 | 37.796359019498 | -122.434822974351 | (37.796359019498, -122.434822974351) | 13 | 9 | 1 | 57 | 17 | ||||
16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
20021 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
39009 | 255287 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2758 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999862 | 2117824 | 37.7951315610034 | -122.444483561153 | (37.7951315610034, -122.444483561153) | 13 | 9 | 1 | 57 | 17 | ||||
40123 | 256065 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2800 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2018 12:00:00 AM | 3 | 3x3 | 6002545 | 2117972 | 37.7956906526811 | -122.435210571933 | (37.7956906526811, -122.435210571933) | 13 | 9 | 1 | 57 | 17 | ||
44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
73188 | 255598 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
79307 | 255595 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
91730 | 255599 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||
96773 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 53020 | 6006011 | 2111744 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | 7 | 9 | 11 | 28852 | 10 | |||
118931 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
125819 | 88147 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
133531 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006264 | 2119500 | 37.8000966404513 | -122.42245076966 | (37.8000966404513, -122.42245076966) | 13 | 9 | 1 | 28858 | 32 | ||||
138097 | 88148 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1499 Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 6 | 3x3 | Permit Number 51176 | 6003399.3649 | 2112760.0054 | 37.7814283176978 | -122.431881978872 | (37.7814283176978, -122.431881978872) | 15 | 9 | 11 | 29490 | 41 | |
142991 | 255600 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
153500 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 106 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | 13 | 9 | 1 | 57 | 17 | ||
168619 | 255596 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
170538 | 88146 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
92381 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 15x4 | 6004495 | 2117637 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | 13 | 9 | 1 | 28858 | 27 | |||
106956 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026 | 2116224 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | 13 | 9 | 1 | 29490 | 27 | |
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
162406 | 255994 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 179 Retiro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6001908 | 2121813 | 37.8062008335618 | -122.437689923584 | (37.8062008335618, -122.437689923584) | 13 | 9 | 1 | 57 | 17 | ||||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
17502 | 260902 | Significant Tree 6 | Populus alba :: White Poplar 184 | 1901 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
41224 | 258232 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||
43239 | 258527 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
53621 | 258239 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
56668 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | 13 | 9 | 1 | 57 | 27 | |||||
60038 | 258526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 50 Hermann St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
67916 | 258235 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
71526 | 258236 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
72516 | 258223 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 53 Starr King Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | Permit Number 782966 | 6005764 | 2113984 | 37.784922869937 | -122.423788535241 | (37.784922869937, -122.423788535241) | 13 | 9 | 11 | 28858 | 41 | |||
78486 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
92540 | 113772 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 6001375.31674 | 2117310.7972 | 37.7938086711861 | -122.439210462719 | (37.7938086711861, -122.439210462719) | 13 | 9 | 1 | 57 | 27 | ||||
95081 | 112874 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2636 Vallejo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 13 | 3x3 | Permit Number 776037 | 6000935.48392 | 2117605.97258 | 37.7945941075731 | -122.440753504176 | (37.7945941075731, -122.440753504176) | 13 | 9 | 1 | 57 | 27 | |
98424 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
103945 | 258237 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
109250 | 107818 | Significant Tree 6 | Ficus Spp. :: 101 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 6004715.2 | 2110227.8 | 37.7745500089947 | -122.427149405032 | (37.7745500089947, -122.427149405032) | 7 | 9 | 11 | 28852 | 10 | ||||
110239 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
115750 | 255277 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
118707 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
120900 | 258240 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
125310 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
128387 | 113771 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 6001386.1067 | 2117311.2447 | 37.7938105138862 | -122.439173160634 | (37.7938105138862, -122.439173160634) | 13 | 9 | 1 | 57 | 27 | ||||
138832 | 258234 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
153073 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
155172 | 258233 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
160060 | 258238 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
167525 | 258528 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
172310 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.439113709125 | (37.7938132775122, -122.439113709125) | 13 | 9 | 1 | 57 | 27 | ||||
174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
192756 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||
193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
4164 | 260061 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
8078 | 260059 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
9215 | 260060 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
18171 | 260058 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
27012 | 255276 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
36041 | 255248 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
75842 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
85142 | 255249 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 209x Willow St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
88383 | 103615 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
95437 | 103618 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
108843 | 253969 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
110134 | 103612 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
117546 | 255247 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
126646 | 255275 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
139171 | 255246 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
139296 | 253970 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
144064 | 103614 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
156627 | 125128 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2545 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5999632.15337 | 2117620.57677 | 37.7945598973812 | -122.44526423016 | (37.7945598973812, -122.44526423016) | 13 | 9 | 1 | 57 | 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) );