Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 184172 | 184172 | 178271 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6009176.170940001 | 2086260.2904299998 | 37.7089917311415 | -122.41002561149901 | (37.7089917311415, -122.410025611499) | |||
| 176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
| 168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
| 66895 | 66895 | 176112 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Tomaso Ct | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009187.4096 | 2086275.4475900002 | 37.7090339795175 | -122.409987838189 | (37.7090339795175, -122.409987838189) | |||
| 164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 115840 | 115840 | 176282 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6009202.48899 | 2086331.0577900002 | 37.709187518951296 | -122.40993964441401 | (37.7091875189513, -122.409939644414) | |||
| 77276 | 77276 | 176283 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6009206.42472 | 2086339.2337599997 | 37.7092101890802 | -122.40992661863999 | (37.7092101890802, -122.40992661864) | |||
| 176020 | 176020 | 178272 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.709289534449894 | -122.409886240875 | (37.7092895344499, -122.409886240875) | |||
| 48879 | 48879 | 177820 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009221.96633 | 2086380.57337 | 37.7093245702546 | -122.409875820418 | (37.7093245702546, -122.409875820418) | |||
| 119320 | 119320 | 177821 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009239.86768 | 2086426.74333 | 37.7094523468075 | -122.40981720709101 | (37.7094523468075, -122.409817207091) | |||
| 45261 | 45261 | 177822 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 3ft | 6009243.51838 | 2086439.4286099998 | 37.7094873825954 | -122.40980548443899 | (37.7094873825954, -122.409805484439) | |||
| 35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
| 80765 | 80765 | 121082 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 24X KEMPTON AVE | 6 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 112585 | 112585 | 117548 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 2 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 121639 | 121639 | 117546 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 126638 | 126638 | 117550 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 4 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 120316 | 120316 | 121151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1X Payson St | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 25 | 3x3 | 5992041.0 | 2087761.0 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | |||
| 3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
| 162601 | 162601 | 178307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 623 Brotherhood Way | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 5990951.00825 | 2088079.7183700001 | 37.712949111472604 | -122.473146401692 | (37.7129491114726, -122.473146401692) | |||
| 179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 165261 | 165261 | 179181 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 287 Hester Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6012224.031 | 2087775.33367 | 37.7133220954184 | -122.399597997574 | (37.7133220954184, -122.399597997574) | ||||
| 59767 | 59767 | 179661 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6012216.37842 | 2087780.43205 | 37.7133356679799 | -122.399624805455 | (37.7133356679799, -122.399624805455) | ||||
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 169682 | 169682 | 179659 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012208.68796 | 2087783.6774 | 37.7133441503725 | -122.39965161424801 | (37.7133441503725, -122.399651614248) | ||||
| 130601 | 130601 | 179660 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012212.84494 | 2087789.77212 | 37.7133611169841 | -122.399637673848 | (37.7133611169841, -122.399637673848) | ||||
| 178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
| 73968 | 73968 | 187552 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2 Beeman Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6012028.620569999 | 2088183.9402700001 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | ||||
| 47213 | 47213 | 180192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Campbell Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6011017.70209 | 2088215.1538900002 | 37.714462435764105 | -122.40379844036 | (37.7144624357641, -122.40379844036) | ||||
| 154492 | 154492 | 175325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Campbell Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6011011.17717 | 2088216.37371 | 37.714465420623796 | -122.403821078997 | (37.7144654206238, -122.403821078997) | ||||
| 155381 | 155381 | 187544 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400 Somerset St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011380.55027 | 2088229.60878 | 37.714522389959996 | -122.40254530072201 | (37.71452238996, -122.402545300722) | ||||
| 173566 | 173566 | 187579 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 299 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6008885.34324 | 2088289.2599799999 | 37.7145465601547 | -122.411173984595 | (37.7145465601547, -122.411173984595) | ||||
| 24680 | 24680 | 187543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6011384.82868 | 2088240.1087599997 | 37.714551459646394 | -122.402531250636 | (37.7145514596464, -122.402531250636) | ||||
| 67813 | 67813 | 187548 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1398 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6011346.78154 | 2088306.58257 | 37.7147318591505 | -122.402667429564 | (37.7147318591505, -122.402667429564) | ||||
| 150170 | 150170 | 187558 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3959 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011340.42145 | 2088314.93577 | 37.7147544402534 | -122.40268999986799 | (37.7147544402534, -122.402689999868) | ||||
| 147897 | 147897 | 187545 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1399 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011375.77756 | 2088317.82522 | 37.714764348070204 | -122.40256799691002 | (37.7147643480702, -122.40256799691) | ||||
| 164724 | 164724 | 187547 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1398 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6011342.64618 | 2088318.4988900002 | 37.71476434807511 | -122.402682560663 | (37.7147643480751, -122.402682560663) | ||||
| 169579 | 169579 | 187557 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3959 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6011334.94928 | 2088323.74418 | 37.71477832084229 | -122.40270953314301 | (37.7147783208423, -122.402709533143) | ||||
| 45475 | 45475 | 187553 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3960 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011370.897059999 | 2088323.0132400002 | 37.7147783208511 | -122.40258523064199 | (37.7147783208511, -122.402585230642) | ||||
| 162415 | 162415 | 187555 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3960 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011363.78669 | 2088352.3188099999 | 37.714858391064 | -122.40261186676202 | (37.714858391064, -122.402611866762) | ||||
| 166465 | 166465 | 187554 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3960 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011368.52295 | 2088357.8500700002 | 37.71487384321561 | -122.40259588490801 | (37.7148738432156, -122.402595884908) | ||||
| 188399 | 188399 | 187546 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1399 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6011366.67431 | 2088362.22575 | 37.7148857547405 | -122.402602582141 | (37.7148857547405, -122.402602582141) | ||||
| 68864 | 68864 | 187556 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3960 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.40260653916599 | (37.7148921048592, -122.402606539166) | ||||
| 133976 | 133976 | 187580 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 297 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6008925.29742 | 2088423.47753 | 37.7149173344326 | -122.411045360877 | (37.7149173344326, -122.411045360877) | ||||
| 32469 | 32469 | 187581 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 297 Elliot St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008926.43225 | 2088428.3515400002 | 37.7149307810954 | -122.411041782475 | (37.7149307810954, -122.411041782475) | ||||
| 185900 | 185900 | 201701 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 6015213.19192 | 2088555.8526400002 | 37.71563141862261 | -122.389320803321 | (37.7156314186226, -122.389320803321) | |||
| 154668 | 154668 | 201702 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | Width 0ft | 6015209.27922 | 2088565.69519 | 37.7156582274311 | -122.38933501442 | (37.7156582274311, -122.38933501442) | |||
| 133827 | 133827 | 201703 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 39 | Width 0ft | 6015230.77883 | 2088581.00853 | 37.7157014668276 | -122.389261770026 | (37.7157014668276, -122.389261770026) | |||
| 70105 | 70105 | 201705 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6015223.65534 | 2088604.14368 | 37.7157645965377 | -122.389288006849 | (37.7157645965377, -122.389288006849) | |||
| 70199 | 70199 | 201706 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6015220.50019 | 2088604.5221400002 | 37.7157654607945 | -122.38929893900601 | (37.7157654607945, -122.389298939006) | |||
| 77137 | 77137 | 201707 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6015219.60254 | 2088607.0599200001 | 37.7157723792799 | -122.389302218834 | (37.7157723792799, -122.389302218834) | |||
| 41940 | 41940 | 201704 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | Width 0ft | 6015220.38125 | 2088614.2880799999 | 37.7157922695756 | -122.389300031678 | (37.7157922695756, -122.389300031678) | |||
| 46759 | 46759 | 187578 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 211 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6009088.83114 | 2088896.1901099999 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | ||||
| 28120 | 28120 | 178856 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 121 Delta St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009824.00265 | 2088991.8165400003 | 37.71652823335621 | -122.407979098955 | (37.7165282333562, -122.407979098955) | ||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 67603 | 67603 | 181293 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 184 Mount Vernon Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 5998992.1360599995 | 2089349.9308099998 | 37.7168991290824 | -122.44544499658998 | (37.7168991290824, -122.44544499659) | ||||
| 164168 | 164168 | 177470 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | ||||
| 179229 | 179229 | 177471 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.44547622197399 | (37.7169201246297, -122.445476221974) | ||||
| 178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
| 180895 | 180895 | 176096 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998966.43073 | 2089373.6298 | 37.7169627336137 | -122.445535550248 | (37.7169627336137, -122.445535550248) | ||||
| 65775 | 65775 | 176097 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998962.663240001 | 2089377.08137 | 37.716971995749795 | -122.445548820645 | (37.7169719957498, -122.445548820645) | ||||
| 184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
| 174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
| 35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
| 59717 | 59717 | 178076 | Undocumented 2 | Persea americana :: Avocado 113 | 184 Mount Vernon Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998937.21643 | 2089402.34913 | 37.7170399224441 | -122.44563859365401 | (37.7170399224441, -122.445638593654) | ||||
| 48369 | 48369 | 179631 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 184 Mount Vernon Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998932.987869999 | 2089405.3609099998 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | ||||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 60035 | 60035 | 187570 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010859.73078 | 2089462.03095 | 37.7178772802949 | -122.404432169207 | (37.7178772802949, -122.404432169207) | ||||
| 29820 | 29820 | 187571 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010860.52073 | 2089475.11103 | 37.7179132396708 | -122.40443035886899 | (37.7179132396708, -122.404430358869) | ||||
| 146973 | 146973 | 187576 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010826.85106 | 2089479.8583099998 | 37.7179243930824 | -122.40454707471301 | (37.7179243930824, -122.404547074713) | ||||
| 172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
| 29739 | 29739 | 187574 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010842.8913900005 | 2089488.5588 | 37.71794917929 | -122.404492242147 | (37.71794917929, -122.404492242147) | ||||
| 36978 | 36978 | 187575 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010832.96557 | 2089490.7918200002 | 37.7179547559905 | -122.40452670863998 | (37.7179547559905, -122.40452670864) | ||||
| 162264 | 162264 | 187573 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010858.37792 | 2089492.3055900002 | 37.717960332674295 | -122.404438975305 | (37.7179603326743, -122.404438975305) | ||||
| 136128 | 136128 | 218153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Ashton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5994153.71185 | 2090014.1877400002 | 37.7184456203604 | -122.46221709555 | (37.7184456203604, -122.46221709555) | ||||
| 39341 | 39341 | 218152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 22 Ashton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5994167.21256 | 2090073.13732 | 37.71860825915 | -122.46217470241601 | (37.71860825915, -122.462174702416) | ||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 72602 | 72602 | 187584 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 747 University St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6008737.4209199995 | 2090741.8815799998 | 37.721272650900396 | -122.411858473006 | (37.7212726509004, -122.411858473006) | ||||
| 152372 | 152372 | 187583 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 University St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008740.19071 | 2090749.62669 | 37.721294072735795 | -122.411849445609 | (37.7212940727358, -122.411849445609) | ||||
| 176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 48330 | 48330 | 178340 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 72 La Grande Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005229.68605 | 2091771.5142599999 | 37.7239023836832 | -122.424056914098 | (37.7239023836832, -122.424056914098) | ||||
| 173385 | 173385 | 175810 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | ||||
| 116919 | 116919 | 175809 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6005230.95207 | 2091785.5880000002 | 37.7239410985769 | -122.424053538037 | (37.7239410985769, -122.424053538037) | ||||
| 53626 | 53626 | 175808 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6005234.38829 | 2091786.48978 | 37.7239437686747 | -122.42404172366001 | (37.7239437686747, -122.42404172366) | ||||
| 179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
| 53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
| 181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) | ||||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 123296 | 123296 | 177517 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 654 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6005174.05368 | 2092521.73439 | 37.7259591826438 | -122.424302559431 | (37.7259591826438, -122.424302559431) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");