trees
1,732 rows where qLegalStatus_id = 6 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
1467 | 259815 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
10119 | 261688 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
44457 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 9 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
54493 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
67746 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
87807 | 113732 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 9 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
134246 | 258292 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
161834 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | |||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
194175 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 699X DETROIT ST | 9 | Back Yard : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
3287 | 259814 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
10395 | 260478 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
14462 | 261432 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
30455 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
38864 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
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 | ||||
57354 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
75471 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
98870 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 8 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
119547 | 107080 | Significant Tree 6 | Magnolia x soulangiana :: Saucer Magnolia 147 | 401X TOWNSEND ST | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 14 | 2x30 | 6013045 | 2110022 | 37.774452457479 | -122.398320364295 | (37.774452457479, -122.398320364295) | 14 | 2 | 9 | 28856 | 20 | |||
141742 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
159425 | 258291 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 8 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
177074 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |||||
189693 | 252829 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 8 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
192790 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 8 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
6413 | 259813 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
9303 | 259269 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
11407 | 260477 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
13844 | 260966 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
16043 | 260472 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 7 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
19958 | 104685 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 7 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
37050 | 252828 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 7 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
60074 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 7 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
78403 | 258093 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1825 Mission St | 7 | Front Yard : Yard | Tree | Private 2 | 04/04/2019 12:00:00 AM | 3 | 3X3 | 6006778.7933 | 2107821.9347 | 37.7680605555842 | -122.419840266187 | (37.7680605555842, -122.419840266187) | 8 | 4 | 7 | 28853 | 19 | ||
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 | |||||
80420 | 105436 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 15 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
82626 | 258290 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 7 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
88321 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
95053 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
95583 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 531 | 273 Magellan Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
100865 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
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 | ||||
141272 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
154153 | 105087 | Significant Tree 6 | :: 45 | 344 Fulton St | 7 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 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 | ||||
167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
170444 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
177119 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard | Tree | Private 2 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | 9 | 7 | 6 | 28861 | 25 | |||
181535 | 173677 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
182062 | 100700 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 7 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
121105 | 88572 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 66 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
77876 | 88571 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 62 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
130549 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
51498 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
6612 | 259812 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
8040 | 260572 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
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 | ||||||||||||
12545 | 260484 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
16010 | 260965 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
20293 | 254534 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 737 Buena Vista Ave West | 6 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
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 | ||||
30833 | 258289 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
33161 | 254729 | Significant Tree 6 | Cryptomeria japonica :: Japanese Cryptomeria 420 | 1940 Mission St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | 8 | 4 | 7 | 28853 | 19 | ||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
62092 | 106569 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 6 | Front Yard : Yard | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.7434933850228 | -122.383634554004 | (37.7434933850228, -122.383634554004) | 10 | 3 | 8 | 58 | 1 | |||
62378 | 173676 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
70762 | 100699 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 6 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
73917 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
78991 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 6 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | |||||
93603 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 6 | Front Yard : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
94836 | 254241 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 6 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 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) );