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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 107595 | 107595 | 98272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | ||
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 79389 | 79389 | 98269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscape plot | Permit Number 768491 | 6009963.0 | 2103401.0 | 37.7561005415225 | -122.40851449565001 | (37.7561005415225, -122.40851449565) | |
| 125626 | 125626 | 49691 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2003 12:00:00 AM | tx5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |
| 113240 | 113240 | 67948 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | ex3 | Permit Number 31662 | 5988736.13806 | 2111981.42447 | 37.778448401356705 | -122.48255196765498 | (37.7784484013567, -122.482551967655) |
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 3187 | 3187 | 207331 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 432 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 8 | Width 8ft | Permit Number 45704 | 6000124.74065 | 2095150.49618 | 37.7328907415174 | -122.441946248045 | (37.7328907415174, -122.441946248045) | |
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 4112 | 4112 | 226674 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 145 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 18 | Width 7ft | Permit Number 21993 | 6005571.69833 | 2100193.82022 | 37.747047459974 | -122.423473113803 | (37.747047459974, -122.423473113803) | |
| 544 | 544 | 224355 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 23 | Width 6ft | Permit Number 16120 | 6005992.7506800005 | 2106707.14788 | 37.7649553019752 | -122.42247988543501 | (37.7649553019752, -122.422479885435) | |
| 2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
| 2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
| 2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
| 2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
| 3095 | 3095 | 204715 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 327 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3 | Width 6ft | Permit Number 51243 | 5996623.78142 | 2106956.86791 | 37.7651079834665 | -122.454902653043 | (37.7651079834665, -122.454902653043) | |
| 3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 179118 | 179118 | 126319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 752 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 6010083.7089 | 2116366.9037599997 | 37.7917086579707 | -122.409011858816 | (37.7917086579707, -122.409011858816) | |||
| 1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
| 1005 | 1005 | 131220 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 411 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1994 12:00:00 AM | 8 | Width 5ft | Permit Number 33166 | 6008433.24487 | 2113895.82908 | 37.7848310944226 | -122.414547535863 | (37.7848310944226, -122.414547535863) | |
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 1215 | 1215 | 218931 | Permitted Site 1 | Tree(s) :: 17 | 1353 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779656 | 5994855.14791 | 2106335.8141799998 | 37.7633011159875 | -122.460974863827 | (37.7633011159875, -122.460974863827) | |
| 1512 | 1512 | 243955 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.3814199995 | 2109908.18867 | 37.773804548164705 | -122.419028109365 | (37.7738045481647, -122.419028109365) | |
| 1514 | 1514 | 243952 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.41915431212601 | (37.7741761624211, -122.419154312126) | |
| 1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
| 1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
| 1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
| 1519 | 1519 | 243949 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.017419999 | 2110160.92453 | 37.7744951573695 | -122.41925139124399 | (37.7744951573695, -122.419251391244) | |
| 1521 | 1521 | 243954 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.773917457170796 | -122.41905723302 | (37.7739174571708, -122.41905723302) | |
| 1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
| 1917 | 1917 | 125217 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | Permit Number 768908 | 6005070.35193 | 2116772.06135 | 37.79253900653 | -122.426386916319 | (37.79253900653, -122.426386916319) | ||
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 1991 | 1991 | 123758 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5994989.32477 | 2110751.87532 | 37.7754341833406 | -122.46083085861 | (37.7754341833406, -122.46083085861) | |||
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
| 2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2390 | 2390 | 201832 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.727795861786205 | -122.370472171548 | (37.7277958617862, -122.370472171548) | |
| 2400 | 2400 | 201838 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.37077139578501 | (37.7274339035298, -122.370771395785) | |
| 2406 | 2406 | 201829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.7945400001 | 37.7281471046068 | -122.37015664263399 | (37.7281471046068, -122.370156642634) | |
| 2411 | 2411 | 201831 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.8842900002 | 37.7278602487283 | -122.37041936696698 | (37.7278602487283, -122.370419366967) | |
| 2419 | 2419 | 201835 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.72760966254629 | -122.370626184075 | (37.7276096625463, -122.370626184075) | |
| 2423 | 2423 | 201830 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | |
| 2435 | 2435 | 201826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | |
| 2444 | 2444 | 201828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.3694799999 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | |
| 2446 | 2446 | 201827 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | |
| 2452 | 2452 | 201837 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | |
| 2453 | 2453 | 201836 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | |
| 2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
| 2460 | 2460 | 201825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.1924700001 | 37.7284547293849 | -122.36988121894899 | (37.7284547293849, -122.369881218949) | |
| 2461 | 2461 | 201834 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | |
| 2515 | 2515 | 124752 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | ||
| 3590 | 3590 | 246905 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5997325.00222 | 2107400.6153700002 | 37.76636660087539 | -122.45250934033501 | (37.7663666008754, -122.452509340335) | |||
| 3609 | 3609 | 246906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 491 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2010 12:00:00 AM | 3 | Width 5ft | Permit Number 53958 | 5997348.6484 | 2107404.24528 | 37.7663779224388 | -122.45242781498699 | (37.7663779224388, -122.452427814987) | |
| 4023 | 4023 | 232380 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6001617.91184 | 2102022.2796 | 37.7518440201921 | -122.437275848296 | (37.7518440201921, -122.437275848296) | |||
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 538 | 538 | 224356 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3122 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | Width 4ft | Permit Number 16121 | 6005963.44888 | 2106707.74991 | 37.7649553019601 | -122.422581275918 | (37.7649553019601, -122.422581275918) | |
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 559 | 559 | 224354 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 21 | Width 4ft | Permit Number 16115 | 6006614.25148 | 2106740.2812200002 | 37.7650813194782 | -122.420332618267 | (37.7650813194782, -122.420332618267) | |
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 1563 | 1563 | 125822 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2301 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003751.95692 | 2115935.8856900004 | 37.7901684673368 | -122.43088890270398 | (37.7901684673368, -122.430888902704) | |||
| 1844 | 1844 | 240844 | Permitted Site 1 | Styphnolobium japonicum :: Chinese scholar tree 156 | 2512 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1992 12:00:00 AM | 11 | Width 4ft | Permit Number 30823 | 6011341.20529 | 2101862.92497 | 37.7519544137647 | -122.403639957344 | (37.7519544137647, -122.403639957344) | |
| 1884 | 1884 | 236583 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 5 | Width 4ft | Permit Number 779645 | 6009295.1552099995 | 2105340.17803 | 37.7613876608276 | -122.41096109620001 | (37.7613876608276, -122.4109610962) | |
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | |
| 2018 | 2018 | 238617 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 5 | Width 4ft | Permit Number 769743 | 6001157.09349 | 2101748.35409 | 37.751065679453504 | -122.438849790481 | (37.7510656794535, -122.438849790481) | |
| 2069 | 2069 | 129587 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.79668221737371 | -122.43067024784901 | (37.7966822173737, -122.430670247849) | |
| 2072 | 2072 | 136839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1911 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | Width 4ft | Permit Number 52344 | 6003883.81928 | 2118306.5649 | 37.7966852175075 | -122.43060190297199 | (37.7966852175075, -122.430601902972) | |
| 2157 | 2157 | 127892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133534999 | (37.7994012851886, -122.40934133535) | |
| 2161 | 2161 | 127894 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010099.45524 | 2119176.61212 | 37.7994243150494 | -122.40915572694999 | (37.7994243150494, -122.40915572695) | |||
| 2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
| 2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | |
| 2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | |
| 2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
| 2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | |
| 2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
| 2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
| 2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | |
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 2430 | 2430 | 201600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020594.26008 | 2092766.53995 | 37.7274900446232 | -122.371012172182 | (37.7274900446232, -122.371012172182) | |
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2441 | 2441 | 201599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020607.895690001 | 2092757.2128700002 | 37.72746518285071 | -122.37096438849899 | (37.7274651828507, -122.370964388499) | |
| 2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
| 2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
| 2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) | |
| 2491 | 2491 | 235511 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1002 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | 25 | Width 4ft | Permit Number 20185 | 5998857.80295 | 2106434.63527 | 37.7638019637156 | -122.4471381628 | (37.7638019637156, -122.4471381628) | |
| 2636 | 2636 | 239448 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 11 | Width 4ft | Permit Number 38139 | 6004193.01737 | 2096717.47365 | 37.7374242967807 | -122.427992792539 | (37.7374242967807, -122.427992792539) | |
| 2752 | 2752 | 204285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 130 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 0 | Width 4ft | Permit Number 778704 | 5994440.258090001 | 2105345.9021900003 | 37.7605591918785 | -122.462338019278 | (37.7605591918785, -122.462338019278) | |
| 2800 | 2800 | 248806 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1039 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 18 | Width 4ft | Permit Number 17875 | 5997248.91757 | 2106862.4287 | 37.7648845181415 | -122.45273365463001 | (37.7648845181415, -122.45273365463) |
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");