Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 561 | 561 | 204410 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 450x Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992920.0 | 2104601.0 | 37.7584262276473 | -122.46754168203998 | (37.7584262276473, -122.46754168204) | |||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 566 | 566 | 243384 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 88 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 3x3 | 6010512.94245 | 2100000.19671 | 37.746793468955204 | -122.406372986245 | (37.7467934689552, -122.406372986245) | ||
| 567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 569 | 569 | 194126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 572 | 572 | 194125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 573 | 573 | 194127 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 574 | 574 | 194128 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 575 | 575 | 194123 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 587 | 587 | 233050 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3181 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2011 12:00:00 AM | 3 | Width 3ft | 6007759.16475 | 2102654.84325 | 37.7539280965303 | -122.416083280221 | (37.7539280965303, -122.416083280221) | ||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 594 | 594 | 140071 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 606 | 606 | 233049 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3181 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2011 12:00:00 AM | 3 | Width 3ft | 6007718.49924 | 2102654.70617 | 37.753925433618704 | -122.416223901805 | (37.7539254336187, -122.416223901805) | ||
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 611 | 611 | 140070 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 619 | 619 | 244248 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 02:55:00 PM | 3 | Width 0ft | 6005671.5367 | 2110041.0199 | 37.7740911903854 | -122.42382796196699 | (37.7740911903854, -122.423827961967) | ||
| 620 | 620 | 244252 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 03:09:00 PM | 3 | Width 0ft | 6005662.3712 | 2110108.233 | 37.7742752238868 | -122.423864447369 | (37.7742752238868, -122.423864447369) | ||
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 636 | 636 | 244251 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 03:04:00 PM | 3 | Width 0ft | 6005664.6626 | 2110090.6659 | 37.7742271182357 | -122.423855271591 | (37.7742271182357, -122.423855271591) | ||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 648 | 648 | 244249 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 03:00:00 PM | 3 | Width 0ft | 6005669.2453 | 2110057.8231 | 37.774137198555 | -122.423837083382 | (37.774137198555, -122.423837083382) | ||
| 651 | 651 | 251359 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4050 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994421.0 | 2112898.0 | 37.7812941506761 | -122.462952553035 | (37.7812941506761, -122.462952553035) | ||||
| 653 | 653 | 144739 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | |||
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 658 | 658 | 147406 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 515 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 6x10 | 5989054.53583 | 2111789.60329 | 37.7779402316839 | -122.48143647103201 | (37.7779402316839, -122.481436471032) | |||
| 659 | 659 | 244390 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:00:00 PM | 3 | Width 0ft | 6005651.6782 | 2110185.3753 | 37.774486434317105 | -122.423906923072 | (37.7744864343171, -122.423906923072) | ||
| 660 | 660 | 244391 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:16:00 PM | 3 | Width 0ft | 6005650.1507 | 2110201.4148 | 37.774530388668 | -122.42391334778499 | (37.774530388668, -122.423913347785) | ||
| 664 | 664 | 244393 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:35:00 PM | 3 | Width 0ft | 6005645.568 | 2110235.0213 | 37.774622405266 | -122.423931590501 | (37.774622405266, -122.423931590501) | ||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 668 | 668 | 244392 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:27:00 PM | 3 | Width 0ft | 6005647.8593 | 2110218.2181 | 37.774576397101995 | -122.42392246931401 | (37.774576397102, -122.423922469314) | ||
| 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) | ||||
| 694 | 694 | 120738 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700x 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 4ft | 5989768.19982 | 2110516.41697 | 37.7744858825371 | -122.478874537994 | (37.7744858825371, -122.478874537994) | ||
| 697 | 697 | 251362 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1300X Stanyan St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | ||||
| 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) | ||||
| 752 | 752 | 251380 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 780 | 780 | 251383 | Undocumented 2 | Persea americana :: Avocado 113 | 49x Milan Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997587.0 | 2087495.0 | 37.711725600519706 | -122.450168218052 | (37.7117256005197, -122.450168218052) | ||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 783 | 783 | 251381 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 795 | 795 | 140241 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 160 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998775.6798 | 2110202.3294 | 37.7741424035345 | -122.44769344620701 | (37.7741424035345, -122.447693446207) | |||
| 810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 825 | 825 | 244349 | Undocumented 2 | Shrub :: Shrub 98 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.77508393621179 | -122.424033097665 | (37.7750839362118, -122.424033097665) | ||
| 834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 857 | 857 | 240430 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2637 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 3ft | 6010665.07202 | 2102243.00786 | 37.752960245237105 | -122.406004908126 | (37.7529602452371, -122.406004908126) | ||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 860 | 860 | 189218 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 72 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6016946.50299 | 2094945.8896700002 | 37.7332731602285 | -122.38377428587299 | (37.7332731602285, -122.383774285873) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 895 | 895 | 209148 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5995023.415709999 | 2107016.68952 | 37.7651803042563 | -122.46044222322901 | (37.7651803042563, -122.460442223229) | |||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 900 | 900 | 140947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 902 | 902 | 140944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 904 | 904 | 140946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 907 | 907 | 140952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 912 | 912 | 137817 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004275.6077 | 2115310.8412 | 37.7884819087987 | -122.429032528237 | (37.7884819087987, -122.429032528237) | |||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 915 | 915 | 140945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 918 | 918 | 206336 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993226.58531 | 2103261.3034200002 | 37.7547654642635 | -122.46638401611 | (37.7547654642635, -122.46638401611) | |||
| 919 | 919 | 140949 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2060 Ofarrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 920 | 920 | 206335 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5993241.59075 | 2103263.0584299997 | 37.7547711488889 | -122.466332251156 | (37.7547711488889, -122.466332251156) | |||
| 922 | 922 | 140943 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 923 | 923 | 210740 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992981.0390099995 | 2088189.5314 | 37.7133679617255 | -122.46613798048901 | (37.7133679617255, -122.466137980489) | |||
| 924 | 924 | 214223 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999983.92895 | 2095213.9818900002 | 37.7330570333525 | -122.44243762501199 | (37.7330570333525, -122.442437625012) | |||
| 925 | 925 | 139814 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1652 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002517.0 | 2112708.0 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | |||
| 927 | 927 | 140951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 929 | 929 | 140950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 930 | 930 | 206338 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5993167.1259699995 | 2103261.31068 | 37.7547620531391 | -122.466589641618 | (37.7547620531391, -122.466589641618) | |||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 938 | 938 | 251414 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 947 | 947 | 251413 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 955 | 955 | 251402 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 190 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007981.0 | 2093052.0 | 37.7275732783897 | -122.41463660892599 | (37.7275732783897, -122.414636608926) | ||||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 967 | 967 | 251416 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | ||||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 971 | 971 | 251415 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 1000 | 1000 | 133103 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006658.0 | 2119469.0 | 37.8000337406718 | -122.42108517312599 | (37.8000337406718, -122.421085173126) | |||
| 1002 | 1002 | 221998 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 171 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | 6005231.98236 | 2103978.9256700003 | 37.7574213016572 | -122.42491707607999 | (37.7574213016572, -122.42491707608) | ||
| 1006 | 1006 | 232567 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 947 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6000330.76798 | 2101953.15424 | 37.751580964011204 | -122.441721996685 | (37.7515809640112, -122.441721996685) |
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");