Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 79846 | 79846 | 117347 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||||||
| 79919 | 79919 | 94871 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 Innes Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.38840048148701 | (37.7393228299093, -122.388400481487) | ||
| 79961 | 79961 | 105904 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | |||||
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 80121 | 80121 | 91624 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | |||
| 80131 | 80131 | 107758 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005605.1 | 2096623.0 | 37.7372446808015 | -122.42310384359101 | (37.7372446808015, -122.423103843591) | |||||
| 80132 | 80132 | 105261 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988914.8 | 2089258.8 | 37.716068469533205 | -122.48027037241002 | (37.7160684695332, -122.48027037241) | |||||
| 80163 | 80163 | 88235 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 329 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51224 | 6000219.0 | 2110006.0 | 37.773685716624705 | -122.44268666247 | (37.7736857166247, -122.44268666247) | |||
| 80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 80283 | 80283 | 112014 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 80300 | 80300 | 86765 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 80408 | 80408 | 86825 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1741 08th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 3x3 | Permit Number 49767 | 5993680.6 | 2103635.0 | 37.7558177255225 | -122.464841058216 | (37.7558177255225, -122.464841058216) | |||
| 80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
| 80420 | 80420 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||
| 80431 | 80431 | 106930 | Undocumented 2 | Tree(s) :: 17 | 560 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | 3X3 | Permit Number 772858 | 6001503.6522699995 | 2101489.5191200003 | 37.750374691310604 | -122.43763282240499 | (37.7503746913106, -122.437632822405) | |||
| 80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 80634 | 80634 | 89346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 80715 | 80715 | 88184 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 489 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767583 | 6010914.9 | 2111745.1 | 37.7790648045054 | -122.40581022426599 | (37.7790648045054, -122.405810224266) | ||
| 80788 | 80788 | 107855 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 80806 | 80806 | 86711 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 3714 Cesar Chavez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | 6 | Permit Number 49697 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||
| 80849 | 80849 | 97052 | Property Tree 7 | Pyrus spp :: Pear Tree 291 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 80926 | 80926 | 87297 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4227 Lincoln Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773956 | 5982573.0 | 2106897.6 | 37.764129220397294 | -122.50349567213001 | (37.7641292203973, -122.50349567213) | ||
| 80946 | 80946 | 88494 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452.0 | 2093927.0 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | |||
| 81002 | 81002 | 86871 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | ||||
| 81019 | 81019 | 112013 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 81040 | 81040 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 81073 | 81073 | 101977 | Property Tree 7 | Cedrus deodara :: Deodar Cedar 129 | 601 Grand View Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000076.2 | 2101609.9 | 37.750623962991796 | -122.44257767940901 | (37.7506239629918, -122.442577679409) | ||||||
| 81078 | 81078 | 94935 | Significant Tree 6 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig 469 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 81160 | 81160 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
| 81296 | 81296 | 91645 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.41632974036501 | (37.7523204379956, -122.416329740365) | |||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81435 | 81435 | 94362 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 507 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | 3x3 | Permit Number 53636 | 5992474.9 | 2111972.9 | 37.7786417900192 | -122.469617677573 | (37.7786417900192, -122.469617677573) | |||
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 81502 | 81502 | 107995 | Undocumented 2 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 907 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 6x11 | Permit Number 774103 | 6015290.10173 | 2104424.8547900002 | 37.7592087238569 | -122.39016295569598 | (37.7592087238569, -122.390162955696) | ||
| 81555 | 81555 | 108736 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1351 Minna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | ||
| 81573 | 81573 | 110967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003043.0 | 2116458.0 | 37.7915618650441 | -122.43337916182101 | (37.7915618650441, -122.433379161821) | ||||
| 81598 | 81598 | 94690 | Property Tree 7 | Brachychiton populneus :: Bottle Tree 329 | 749 Congo St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274.0 | 2096023.0 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | ||||
| 81636 | 81636 | 87743 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 335 Wilde Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | |||
| 81641 | 81641 | 89366 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51946 | 6006673.6 | 2095420.1 | 37.7340020224619 | -122.419324232824 | (37.7340020224619, -122.419324232824) | |||
| 81688 | 81688 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 81746 | 81746 | 100074 | Undocumented 2 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003070.0 | 2104166.0 | 37.7578126071811 | -122.43240742658399 | (37.7578126071811, -122.432407426584) | ||||||
| 81789 | 81789 | 86872 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2007 12:00:00 AM | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | |||
| 81908 | 81908 | 89201 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1627 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371.0 | 2111438.0 | 37.7776832317385 | -122.43880436100599 | (37.7776832317385, -122.438804361006) | |||
| 81963 | 81963 | 88252 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1025 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131.0 | 2106547.0 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | |||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 82071 | 82071 | 92681 | Permitted Site 1 | Brahea aramata :: Mexican Blue Palm 313 | 2660 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2009 12:00:00 AM | Permit Number 52944 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
| 82097 | 82097 | 91787 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 974 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.2012910005 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | |||
| 82109 | 82109 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||||
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 82418 | 82418 | 91638 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.5368439998 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | |||
| 82435 | 82435 | 88162 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 365 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190844999 | (37.7810391100489, -122.40303190845) | |||
| 82487 | 82487 | 104995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2220 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | |||
| 82492 | 82492 | 112009 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 82526 | 82526 | 88406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1716 Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055.0 | 2117126.0 | 37.7936228211286 | -122.41954507638901 | (37.7936228211286, -122.419545076389) | |||
| 82540 | 82540 | 91660 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | ||
| 82574 | 82574 | 107467 | Permitted Site 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 473 | 1643 35th Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | |||
| 82620 | 82620 | 102901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 BATTERY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012523.0 | 2118543.0 | 37.797820041376205 | -122.400724815577 | (37.7978200413762, -122.400724815577) | ||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 82777 | 82777 | 85446 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 82793 | 82793 | 95708 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 277 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392.0 | 2091652.0 | 37.7235268927559 | -122.42694415274201 | (37.7235268927559, -122.426944152742) | ||
| 82794 | 82794 | 110929 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 445 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002243.0 | 2098437.0 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | |||||
| 82811 | 82811 | 114380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 437X SERRANO DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 5988907.0 | 2090368.0 | 37.7191136019865 | -122.48037847439699 | (37.7191136019865, -122.480378474397) | |||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 82853 | 82853 | 88479 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386.0 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | ||
| 82865 | 82865 | 93743 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | |||
| 82883 | 82883 | 92052 | DPW Maintained 3 | Betula nigra :: River Birch 266 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 82893 | 82893 | 97042 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 82954 | 82954 | 88643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623.0 | 37.745826311758705 | -122.40210478451701 | (37.7458263117587, -122.402104784517) | |||
| 82966 | 82966 | 88341 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823.0 | 2090807.0 | 37.721231068747294 | -122.425394157088 | (37.7212310687473, -122.425394157088) | |||
| 82980 | 82980 | 87788 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
| 83017 | 83017 | 104401 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 727 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999017.0 | 2108166.0 | 37.768564950056 | -122.44671213341002 | (37.768564950056, -122.44671213341) | ||||
| 83056 | 83056 | 108808 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 542 Moscow St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.42937193832199 | (37.7190626969286, -122.429371938322) | |
| 83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
| 83393 | 83393 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 83446 | 83446 | 106682 | Undocumented 2 | Acer spp :: Maple 158 | 212 COLLINGWOOD ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002028.5 | 2104520.8 | 37.7587276896571 | -122.436034749265 | (37.7587276896571, -122.436034749265) | ||||||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83455 | 83455 | 89234 | Permitted Site 1 | Tree(s) :: 17 | 239 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2008 12:00:00 AM | 3x3 | Permit Number 51868 | 6009415.9 | 2110603.1 | 37.7758451977468 | -122.41091521392 | (37.7758451977468, -122.41091521392) | |||
| 83486 | 83486 | 108472 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | |||
| 83538 | 83538 | 92871 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 3600 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53088 | 5997031.0 | 2116025.0 | 37.790030052590105 | -122.454149203806 | (37.7900300525901, -122.454149203806) | ||||
| 83545 | 83545 | 107135 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 83608 | 83608 | 89008 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 707 Carolina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436.0 | 2104662.0 | 37.7597011565358 | -122.40005052882499 | (37.7597011565358, -122.400050528825) | |||
| 83612 | 83612 | 105285 | Undocumented 2 | Persea americana :: Avocado 113 | 1055 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5998993.5 | 2106394.4 | 37.763699240068796 | -122.44666593484399 | (37.7636992400688, -122.446665934844) | ||||
| 83657 | 83657 | 107775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | |||||
| 83723 | 83723 | 88533 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 55 Cervantes Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2008 12:00:00 AM | 3x3 | Permit Number 51490 | 6001717.8 | 2120796.9 | 37.8034000766729 | -122.438275302167 | (37.8034000766729, -122.438275302167) | |||
| 83761 | 83761 | 97253 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 364 Banks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768268 | 6008584.5 | 2096981.4 | 37.7383964511341 | -122.412827985209 | (37.7383964511341, -122.412827985209) | |||
| 83825 | 83825 | 96459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 83863 | 83863 | 107650 | Undocumented 2 | Tree(s) :: 17 | 888 DUNCAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000841.2 | 2099697.3 | 37.74541599809321 | -122.439795143209 | (37.7454159980932, -122.439795143209) | ||||||
| 84040 | 84040 | 91682 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007432.064539 | 2107206.199481 | 37.766406671896 | -122.41753702057301 | (37.766406671896, -122.417537020573) | |||
| 84128 | 84128 | 112015 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 84214 | 84214 | 121763 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 84244 | 84244 | 105061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 163 10TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 4x3 | 5992696.3 | 2114396.0 | 37.785307754338 | -122.46902816717301 | (37.785307754338, -122.469028167173) |
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");