trees
665 rows where qSpecies_id = 89 sorted by TreeID descending
This data as json, CSV (advanced)
rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114783 | 99408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
184139 | 99406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
139862 | 99405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
129408 | 99404 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
140669 | 99403 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
103501 | 99402 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
43231 | 99401 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
144868 | 97942 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
175348 | 97941 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
97400 | 97940 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
152220 | 96259 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
72046 | 96257 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
33164 | 96256 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
136678 | 96255 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
104611 | 96061 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
182643 | 96060 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
42265 | 96059 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
131468 | 95783 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767527 | 6009054 | 2104485 | 37.7590260110101 | -122.411734726588 | (37.7590260110101, -122.411734726588) | 2 | 4 | 7 | 28859 | 19 | |
171547 | 95678 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 307 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767430 | 6009637.5069 | 2092959.36639 | 37.7274118548521 | -122.408903491428 | (37.7274118548521, -122.408903491428) | 10 | 3 | 7 | 309 | 28 |
180103 | 95587 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153 | 2112651 | 37.7816213577124 | -122.401590796207 | (37.7816213577124, -122.401590796207) | 6 | 2 | 9 | 28856 | 34 | |
131214 | 95368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2011 12:00:00 AM | 3x3 | Permit Number 767465 | 5999728 | 2101957 | 37.7515571607552 | -122.443806713729 | (37.7515571607552, -122.443806713729) | 2 | 5 | 5 | 63 | 38 | ||
172548 | 94178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1379 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53590 | 6011748.15969 | 2101956.87191 | 37.7522350957877 | -122.402239247057 | (37.7522350957877, -122.402239247057) | 10 | 3 | 8 | 28856 | 29 | |
162633 | 94132 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | ||
101343 | 94131 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | ||
173885 | 92979 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575 | (37.78494212831, -122.40950424575) | 14 | 10 | 9 | 28852 | 36 | ||
133287 | 92978 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009889.178 | 2113928.01502 | 37.7850011562254 | -122.409512732628 | (37.7850011562254, -122.409512732628) | 14 | 10 | 9 | 28852 | 36 | ||
158434 | 92783 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | ||
117987 | 92782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | |||
128968 | 92753 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.78777 | 37.8021663758311 | -122.446615526285 | (37.8021663758311, -122.446615526285) | 13 | 9 | 1 | 57 | 17 | |
14262 | 92752 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | 13 | 9 | 1 | 57 | 17 | |
133085 | 92446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) | 1 | 8 | 3 | 56 | 35 |
177681 | 92445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
142633 | 92417 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1579 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52809 | 5984633.3 | 2104450.5 | 37.7575310784342 | -122.496189239645 | (37.7575310784342, -122.496189239645) | 1 | 8 | 3 | 56 | 35 | |
49047 | 92416 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 | |
131834 | 92415 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 |
131175 | 91501 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 52121 | 6009912 | 2113772 | 37.7845740549071 | -122.409422761042 | (37.7845740549071, -122.409422761042) | 14 | 10 | 9 | 28852 | 36 | ||
21935 | 91500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350554 | (37.784734187987, -122.40946350554) | 14 | 10 | 9 | 28852 | 36 | |
178191 | 91499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | 14 | 10 | 9 | 28852 | 36 | |
106011 | 91377 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 49 Seward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52069 | 6000873 | 2104304 | 37.7580666971462 | -122.440015443053 | (37.7580666971462, -122.440015443053) | 2 | 4 | 5 | 28862 | 38 | |||
182650 | 88208 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 607 Central Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | 15 | 5 | 11 | 29492 | 16 | |||
84641 | 88118 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.443725322035 | (37.7516991466356, -122.443725322035) | 2 | 5 | 5 | 63 | 38 | ||
159467 | 86884 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2534 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.7392229927812 | -122.504282496051 | (37.7392229927812, -122.504282496051) | 1 | 8 | 3 | 29491 | 35 | |||
414 | 8435 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | 13 | 9 | 11 | 29490 | 13 | ||
100280 | 8408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711 | (37.7849669496355, -122.42916474711) | 13 | 9 | 11 | 29490 | 13 | ||
58303 | 81183 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | 2 | 7 | 7 | 28859 | 2 | ||
89611 | 79973 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.86124 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | 9 | 7 | 6 | 28861 | 25 | |
53345 | 79776 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.08638 | 37.7519189391152 | -122.401951552136 | (37.7519189391152, -122.401951552136) | 10 | 3 | 8 | 28856 | 29 | |
101124 | 71559 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 919 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772718 | 6007599.61852401 | 2104303.467284 | 37.758445868977 | -122.416751817847 | (37.758445868977, -122.416751817847) | 2 | 4 | 7 | 28859 | 19 |
156024 | 7130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | 13 | 9 | 1 | 28858 | 41 | ||
98180 | 7129 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.65603 | 37.7876230577135 | -122.424742207381 | (37.7876230577135, -122.424742207381) | 13 | 9 | 1 | 28858 | 41 | ||
145672 | 7128 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.7876133917897 | -122.424802721882 | (37.7876133917897, -122.424802721882) | 13 | 9 | 1 | 28858 | 41 | ||
148477 | 7127 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.25762 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | 13 | 9 | 1 | 28858 | 41 | ||
139279 | 7126 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.58539 | 2115024.09543 | 37.7877762068484 | -122.424016185622 | (37.7877762068484, -122.424016185622) | 13 | 9 | 1 | 28858 | 41 | ||
20279 | 7125 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.17658 | 2115026.96294 | 37.7877851299198 | -122.423952067531 | (37.7877851299198, -122.423952067531) | 13 | 9 | 1 | 28858 | 41 | ||
151012 | 7124 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.7878058449088 | -122.423800846553 | (37.7878058449088, -122.423800846553) | 13 | 9 | 1 | 28858 | 41 | ||
30986 | 7123 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.423746004087 | (37.7878131752727, -122.423746004087) | 13 | 9 | 1 | 28858 | 41 | ||
98897 | 7122 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.45791 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | 13 | 9 | 1 | 28858 | 41 | ||
89307 | 70577 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 3 | 4x4 | Permit Number 50063 | 5992415.28352 | 2114057.951 | 37.7843633240791 | -122.469975767472 | (37.7843633240791, -122.469975767472) | 11 | 6 | 2 | 54 | 11 | |
16090 | 70151 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.417304870747 | (37.786282435643, -122.417304870747) | 13 | 1 | 9 | 28858 | 36 | |||
186795 | 69515 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.7377003998713 | -122.412084952925 | (37.7377003998713, -122.412084952925) | 10 | 7 | 7 | 28859 | 2 | ||
185576 | 69035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | 1 | 8 | 3 | 56 | 35 | ||
62150 | 67492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.402564065097 | (37.7556157939465, -122.402564065097) | 10 | 3 | 8 | 28856 | 29 | |
87958 | 66924 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.416415794383 | (37.7413986874365, -122.416415794383) | 2 | 7 | 7 | 28859 | 2 | ||
106703 | 66898 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | 2 | 7 | 7 | 28859 | 2 | ||
98782 | 66897 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | 2 | 7 | 7 | 28859 | 2 | ||
115971 | 66783 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.75561 | 2120327.60903 | 37.8023530049553 | -122.423493236148 | (37.8023530049553, -122.423493236148) | 5 | 9 | 1 | 28858 | 32 | |
3907 | 66747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | 11 | 6 | 2 | 55 | 26 | |
115360 | 66399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1991 12:00:00 AM | 11 | 4.5x12 | Permit Number 29525 | 6007445.41695715 | 2096473.5258201 | 37.7369379378565 | -122.41673042001 | (37.7369379378565, -122.41673042001) | 2 | 7 | 7 | 28859 | 2 | |
64382 | 66177 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.7396048925803 | -122.41021864302 | (37.7396048925803, -122.41021864302) | 10 | 7 | 7 | 28859 | 2 | ||
78118 | 66176 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.7395070660178 | -122.410227607366 | (37.7395070660178, -122.410227607366) | 10 | 7 | 7 | 28859 | 2 | ||
51367 | 65437 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.7829882723647 | -122.411968925085 | (37.7829882723647, -122.411968925085) | 14 | 10 | 9 | 28852 | 36 | ||
68515 | 65417 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 887 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | Permit Number 28274 | 6009256.60978604 | 2115652.27846796 | 37.7897001035195 | -122.411823108686 | (37.7897001035195, -122.411823108686) | 5 | 1 | 10 | 28857 | 21 | ||
36154 | 64967 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.7990657940144 | -122.426979209822 | (37.7990657940144, -122.426979209822) | 13 | 9 | 1 | 57 | 17 | |
117721 | 64654 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1315 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1988 12:00:00 AM | Permit Number 25578 | 6006760.4974846 | 2115419.54547338 | 37.7889207278004 | -122.420442899695 | (37.7889207278004, -122.420442899695) | 13 | 9 | 10 | 28858 | 21 | ||
69885 | 63536 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 337 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24149 | 6006745.70850466 | 2104155.29441199 | 37.7579909553953 | -122.419694511877 | (37.7579909553953, -122.419694511877) | 2 | 4 | 7 | 28859 | 19 | ||
155653 | 63535 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 343 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24148 | 6006747.55377608 | 2104121.784718 | 37.7578990494792 | -122.419685752558 | (37.7578990494792, -122.419685752558) | 2 | 4 | 7 | 28859 | 19 | ||
118456 | 62043 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.24012 | 2112760.57959 | 37.7820319806273 | -122.394782327659 | (37.7820319806273, -122.394782327659) | 6 | 2 | 9 | 28856 | 6 | ||
115495 | 59475 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30019 | 6005649.89083993 | 2108784.60921416 | 37.7706401673343 | -122.423813483184 | (37.7706401673343, -122.423813483184) | 8 | 2 | 5 | 28853 | 19 | ||
135153 | 57875 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 411 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1997 12:00:00 AM | Permit Number 16823 | 6009320.51611206 | 2114267.52405605 | 37.7859014867053 | -122.411504124328 | (37.7859014867053, -122.411504124328) | 14 | 10 | 9 | 28852 | 36 | ||
157818 | 53452 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010475.69688316 | 2099901.56098952 | 37.7465205531872 | -122.406494829187 | (37.7465205531872, -122.406494829187) | 2 | 7 | 7 | 28859 | 2 | ||
133628 | 52182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.38647 | 37.7779078632967 | -122.410641078729 | (37.7779078632967, -122.410641078729) | 8 | 2 | 9 | 28853 | 34 | |
111073 | 51699 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.91351 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | 10 | 3 | 7 | 309 | 28 | ||
79790 | 51611 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
72406 | 51468 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.413570470462 | (37.7370397099418, -122.413570470462) | 2 | 7 | 7 | 28859 | 2 |
58068 | 51467 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.413570470462 | (37.7370397099418, -122.413570470462) | 2 | 7 | 7 | 28859 | 2 | ||
180503 | 51460 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
35568 | 51459 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
87846 | 50391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.7328303156217 | -122.455320609685 | (37.7328303156217, -122.455320609685) | 9 | 7 | 4 | 59 | 40 | ||
129213 | 50096 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2005 12:00:00 AM | Permit Number 47882 | 5993030.04532242 | 2099099.0201688 | 37.7433255578151 | -122.466761150098 | (37.7433255578151, -122.466761150098) | 1 | 8 | 4 | 59 | 40 | ||
68653 | 50078 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.472228150036 | (37.7382952135341, -122.472228150036) | 1 | 8 | 4 | 29491 | 40 | ||
116961 | 50076 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.7383668512451 | -122.472233215714 | (37.7383668512451, -122.472233215714) | 1 | 8 | 4 | 29491 | 40 | ||
53152 | 50074 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | 1 | 8 | 4 | 29491 | 40 | ||
5122 | 50073 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.7390195978985 | -122.472099259809 | (37.7390195978985, -122.472099259809) | 1 | 8 | 4 | 29491 | 40 | ||
179660 | 49037 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | |
132417 | 49036 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );