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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |||||
| 142093 | 142093 | 49037 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.75010793907921 | -122.429604025448 | (37.7501079390792, -122.429604025448) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 149721 | 149721 | 125500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.41895432719299 | (37.7995302219096, -122.418954327193) | ||||
| 152994 | 152994 | 37651 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.8860400002 | 37.776550828957504 | -122.477359640658 | (37.7765508289575, -122.477359640658) | |
| 159071 | 159071 | 125499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007355.47144 | 2119286.0885099997 | 37.799570804701396 | -122.418658671469 | (37.7995708047014, -122.418658671469) | ||||
| 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) | |
| 159436 | 159436 | 51699 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.913509999 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | ||
| 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) | ||
| 164200 | 164200 | 189164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6014453.294530001 | 2102557.3777799997 | 37.754034584334605 | -122.392926403935 | (37.7540345843346, -122.392926403935) | ||||
| 164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
| 167943 | 167943 | 31087 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 61 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34823 | 6005643.9795699995 | 2108712.30745 | 37.7704413103375 | -122.42382878848 | (37.7704413103375, -122.42382878848) | |
| 170476 | 170476 | 37652 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 5 | Permit Number 40063 | 5990267.40387 | 2111259.21957 | 37.7765543890648 | -122.477202007865 | (37.7765543890648, -122.477202007865) | |
| 173180 | 173180 | 66747 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | |
| 174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
| 174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
| 175782 | 175782 | 33291 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37451 | 6009219.70147 | 2117007.84258 | 37.7934200822178 | -122.412046646261 | (37.7934200822178, -122.412046646261) | |
| 178837 | 178837 | 92978 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009889.177999999 | 2113928.0150200003 | 37.7850011562254 | -122.409512732628 | (37.7850011562254, -122.409512732628) | ||
| 179368 | 179368 | 37653 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.837669999 | 2111259.2640400003 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | |
| 183063 | 183063 | 34667 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.0104900002 | 37.798287972172396 | -122.43244168475799 | (37.7982879721724, -122.432441684758) | ||
| 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) | ||||
| 184444 | 184444 | 66783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.755609999 | 2120327.60903 | 37.80235300495529 | -122.42349323614799 | (37.8023530049553, -122.423493236148) | |
| 185094 | 185094 | 52182 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.3864700003 | 37.777907863296704 | -122.410641078729 | (37.7779078632967, -122.410641078729) | |
| 185204 | 185204 | 203464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999389.85516 | 2094399.0679799998 | 37.730785591378606 | -122.44443294273701 | (37.7307855913786, -122.444432942737) | ||||
| 186805 | 186805 | 34852 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.6555699995 | 2104887.53933 | 37.760413499914996 | -122.394284848775 | (37.760413499915, -122.394284848775) | ||
| 186976 | 186976 | 62043 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.240119999 | 2112760.57959 | 37.782031980627295 | -122.394782327659 | (37.7820319806273, -122.394782327659) | ||
| 7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
| 17640 | 17640 | 4490 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | ||
| 18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
| 22388 | 22388 | 7124 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.787805844908796 | -122.42380084655301 | (37.7878058449088, -122.423800846553) | ||
| 22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
| 22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
| 22606 | 22606 | 7130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | ||
| 22608 | 22608 | 9889 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005347.08674 | 2115527.81747 | 37.78913826426621 | -122.425340821331 | (37.7891382642662, -122.425340821331) | |||
| 22660 | 22660 | 28058 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.0390099995 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | ||
| 22690 | 22690 | 28059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | ||
| 22731 | 22731 | 7128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.787613391789705 | -122.424802721882 | (37.7876133917897, -122.424802721882) | ||
| 79867 | 79867 | 16399 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 80299 | 80299 | 28777 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 80980 | 80980 | 27672 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 81629 | 81629 | 27670 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 84998 | 84998 | 16401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 90024 | 90024 | 27668 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 90399 | 90399 | 27665 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
| 90762 | 90762 | 16404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 92549 | 92549 | 27666 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
| 94446 | 94446 | 27669 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 94567 | 94567 | 16912 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 474 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.774538702608396 | -122.42709732349701 | (37.7745387026084, -122.427097323497) | |||
| 95583 | 95583 | 24521 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 100083 | 100083 | 8408 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | ||
| 104455 | 104455 | 24519 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 106158 | 106158 | 16913 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.774317282432705 | -122.42713137468999 | (37.7743172824327, -122.42713137469) | |||
| 110335 | 110335 | 24520 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 111562 | 111562 | 27667 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
| 115405 | 115405 | 24518 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 117237 | 117237 | 24504 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005526.31532 | 2114998.99681 | 37.787696378772296 | -122.424683078077 | (37.7876963787723, -122.424683078077) | |||
| 118715 | 118715 | 27671 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 119097 | 119097 | 8435 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | ||
| 120146 | 120146 | 16406 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 121736 | 121736 | 16403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 121821 | 121821 | 17031 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.43844479592501 | (37.7730732545652, -122.438444795925) | |||
| 122310 | 122310 | 16400 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 122812 | 122812 | 16907 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004778.478730001 | 2110233.49325 | 37.774569219476206 | -122.426930917012 | (37.7745692194762, -122.426930917012) | |||
| 124922 | 124922 | 17121 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997743.8504099995 | 2109170.01524 | 37.7712489089965 | -122.45118824582701 | (37.7712489089965, -122.451188245827) | |||
| 126087 | 126087 | 16391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 248X Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 3 | 3X3 | 6006237.34556 | 2114081.50477 | 37.785217303604796 | -122.422157838958 | (37.7852173036048, -122.422157838958) | ||
| 127147 | 127147 | 17018 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.7796099996 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | ||
| 139087 | 139087 | 24505 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005509.85054 | 2114996.70292 | 37.787689150419 | -122.424739879851 | (37.787689150419, -122.424739879851) | |||
| 140160 | 140160 | 17102 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.44794034143601 | (37.771661239802, -122.447940341436) | |||
| 143787 | 143787 | 16405 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 145083 | 145083 | 16402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
| 7088 | 7088 | 107943 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | |||
| 8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
| 8942 | 8942 | 19287 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | |||
| 10269 | 10269 | 91500 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350553999 | (37.784734187987, -122.40946350554) | |
| 11423 | 11423 | 110030 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.5181900002 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) |
| 12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
| 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) |
| 22516 | 22516 | 7126 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.585390001 | 2115024.0954299998 | 37.7877762068484 | -122.42401618562201 | (37.7877762068484, -122.424016185622) | ||
| 22560 | 22560 | 7122 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.457909999 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) |
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");