trees
104 rows where Police Districts = 2 and qLegalStatus_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6111 | 260586 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
6121 | 260584 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||||
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 | ||||
7698 | 259819 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
8301 | 114726 | Significant Tree 6 | :: 45 | 520 Townsend St | 2 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
9200 | 259821 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
9433 | 261043 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||||
9510 | 260587 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 890x Harrison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
12030 | 259810 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13096 | 259808 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13203 | 259818 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
13753 | 259809 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
14597 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 4 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
14819 | 259822 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
14961 | 259823 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
16309 | 259807 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
16536 | 259816 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
16794 | 261146 | Significant Tree 6 | Ficus Spp. :: 101 | 375x Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 3x3 | 6014494 | 2112212 | 37.780546313007 | -122.393461254196 | (37.780546313007, -122.393461254196) | 6 | 2 | 9 | 28856 | 6 | ||
16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
17902 | 113640 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
18324 | 109414 | Significant Tree 6 | Persea americana :: Avocado 34 | 4 GUY PL | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6014378.1 | 2114502.6 | 37.7868293368446 | -122.394022608955 | (37.7868293368446, -122.394022608955) | 6 | 2 | 9 | 28855 | 6 | ||||
18661 | 259820 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
18707 | 259811 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
22296 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
24833 | 104679 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 1 | 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 | ||||
37577 | 100056 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
40244 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
43381 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 4 | 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 | ||||
45878 | 173675 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
46337 | 115125 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
47325 | 104683 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 5 | 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 | ||||
48723 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : | Tree | Private 2 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | 6 | 2 | 9 | 28855 | 6 | ||||
50152 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
51708 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 322 | 99X Cleveland St | 2 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
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 | ||||
64486 | 104680 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 2 | 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 | ||||
65204 | 100696 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 3 | 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 | |||
67051 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
67239 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
67391 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
67412 | 107136 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 700X Stevenson St | 1 | Front Yard : Yard | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.34042 | 2111440.428 | 37.7780897748997 | -122.414335356247 | (37.7780897748997, -122.414335356247) | 8 | 2 | 9 | 28853 | 34 | |||
68704 | 173596 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 300 Howard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 779179 | 6014439 | 2115766 | 37.7903017260092 | -122.393900378517 | (37.7903017260092, -122.393900378517) | 12 | 2 | 9 | 28855 | 6 | |||
68737 | 104228 | Significant Tree 6 | Tree(s) :: 17 | 183 FREMONT ST | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Permit Number 770922 | 6014038 | 2115456 | 37.7894282446126 | -122.395266095466 | (37.7894282446126, -122.395266095466) | 12 | 2 | 9 | 28855 | 6 | |||
69806 | 106872 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 3 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
73225 | 100695 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 2 | 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 | |||
76208 | 106874 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 5 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
77590 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 99X Cleveland St | 3 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
85061 | 255144 | Significant Tree 6 | Cupressus sempervirens :: Italian Cypress 204 | 101x Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013362 | 2113756 | 37.7847228211314 | -122.3974857221 | (37.7847228211314, -122.3974857221) | 6 | 2 | 9 | 28856 | 6 | ||||
87462 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826 | 2110084 | 37.7744428576765 | -122.409459923405 | (37.7744428576765, -122.409459923405) | 8 | 2 | 9 | 28853 | 34 | |||
92116 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
93652 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010511 | 2109243 | 37.7721720235673 | -122.407031076357 | (37.7721720235673, -122.407031076357) | 14 | 2 | 9 | 28853 | 34 | ||||
93660 | 96184 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 1 | Sidewalk: Property side : | Tree | Private 2 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |||
100518 | 100698 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 5 | 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 | |||
103863 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
104445 | 104681 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 3 | 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 | ||||
105286 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 135 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout | Tree | Private 2 | 15 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
109218 | 107137 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 700X Stevenson St | 2 | Front Yard : Yard | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.34042 | 2111440.428 | 37.7780897748997 | -122.414335356247 | (37.7780897748997, -122.414335356247) | 8 | 2 | 9 | 28853 | 34 | |||
110183 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 561X Folsom St | 1 | Front Yard : Yard | Tree | Private 2 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.90646 | 37.7859605214302 | -122.396175324952 | (37.7859605214302, -122.396175324952) | 6 | 2 | 9 | 28856 | 6 | |
110338 | 115124 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
110899 | 114725 | Significant Tree 6 | :: 45 | 520 Townsend St | 1 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
111755 | 109415 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 4 GUY PL | 2 | Front Yard : Yard | Tree | Private 2 | 6014378.1 | 2114502.6 | 37.7868293368446 | -122.394022608955 | (37.7868293368446, -122.394022608955) | 6 | 2 | 9 | 28855 | 6 | |||||
113295 | 113637 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
115063 | 107139 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 700X Stevenson St | 4 | Front Yard : Yard | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.34042 | 2111440.428 | 37.7780897748997 | -122.414335356247 | (37.7780897748997, -122.414335356247) | 8 | 2 | 9 | 28853 | 34 | |||
115499 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
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 | |||
126787 | 96185 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 2 | Sidewalk: Property side : | Tree | Private 2 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | 6 | 2 | 9 | 28855 | 6 | ||||
133327 | 255538 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
135261 | 106871 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 2 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | |||
137482 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 1 | 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 | |||
143592 | 105678 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 101X 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6012079.1 | 2114345.8 | 37.7862707590298 | -122.401965633825 | (37.7862707590298, -122.401965633825) | 12 | 2 | 9 | 28853 | 6 | |||
144153 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | ||
145519 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
148345 | 104684 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 6 | 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 | ||||
153818 | 100055 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
158154 | 258096 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
167489 | 104452 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1045 Mission St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x6 | Permit Number 770594 | 6009749.9 | 2112056.4 | 37.7798543407434 | -122.409862429103 | (37.7798543407434, -122.409862429103) | 14 | 2 | 9 | 28853 | 34 | |||
170900 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 4 | 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 | |||
174218 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
175722 | 107138 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 700X Stevenson St | 3 | Front Yard : Yard | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.34042 | 2111440.428 | 37.7780897748997 | -122.414335356247 | (37.7780897748997, -122.414335356247) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||||
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 | ||||
181750 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
182623 | 106870 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 2 | Permit Number 769156 | 6008504.13663 | 2111439.18954 | 37.7780897331906 | -122.414128411309 | (37.7780897331906, -122.414128411309) | 8 | 2 | 9 | 28853 | 34 | ||
182808 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
184663 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
185174 | 255539 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
188934 | 100054 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 |
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) );