trees

172 rows where Zip Codes = 63 and qLegalStatus_id = 6 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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)
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
80551 100195 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 3 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
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
2352 101748 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700X Panorama Dr 1 Back Yard : Yard Tree Private 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
159982 102589 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5157 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415) 2 4 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
1790 103256 Significant Tree 6 Maytenus boaria :: Mayten 58 4187 26th St 1 Front Yard : Yard Tree Private 2     16 3x3   6002700 2100625 37.7480688746475 -122.433434000346 (37.7480688746475, -122.433434000346) 2 4 5 63 22
117472 103478 Significant Tree 6 Aesculus californica :: California Buckeye 168 50 Gardenside Dr 1 Front Yard : Yard Tree Private 2         Permit Number 770287 5999492 2102892 37.7541109784186 -122.444690026478 (37.7541109784186, -122.444690026478) 2 5 5 63 38
17429 103965 Significant Tree 6 Tree(s) :: 17 141 Marview Way 1 Front Yard : Yard Tree Private 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
178069 104027 Significant Tree 6 Pinus radiata :: Monterey Pine 15 520X Oak Park Dr 1 Back Yard : Yard Tree Private 2   07/25/2013 12:00:00 AM     Permit Number 770238 5995008.5 2103700.7 37.7560745928775 -122.460253542676 (37.7560745928775, -122.460253542676) 1 5 4 63 12
158256 104037 Significant Tree 6 Tree(s) :: 17 520X Oak Park Dr 2 Front Yard : Yard Tree Private 2           5995008.5 2103700.7 37.7560745928775 -122.460253542676 (37.7560745928775, -122.460253542676) 1 5 4 63 12
49109 104146 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1710-1738 Diamond St 1 Front Yard : Yard Tree Private 2     40     6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
168357 104148 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 2 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
116917 104149 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 3 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
142943 104150 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 4 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
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
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
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
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
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
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
89812 107834 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
170160 107835 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
178584 108144 Significant Tree 6 Pinus radiata :: Monterey Pine 15 140x TOPAZ WAY 2 Front Yard : Yard Tree Private 2     30   Permit Number 775551 6001767 2098265 37.7415358930081 -122.436491384585 (37.7415358930081, -122.436491384585) 2 7 5 63 7
132961 108177 Significant Tree 6 Pinus radiata :: Monterey Pine 15 201 PANORAMA DR 1 Front Yard : Yard Tree Private 2     22 3x3   5997273.1 2100946.6 37.7486425219839 -122.452223122411 (37.7486425219839, -122.452223122411) 1 5 4 63 38
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
149707 108978 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 MIGUEL ST 1 Front Yard : Yard Tree Private 2     44     6003334.2 2097391.9 37.7392274919289 -122.431010244874 (37.7392274919289, -122.431010244874) 2 7 5 63 7
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
170923 109294 Significant Tree 6 Ficus nitida :: Laurel Fig 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 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
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
59778 112374 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1247 Bosworth St 1 Front Yard : Yard Tree Private 2       20x20 Permit Number 775819 6000424.11007 2096055.79143 37.7353935258967 -122.440976176652 (37.7353935258967, -122.440976176652) 9 7 4 63 40
69856 112572 Significant Tree 6 Cordyline australis :: Dracena Palm 64 162 GRAND VIEW AVE 4 Front Yard : Cutout Tree Private 2       3x3   6000754 2103380 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392) 2 4 5 63 38
42888 113973 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 11 Hiliritas Ave 1 Front Yard : Yard Tree Private 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 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
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
111867 115459 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 1 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
179476 115460 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 2 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
70573 116500 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 1 Median : Yard Tree Private 2     45 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
39106 116501 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 2 Median : Yard Tree Private 2     40 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
107819 116502 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 3 Median : Yard Tree Private 2     28 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
87199 116862 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 1 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
86997 116863 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 2 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
58933 116864 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 3 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
178948 117208 Significant Tree 6 Pinus radiata :: Monterey Pine 15 25 MIDCREST WAY 1 Front Yard : Cutout Tree Private 2     20     5997992 2100464 37.7473585772285 -122.44970241305 (37.7473585772285, -122.44970241305) 1 5 4 63 38
190157 117273 Significant Tree 6 Pinus radiata :: Monterey Pine 15 17 PEREGO TER 1 Back Yard : Yard Tree Private 2           5999542 2101494 37.7502752643571 -122.444416651791 (37.7502752643571, -122.444416651791) 2 5 5 63 38
149078 117438 Significant Tree 6 Juniperus chinensis :: Juniper 113 230 AMBER DR 1 Sidewalk: Property side : Cutout Tree Private 2     25 3X3   5999593 2099199 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191) 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
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
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
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
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
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
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
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
191505 121180 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
110196 121181 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 2 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
154884 121182 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 3 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
114919 121183 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 4 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
52280 121184 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 5 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
122047 121185 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 6 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
88321 121186 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 7 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
57354 121187 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 8 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
67746 121188 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 9 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
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
42733 121190 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 11 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
67180 121191 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 12 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
113996 121192 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 13 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
88853 121193 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 14 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
41386 121194 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 255x Red Rock Way 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
116253 121195 Significant Tree 6 Myoporum laetum :: Myoporum 62 255x Red Rock Way 2 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
171448 121196 Significant Tree 6 Myoporum laetum :: Myoporum 62 255x Red Rock Way 3 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
7026 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150 Raccoon Dr 1 Back Yard : Cutout Tree Private 2     36 3x3   5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
110740 173731 Significant Tree 6 Myoporum laetum :: Myoporum 62 484 Chenery St 1 Front Yard : Yard Tree Private 2           6003566 2096120 37.7357482768139 -122.430118073632 (37.7357482768139, -122.430118073632) 2 7 5 63 7
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
50525 173933 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 190 Beacon St 1 Front Yard : Yard Tree Private 2           6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
77539 187651 Significant Tree 6 Myoporum laetum :: Myoporum 62 175 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998689 2104063 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828) 15 5 5 63 3
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
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
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
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
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
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
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
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
109594 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 2 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
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
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
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
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
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
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

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