trees
665 rows where qSpecies_id = 89 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142171 | 33292 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 160 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | 3 | 1 | 10 | 28857 | 21 | ||
142231 | 31949 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
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 | |
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 | |||||
148923 | 38937 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.7254190951466 | -122.471123685701 | (37.7254190951466, -122.471123685701) | 9 | 8 | 4 | 59 | 40 | ||
150762 | 34186 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
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 | ||
152789 | 38941 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2001 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.7253648428023 | -122.471306529261 | (37.7253648428023, -122.471306529261) | 9 | 8 | 4 | 59 | 40 | ||
154300 | 37067 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39669 | 6003676.44308345 | 2099207.16082517 | 37.7442311672419 | -122.429956374539 | (37.7442311672419, -122.429956374539) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
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 | ||
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 | ||
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 | |||
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 | ||
163753 | 42785 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 269 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.7741284823912 | -122.425255647592 | (37.7741284823912, -122.425255647592) | 7 | 9 | 11 | 28852 | 10 | ||
164516 | 45290 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 600 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | 2 | 7 | 7 | 28859 | 2 | |||
165775 | 34188 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
167430 | 37576 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918 | (37.7601298795068, -122.44341407918) | 2 | 4 | 5 | 28862 | 3 | ||
167613 | 33368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
168006 | 49034 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 3 | 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 | ||
170131 | 45807 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.470920456526 | (37.7509526116716, -122.470920456526) | 1 | 8 | 4 | 29491 | 12 | |||
170746 | 38961 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.7432621510095 | -122.406749540855 | (37.7432621510095, -122.406749540855) | 10 | 7 | 7 | 28859 | 2 | ||
174368 | 32129 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | 3 | 1 | 10 | 28857 | 4 | ||
174438 | 31950 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
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 | |||||
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 | |
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 | ||
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 | |
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 | |||
184137 | 46752 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||
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 | ||
186226 | 32707 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
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 | |||||
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 | ||
187634 | 32133 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
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 | |||||
189014 | 49035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | 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 | ||
189305 | 30607 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | |
189904 | 33365 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
191382 | 33001 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
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 |
21355 | 125539 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.7945246709392 | -122.407399099212 | (37.7945246709392, -122.407399099212) | 3 | 1 | 10 | 28857 | 4 | |||
22266 | 189179 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012646.32236 | 2115321.24239 | 37.7889807363318 | -122.400071707361 | (37.7889807363318, -122.400071707361) | 12 | 2 | 9 | 28855 | 6 | |||
24163 | 220599 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 714 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010100.45141 | 2104938.60727 | 37.7603301624296 | -122.408147577953 | (37.7603301624296, -122.408147577953) | 2 | 4 | 8 | 28859 | 19 | |||
24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
30380 | 220601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.405769837005 | (37.7468607265348, -122.405769837005) | 2 | 7 | 7 | 28859 | 2 | |||
32468 | 189167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 18 | Median : Yard | Tree | DPW 1 | 1 | 6012264.80612 | 2102152.75254 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | 10 | 3 | 8 | 28856 | 29 | ||||
33000 | 220606 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.7355851472373 | -122.41746095617 | (37.7355851472373, -122.41746095617) | 2 | 7 | 7 | 28859 | 2 | |||
36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
38146 | 220652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | 2 | 7 | 7 | 28859 | 2 | |||
44724 | 125536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010079.47478 | 2116878.80155 | 37.7931139682908 | -122.409062644439 | (37.7931139682908, -122.409062644439) | 3 | 1 | 10 | 28857 | 4 | |||
45630 | 120025 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987224.82866 | 2110876.63769 | 37.7753269317853 | -122.487698901899 | (37.7753269317853, -122.487698901899) | 11 | 6 | 2 | 55 | 26 | |||
46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |
62853 | 250093 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.7893943794989 | -122.425398617158 | (37.7893943794989, -122.425398617158) | 13 | 9 | 1 | 28858 | 41 | |||
63181 | 203460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998498.64412 | 2094367.64391 | 37.7306484177731 | -122.447511726809 | (37.7306484177731, -122.447511726809) | 9 | 7 | 4 | 28861 | 40 | |||
64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 | |||
67570 | 189177 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | 12 | 2 | 9 | 28855 | 6 | |||
71039 | 220661 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | 2 | 7 | 7 | 28859 | 2 | |||
71615 | 125510 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.7989384014533 | -122.414228184789 | (37.7989384014533, -122.414228184789) | 5 | 1 | 10 | 308 | 32 | |||
72741 | 125513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008593.29487 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | 5 | 1 | 10 | 308 | 32 | |||
75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
76065 | 175158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.441868929714 | (37.7250771680567, -122.441868929714) | 9 | 7 | 6 | 28861 | 25 | |||
77941 | 125515 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | 5 | 1 | 10 | 308 | 32 | |||
82943 | 44822 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 209 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2001 12:00:00 AM | 1 | Permit Number 43915 | 5993346.02796 | 2114050.28592 | 37.7843960368297 | -122.466755185011 | (37.7843960368297, -122.466755185011) | 11 | 6 | 2 | 54 | 11 | ||
83370 | 175160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | 9 | 7 | 6 | 28861 | 25 | |||
84672 | 175155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | 9 | 7 | 6 | 28861 | 25 | |||
84837 | 203444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995221.10472 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | 9 | 7 | 4 | 59 | 40 | |||
87960 | 220595 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005798.00468 | 2105985.91015 | 37.7629639655453 | -122.423102194736 | (37.7629639655453, -122.423102194736) | 8 | 4 | 5 | 28859 | 19 | |||
88481 | 203496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998101.39373 | 2095150.67529 | 37.7327757263052 | -122.448941459085 | (37.7327757263052, -122.448941459085) | 9 | 7 | 4 | 59 | 40 | |||
88927 | 220598 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006787.43083 | 2105854.68311 | 37.7626594317184 | -122.419670791888 | (37.7626594317184, -122.419670791888) | 8 | 4 | 7 | 28859 | 19 | |||
95831 | 125519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.7989271266439 | -122.414431021472 | (37.7989271266439, -122.414431021472) | 5 | 1 | 10 | 308 | 32 | |||
98841 | 175159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000090.18527 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | 9 | 7 | 6 | 28861 | 25 | |||
99651 | 249529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | 13 | 9 | 11 | 28858 | 41 | |||
105770 | 221768 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.7400514583975 | -122.426721628722 | (37.7400514583975, -122.426721628722) | 2 | 7 | 5 | 63 | 7 | |||
111278 | 175161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000095.42068 | 2092313.25863 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | 9 | 7 | 6 | 28861 | 25 | |||
117582 | 203446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.70657 | 2097826.55093 | 37.7399577427547 | -122.459101255842 | (37.7399577427547, -122.459101255842) | 9 | 7 | 4 | 59 | 40 | |||
119465 | 189175 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012666.59913 | 2115298.53532 | 37.7889195185657 | -122.399999956726 | (37.7889195185657, -122.399999956726) | 12 | 2 | 9 | 28855 | 6 | |||
121531 | 203462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.439646720213 | (37.7309725397368, -122.439646720213) | 9 | 7 | 4 | 63 | 40 | |||
124092 | 123452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | 11 | 6 | 2 | 54 | 11 | |||
125349 | 113957 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | 3 | 1 | 10 | 308 | 21 | ||
125410 | 175162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000098.01412 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | 9 | 7 | 6 | 28861 | 25 | |||
128586 | 220600 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.22738 | 2100038.82593 | 37.7469081100366 | -122.405845659758 | (37.7469081100366, -122.405845659758) | 2 | 7 | 7 | 28859 | 2 | |||
131258 | 123145 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992857.65671 | 2111637.48406 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | 11 | 6 | 2 | 54 | 11 | |||
131502 | 203477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.474801058017 | (37.7443538888309, -122.474801058017) | 1 | 8 | 4 | 29491 | 40 | |||
133109 | 175164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000102.23368 | 2092318.39014 | 37.7251131517233 | -122.441820869043 | (37.7251131517233, -122.441820869043) | 9 | 7 | 6 | 28861 | 25 | |||
135354 | 221772 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | 2 | 7 | 5 | 63 | 7 | |||
136839 | 125531 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.15064 | 2116889.31743 | 37.7931427681724 | -122.409067968409 | (37.7931427681724, -122.409067968409) | 3 | 1 | 10 | 28857 | 4 | |||
140751 | 250128 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.7891090713658 | -122.425258261764 | (37.7891090713658, -122.425258261764) | 13 | 9 | 1 | 28858 | 41 | |||
147929 | 175156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | 9 | 7 | 6 | 28861 | 25 | |||
148998 | 175154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.441897095593 | (37.7250574153596, -122.441897095593) | 9 | 7 | 6 | 28861 | 25 | |||
151616 | 39223 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.53728 | 2109997.98133 | 37.7726280682786 | -122.50454323337 | (37.7726280682786, -122.50454323337) | 11 | 6 | 2 | 55 | 26 | |
159600 | 220614 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008369.00642 | 2103859.12249 | 37.7572690437374 | -122.414059488154 | (37.7572690437374, -122.414059488154) | 2 | 4 | 7 | 28859 | 19 | |||
159811 | 125516 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.7989287139392 | -122.414387412476 | (37.7989287139392, -122.414387412476) | 5 | 1 | 10 | 308 | 32 | |||
171957 | 220662 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.423646281876 | (37.7365897745051, -122.423646281876) | 2 | 7 | 7 | 28859 | 2 | |||
175290 | 203445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.97252 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | 9 | 7 | 4 | 59 | 40 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
176774 | 220590 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 653 Duncan St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002350.00188 | 2099716.46414 | 37.7455543857324 | -122.434579325574 | (37.7455543857324, -122.434579325574) | 2 | 7 | 5 | 63 | 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) );