Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3455 | 3455 | 160606 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002538.27018 | 2089198.0058799998 | 37.716683778298 | -122.43317690119301 | (37.716683778298, -122.433176901193) | ||
| 4417 | 4417 | 178030 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 10:06:00 AM | 3 | Width 3ft | 6003911.3035 | 2091023.37584 | 37.7217736371229 | -122.42856104714899 | (37.7217736371229, -122.428561047149) | |
| 4636 | 4636 | 160605 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 753 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:48:00 PM | 3 | Width 0ft | 6002503.48745 | 2089141.9591700002 | 37.7165279132188 | -122.43329312510201 | (37.7165279132188, -122.433293125102) | |
| 4643 | 4643 | 180958 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 778 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:11:00 PM | 3 | Width 2ft | 6001688.47401 | 2089452.0208 | 37.71733300339179 | -122.43613238641001 | (37.7173330033918, -122.43613238641) | |
| 4649 | 4649 | 160603 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 771 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:20:00 PM | 3 | Width 0ft | 6002439.45935 | 2089043.6154099999 | 37.7162542504093 | -122.43350741373399 | (37.7162542504093, -122.433507413734) | |
| 4675 | 4675 | 160521 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 786 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:59:00 AM | 3 | Width 0ft | 6001662.29271 | 2089410.30964 | 37.7172169863455 | -122.436219899452 | (37.7172169863455, -122.436219899452) | |
| 4678 | 4678 | 160520 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 782 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:02:00 PM | 3 | Width 0ft | 6001673.45326 | 2089428.5205599999 | 37.7172676235708 | -122.436182625252 | (37.7172676235708, -122.436182625252) | |
| 4786 | 4786 | 161115 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 580 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:13:00 PM | 3 | Width 0ft | 6003070.44185 | 2090129.12968 | 37.719270613428705 | -122.431403880597 | (37.7192706134287, -122.431403880597) | |
| 18894 | 18894 | 87976 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 2160 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.778042363793396 | -122.446282917617 | (37.7780423637934, -122.446282917617) | ||
| 19281 | 19281 | 114961 | Private 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.45011626136801 | (37.7429206264442, -122.450116261368) | |||
| 61695 | 61695 | 88264 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1911 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51250 | 5997436.0 | 2108804.0 | 37.7702262944805 | -122.452226693379 | (37.7702262944805, -122.452226693379) | |
| 66766 | 66766 | 95870 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 471 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2012 12:00:00 AM | 0 | 3x3 | Permit Number 769435 | 6010616.0 | 2120218.0 | 37.80231263502721 | -122.407441748946 | (37.8023126350272, -122.407441748946) | |
| 77450 | 77450 | 95871 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 585 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767589 | 6010187.2 | 2119540.0 | 37.8004270041515 | -122.40887774988501 | (37.8004270041515, -122.408877749885) | |
| 77878 | 77878 | 95872 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 585 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767589 | 6010187.2 | 2119540.0 | 37.8004270041515 | -122.40887774988501 | (37.8004270041515, -122.408877749885) | |
| 78147 | 78147 | 83901 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 30 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50520 | 6000137.45040152 | 2093299.82569478 | 37.727809954285 | -122.441769533345 | (37.727809954285, -122.441769533345) | ||
| 79443 | 79443 | 45137 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1234 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53510 | 6000650.05093889 | 2109301.35578788 | 37.7717755038706 | -122.441145029184 | (37.7717755038706, -122.441145029184) | ||
| 79869 | 79869 | 96477 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3x3 | Permit number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 80715 | 80715 | 88184 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 489 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767583 | 6010914.9 | 2111745.1 | 37.7790648045054 | -122.40581022426599 | (37.7790648045054, -122.405810224266) | ||
| 81963 | 81963 | 88252 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1025 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131.0 | 2106547.0 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | |||
| 82739 | 82739 | 115779 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 864 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775643 | 6009345.7 | 2104137.1 | 37.7580871157921 | -122.41070131714301 | (37.7580871157921, -122.410701317143) | ||
| 83924 | 83924 | 114962 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 220 Evelyn Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.45011626136801 | (37.7429206264442, -122.450116261368) | |||
| 84640 | 84640 | 92222 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 85713 | 85713 | 32056 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 3516 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52612 | 6003328.9813191 | 2106558.55926414 | 37.7643966822396 | -122.431682578762 | (37.7643966822396, -122.431682578762) | |
| 85916 | 85916 | 88249 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 4758 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51235 | 5998426.0 | 2105687.0 | 37.7617244639768 | -122.448577782387 | (37.7617244639768, -122.448577782387) | |||
| 86053 | 86053 | 88254 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 107 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51239 | 5998213.0 | 2108192.0 | 37.768590378969 | -122.449494963351 | (37.768590378969, -122.449494963351) | |||
| 86409 | 86409 | 95530 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767321 | 5982880.0 | 2100129.0 | 37.745562588945205 | -122.501933006964 | (37.7455625889452, -122.501933006964) | |
| 87675 | 87675 | 88248 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 4418 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51234 | 6000065.0 | 2105781.0 | 37.7620761444221 | -122.44291590806401 | (37.7620761444221, -122.442915908064) | |||
| 88567 | 88567 | 92219 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 89913 | 89913 | 87928 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 2x TRAINOR ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50952 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||
| 90451 | 90451 | 63131 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 12 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52579 | 6007273.52756305 | 2099560.25449012 | 37.745403739192 | -122.417543422292 | (37.745403739192, -122.417543422292) | ||
| 90586 | 90586 | 84437 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 635 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53514 | 6007921.04355944 | 2104231.6010621996 | 37.7582666141285 | -122.415635095313 | (37.7582666141285, -122.415635095313) | ||
| 91640 | 91640 | 88352 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 700 VIENNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.717341135839604 | -122.43297431107901 | (37.7173411358396, -122.432974311079) | ||
| 93064 | 93064 | 95705 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 531 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767453 | 5992416.0 | 2103429.0 | 37.7551791102968 | -122.46919942196399 | (37.7551791102968, -122.469199421964) | |
| 93354 | 93354 | 117394 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 283 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776575 | 5993365.5 | 2113610.2 | 37.78318880461661 | -122.46665581889401 | (37.7831888046166, -122.466655818894) | ||
| 97321 | 97321 | 95568 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 353 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767360 | 6002854.0 | 2101511.0 | 37.7505103579798 | -122.432964764241 | (37.7505103579798, -122.432964764241) | |
| 101743 | 101743 | 115179 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 2018 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775293 | 5981721.2 | 2101325.9 | 37.7487808007055 | -122.50602861588301 | (37.7487808007055, -122.506028615883) | |||
| 102607 | 102607 | 49926 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 639@ 20th ST Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53572 | 6007922.28440673 | 2104209.24888267 | 37.7582053099171 | -122.41562922132499 | (37.7582053099171, -122.415629221325) | ||
| 104457 | 104457 | 62528 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 4259 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53580 | 6000833.16850213 | 2102853.59020152 | 37.7540819566375 | -122.440049196257 | (37.7540819566375, -122.440049196257) | ||
| 105623 | 105623 | 112775 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 298X De Montfort Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994620.34335 | 2091897.94945 | 37.7236448360577 | -122.460740597397 | (37.7236448360577, -122.460740597397) | ||
| 108296 | 108296 | 88324 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 182 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51313 | 6003195.0 | 2092351.0 | 37.7253784345628 | -122.431131833246 | (37.7253784345628, -122.431131833246) | |||
| 109564 | 109564 | 88181 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 437 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.779945319801605 | -122.40459520204399 | (37.7799453198016, -122.404595202044) | ||
| 110782 | 110782 | 64873 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.43540751638399 | (37.77059279087, -122.435407516384) | ||
| 111462 | 111462 | 62882 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 107 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/2015 12:00:00 AM | Permit Number 774278 | 6008878.23001524 | 2098033.75307574 | 37.7413024656019 | -122.41188674968001 | (37.7413024656019, -122.41188674968) | ||
| 112159 | 112159 | 99820 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2012 12:00:00 AM | 8 | 3x3 | Permit Number 768974 | 6007364.7 | 2097747.0 | 37.7404300763526 | -122.417099703218 | (37.7404300763526, -122.417099703218) |
| 120346 | 120346 | 95576 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 373 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767365 | 6003497.0 | 2099203.0 | 37.7442095786195 | -122.430576552899 | (37.7442095786195, -122.430576552899) | |
| 122762 | 122762 | 96479 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | |||
| 125623 | 125623 | 92220 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 126403 | 126403 | 96478 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3x3 | Permit Numbe 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 126628 | 126628 | 115321 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 783 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776299 | 5992231.1 | 2110127.0 | 37.7735593554473 | -122.470326606247 | (37.7735593554473, -122.470326606247) | ||
| 126791 | 126791 | 88318 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 607 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51309 | 6002519.4 | 2089575.2 | 37.717718399475295 | -122.43326906293899 | (37.7177183994753, -122.433269062939) | |||
| 127336 | 127336 | 23686 | DPW Maintained 3 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 332 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 776287 | 6006868.2665484 | 2098036.0093442 | 37.741195691996296 | -122.418836670708 | (37.7411956919963, -122.418836670708) | |
| 127473 | 127473 | 97045 | Property Tree 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 127538 | 127538 | 92221 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
| 128275 | 128275 | 52407 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 70 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | 3x3 | Permit Number 48526 | 6007233.79686164 | 2099091.04833404 | 37.7441131685781 | -122.41764755491998 | (37.7441131685781, -122.41764755492) | |
| 128984 | 128984 | 95540 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 4750 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767327 | 6000130.6 | 2101122.2 | 37.749287957362796 | -122.442354552038 | (37.7492879573628, -122.442354552038) | |
| 139145 | 139145 | 65459 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 298X De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994499.27735341 | 2091923.17456246 | 37.7237071317421 | -122.46116092612 | (37.7237071317421, -122.46116092612) | ||
| 139886 | 139886 | 88182 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 437 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.779945319801605 | -122.40459520204399 | (37.7799453198016, -122.404595202044) | ||
| 140279 | 140279 | 63695 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1783 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2014 12:00:00 AM | Permit Number 773244 | 5993095.47933652 | 2103351.7568476 | 37.7550062601161 | -122.46684398788099 | (37.7550062601161, -122.466843987881) | ||
| 145410 | 145410 | 115404 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 355 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776433 | 6006990.5 | 2096060.3 | 37.7357777137995 | -122.418273984634 | (37.7357777137995, -122.418273984634) | ||
| 145942 | 145942 | 115339 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 534 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776329 | 5994083.4 | 2111862.7 | 37.778432043803 | -122.464045297105 | (37.778432043803, -122.464045297105) |
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");