Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77611 | 77611 | 102625 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 17346 | 6010349.4 | 2120908.5 | 37.804193651889 | -122.408413053021 | (37.804193651889, -122.408413053021) | ||
| 77612 | 77612 | 35515 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3384 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38917 | 6006486.65777804 | 2102632.29019792 | 37.7537945415914 | -122.42048231610201 | (37.7537945415914, -122.420482316102) | ||
| 77613 | 77613 | 94798 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495@Ulloa 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | ||
| 77614 | 77614 | 65560 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 310 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1990 12:00:00 AM | Permit Number 28459 | 5995012.80467967 | 2096143.76494049 | 37.735325388127606 | -122.459691319295 | (37.7353253881276, -122.459691319295) | ||
| 77615 | 77615 | 15817 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000711.60071 | 2089768.80667 | 37.71814727755579 | -122.439531669663 | (37.7181472775558, -122.439531669663) | ||
| 77616 | 77616 | 21117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
| 77617 | 77617 | 58838 | Permitted Site 1 | Tree(s) :: 17 | 1271 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1979 12:00:00 AM | Permit Number 18094 | 5983335.9289763 | 2106499.36834563 | 37.7630806124652 | -122.50082751272801 | (37.7630806124652, -122.500827512728) | |||
| 77618 | 77618 | 34735 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851001 | (37.7509115908716, -122.41496434851) | ||
| 77619 | 77619 | 30430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 418 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | Permit Number 83 | 6010919.16231667 | 2119684.73214888 | 37.8008653758927 | -122.40635505796301 | (37.8008653758927, -122.406355057963) | |||
| 77620 | 77620 | 66244 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | ||
| 77621 | 77621 | 60394 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1490 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19974 | 6015495.25589762 | 2094826.0117952998 | 37.7328636713029 | -122.38878332305599 | (37.7328636713029, -122.388783323056) | ||
| 77622 | 77622 | 45475 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1355 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44760 | 5999364.2117528 | 2089872.65901255 | 37.7183556553422 | -122.44419645780701 | (37.7183556553422, -122.444196457807) | ||
| 77623 | 77623 | 15092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 70 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6014509.9392 | 2116711.29875 | 37.79290123889 | -122.393721124469 | (37.79290123889, -122.393721124469) | |||
| 77624 | 77624 | 38448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 77625 | 77625 | 32027 | Permitted Site 1 | Tree(s) :: 17 | 910 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48084 | 6011969.92653518 | 2111658.90845523 | 37.77888708705839 | -122.402154376916 | (37.7788870870584, -122.402154376916) | |||
| 77626 | 77626 | 12619 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 805 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 5992948.7978300005 | 2114805.70413 | 37.786447275102 | -122.46818442350599 | (37.786447275102, -122.468184423506) | |||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 77628 | 77628 | 36000 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 131 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39149 | 6007256.30049385 | 2100148.76255182 | 37.747018680703896 | -122.417644695138 | (37.7470186807039, -122.417644695138) | ||
| 77629 | 77629 | 87016 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 77630 | 77630 | 43573 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 158 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43234 | 6004132.40466679 | 2101038.73757392 | 37.749286064647 | -122.428510284583 | (37.749286064647, -122.428510284583) | ||
| 77631 | 77631 | 52211 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | ||
| 77632 | 77632 | 110165 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129x GARCES DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||||
| 77633 | 77633 | 27357 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006189.18785 | 2114381.67214 | 37.786038772838296 | -122.422345784799 | (37.7860387728383, -122.422345784799) | |||
| 77634 | 77634 | 90408 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 77635 | 77635 | 2232 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1209 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3PL | 6000801.92517 | 2112828.28731 | 37.78146821443 | -122.44087273823799 | (37.78146821443, -122.440872738238) | |||
| 77636 | 77636 | 21048 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 2101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 77637 | 77637 | 11714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 77638 | 77638 | 39764 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | ||
| 77639 | 77639 | 58591 | Permitted Site 1 | Tree(s) :: 17 | 246 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | Permit Number 17791 | 5997582.85461659 | 2106170.83422874 | 37.7630047043289 | -122.451528768877 | (37.7630047043289, -122.451528768877) | |||
| 77640 | 77640 | 105838 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 39X Bonview St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6007716.90579 | 2099172.4114099997 | 37.7443637468546 | -122.415982827151 | (37.7443637468546, -122.415982827151) | ||||
| 77641 | 77641 | 59388 | Permitted Site 1 | Tree(s) :: 17 | 455 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | Permit Number 18742 | 6003712.37776626 | 2096164.54278764 | 37.7358788705594 | -122.429615164566 | (37.7358788705594, -122.429615164566) | |||
| 77642 | 77642 | 120125 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
| 77643 | 77643 | 64141 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 450 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31503 | 6003668.99323589 | 2098381.3149539 | 37.7419631631413 | -122.42992323768401 | (37.7419631631413, -122.429923237684) | ||
| 77644 | 77644 | 742 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 2101 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6 | 5985080.7039352 | 2100890.0347213 | 37.747781216484796 | -122.494379511431 | (37.7477812164848, -122.494379511431) | |||
| 77645 | 77645 | 34539 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3601 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38248 | 6008520.94384418 | 2098088.77509924 | 37.74143349287579 | -122.413126013386 | (37.7414334928758, -122.413126013386) | ||
| 77646 | 77646 | 58026 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.734908020909295 | -122.41251618319201 | (37.7349080209093, -122.412516183192) | ||
| 77647 | 77647 | 47952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 284 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45682 | 5997872.43575123 | 2096301.72488979 | 37.7359231369177 | -122.44981594322701 | (37.7359231369177, -122.449815943227) | ||
| 77648 | 77648 | 25821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 77649 | 77649 | 55751 | Permitted Site 1 | Tree(s) :: 17 | 319 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1973 12:00:00 AM | Permit Number 11784 | 6006579.23439853 | 2097315.79537163 | 37.739201866662896 | -122.419784951043 | (37.7392018666629, -122.419784951043) | |||
| 77650 | 77650 | 108872 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1317 Grove St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773401 | 6001507.20104 | 2110761.06824 | 37.775832295364104 | -122.438284688432 | (37.7758322953641, -122.438284688432) | |
| 77651 | 77651 | 98036 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 2242 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | Permit Number 768378 | 6002381.4 | 2115984.8 | 37.7902250230638 | -122.43563441767 | (37.7902250230638, -122.43563441767) | |||
| 77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 77654 | 77654 | 114537 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 1624 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | 3x4 | 6009248.6 | 2099914.9 | 37.74648845381439 | -122.41073895467 | (37.7464884538144, -122.41073895467) | |||
| 77655 | 77655 | 63138 | Permitted Site 1 | Tree(s) :: 17 | 90 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1986 12:00:00 AM | Permit Number 23658 | 6007312.55420039 | 2098857.14410413 | 37.7434753513127 | -122.41735865607001 | (37.7434753513127, -122.41735865607) | |||
| 77656 | 77656 | 49766 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 333 Schwerin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | ||
| 77657 | 77657 | 99736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
| 77658 | 77658 | 113049 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X LAIDLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003128.0 | 2096056.0 | 37.7355477305103 | -122.43162784146999 | (37.7355477305103, -122.43162784147) | ||||
| 77659 | 77659 | 7482 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 77660 | 77660 | 8017 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | |||
| 77661 | 77661 | 94252 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 77662 | 77662 | 60415 | Permitted Site 1 | Tree(s) :: 17 | 1514 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1982 12:00:00 AM | Permit Number 19996 | 6015715.89043664 | 2094311.73125073 | 37.7314637862557 | -122.387984651822 | (37.7314637862557, -122.387984651822) | |||
| 77663 | 77663 | 115778 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 1258 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772460 | 6014378.5 | 2090761.5 | 37.721641380247995 | -122.392360079917 | (37.721641380248, -122.392360079917) | ||
| 77664 | 77664 | 96104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
| 77665 | 77665 | 39143 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3330 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40820 | 6007564.50118808 | 2100613.04522011 | 37.7483108345809 | -122.416611844962 | (37.7483108345809, -122.416611844962) | |||
| 77666 | 77666 | 55148 | Permitted Site 1 | Tree(s) :: 17 | 638 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | Permit Number 11052 | 5993191.32234649 | 2111125.40566616 | 37.776356179458794 | -122.467077684606 | (37.7763561794588, -122.467077684606) | |||
| 77667 | 77667 | 4142 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 77668 | 77668 | 60011 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1255 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1982 12:00:00 AM | Permit Number 19497 | 5991082.34836837 | 2106871.19693577 | 37.7645533154057 | -122.47406267204398 | (37.7645533154057, -122.474062672044) | ||
| 77669 | 77669 | 82541 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 657 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52586 | 6004618.75767182 | 2111536.15402672 | 37.7781369742486 | -122.427576250385 | (37.7781369742486, -122.427576250385) | ||
| 77670 | 77670 | 59293 | Permitted Site 1 | Tree(s) :: 17 | 2238 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1980 12:00:00 AM | Permit Number 18630 | 6002854.57798819 | 2117868.1515112 | 37.7954230864895 | -122.434131950138 | (37.7954230864895, -122.434131950138) | |||
| 77671 | 77671 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 231 | 276 Yerba Buena Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5995080.66446 | 2095640.15746 | 37.733946507354396 | -122.459420244296 | (37.7339465073544, -122.459420244296) | ||||
| 77672 | 77672 | 99969 | Undocumented 2 | Tree(s) :: 17 | 2270 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2013 12:00:00 AM | Permit Number 767924 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||
| 77673 | 77673 | 94289 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147.0 | 2103917.0 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | ||
| 77674 | 77674 | 116662 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 77675 | 77675 | 3914 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 77676 | 77676 | 54333 | Permitted Site 1 | Tree(s) :: 17 | 1307 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1972 12:00:00 AM | Permit Number 10094 | 5994843.33332779 | 2106635.74898554 | 37.7641239793189 | -122.46103746711701 | (37.7641239793189, -122.461037467117) | |||
| 77677 | 77677 | 67084 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248004 | -122.417988384197 | (37.738413501248, -122.417988384197) | ||
| 77678 | 77678 | 50789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | ||
| 77679 | 77679 | 73660 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 77680 | 77680 | 63803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.41075136529899 | (37.7385764323817, -122.410751365299) | ||
| 77681 | 77681 | 22928 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 360 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 12 | 3X3 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | ||
| 77682 | 77682 | 87446 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1419X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6002388.02378 | 2093708.6990200002 | 37.729060607112395 | -122.434018479663 | (37.7290606071124, -122.434018479663) | ||
| 77683 | 77683 | 22980 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 09/30/2006 12:00:00 AM | 6 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 77684 | 77684 | 104322 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 90X Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002383.0 | 2106795.0 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | ||||
| 77685 | 77685 | 32251 | Permitted Site 1 | Tree(s) :: 17 | 1601 Mission St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | Permit Number 35559 | 6007188.44453353 | 2109602.50556833 | 37.7729726509951 | -122.41854960025 | (37.7729726509951, -122.41854960025) | |||
| 77686 | 77686 | 18442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 77687 | 77687 | 56464 | Permitted Site 1 | Tree(s) :: 17 | 2404 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992053.14461509 | 2099061.3372863 | 37.7431656625105 | -122.470136246201 | (37.7431656625105, -122.470136246201) | |||||
| 77688 | 77688 | 93269 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1730 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004618.0 | 2098811.0 | 37.743196678206296 | -122.42667246707799 | (37.7431966782063, -122.426672467078) | ||
| 77689 | 77689 | 47770 | Permitted Site 1 | Tree(s) :: 17 | 135 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2002 12:00:00 AM | Permit Number 45549 | 6004019.41405329 | 2097004.40656941 | 37.738202326151296 | -122.42861346779699 | (37.7382023261513, -122.428613467797) | |||
| 77690 | 77690 | 6329 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 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) | |
| 77692 | 77692 | 3754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1020 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 18 | 6012443.0515847 | 2103208.5839527003 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | |||
| 77693 | 77693 | 67983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31707 | 5996243.31807004 | 2090478.67458978 | 37.7198410887436 | -122.455027781571 | (37.7198410887436, -122.455027781571) | ||
| 77694 | 77694 | 44160 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 77695 | 77695 | 42820 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 77696 | 77696 | 50501 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 731 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47137 | 6002346.93991516 | 2089394.75729347 | 37.717213158613895 | -122.43385228911998 | (37.7172131586139, -122.43385228912) | ||
| 77697 | 77697 | 41837 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1225 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42225 | 5990765.08330187 | 2107058.41544257 | 37.7650489839866 | -122.475173663486 | (37.7650489839866, -122.475173663486) | ||
| 77698 | 77698 | 68120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.745340567320106 | -122.42120066595501 | (37.7453405673201, -122.421200665955) | ||
| 77699 | 77699 | 50634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 77700 | 77700 | 37051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.43023969551201 | (37.7427495797017, -122.430239695512) | ||
| 77701 | 77701 | 20565 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
| 77702 | 77702 | 69531 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 23 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1997 12:00:00 AM | Permit Number 38565 | 5995300.80915633 | 2090069.63363967 | 37.718663844062796 | -122.458256093312 | (37.7186638440628, -122.458256093312) | ||
| 77703 | 77703 | 92591 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 445 Wawona St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 77704 | 77704 | 111278 | DPW Maintained 3 | Thuja plicata :: Western Red Cedar 317 | 700X BOSWORTH ST | 16 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 77705 | 77705 | 35507 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | ||
| 77706 | 77706 | 114927 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 77707 | 77707 | 111573 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1x SUNSET BLVD OFF RAMP | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5984955.0 | 2095624.0 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | ||||
| 77708 | 77708 | 35666 | Permitted Site 1 | Tree(s) :: 17 | 500 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38979 | 6004103.98358838 | 2110453.97229752 | 37.77513643941779 | -122.42927985292499 | (37.7751364394178, -122.429279852925) | |||
| 77709 | 77709 | 91916 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1555 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5990949.753071 | 2106534.898314 | 37.763622247809295 | -122.47449673434299 | (37.7636222478093, -122.474496734343) | ||
| 77710 | 77710 | 6828 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) |
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");