trees
39,840 rows where qLegalStatus_id = 7 sorted by Neighborhoods (old) descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 462 | 33949 | Permitted Site 7 | Tree(s) :: 17 | 1238 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37907 | 5999468.65195546 | 2108623.71254321 | 37.7698475030127 | -122.445182824083 | (37.7698475030127, -122.445182824083) | 15 | 5 | 11 | 29492 | 9 | |||
| 778 | 61131 | Permitted Site 7 | Tree(s) :: 17 | 76 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1983 12:00:00 AM | Permit Number 20983 | 5998241.83548559 | 2106883.25514995 | 37.7649985471459 | -122.449300920602 | (37.7649985471459, -122.449300920602) | 15 | 5 | 11 | 29492 | 9 | |||
| 1177 | 50666 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | 15 | 5 | 11 | 29492 | 9 | |||
| 2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
| 2269 | 58628 | Permitted Site 7 | Tree(s) :: 17 | 1240 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17846 | 5998229.96040674 | 2106129.9560019 | 37.7629294984974 | -122.449287716214 | (37.7629294984974, -122.449287716214) | 15 | 5 | 11 | 29492 | 9 | |||
| 2375 | 58506 | Permitted Site 7 | Tree(s) :: 17 | 1378 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17681 | 5999108.40955672 | 2108391.40839874 | 37.7691890857648 | -122.446412174677 | (37.7691890857648, -122.446412174677) | 15 | 5 | 11 | 29492 | 9 | |||
| 2897 | 62561 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | 15 | 5 | 11 | 29492 | 9 | ||
| 3159 | 94569 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
| 3610 | 45141 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | 15 | 5 | 11 | 29492 | 9 | ||
| 4209 | 62680 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 654 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23014 | 6002561.35247931 | 2108872.24257196 | 37.7707059484007 | -122.434503031919 | (37.7707059484007, -122.434503031919) | 15 | 5 | 11 | 29492 | 9 | ||
| 4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
| 4919 | 64744 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | 15 | 5 | 11 | 29492 | 9 | ||
| 5390 | 244700 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 722 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:50:00 AM | 3 | Width 3ft | Permit Number 32809 | 6002026.57128 | 2108798.52358 | 37.7704731625436 | -122.43634756898 | (37.7704731625436, -122.43634756898) | 15 | 5 | 11 | 29492 | 9 | |
| 5413 | 54883 | Permitted Site 7 | Tree(s) :: 17 | 130 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | Permit Number 10747 | 5997823.05471268 | 2107172.49422209 | 37.7657687610677 | -122.450770228093 | (37.7657687610677, -122.450770228093) | 15 | 5 | 11 | 29492 | 9 | |||
| 5516 | 248395 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41881 | 5997659.0251 | 2108142.2349 | 37.7684220306889 | -122.451407517669 | (37.7684220306889, -122.451407517669) | 15 | 5 | 11 | 29492 | 9 | |
| 5878 | 236882 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 5 | Width 3ft | Permit Number 772898 | 5999413.41178 | 2107340.88769 | 37.7663220358477 | -122.445281650937 | (37.7663220358477, -122.445281650937) | 15 | 5 | 5 | 29492 | 9 | |
| 6128 | 54602 | Permitted Site 7 | Tree(s) :: 17 | 9 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | Permit Number 10425 | 6001366.18346921 | 2108717.79509064 | 37.770213956935 | -122.438626063816 | (37.770213956935, -122.438626063816) | 15 | 5 | 11 | 29492 | 9 | |||
| 6556 | 58570 | Permitted Site 7 | Tree(s) :: 17 | 21 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | Permit Number 17762 | 5998605.35109058 | 2106881.40863757 | 37.7650142634589 | -122.448043483158 | (37.7650142634589, -122.448043483158) | 15 | 5 | 11 | 29492 | 9 | |||
| 6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
| 6803 | 58505 | Permitted Site 7 | Tree(s) :: 17 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17679 | 5999211.20393328 | 2108405.73280016 | 37.7692342875299 | -122.446057646319 | (37.7692342875299, -122.446057646319) | 15 | 5 | 11 | 29492 | 9 | |||
| 7091 | 88264 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1911 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51250 | 5997436 | 2108804 | 37.7702262944805 | -122.452226693379 | (37.7702262944805, -122.452226693379) | 15 | 5 | 11 | 29492 | 9 | |
| 7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
| 7432 | 40564 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 223 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 41608 | 6003273.4207217 | 2109055.89818285 | 37.7712506170222 | -122.432053094849 | (37.7712506170222, -122.432053094849) | 15 | 9 | 11 | 29492 | 9 | ||
| 7577 | 248396 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41881 | 5997671.1383 | 2108143.749 | 37.7684268816356 | -122.451365728625 | (37.7684268816356, -122.451365728625) | 15 | 5 | 11 | 29492 | 9 | |
| 7656 | 41147 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1571 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41880 | 5998098.90766238 | 2108198.23177185 | 37.7686009624438 | -122.449890046711 | (37.7686009624438, -122.449890046711) | 15 | 5 | 11 | 29492 | 9 | ||
| 7848 | 54566 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | 15 | 5 | 11 | 29492 | 9 | ||
| 8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
| 8462 | 56815 | Permitted Site 7 | Tree(s) :: 17 | 1025 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14046 | 5999125.01104675 | 2106549.41228247 | 37.764132376363 | -122.446222231908 | (37.764132376363, -122.446222231908) | 15 | 5 | 11 | 29492 | 9 | |||
| 8623 | 56851 | Permitted Site 7 | Tree(s) :: 17 | 824 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14085 | 5999153.34024967 | 2107522.86966015 | 37.7668068637023 | -122.446194277772 | (37.7668068637023, -122.446194277772) | 15 | 5 | 5 | 29492 | 9 | |||
| 8747 | 58667 | Permitted Site 7 | Tree(s) :: 17 | 160 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17891 | 5998309.60623397 | 2107835.13472194 | 37.7676160435774 | -122.449135099535 | (37.7676160435774, -122.449135099535) | 15 | 5 | 11 | 29492 | 9 | |||
| 8805 | 53790 | Permitted Site 7 | Tree(s) :: 17 | 169 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1986 12:00:00 AM | Permit Number 23032 | 5998265.46795949 | 2107775.81864913 | 37.7674506521184 | -122.449283493491 | (37.7674506521184, -122.449283493491) | 15 | 5 | 11 | 29492 | 9 | |||
| 8846 | 97906 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 401 Upper Ter | 1 | Front Yard : Yard | Tree | Private 2 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428 | (37.7632905770055, -122.44586250428) | 15 | 5 | 5 | 29492 | 9 | ||
| 9152 | 64088 | Permitted Site 7 | Tree(s) :: 17 | 715 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1987 12:00:00 AM | Permit Number 24850 | 5999882.54311766 | 2107850.29085779 | 37.7677474972086 | -122.443695618229 | (37.7677474972086, -122.443695618229) | 15 | 5 | 5 | 29492 | 9 | |||
| 9320 | 221746 | Permitted Site 7 | Pittosporum spp :: Pittosporum spp 170 | 200 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 25 | Width 3ft | Permit Number 12382 | 5997646.78521 | 2106482.1718 | 37.7638632192392 | -122.451330111502 | (37.7638632192392, -122.451330111502) | 15 | 5 | 11 | 29492 | 9 | |
| 9367 | 83358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1160 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50875 | 5997390.75214654 | 2106213.86032098 | 37.7631118403797 | -122.452196286828 | (37.7631118403797, -122.452196286828) | 15 | 5 | 11 | 29492 | 9 | ||
| 9466 | 49338 | Permitted Site 7 | Fraxinus angustifolia :: Narrow-leaved Ash 331 | 100 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.7640688343052 | -122.444414431135 | (37.7640688343052, -122.444414431135) | 15 | 5 | 5 | 29492 | 9 | |||
| 10078 | 51848 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 813 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48072 | 5998616.0895613 | 2107512.49914502 | 37.7667476925096 | -122.44805178449 | (37.7667476925096, -122.44805178449) | 15 | 5 | 11 | 29492 | 9 | |||
| 10122 | 52665 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815 | 2109317 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | 15 | 5 | 11 | 29492 | 9 | |
| 10386 | 34217 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38032 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | |||
| 10400 | 57447 | Permitted Site 7 | Tree(s) :: 17 | 1062 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | Permit Number 16293 | 6001478.15691041 | 2109417.28569642 | 37.7721409530901 | -122.438288868495 | (37.7721409530901, -122.438288868495) | 15 | 5 | 11 | 29492 | 9 | |||
| 10494 | 62550 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 851 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468697 | (37.7724466097716, -122.43474468697) | 15 | 5 | 11 | 29492 | 9 | ||
| 10622 | 58722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | 15 | 5 | 5 | 29492 | 9 | ||
| 10983 | 66731 | Permitted Site 7 | Tree(s) :: 17 | 415 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/1991 12:00:00 AM | Permit Number 29974 | 5997421.22692959 | 2109110.77309545 | 37.7710677681546 | -122.452299932575 | (37.7710677681546, -122.452299932575) | 15 | 5 | 11 | 29492 | 9 | |||
| 11083 | 53568 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2014 12:00:00 AM | 3 | 6x7 | Permit Number 774472 | 6002289.86675011 | 2108835.21130526 | 37.7705888548661 | -122.435439454682 | (37.7705888548661, -122.435439454682) | 15 | 5 | 11 | 29492 | 9 | |
| 11558 | 116508 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1500x Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
| 11706 | 58511 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1430 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1979 12:00:00 AM | Permit Number 17687 | 5998871.25967783 | 2108358.36156462 | 37.7690847998305 | -122.447230081169 | (37.7690847998305, -122.447230081169) | 15 | 5 | 11 | 29492 | 9 | |||
| 11723 | 93875 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997572 | 2107825 | 37.7675460011803 | -122.451685641377 | (37.7675460011803, -122.451685641377) | 15 | 5 | 11 | 29492 | 9 | |||||
| 12183 | 56754 | Permitted Site 7 | Tree(s) :: 17 | 620 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | Permit Number 16646 | 6002729.54406752 | 2108895.61995521 | 37.7707796830224 | -122.43392292637 | (37.7707796830224, -122.43392292637) | 15 | 5 | 11 | 29492 | 9 | |||
| 12653 | 56786 | Permitted Site 7 | Tree(s) :: 17 | 31 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1974 12:00:00 AM | Permit Number 14009 | 6000354.07450678 | 2108996.94987649 | 37.7709228183579 | -122.442146973348 | (37.7709228183579, -122.442146973348) | 15 | 5 | 11 | 29492 | 9 | |||
| 13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 13293 | 58458 | Permitted Site 7 | Tree(s) :: 17 | 197 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | Permit Number 17612 | 5998924.46027036 | 2107032.18373929 | 37.7654464900611 | -122.446950618984 | (37.7654464900611, -122.446950618984) | 15 | 5 | 11 | 29492 | 9 | |||
| 13652 | 41494 | Permitted Site 7 | Tree(s) :: 17 | 51 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2000 12:00:00 AM | Permit Number 42058 | 6003076.88222491 | 2108741.04332647 | 37.7703749584039 | -122.432710434036 | (37.7703749584039, -122.432710434036) | 15 | 5 | 5 | 29492 | 9 | |||
| 13696 | 45131 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 121 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43990 | 6000310.7826269 | 2109305.17604742 | 37.7717666625759 | -122.442318851526 | (37.7717666625759, -122.442318851526) | 15 | 5 | 11 | 29492 | 9 | ||
| 13830 | 62681 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 59 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23015 | 6002832.11131033 | 2108737.08241022 | 37.7703501979341 | -122.433556812869 | (37.7703501979341, -122.433556812869) | 15 | 5 | 5 | 29492 | 9 | ||
| 13925 | 58602 | Permitted Site 7 | Tree(s) :: 17 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1979 12:00:00 AM | Permit Number 17808 | 5997971.89469326 | 2107987.65011821 | 37.7680154907799 | -122.450314190437 | (37.7680154907799, -122.450314190437) | 15 | 5 | 11 | 29492 | 9 | |||
| 14008 | 60195 | Permitted Site 7 | Tree(s) :: 17 | 810 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1982 12:00:00 AM | Permit Number 19741 | 5997660.9442942 | 2107774.62425331 | 37.767412775668 | -122.451374362519 | (37.767412775668, -122.451374362519) | 15 | 5 | 11 | 29492 | 9 | |||
| 14086 | 61802 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 527 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21831 | 6003166.76547694 | 2108904.02259639 | 37.7708275566646 | -122.43241117029 | (37.7708275566646, -122.43241117029) | 15 | 5 | 5 | 29492 | 9 | ||
| 14325 | 56804 | Permitted Site 7 | Tree(s) :: 17 | 121 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17729 | 5999330.31901261 | 2107678.68702178 | 37.7672448044403 | -122.445593345773 | (37.7672448044403, -122.445593345773) | 15 | 5 | 5 | 29492 | 9 | |||
| 14345 | 53839 | Permitted Site 7 | Tree(s) :: 17 | 1379 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1972 12:00:00 AM | Permit Number 9541 | 5999534.10280791 | 2107886.42603374 | 37.7678268356988 | -122.444903424555 | (37.7678268356988, -122.444903424555) | 15 | 5 | 11 | 29492 | 9 | |||
| 14510 | 225860 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1979 12:00:00 AM | 32 | Width 4ft | Permit Number 17861 | 5997829.91039 | 2105879.41446 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | 15 | 5 | 11 | 29492 | 9 | |
| 14558 | 46532 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 881PERMIT) Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2002 12:00:00 AM | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.447795788427 | (37.765484436098, -122.447795788427) | 15 | 5 | 11 | 29492 | 9 | |||
| 14591 | 17106 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.7716088013494 | -122.448553894841 | (37.7716088013494, -122.448553894841) | 15 | 5 | 11 | 29492 | 9 | |||
| 15340 | 62553 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 932 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.7724162326817 | -122.436140888716 | (37.7724162326817, -122.436140888716) | 15 | 5 | 11 | 29492 | 9 | ||
| 15429 | 60677 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1098 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25704 | 6001311.54507479 | 2109393.91334387 | 37.7720673006946 | -122.438863516223 | (37.7720673006946, -122.438863516223) | 15 | 5 | 11 | 29492 | 9 | ||
| 16326 | 108982 | Permitted Site 7 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772764 | 5998041.9 | 2106031.7 | 37.7626489535182 | -122.449931067375 | (37.7626489535182, -122.449931067375) | 15 | 5 | 11 | 29492 | 9 |
| 16480 | 50938 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.448495440986 | (37.7617562199837, -122.448495440986) | 15 | 5 | 11 | 29492 | 9 | ||
| 17149 | 96170 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 400 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997935 | 2109242 | 37.7714575031408 | -122.450532245047 | (37.7714575031408, -122.450532245047) | 15 | 5 | 11 | 29492 | 9 | ||||
| 17485 | 64739 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.7711120386945 | -122.433710000051 | (37.7711120386945, -122.433710000051) | 15 | 5 | 11 | 29492 | 9 | ||
| 17928 | 87790 | Permitted Site 7 | Brahea aramata :: Mexican Blue Palm 377 | 635 Buena Vista West Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2008 12:00:00 AM | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
| 18628 | 116483 | Permitted Site 7 | Tree(s) :: 17 | 191 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999138.49956791 | 2107652.6022322 | 37.7671622291215 | -122.446254942292 | (37.7671622291215, -122.446254942292) | 15 | 5 | 5 | 29492 | 9 | |||||
| 18761 | 56456 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30464 | 5999359.80887308 | 2107414.28954328 | 37.7665205189943 | -122.445472331181 | (37.7665205189943, -122.445472331181) | 15 | 5 | 5 | 29492 | 9 | ||
| 19342 | 94647 | Permitted Site 7 | Tree(s) :: 17 | 37 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2010 12:00:00 AM | Permit Number 53784 | 5999741 | 2107742 | 37.7674420836916 | -122.444177414561 | (37.7674420836916, -122.444177414561) | 15 | 5 | 5 | 29492 | 9 | |||
| 19633 | 58597 | Permitted Site 7 | Tree(s) :: 17 | 4708 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | Permit Number 17798 | 5998613.71749143 | 2105706.69094425 | 37.7617892620457 | -122.447929963483 | (37.7617892620457, -122.447929963483) | 15 | 5 | 11 | 29492 | 9 | |||
| 19713 | 50720 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1350 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/2004 12:00:00 AM | Permit Number 47273 | 5999239.23876402 | 2108409.63945521 | 37.7692466150992 | -122.44596095669 | (37.7692466150992, -122.44596095669) | 15 | 5 | 11 | 29492 | 9 | ||
| 19810 | 106233 | Permitted Site 7 | Tree(s) :: 17 | 4862 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2014 12:00:00 AM | 3 | Permit Number 773160 | 5997949.3 | 2105681.6 | 37.7616823682878 | -122.45022609909 | (37.7616823682878, -122.45022609909) | 15 | 5 | 11 | 29492 | 9 | ||
| 19995 | 53679 | Permitted Site 7 | Tree(s) :: 17 | 879 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1970 12:00:00 AM | Permit Number 6620 | 5998678.63313095 | 2107064.43535106 | 37.7655209974413 | -122.447803197371 | (37.7655209974413, -122.447803197371) | 15 | 5 | 11 | 29492 | 9 | |||
| 20234 | 110527 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1208 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000769 | 2109311 | 37.771808759149 | -122.440734269497 | (37.771808759149, -122.440734269497) | 15 | 5 | 11 | 29492 | 9 | ||||
| 20252 | 66756 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 117 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30009 | 5999558.794274 | 2106484.77967466 | 37.7639796750059 | -122.444717260685 | (37.7639796750059, -122.444717260685) | 15 | 5 | 5 | 29492 | 9 | ||
| 20659 | 59670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297 | 2106864 | 37.7649488326227 | -122.449108733904 | (37.7649488326227, -122.449108733904) | 15 | 5 | 11 | 29492 | 9 |
| 20710 | 95694 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767442 | 5997236 | 2108822 | 37.7702642586668 | -122.452919787946 | (37.7702642586668, -122.452919787946) | 15 | 5 | 11 | 29492 | 9 | |
| 20974 | 58621 | Permitted Site 7 | Tree(s) :: 17 | 1137 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17837 | 5998137.96334182 | 2106414.28158144 | 37.7637049222099 | -122.449626390171 | (37.7637049222099, -122.449626390171) | 15 | 5 | 11 | 29492 | 9 | |||
| 21121 | 51223 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47589 | 5999349.25090269 | 2107863.63052883 | 37.7677536935842 | -122.445541163796 | (37.7677536935842, -122.445541163796) | 15 | 5 | 11 | 29492 | 9 | ||
| 21426 | 35154 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | 15 | 5 | 11 | 29492 | 9 | ||
| 21470 | 81452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 730 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49733 | 5997103.70386372 | 2108221.85987986 | 37.768608846124 | -122.453334062784 | (37.768608846124, -122.453334062784) | 15 | 5 | 11 | 29492 | 9 | ||
| 21532 | 56808 | Permitted Site 7 | Tree(s) :: 17 | 848 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14037 | 5999171.95831091 | 2107389.69108844 | 37.7664422520958 | -122.446120300719 | (37.7664422520958, -122.446120300719) | 15 | 5 | 5 | 29492 | 9 | |||
| 21550 | 58655 | Permitted Site 7 | Tree(s) :: 17 | 1208 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17877 | 5997450.10068352 | 2105786.4314569 | 37.7619416285684 | -122.451960182522 | (37.7619416285684, -122.451960182522) | 15 | 5 | 11 | 29492 | 9 | |||
| 21814 | 60571 | Permitted Site 7 | Tree(s) :: 17 | 1143 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1982 12:00:00 AM | Permit Number 20184 | 5998884.31137218 | 2105887.22823389 | 37.7623004356762 | -122.447007083315 | (37.7623004356762, -122.447007083315) | 15 | 5 | 11 | 29492 | 9 | |||
| 21824 | 67193 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30643 | 5997981.64121917 | 2106794.49458323 | 37.764739946577 | -122.450194465027 | (37.764739946577, -122.450194465027) | 15 | 5 | 11 | 29492 | 9 | ||
| 22013 | 58562 | Permitted Site 7 | Tree(s) :: 17 | 459 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | Permit Number 17751 | 5997550.12552913 | 2107430.49476709 | 37.766461537741 | -122.451732840186 | (37.766461537741, -122.451732840186) | 15 | 5 | 11 | 29492 | 9 | |||
| 22077 | 49434 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4746@ COLE 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 46372 | 5998472.35815921 | 2105699.24121629 | 37.7617607258811 | -122.448418330414 | (37.7617607258811, -122.448418330414) | 15 | 5 | 11 | 29492 | 9 | ||
| 22250 | 53182 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 125@ FREDRICK Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51539 | 5999344.74369471 | 2107521.50926134 | 37.7668140573489 | -122.445532149483 | (37.7668140573489, -122.445532149483) | 15 | 5 | 5 | 29492 | 9 | ||
| 22548 | 10416 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.445280397708 | (37.7701488573322, -122.445280397708) | 15 | 5 | 11 | 29492 | 9 | |||
| 22559 | 88965 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Buena Vista East Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2008 12:00:00 AM | 3x3 | Permit Number 51729 | 6001457 | 2108463 | 37.7695195187535 | -122.438293674292 | (37.7695195187535, -122.438293674292) | 15 | 5 | 5 | 29492 | 9 | ||
| 22829 | 54881 | Permitted Site 7 | Tree(s) :: 17 | 122 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | Permit Number 10745 | 5997881.39399763 | 2107180.62380817 | 37.7657944221927 | -122.450569032082 | (37.7657944221927, -122.450569032082) | 15 | 5 | 11 | 29492 | 9 | |||
| 22943 | 58649 | Permitted Site 7 | Tree(s) :: 17 | 932 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17871 | 5997240.30173879 | 2107294.95521373 | 37.7660716318861 | -122.452794675096 | (37.7660716318861, -122.452794675096) | 15 | 5 | 11 | 29492 | 9 | |||
| 22951 | 31794 | Permitted Site 7 | Tree(s) :: 17 | 135 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2015 12:00:00 AM | Permit Number 775857 | 6001317.37619782 | 2108550.87178 | 37.7697528504481 | -122.43878292419 | (37.7697528504481, -122.43878292419) | 15 | 5 | 5 | 29492 | 9 | ||
| 22974 | 65880 | Permitted Site 7 | Tree(s) :: 17 | 110 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | Permit Number 28882 | 6002383.11607234 | 2108865.27464949 | 37.770676696874 | -122.435119055267 | (37.770676696874, -122.435119055267) | 15 | 5 | 11 | 29492 | 9 | |||
| 23000 | 57779 | Permitted Site 7 | Tree(s) :: 17 | 1135 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1977 12:00:00 AM | Permit Number 17647 | 5998880.95748746 | 2105913.85882905 | 37.7623733650121 | -122.447020599599 | (37.7623733650121, -122.447020599599) | 15 | 5 | 11 | 29492 | 9 | |||
| 23013 | 62551 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | 15 | 5 | 11 | 29492 | 9 | ||
| 23122 | 56527 | Permitted Site 7 | Tree(s) :: 17 | 4712 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998598.83756135 | 2105705.90676234 | 37.7617862583341 | -122.447981370547 | (37.7617862583341, -122.447981370547) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );