341 rows where qLegalStatus_id = 8 sorted by Fire Prevention Districts

View and edit SQL

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)
1694 100166 Property Tree 8 Salix spp :: Willow 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree Private 2         Permit Number 769026                    
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
628 256542 Property Tree 8 Pinus radiata :: Monterey Pine 15 133 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
1189 261265 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 5 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
3020 260513 Property Tree 8 Pinus radiata :: Monterey Pine 15 1990 41st Ave 1 Back Yard : Yard Tree Health Dept 13       10x10   5983703 2101544 37.7494961014415 -122.499191781388 (37.7494961014415, -122.499191781388) 1 8 3 29491 35
4239 258982 Property Tree 8 Pinus radiata :: Monterey Pine 15 239 Panorama Dr 1 Back Yard : Yard Tree Private 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
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
13075 261490 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
13614 258670 Property Tree 8 Pinus radiata :: Monterey Pine 15 152 Kensington Way   Front Yard : Yard Tree Private 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
15601 99374 Property Tree 8 Pinus radiata :: Monterey Pine 15 21 Panorama Dr   Back Yard : Yard Tree Private 2     24     5998009 2100230 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288) 1 5 4 63 38
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
20664 121198 Property Tree 8 Cordyline australis :: Dracena Palm 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 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
28314 256608 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 2 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
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
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
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
51917 256537 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Cutout Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
56515 102470 Property Tree 8 Pinus radiata :: Monterey Pine 15 1021 Kirkham St 2 Back Yard : Yard Tree Private 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
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
75714 114950 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 2 unknown : Yard Tree DPW 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
87678 254111 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 1 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89545 256543 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
89692 122453 Property Tree 8 Pinus radiata :: Monterey Pine 15 217 San Marcos Ave 1 Back Yard : Yard Tree Private 2       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209) 1 8 4 29491 40
92957 257936 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 2 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
96282 117254 Property Tree 8 Pinus radiata :: Monterey Pine 15 2067 33RD AVE 1 Back Yard : Yard Tree Private 2       3x3   5985987 2101171 37.7486056682842 -122.491266304796 (37.7486056682842, -122.491266304796) 1 8 3 29491 35
99909 96676 Property Tree 8 Prunus spp :: Cherry 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
103546 113379 Property Tree 8 Fagus sylvatica :: European Beech 272 140 CASTENADA AVE 1 Front Yard : Yard Tree Private 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
105992 258053 Property Tree 8 Pinus radiata :: Monterey Pine 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
107546 112377 Property Tree 8 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 3 Sidewalk: Curb side : Cutout Tree MTA 3     36     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
108384 122480 Property Tree 8 Pinus radiata :: Monterey Pine 15 596X Buckingham Way 1 Side Yard : Cutout Tree Private 2       3x3   5990152 2094375 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616) 1 8 4 64 14
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
124235 122518 Property Tree 8 Pinus radiata :: Monterey Pine 15 772X Panorama Dr 1 Back Yard : Cutout Tree Private 2       3x3   5996713 2102901 37.7539767153501 -122.45430108189 (37.7539767153501, -122.45430108189) 1 5 4 63 38
131293 254124 Property Tree 8 Pinus radiata :: Monterey Pine 15 365 Edgehill Way 1 Back Yard : Cutout Tree Private 2       3x3   5994964 2098864 37.7427916745102 -122.460057057879 (37.7427916745102, -122.460057057879) 1 8 4 59 40
133884 114949 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 1 unknown : Yard Tree DPW 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
134592 102469 Property Tree 8 Pinus radiata :: Monterey Pine 15 1021 Kirkham St 1 Back Yard : Yard Tree Private 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
159644 120526 Property Tree 8 Pinus radiata :: Monterey Pine 15 1439 47th Ave 1 Back Yard : Yard Tree Private 2     20 3x3   5981489 2105275 37.7596102388302 -122.50712446854 (37.7596102388302, -122.50712446854) 1 8 3 56 35
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
168913 114365 Property Tree 8 Pinus radiata :: Monterey Pine 15 2546 28th Ave 1 Back Yard : Yard Tree Private 2     35     5987735.7 2097954.4 37.7398757613896 -122.484983441996 (37.7398757613896, -122.484983441996) 1 8 3 29491 35
176576 257935 Property Tree 8 Pinus radiata :: Monterey Pine 15 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
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
177799 103504 Property Tree 8 Pinus radiata :: Monterey Pine 15 148 Huntington Dr 1 Back Yard : Yard Tree Private 2           5984515 2095210 37.7321522522788 -122.49591670505 (37.7321522522788, -122.49591670505) 1 8 4 64 35
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
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
7677 258687 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 9 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
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
9214 264784 Property Tree 8 Pinus halepensis :: Allepo Pine 330 67 Rosenkranz St 3 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
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
12066 258686 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 8 Sidewalk: Curb side : Yard 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
15695 262389 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 67 Rosenkranz St 1 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
15996 258691 Property Tree 8 Pinus radiata :: Monterey Pine 15 100x Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 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
27030 106971 Property Tree 8 Pinus radiata :: Monterey Pine 15 3479X San Bruno Ave 1 Front Yard : Yard Tree Private 2     30     6011510.60551 2091910.03431 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294) 10 3 7 309 28
28806 97041 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 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
30618 97004 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A 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
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 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
33597 97039 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 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
35599 97045 Property Tree 8 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 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
39203 97052 Property Tree 8 Pyrus spp :: Pear Tree 281 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
40665 97022 Property Tree 8 Umbellularia californica :: California Bay 326 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
41028 97042 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 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
41321 97014 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 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
44692 97015 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 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
51341 97051 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
56664 97021 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 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
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
62691 97040 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 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
64109 97027 Property Tree 8 Myoporum laetum :: Myoporum 62 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
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
71527 97029 Property Tree 8 Rhamnus californica :: Coffeeberry Tree 320 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
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
92080 97016 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 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
104074 97028 Property Tree 8 Morus alba :: White Mulberry 246 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
116957 97032 Property Tree 8 Griselinia lucida :: Griselinia 242 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
120723 97043 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 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
125967 96999 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A 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
128716 108973 Property Tree 8 Pinus radiata :: Monterey Pine 15 3485X SAN BRUNO AVE 1 Median : Yard Tree DPW for City Agency 14           6011510 2091910 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066) 10 3 7 309 28
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
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
149518 109194 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 4705 03rd St   Back Yard : Yard Tree Arts Commission 19     45     6015121.6 2095617 37.7350148477359 -122.390130397219 (37.7350148477359, -122.390130397219) 10 3 8 58 1
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
175126 97044 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 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
175634 97037 Property Tree 8 Griselinia lucida :: Griselinia 242 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
176465 97038 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 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
179653 97035 Property Tree 8 Casurina stricta :: Beefwood: Drooping She-Oak 173 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
189767 97036 Property Tree 8 Griselinia lucida :: Griselinia 242 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
192727 97026 Property Tree 8 Tilia cordata :: Littleleaf Linden 12 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
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
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
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
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
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
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
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
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
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

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