Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 30701 | 30701 | 71808 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5989823.9383 | 2098417.3202 | 37.741268233056395 | -122.477797097779 | (37.7412682330564, -122.477797097779) | ||
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 35287 | 35287 | 35365 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | |
| 37316 | 37316 | 35009 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | ||
| 38136 | 38136 | 46819 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.020819999 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | |
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 47568 | 47568 | 54838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.773438741186204 | -122.44770637361201 | (37.7734387411862, -122.447706373612) | ||
| 47675 | 47675 | 176920 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 671 London St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6001061.12784 | 2089906.70665 | 37.718545806627205 | -122.43833338090299 | (37.7185458066272, -122.438333380903) | ||||
| 48721 | 48721 | 33958 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | ||
| 49002 | 49002 | 97113 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | |||
| 49423 | 49423 | 37645 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | |
| 51167 | 51167 | 32295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.40312032520201 | (37.7661293203346, -122.403120325202) | ||
| 54300 | 54300 | 227606 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | ||||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 55006 | 55006 | 35364 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.3243400003 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | |
| 55812 | 55812 | 50231 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | |
| 56357 | 56357 | 43807 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.677999999 | 2112363.29745 | 37.7794807721264 | -122.48353979825899 | (37.7794807721264, -122.483539798259) | |
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 57481 | 57481 | 35363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 5 | Permit Number 38825 | 6011873.19867 | 2103659.8662799997 | 37.7569181237816 | -122.401926543791 | (37.7569181237816, -122.401926543791) | |
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 60646 | 60646 | 191259 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 900x Carolina St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.39984551077299 | (37.7562963136528, -122.399845510773) | ||||
| 60958 | 60958 | 48733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.764210939174106 | -122.489081723593 | (37.7642109391741, -122.489081723593) | ||
| 61686 | 61686 | 105315 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | |||||
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 63792 | 63792 | 64471 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | ||
| 63865 | 63865 | 98154 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.2977400003 | 37.779377741026394 | -122.473802878969 | (37.7793777410264, -122.473802878969) | ||
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 66851 | 66851 | 191268 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | ||||
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 69112 | 69112 | 187585 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 748 University St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6008708.47344 | 2090752.4419999998 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | ||||
| 71525 | 71525 | 97676 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | ||||
| 73208 | 73208 | 49756 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.71760318852571 | -122.40264894398899 | (37.7176031885257, -122.402648943989) | |
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
| 77958 | 77958 | 31771 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 78213 | 78213 | 37034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 266 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.42577301954901 | (37.7422146471398, -122.425773019549) | ||
| 82228 | 82228 | 31734 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 82615 | 82615 | 105316 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | ||||
| 83118 | 83118 | 38678 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 87075 | 87075 | 52479 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | ||
| 88005 | 88005 | 30508 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.72681424554771 | -122.40864217293199 | (37.7268142455477, -122.408642172932) | ||
| 90324 | 90324 | 30582 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 90650 | 90650 | 30584 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 92160 | 92160 | 39928 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 92502 | 92502 | 101350 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 93338 | 93338 | 42428 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.45269862641099 | (37.7322374467316, -122.452698626411) | ||
| 94438 | 94438 | 41525 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.733693765900604 | -122.37859297315 | (37.7336937659006, -122.37859297315) | |||
| 95348 | 95348 | 97442 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 95736 | 95736 | 31792 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | ||
| 97690 | 97690 | 48988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.42535889959998 | (37.7454580443014, -122.4253588996) | ||
| 98035 | 98035 | 31731 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 99320 | 99320 | 31776 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 99776 | 99776 | 65445 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 922 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | ||
| 100674 | 100674 | 98153 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258.0 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | |||
| 100830 | 100830 | 31795 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | ||
| 102328 | 102328 | 34270 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 102408 | 102408 | 101353 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102904 | 102904 | 34272 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 105384 | 105384 | 55357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | |||
| 105518 | 105518 | 39927 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 105593 | 105593 | 31773 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 106270 | 106270 | 34269 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 107985 | 107985 | 92049 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 108210 | 108210 | 122590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6008161.0 | 2119143.0 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | |||||
| 110478 | 110478 | 30583 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 111098 | 111098 | 50485 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.720405949717104 | -122.45400837564699 | (37.7204059497171, -122.454008375647) | ||
| 111844 | 111844 | 37577 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | ||
| 114236 | 114236 | 30585 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 115996 | 115996 | 45704 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2923 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 44378 | 6009338.32453862 | 2102737.8165792 | 37.7542445851646 | -122.41062801127701 | (37.7542445851646, -122.410628011277) | ||
| 116693 | 116693 | 37466 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | ||
| 117577 | 117577 | 31772 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 119869 | 119869 | 30569 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | ||
| 120187 | 120187 | 36895 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39548 | 6001738.91463484 | 2103541.42716619 | 37.7560221127265 | -122.436966152078 | (37.7560221127265, -122.436966152078) | ||
| 122986 | 122986 | 38679 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 123726 | 123726 | 35235 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | |
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 126804 | 126804 | 44213 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | ||
| 127076 | 127076 | 45705 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.41055749570499 | (37.754248802934, -122.410557495705) | ||
| 132763 | 132763 | 48667 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.788997318923705 | -122.44815975037599 | (37.7889973189237, -122.448159750376) | ||
| 134345 | 134345 | 32357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452058998 | (37.7959569797808, -122.40333452059) | ||
| 135774 | 135774 | 39858 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | |
| 136981 | 136981 | 37644 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.460530001 | 2111993.16181 | 37.7785610650821 | -122.47776398494499 | (37.7785610650821, -122.477763984945) | |
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 143244 | 143244 | 34271 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 145061 | 145061 | 31775 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) |
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");