trees

336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by PlantDate descending

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
169778 255656 Significant Tree 6 Tree(s) :: 17 5827 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2   12/28/2018 12:00:00 AM 3 12x12 Permit Number 781981 6000844 2096795 37.7374471263095 -122.439577439508 (37.7374471263095, -122.439577439508) 2 7 5 63 7
109570 114194 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/23/2015 12:00:00 AM 30 3x3 Permit Number 777057 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
86813 104872 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1753 Noe St 1 Hanging basket : Yard Tree Private 2   11/22/2013 12:00:00 AM     Permit Number 770054 6003434.1 2098036.1 37.7410019772539 -122.430710793678 (37.7410019772539, -122.430710793678) 2 7 5 63 7
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
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
98953 114193 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 1 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
17239 32497 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 665 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.30694 2095863.10154 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676) 2 7 7 28859 2
87807 113732 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 9 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185143 113737 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 14 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185504 113729 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 6 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
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
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
151159 107322 Significant Tree 6 Tree(s) :: 17 68 ROSENKRANZ ST 1 Front Yard : Yard Tree Private 2   09/29/2014 12:00:00 AM 3   Permit Number 773942 6009212 2098349 37.7421867844178 -122.410754944355 (37.7421867844178, -122.410754944355) 10 7 7 28859 2
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
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
119122 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Sussex St 1 Sidewalk: Curb side : Yard Tree Private 2   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194 2096647 37.7370606668352 -122.438356728037 (37.7370606668352, -122.438356728037) 2 7 5 63 7
134585 24480 Significant Tree 6 Salix babylonica :: Weeping Willow 308 108X Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351 -122.434899824187 (37.737282128351, -122.434899824187) 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
190141 100043 Significant Tree 6 Tree(s) :: 17 50 Bronte St 1 Front Yard : Yard Tree Private 2   07/12/2012 12:00:00 AM     Permit Number 769001 6009337 2097155 37.7389153282678 -122.410238449764 (37.7389153282678, -122.410238449764) 10 7 7 28859 2
59436 117588 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 261 Ripley St 1 Front Yard : Yard Tree Private 2   06/27/2016 12:00:00 AM 3   Permit Number 778127 6009622.3 2099176 37.7444805424074 -122.409394598776 (37.7444805424074, -122.409394598776) 2 7 7 28859 2
103941 57910 Significant Tree 6 Tree(s) :: 17 446 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1977 12:00:00 AM     Permit Number 16868 6003019.35193275 2099229.53580249 37.7442553690473 -122.432230049776 (37.7442553690473, -122.432230049776) 2 7 5 63 22
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
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
191007 96222 Significant Tree 6 Tree(s) :: 17 176 Holladay Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/18/2011 12:00:00 AM 18 3x3 Permit Number 767739 6010842.9 2100101.6 37.7470903528282 -122.405239158587 (37.7470903528282, -122.405239158587) 2 7 7 28859 2
57424 101476 Significant Tree 6 :: 45 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
55458 255165 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 371 Prospect Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 781717 6006352.58239 2097791.19314 37.7404944317648 -122.420602351048 (37.7404944317648, -122.420602351048) 2 7 7 28859 2
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
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
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
77320 116457 Significant Tree 6 Tree(s) :: 17 412 Nevada St 1 Front Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3   Permit Number 777591 6008890.4 2096365.2 37.736721665261 -122.41172680033 (37.736721665261, -122.41172680033) 10 7 7 28859 2
157806 95777 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 30 Onondaga Ave   Front Yard : Yard Tree Private 2   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.7218615356817 -122.437972107548 (37.7218615356817, -122.437972107548) 9 7 6 28861 25
182728 102583 Significant Tree 6 Tree(s) :: 17 22 Gennessee St 1 Front Yard : Yard Tree Private 2   02/27/2013 12:00:00 AM     Permit Number 769949 5997479.4 2093692.8 37.7287371564084 -122.450986747444 (37.7287371564084, -122.450986747444) 9 7 4 28861 40
62334 87240 Significant Tree 6 Tree(s) :: 17 233 Arbor St 2 Sidewalk: Curb side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
71176 87239 Significant Tree 6 Tree(s) :: 17 233 Arbor St 1 Sidewalk: Property side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
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
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
108135 108305 Significant Tree 6 Tree(s) :: 17 360 GAMBIER ST 1 Front Yard : Yard Tree Private 2   02/06/2015 12:00:00 AM 3   Permit Number 774454 6006059.9 2092154.5 37.725000818071 -122.421214176486 (37.725000818071, -122.421214176486) 9 7 7 309 5
64560 87191 Significant Tree 6 Tree(s) :: 17 640 Miramar Ave 1 Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50212 5995439 2093622 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987) 9 7 4 28861 40
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
143852 98290 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 6 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
165161 98288 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
129559 98274 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 766 Anderson St   Front Yard : Yard Tree Private 2   01/23/2012 12:00:00 AM 18   Permit Number 768445 6007723 2095324 37.7337971999422 -122.415689321062 (37.7337971999422, -122.415689321062) 2 7 7 28859 2
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
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
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
166995 115091 Significant Tree 6 Tree(s) :: 17 121 Topaz Way 2 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
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
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
551 234021 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 147 Nevada St 1 Sidewalk: Curb side : Pot Tree Private 2     13 Width 3ft   6009064.54563 2097789.74594 37.7406429263284 -122.411225300822 (37.7406429263284, -122.411225300822) 10 7 7 28859 2
1377 262327 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1679 262328 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
2175 121189 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
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
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
3385 223764 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6009530.67949 2097860.55808 37.7408634922583 -122.409618578359 (37.7408634922583, -122.409618578359) 10 7 7 28859 2
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
3842 109772 Significant Tree 6 Yucca elephantipes :: Giant Yucca 268 2200x SAN JOSE AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
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
4813 223765 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6009530.59471 2097856.4038 37.7408520807582 -122.409618578357 (37.7408520807582, -122.409618578357) 10 7 7 28859 2
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
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
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
7288 264692 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1500 Plymouth Ave 1 Side Yard : Yard Tree Private 2       10x10   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
7631 256540 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
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
7930 223763 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6009530.79254 2097866.09723 37.7408787078943 -122.409618578334 (37.7408787078943, -122.409618578334) 10 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
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
8751 262427 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
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
10088 253978 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       3x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
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
11014 262425 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11129 236516 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 63 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6009359.84862 2097078.24448 37.7387058549889 -122.410154031979 (37.7387058549889, -122.410154031979) 10 7 7 28859 2
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
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
12676 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
13663 258677 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 607 Congo St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   6000094 2095817 37.7347190533418 -122.442100351643 (37.7347190533418, -122.442100351643) 9 7 4 63 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
14497 251425 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
14780 262330 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
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
15717 221238 Significant Tree 6 Betula pendula :: European White Birch 253 55 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 3ft   6009363.02974 2097125.97708 37.7388370966643 -122.41014640214 (37.7388370966643, -122.41014640214) 10 7 7 28859 2
15980 262426 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
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
16372 96327 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
16429 262110 Significant Tree 6 Phoenix dactylifera :: Date Palm 87 25 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002200 2092574 37.7259343081174 -122.434587389509 (37.7259343081174, -122.434587389509) 9 7 6 28861 25
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
18601 262329 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18860 229626 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3658 Folsom St 1 Side Yard : Cutout Tree Private 2     10 Width 3ft   6008459.0571 2097864.523 37.7408142714666 -122.413324142211 (37.7408142714666, -122.413324142211) 2 7 7 28859 2
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
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
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

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