Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137147 | 137147 | 220593 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008525.9203 | 2107974.98193 | 37.768579058113104 | -122.413807947778 | (37.7685790581131, -122.413807947778) | |||
| 156031 | 156031 | 220594 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.768587792328894 | -122.413650808341 | (37.7685877923289, -122.413650808341) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 154701 | 154701 | 220611 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009641.7814 | 2098664.7156700003 | 37.743077758937105 | -122.40929116218399 | (37.7430777589371, -122.409291162184) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38916 | 38916 | 125482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.41113140348499 | (37.7914679787239, -122.411131403485) | |||
| 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) | |||
| 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) | |||
| 89015 | 89015 | 66177 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.739604892580296 | -122.41021864302 | (37.7396048925803, -122.41021864302) | ||
| 163606 | 163606 | 220643 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.739520706418396 | -122.410190999519 | (37.7395207064184, -122.410190999519) | |||
| 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) | |||
| 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) | ||||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 66904 | 66904 | 203470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999333.68862 | 2093807.8865599998 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | ||||
| 185192 | 185192 | 189165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | |||
| 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) | |||
| 150526 | 150526 | 125502 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6007468.42884 | 2120195.8771599997 | 37.8020752142594 | -122.41833233898701 | (37.8020752142594, -122.418332338987) | |||
| 161839 | 161839 | 125503 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6007472.5485 | 2120196.7006200003 | 37.802077707171605 | -122.418318141382 | (37.8020777071716, -122.418318141382) | |||
| 90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 60506 | 60506 | 203484 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | |||
| 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) | |||
| 165566 | 165566 | 203486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.088169999 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | |||
| 78317 | 78317 | 96059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | 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) | |
| 100078 | 100078 | 94131 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | 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) | ||
| 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) | |
| 118016 | 118016 | 53452 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010475.69688316 | 2099901.56098952 | 37.7465205531872 | -122.406494829187 | (37.7465205531872, -122.406494829187) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 46216 | 46216 | 189159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | |||
| 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) | |||
| 132055 | 132055 | 189161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.41521025345699 | (37.7724477670719, -122.415210253457) | |||
| 186745 | 186745 | 189158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008181.208740001 | 2109420.17856 | 37.7725278642987 | -122.41510258932301 | (37.7725278642987, -122.415102589323) | |||
| 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) | |||
| 58353 | 58353 | 125529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | |||
| 71399 | 71399 | 125537 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.43392 | 2116876.79887 | 37.7931084671277 | -122.409062644443 | (37.7931084671277, -122.409062644443) | |||
| 131931 | 131931 | 125538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010079.834919999 | 2116873.2549900003 | 37.793098758955395 | -122.409061006782 | (37.7930987589554, -122.409061006782) | |||
| 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) | |||
| 150359 | 150359 | 125533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010078.6629 | 2116885.41787 | 37.7931320896218 | -122.40906592066901 | (37.7931320896218, -122.409065920669) | |||
| 161599 | 161599 | 125530 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010077.8438099995 | 2116891.68093 | 37.7931492405824 | -122.40906919691002 | (37.7931492405824, -122.40906919691) | |||
| 168469 | 168469 | 125534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953004 | -122.409064282098 | (37.793125940953, -122.409064282098) | |||
| 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) | |||
| 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) | |||
| 55076 | 55076 | 125501 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007553.747280001 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | |||
| 14649 | 14649 | 67492 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.40256406509701 | (37.7556157939465, -122.402564065097) | |
| 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) | |||
| 160402 | 160402 | 203463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.731015444602896 | -122.43964672024099 | (37.7310154446029, -122.439646720241) | |||
| 73487 | 73487 | 125479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1133 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009244.74147 | 2117035.03683 | 37.793496155866706 | -122.411961928316 | (37.7934961558667, -122.411961928316) | |||
| 67240 | 67240 | 125498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | |||
| 165596 | 165596 | 125497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6006282.866880001 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | |||
| 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) | |||
| 48661 | 48661 | 125469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.791401184258795 | -122.413517591782 | (37.7914011842588, -122.413517591782) | |||
| 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) | |||
| 118179 | 118179 | 125465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.41392705669399 | (37.7913483149251, -122.413927056694) | |||
| 136527 | 136527 | 125466 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6008683.65979 | 2116266.52541 | 37.7913545166392 | -122.413848933479 | (37.7913545166392, -122.413848933479) | |||
| 168173 | 168173 | 125468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | |||
| 101512 | 101512 | 66924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.41641579438298 | (37.7413986874365, -122.416415794383) | ||
| 105612 | 105612 | 49036 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 4 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 170184 | 170184 | 220663 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696546999 | (37.7501903863949, -122.42961696547) | |||
| 27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
| 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) | ||||
| 132131 | 132131 | 220639 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5997451.780119999 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | |||
| 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) | |||||
| 35121 | 35121 | 125494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | |||
| 45984 | 45984 | 125495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.802382621428706 | -122.423246597049 | (37.8023826214287, -122.423246597049) | |||
| 71919 | 71919 | 125496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6006063.84143 | 2120339.6871599997 | 37.802390914060204 | -122.42320311664899 | (37.8023909140602, -122.423203116649) | |||
| 76694 | 76694 | 125491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005994.09185 | 2120329.4714599997 | 37.8023589278732 | -122.42344375814599 | (37.8023589278732, -122.423443758146) | |||
| 149835 | 149835 | 125493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006021.473809999 | 2120333.6545700002 | 37.8023719590496 | -122.42334930055401 | (37.8023719590496, -122.423349300554) | |||
| 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) | |||
| 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) | |
| 175547 | 175547 | 189180 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.39907951143101 | (37.7845788525671, -122.399079511431) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 121499 | 121499 | 37576 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918002 | (37.7601298795068, -122.44341407918) | ||
| 47327 | 47327 | 201923 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 125 Elmira St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.735865039640395 | -122.403662651736 | (37.7358650396404, -122.403662651736) | |||
| 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) | |
| 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) | |
| 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) | ||
| 176841 | 176841 | 91499 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | |
| 63274 | 63274 | 203472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 126 Howth St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.721728810427706 | -122.450411736413 | (37.7217288104277, -122.450411736413) | |||
| 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) |
| 60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
| 33358 | 33358 | 220588 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1285 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010337.44954 | 2101779.52105 | 37.7516692837277 | -122.40710522684499 | (37.7516692837277, -122.407105226845) |
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");