trees

341 rows where qLegalStatus_id = 8 sorted by qSpecies_id

✎ 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)
181668 115651 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 17 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
183601 256482 Property Tree 8 Pinus radiata :: Monterey Pine 15 168 Moultrie St 1 Back Yard : Cutout Tree Private 2       3x3   6007766 2098288 37.7419381097545 -122.415750458671 (37.7419381097545, -122.415750458671) 2 7 7 28859 2
185468 120977 Property Tree 8 Pinus radiata :: Monterey Pine 15 794x Gates St 1 Sidewalk: Curb side : Yard Tree Private 2     3030 3x3   6008103 2095407 37.7340464539486 -122.414381414226 (37.7340464539486, -122.414381414226) 2 7 7 28859 2
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
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
5745 193934 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 Width 3ft   6016623.26344 2095403.70542 37.7345123576517 -122.384923708478 (37.7345123576517, -122.384923708478) 10 3 8 58 1
17872 258685 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 2 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
54121 101901 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 1100 Ocean Ave 2 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
66427 248974 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 716 Goettingen St 1 Back Yard : Yard Tree Private 2       3x3   6010713 2091306 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237) 10 3 7 309 28
227 102275 Property Tree 8 Tree(s) :: 17 267 Topaz Way   Back Yard : Yard Landscaping Private 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
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
26011 100148 Property Tree 8 Tree(s) :: 17 209 Vicksburg St   Back Yard : Yard Tree Private 2           6004141 2102142 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
27177 101951 Property Tree 8 Tree(s) :: 17 21 Lyell St   unknown : Yard Tree Private 2           6003106 2094969 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
30075 100070 Property Tree 8 Tree(s) :: 17 331 Serrano Dr 1 Front Yard : Yard Tree Private 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
32266 108871 Property Tree 8 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard Tree Private 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
33827 99268 Property Tree 8 Tree(s) :: 17 292 Whitney St   Front Yard : Cutout Tree Private 2           6004280 2096681 37.7373290690714 -122.427689454915 (37.7373290690714, -122.427689454915) 2 7 5 63 7
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
54211 98502 Property Tree 8 Tree(s) :: 17 244 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
58309 100046 Property Tree 8 Tree(s) :: 17 562 28th St   Front Yard : Yard Tree Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
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
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
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
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
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
99841 98436 Property Tree 8 Tree(s) :: 17 238 Glenview Dr   Back Yard : Yard Tree Private 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
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
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
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
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
129765 105353 Property Tree 8 Tree(s) :: 17 1979 SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
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
149268 106458 Property Tree 8 Tree(s) :: 17 71 HANCOCK ST   Back Yard : Yard Tree Private 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 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
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
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
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
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
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
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
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
146144 105171 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 4755X 03RD ST 5 Front Yard : Yard Tree Arts Commission 19     14 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
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
164164 105170 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 4755X 03RD ST 4 Front Yard : Cutout Tree Arts Commission 19     2 3x3   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
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
20402 257888 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 155X Magellan Ave 1 Front Yard : Yard Tree MTA 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
57045 105169 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 3 Front Yard : Cutout Tree Arts Commission 19     23 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
133384 105167 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 1 Front Yard : Cutout Tree Arts Commission 19     8 3x3   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
153614 255116 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 301X Chester Ave 3 Sidewalk: Property side : Cutout Tree DPW 1       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
178160 173600 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 500 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996184 2102497 37.7528370823128 -122.456101271869 (37.7528370823128, -122.456101271869) 1 5 4 63 12
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
169065 108625 Property Tree 8 Persea americana :: Avocado 34 100 GENEBERN WAY 1 Front Yard : Yard Tree Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
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
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
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
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
134313 255008 Property Tree 8 Pittosporum undulatum :: Victorian Box 36 1 Villa Ter 1 Back Yard : Yard Tree Private 2       3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
10450 114373 Property Tree 8 Liquidambar styraciflua :: American Sweet Gum 37 805 GONZALEZ DR 1 Front Yard : Yard Tree Private 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
42570 224716 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 5 Front Yard : Cutout Tree MTA 3     13 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
68467 224715 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 4 Front Yard : Cutout Tree MTA 3     12 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
141413 224714 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 3 Front Yard : Cutout Tree MTA 3     11 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
154580 224422 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 2 Front Yard : Cutout Tree MTA 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
106981 109092 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
194103 109076 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
30200 98503 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 208 Glenview Dr   Back Yard : Yard Tree Private 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
44661 102745 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 222 Moncada Way 1 Front Yard : Yard Tree Private 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
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
57789 121199 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 72 Fountain St 1 Back Yard : Yard Tree Private 2           6000322 2101283 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556) 2 4 5 28862 22
75016 98140 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 315 San Marcos Ave   Front Yard : Yard Tree Private 2           5992920.8 2100212.1 37.7463754865467 -122.467219803339 (37.7463754865467, -122.467219803339) 1 8 4 29491 40
112077 253339 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2019X 24th Ave 1 Sidewalk: Property side : Yard Tree PUC 8       3x3   5988853 2101569 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136) 1 8 3 29491 35
113507 253768 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 100 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 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
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
157400 97685 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 84 Coventry Ct   Back Yard : Yard Tree Private 2           5997084 2096485 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132) 9 7 4 59 40
161514 253207 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 89 Woodhaven Ct 1 Back Yard : Cutout Tree Private 2       3x3   5996069 2103645 37.7559825991437 -122.456581972884 (37.7559825991437, -122.456581972884) 1 5 4 63 12
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
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
192549 98880 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 101 Lansdale Ave 1 Front Yard : Yard Tree Private 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
22075 187658 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 600X Clarendon Ave 1 Front Yard : Yard Tree Private 2       3x3   5995637 2102382 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932) 1 5 4 63 12
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
23775 108576 Property Tree 8 :: 45 2479 Diamond St 1 Front Yard : Yard Landscaping Private 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
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
91643 97034 Property Tree 8 :: 45 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
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
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
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
94159 97024 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
122314 97023 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19

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