Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 2135 | 2135 | 57208 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2238 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | Permit Number 775007 | 6000879.71894 | 2116143.1485 | 37.7905743988346 | -122.440841472269 | (37.7905743988346, -122.440841472269) | ||
| 2378 | 2378 | 221860 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 15 | Width 3ft | Permit Number 39568 | 6001163.03933 | 2103237.69221 | 37.7551553815387 | -122.438935950032 | (37.7551553815387, -122.438935950032) | |
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 8499 | 8499 | 41209 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.44286834991101 | (37.7996299225355, -122.442868349911) | |
| 9773 | 9773 | 114349 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798001 | (37.7634027199113, -122.50597849798) | ||
| 10544 | 10544 | 52929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.727471916095205 | -122.433397195531 | (37.7274719160952, -122.433397195531) |
| 10710 | 10710 | 108565 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.9401900002 | 37.7253828953025 | -122.40588377841401 | (37.7253828953025, -122.405883778414) |
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 11336 | 11336 | 97263 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.9708200002 | 37.732983995812795 | -122.41010807752599 | (37.7329839958128, -122.410108077526) | |
| 11377 | 11377 | 108847 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.43629760175101 | (37.7100901720951, -122.436297601751) | |
| 11746 | 11746 | 1274 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 778829 | 5992454.25389 | 2087344.9239400001 | 37.71101846581121 | -122.467897323323 | (37.7110184658112, -122.467897323323) | |
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 12058 | 12058 | 108846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | |
| 12826 | 12826 | 117427 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.4481900001 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | ||
| 12996 | 12996 | 35840 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.1440400002 | 37.7196921382746 | -122.43417669731501 | (37.7196921382746, -122.434176697315) |
| 17027 | 17027 | 4845 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589431999 | (37.7395500270059, -122.41939589432) | ||
| 18080 | 18080 | 112764 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908001 | (37.7167707693614, -122.45190370908) | ||
| 18159 | 18159 | 64301 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.609957799 | 2099277.06478887 | 37.74449416747979 | -122.42561779186899 | (37.7444941674798, -122.425617791869) | ||
| 18583 | 18583 | 26511 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.75182981809429 | -122.411926215341 | (37.7518298180943, -122.411926215341) | |||
| 18634 | 18634 | 67500 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1997 12:00:00 AM | Permit Number 31028 | 5997975.78487802 | 2094419.07569222 | 37.7307597431483 | -122.449323026732 | (37.7307597431483, -122.449323026732) | ||
| 19069 | 19069 | 4572 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 233 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 1 | 6x6 | Permit Number 775065 | 6006398.09865 | 2098473.12689 | 37.742369434016 | -122.420493366683 | (37.742369434016, -122.420493366683) | |
| 20064 | 20064 | 4846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 210 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 15 | 3X3 | 6006713.9746 | 2097429.76412 | 37.7395223890352 | -122.419327161814 | (37.7395223890352, -122.419327161814) | ||
| 21771 | 21771 | 27336 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.3579400002 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | ||
| 23776 | 23776 | 40163 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 39201 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Permit Number 41356 | 6010358.38502 | 2116055.23844 | 37.7908682829043 | -122.40803948753 | (37.7908682829043, -122.40803948753) | |||
| 24411 | 24411 | 31817 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 378 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 11 | Permit Number 35283 | 6003458.13683 | 2099246.4861 | 37.7443267796662 | -122.43071403581999 | (37.7443267796662, -122.43071403582) | |
| 25004 | 25004 | 94732 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) |
| 25764 | 25764 | 104693 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988848.42745 | 2113351.68498 | 37.7822172841496 | -122.482263939923 | (37.7822172841496, -122.482263939923) | |
| 25869 | 25869 | 37614 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 438 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 21 | Permit Number 40038 | 5990631.22382 | 2112392.71042 | 37.7796877441109 | -122.47602626679199 | (37.7796877441109, -122.476026266792) | |
| 27821 | 27821 | 32474 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 7 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 15 | Permit Number 36982 | 6000854.394669999 | 2106273.37873 | 37.7634730690508 | -122.44022101378401 | (37.7634730690508, -122.440221013784) | |
| 30127 | 30127 | 38206 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | |
| 30611 | 30611 | 113546 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.090480001 | 2105100.1338299997 | 37.7608633956443 | -122.40260920746701 | (37.7608633956443, -122.402609207467) | ||
| 31047 | 31047 | 38227 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1099 Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.01456 | 2102105.05687 | 37.7527820922208 | -122.39354933016199 | (37.7527820922208, -122.393549330162) | ||
| 32014 | 32014 | 35736 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | |
| 32779 | 32779 | 67371 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | |
| 33741 | 33741 | 38113 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1296 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 9 | Permit Number 40278 | 5987108.7979 | 2106493.9222 | 37.7632864483052 | -122.48777820863701 | (37.7632864483052, -122.487778208637) | |
| 34538 | 34538 | 67951 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 546 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 1 | Permit Number 31666 | 5988462.26619 | 2112267.73562 | 37.779218595028794 | -122.483520377593 | (37.7792185950288, -122.483520377593) | |
| 34901 | 34901 | 108776 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 35641 | 35641 | 51092 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1962 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 8 | Permit Number 47549 | 5987266.4855 | 2101911.4788 | 37.75071350308671 | -122.486896287824 | (37.7507135030867, -122.486896287824) | ||
| 36359 | 36359 | 65523 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.2505700001 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | |
| 37052 | 37052 | 38204 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.723383562996794 | -122.405053372309 | (37.7233835629968, -122.405053372309) | |
| 37457 | 37457 | 67246 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 21 | Permit Number 30710 | 5983966.26401 | 2111769.24931 | 37.777587186025 | -122.499036819383 | (37.777587186025, -122.499036819383) | |
| 39136 | 39136 | 44734 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1434 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 15 | Permit Number 43849 | 5988947.4767 | 2101073.1476 | 37.7485095315689 | -122.481021968545 | (37.7485095315689, -122.481021968545) | |
| 40525 | 40525 | 83821 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1514 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50163 | 5981890.7885 | 2104754.0668 | 37.75820356042521 | -122.505696289301 | (37.7582035604252, -122.505696289301) | |
| 40756 | 40756 | 83009 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.9515299997 | 37.7619540583423 | -122.40137802299499 | (37.7619540583423, -122.401378022995) | |
| 41932 | 41932 | 114086 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 20 Cook St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997489.0948 | 2113600.1035 | 37.783398187645 | -122.45238918542401 | (37.783398187645, -122.452389185424) | |||
| 41955 | 41955 | 83487 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2051 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50156 | 5982589.2289 | 2101159.5488 | 37.7483751044578 | -122.503014711943 | (37.7483751044578, -122.503014711943) | |
| 43708 | 43708 | 64171 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 610 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 21 | Permit Number 24952 | 5991942.3425 | 2111250.75611 | 37.7766281856646 | -122.47140734968201 | (37.7766281856646, -122.471407349682) | |
| 43753 | 43753 | 37072 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1426 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 14 | Permit Number 39847 | 5982799.9219 | 2105403.4894 | 37.7600401558558 | -122.502600230953 | (37.7600401558558, -122.502600230953) | |
| 44377 | 44377 | 47976 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1515 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | 2 | Permit Number 45710 | 5988978.856000001 | 2104994.3044 | 37.7592778047967 | -122.48120055117701 | (37.7592778047967, -122.481200551177) | |
| 44826 | 44826 | 53159 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1747@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 13 | Permit Number 49080 | 6014484.905180001 | 2095154.52732 | 37.733709657875295 | -122.392299359741 | (37.7337096578753, -122.392299359741) | |
| 46276 | 46276 | 68880 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 28 | Permit Number 32851 | 6000180.507069999 | 2120770.20455 | 37.8032392229736 | -122.44359322865299 | (37.8032392229736, -122.443593228653) | |
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 48562 | 48562 | 95121 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 68 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54048 | 6002661.0 | 2094358.0 | 37.730858928558895 | -122.433121153797 | (37.7308589285589, -122.433121153797) | |
| 49216 | 49216 | 38203 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 691 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010707.714480001 | 2091513.67595 | 37.723502179070394 | -122.40510200945101 | (37.7235021790704, -122.405102009451) | |
| 49477 | 49477 | 107593 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1801 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x6 | 5993030.37815 | 2112040.04561 | 37.7788582423825 | -122.467700965505 | (37.7788582423825, -122.467700965505) | |||
| 50290 | 50290 | 37084 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1487 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 9 | Permit Number 39685 | 5982148.9004 | 2105004.528 | 37.7589064434103 | -122.504822200215 | (37.7589064434103, -122.504822200215) | |
| 51781 | 51781 | 37529 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.391419999 | 2115650.05703 | 37.789581982560705 | -122.41871930464701 | (37.7895819825607, -122.418719304647) | |
| 56255 | 56255 | 44243 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4005 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | 12 | Permit Number 43678 | 5983313.0175 | 2106265.8208 | 37.7624380119611 | -122.500889481832 | (37.7624380119611, -122.500889481832) | ||
| 56768 | 56768 | 37527 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.41870044408199 | (37.7894946107457, -122.418700444082) | |
| 56864 | 56864 | 42268 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42509 | 5987415.8588 | 2105330.3292 | 37.7601094468303 | -122.486630755953 | (37.7601094468303, -122.486630755953) | |
| 61285 | 61285 | 40196 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 562 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 26 | Permit Number 41380 | 5983509.69459 | 2111981.18634 | 37.778142310971106 | -122.500631896768 | (37.7781423109711, -122.500631896768) | |
| 62442 | 62442 | 84402 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.44118716032499 | (37.778458498926, -122.441187160325) | |
| 63823 | 63823 | 37604 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | |
| 64399 | 64399 | 96841 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4426 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54781 | 5981806.97545 | 2111010.8887 | 37.7753780521761 | -122.50645014202298 | (37.7753780521761, -122.506450142023) |
| 64744 | 64744 | 114084 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 20 Cook St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 5997493.8327 | 2113562.2002 | 37.783294386609796 | -122.452370058209 | (37.7832943866098, -122.452370058209) | |||
| 64814 | 64814 | 37659 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.47158794068599 | (37.7791167592266, -122.471587940686) | |
| 65312 | 65312 | 69299 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.982999999 | 2110939.1774 | 37.7762325313103 | -122.44369120188499 | (37.7762325313103, -122.443691201885) | |
| 65323 | 65323 | 35138 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.9612599998 | 37.715825312477605 | -122.435095942923 | (37.7158253124776, -122.435095942923) | |
| 65965 | 65965 | 39931 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.703319999 | 2087956.6998299998 | 37.713712300459704 | -122.406282682604 | (37.7137123004597, -122.406282682604) | |
| 66318 | 66318 | 65718 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.44056528958099 | (37.7124240746766, -122.440565289581) | |
| 66861 | 66861 | 67245 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4738 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 15 | Permit Number 30709 | 5983942.53029 | 2111768.1419599997 | 37.777582753336794 | -122.499118839179 | (37.7775827533368, -122.499118839179) | |
| 67605 | 67605 | 36190 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 181 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39257 | 5996902.2714 | 2113184.5215 | 37.7822234726194 | -122.45438932298201 | (37.7822234726194, -122.454389322982) | |
| 69427 | 69427 | 64508 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | |
| 69963 | 69963 | 64114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.764510344589894 | -122.46840068588101 | (37.7645103445899, -122.468400685881) | ||
| 70374 | 70374 | 41233 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.80516630374971 | -122.435520011048 | (37.8051663037497, -122.435520011048) | |
| 70503 | 70503 | 67419 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 507 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 21 | Permit Number 30920 | 5990601.19445 | 2111910.6145099998 | 37.7783623005847 | -122.476094929494 | (37.7783623005847, -122.476094929494) | |
| 70667 | 70667 | 64185 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1801 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/07/1993 12:00:00 AM | 19 | 6x9 | Permit Number 24970 | 5993009.35743 | 2112040.6417799997 | 37.7788586655522 | -122.46777372723999 | (37.7788586655522, -122.46777372724) |
| 72523 | 72523 | 108691 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1638 41st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774623 | 5983468.36272 | 2103987.5899 | 37.756191751246796 | -122.500183776602 | (37.7561917512468, -122.500183776602) | |
| 72675 | 72675 | 91464 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008023.92041 | 2119932.4105700003 | 37.801383054633796 | -122.416391395149 | (37.8013830546338, -122.416391395149) | |
| 72731 | 72731 | 39936 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.3367800005 | 2088185.9421 | 37.7143129666441 | -122.40807668619499 | (37.7143129666441, -122.408076686195) | |
| 74947 | 74947 | 43793 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 170 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 6 | Permit Number 43423 | 5989012.43621 | 2114211.91029 | 37.7845887590001 | -122.481759578125 | (37.7845887590001, -122.481759578125) | |
| 75821 | 75821 | 68256 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.40921918673901 | (37.7281816043806, -122.409219186739) | |
| 76400 | 76400 | 63461 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 45 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1987 12:00:00 AM | Permit Number 24052 | 6006867.21716204 | 2099801.68707108 | 37.7460437878528 | -122.418965501899 | (37.7460437878528, -122.418965501899) | ||
| 76573 | 76573 | 83067 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.4008400002 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | |
| 77309 | 77309 | 97549 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 199x FLOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 42524 | 5999753.0 | 2094070.0 | 37.729902760805295 | -122.443153872698 | (37.7299027608053, -122.443153872698) | ||
| 77472 | 77472 | 65559 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 301 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1990 12:00:00 AM | Permit Number 28458 | 5995039.18564511 | 2096207.71663667 | 37.735502500801 | -122.45960474158501 | (37.735502500801, -122.459604741585) | ||
| 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) | ||
| 79823 | 79823 | 109284 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) |
| 80430 | 80430 | 63857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24557 | 6002233.40181795 | 2109560.38159908 | 37.7725767859044 | -122.435686656968 | (37.7725767859044, -122.435686656968) | ||
| 80554 | 80554 | 63133 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | ||
| 81614 | 81614 | 63855 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | ||
| 81824 | 81824 | 68866 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32829 | 5999664.63009036 | 2093804.62136616 | 37.72916905360999 | -122.44344032201401 | (37.72916905361, -122.443440322014) | ||
| 82306 | 82306 | 67034 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3947 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30406 | 6003485.585090701 | 2102413.54143102 | 37.7530243281476 | -122.430845098487 | (37.7530243281476, -122.430845098487) | ||
| 82393 | 82393 | 108910 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) |
| 82800 | 82800 | 59432 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3045 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 18794 | 6002901.09620901 | 2096034.49584779 | 37.7354758211207 | -122.43241079809299 | (37.7354758211207, -122.432410798093) | ||
| 83680 | 83680 | 67285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.726355926218204 | -122.425894675863 | (37.7263559262182, -122.425894675863) | ||
| 84363 | 84363 | 94666 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020.0 | 2095225.0 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | |
| 84491 | 84491 | 32893 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774785 | 5993955.18913569 | 2106899.23772087 | 37.764796302786 | -122.46412840547899 | (37.764796302786, -122.464128405479) | |
| 84626 | 84626 | 66322 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) |
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");