Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104270 | 104270 | 75029 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 122319 | 122319 | 103020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave property permits | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
| 140145 | 140145 | 103021 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 40X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave for old permit records | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
| 138577 | 138577 | 103085 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
| 141309 | 141309 | 103086 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
| 141848 | 141848 | 96914 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | |
| 112467 | 112467 | 54234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1270 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2010 12:00:00 AM | Permit Number 9974 | 5995196.04681137 | 2106906.46154553 | 37.7648875762272 | -122.45983715274201 | (37.7648875762272, -122.459837152742) | ||
| 125795 | 125795 | 54232 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.76494254532629 | -122.460021156774 | (37.7649425453263, -122.460021156774) | ||
| 140666 | 140666 | 54120 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 775 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/2000 12:00:00 AM | Permit Number 9853 | 5994299.65074367 | 2089905.11614326 | 37.7181545378086 | -122.461704745095 | (37.7181545378086, -122.461704745095) | ||
| 101331 | 101331 | 54097 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.759594708041796 | -122.441471294748 | (37.7595947080418, -122.441471294748) | ||
| 114923 | 114923 | 54029 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 270 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1996 12:00:00 AM | Permit Number 9749 | 6004544.38660798 | 2103986.94623016 | 37.757404461657295 | -122.42729562792101 | (37.7574044616573, -122.427295627921) | ||
| 134551 | 134551 | 54010 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1537 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 5 | Permit Number 9729 | 6012988.89964 | 2105636.75215 | 37.7624084228186 | -122.39820669870599 | (37.7624084228186, -122.398206698706) | |
| 51676 | 51676 | 54006 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3300 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 2 | Permit Number 9725 | 5985332.63941 | 2111140.64831 | 37.7759412831996 | -122.494263790905 | (37.7759412831996, -122.494263790905) | |
| 78811 | 78811 | 53975 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 568 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/11/1995 12:00:00 AM | Permit Number 9691 | 6011465.5040552 | 2109667.69940903 | 37.773391518391 | -122.40375923687799 | (37.773391518391, -122.403759236878) | ||
| 25717 | 25717 | 53974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 4 | Permit Number 9690 | 6009227.8600699995 | 2115996.16493 | 37.790642719446204 | -122.41194689162901 | (37.7906427194462, -122.411946891629) | |
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 107723 | 107723 | 53857 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | Permit Number 9566 | 6015422.17631644 | 2105692.8193858 | 37.76269760659729 | -122.38979473959 | (37.7626976065973, -122.38979473959) | ||
| 123573 | 123573 | 53770 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 316 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | Permit Number 9456 | 5992852.04223281 | 2094739.01017834 | 37.7313437896565 | -122.46705971241 | (37.7313437896565, -122.46705971241) | ||
| 112843 | 112843 | 53753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 119 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | Permit Number 9433 | 6007101.960026401 | 2098736.7446672 | 37.7431329104844 | -122.418078305823 | (37.7431329104844, -122.418078305823) | ||
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 3502 | 3502 | 35369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 628 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2005 12:00:00 AM | 8 | 5x9 | Permit Number 780712 | 6010944.29074 | 2105222.09895 | 37.76115577964 | -122.40524908009199 | (37.76115577964, -122.405249080092) |
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 3061 | 3061 | 61313 | Permitted Site 1 | Tree(s) :: 17 | 1355 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2017 12:00:00 AM | 3 | Permit Number 780590 | 6011741.38821 | 2102064.0767099997 | 37.752529078769896 | -122.402270200829 | (37.7525290787699, -122.402270200829) | |
| 3291 | 3291 | 41799 | Permitted Site 1 | Tree(s) :: 17 | 101 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780552 | 6011423.81805 | 2107722.81991 | 37.7680489940823 | -122.403766558473 | (37.7680489940823, -122.403766558473) |
| 2215 | 2215 | 62177 | Permitted Site 1 | Tree(s) :: 17 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 15 | 3x3 | Permit Number 780357 | 6000151.498869999 | 2091775.04378 | 37.723624054296295 | -122.44161159051599 | (37.7236240542963, -122.441611590516) |
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 2974 | 2974 | 68083 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 406 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 14 | Permit Number 780238 | 6000946.91691 | 2092398.9049099998 | 37.725382321520705 | -122.438906661816 | (37.7253823215207, -122.438906661816) | |
| 3912 | 3912 | 38150 | Permitted Site 1 | Tree(s) :: 17 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 12:00:00 AM | 3 | Permit Number 780230 | 6010281.37407 | 2093721.8548299999 | 37.7295415331127 | -122.40673134359899 | (37.7295415331127, -122.406731343599) | |
| 1863 | 1863 | 33121 | Permitted Site 1 | Tree(s) :: 17 | 2360 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2017 12:00:00 AM | 3 | Permit Number 780047 | 6001597.15977 | 2119079.49 | 37.7986776600995 | -122.438569654391 | (37.7986776600995, -122.438569654391) | |
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 1977 | 1977 | 35358 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 861 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2017 12:00:00 AM | 3 | Permit Number 779956 | 6011891.4551800005 | 2104381.4501400003 | 37.758900452609794 | -122.401914128638 | (37.7589004526098, -122.401914128638) | |
| 1250 | 1250 | 31791 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 186 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 779904 | 6001704.83909 | 2107714.56044 | 37.767478581987206 | -122.437382809181 | (37.7674785819872, -122.437382809181) | |
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 15812 | 15812 | 95581 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3881 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779561 | 6003940.0 | 2101864.0 | 37.7515411523314 | -122.429234461777 | (37.7515411523314, -122.429234461777) |
| 77 | 77 | 49739 | Permitted Site 1 | Tree(s) :: 17 | 145 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779552 | 6013462.1222 | 2106403.54987 | 37.764540227980206 | -122.396623740816 | (37.7645402279802, -122.396623740816) | |
| 10205 | 10205 | 34128 | Permitted Site 1 | Tree(s) :: 17 | 1401 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2017 12:00:00 AM | 3 | Permit Number 779521 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | |
| 71360 | 71360 | 78237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | Permit Number 779512 | 5999758.88688 | 2090259.2057 | 37.7194395330998 | -122.442859978114 | (37.7194395330998, -122.442859978114) | |
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 15519 | 15519 | 38776 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 660 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2017 12:00:00 AM | 3 | Permit Number 779488 | 6014510.81012 | 2111730.04342 | 37.7792239033058 | -122.39336936232999 | (37.7792239033058, -122.39336936233) | |
| 268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
| 2039 | 2039 | 45572 | Permitted Site 1 | Tree(s) :: 17 | 1951 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2017 12:00:00 AM | 3 | Permit Number 779446 | 5999433.18152 | 2115607.6653299998 | 37.7890216140951 | -122.44580786133999 | (37.7890216140951, -122.44580786134) | |
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 13258 | 13258 | 60325 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 335 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2017 12:00:00 AM | 3 | Permit Number 779431 | 5986505.891009999 | 2113659.48607 | 37.7829258811438 | -122.49039060665001 | (37.7829258811438, -122.49039060665) | |
| 9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
| 9949 | 9949 | 63390 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.734132412410396 | -122.416802921773 | (37.7341324124104, -122.416802921773) | |
| 9793 | 9793 | 43684 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 583 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779365 | 5993748.11926 | 2111537.7275799997 | 37.777520428161296 | -122.46518153966998 | (37.7775204281613, -122.46518153967) | |
| 10160 | 10160 | 37874 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10181 | 10181 | 37872 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10182 | 10182 | 37873 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 9780 | 9780 | 65693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779357 | 6005288.42845233 | 2101344.00549356 | 37.7501896116955 | -122.424534439725 | (37.7501896116955, -122.424534439725) |
| 13340 | 13340 | 42050 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13342 | 13342 | 42051 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13346 | 13346 | 42052 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13351 | 13351 | 42049 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 4088 | 4088 | 30930 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.45690211214199 | (37.7218954350219, -122.456902112142) |
| 11218 | 11218 | 68392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.0441299998 | 37.7296331848184 | -122.43667784142099 | (37.7296331848184, -122.436677841421) |
| 13316 | 13316 | 94652 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847.0 | 2095961.0 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) |
| 9831 | 9831 | 36377 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) |
| 9832 | 9832 | 36376 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | |
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 7637 | 7637 | 36881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | |
| 77691 | 77691 | 63661 | Permitted Site 1 | Tree(s) :: 17 | 478 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779161 | 6003414.6876897 | 2100122.82585576 | 37.7467305432329 | -122.43092680414699 | (37.7467305432329, -122.430926804147) | |
| 9041 | 9041 | 42494 | Permitted Site 1 | Tree(s) :: 17 | 698X Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779155 | 5996831.0 | 2094462.0 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | |
| 9688 | 9688 | 35795 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.75963284616879 | -122.42070069541 | (37.7596328461688, -122.42070069541) | ||
| 5410 | 5410 | 41173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.7499700002 | 37.801161655947396 | -122.446569707626 | (37.8011616559474, -122.446569707626) | |
| 110863 | 110863 | 121421 | Undocumented 2 | Tree(s) :: 17 | 301 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779128 | 6001229.40575975 | 2096509.00524046 | 37.736683779153104 | -122.438224431893 | (37.7366837791531, -122.438224431893) | |
| 22259 | 22259 | 32095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779125 | 6003421.63406 | 2105677.3546700003 | 37.761982358207796 | -122.431299212108 | (37.7619823582078, -122.431299212108) | |
| 139694 | 139694 | 121473 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 70 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778986 | 5996899.0 | 2114122.0 | 37.7847973525788 | -122.454468383435 | (37.7847973525788, -122.454468383435) |
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 10270 | 10270 | 41911 | Permitted Site 1 | Tree(s) :: 17 | 595 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2017 12:00:00 AM | 3 | Permit Number 778901 | 5992201.12975 | 2111434.05815 | 37.7771464503181 | -122.47052549063999 | (37.7771464503181, -122.47052549064) | |
| 82256 | 82256 | 46839 | Permitted Site 1 | Tree(s) :: 17 | 298 Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2016 12:00:00 AM | 3 | Permit Number 778889 | 6004393.42189905 | 2090714.06413365 | 37.72095160713771 | -122.42687247108401 | (37.7209516071377, -122.426872471084) | |
| 97730 | 97730 | 46838 | Permitted Site 1 | Tree(s) :: 17 | 298 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2016 12:00:00 AM | 3 | Permit Number 778889 | 6004393.42189905 | 2090714.06413365 | 37.72095160713771 | -122.42687247108401 | (37.7209516071377, -122.426872471084) | |
| 114018 | 114018 | 46837 | Permitted Site 1 | Tree(s) :: 17 | 298 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2016 12:00:00 AM | 3 | Permit Number 778889 | 6004393.42189905 | 2090714.06413365 | 37.72095160713771 | -122.42687247108401 | (37.7209516071377, -122.426872471084) | |
| 142057 | 142057 | 37538 | Permitted Site 1 | Tree(s) :: 17 | 620 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2016 12:00:00 AM | 3 | Permit Number 778882 | 6008292.72595773 | 2114178.69449063 | 37.785599879046 | -122.41505371562401 | (37.785599879046, -122.415053715624) | |
| 7584 | 7584 | 38094 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | |
| 116949 | 116949 | 41673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 69 Deming St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 778874 | 5999228.79012001 | 2105180.00479751 | 37.7603782511364 | -122.445764801622 | (37.7603782511364, -122.445764801622) | ||
| 116861 | 116861 | 39163 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 5 | Permit Number 778831 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) | |
| 85905 | 85905 | 40858 | Permitted Site 1 | Tree(s) :: 17 | 1670 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2016 12:00:00 AM | 3 | Permit Number 778806 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | |
| 93936 | 93936 | 32892 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) |
| 13361 | 13361 | 117223 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013667.943030001 | 2111389.10897 | 37.7782409101283 | -122.39626130683997 | (37.7782409101283, -122.39626130684) | |
| 13660 | 13660 | 117220 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013718.755890001 | 2111339.55053 | 37.7781076611892 | -122.39608205125799 | (37.7781076611892, -122.396082051258) | |
| 14154 | 14154 | 117219 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013733.69082 | 2111323.12296 | 37.7780633857557 | -122.39602923405701 | (37.7780633857557, -122.396029234057) | |
| 14214 | 14214 | 69442 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013823.57483 | 2111230.5410599997 | 37.777814177306 | -122.395711802165 | (37.777814177306, -122.395711802165) | |
| 14549 | 14549 | 117222 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013683.04729 | 2111373.4456700003 | 37.7781987427098 | -122.396207957236 | (37.7781987427098, -122.396207957236) | |
| 14702 | 14702 | 117215 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013784.57093 | 2111269.26347 | 37.7779183304931 | -122.395849445217 | (37.7779183304931, -122.395849445217) | |
| 15546 | 15546 | 117216 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013770.84151 | 2111284.28441 | 37.7779588107877 | -122.395897993299 | (37.7779588107877, -122.395897993299) | |
| 15669 | 15669 | 117221 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013696.95586 | 2111359.6496200003 | 37.778161635782396 | -122.39615887494499 | (37.7781616357824, -122.396158874945) | |
| 16129 | 16129 | 117218 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013744.24197 | 2111311.0843599997 | 37.7780309175198 | -122.395991889732 | (37.7780309175198, -122.395991889732) | |
| 16357 | 16357 | 117217 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013756.29755 | 2111297.17195 | 37.77799338791311 | -122.395949209701 | (37.7779933879131, -122.395949209701) | |
| 16504 | 16504 | 117214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013802.24625 | 2111251.09103 | 37.7778694163842 | -122.395787025958 | (37.7778694163842, -122.395787025958) | |
| 93511 | 93511 | 67139 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778711 | 5995503.40408063 | 2107002.8233616003 | 37.765169831893104 | -122.45878106616199 | (37.7651698318931, -122.458781066162) |
| 110512 | 110512 | 67719 | Permitted Site 1 | Tree(s) :: 17 | 130 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2016 12:00:00 AM | 3 | 5x3 | Permit Number 778704 | 5994504.48369031 | 2105343.24284692 | 37.760555588071206 | -122.462115700995 | (37.7605555880712, -122.462115700995) |
| 91264 | 91264 | 37274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3861 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778685 | 6002725.39128498 | 2102957.76189665 | 37.7544755272865 | -122.43351288179899 | (37.7544755272865, -122.433512881799) | |
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 92996 | 92996 | 94678 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 160 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778668 | 6004537.0 | 2097560.0 | 37.7397571378771 | -122.426863468968 | (37.7397571378771, -122.426863468968) |
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");