trees

112 rows where qLegalStatus_id = 6 and qSiteInfo = "Front Yard : Cutout" sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Front Yard : Cutout · 112 ✖
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)
429 259715 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 210 Gold Mine Dr 1 Front Yard : Cutout Tree Private 2       3x3   6000723 2098465 37.7420256658379 -122.440115509428 (37.7420256658379, -122.440115509428) 2 7 5 63 7
873 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 2 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM   3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
3099 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 953 Indiana St 1 Front Yard : Cutout Tree Private 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
3182 261252 Significant Tree 6 Banksia integrifolia :: Coast Banksia 21 100 Collins St 1 Front Yard : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3                        
5414 261208 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1131 Sutter St 1 Front Yard : Cutout Tree Private 2       3x3   6007175 2115019 37.7878442781586 -122.418980353142 (37.7878442781586, -122.418980353142) 13 9 10 28858 21
7835 258799 Significant Tree 6 Taxus baccata :: Irish Yew 86 566 29th Ave 1 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
8456 99698 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 1 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
8573 264725 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 136 Addison St 1 Front Yard : Cutout Tree Private 2       3x3   6002996 2096937 37.7379592717499 -122.432147110586 (37.7379592717499, -122.432147110586) 2 7 5 63 7
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
10900 256098 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1776 Vallejo St 1 Front Yard : Cutout Tree Private 2           6005064.21519 2118169.93221 37.7963768588038 -122.426507729874 (37.7963768588038, -122.426507729874) 13 9 1 28858 17
11600 260651 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 2 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
12050 261306 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1555 Union St 1 Front Yard : Cutout Tree Private 2       3x3   6005549 2118864 37.7983099861265 -122.424879674285 (37.7983099861265, -122.424879674285) 13 9 1 57 17
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
13092 261764 Significant Tree 6 Melaleuca quinquenervia :: Cajeput 10 130 Bartlett St 2 Front Yard : Cutout Tree Private 2       4x4   6006663 2102839 37.7543720553146 -122.419887150249 (37.7543720553146, -122.419887150249) 2 4 7 28859 19
14356 264786 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 451 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995368 2094795 37.7316424274687 -122.458365690275 (37.7316424274687, -122.458365690275) 9 7 4 59 40
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
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
15969 261831 Significant Tree 6 Acer japonicum :: Japanese Maple 124 1507 Cole St 1 Front Yard : Cutout Tree Private 2       3x3   5998279 2105297 37.7606452154312 -122.449058098094 (37.7606452154312, -122.449058098094) 15 5 11 29492 12
16260 260650 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 1 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
17941 258800 Significant Tree 6 Juniperus chinensis :: Juniper 113 566 29th Ave 2 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
18899 261161 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 2452 Green St 1 Front Yard : Cutout Tree Private 2       3x3   6001304 2118013 37.7957326780501 -122.439507585878 (37.7957326780501, -122.439507585878) 13 9 1 57 17
19453 261628 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3930 21st St 1 Front Yard : Cutout Tree Private 2       3x3   6002255 2103579 37.7561545985327 -122.435184046951 (37.7561545985327, -122.435184046951) 2 4 5 28862 3
20150 256573 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 145 Castenada Ave 1 Front Yard : Cutout Tree Private 2       3x3   5994569 2100949 37.74849383418 -122.461573977381 (37.74849383418, -122.461573977381) 1 8 4 29491 40
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
22312 116999 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
24634 111770 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 707 Douglass St   Front Yard : Cutout Tree Private 2       3x3 Permit Number 775627 6001281 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375) 2 4 5 28862 22
27985 253620 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 1120 South Van Ness Ave 3 Front Yard : Cutout Tree Private 2       Width 3ft   6007603.98274 2103104.14442 37.7551530486792 -122.416651764192 (37.7551530486792, -122.416651764192) 2 4 7 28859 19
29057 116956 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 380 SAN JOSE AVE 1 Front Yard : Cutout Tree Private 2     28 3x3   6006172 2100967 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126) 2 4 5 28859 19
29379 254551 Significant Tree 6 Cordyline australis :: Dracena Palm 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree Private 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
29803 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree Arts Commission 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
32335 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
32630 85060 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070 California St 1 Front Yard : Cutout Tree Private 2   07/03/2007 12:00:00 AM     Permit Number 49405 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
34696 253950 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 431 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
43517 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout Tree Private 2   08/01/2008 12:00:00 AM     Permit Number 51562 5991996 2092560 37.7253113201117 -122.469860593138 (37.7253113201117, -122.469860593138) 9 8 4 59 40
44979 39247 Significant Tree 6 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 3524 Jackson St 1 Front Yard : Cutout Tree Private 2   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
45867 107185 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 10 Florence St 1 Front Yard : Cutout Tree Private 2         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272) 5 1 10 308 21
48200 108097 Significant Tree 6 Tree(s) :: 17 3370 Washington St 2 Front Yard : Cutout Tree Private 2           5998663.3699 2115944.31994 37.789901994506 -122.448495552231 (37.789901994506, -122.448495552231) 13 6 1 54 31
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
54248 115888 Significant Tree 6 Olea europaea :: Olive Tree 9 811 TREAT AVE 1 Front Yard : Cutout Tree Private 2     20 3x3   6008597 2103712 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978) 2 4 7 28859 19
56298 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 104x TAPIA DR 1 Front Yard : Cutout Tree Private 2     10     5988688 2090939 37.7206686952673 -122.481177253578 (37.7206686952673, -122.481177253578) 1 8 4 64 14
57122 104444 Significant Tree 6 Acer japonicum :: Japanese Maple 124 507 Capp St 1 Front Yard : Cutout Tree Private 2       2x6 Permit Number 770679 6007300 2104257.5 37.7583027968034 -122.417784776473 (37.7583027968034, -122.417784776473) 2 4 7 28859 19
58472 104728 Significant Tree 6 Tree(s) :: 17 3212 Jackson St 1 Front Yard : Cutout Tree Private 2   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492) 13 6 1 54 31
59089 116955 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Front Yard : Cutout Tree Private 2     6 3x3   6001245 2101454 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352) 2 4 5 28862 22
62475 107113 Significant Tree 6 Brahea edulis :: Guadalupe Palm 218 2100 MARKET ST   Front Yard : Cutout Tree Private 2           6004034 2107672.1 37.7674941340109 -122.429323526179 (37.7674941340109, -122.429323526179) 7 9 5 28862 3
64719 253770 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 234 Carl St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 770677 5997066 2107091 37.7655016335596 -122.453382820195 (37.7655016335596, -122.453382820195) 15 5 11 29492 12
65723 108022 Significant Tree 6 Grevillea robusta :: Silk Oak Tree 76 455X Ivy St 2 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
69512 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 500 Raymond Ave 1 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM 30 3x3   6008233.87951 2088473.93147 37.7150170728648 -122.413438766187 (37.7150170728648, -122.413438766187) 9 7 8 309 18
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
69856 112572 Significant Tree 6 Cordyline australis :: Dracena Palm 64 162 GRAND VIEW AVE 4 Front Yard : Cutout Tree Private 2       3x3   6000754 2103380 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392) 2 4 5 63 38
72773 112366 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2224 Baker St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 775823 5999858.5 2116547.8 37.791627252722 -122.444403911295 (37.791627252722, -122.444403911295) 13 6 1 29490 27
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
75962 111070 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1836 08TH AVE 2 Front Yard : Cutout Tree Private 2     2 3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
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
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
80380 114184 Significant Tree 6 Tree(s) :: 17 2454 HYDE ST 1 Front Yard : Cutout Tree Private 2   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060 2120781 37.8036588138585 -122.41978724304 (37.8036588138585, -122.41978724304) 5 1 1 28858 32
80605 99830 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398@Steiner Broadway 1 Front Yard : Cutout Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
85934 88453 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 2 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
89841 253178 Significant Tree 6 Washingtonia filifera :: California Fan Palm 176 4450 24th St 2 Front Yard : Cutout Tree Private 2       Width 0ft Permit Number 780574 6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398) 2 4 5 28862 22
90328 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 6001 Geary Blvd 1 Front Yard : Cutout Tree Private 2           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894) 11 6 2 55 26
90493 108096 Significant Tree 6 Ficus rubiginosa :: Port Jackson Fig 339 3370 Washington St 1 Front Yard : Cutout Tree Private 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.7898725948813 -122.448455078738 (37.7898725948813, -122.448455078738) 13 6 1 54 31
92659 85428 Significant Tree 6 Tree(s) :: 17 43 Ora Way 1 Front Yard : Cutout Tree Private 2   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.7416050219872 -122.437232403771 (37.7416050219872, -122.437232403771) 2 7 5 63 7
97746 111068 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 1 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
98944 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 301X Sargent St 1 Front Yard : Cutout Tree Private 2       3x3   5993018 2089140 37.7159798527116 -122.466079257059 (37.7159798527116, -122.466079257059) 9 8 6 64 24
99727 258388 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2770 Lombard St 2 Front Yard : Cutout Tree Private 2           5999223 2119112 37.7986315842223 -122.446787313103 (37.7986315842223, -122.446787313103) 13 9 1 57 17
99950 117000 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 3 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
100356 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 4 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
100759 99832 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398@Steiner Broadway 3 Front Yard : Cutout Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
104764 115564 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 3524 Jackson St 2 Front Yard : Cutout Tree Private 2       5x10   5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
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
105893 116998 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 1 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
110541 113044 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 3 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
111048 113744 Significant Tree 6 Cordyline australis :: Dracena Palm 64 909 ASHBURY ST 1 Front Yard : Cutout Tree Private 2       3x3   5999156 2107025 37.7654399906909 -122.44614926226 (37.7654399906909, -122.44614926226) 15 5 11 29492 9
113506 108002 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 461X Ivy St 1 Front Yard : Cutout Tree Private 2           6005199.36333 2111122.83043 37.7770349120596 -122.425538300101 (37.7770349120596, -122.425538300101) 7 9 11 28852 10
118020 88454 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 3 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
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
125570 253265 Significant Tree 6 Juniperus chinensis :: Juniper 113 180 San Aleso Ave 1 Front Yard : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   5993319 2094440 37.7305497238902 -122.465423653439 (37.7305497238902, -122.465423653439) 9 8 4 59 40
127456 107197 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 339 Kirkham St 1 Front Yard : Cutout Tree Private 2   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.58741 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688) 1 8 4 56 12
129885 111357 Significant Tree 6 Pinus radiata :: Monterey Pine 15 600x MANSELL ST 1 Front Yard : Cutout Tree DPW 1     48 3x3   6010142 2090267 37.7200474236955 -122.406969764511 (37.7200474236955, -122.406969764511) 10 3 8 309 28
130286 253951 Significant Tree 6 Tree(s) :: 17 431 Yerba Buena Ave 2 Front Yard : Cutout Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780852 5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
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
131538 173716 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1652 Fell St 1 Front Yard : Cutout Tree Private 2           5999516 2109850 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354) 15 5 11 29492 16
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
137101 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2777 Pine St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 779015 6000658 2114782 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069) 13 6 1 29490 27
138601 88455 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 4 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
141035 88568 Significant Tree 6 Tree(s) :: 17 1335 Webster St 59 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
145466 88567 Significant Tree 6 Tree(s) :: 17 1335 Webster St 39 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
152275 103719 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 748 Treat Ave 1 Front Yard : Cutout Tree Private 2     8 3x3   6008496.2 2104169 37.7581270399512 -122.413641518528 (37.7581270399512, -122.413641518528) 2 4 7 28859 19
154007 105073 Significant Tree 6 Myoporum laetum :: Myoporum 62 101 LUNDYS LN 1 Front Yard : Cutout Tree Private 2     18     6006875 2098969 37.7437578546964 -122.418879543436 (37.7437578546964, -122.418879543436) 2 7 7 28859 2
156168 113153 Significant Tree 6 Populus alba :: White Poplar 184 55 BRONTE ST   Front Yard : Cutout Tree Private 2     12 3x3   6009403 2097128 37.7388448914729 -122.410008345842 (37.7388448914729, -122.410008345842) 10 7 7 28859 2
156782 12711 Significant Tree 6 Tree(s) :: 17 1449 Lake St 3 Front Yard : Cutout Tree DPW 1   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046) 11 6 2 54 26
157634 85365 Significant Tree 6 Myoporum laetum :: Myoporum 62 66 Clarendon Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.7588714791444 -122.450538092312 (37.7588714791444, -122.450538092312) 15 5 11 28862 12
160978 112451 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 MASONIC AVE 1 Front Yard : Cutout Tree Private 2       3x6   5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
164452 117027 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 731 CLAYTON ST 1 Front Yard : Cutout Tree Private 2           5998515 2108057 37.7682369747157 -122.448440651351 (37.7682369747157, -122.448440651351) 15 5 11 29492 9
165013 85367 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1990 09th Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.465266058842 (37.7513105791605, -122.465266058842) 1 8 4 29491 12
166780 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout Tree Private 2   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338 2118225 37.7962597494046 -122.442865342513 (37.7962597494046, -122.442865342513) 13 9 1 57 17
170978 108021 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 455X Ivy St 1 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
173520 258387 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2770 Lombard St 1 Front Yard : Cutout Tree Private 2           5999223 2119112 37.7986315842223 -122.446787313103 (37.7986315842223, -122.446787313103) 13 9 1 57 17
177345 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout Tree Private 2   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497 2117826 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505) 13 9 1 29490 27
178383 254277 Significant Tree 6 Juniperus chinensis :: Juniper 113 105 Gladeview Way 1 Front Yard : Cutout Tree Private 2       3x6 Permit Number 781296 5997754 2101950 37.7514251480437 -122.450632514859 (37.7514251480437, -122.450632514859) 1 5 4 63 38

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);