341 rows where qLegalStatus_id = 8 sorted by qCaretaker_id

View and edit SQL

PlantType

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)
342 115652 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 18 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
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
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
12060 101900 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100 Ocean Ave 1 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
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
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
18104 260417 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 335 Corbett Ave 1 Median : Cutout Tree DPW 1       3x3   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3
22171 251481 Property Tree 8 Pinus radiata :: Monterey Pine 15 32 Peralta Ave 1 Back Yard : Yard Tree DPW 1       3x3   6010779 2100499 37.7481779538542 -122.405488104269 (37.7481779538542, -122.405488104269) 2 7 7 28859 2
24981 115647 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 13 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
27745 115653 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 19 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
36364 115642 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 8 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
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
61637 115638 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 4 Back Yard : Cutout Tree DPW 1     7 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
67651 115641 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 7 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
69931 115646 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 12 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
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
82655 115645 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 11 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
92653 115639 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 5 Back Yard : Cutout Tree DPW 1     6 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
94640 115635 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 1 Back Yard : Cutout Tree DPW 1     20 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
102518 115648 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 14 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
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
109260 115649 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 15 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
113451 115644 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 10 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
128219 101903 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 4 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
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
137355 115636 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 2 Back Yard : Cutout Tree DPW 1     16 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
144021 115650 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 16 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
144842 101905 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 6 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
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
154591 112948 Property Tree 8 Tristaniopsis laurina :: Swamp Myrtle 1 400 Pioche St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.422639431486 (37.7280608613968, -122.422639431486) 9 7 7 309 5
163840 115640 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 6 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
168631 115643 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 9 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
173132 115637 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 3 Back Yard : Cutout Tree DPW 1     14 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
175002 115655 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 21 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
177053 115654 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 20 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
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
191552 101904 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 5 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
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
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
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
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 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
1694 100166 Property Tree 8 Salix spp :: Willow 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree Private 2         Permit Number 769026                    
2059 264900 Property Tree 8 Pinus radiata :: Monterey Pine 15 35X Parkridge Dr 1 Median : Yard Tree Private 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
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
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
5288 260453 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 4 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
5987 262213 Property Tree 8 Olea europaea :: Olive Tree 9 66 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997837 2104660 37.7588708842054 -122.450540844653 (37.7588708842054, -122.450540844653) 15 5 11 28862 12
6335 262305 Property Tree 8 Casuarina cunninghamiana :: Horsetail pine 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
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
7179 260247 Property Tree 8 Magnolia spp :: Magnolia 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
7863 260451 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 2 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8587 260455 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 6 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
9029 258675 Property Tree 8 Myoporum laetum :: Myoporum 62 60 Laidley St 1 Back Yard : Yard Tree Private 2       3x3   6003232 2097949 37.7407513687421 -122.431403364879 (37.7407513687421, -122.431403364879) 2 7 5 63 7
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
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
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
12648 260457 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 8 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
13403 261178 Property Tree 8 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
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
13832 259913 Property Tree 8 Pinus radiata :: Monterey Pine 15 23 Cresta Vista Dr 1 Back Yard : Yard Tree Private 2       3x3   5995254 2096176 37.7354277647167 -122.45885975654 (37.7354277647167, -122.45885975654) 9 7 4 59 40
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
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
16690 260450 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 1 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
19362 260454 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 5 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19609 260452 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 3 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
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
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
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
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
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
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
24750 94468 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
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
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
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
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
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
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
28785 122558 Property Tree 8 Pinus radiata :: Monterey Pine 15 1760 Diamond St 1 Back Yard : Yard Tree Private 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
28928 116154 Property Tree 8 Pinus Spp :: Pine Spp 100 324 POPE ST 1 Back Yard : Yard Tree Private 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
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
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
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
30542 98548 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 132 Hamerton Ave 1 Front Yard : Yard Tree Private 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
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
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
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
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
33684 97290 Property Tree 8 Pinus radiata :: Monterey Pine 15 55 Hiliritas Ave   Front Yard : Yard Tree Private 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
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
34602 97033 Property Tree 8 Afrocarpus gracilior :: Fern Pine 89 61 Vicksburg St   Back Yard : Yard Tree Private 2         Possible significant tree; Nellie RoW; rear yard 6004120 2102703 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406) 2 4 5 28862 22
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
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
39981 256672 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 Kenwood Way 11 Back Yard : Yard Tree Private 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40

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