Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 25852 | 25852 | 70376 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | ||
| 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) | |
| 28243 | 28243 | 70581 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 366 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 16 | 5989681.74367 | 2112910.59233 | 37.7810546031553 | -122.47934879186 | (37.7810546031553, -122.47934879186) | ||
| 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) | ||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 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) | |
| 33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) | ||||
| 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) | ||
| 35978 | 35978 | 175198 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6005048.079 | 2092617.03467 | 37.726213742054604 | -122.424744822616 | (37.7262137420546, -122.424744822616) | ||||
| 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) | |
| 38546 | 38546 | 70527 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004201.75826 | 2093380.3315400002 | 37.728261749270395 | -122.427724869209 | (37.7282617492704, -122.427724869209) | ||
| 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) | |
| 39195 | 39195 | 70583 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1801 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 13 | 5989858.46515 | 2113331.7143200003 | 37.78222114927679 | -122.478768239422 | (37.7822211492768, -122.478768239422) | ||
| 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) | |||
| 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) | |
| 46838 | 46838 | 70589 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 339 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 19 | 5989627.95381 | 2113064.98358 | 37.7814753940656 | -122.479546175065 | (37.7814753940656, -122.479546175065) | ||
| 48052 | 48052 | 124270 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2 03rd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | ||||
| 48208 | 48208 | 70645 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | ||
| 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) | |
| 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) | |
| 60499 | 60499 | 124074 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 701 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991915.64045 | 2110472.3398700003 | 37.7744893213305 | -122.47144298584699 | (37.7744893213305, -122.471442985847) | ||||
| 61216 | 61216 | 124272 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5994894.056609999 | 2114999.9706 | 37.787092832167 | -122.46146845316002 | (37.787092832167, -122.46146845316) | ||||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |
| 66659 | 66659 | 74492 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 11 | 6004373.61085 | 2091456.86354 | 37.7229900511464 | -122.42699382922 | (37.7229900511464, -122.42699382922) | ||
| 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) | |
| 69292 | 69292 | 73402 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | ||
| 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) | |
| 72089 | 72089 | 74647 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 9 | 6004365.04367 | 2091463.5414099998 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | ||
| 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) | |
| 72972 | 72972 | 70491 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 18 | 6005035.0472800005 | 2091735.87999 | 37.723793548611496 | -122.424727215697 | (37.7237935486115, -122.424727215697) | ||
| 73789 | 73789 | 175201 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.42469093704099 | (37.7261438278596, -122.424690937041) | ||||
| 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) | |
| 75371 | 75371 | 70397 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 21 | 6006350.25387 | 2093285.0007900002 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | ||
| 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) | |
| 75996 | 75996 | 175203 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 655 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | ||||
| 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) | ||
| 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) | ||
| 78115 | 78115 | 73451 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 376 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 8 | 5989681.20245 | 2112841.9195 | 37.7808660152932 | -122.479345638761 | (37.7808660152932, -122.479345638761) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 84854 | 84854 | 64151 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24930 | 6003105.46054998 | 2099234.08620142 | 37.7442727453071 | -122.43193262973601 | (37.7442727453071, -122.431932629736) | ||
| 85077 | 85077 | 114757 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | Permit Number 777137 | 6000857.2 | 2101959.2 | 37.751627545050894 | -122.439901966271 | (37.7516275450509, -122.439901966271) | |||
| 85078 | 85078 | 64790 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 221 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25786 | 6002754.53875379 | 2109297.20875 | 37.771883765265706 | -122.433865178188 | (37.7718837652657, -122.433865178188) | ||
| 85108 | 85108 | 115172 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | |||
| 85384 | 85384 | 59441 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.919079901 | 2095333.58373446 | 37.7336281759245 | -122.42766636908001 | (37.7336281759245, -122.42766636908) | |||
| 85576 | 85576 | 53235 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31473 | 6004075.80842764 | 2102593.23401919 | 37.7535511453461 | -122.428816801411 | (37.7535511453461, -122.428816801411) | ||
| 86941 | 86941 | 40424 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.45558972239401 | (37.7310042675093, -122.455589722394) | |
| 87259 | 87259 | 62770 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.46687140584801 | (37.7579524055375, -122.466871405848) | ||
| 87275 | 87275 | 67908 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.728356579287706 | -122.44478069728001 | (37.7283565792877, -122.44478069728) | ||
| 87393 | 87393 | 62771 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | ||
| 88128 | 88128 | 66622 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.758251464098294 | -122.40771590105699 | (37.7582514640983, -122.407715901057) | ||
| 88131 | 88131 | 62339 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.736081814832204 | -122.42541149958599 | (37.7360818148322, -122.425411499586) | ||
| 88845 | 88845 | 65658 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 72 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28578 | 5998676.92004406 | 2096648.99460169 | 37.73692265288229 | -122.44705951571999 | (37.7369226528823, -122.44705951572) | ||
| 88960 | 88960 | 67941 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.734668261802504 | -122.427968106929 | (37.7346682618025, -122.427968106929) | ||
| 89439 | 89439 | 53384 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.719280057149504 | -122.46030414100001 | (37.7192800571495, -122.460304141) | ||
| 89722 | 89722 | 64105 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 531 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176004 | 37.7433167168502 | -122.43179864381099 | (37.7433167168502, -122.431798643811) |
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");