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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17413 | 17413 | 225 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.47486804133301 | (37.7331946143326, -122.474868041333) | ||
| 21024 | 21024 | 228 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.732946707226205 | -122.47484341251601 | (37.7329467072262, -122.474843412516) | ||
| 12571 | 12571 | 1265 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5992172.84146 | 2087217.03484 | 37.710651058571294 | -122.468860642897 | (37.7106510585713, -122.468860642897) | ||
| 12505 | 12505 | 1266 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5992143.8312800005 | 2087204.7899900002 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | |||
| 12394 | 12394 | 1269 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992328.07158 | 2087287.97745 | 37.7108548170665 | -122.468329295555 | (37.7108548170665, -122.468329295555) | |||
| 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) | |
| 11329 | 11329 | 1275 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992427.65168 | 2087335.5500599998 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | |||
| 11911 | 11911 | 1278 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 12 | 3X3 | 5992545.036040001 | 2087392.68167 | 37.711154838998 | -122.467587032028 | (37.711154838998, -122.467587032028) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 116644 | 116644 | 5134 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 6 | 3X3 | 6002450.59942 | 2095504.85865 | 37.733996003275706 | -122.433930487392 | (37.7339960032757, -122.433930487392) | ||
| 143515 | 143515 | 21401 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2692X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 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) | |||
| 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) | ||
| 157990 | 157990 | 30579 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 396 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | 2 | Permit Number 34554 | 6003425.76209 | 2108645.8916700003 | 37.7701334751172 | -122.43149686511002 | (37.7701334751172, -122.43149686511) | ||
| 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) | |
| 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) | |
| 153467 | 153467 | 32556 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 233 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37043 | 6004755.28395 | 2103949.67696 | 37.75731405392921 | -122.42656360702 | (37.7573140539292, -122.42656360702) | ||
| 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) | |
| 132438 | 132438 | 33146 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 650 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37371 | 5989131.31746 | 2110902.5354 | 37.775509053938606 | -122.481105889377 | (37.7755090539386, -122.481105889377) | |
| 89835 | 89835 | 33484 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.42106821147301 | (37.741769825751, -122.421068211473) |
| 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) | ||
| 124280 | 124280 | 34739 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3x3 | Permit Number 38389 | 6007302.61875581 | 2103939.58827334 | 37.7574300317864 | -122.41775318583299 | (37.7574300317864, -122.417753185833) | |
| 128624 | 128624 | 35065 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1725 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38620 | 5993082.12771331 | 2103730.13138284 | 37.7560444079518 | -122.46691766691002 | (37.7560444079518, -122.46691766691) | ||
| 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) | |
| 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) | |
| 175246 | 175246 | 35737 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 351 Hale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 11 | Permit Number 39011 | 6008822.29863 | 2094308.6261200001 | 37.731070936367296 | -122.411816979173 | (37.7310709363673, -122.411816979173) | |
| 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) |
| 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) |
| 179847 | 179847 | 36189 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 181 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 11 | Permit Number 39257 | 5996904.302 | 2113169.9694 | 37.7821836328514 | -122.454381246555 | (37.7821836328514, -122.454381246555) | |
| 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) | |
| 154307 | 154307 | 37071 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1426 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39847 | 5982798.7178 | 2105383.4209 | 37.75998498268579 | -122.502602909857 | (37.7599849826858, -122.502602909857) | |
| 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) | |
| 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) | |
| 158513 | 158513 | 37085 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1487 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 13 | Permit Number 39685 | 5982149.7032 | 2104986.8677 | 37.7588580004754 | -122.504818115198 | (37.7588580004754, -122.504818115198) | ||
| 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) | |
| 137710 | 137710 | 37528 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.5342599996 | 37.789536754768 | -122.41870954971901 | (37.789536754768, -122.418709549719) | |
| 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) | |
| 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) | |
| 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) | |
| 127752 | 127752 | 37615 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 458 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 13 | Permit Number 40039 | 5990633.383119999 | 2112269.25863 | 37.779348904808 | -122.476009778191 | (37.779348904808, -122.476009778191) | |
| 148868 | 148868 | 37616 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 462 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 17 | Permit Number 43442 | 5990631.36651 | 2112225.85325 | 37.7792296086918 | -122.476013583462 | (37.7792296086918, -122.476013583462) | |
| 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) | |
| 134391 | 134391 | 37793 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | |
| 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) | |
| 183224 | 183224 | 38114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | |
| 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) | |
| 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) | |
| 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) | |
| 172513 | 172513 | 38214 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.3016599999 | 37.7257240567036 | -122.40557203921499 | (37.7257240567036, -122.405572039215) | |
| 155330 | 155330 | 38225 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1099 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 13 | Permit Number 40351 | 6014263.22127 | 2102058.4146 | 37.7526539784223 | -122.39354880945 | (37.7526539784223, -122.39354880945) | ||
| 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) | ||
| 154866 | 154866 | 38552 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.729747018873205 | -122.389154637038 | (37.7297470188732, -122.389154637038) | |
| 179857 | 179857 | 38581 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.38744993888399 | (37.7309688285238, -122.387449938884) | |
| 100555 | 100555 | 38954 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 293 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50374 | 6000154.66929043 | 2094929.77821336 | 37.73228640687 | -122.441826941763 | (37.73228640687, -122.441826941763) | ||
| 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) | ||
| 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) | |
| 136637 | 136637 | 39933 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.713822785758296 | -122.406266946271 | (37.7138227857583, -122.406266946271) | |
| 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) | |
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 180152 | 180152 | 44242 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4007 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | 7 | Permit Number 43678 | 5983296.4831 | 2106264.529 | 37.7624334942373 | -122.50094657176099 | (37.7624334942373, -122.500946571761) | ||
| 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) | ||
| 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) | |
| 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) | |
| 95937 | 95937 | 47054 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603002 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | |||
| 124048 | 124048 | 47055 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603002 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | ||
| 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) | |
| 134847 | 134847 | 47455 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45361 | 5983102.34627 | 2110320.59838 | 37.7735588969863 | -122.501918137817 | (37.7735588969863, -122.501918137817) | |
| 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) | |
| 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) | ||
| 186613 | 186613 | 52520 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.7166900001 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | |
| 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) |
| 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) | |
| 165262 | 165262 | 53160 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1747@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 8 | Permit Number 49080 | 6014477.38224 | 2095160.1105 | 37.73372457041361 | -122.39232575933201 | (37.7337245704136, -122.392325759332) | |
| 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) | ||
| 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) | ||
| 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) | |
| 114872 | 114872 | 55367 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 166 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | Permit Number 11301 | 5993332.6421826 | 2094501.86251048 | 37.730720369862 | -122.46538098284799 | (37.730720369862, -122.465380982848) | ||
| 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) | |||
| 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) | ||
| 118235 | 118235 | 59173 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 327 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1992 12:00:00 AM | Permit Number 18486 | 6003820.21364245 | 2098630.45378724 | 37.742655803759 | -122.429418128827 | (37.742655803759, -122.429418128827) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 95707 | 95707 | 62373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 451 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | ||
| 125368 | 125368 | 62444 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 221 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | Permit Number 25105 | 6005138.76094737 | 2098996.79373606 | 37.7437362535856 | -122.424885027142 | (37.7437362535856, -122.424885027142) | ||
| 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) | ||
| 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) | ||
| 166631 | 166631 | 62982 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1391 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 20 | Permit Number 30047 | 6006920.35815 | 2118393.21581 | 37.7970946941148 | -122.420100923242 | (37.7970946941148, -122.420100923242) | |
| 91065 | 91065 | 63004 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.737000082845704 | -122.417307379598 | (37.7370000828457, -122.417307379598) |
| 107153 | 107153 | 63129 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | ||
| 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) |
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");