Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177621 | 177621 | 34624 | Permitted Site 1 | Pinus torreyana :: Torrey Pine 555 | 1440 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 12 | Permit Number 38306 | 5988698.57904624 | 2105516.51025916 | 37.7606953425859 | -122.482208131756 | (37.7606953425859, -122.482208131756) | |
| 168425 | 168425 | 49167 | Permitted Site 1 | Acer tegmentosum :: Manchurian snakebark maple 552 | 559 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2003 12:00:00 AM | 4 | Permit Number 46289 | 6011256.105830001 | 2105759.6348200003 | 37.762649160563704 | -122.40420847273998 | (37.7626491605637, -122.40420847274) | ||
| 160417 | 160417 | 101728 | Permitted Site 1 | Cercidiphyllum japonicum :: Katsura tree 547 | 90 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2012 12:00:00 AM | 7 | 3x3 | Permit Number 769383 | 6003346.97259 | 2094586.71516 | 37.731525817059705 | -122.430765951898 | (37.7315258170597, -122.430765951898) | |
| 138584 | 138584 | 94587 | Permitted Site 1 | Persea americana 'Stewart' :: Stewart Avocado 538 | 4072 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2010 12:00:00 AM | 3x3 | Permit Number 53764 | 6002706.0 | 2101836.0 | 37.7513943353159 | -122.433499781921 | (37.7513943353159, -122.433499781921) | |||
| 136860 | 136860 | 107594 | Permitted Site 1 | Prunus campanulata :: Taiwan Flowering Cherry 537 | 1801X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 5993052.66806 | 2112040.96292 | 37.778862048054 | -122.467623923273 | (37.778862048054, -122.467623923273) | |||
| 128879 | 128879 | 40225 | Permitted Site 1 | Acer ginnela :: Amur Maple 532 | 394 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41407 | 6003833.01657725 | 2102180.77232097 | 37.7524048777321 | -122.429627013671 | (37.7524048777321, -122.429627013671) | ||
| 133909 | 133909 | 58103 | Permitted Site 1 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 756 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52383 | 6011525.71136 | 2104836.68468 | 37.7601300066003 | -122.403211071536 | (37.7601300066003, -122.403211071536) | |
| 142788 | 142788 | 57101 | Permitted Site 1 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 3721 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 4 | 3x3 | Permit Number 14371 | 6004927.69179762 | 2102493.53287665 | 37.753325568237294 | -122.425863704952 | (37.7533255682373, -122.425863704952) | |
| 118076 | 118076 | 26589 | Permitted Site 1 | Ulmus procera :: English Elm 527 | 1647 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 6 | 3X3 | 6012128.96715 | 2091072.2459200001 | 37.722369452807605 | -122.400157976887 | (37.7223694528076, -122.400157976887) | ||
| 117945 | 117945 | 104498 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 128374 | 128374 | 104497 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 115182 | 115182 | 53140 | Permitted Site 1 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 525 | 1498@ KEITH Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
| 112390 | 112390 | 82083 | Permitted Site 1 | Ulmus parvifolia 'True Green' :: True Green Chinese Elm 523 | 1442 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
| 109820 | 109820 | 7938 | Permitted Site 1 | Crinodendron patagua :: Lily-of-the-Valley Tree 521 | 1410X Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6005829.8939946 | 2114877.7740744 | 37.7873806719016 | -122.42362413098199 | (37.7873806719016, -122.423624130982) | |||
| 108919 | 108919 | 100076 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 262 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776532 | 5990584.51145 | 2113652.92092 | 37.783145223942 | -122.47627994024201 | (37.783145223942, -122.476279940242) | |
| 122707 | 122707 | 100078 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 266 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776410 | 5990586.53381 | 2113609.7978 | 37.7830269371305 | -122.47626979286501 | (37.7830269371305, -122.476269792865) | |
| 125233 | 125233 | 38821 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 426 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 777484 | 5994995.0692300005 | 2112615.41295 | 37.7805512921286 | -122.460946081899 | (37.7805512921286, -122.460946081899) | |
| 107483 | 107483 | 51021 | Permitted Site 1 | Prunus sargentii :: Sargent Cherry 517 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50421 | 6001430.71351981 | 2101713.7407115 | 37.750986202789 | -122.43790110742201 | (37.750986202789, -122.437901107422) | ||
| 105760 | 105760 | 52841 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 2600@ PIERCE Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48859 | 6001694.15234168 | 2117006.51478628 | 37.7929913285029 | -122.43808545751499 | (37.7929913285029, -122.438085457515) | |||
| 121318 | 121318 | 48732 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 1840 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2002 12:00:00 AM | Permit Number 46012 | 6001561.51478574 | 2114750.36064197 | 37.7867889680887 | -122.438382676367 | (37.7867889680887, -122.438382676367) | |||
| 123428 | 123428 | 46361 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 160 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2002 12:00:00 AM | Permit Number 44599 | 6015543.16497343 | 2115073.84916298 | 37.7884625396437 | -122.390031641839 | (37.7884625396437, -122.390031641839) | |||
| 144647 | 144647 | 50176 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 1400 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | Permit Number 46885 | 5993138.94338431 | 2097622.37512786 | 37.739277347046496 | -122.46627731988 | (37.7392773470465, -122.46627731988) | |||
| 104446 | 104446 | 53220 | Permitted Site 1 | Citrus x hystrix :: Kaffir lime 515 | 311 San Benito Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | 3x7 | Permit Number 769253 | 5992906.41199583 | 2094772.69381636 | 37.7314394147179 | -122.466874195473 | (37.7314394147179, -122.466874195473) | ||
| 115983 | 115983 | 35968 | Permitted Site 1 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 513 | 123 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39126 | 6005630.57353586 | 2096425.6693507 | 37.7367042924726 | -122.423001748533 | (37.7367042924726, -122.423001748533) | ||
| 141616 | 141616 | 3915 | Permitted Site 1 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 141601 | 141601 | 108981 | Permitted Site 1 | Eucalyptus odorata :: Peppermint Box 507 | 10 ARBOR ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/02/2015 12:00:00 AM | 3 | Permit Number 774690 | 6002183.8 | 2097008.7 | 37.7381100606509 | -122.434960408352 | (37.7381100606509, -122.434960408352) | |||
| 94322 | 94322 | 63293 | Permitted Site 1 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 15 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23859 | 6008094.27360425 | 2100056.59433468 | 37.7468127256176 | -122.41474052571199 | (37.7468127256176, -122.414740525712) | ||
| 102112 | 102112 | 108072 | Permitted Site 1 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 101 BUENA VISTA AVE EAST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
| 90478 | 90478 | 52993 | Permitted Site 1 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 501 | 1210 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 24 | 3x3 | Permit Number 49019 | 6003829.10545601 | 2101223.75142142 | 37.749776901068 | -122.42957229205601 | (37.749776901068, -122.429572292056) | |
| 118068 | 118068 | 55720 | Permitted Site 1 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 501 | 58 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53177 | 6003133.68670367 | 2107965.52082477 | 37.7682487847408 | -122.432458547407 | (37.7682487847408, -122.432458547407) | |||
| 90412 | 90412 | 117515 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 252 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003503.0 | 2106732.0 | 37.76488277097621 | -122.43109307683599 | (37.7648827709762, -122.431093076836) | |||||
| 120633 | 120633 | 33490 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 35 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37609 | 6006977.21573848 | 2099539.13365135 | 37.74532906867729 | -122.418566525643 | (37.7453290686773, -122.418566525643) | ||
| 126777 | 126777 | 33504 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37598 | 6006493.12826546 | 2098644.93339698 | 37.7428465310244 | -122.420176972942 | (37.7428465310244, -122.420176972942) | |||
| 144735 | 144735 | 33506 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37601 | 6006405.76060345 | 2098478.97764317 | 37.7423859306557 | -122.42046728912099 | (37.7423859306557, -122.420467289121) | |||
| 145498 | 145498 | 33505 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 201 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37599 | 6006452.6422085995 | 2098569.84491652 | 37.7426380736375 | -122.42031163432199 | (37.7426380736375, -122.420311634322) | |||
| 88612 | 88612 | 95698 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 90751 | 90751 | 95699 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 95246 | 95246 | 95696 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 120606 | 120606 | 95697 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 87379 | 87379 | 95376 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767248 | 6004016.0 | 2102485.0 | 37.753250574879395 | -122.429015915711 | (37.7532505748794, -122.429015915711) | |
| 90744 | 90744 | 94882 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 1778 Quesada Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53949 | 6014333.3 | 2095365.5 | 37.7342805262691 | -122.392838262387 | (37.7342805262691, -122.392838262387) | ||
| 91664 | 91664 | 95389 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 4751 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767258 | 6000210.0 | 2101069.0 | 37.749146408168 | -122.442076167893 | (37.749146408168, -122.442076167893) | |
| 115012 | 115012 | 95548 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 1701x SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767348 | 6003979.0 | 2098037.0 | 37.74103530456421 | -122.428826793148 | (37.7410353045642, -122.428826793148) |
| 91238 | 91238 | 107719 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 3301x 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774073 | 6007483.0 | 2105569.0 | 37.761914169510604 | -122.417244815958 | (37.7619141695106, -122.417244815958) | |
| 98556 | 98556 | 97557 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 1316 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2011 12:00:00 AM | Permit Number 768295 | 5993059.9 | 2106465.7 | 37.7635542817507 | -122.467193428173 | (37.7635542817507, -122.467193428173) | |||
| 86832 | 86832 | 98699 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 89301 | 89301 | 98701 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 89877 | 89877 | 98698 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 86750 | 86750 | 106343 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 97261 | 97261 | 106340 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | |||
| 143282 | 143282 | 106339 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497X Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.6 | 2099138.4 | 37.7439915346951 | -122.433052549622 | (37.7439915346951, -122.433052549622) | ||
| 86198 | 86198 | 47414 | Permitted Site 1 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 492 | 396 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45325 | 6003061.80741147 | 2104489.40624321 | 37.7587001387613 | -122.43245885881001 | (37.7587001387613, -122.43245885881) | ||
| 146197 | 146197 | 47413 | Permitted Site 1 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 492 | 396 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45325 | 6003061.80741147 | 2104489.40624321 | 37.7587001387613 | -122.43245885881001 | (37.7587001387613, -122.43245885881) | ||
| 85671 | 85671 | 40135 | Permitted Site 1 | Geijera spp :: Geijera 489 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41339 | 6009180.78986515 | 2103366.6928894 | 37.755962504482 | -122.411217228554 | (37.755962504482, -122.411217228554) | ||||
| 85457 | 85457 | 50410 | Permitted Site 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 487 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47065 | 6000234.812518599 | 2094385.17995161 | 37.7307956329874 | -122.441510803123 | (37.7307956329874, -122.441510803123) | ||
| 88703 | 88703 | 66716 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 3506 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1991 12:00:00 AM | 12 | 3x3 | Permit Number 29957 | 6006118.0 | 2102026.0 | 37.752109025945295 | -122.42171416073799 | (37.7521090259453, -122.421714160738) | |
| 109365 | 109365 | 107697 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 141297 | 141297 | 107698 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 142899 | 142899 | 100073 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 930@ Lorraine Ct Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2012 12:00:00 AM | 3x3 | Permit Number 769060 | 5996162.0 | 2112255.0 | 37.7796287713947 | -122.45688306406099 | (37.7796287713947, -122.456883064061) | ||
| 84332 | 84332 | 52189 | Permitted Site 1 | Liquidambar formosana :: Chinese Sweet Gum 481 | 985 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50862 | 5998794.16746472 | 2106547.68954693 | 37.7641087462545 | -122.44736639531901 | (37.7641087462545, -122.447366395319) | ||
| 111417 | 111417 | 57009 | Permitted Site 1 | Liquidambar formosana :: Chinese Sweet Gum 481 | 24 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 3 | Permit Number 775634 | 6003352.23299803 | 2107445.91361589 | 37.7668344601842 | -122.43166551543001 | (37.7668344601842, -122.43166551543) | ||
| 84047 | 84047 | 38429 | Permitted Site 1 | Sambucus mexicana :: Blue Elderberry 480 | 1000X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1998 12:00:00 AM | 6012766.0 | 2102838.0 | 37.7547112450133 | -122.398781204994 | (37.7547112450133, -122.398781204994) | ||||
| 83778 | 83778 | 87644 | Permitted Site 1 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 1770X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004459.1886599995 | 2114839.9257 | 37.7871992830496 | -122.428363789521 | (37.7871992830496, -122.428363789521) | |||
| 140328 | 140328 | 83461 | Permitted Site 1 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 847 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50441 | 6000958.23221364 | 2101981.88946936 | 37.7516955955481 | -122.43955421112601 | (37.7516955955481, -122.439554211126) | ||
| 82982 | 82982 | 92439 | Permitted Site 1 | Griselinia lucida :: Griselinia 477 | 1314 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52829 | 5982178.1 | 2106127.8 | 37.761992345907004 | -122.50480444860399 | (37.761992345907, -122.504804448604) | |
| 83334 | 83334 | 115773 | Permitted Site 1 | Griselinia lucida :: Griselinia 477 | 1247 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772445 | 6015089.2 | 2090491.5 | 37.720939452782105 | -122.389884508267 | (37.7209394527821, -122.389884508267) | ||
| 82944 | 82944 | 97131 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 91445 | 91445 | 97133 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 92039 | 92039 | 97130 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 93695 | 93695 | 97128 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 119675 | 119675 | 97132 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 124371 | 124371 | 97129 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 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) | |||
| 82201 | 82201 | 47719 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 227 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45514 | 6001968.67680158 | 2096145.76019893 | 37.7357284107067 | -122.435642476033 | (37.7357284107067, -122.435642476033) | ||
| 90693 | 90693 | 50864 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 3949 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47379 | 6004213.25771434 | 2100699.47949469 | 37.7483591159424 | -122.428206518167 | (37.7483591159424, -122.428206518167) | |||
| 100233 | 100233 | 39713 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 690 Mangels Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1999 12:00:00 AM | Permit Number 41097 | 5996877.25794519 | 2095301.81406685 | 37.7331206330938 | -122.45318448806002 | (37.7331206330938, -122.45318448806) | |||
| 112202 | 112202 | 39712 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 690 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1999 12:00:00 AM | Permit Number 41097 | 5996877.25794519 | 2095301.81406685 | 37.7331206330938 | -122.45318448806002 | (37.7331206330938, -122.45318448806) | |||
| 112657 | 112657 | 46918 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 132 Apollo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | Permit Number 44975 | 6012573.05799142 | 2094250.99481075 | 37.731122398703 | -122.39884583127301 | (37.731122398703, -122.398845831273) | |||
| 115674 | 115674 | 39716 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 690 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1999 12:00:00 AM | Permit Number 41097 | 5996877.25794519 | 2095301.81406685 | 37.7331206330938 | -122.45318448806002 | (37.7331206330938, -122.45318448806) | |||
| 121350 | 121350 | 39714 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 690 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41097 | 5996877.25794519 | 2095301.81406685 | 37.7331206330938 | -122.45318448806002 | (37.7331206330938, -122.45318448806) | ||
| 124480 | 124480 | 39717 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 735 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41098 | 5996645.89936221 | 2095233.50926101 | 37.732919821696 | -122.453979420774 | (37.732919821696, -122.453979420774) | ||
| 144946 | 144946 | 39715 | Permitted Site 1 | Malus x 'Callaway' :: White-Flowered Crabapple 472 | 690 Mangels Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1999 12:00:00 AM | Permit Number 41097 | 5996877.25794519 | 2095301.81406685 | 37.7331206330938 | -122.45318448806002 | (37.7331206330938, -122.45318448806) | |||
| 81243 | 81243 | 66957 | Permitted Site 1 | Tilia spp :: Linden 470 | 37 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1992 12:00:00 AM | 3x3 | Permit Number 30292 | 5997466.01687457 | 2113443.17296717 | 37.7829659755963 | -122.452457697129 | (37.7829659755963, -122.452457697129) | ||
| 80729 | 80729 | 97127 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 84471 | 84471 | 97946 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 108722 | 108722 | 97947 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 112108 | 112108 | 97134 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 120643 | 120643 | 97948 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 146003 | 146003 | 97126 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 80682 | 80682 | 41831 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 1359 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42217 | 5991431.78738883 | 2106173.10651318 | 37.76265678079321 | -122.47280316308901 | (37.7626567807932, -122.472803163089) |
| 90098 | 90098 | 41832 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 42217 | 5991431.78738883 | 2106173.10651318 | 37.76265678079321 | -122.47280316308901 | (37.7626567807932, -122.472803163089) |
| 104923 | 104923 | 39977 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 2535 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 41236 | 5990760.76494865 | 2098142.10858699 | 37.7405668981047 | -122.474537835541 | (37.7405668981047, -122.474537835541) | ||
| 112340 | 112340 | 39604 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 3628 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | 5 | 3x3 | Permit Number 41007 | 6005441.47926786 | 2104914.36675045 | 37.7600016345446 | -122.424259080531 | (37.7600016345446, -122.424259080531) |
| 139070 | 139070 | 46183 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 60 Stonecrest Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 44510 | 5991036.80877736 | 2093807.38449355 | 37.7286808348731 | -122.473267326425 | (37.7286808348731, -122.473267326425) | ||
| 142228 | 142228 | 38658 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40580 | 5997471.03104632 | 2107818.12364092 | 37.7675213374579 | -122.452034381815 | (37.7675213374579, -122.452034381815) | |
| 79762 | 79762 | 50834 | Permitted Site 1 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 153 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | Permit Number 47352 | 5994256.29106206 | 2114544.54740164 | 37.7858056356354 | -122.463641898442 | (37.7858056356354, -122.463641898442) | |||
| 81626 | 81626 | 44829 | Permitted Site 1 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 4256 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2001 12:00:00 AM | Permit Number 43921 | 6001511.54431017 | 2102357.39385657 | 37.7527581163366 | -122.43766767888799 | (37.7527581163366, -122.437667678888) | |||
| 115698 | 115698 | 40376 | Permitted Site 1 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 1555 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1999 12:00:00 AM | Permit Number 41488 | 5993971.05534262 | 2104925.64646362 | 37.7593782496265 | -122.46393025884399 | (37.7593782496265, -122.463930258844) | |||
| 116533 | 116533 | 50833 | Permitted Site 1 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 153 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | Permit Number 47352 | 5994256.29106206 | 2114544.54740164 | 37.7858056356354 | -122.463641898442 | (37.7858056356354, -122.463641898442) | |||
| 143995 | 143995 | 50630 | Permitted Site 1 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 1198 Gilman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) |
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");