trees

172 rows where Zip Codes = 63 and qLegalStatus_id = 6 sorted by Neighborhoods (old)

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 63 · 172 ✖
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) ▼
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
51304 255705 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 1 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
55746 98694 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 1 Back Yard : Yard Tree Private 2   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.7543910951738 -122.455633951336 (37.7543910951738, -122.455633951336) 1 5 4 63 12
58512 253898 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 2 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 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
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
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
122782 255708 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 2 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
153493 256541 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Warren Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995584 2102944 37.754029973308 -122.458208518647 (37.754029973308, -122.458208518647) 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
168009 254385 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 178X Warren Dr 1 Side Yard : Yard Tree Private 2       3x3   5995100 2102878 37.7538209308694 -122.459877514706 (37.7538209308694, -122.459877514706) 1 5 4 63 12
172767 98696 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 3 Back Yard : Yard Tree Private 2   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.7543910951738 -122.455633951336 (37.7543910951738, -122.455633951336) 1 5 4 63 12
175269 98695 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 2 Back Yard : Yard Tree Private 2   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.7543910951738 -122.455633951336 (37.7543910951738, -122.455633951336) 1 5 4 63 12
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
183899 253897 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 1 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 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
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
86615 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5159 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000808 2099903 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335) 2 4 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
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
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
91521 255902 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3943 Cesar Chavez St 1 Front Yard : Yard Tree Private 2           6004266 2100418 37.7475892225894 -122.428004081153 (37.7475892225894, -122.428004081153) 2 4 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
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
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 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
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
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
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
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
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
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
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
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
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
128772 258286 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 3 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
134246 258292 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 9 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 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
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
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
145770 258288 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 5 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
147696 258285 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 2 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
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
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
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
159425 258291 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 8 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 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
8580 261010 Significant Tree 6 Tree(s) :: 17 91 Parkridge Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 3x3 Permit Number 784979 5998980 2102204 37.7521926688144 -122.446411148664 (37.7521926688144, -122.446411148664) 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
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
18868 260249 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 10 Crestline Dr 1 Median : Yard Tree Private 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
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
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38

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