Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104 | 104 | 251210 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | |||||||||
| 6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
| 7152 | 7152 | 29781 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 3 | 6006021.95745 | 2117391.75426 | 37.7942942736085 | -122.42313839334601 | (37.7942942736085, -122.423138393346) | |||
| 8274 | 8274 | 41820 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.683999999 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | |
| 12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
| 22882 | 22882 | 176369 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.47481676917101 | (37.7159609464097, -122.474816769171) | ||||
| 23961 | 23961 | 247944 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 21 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010317.99645 | 2098902.9194900002 | 37.7437696775404 | -122.40696976733999 | (37.7437696775404, -122.40696976734) | ||||
| 24685 | 24685 | 32723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1082 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | Permit Number 37114 | 6007012.43686 | 2114697.78275 | 37.786953139214894 | -122.419519994465 | (37.7869531392149, -122.419519994465) | |
| 25083 | 25083 | 250988 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981857.67732 | 2112961.27677 | 37.780736228431394 | -122.50641942431999 | (37.7807362284314, -122.50641942432) | ||||
| 25469 | 25469 | 224313 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6003370.69781 | 2095579.24653 | 37.734252427487895 | -122.43075473197099 | (37.7342524274879, -122.430754731971) | ||||
| 26530 | 26530 | 32698 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 665 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37104 | 6008567.49434 | 2114513.32482 | 37.7865341297888 | -122.41412677632799 | (37.7865341297888, -122.414126776328) | |
| 26599 | 26599 | 176373 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Higuera Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5987816.39494 | 2090204.8052400001 | 37.7186020727071 | -122.484136269073 | (37.7186020727071, -122.484136269073) | ||||
| 27432 | 27432 | 66268 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2008 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1990 12:00:00 AM | 12 | Permit Number 29375 | 5986711.6119 | 2096941.9622 | 37.7370361716902 | -122.488449873835 | (37.7370361716902, -122.488449873835) | ||
| 29272 | 29272 | 206257 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998979.032869999 | 2094999.63504 | 37.7324111582444 | -122.44589639242099 | (37.7324111582444, -122.445896392421) | ||||
| 30141 | 30141 | 42966 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.75959819679839 | -122.45063741216002 | (37.7595981967984, -122.45063741216) | |||
| 30876 | 30876 | 37950 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 17 | Permit Number 40190 | 6013298.71774 | 2104246.1656 | 37.7586074292188 | -122.397037638472 | (37.7586074292188, -122.397037638472) | |
| 30956 | 30956 | 191848 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1951 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6013055.009930001 | 2095902.15156 | 37.735682976376204 | -122.397295372485 | (37.7356829763762, -122.397295372485) | ||||
| 32359 | 32359 | 191816 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300x De Haro St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012277.20441 | 2102232.55885 | 37.7530215888816 | -122.40042907904899 | (37.7530215888816, -122.400429079049) | ||||
| 35071 | 35071 | 176378 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989827.05129 | 2090325.18948 | 37.7190494782331 | -122.477195118066 | (37.7190494782331, -122.477195118066) | ||||
| 35275 | 35275 | 223973 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3977 22nd St | 3 | : 4 | Tree 1 | Private 1 | 15 | 6001912.30882 | 2102919.7297900002 | 37.754324934974704 | -122.436322006668 | (37.7543249349747, -122.436322006668) | ||||
| 35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
| 36064 | 36064 | 73981 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1020 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 22 | 6007232.56543 | 2114727.7662400003 | 37.7870478630276 | -122.418760525075 | (37.7870478630276, -122.418760525075) | ||
| 36449 | 36449 | 176377 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989839.20092 | 2090334.4554299999 | 37.7190756251255 | -122.47715379871201 | (37.7190756251255, -122.477153798712) | ||||
| 37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
| 37807 | 37807 | 32670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 25 | Permit Number 37094 | 6011135.7894 | 2112024.86418 | 37.7798453222359 | -122.405065778479 | (37.7798453222359, -122.405065778479) | |
| 37941 | 37941 | 201685 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 08th St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6010307.98401 | 2109858.68813 | 37.773851197808206 | -122.407776750616 | (37.7738511978082, -122.407776750616) | ||||
| 38233 | 38233 | 191806 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 347 San Bruno Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010921.55784 | 2106905.85989 | 37.7657777364646 | -122.405446288816 | (37.7657777364646, -122.405446288816) | ||||
| 38245 | 38245 | 206256 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 52 Burnside Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001149.03132 | 2095735.7759900002 | 37.7345560997669 | -122.438446938292 | (37.7345560997669, -122.438446938292) | ||||
| 40072 | 40072 | 37951 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 12 | Permit Number 40190 | 6013298.65055 | 2104257.08873 | 37.7586374180095 | -122.397038636728 | (37.7586374180095, -122.397038636728) | |
| 40488 | 40488 | 32598 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985603.1005 | 2105094.5695 | 37.759356274150704 | -122.492882766578 | (37.7593562741507, -122.492882766578) | ||
| 41196 | 41196 | 209133 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6001054.84945 | 2095714.1457200001 | 37.734491350384005 | -122.43877100628 | (37.734491350384, -122.43877100628) | ||||
| 41375 | 41375 | 45055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | ||
| 43726 | 43726 | 247881 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 387 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009928.32781 | 2098399.30466 | 37.742365048010896 | -122.4082816417 | (37.7423650480109, -122.4082816417) | ||||
| 43900 | 43900 | 31372 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 608 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | 16 | Permit Number 34974 | 5991288.7498699995 | 2099114.74799 | 37.7432680941565 | -122.472783188016 | (37.7432680941565, -122.472783188016) | |
| 43975 | 43975 | 43992 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 141 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 13 | Permit Number 43551 | 6010011.61771 | 2107517.81839 | 37.7674071146631 | -122.408636765987 | (37.7674071146631, -122.408636765987) | ||
| 44401 | 44401 | 126600 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1820x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006102.71241 | 2116870.57968 | 37.7928678157445 | -122.42282191472201 | (37.7928678157445, -122.422821914722) | ||||
| 44468 | 44468 | 176364 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988874.21496 | 2090711.48965 | 37.720054833031504 | -122.480516928613 | (37.7200548330315, -122.480516928613) | ||||
| 46907 | 46907 | 68269 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 424 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 13 | Permit Number 32076 | 6010049.762159999 | 2092483.07672 | 37.7261271472388 | -122.40744475327499 | (37.7261271472388, -122.407444753275) | |
| 47483 | 47483 | 223974 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Miguel St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6003823.8109 | 2097275.5293400004 | 37.7389356956285 | -122.429309094259 | (37.7389356956285, -122.429309094259) | ||||
| 48476 | 48476 | 36977 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 16 | Permit Number 39602 | 5993647.32145 | 2114324.1067 | 37.7851652576674 | -122.46573272346599 | (37.7851652576674, -122.465732723466) | |
| 50024 | 50024 | 107109 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5993767.08799 | 2112314.81311 | 37.779655189730605 | -122.46517237775801 | (37.7796551897306, -122.465172377758) | ||||
| 50215 | 50215 | 209138 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000918.34106 | 2095790.55513 | 37.7346933857729 | -122.439248434772 | (37.7346933857729, -122.439248434772) | ||||
| 50311 | 50311 | 209137 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000977.0463 | 2095762.1119400002 | 37.734618627848796 | -122.43904343343 | (37.7346186278488, -122.43904343343) | ||||
| 50789 | 50789 | 30773 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 548 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 34 | Permit Number 34652 | 6014000.72465 | 2112264.48181 | 37.7806629966488 | -122.395171417543 | (37.7806629966488, -122.395171417543) | |
| 51031 | 51031 | 206258 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998976.70694 | 2094998.91633 | 37.732409052024295 | -122.44590438200198 | (37.7324090520243, -122.445904382002) | ||||
| 51663 | 51663 | 224312 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6003373.67876 | 2095579.3072 | 37.7342527629625 | -122.43074443020599 | (37.7342527629625, -122.430744430206) | ||||
| 51940 | 51940 | 74090 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5986841.7666 | 2102304.3098 | 37.751767339194394 | -122.488393849306 | (37.7517673391944, -122.488393849306) | ||
| 53072 | 53072 | 191824 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6010910.67908 | 2107126.67361 | 37.7663834325752 | -122.405499469327 | (37.7663834325752, -122.405499469327) | ||||
| 53137 | 53137 | 191990 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6018074.25782 | 2093264.02641 | 37.7287173674097 | -122.379758475681 | (37.7287173674097, -122.379758475681) | ||||
| 53417 | 53417 | 176367 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989068.70923 | 2090618.6052 | 37.7198110969962 | -122.479837842465 | (37.7198110969962, -122.479837842465) | ||||
| 53797 | 53797 | 201666 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 08th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6010327.42074 | 2109693.60049 | 37.77339899349779 | -122.40769787286999 | (37.7733989934978, -122.40769787287) | ||||
| 54010 | 54010 | 247872 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009895.64631 | 2098398.03188 | 37.7423597231243 | -122.408394555183 | (37.7423597231243, -122.408394555183) | ||||
| 56135 | 56135 | 250989 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5981864.98937 | 2112954.2603599997 | 37.7807173939441 | -122.506393608376 | (37.7807173939441, -122.506393608376) | ||||
| 58168 | 58168 | 209136 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6000997.1554 | 2095746.93377 | 37.7345780962937 | -122.438972822257 | (37.7345780962937, -122.438972822257) | ||||
| 60639 | 60639 | 191813 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 6011137.70759 | 2106686.95849 | 37.7651887659782 | -122.40468325722901 | (37.7651887659782, -122.404683257229) | ||||
| 62987 | 62987 | 209141 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 112 Marston Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5998693.6705599995 | 2093224.71233 | 37.7275213392184 | -122.446755287223 | (37.7275213392184, -122.446755287223) | ||||
| 63607 | 63607 | 191841 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6015067.74656 | 2099262.4877299997 | 37.7450216201491 | -122.39057124226801 | (37.7450216201491, -122.390571242268) | ||||
| 65760 | 65760 | 32217 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 525 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 24 | Permit Number 35538 | 6009485.22492 | 2100263.16237 | 37.747457969910705 | -122.409945309239 | (37.7474579699107, -122.409945309239) | |
| 65910 | 65910 | 38340 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1517 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 14 | Permit Number 40407 | 5982158.3822 | 2104738.8652 | 37.7581775666431 | -122.504769723467 | (37.7581775666431, -122.504769723467) | |
| 65993 | 65993 | 176371 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Higuera Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5988051.57077 | 2090189.21329 | 37.7185729508586 | -122.483322229739 | (37.7185729508586, -122.483322229739) | ||||
| 66845 | 66845 | 191823 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010913.1498300005 | 2107097.65952 | 37.766303904620706 | -122.405488879804 | (37.7663039046207, -122.405488879804) | ||||
| 68826 | 68826 | 209140 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 112 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5998703.32943 | 2093223.9709599998 | 37.727519855354096 | -122.446721843256 | (37.7275198553541, -122.446721843256) | ||||
| 69503 | 69503 | 224311 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003371.63665 | 2095581.9974099998 | 37.7342600339703 | -122.430751682345 | (37.7342600339703, -122.430751682345) | ||||
| 71070 | 71070 | 191828 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010898.97678 | 2107303.7409200002 | 37.7668689648497 | -122.40555241780301 | (37.7668689648497, -122.405552417803) | ||||
| 71300 | 71300 | 191840 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 6015034.2062 | 2099284.7294900003 | 37.7450808306162 | -122.39068877377701 | (37.7450808306162, -122.390688773777) | ||||
| 71655 | 71655 | 176365 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988916.46599 | 2090663.1949 | 37.719924683163 | -122.48036734976999 | (37.719924683163, -122.48036734977) | ||||
| 73439 | 73439 | 249465 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6006528.896380001 | 2113762.4002 | 37.78435756088879 | -122.421126494805 | (37.7843575608888, -122.421126494805) | ||||
| 73581 | 73581 | 191844 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | 6015247.82087 | 2099125.91751 | 37.7446566150196 | -122.38993903417 | (37.7446566150196, -122.38993903417) | ||||
| 73794 | 73794 | 73855 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5986859.2227 | 2102304.8233 | 37.7517697676229 | -122.488333522296 | (37.7517697676229, -122.488333522296) | ||
| 73889 | 73889 | 191811 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 6011131.47947 | 2106831.70462 | 37.76558585803421 | -122.40471498982299 | (37.7655858580342, -122.404714989823) | ||||
| 74701 | 74701 | 35839 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 518 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 13 | Permit Number 39066 | 6001544.15137 | 2090744.8292200002 | 37.7208745650816 | -122.43672373202601 | (37.7208745650816, -122.436723732026) | |
| 75335 | 75335 | 67222 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 5428 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 12 | Permit Number 30681 | 5981782.23642 | 2111693.16407 | 37.7772499233167 | -122.506586330196 | (37.7772499233167, -122.506586330196) | |
| 75369 | 75369 | 176363 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5988462.773440001 | 2091307.9607099998 | 37.7216686718604 | -122.48198279658399 | (37.7216686718604, -122.481982796584) | ||||
| 76522 | 76522 | 36974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 10 | Permit Number 39602 | 5993649.0736 | 2114306.93888 | 37.7851182205824 | -122.46572541386601 | (37.7851182205824, -122.465725413866) | |
| 77191 | 77191 | 246720 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 75 Stoneman St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007960.82991 | 2099365.47292 | 37.744907561828796 | -122.4151530494 | (37.7449075618288, -122.4151530494) | ||||
| 77352 | 77352 | 36702 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005001.97582164 | 2104885.80884876 | 37.759898394802605 | -122.42577707942199 | (37.7598983948026, -122.425777079422) | ||
| 78184 | 78184 | 42222 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
| 78814 | 78814 | 42223 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
| 79810 | 79810 | 68817 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2007 12:00:00 AM | Permit Number 49379 | 6000058.92001633 | 2094143.32486819 | 37.730121532663105 | -122.442101535638 | (37.7301215326631, -122.442101535638) | ||
| 80578 | 80578 | 36705 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||
| 81989 | 81989 | 39617 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 143 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | Permit Number 41017 | 5997752.15145133 | 2106762.51515119 | 37.7646390036764 | -122.45098590004999 | (37.7646390036764, -122.45098590005) | |||
| 82285 | 82285 | 50882 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2055 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47392 | 5991593.93786831 | 2101441.81632133 | 37.7496752859252 | -122.471897503797 | (37.7496752859252, -122.471897503797) | ||
| 82947 | 82947 | 46916 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | ||
| 84579 | 84579 | 49746 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 40@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46545 | 6008551.24165341 | 2087877.47374564 | 37.7133971377495 | -122.412299691068 | (37.7133971377495, -122.412299691068) | ||
| 84687 | 84687 | 41668 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500 Corbett Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 85345 | 85345 | 36703 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||
| 86261 | 86261 | 42484 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 50 Phelan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997088.18001 | 2092254.3140099999 | 37.7247650096883 | -122.452235460018 | (37.7247650096883, -122.452235460018) | ||
| 87916 | 87916 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 87952 | 87952 | 111303 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||||
| 90337 | 90337 | 83074 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6017910.254851099 | 2094654.90941097 | 37.7325274125135 | -122.380422079616 | (37.7325274125135, -122.380422079616) | ||||
| 90863 | 90863 | 43515 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
| 90990 | 90990 | 84960 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2007 12:00:00 AM | Permit Number 49352 | 5988993.8 | 2097500.0 | 37.7387012975774 | -122.48060025376301 | (37.7387012975774, -122.480600253763) | |||
| 91233 | 91233 | 44205 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 341 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1986 12:00:00 AM | Permit Number 43653 | 6007751.99799899 | 2097517.30165944 | 37.739821155436 | -122.415744314793 | (37.739821155436, -122.415744314793) | ||
| 92147 | 92147 | 42218 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
| 92358 | 92358 | 42224 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
| 93393 | 93393 | 103615 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 93935 | 93935 | 38688 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40601 | 6001154.46973963 | 2111747.51694807 | 37.7785207657155 | -122.439575605477 | (37.7785207657155, -122.439575605477) | ||
| 94001 | 94001 | 43523 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1442 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43199 | 6000900.07851404 | 2110723.16086375 | 37.7756936614931 | -122.44038215551001 | (37.7756936614931, -122.44038215551) | ||
| 94433 | 94433 | 38683 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
| 94979 | 94979 | 38022 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.740344819144795 | -122.468223027257 | (37.7403448191448, -122.468223027257) |
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");