trees

336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by qAddress 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)
159697 226945 Significant Tree 6 Juniperus chinensis :: Juniper 113 998 Chenery St 4 Sidewalk: Property side : Yard Tree Private 2     21 Width 1ft   6001140.61217 2096125.61153 37.7356260187109 -122.438503967885 (37.7356260187109, -122.438503967885) 2 7 5 63 7
63551 121177 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
150739 121178 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
188209 121179 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
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
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
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
87873 121174 Significant Tree 6 Tree(s) :: 17 950 Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
111801 121175 Significant Tree 6 Tree(s) :: 17 950 Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
135671 121172 Significant Tree 6 Tree(s) :: 17 950 Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
185684 121176 Significant Tree 6 Tree(s) :: 17 950 Duncan St 5 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
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
48955 255537 Significant Tree 6 Melaleuca linariifolia :: Flaxleaf Paperbark 103 93X Monterey Blvd 1 Side Yard : Cutout Tree Private 2       10x10   6001470 2094575 37.7313871286154 -122.437254157834 (37.7313871286154, -122.437254157834) 9 7 4 63 40
139989 100474 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 2 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
189375 100473 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 1 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 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
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
95045 121170 Significant Tree 6 Tree(s) :: 17 900x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
125742 121169 Significant Tree 6 Acacia spp :: Acacia Spp 105 900x Duncan St 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
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
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
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
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
68299 99852 Significant Tree 6 Juniperus chinensis :: Juniper 113 86 Nordhoff St 1 Front Yard : Yard Tree Private 2           6000395 2095652 37.7342831509698 -122.441047861045 (37.7342831509698, -122.441047861045) 9 7 5 63 40
80243 255324 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 852 Chenery St 2 Front Yard : Yard Tree Private 2       3X3   6001755.94767 2095865.71194 37.7349473777015 -122.436357925586 (37.7349473777015, -122.436357925586) 2 7 5 63 7
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
108320 104865 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 80 Stoneman St 1 Front Yard : Yard Tree Private 2         Permit Number 770375 6007947.7 2099422 37.7450620347132 -122.415202450973 (37.7450620347132, -122.415202450973) 2 7 7 28859 2
48619 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 78 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
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
39767 254934 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
56399 254401 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779678 5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
168489 254935 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
177584 234000 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 749 27th St 2 Front Yard : Yard Tree Private 2     10 Width 10ft   6001659.60779 2099970.43439 37.7462125114091 -122.436984776447 (37.7462125114091, -122.436984776447) 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
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
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
47483 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 1 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
110581 113359 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 2 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
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
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
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
144689 253283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 673 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005929 2099335 37.7447094953859 -122.422176588207 (37.7447094953859, -122.422176588207) 2 7 5 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
100702 109040 Significant Tree 6 Juniperus chinensis :: Juniper 113 654 Precita Ave   Front Yard : Yard Tree Private 2     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152) 2 7 7 28859 2
194262 262537 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 65 Ocean Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
194276 262536 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 65 Ocean Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
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
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
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
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
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
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
27222 258201 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
33311 258200 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
163996 258199 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
51024 105872 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 595X San Jose Ave 6 Front Yard : Yard Tree Private 2           6006124.47156 2100100.14306 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
116509 98545 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 1 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
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
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
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
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
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
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
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
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
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
168346 251480 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010641 2100362 37.7477940646116 -122.405955656592 (37.7477940646116, -122.405955656592) 2 7 7 28859 2
34770 251426 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
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
30295 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
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
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
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
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
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
39321 120597 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
80257 122411 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
92548 122410 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25

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