trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
7000 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 52 Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
7196 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 60R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999394 | 2100048 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | 2 | 7 | 5 | 63 | 22 | |||||
7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
20228 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 14R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999202 | 2100044 | 37.7462745109784 | -122.445488137723 | (37.7462745109784, -122.445488137723) | 2 | 7 | 5 | 63 | 22 | |||||
20385 | 251602 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 44R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
34428 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 22R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999148 | 2100052 | 37.7462933941297 | -122.445675437709 | (37.7462933941297, -122.445675437709) | 2 | 7 | 5 | 63 | 22 | |||||
39032 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 48R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
42469 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 8R Amethyst Way | 2 | Back Yard : Yard | Tree | Private 2 | 5999237 | 2100032 | 37.7462435599048 | -122.445366249721 | (37.7462435599048, -122.445366249721) | 2 | 7 | 5 | 63 | 22 | |||||
51717 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
52672 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
54862 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 48R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
71809 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard | Tree | Private 2 | 2 | 6004001.3006 | 2094332.00643 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | 9 | 7 | 6 | 28861 | 5 | ||||
74590 | 115445 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 1 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
77182 | 251613 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 60R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999394 | 2100048 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | 2 | 7 | 5 | 63 | 22 | |||||
92509 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | 2 | 7 | 7 | 28859 | 2 | ||
98838 | 251629 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 8R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999237 | 2100032 | 37.7462435599048 | -122.445366249721 | (37.7462435599048, -122.445366249721) | 2 | 7 | 5 | 63 | 22 | |||||
100865 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
102716 | 251631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 8R Amethyst Way | 3 | Back Yard : Yard | Tree | Private 2 | 5999237 | 2100032 | 37.7462435599048 | -122.445366249721 | (37.7462435599048, -122.445366249721) | 2 | 7 | 5 | 63 | 22 | |||||
110002 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | 2 | 7 | 7 | 28859 | 2 | ||
111349 | 251628 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2R Amethyst Way | 3 | Back Yard : Yard | Tree | Private 2 | 5999263 | 2100016 | 37.7462011119367 | -122.44527519505 | (37.7462011119367, -122.44527519505) | 2 | 7 | 5 | 63 | 22 | |||||
113435 | 251621 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 72R Amber Dr | 4 | Back Yard : Yard | Tree | Private 2 | 5999318 | 2100030 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | 2 | 7 | 5 | 63 | 22 | |||||
120908 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | 9 | 7 | 6 | 28861 | 5 | ||||
122354 | 251619 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 72R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999318 | 2100030 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | 2 | 7 | 5 | 63 | 22 | |||||
145363 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999263 | 2100016 | 37.7462011119367 | -122.44527519505 | (37.7462011119367, -122.44527519505) | 2 | 7 | 5 | 63 | 22 | |||||
150154 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard | Tree | Private 2 | 2 | 6003898.31997 | 2094328.29867 | 37.7308474854131 | -122.428841421596 | (37.7308474854131, -122.428841421596) | 9 | 7 | 6 | 28861 | 5 | ||||
153865 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 14R Amethyst Way | 2 | Back Yard : Yard | Tree | Private 2 | 5999202 | 2100044 | 37.7462745109784 | -122.445488137723 | (37.7462745109784, -122.445488137723) | 2 | 7 | 5 | 63 | 22 | |||||
156992 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x Montcalm St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010036 | 2099760 | 37.7461072494139 | -122.408005278478 | (37.7461072494139, -122.408005278478) | 2 | 7 | 7 | 28859 | 2 | ||||
159825 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard | Tree | Private 2 | 2 | 6003946.78636 | 2094329.77315 | 37.7308542770831 | -122.428673970523 | (37.7308542770831, -122.428673970523) | 9 | 7 | 6 | 28861 | 5 | ||||
165425 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard | Tree | Private 2 | 3 | 6003967.55773 | 2094330.40491 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | 9 | 7 | 6 | 28861 | 5 | ||||
167870 | 251608 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
169643 | 251606 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 52R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
177119 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard | Tree | Private 2 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | 9 | 7 | 6 | 28861 | 25 | |||
177581 | 251609 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
177640 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 30X Zircon Pl | 1 | Back Yard : Yard | Tree | Private 2 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.434652757436 | (37.7430068656447, -122.434652757436) | 2 | 7 | 5 | 63 | 7 | |||||
178454 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard | Tree | Private 2 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051412 | (37.7332919614683, -122.45317051412) | 9 | 7 | 4 | 59 | 40 | |||
179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
184053 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X STILLINGS AVE | 1 | Back Yard : Yard | Tree | Private 2 | 60 | 6000417 | 2095694 | 37.7343997262189 | -122.44097481224 | (37.7343997262189, -122.44097481224) | 9 | 7 | 5 | 63 | 40 | ||||
184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
190882 | 251610 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 3 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
194175 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 699X DETROIT ST | 9 | Back Yard : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
126350 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : | Tree | Private 2 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261909 | (37.740765720819, -122.41052261909) | 10 | 7 | 7 | 28859 | 2 | |||
429 | 259715 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 210 Gold Mine Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000723 | 2098465 | 37.7420256658379 | -122.440115509428 | (37.7420256658379, -122.440115509428) | 2 | 7 | 5 | 63 | 7 | ||||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
8573 | 264725 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 136 Addison St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002996 | 2096937 | 37.7379592717499 | -122.432147110586 | (37.7379592717499, -122.432147110586) | 2 | 7 | 5 | 63 | 7 | ||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
14356 | 264786 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 451 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995368 | 2094795 | 37.7316424274687 | -122.458365690275 | (37.7316424274687, -122.458365690275) | 9 | 7 | 4 | 59 | 40 | ||||
29379 | 254551 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 1433 Cayuga Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5999129 | 2089595 | 37.7175798453783 | -122.444989533853 | (37.7175798453783, -122.444989533853) | 9 | 7 | 6 | 28861 | 25 | ||||
34696 | 253950 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 431 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | ||||
69512 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 500 Raymond Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.87951 | 2088473.93147 | 37.7150170728648 | -122.413438766187 | (37.7150170728648, -122.413438766187) | 9 | 7 | 8 | 309 | 18 | ||
92659 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout | Tree | Private 2 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.7416050219872 | -122.437232403771 | (37.7416050219872, -122.437232403771) | 2 | 7 | 5 | 63 | 7 | |||
100356 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
110541 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
130286 | 253951 | Significant Tree 6 | Tree(s) :: 17 | 431 Yerba Buena Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780852 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | |
154007 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 101 LUNDYS LN | 1 | Front Yard : Cutout | Tree | Private 2 | 18 | 6006875 | 2098969 | 37.7437578546964 | -122.418879543436 | (37.7437578546964, -122.418879543436) | 2 | 7 | 7 | 28859 | 2 | ||||
156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
3798 | 262575 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Topaz Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001722 | 2097902 | 37.7405366227001 | -122.436621002014 | (37.7405366227001, -122.436621002014) | 2 | 7 | 5 | 63 | 7 | |||||
4207 | 247626 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009494.96271 | 2096975.40444 | 37.7384310509429 | -122.409679612625 | (37.7384310509429, -122.409679612625) | 10 | 7 | 7 | 28859 | 2 | ||||
4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
5702 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
6178 | 247627 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6009494.82009 | 2096968.41626 | 37.7384118549208 | -122.409679612627 | (37.7384118549208, -122.409679612627) | 10 | 7 | 7 | 28859 | 2 | ||||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
7310 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 185 Chilton Ave | Front Yard : Yard | Tree | Private 2 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
8454 | 247630 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6009492.89578 | 2096949.07994 | 37.7383586537362 | -122.409684901541 | (37.7383586537362, -122.409684901541) | 10 | 7 | 7 | 28859 | 2 | ||||
9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
10162 | 230434 | Significant Tree 6 | Magnolia x soulangiana :: Saucer Magnolia 147 | 272 Anderson St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6007874.82314 | 2097362.07469 | 37.7394018403099 | -122.415308650074 | (37.7394018403099, -122.415308650074) | 2 | 7 | 7 | 28859 | 2 | |||
10910 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
12344 | 247628 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6009493.85882 | 2096962.27736 | 37.7383949449624 | -122.409682503062 | (37.7383949449624, -122.409682503062) | 10 | 7 | 7 | 28859 | 2 | ||||
15224 | 264691 | Significant Tree 6 | Leucodendron argenteum :: Silver Tree 46 | 1560 Plymouth Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5995798 | 2094356 | 37.730461740667 | -122.45684736471 | (37.730461740667, -122.45684736471) | 9 | 7 | 4 | 28861 | 40 | ||||
16054 | 247629 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | 6009493.3855 | 2096955.46231 | 37.7383762057861 | -122.409683658684 | (37.7383762057861, -122.409683658684) | 10 | 7 | 7 | 28859 | 2 | ||||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
22846 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
23740 | 255978 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
23771 | 105863 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
24668 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 203 Surrey St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768282 | 6002070 | 2096079.6 | 37.7355525046422 | -122.435287431957 | (37.7355525046422, -122.435287431957) | 2 | 7 | 5 | 63 | 7 | ||||
27545 | 115090 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 1 | Front Yard : Yard | Tree | Private 2 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050 | 37.7409500647868 | -122.436201464472 | (37.7409500647868, -122.436201464472) | 2 | 7 | 5 | 63 | 7 | |||
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
30833 | 258289 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
32555 | 121168 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
34790 | 105768 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 98X GOLD MINE DR | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6001350 | 2099153 | 37.7439504273559 | -122.437996817375 | (37.7439504273559, -122.437996817375) | 2 | 7 | 5 | 63 | 22 | ||||
35675 | 105864 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );