Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125757 | 125757 | 42094 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | ||
| 125905 | 125905 | 42092 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 37 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42398 | 6008159.28675644 | 2099396.47385495 | 37.745003834436396 | -122.414469013279 | (37.7450038344364, -122.414469013279) | ||
| 127638 | 127638 | 34191 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 128511 | 128511 | 45268 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44114 | 6008478.34688269 | 2095821.77218586 | 37.7352064067106 | -122.41311303777901 | (37.7352064067106, -122.413113037779) | ||
| 128603 | 128603 | 31948 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1677 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | ||
| 128812 | 128812 | 51459 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
| 128844 | 128844 | 34278 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.784622151593794 | -122.48837227738501 | (37.7846221515938, -122.488372277385) | ||
| 129084 | 129084 | 34184 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 129485 | 129485 | 97033 | Property Tree 7 | Afrocarpus gracilior :: Fern Pine 70 | 61 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | Possible significant tree; Nellie RoW; rear yard | 6004120.0 | 2102703.0 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | |||||
| 138603 | 138603 | 51460 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
| 138919 | 138919 | 32133 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 139907 | 139907 | 49035 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.75010793907921 | -122.429604025448 | (37.7501079390792, -122.429604025448) | ||
| 140459 | 140459 | 95587 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153.0 | 2112651.0 | 37.781621357712396 | -122.401590796207 | (37.7816213577124, -122.401590796207) | |
| 141972 | 141972 | 97941 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 142122 | 142122 | 31950 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1677 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | ||
| 142286 | 142286 | 38961 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.743262151009496 | -122.406749540855 | (37.7432621510095, -122.406749540855) | ||
| 142306 | 142306 | 30607 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | |
| 142346 | 142346 | 46752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | ||
| 142705 | 142705 | 96486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997433.0 | 2105848.0 | 37.762109700699895 | -122.452023768999 | (37.7621097006999, -122.452023768999) | |||||
| 143032 | 143032 | 69035 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | ||
| 143236 | 143236 | 97939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 143853 | 143853 | 32707 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 143899 | 143899 | 96060 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
| 144315 | 144315 | 88208 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 607 Central Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619.0 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | |||
| 144354 | 144354 | 69515 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.737700399871294 | -122.412084952925 | (37.7377003998713, -122.412084952925) | ||
| 144926 | 144926 | 33001 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 65098 | 65098 | 92415 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) |
| 24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
| 27556 | 27556 | 220598 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006787.43083 | 2105854.6831099996 | 37.7626594317184 | -122.41967079188801 | (37.7626594317184, -122.419670791888) | |||
| 29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
| 30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
| 30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
| 31097 | 31097 | 123452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | |||
| 33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
| 34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
| 35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
| 35686 | 35686 | 125515 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | |||
| 35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
| 43229 | 43229 | 220599 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010100.45141 | 2104938.60727 | 37.7603301624296 | -122.408147577953 | (37.7603301624296, -122.408147577953) | |||
| 43773 | 43773 | 189175 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012666.59913 | 2115298.5353200003 | 37.788919518565706 | -122.39999995672599 | (37.7889195185657, -122.399999956726) | |||
| 43884 | 43884 | 189176 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012661.31608 | 2115304.6540900003 | 37.7889360247231 | -122.40001866534901 | (37.7889360247231, -122.400018665349) | |||
| 44628 | 44628 | 220614 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008369.0064199995 | 2103859.12249 | 37.757269043737395 | -122.414059488154 | (37.7572690437374, -122.414059488154) | |||
| 48020 | 48020 | 189179 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012646.32236 | 2115321.2423900003 | 37.788980736331794 | -122.400071707361 | (37.7889807363318, -122.400071707361) | |||
| 49575 | 49575 | 123145 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992857.65671 | 2111637.4840599997 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | |||
| 52592 | 52592 | 220600 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010666.22738 | 2100038.82593 | 37.7469081100366 | -122.405845659758 | (37.7469081100366, -122.405845659758) | |||
| 53779 | 53779 | 120025 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987224.82866 | 2110876.6376900002 | 37.775326931785294 | -122.487698901899 | (37.7753269317853, -122.487698901899) | |||
| 54337 | 54337 | 175154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.44189709559299 | (37.7250574153596, -122.441897095593) | |||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 57123 | 57123 | 175162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000098.0141199995 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | |||
| 58639 | 58639 | 203477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.47480105801701 | (37.7443538888309, -122.474801058017) | |||
| 65811 | 65811 | 175157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | |||
| 67817 | 67817 | 125519 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.798927126643896 | -122.414431021472 | (37.7989271266439, -122.414431021472) | |||
| 70001 | 70001 | 175158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.44186892971399 | (37.7250771680567, -122.441868929714) | |||
| 76902 | 76902 | 175164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000102.2336800005 | 2092318.3901400003 | 37.7251131517233 | -122.44182086904301 | (37.7251131517233, -122.441820869043) | |||
| 102425 | 102425 | 125510 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.79893840145329 | -122.41422818478901 | (37.7989384014533, -122.414228184789) | |||
| 133155 | 133155 | 189177 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | |||
| 134317 | 134317 | 125539 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.794524670939204 | -122.407399099212 | (37.7945246709392, -122.407399099212) | |||
| 134639 | 134639 | 203462 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.43964672021299 | (37.7309725397368, -122.439646720213) | |||
| 145266 | 145266 | 39223 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.537280001 | 2109997.98133 | 37.77262806827861 | -122.50454323337 | (37.7726280682786, -122.50454323337) | |
| 147861 | 147861 | 220661 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | |||
| 149030 | 149030 | 79776 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.0863799998 | 37.75191893911521 | -122.401951552136 | (37.7519189391152, -122.401951552136) | |
| 149936 | 149936 | 125536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010079.474780001 | 2116878.80155 | 37.7931139682908 | -122.40906264443899 | (37.7931139682908, -122.409062644439) | |||
| 152559 | 152559 | 189178 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012651.667780001 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | |||
| 155006 | 155006 | 221772 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | |||
| 156172 | 156172 | 249529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | |||
| 157223 | 157223 | 123467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.45944839629601 | (37.775289512367, -122.459448396296) | |||
| 159116 | 159116 | 32706 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | |
| 160711 | 160711 | 175159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000090.185269999 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | |||
| 161024 | 161024 | 44822 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 209 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2001 12:00:00 AM | 1 | Permit Number 43915 | 5993346.02796 | 2114050.28592 | 37.784396036829705 | -122.46675518501101 | (37.7843960368297, -122.466755185011) | ||
| 167219 | 167219 | 203460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998498.644119999 | 2094367.6439099999 | 37.730648417773104 | -122.44751172680901 | (37.7306484177731, -122.447511726809) | |||
| 171195 | 171195 | 203445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.972519999 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | |||
| 172151 | 172151 | 220652 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | |||
| 172296 | 172296 | 220606 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.735585147237295 | -122.41746095616999 | (37.7355851472373, -122.41746095617) | |||
| 174293 | 174293 | 220662 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.42364628187599 | (37.7365897745051, -122.423646281876) | |||
| 174663 | 174663 | 125531 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010078.150640001 | 2116889.31743 | 37.793142768172395 | -122.409067968409 | (37.7931427681724, -122.409067968409) | |||
| 174841 | 174841 | 114540 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.4450199995 | 2104594.7801900003 | 37.7594980943773 | -122.40119249645299 | (37.7594980943773, -122.401192496453) | |
| 175422 | 175422 | 113957 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | ||
| 175671 | 175671 | 220601 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.40576983700501 | (37.7468607265348, -122.405769837005) | |||
| 176107 | 176107 | 220590 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002350.00188 | 2099716.4641400003 | 37.7455543857324 | -122.43457932557399 | (37.7455543857324, -122.434579325574) | |||
| 177273 | 177273 | 125532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.793138238302205 | -122.409066739034 | (37.7931382383022, -122.409066739034) | |||
| 178396 | 178396 | 125512 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | |||
| 178983 | 178983 | 203444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995221.104719999 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | |||
| 179679 | 179679 | 175156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | |||
| 180841 | 180841 | 221768 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.740051458397495 | -122.426721628722 | (37.7400514583975, -122.426721628722) | |||
| 181526 | 181526 | 220595 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005798.00468 | 2105985.91015 | 37.762963965545296 | -122.423102194736 | (37.7629639655453, -122.423102194736) | |||
| 182144 | 182144 | 125516 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.798928713939205 | -122.414387412476 | (37.7989287139392, -122.414387412476) | |||
| 183613 | 183613 | 175155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | |||
| 183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) | ||||
| 184886 | 184886 | 175161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000095.42068 | 2092313.2586299998 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | |||
| 185062 | 185062 | 203496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998101.393730001 | 2095150.6752900002 | 37.732775726305206 | -122.448941459085 | (37.7327757263052, -122.448941459085) | |||
| 187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) | |||
| 1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
| 19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
| 26824 | 26824 | 125535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | |||
| 30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
| 33829 | 33829 | 189162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036411998 | (37.7724260745213, -122.41525036412) | |||
| 35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) |
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");