185 rows where Police Districts = 5 and qLegalStatus_id = 6 sorted by PlantDate

View and edit SQL

Police Districts

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)
180 110904 Significant Tree 6 Tree(s) :: 17 203 CORBETT AVE 1 Front Yard : Yard Tree Private 2     20 3x3   6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3
2352 101748 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700X Panorama Dr 1 Back Yard : Yard Tree Private 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
3462 233333 Significant Tree 6 Pinus radiata :: Monterey Pine 15 188 States St 1 Back Yard : Yard Tree Private 2     14 Width 3ft Permit Number 784841 6001049.9199 2106366.66768 37.763740347549 -122.43955144426 (37.763740347549, -122.43955144426) 15 5 5 28862 3
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
7026 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150 Raccoon Dr 1 Back Yard : Cutout Tree Private 2     36 3x3   5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
13777 261032 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 438 Roosevelt Way 2 Front Yard : Yard Tree Private 2       Width 3ft   6000030.97008 2106544.70148 37.7641711390149 -122.443088453592 (37.7641711390149, -122.443088453592) 15 5 5 29492 3
14733 255398 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 637 MASONIC AVE 3 Sidewalk: Property side : Cutout Tree Private 2       Width 0ft   5999139.3301 2110590.1819 37.7752281241925 -122.446463429304 (37.7752281241925, -122.446463429304) 15 5 11 29492 16
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
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18711 262449 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 155 Baker St 1 Side Yard : Yard Tree Private 2       10x10   6000750.251 2109577.8851 37.7725404908768 -122.440818271359 (37.7725404908768, -122.440818271359) 15 5 11 29492 9
18868 260249 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 10 Crestline Dr 1 Median : Yard Tree Private 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
21449 255662 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
23401 114142 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99 Divisadero St   Front Yard : Yard Tree Private 2           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265) 15 5 5 29492 3
24444 173927 Significant Tree 6 Pinus radiata :: Monterey Pine 15 240 States St 1 Back Yard : Yard Tree Private 2           6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
25777 257968 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499X Carl St 2 Sidewalk: Property side : Yard Tree Private 2       10x10   5995946 2106884 37.7648690031923 -122.457241646887 (37.7648690031923, -122.457241646887) 15 5 11 29492 12
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
34055 105417 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 3 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
34533 110193 Significant Tree 6 Pinus radiata :: Monterey Pine 15 7X CASTRO ST 1 Back Yard : Yard Tree Private 2       3x3   6002014.1 2108690 37.7701744750285 -122.436382938918 (37.7701744750285, -122.436382938918) 15 5 5 29492 9
35186 100579 Significant Tree 6 Tree(s) :: 17 35 Lloyd St 2 Front Yard : Yard Tree Private 2           6002279.7 2108550 37.7698051576272 -122.435454215606 (37.7698051576272, -122.435454215606) 15 5 5 29492 9
35278 115415 Significant Tree 6 Pinus radiata :: Monterey Pine 15 137 ANZAVISTA AVE 1 Back Yard : Yard Tree Private 2       3x3   5999865 2112093 37.7793958997315 -122.444061187374 (37.7793958997315, -122.444061187374) 15 5 1 29490 16
36670 87156 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 237 Rivoli St 1 Front Yard : Yard Tree Private 2         Permit Number 50138 5997662 2105892 37.7622436280127 -122.451234923187 (37.7622436280127, -122.451234923187) 15 5 11 29492 9
36736 101527 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 151-153 Lower Ter 1 Front Yard : Yard Tree Private 2     18   Permit Number 769490 6000139.7 2106146.6 37.7630842500585 -122.4426838025 (37.7630842500585, -122.4426838025) 15 5 5 28862 3
37143 257967 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499X Carl St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   5995946 2106884 37.7648690031923 -122.457241646887 (37.7648690031923, -122.457241646887) 15 5 11 29492 12
37158 254238 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 47 Cole St 3 Front Yard : Yard Tree Private 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
38032 110839 Significant Tree 6 Tree(s) :: 17 2037 TURK BLVD 1 Front Yard : Yard Tree Private 2     13     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
38051 108038 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Twin Peaks Blvd   Front Yard : Yard Tree Private 2           5998985.48572 2105240.3128 37.7605299471227 -122.446610614338 (37.7605299471227, -122.446610614338) 15 5 5 28862 12
38960 103564 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 2 Front Yard : Yard Tree Private 2     13   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
39106 116501 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 2 Median : Yard Tree Private 2     40 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
39128 251719 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1301 Clayton St 1 Side Yard : Yard Tree Private 2           5999055 2105304 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866) 15 5 5 28862 12
40516 254236 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 47 Cole St 1 Front Yard : Yard Tree Private 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
50909 103563 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 1 Front Yard : Yard Tree Private 2     15   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
51304 255705 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 1 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
51579 251199 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 4 Front Yard : Yard Tree Private 2       3X3   6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
58933 116864 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 3 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
59354 102987 Significant Tree 6 Quercus palustris :: Pin Oak 379 161 Edgewood Ave 1 Front Yard : Yard Tree Private 2         Permit Number 769930 5996558.2 2106100.3 37.7627523048829 -122.455067580852 (37.7627523048829, -122.455067580852) 15 5 11 29492 12
62810 110841 Significant Tree 6 Tree(s) :: 17 2037 TURK BLVD 3 Front Yard : Yard Tree Private 2           6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
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
67290 87157 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 237 Rivoli St 2 Front Yard : Yard Tree Private 2         Permit Number 50138 5997662 2105892 37.7622436280127 -122.451234923187 (37.7622436280127, -122.451234923187) 15 5 11 29492 9
68001 110840 Significant Tree 6 Tree(s) :: 17 2037 TURK BLVD 2 Front Yard : Yard Tree Private 2           6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
68234 107718 Significant Tree 6 Tree(s) :: 17 1 DOUGLASS ST 1 Front Yard : Yard Tree Private 2     16     6001037.5 2106279.2 37.7634994759637 -122.439588129958 (37.7634994759637, -122.439588129958) 15 5 5 28862 3
70573 116500 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 1 Median : Yard Tree Private 2     45 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
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
77157 112924 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2X Noe St   Sidewalk: Property side : Yard Tree Private 2           6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
77539 187651 Significant Tree 6 Myoporum laetum :: Myoporum 62 175 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998689 2104063 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828) 15 5 5 63 3
80551 100195 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 3 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
83112 93724 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 415 Belvedere St   Front Yard : Yard Tree Private 2           5998488 2106798 37.7647785355325 -122.448443362436 (37.7647785355325, -122.448443362436) 15 5 11 29492 9
83943 118327 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 109 ALPINE TER   Sidewalk: Curb side : Cutout Tree Private 2     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181 (37.7688096651516, -122.43737752181) 15 5 5 29492 3
85388 255663 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
86356 254240 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 47 Cole St 5 Front Yard : Yard Tree Private 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
86997 116863 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 2 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
87199 116862 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 1 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
87223 103565 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 3 Front Yard : Yard Tree Private 2     9   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
88761 111358 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1637 OAK ST 1 Front Yard : Yard Tree Private 2       3x15   5999143 2109364 37.7718615511814 -122.446362505197 (37.7718615511814, -122.446362505197) 15 5 11 29492 9
89139 111359 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1637 OAK ST 2 Front Yard : Yard Tree Private 2       3x15   5999143 2109364 37.7718615511814 -122.446362505197 (37.7718615511814, -122.446362505197) 15 5 11 29492 9
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
100026 254674 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 2 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
102398 105415 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 1 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
106559 110842 Significant Tree 6 Tree(s) :: 17 2037 TURK BLVD 4 Front Yard : Yard Tree Private 2           6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
107819 116502 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 3 Median : Yard Tree Private 2     28 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
108660 105368 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 180 CLIFFORD TER   Sidewalk: Curb side : Cutout Tree Private 2           5999283.1 2106587.2 37.7642451591147 -122.445678167683 (37.7642451591147, -122.445678167683) 15 5 5 29492 9
109594 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 2 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
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
114223 105416 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 2 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
115682 111766 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1860 HAYES ST 4 Front Yard : Yard Tree SFUSD 4           5998973 2110255 37.7742982989317 -122.447014674672 (37.7742982989317, -122.447014674672) 15 5 11 29492 16
117472 103478 Significant Tree 6 Aesculus californica :: California Buckeye 168 50 Gardenside Dr 1 Front Yard : Yard Tree Private 2         Permit Number 770287 5999492 2102892 37.7541109784186 -122.444690026478 (37.7541109784186, -122.444690026478) 2 5 5 63 38
119143 113163 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1300X STANYAN ST 2 Front Yard : Yard Tree Private 2     40 3x3   5997565 2104877 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349) 15 5 11 28862 12
122782 255708 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 2 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
123285 107037 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1060 Clayton St 1 Front Yard : Yard Tree Private 2     99     5998985 2106259 37.7633269800406 -122.446685590868 (37.7633269800406, -122.446685590868) 15 5 5 29492 9
123649 98302 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 6 Locksley Ave 2 Front Yard : Yard Tree Private 2           5994194 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093) 1 5 4 56 12
125726 113380 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 63 Potomac St 1 Front Yard : Yard Tree Private 2       4x4 Permit Number 776311 6003081 2108682.5 37.7702144463181 -122.432692008068 (37.7702144463181, -122.432692008068) 15 5 5 29492 9
125728 98303 Significant Tree 6 Myoporum laetum :: Myoporum 62 6 Locksley Ave 3 Front Yard : Yard Tree Private 2           5994194 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093) 1 5 4 56 12
129904 254673 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 1 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
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
132961 108177 Significant Tree 6 Pinus radiata :: Monterey Pine 15 201 PANORAMA DR 1 Front Yard : Yard Tree Private 2     22 3x3   5997273.1 2100946.6 37.7486425219839 -122.452223122411 (37.7486425219839, -122.452223122411) 1 5 4 63 38
134725 187654 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
135834 102467 Significant Tree 6 Pinus radiata :: Monterey Pine 15 36 Saint Germain Ave 1 Front Yard : Yard Tree Private 2           5997576.7 2104111.9 37.757351037011 -122.451401547119 (37.757351037011, -122.451401547119) 15 5 4 28862 38
139403 100171 Significant Tree 6 Quercus suber :: Cork Oak 78 109 Edgewood Ave 1 Front Yard : Yard Tree Private 2           5996563.8 2106359.1 37.763463224844 -122.455066914463 (37.763463224844, -122.455066914463) 15 5 11 29492 12
144656 255730 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002272 2111622 37.7782396679587 -122.435700666763 (37.7782396679587, -122.435700666763) 15 5 11 29490 41
145352 100578 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 35 Lloyd St 1 Front Yard : Yard Tree Private 2         Permit Number 56924 6002279.7 2108550 37.7698051576272 -122.435454215606 (37.7698051576272, -122.435454215606) 15 5 5 29492 9
145840 113162 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1300X STANYAN ST 1 Front Yard : Yard Tree Private 2     40 3x3   5997565 2104877 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349) 15 5 11 28862 12
148062 85032 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Panorama Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5997300 2101977 37.7514732863106 -122.452204440653 (37.7514732863106, -122.452204440653) 1 5 4 63 38
149146 105234 Significant Tree 6 Olea europaea :: Olive Tree 9 250 STATES ST 5 Front Yard : Yard Tree Private 2     12     6000595.6 2106681.2 37.7645781078798 -122.441145360444 (37.7645781078798, -122.441145360444) 15 5 5 28862 3
150406 251198 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2           6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
151692 104169 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470X Roosevelt Way 1 Front Yard : Yard Tree Private 2           5999944.58235 2106286.89423 37.7634583383964 -122.443368723848 (37.7634583383964, -122.443368723848) 15 5 5 29492 3
153493 256541 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Warren Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995584 2102944 37.754029973308 -122.458208518647 (37.754029973308, -122.458208518647) 1 5 4 63 12
155327 107408 Significant Tree 6 Acer japonicum :: Japanese Maple 124 10 PEMBERTON PL 1 Front Yard : Yard Tree Private 2     30     5998956.5 2104566.5 37.7586781689727 -122.446662380642 (37.7586781689727, -122.446662380642) 15 5 5 28862 12
155662 105755 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1100X Divisadero St 1 Front Yard : Yard Tree Private 2           6001418 2112151 37.7796436231931 -122.438692875339 (37.7796436231931, -122.438692875339) 15 5 11 29490 41
157045 105845 Significant Tree 6 Pinus radiata :: Monterey Pine 15 355 Buena Vista Ave   Front Yard : Yard Tree Private 2           6000886.5 2107736.6 37.767492540377 -122.440214908068 (37.767492540377, -122.440214908068) 15 5 5 29492 3
158256 104037 Significant Tree 6 Tree(s) :: 17 520X Oak Park Dr 2 Front Yard : Yard Tree Private 2           5995008.5 2103700.7 37.7560745928775 -122.460253542676 (37.7560745928775, -122.460253542676) 1 5 4 63 12
158598 117249 Significant Tree 6 Pinus radiata :: Monterey Pine 15 299x GRAYSTONE TER 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999641 2104067 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093) 2 5 5 28862 3
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
163180 254675 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 3 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
163659 102019 Significant Tree 6 Melaleuca quinquenervia :: Cajeput 10 3028 Market St 1 Front Yard : Yard Tree Private 2     30 4x14   6000376.7 2105451.5 37.7611891846044 -122.44181421161 (37.7611891846044, -122.44181421161) 15 5 5 28862 3
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
168009 254385 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 178X Warren Dr 1 Side Yard : Yard Tree Private 2       3x3   5995100 2102878 37.7538209308694 -122.459877514706 (37.7538209308694, -122.459877514706) 1 5 4 63 12

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