trees

341 rows where qLegalStatus_id = 8 sorted by Latitude descending

✎ View and edit SQL

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)
26017 109376 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 3 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
64778 109377 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 4 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
84676 109375 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 2 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
137889 109378 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 5 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
155569 109374 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 1 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
173335 117644 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1111X SANSOME ST 1 Back Yard : Yard Tree Private 2       3x30   6011937 2119613 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034) 3 1 10 308 23
141783 110320 Property Tree 8 :: 45 9 Imperial Aly   Back Yard : Yard Landscaping Private 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
46823 103516 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Back Yard : Yard Tree Private 2           6008298 2118971 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445) 5 1 10 308 32
113165 113482 Property Tree 8 Pinus radiata :: Monterey Pine 15 2839 Pierce St   Back Yard : Yard Tree Private 2           6001345 2118077 37.7959107386074 -122.439370308548 (37.7959107386074, -122.439370308548) 13 9 1 57 17
170932 102752 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 2452 Green St   Back Yard : Yard Tree Private 2           6001313 2117994 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164) 13 9 1 57 17
22174 33799 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 10 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
31871 33776 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
43580 33793 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
54368 33775 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
62239 33794 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 13 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
71205 33789 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
91079 33787 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
140802 33786 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
163103 33791 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
167692 33790 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
185435 33788 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
27877 33781 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x misson st 12 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757) 12 2 9 28855 6
31670 104539 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 2 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
49750 104540 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 4 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
52825 104544 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 8 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
86207 104538 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 1 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
99497 104543 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 7 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101786 104542 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 6 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
181064 104568 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 9 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 5 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
19898 98265 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 755 O'Farrell St   Back Yard : Yard Tree Private 2         Backyard tree; not significant 6007700 2113968.3 37.7849888609023 -122.417089467607 (37.7849888609023, -122.417089467607) 7 10 9 28858 36
136282 110181 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 2620 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 1.5x4   5999902.8272 2114053.62 37.7847814144727 -122.444071244627 (37.7847814144727, -122.444071244627) 15 6 1 29490 31
98201 106968 Property Tree 8 :: 45 351 26th Ave   Back Yard : Yard Tree Private 2           5987720.26121 2113604.44601 37.7828456076198 -122.486185401226 (37.7828456076198, -122.486185401226) 11 6 2 55 26
95526 100139 Property Tree 8 Tree(s) :: 17 155 05th St 2 Front Yard : Yard Tree Private 2         Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
193463 102056 Property Tree 8 Pinus radiata :: Monterey Pine 15 332 19th Ave 1 Back Yard : Yard Tree Private 2           5990007.7 2113121.3 37.7816520743217 -122.478236569715 (37.7816520743217, -122.478236569715) 11 6 2 55 26
67079 251294 Property Tree 8 :: 45 7126 Geary Blvd 1 Back Yard : Cutout Tree Private 2       3x3   5984860 2112552 37.7797887789018 -122.496002892522 (37.7797887789018, -122.496002892522) 11 6 2 55 26
150502 97162 Property Tree 8 Malus :: Crab Apple 82 478 10th Ave   Back Yard : Yard Tree Private 2         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686) 11 6 2 54 11
105239 110843 Property Tree 8 Pseudotsuga menziesii :: Douglas Fir 285 2037 TURK BLVD   Front Yard : Yard Tree Private 2     15     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
6943 262154 Property Tree 8 Pinus radiata :: Monterey Pine 15 519 22nd Ave 1 Back Yard : Yard Tree Private 2       3x3   5989039 2111772 37.7778909946523 -122.481488924787 (37.7778909946523, -122.481488924787) 11 6 2 55 26
96626 91109 Property Tree 8 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
109556 91108 Property Tree 8 Tree(s) :: 17 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
364 255980 Property Tree 8 Tree(s) :: 17 541 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000551 2110847 37.7760138103106 -122.441598590487 (37.7760138103106, -122.441598590487) 15 5 11 29492 16
20715 99276 Property Tree 8 Tree(s) :: 17 85X 10th St 2 Front Yard : Yard Tree Private 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
89589 99277 Property Tree 8 Tree(s) :: 17 85X 10th St 3 Front Yard : Yard Tree Private 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
103261 99275 Property Tree 8 Tree(s) :: 17 85X 10th St 1 Front Yard : Yard Tree Private 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
87602 253142 Property Tree 8 Juniperus silicicola :: Southern red cedar 429 735 29th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
163643 253143 Property Tree 8 Juniperus silicicola :: Southern red cedar 429 735 29th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
71797 256101 Property Tree 8 Populus spp :: Poplar Spp 262 1255 Oak St 1 Back Yard : Cutout Tree Private 2       3x3   6001013 2109627 37.7726903083913 -122.439912920243 (37.7726903083913, -122.439912920243) 15 5 11 29492 9
30353 105684 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 1 Front Yard : Pot Tree Private 2     10     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
33251 105685 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 2 Front Yard : Pot Tree Private 2     8     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
145638 105686 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 3 Front Yard : Pot Tree Private 2     6     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
123806 256658 Property Tree 8 Pinus radiata :: Monterey Pine 15 7014 Fulton St 1 Back Yard : Cutout Tree Private 2           5981603 2109659 37.7716541501084 -122.507055421099 (37.7716541501084, -122.507055421099) 11 6 2 55 26
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
183366 251343 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 934 Brannan St 1 Back Yard : Yard Tree Private 2       3x3   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
189109 120533 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 951 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   6010745 2108673 37.7706200263658 -122.406181480785 (37.7706200263658, -122.406181480785) 14 2 9 28853 34
9668 264919 Property Tree 8 Olea Majestic Beauty :: 183 1833 Page St 1 Sidewalk: Property side : Yard Tree Public Library 12       3x3   5997789 2108763 37.7701339345343 -122.451002717521 (37.7701339345343, -122.451002717521) 15 5 11 29492 9
80203 253469 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 701 Stanyan St 5 Side Yard : Yard Tree Private 2           5997178 2108423 37.7691653834469 -122.453091601514 (37.7691653834469, -122.453091601514) 15 5 11 29492 9
141124 100244 Property Tree 8 Persea americana :: Avocado 34 71 Sanchez St   Back Yard : Yard Tree Private 2         Interior courtyard 6003507 2107903 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878) 7 9 5 28862 3
179317 103673 Property Tree 8 :: 45 64 Henry St   Back Yard : Yard Tree Private 2           6003097 2107420 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662) 15 5 5 28862 3
163139 112668 Property Tree 8 Pinus radiata :: Monterey Pine 15 129 Henry St   Back Yard : Yard Tree Private 2           6002668 2107340.8 37.7665070360696 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
142995 108574 Property Tree 8 Tree(s) :: 17 1891 15th St 1 Back Yard : Yard Tree Private 2       7x8   6004884.86016 2107160.44126 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
92154 97177 Property Tree 8 Tree(s) :: 17 257 Roosevelt Way   Back Yard : Yard Tree Private 2         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.7658190148973 -122.440304070451 (37.7658190148973, -122.440304070451) 15 5 5 28862 3
121285 104318 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 22 Beaver St 1 Front Yard : Yard Tree Private 2       3x3   6002763 2106816 37.765071454108 -122.433658549479 (37.765071454108, -122.433658549479) 15 5 5 28862 3
101829 257926 Property Tree 8 Pinus radiata :: Monterey Pine 15 8 Hill Point Ave 1 Back Yard : Yard Tree Private 2       3x3   5996384 2106804 37.7646744896132 -122.455720942569 (37.7646744896132, -122.455720942569) 15 5 11 29492 12
39751 96590 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
44908 96593 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
63210 96591 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
81530 96594 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
145479 96592 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
156111 96589 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
2474 256556 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 5 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
34431 256554 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 3 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
90011 256555 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 4 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
175776 256557 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 6 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176971 256553 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 2 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
189291 256552 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 1 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
120621 101625 Property Tree 8 Fagus sylvatica :: European Beech 272 64 Levant St 1 Front Yard : Cutout Tree Private 2         Permit Number 769362 6000275.9 2106473.5 37.7639895997076 -122.442236202383 (37.7639895997076, -122.442236202383) 15 5 5 28862 3
35596 254587 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1270 24th Ave 1 Back Yard : Cutout Tree Private 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
56024 105231 Property Tree 8 Pinus Spp :: Pine Spp 100 460X ROOSEVELT WAY 1 Front Yard : Yard Tree Private 2     9     6000051 2106345 37.7636239504047 -122.443004833609 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
8082 96598 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
19875 96597 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
33788 96601 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
35006 96602 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
120469 96606 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
136541 96599 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
138264 96604 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
142618 96600 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
184992 96603 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186894 96605 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
149052 105232 Property Tree 8 Pinus radiata :: Monterey Pine 15 460X ROOSEVELT WAY 2 Front Yard : Yard Tree Private 2     17     5999944 2106286 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769) 15 5 5 29492 3
116904 105236 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 235X STATES ST 1 Back Yard : Yard Tree Private 2     30     6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
177432 102706 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1342 Funston Ave 1 Back Yard : Yard Tree Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
11932 252833 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 1 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
13841 252837 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 5 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
103773 252839 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 2 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
136363 252834 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 2 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
183841 252835 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 3 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9

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