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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16903 | 16903 | 203213 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 626 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 10x4 | Permit Number 779632 | 6001387.0 | 2090021.0 | 37.7188781603148 | -122.437215155763 | (37.7188781603148, -122.437215155763) | ||
| 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) | |
| 101780 | 101780 | 46374 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2135 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778548 | 5982916.26389717 | 2100594.08542438 | 37.746841715159796 | -122.50184201898001 | (37.7468417151598, -122.50184201898) | |
| 138969 | 138969 | 47448 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 714 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778519 | 5981684.9751 | 2110860.5304900003 | 37.7749580289324 | -122.506861007188 | (37.7749580289324, -122.506861007188) | |
| 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) | |
| 99234 | 99234 | 120108 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3528 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778087 | 6004858.0 | 2103141.0 | 37.755099423002896 | -122.426150804554 | (37.7550994230029, -122.426150804554) | |
| 22901 | 22901 | 183545 | Planning Code 138.1 required 4 | Agonis flexuosa :: Peppermint Willow 7 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.73937736557679 | -122.482876432223 | (37.7393773655768, -122.482876432223) | |
| 100955 | 100955 | 87814 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2000 10th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | ||
| 101356 | 101356 | 87815 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2000 10th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | ||
| 144820 | 144820 | 87813 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2000 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | ||
| 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) | ||
| 112685 | 112685 | 115169 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1463 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777351 | 5983676.8 | 2105200.0 | 37.759532920891 | -122.49955253982901 | (37.759532920891, -122.499552539829) | |||
| 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) | |||
| 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) | ||
| 112433 | 112433 | 97220 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132.0 | 2101212.0 | 37.749133146159004 | -122.466562169914 | (37.749133146159, -122.466562169914) | |||
| 113113 | 113113 | 33539 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 253 BOCANA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | 4x4 | Permit Number 775951 | 6007035.0 | 2097463.0 | 37.7396317225537 | -122.418219548801 | (37.7396317225537, -122.418219548801) | ||
| 143140 | 143140 | 115291 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1811 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775894 | 5990908.2 | 2103066.5 | 37.7540965389008 | -122.474387332213 | (37.7540965389008, -122.474387332213) | |||
| 123536 | 123536 | 114809 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.48480450813801 | (37.763791122625, -122.484804508138) | |||
| 139665 | 139665 | 107942 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 415 KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | 6x5 | Permit Number 775659 | 5993574.7 | 2105234.4 | 37.760203156894 | -122.465323466087 | (37.760203156894, -122.465323466087) | |
| 128699 | 128699 | 115206 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 390 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775334 | 6003427.0 | 2108679.3 | 37.7702252763858 | -122.431494968546 | (37.7702252763858, -122.431494968546) | |||
| 102691 | 102691 | 115201 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | |||
| 115807 | 115807 | 115202 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1352 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | |||
| 120221 | 120221 | 115173 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2063 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775267 | 5982265.3 | 2101066.7 | 37.7481011229623 | -122.504127955016 | (37.7481011229623, -122.504127955016) | |||
| 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) | |||
| 22945 | 22945 | 104992 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.74123331264771 | -122.505795454359 | (37.7412333126477, -122.505795454359) | |
| 128249 | 128249 | 109405 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.753003931617705 | -122.46482995514 | (37.7530039316177, -122.46482995514) | ||
| 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) | |
| 103129 | 103129 | 109743 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.43395300270399 | (37.7602597694278, -122.433953002704) |
| 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) | ||
| 188872 | 188872 | 113547 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | ||
| 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) | ||
| 145744 | 145744 | 109499 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207236999 | (37.7359945088656, -122.43418207237) |
| 145260 | 145260 | 115281 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360.0 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | |||
| 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) | |
| 144078 | 144078 | 108734 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Aloha Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774639 | 5991915.16633 | 2104292.89593 | 37.7575221893456 | -122.470994366205 | (37.7575221893456, -122.470994366205) | |
| 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) | |
| 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) |
| 125208 | 125208 | 115171 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2218 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 774487 | 5982698.2 | 2099998.9 | 37.745194688928706 | -122.502552005341 | (37.7451946889287, -122.502552005341) | |||
| 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) | ||
| 102123 | 102123 | 60473 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.716702150620605 | -122.451539811129 | (37.7167021506206, -122.451539811129) | |||
| 97121 | 97121 | 112745 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.45208619405899 | (37.7152791660762, -122.452086194059) | ||
| 125420 | 125420 | 114566 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | |||
| 113053 | 113053 | 109068 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1216 COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774077 | 5998287.0 | 2106143.6 | 37.762970223958 | -122.44909141982299 | (37.762970223958, -122.449091419823) | |
| 117619 | 117619 | 55230 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | Permit Number 774077 | 5998221.35114249 | 2106191.93019124 | 37.763099171561706 | -122.44932195790199 | (37.7630991715617, -122.449321957902) | |
| 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) | |
| 114658 | 114658 | 108766 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 5 | 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) | |
| 126629 | 126629 | 108762 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 1 | 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) | |
| 144398 | 144398 | 108769 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 8 | 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) | |
| 145235 | 145235 | 108773 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 12 | 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) | |
| 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) | |
| 105306 | 105306 | 108505 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.4139099997 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) |
| 100535 | 100535 | 108501 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) |
| 99527 | 99527 | 109287 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
| 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) |
| 104744 | 104744 | 109285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1530 Sloat Blvd | 4 | 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) |
| 121017 | 121017 | 109283 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1530 Sloat Blvd | 2 | 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) |
| 142867 | 142867 | 109282 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1530 Sloat Blvd | 1 | 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) |
| 91954 | 91954 | 109278 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.756026462840296 | -122.508644093874 | (37.7560264628403, -122.508644093874) |
| 109712 | 109712 | 109039 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2439 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773557 | 5985453.6 | 2098605.4 | 37.741530042819704 | -122.49292181518899 | (37.7415300428197, -122.492921815189) |
| 103908 | 103908 | 109191 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932.0 | 37.761418601404294 | -122.506913128145 | (37.7614186014043, -122.506913128145) |
| 128792 | 128792 | 109288 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773379 | 6002625.7 | 2104315.8 | 37.758198718241296 | -122.433954706682 | (37.7581987182413, -122.433954706682) |
| 115853 | 115853 | 108890 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 350 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | |
| 115761 | 115761 | 114784 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.44279721991501 | (37.7837071608561, -122.442797219915) | |||
| 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) | |
| 109215 | 109215 | 109259 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1658 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773073 | 5981637.7 | 2103794.0 | 37.755552591394604 | -122.506500365189 | (37.7555525913946, -122.506500365189) |
| 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) |
| 95188 | 95188 | 109277 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.50770127946801 | (37.7531458375643, -122.507701279468) |
| 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) | |
| 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) | ||
| 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) |
| 94642 | 94642 | 108926 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.744692745913206 | -122.417269529335 | (37.7446927459132, -122.417269529335) |
| 115640 | 115640 | 105062 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 530 07th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771082 | 5993803.2 | 2111872.0 | 37.7784414265163 | -122.465015282122 | (37.7784414265163, -122.465015282122) | ||||
| 113254 | 113254 | 106164 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771080 | 5993998.9 | 2106208.9 | 37.762903334931295 | -122.463927108118 | (37.7629033349313, -122.463927108118) | |
| 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) | |
| 133834 | 133834 | 104694 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2132 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988835.56911 | 2113350.3875599997 | 37.7822129738615 | -122.482308328405 | (37.7822129738615, -122.482308328405) | |
| 116775 | 116775 | 114957 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | Permit Number 770549 | 5993817.0 | 2111494.4 | 37.7774054340765 | -122.46494011266 | (37.7774054340765, -122.46494011266) | |||
| 85398 | 85398 | 103022 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) |
| 169018 | 169018 | 100940 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1470 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/2012 12:00:00 AM | 0 | Permit Number 769322 | 5982213.5 | 2105098.8 | 37.7591690876422 | -122.504605773131 | (37.7591690876422, -122.504605773131) | ||
| 117836 | 117836 | 57100 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | Permit Number 768635 | 6004924.75692274 | 2102545.44998856 | 37.7534679546686 | -122.42587754962601 | (37.7534679546686, -122.425877549626) | |||
| 125621 | 125621 | 99537 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768635 | 6004924.7 | 2102557.1 | 37.75349993966729 | -122.425878575683 | (37.7534999396673, -122.425878575683) | ||
| 110686 | 110686 | 39929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.71342836866339 | -122.405593725995 | (37.7134283686634, -122.405593725995) | ||
| 141495 | 141495 | 96074 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 439 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3x3 | Permit Number 767700 | 5983724.3 | 2112865.2 | 37.780582151385204 | -122.499954873055 | (37.7805821513852, -122.499954873055) | |
| 136807 | 136807 | 95918 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 682 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767617 | 5991324.67511 | 2110779.5547700003 | 37.775298644974704 | -122.473509641895 | (37.7752986449747, -122.473509641895) |
| 133220 | 133220 | 95909 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1455 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767610 | 5987104.5752 | 2105375.1658 | 37.7602144045714 | -122.48771061732401 | (37.7602144045714, -122.487710617324) |
| 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) |
| 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) | |
| 88212 | 88212 | 95120 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54047 | 6002640.0 | 2094338.0 | 37.730802821842204 | -122.43319232563101 | (37.7308028218422, -122.433192325631) | |
| 146423 | 146423 | 95109 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 615 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54038 | 6001824.30736 | 2093468.5255200001 | 37.7283691373029 | -122.43595011001301 | (37.7283691373029, -122.435950110013) |
| 144631 | 144631 | 94833 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.46518370955499 | (37.7657499301273, -122.465183709555) | |
| 107093 | 107093 | 94831 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.46293678641099 | (37.759825119308, -122.462936786411) | |
| 101896 | 101896 | 94830 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | |
| 109470 | 109470 | 94829 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.759960935580004 | -122.46294625717199 | (37.75996093558, -122.462946257172) | |
| 97022 | 97022 | 94821 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639.0 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | |
| 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) |
| 182399 | 182399 | 94731 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3965 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995713.23783 | 2115474.26613 | 37.788442235114005 | -122.458668634362 | (37.788442235114, -122.458668634362) |
| 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) | |
| 116968 | 116968 | 94662 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53799 | 6004605.0 | 2096922.0 | 37.738009179189795 | -122.42658293494699 | (37.7380091791898, -122.426582934947) | |
| 115438 | 115438 | 94661 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53798 | 6004650.0 | 2096961.0 | 37.7381188082759 | -122.426430123703 | (37.7381188082759, -122.426430123703) | |
| 85777 | 85777 | 94147 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.46759079981199 | (37.7538665624087, -122.467590799812) |
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");