Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
| 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) | ||
| 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) | ||
| 24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
| 27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
| 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) | |||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 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) | |||
| 36512 | 36512 | 175167 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | |||
| 36697 | 36697 | 220597 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | |||
| 40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
| 44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
| 48362 | 48362 | 125504 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6007489.69173 | 2120199.0729400003 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | |||
| 48836 | 48836 | 203495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999677.596390001 | 2094931.24105 | 37.732263227850204 | -122.443476391437 | (37.7322632278502, -122.443476391437) | |||
| 49008 | 49008 | 125522 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | |||
| 51580 | 51580 | 189194 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843001 | (37.7675077191257, -122.40157469843) | |||
| 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) | |||
| 53916 | 53916 | 220624 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002066.32428 | 2102040.31203 | 37.7519190137697 | -122.435726468425 | (37.7519190137697, -122.435726468425) | |||
| 54829 | 54829 | 221760 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.43826897865101 | (37.7574116654297, -122.438268978651) | |||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 61016 | 61016 | 125467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.791363680726796 | -122.413784882888 | (37.7913636807268, -122.413784882888) | |||
| 69728 | 69728 | 125437 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.44406922002199 | (37.8045448847905, -122.444069220022) | |||
| 70634 | 70634 | 189160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008158.83722 | 2109400.5814099996 | 37.772472797918 | -122.415178587445 | (37.772472797918, -122.415178587445) | |||
| 76565 | 76565 | 220629 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000561.393680001 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | |||
| 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) | |||
| 86792 | 86792 | 96257 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 92432 | 92432 | 32708 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 3 | 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) | ||
| 93445 | 93445 | 33004 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 3 | 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) | ||
| 97534 | 97534 | 24506 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005494.49314 | 2114994.9262200003 | 37.7876834046589 | -122.424792887097 | (37.7876834046589, -122.424792887097) | |||
| 101834 | 101834 | 96061 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | 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) | |
| 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) | |||
| 106188 | 106188 | 91501 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 52121 | 6009912.0 | 2113772.0 | 37.784574054907104 | -122.40942276104201 | (37.7845740549071, -122.409422761042) | ||
| 108997 | 108997 | 33369 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 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) | |||
| 118745 | 118745 | 49034 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 3 | 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) | ||
| 122429 | 122429 | 94132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | ||
| 124461 | 124461 | 30606 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 131790 | 131790 | 189183 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6013471.29582 | 2110911.4086700003 | 37.7769183095594 | -122.396908085761 | (37.7769183095594, -122.396908085761) | |||
| 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) | |||
| 136680 | 136680 | 203485 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | |||
| 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) | |||||
| 148413 | 148413 | 203491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.733744960750705 | -122.44270283418899 | (37.7337449607507, -122.442702834189) | |||
| 148756 | 148756 | 249948 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820376998 | (37.8018992421182, -122.40492820377) | |||
| 149006 | 149006 | 175172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003774.221480001 | 2091143.66189 | 37.7220961573958 | -122.42904347588998 | (37.7220961573958, -122.42904347589) | |||
| 150901 | 150901 | 220636 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002799.74223 | 2095713.6411400002 | 37.734589079726 | -122.43273830362699 | (37.734589079726, -122.432738303627) | |||
| 152079 | 152079 | 220653 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008119.35429 | 2096079.0254799998 | 37.7358926083592 | -122.41437240636002 | (37.7358926083592, -122.41437240636) | |||
| 152269 | 152269 | 220631 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000591.194080001 | 2101959.06133 | 37.751612018500204 | -122.440821836477 | (37.7516120185002, -122.440821836477) | |||
| 152920 | 152920 | 203479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | |||
| 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) | |||
| 158252 | 158252 | 221757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.43933259334699 | (37.7579519799282, -122.439332593347) | |||
| 159610 | 159610 | 249987 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | |||
| 160003 | 160003 | 99402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 164426 | 164426 | 125476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.792915476223705 | -122.41194003791 | (37.7929154762237, -122.41194003791) | |||
| 167060 | 167060 | 125489 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007615.8266900005 | 2115821.7314400002 | 37.7900731949784 | -122.417512084408 | (37.7900731949784, -122.417512084408) | |||
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 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) | |
| 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) | |||
| 172051 | 172051 | 249551 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.787680143969496 | -122.424807261672 | (37.7876801439695, -122.424807261672) | |||
| 172117 | 172117 | 125492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.42338828343901 | (37.8023660361287, -122.423388283439) | |||
| 172575 | 172575 | 125528 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Miller Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010067.56823 | 2116961.5742099998 | 37.7933405749546 | -122.409109685279 | (37.7933405749546, -122.409109685279) | |||
| 172952 | 172952 | 248094 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010447.33936 | 2099861.6956599997 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | |||
| 173529 | 173529 | 125459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002302.24315 | 2117372.6414900003 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | |||
| 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) | |||
| 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) | |
| 175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
| 176261 | 176261 | 125470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.79079101674171 | -122.40901798411501 | (37.7907910167417, -122.409017984115) | |||
| 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) | |||
| 181941 | 181941 | 250077 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | |||
| 185533 | 185533 | 125481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6009481.637490001 | 2116293.5320200003 | 37.791473451975605 | -122.41108984583201 | (37.7914734519756, -122.411089845832) |
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");