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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188126 | 188126 | 41204 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | 5 | Permit Number 41910 | 5993962.39394 | 2115424.11607 | 37.7882037522081 | -122.46472258678001 | (37.7882037522081, -122.46472258678) | ||
| 188115 | 188115 | 31154 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 259 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34857 | 5998376.74156 | 2093783.98497 | 37.7290388606445 | -122.447891156156 | (37.7290388606445, -122.447891156156) | |
| 188110 | 188110 | 68454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1993 12:00:00 AM | 8 | Permit Number 32316 | 6005458.13045 | 2117201.77806 | 37.7937408128466 | -122.425075777637 | (37.7937408128466, -122.425075777637) | ||
| 188109 | 188109 | 54813 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 330 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 10 | Permit Number 10667 | 5997647.89997 | 2115270.3728099996 | 37.7879934021327 | -122.451960326717 | (37.7879934021327, -122.451960326717) | ||
| 188104 | 188104 | 50580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | 8 | Permit Number 56162 | 6006391.85485 | 2121486.039 | 37.805557008807504 | -122.422149515895 | (37.8055570088075, -122.422149515895) | ||
| 188103 | 188103 | 62253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 415 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 3 | Permit Number 22379 | 6000969.7318400005 | 2092330.5175599998 | 37.7251958434923 | -122.43882289446998 | (37.7251958434923, -122.43882289447) | |
| 188098 | 188098 | 60322 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 390 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1982 12:00:00 AM | 15 | Permit Number 19892 | 5986562.51313 | 2113318.43854 | 37.7819927692214 | -122.490169625577 | (37.7819927692214, -122.490169625577) | |
| 188086 | 188086 | 65745 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.5194400002 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | |
| 188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
| 188077 | 188077 | 69403 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33507 | 6001071.30066 | 2087381.77877 | 37.7116134968267 | -122.438117445581 | (37.7116134968267, -122.438117445581) | |
| 188076 | 188076 | 40714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 634 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2006 12:00:00 AM | 8 | Permit Number 48841 | 5994113.99611 | 2111184.89224 | 37.7765727285077 | -122.463890241988 | (37.7765727285077, -122.463890241988) | |
| 188068 | 188068 | 55353 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 599 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 12 | Permit Number 11286 | 5993748.41208 | 2113470.19668 | 37.782826483510796 | -122.465320934842 | (37.7828264835108, -122.465320934842) | ||
| 188053 | 188053 | 66364 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1991 12:00:00 AM | 4 | Permit Number 29965 | 5991908.34552 | 2112195.95462 | 37.7792214762424 | -122.471593848027 | (37.7792214762424, -122.471593848027) | ||
| 188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
| 188014 | 188014 | 113280 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6003340.59835 | 2118579.59665 | 37.7974041031652 | -122.432501080454 | (37.7974041031652, -122.432501080454) | ||||
| 188003 | 188003 | 34259 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.46453448944901 | (37.7855927810379, -122.464534489449) | |
| 188001 | 188001 | 99377 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 109 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3 | 4x4 | Permit Number 768808 | 5998465.05526 | 2116051.39793 | 37.7901846614444 | -122.44918941746799 | (37.7901846614444, -122.449189417468) | |
| 187987 | 187987 | 67399 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 578 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 10 | Permit Number 30896 | 5990663.42796 | 2111452.2295 | 37.7771073100211 | -122.475846159065 | (37.7771073100211, -122.475846159065) | |
| 187984 | 187984 | 33233 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 4 | Permit Number 49352 | 5988969.8261 | 2097510.338 | 37.7387282896824 | -122.480683899813 | (37.7387282896824, -122.480683899813) | |
| 187976 | 187976 | 66133 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 64 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 13 | Permit Number 29195 | 6001738.9264 | 2120869.24898 | 37.8035999293564 | -122.438207379562 | (37.8035999293564, -122.438207379562) | ||
| 187953 | 187953 | 55331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.3008700002 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | ||
| 187950 | 187950 | 45592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1767 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44328 | 5985625.0375 | 2103206.7223 | 37.754174049116294 | -122.492667858454 | (37.7541740491163, -122.492667858454) | |
| 187936 | 187936 | 38624 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.728345567294795 | -122.386147618696 | (37.7283455672948, -122.386147618696) | |
| 187930 | 187930 | 63653 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3400 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | 5 | Permit Number 24300 | 5983704.2368 | 2104292.0530000003 | 37.7570415630367 | -122.49939055504 | (37.7570415630367, -122.49939055504) | |
| 187928 | 187928 | 48397 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3919 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45779 | 5995985.21505 | 2115508.15533 | 37.7885509137416 | -122.457730095228 | (37.7885509137416, -122.457730095228) | |
| 187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
| 187894 | 187894 | 43883 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2721 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 6 | Permit Number 43581 | 5996517.80334 | 2111258.1735 | 37.7769121727044 | -122.455580124025 | (37.7769121727044, -122.455580124025) | ||
| 187886 | 187886 | 62312 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 530 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | 16 | Permit Number 22450 | 5994400.4203 | 2111897.3678599996 | 37.778545498008796 | -122.462951128825 | (37.7785454980088, -122.462951128825) | |
| 187880 | 187880 | 83324 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 354 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 4x3 | 5987173.082 | 2113552.1603 | 37.782670140120295 | -122.48807454413901 | (37.7826701401203, -122.488074544139) | ||
| 187855 | 187855 | 43414 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 246 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43159 | 6013391.0866 | 2114213.64892 | 37.785981038638894 | -122.397417197364 | (37.7859810386389, -122.397417197364) | ||
| 187844 | 187844 | 64559 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.774506509156204 | -122.442246634385 | (37.7745065091562, -122.442246634385) | |
| 187842 | 187842 | 57867 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2078 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53494 | 6003110.24385 | 2118247.73617 | 37.7964798348222 | -122.433274440777 | (37.7964798348222, -122.433274440777) | |
| 187827 | 187827 | 60085 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1262 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 13 | Permit Number 19586 | 5988964.5748 | 2106737.2244 | 37.7640625606181 | -122.48137758100401 | (37.7640625606181, -122.481377581004) | |
| 187821 | 187821 | 54669 | Permitted Site 1 | Ilex aquifolium :: European Holly 277 | 287 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1993 12:00:00 AM | 20 | Permit Number 31959 | 6012184.41034 | 2087347.4133099997 | 37.7121449026495 | -122.399704913465 | (37.7121449026495, -122.399704913465) | ||
| 187816 | 187816 | 43812 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43443 | 5990206.91027 | 2114192.65817 | 37.7846052867946 | -122.477625737803 | (37.7846052867946, -122.477625737803) | ||
| 187814 | 187814 | 102790 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 42050 | 5983633.0 | 2103554.0 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | |||
| 187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
| 187804 | 187804 | 52942 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 71 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | Permit Number 48929 | 6002252.43026 | 2093269.9255099997 | 37.727848138461 | -122.434455877432 | (37.727848138461, -122.434455877432) | |
| 187774 | 187774 | 47461 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1818 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45366 | 6000024.694680001 | 2115221.2908900003 | 37.787994486693 | -122.443733540863 | (37.787994486693, -122.443733540863) | |
| 187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
| 187762 | 187762 | 101517 | Permitted Site 1 | Tree(s) :: 17 | 170 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 15 | 3x3 | Permit Number 769472 | 6010021.5 | 2121128.5 | 37.804779349428294 | -122.409563317566 | (37.8047793494283, -122.409563317566) | |
| 187757 | 187757 | 87922 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1395 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50946 | 5999715.0612 | 2113582.0975 | 37.78347602281 | -122.44468694783998 | (37.78347602281, -122.44468694784) | |
| 187730 | 187730 | 41756 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | ||
| 187727 | 187727 | 52853 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1334@ IRVING 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | Permit Number 48861 | 5983712.5574 | 2106045.4474 | 37.761856379175896 | -122.499491355681 | (37.7618563791759, -122.499491355681) | ||
| 187724 | 187724 | 51378 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 356 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52402 | 6008451.43576 | 2108652.78079 | 37.77043595219121 | -122.414113542812 | (37.7704359521912, -122.414113542812) | |
| 187721 | 187721 | 94282 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 5998306.81105 | 2115836.29563 | 37.789584995308296 | -122.449721420432 | (37.7895849953083, -122.449721420432) | ||||
| 187716 | 187716 | 56729 | Permitted Site 1 | Tree(s) :: 17 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | ||
| 187712 | 187712 | 42534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 616 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42640 | 6009431.8080400005 | 2111539.80243 | 37.778418054096605 | -122.41092635717199 | (37.7784180540966, -122.410926357172) | ||
| 187708 | 187708 | 96682 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985880.71623 | 2113435.4542400003 | 37.7822742209113 | -122.492536917229 | (37.7822742209113, -122.492536917229) | ||
| 187706 | 187706 | 55001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.777706381155205 | -122.474810664746 | (37.7777063811552, -122.474810664746) | ||
| 187704 | 187704 | 58265 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3773 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1979 12:00:00 AM | 8 | Permit Number 18039 | 5996781.674769999 | 2115294.23702 | 37.7880092733608 | -122.45495901893999 | (37.7880092733608, -122.45495901894) | ||
| 187699 | 187699 | 62284 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 11 | Permit Number 22422 | 5996159.215890001 | 2112395.0855799997 | 37.780013249453795 | -122.456902830387 | (37.7800132494538, -122.456902830387) | |
| 187696 | 187696 | 64369 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | |
| 187685 | 187685 | 51375 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 548 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 3 | Permit Number 47708 | 6009914.05728 | 2108346.99937 | 37.769678390277 | -122.40903272848499 | (37.769678390277, -122.409032728485) | ||
| 187676 | 187676 | 58061 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1726 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 11 | Permit Number 17031 | 5999586.8326 | 2114838.9116 | 37.786919589274504 | -122.445220957582 | (37.7869195892745, -122.445220957582) | ||
| 187670 | 187670 | 42671 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.9274699995 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | |
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
| 187635 | 187635 | 41263 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2430 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | 8 | Permit Number 41950 | 6007052.18114 | 2120671.77147 | 37.8033584595886 | -122.41980654544099 | (37.8033584595886, -122.419806545441) | ||
| 187632 | 187632 | 68261 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 331 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 4 | Permit Number 32067 | 6009662.93548 | 2092873.24927 | 37.72717681975 | -122.40880951134301 | (37.72717681975, -122.408809511343) | |
| 187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) | |
| 187611 | 187611 | 51093 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Waterville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 4 | Permit Number 47550 | 6011455.69814 | 2095723.6306 | 37.7351036250145 | -122.402812291464 | (37.7351036250145, -122.402812291464) | ||
| 187608 | 187608 | 92252 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1558 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52702 | 5985620.6386 | 2104602.1565 | 37.7580052698857 | -122.492785843667 | (37.7580052698857, -122.492785843667) | |
| 187601 | 187601 | 32793 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1654 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 4 | Permit Number 37156 | 5999891.09612214 | 2110582.97970989 | 37.775251258450204 | -122.443862391105 | (37.7752512584502, -122.443862391105) | |
| 187591 | 187591 | 84413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 738 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51575 | 5994139.251180001 | 2110527.76109 | 37.7747698770868 | -122.463755171286 | (37.7747698770868, -122.463755171286) | |
| 187582 | 187582 | 92421 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1746 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52814 | 5984424.3211 | 2103274.5158 | 37.7542899093449 | -122.496825171857 | (37.7542899093449, -122.496825171857) |
| 187576 | 187576 | 31742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2683 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35232 | 5990177.71472403 | 2097127.35673415 | 37.7377468512318 | -122.47647966560899 | (37.7377468512318, -122.476479665609) | |
| 187574 | 187574 | 31676 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770730 | 6001735.33868 | 2121814.4309799997 | 37.806194943810894 | -122.438287548749 | (37.8061949438109, -122.438287548749) | |||
| 187573 | 187573 | 104823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 641 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | 3x3 | Permit Number 771081 | 5987509.53271 | 2111566.66512 | 37.7772381546113 | -122.48676473846001 | (37.7772381546113, -122.48676473846) | |
| 187568 | 187568 | 40690 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 190 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 12 | 5x10 | Permit Number 41673 | 6004620.52288 | 2094031.3393400002 | 37.730072951499 | -122.42632351321998 | (37.730072951499, -122.42632351322) |
| 187556 | 187556 | 38132 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 11 | Permit Number 40294 | 6010207.56655 | 2094013.9745900002 | 37.7303395024441 | -122.407007086532 | (37.7303395024441, -122.407007086532) | |
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) | |
| 187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
| 187526 | 187526 | 57964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 356 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 18 | Permit Number 16924 | 5999367.58813 | 2086445.59865 | 37.7089459151864 | -122.44393869062799 | (37.7089459151864, -122.443938690628) | ||
| 187501 | 187501 | 92258 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | |
| 187485 | 187485 | 55910 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3646 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1973 12:00:00 AM | 7 | Permit Number 11968 | 5999164.92629 | 2121362.0715400004 | 37.8048063563971 | -122.447150284777 | (37.8048063563971, -122.447150284777) | ||
| 187482 | 187482 | 32718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 13 | Permit Number 37112 | 6008124.13541 | 2116125.0175900003 | 37.790934532354605 | -122.415774856832 | (37.7909345323546, -122.415774856832) | |
| 187481 | 187481 | 57664 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1976 12:00:00 AM | 7 | Permit Number 16566 | 6001568.8356 | 2114688.8156 | 37.786620397604295 | -122.438352937221 | (37.7866203976043, -122.438352937221) | ||
| 187473 | 187473 | 60579 | Permitted Site 1 | Tristania conferta :: 79 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | |
| 187467 | 187467 | 30971 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1918 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 21 | Permit Number 34762 | 6004982.43732 | 2117138.20342 | 37.79353937010811 | -122.426717189659 | (37.7935393701081, -122.426717189659) | |
| 187452 | 187452 | 67020 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 149 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 6 | Permit Number 32112 | 5990819.4847800005 | 2114429.04391 | 37.785289865300996 | -122.475523724044 | (37.785289865301, -122.475523724044) | |
| 187451 | 187451 | 44412 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43763 | 6002334.21635 | 2087134.94604 | 37.7110074922697 | -122.43373484600201 | (37.7110074922697, -122.433734846002) | |
| 187426 | 187426 | 85231 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49539 | 6013350.68536 | 2109356.01998 | 37.772640849735396 | -122.39721622315001 | (37.7726408497354, -122.39721622315) | ||
| 187404 | 187404 | 31226 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34913 | 5992091.73833 | 2097813.94877 | 37.7397428821404 | -122.469911998937 | (37.7397428821404, -122.469911998937) | |
| 187398 | 187398 | 68529 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 614 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 10 | Permit Number 32410 | 5994730.36077 | 2111314.5868 | 37.776964335760496 | -122.461767479865 | (37.7769643357605, -122.461767479865) | |
| 187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) | |
| 187355 | 187355 | 50504 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 9 | Permit Number 47140 | 6001297.56946 | 2089761.94857 | 37.7181617790314 | -122.437505740198 | (37.7181617790314, -122.437505740198) | |
| 187344 | 187344 | 31692 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 61 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 7 | Permit Number 35553 | 5998816.4378 | 2107906.1796 | 37.767840090069896 | -122.44738715512501 | (37.7678400900699, -122.447387155125) | |
| 187342 | 187342 | 65766 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | |
| 187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
| 187334 | 187334 | 101118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1239 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 17026 | 5990136.9434 | 2103098.5473 | 37.7541398185385 | -122.477056838029 | (37.7541398185385, -122.477056838029) | |||
| 187333 | 187333 | 58713 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 680 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1979 12:00:00 AM | 14 | Permit Number 17947 | 6004611.37306 | 2110893.76935 | 37.7763727259597 | -122.427556018821 | (37.7763727259597, -122.427556018821) | ||
| 187325 | 187325 | 48432 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1190 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2002 12:00:00 AM | 11 | Permit Number 45810 | 6009089.71563 | 2116719.69738 | 37.7926216119548 | -122.41247603116501 | (37.7926216119548, -122.412476031165) | ||
| 187324 | 187324 | 60799 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 275 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 5 | Permit Number 20474 | 5998494.132 | 2112280.5701 | 37.7798326205261 | -122.448817090257 | (37.7798326205261, -122.448817090257) | |
| 187312 | 187312 | 88052 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1636 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51062 | 6014945.3864 | 2094540.9532 | 37.732050466410705 | -122.39066446510401 | (37.7320504664107, -122.390664465104) | |
| 187307 | 187307 | 44187 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 248 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 3 | Permit Number 44776 | 5990894.1972 | 2113727.7318 | 37.783368588065706 | -122.47521402717399 | (37.7833685880657, -122.475214027174) | |
| 187303 | 187303 | 44110 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2355 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | 8 | Permit Number 43620 | 6002314.9262 | 2117740.34461 | 37.7950415194118 | -122.43599008309401 | (37.7950415194118, -122.435990083094) | ||
| 187296 | 187296 | 32212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 6 | Permit Number 35533 | 6009893.25149 | 2099852.66085 | 37.746353682475096 | -122.408505421789 | (37.7463536824751, -122.408505421789) | |
| 187293 | 187293 | 93552 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2255 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2010 12:00:00 AM | 16 | 3x3 | Permit Number 53247 | 5999300.87312 | 2116569.26617 | 37.7916543614119 | -122.446334832597 | (37.7916543614119, -122.446334832597) |
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");