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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
| 31851 | 31851 | 188228 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015950.839319999 | 2099751.9631 | 37.746414570195704 | -122.387551780196 | (37.7464145701957, -122.387551780196) | ||||
| 36747 | 36747 | 188229 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 49 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6015937.59243 | 2099752.45795 | 37.746415195218205 | -122.387597621357 | (37.7464151952182, -122.387597621357) | ||||
| 1621 | 1621 | 88501 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1599 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51438 | 6015120.9647 | 2094333.0532 | 37.7314893544439 | -122.390042929541 | (37.7314893544439, -122.390042929541) | |
| 70713 | 70713 | 94867 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 585 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53938 | 6013855.010369999 | 2104400.1239 | 37.7590611164982 | -122.39512449630199 | (37.7590611164982, -122.395124496302) | |
| 3371 | 3371 | 188225 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 2 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013591.2999599995 | 2105254.0413599997 | 37.7613911187249 | -122.396096381957 | (37.7613911187249, -122.396096381957) | |
| 3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
| 3379 | 3379 | 188227 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 4 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 5 | Width 3ft | Permit Number 37286 | 6013561.10942 | 2105252.84027 | 37.7613861409778 | -122.39620071499901 | (37.7613861409778, -122.396200714999) | |
| 19510 | 19510 | 122456 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 80760 | 80760 | 122457 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 103420 | 103420 | 122458 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 79682 | 79682 | 52242 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 80403 | 80403 | 52245 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 105536 | 105536 | 52243 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 140544 | 140544 | 52244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 117650 | 117650 | 86774 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 573 Connecticut St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49746 | 6013291.0 | 2104402.0 | 37.7590348868282 | -122.39707525671601 | (37.7590348868282, -122.397075256716) | |||
| 30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
| 148224 | 148224 | 188231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012859.425559999 | 2113671.68237 | 37.7844633085723 | -122.399218553795 | (37.7844633085723, -122.399218553795) | |||
| 80899 | 80899 | 51734 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 126094 | 126094 | 51733 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 22952 | 22952 | 115614 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 83020 | 83020 | 115619 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 114945 | 114945 | 115618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 42566 | 42566 | 188224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 680 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6012059.12679 | 2105275.043 | 37.7613634169017 | -122.401397037349 | (37.7613634169017, -122.401397037349) | ||||
| 53493 | 53493 | 33102 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 375 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37343 | 6011697.96502 | 2119046.16805 | 37.799155568835 | -122.40361510367701 | (37.799155568835, -122.403615103677) | |
| 61422 | 61422 | 175560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 105 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6011176.06814 | 2093472.4733799999 | 37.728906802388394 | -122.403620739722 | (37.7289068023884, -122.403620739722) | ||||
| 63509 | 63509 | 53408 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 732 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2002 12:00:00 AM | 2 | Permit Number 6307 | 6011253.43466 | 2104717.71315 | 37.7597881275257 | -122.404144378963 | (37.7597881275257, -122.404144378963) | |
| 160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
| 56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
| 40240 | 40240 | 39382 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 15 | Permit Number 40924 | 6011028.8433300005 | 2112194.85786 | 37.7803061060932 | -122.40544772953699 | (37.7803061060932, -122.405447729537) | ||
| 147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
| 67242 | 67242 | 246811 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6010262.216659999 | 2098999.82172 | 37.7440326285028 | -122.40716947078998 | (37.7440326285028, -122.40716947079) | |||
| 172101 | 172101 | 246810 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6010258.54095 | 2098989.94927 | 37.744005315193895 | -122.407181484852 | (37.7440053151939, -122.407181484852) | |||
| 33880 | 33880 | 221109 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 119 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010247.14882 | 2100206.80415 | 37.7473458954989 | -122.407306641714 | (37.7473458954989, -122.407306641714) | |||
| 34588 | 34588 | 175559 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 116 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009960.74638 | 2095001.17625 | 37.7330363336401 | -122.407929970784 | (37.7330363336401, -122.407929970784) | |||
| 132275 | 132275 | 125715 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 165 Francisco St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6010453.93223 | 2121307.9619 | 37.8052963286168 | -122.408079498365 | (37.8052963286168, -122.408079498365) | |||
| 156056 | 156056 | 32640 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2663 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37085 | 6010083.06076 | 2103949.57384 | 37.7576135254646 | -122.408137970501 | (37.7576135254646, -122.408137970501) | |
| 168453 | 168453 | 248009 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 526 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009935.92156 | 2098263.7505 | 37.7419932709619 | -122.408245826194 | (37.7419932709619, -122.408245826194) | |||
| 166849 | 166849 | 221108 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1180 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010002.18992 | 2102348.16897 | 37.7532118971222 | -122.40830470751301 | (37.7532118971222, -122.408304707513) | |||
| 45091 | 45091 | 221126 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 229 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6009794.39876 | 2099562.54978 | 37.745551564551704 | -122.40882678015801 | (37.7455515645517, -122.408826780158) | |||
| 46153 | 46153 | 221125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 229 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009787.17662 | 2099559.77195 | 37.745543532705604 | -122.408851557364 | (37.7455435327056, -122.408851557364) | |||
| 136625 | 136625 | 175549 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 62 Tomaso Ct | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 8ft | 6009261.65543 | 2086500.8991200002 | 37.709657184513 | -122.40974713551901 | (37.709657184513, -122.409747135519) | |||
| 43264 | 43264 | 221106 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009472.02471 | 2105439.84712 | 37.7616712458547 | -122.410356413623 | (37.7616712458547, -122.410356413623) | |||
| 23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
| 68111 | 68111 | 221104 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009432.49535 | 2105438.1168 | 37.761664278799 | -122.41049300806101 | (37.761664278799, -122.410493008061) | |||
| 17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) | |
| 61465 | 61465 | 221103 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009402.10993 | 2105437.04552 | 37.7616596338129 | -122.410598023702 | (37.7616596338129, -122.410598023702) | |||
| 173685 | 173685 | 221102 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009385.9447800005 | 2105435.68423 | 37.7616549897172 | -122.41065383649901 | (37.7616549897172, -122.410653836499) | |||
| 174745 | 174745 | 221101 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009367.670080001 | 2105435.00012 | 37.7616520866991 | -122.410716993221 | (37.7616520866991, -122.410716993221) | |||
| 53922 | 53922 | 221100 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6009350.253169999 | 2105434.72135 | 37.7616503447144 | -122.41077721180599 | (37.7616503447144, -122.410777211806) | |||
| 146788 | 146788 | 221099 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009329.84306 | 2105433.4467700003 | 37.7616457005982 | -122.410847712362 | (37.7616457005982, -122.410847712362) | |||
| 138118 | 138118 | 221098 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | |||
| 89002 | 89002 | 119272 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1101 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 3x3 | 6009465.43944441 | 2117056.87897214 | 37.793568508665295 | -122.41119983681601 | (37.7935685086653, -122.411199836816) | ||
| 110952 | 110952 | 69510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 456 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33637 | 6008875.40021357 | 2096212.24839146 | 37.7363008518361 | -122.411767856956 | (37.7363008518361, -122.411767856956) | ||
| 145150 | 145150 | 69512 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 472 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33639 | 6008869.38717848 | 2096146.49207246 | 37.736119961903896 | -122.411784001618 | (37.7361199619039, -122.411784001618) | ||
| 96501 | 96501 | 69421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 400 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 8 | Permit Number 33526 | 6008905.76984219 | 2106354.06627794 | 37.7641497228891 | -122.41237948925101 | (37.7641497228891, -122.412379489251) | ||
| 53433 | 53433 | 125701 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009113.9445 | 2117050.28629 | 37.7935306880345 | -122.412415576041 | (37.7935306880345, -122.412415576041) | |||
| 45487 | 45487 | 221132 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008864.30785 | 2106343.82537 | 37.764119276915295 | -122.41252217085699 | (37.7641192769153, -122.412522170857) | |||
| 130310 | 130310 | 125702 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009077.34196 | 2117044.73858 | 37.7935134012698 | -122.41254183184799 | (37.7935134012698, -122.412541831848) | |||
| 124418 | 124418 | 66421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 311 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29561 | 6008662.43573018 | 2097263.932308 | 37.7391765974053 | -122.41257848719299 | (37.7391765974053, -122.412578487193) | ||
| 80429 | 80429 | 66424 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 331 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29564 | 6008656.02628353 | 2097191.94254108 | 37.7389785695141 | -122.41259556059099 | (37.7389785695141, -122.412595560591) | ||
| 100357 | 100357 | 66425 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 337 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 8 | 3x3 | Permit Number 29566 | 6008654.10344933 | 2097170.34560865 | 37.7389191611384 | -122.41260068259399 | (37.7389191611384, -122.412600682594) |
| 84049 | 84049 | 107009 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 90063 | 90063 | 107007 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 91717 | 91717 | 107012 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 98482 | 98482 | 107003 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 113605 | 113605 | 107006 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 116833 | 116833 | 107010 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 118818 | 118818 | 107004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 135339 | 135339 | 221133 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008831.47155 | 2106343.31873 | 37.7641160429416 | -122.412635706672 | (37.7641160429416, -122.412635706672) | |||
| 61970 | 61970 | 221157 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 337 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008639.65317 | 2097144.46538 | 37.738847288673 | -122.412648816096 | (37.738847288673, -122.412648816096) | |||
| 164287 | 164287 | 221134 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008816.36555 | 2106342.1549299997 | 37.7641119995907 | -122.412687871844 | (37.7641119995907, -122.412687871844) | |||
| 141121 | 141121 | 111212 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3100x 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008781.0 | 2105093.0 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | |||
| 28073 | 28073 | 221120 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 326 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008611.309880001 | 2097158.27133 | 37.7388836059924 | -122.41274779008499 | (37.7388836059924, -122.412747790085) | |||
| 118647 | 118647 | 66423 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 326 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 4x9 | Permit Number 29563 | 6008605.51305314 | 2097210.95195553 | 37.7390279301146 | -122.412771556258 | (37.7390279301146, -122.412771556258) | |
| 47440 | 47440 | 66426 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 340 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29567 | 6008601.026441 | 2097160.55912441 | 37.7388893105844 | -122.41278350726101 | (37.7388893105844, -122.412783507261) | ||
| 172627 | 172627 | 125709 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009014.12735 | 2118712.39114 | 37.798088817308 | -122.412878520028 | (37.798088817308, -122.412878520028) | ||||
| 31337 | 31337 | 125710 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009006.53902 | 2118723.89067 | 37.798119966232704 | -122.412905591427 | (37.7981199662327, -122.412905591427) | ||||
| 162353 | 162353 | 125714 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 941 Vallejo St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6008973.41059 | 2118698.11415 | 37.7980473306652 | -122.413018402384 | (37.7980473306652, -122.413018402384) | ||||
| 75084 | 75084 | 125704 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008924.73472 | 2116833.00784 | 37.792923474790896 | -122.413054888768 | (37.7929234747909, -122.413054888768) | |||
| 24322 | 24322 | 125703 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008909.16091 | 2116830.53076 | 37.7929157990679 | -122.4131085999 | (37.7929157990679, -122.4131085999) | |||
| 147647 | 147647 | 125711 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 954 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008937.17158 | 2118714.51142 | 37.798090319168 | -122.413144960375 | (37.798090319168, -122.413144960375) | ||||
| 50526 | 50526 | 72443 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 11 | 6008813.774540001 | 2115937.32557 | 37.790457920444005 | -122.413375446746 | (37.790457920444, -122.413375446746) | ||
| 158306 | 158306 | 125712 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008850.76057 | 2118710.67422 | 37.798074931775396 | -122.413443697187 | (37.7980749317754, -122.413443697187) | ||||
| 133304 | 133304 | 125713 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008845.05182 | 2118706.6905799997 | 37.7980636731514 | -122.41346316930799 | (37.7980636731514, -122.413463169308) | ||||
| 181814 | 181814 | 74235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6008785.22187 | 2115933.15302 | 37.79044486048821 | -122.413473942277 | (37.7904448604882, -122.413473942277) | ||
| 50257 | 50257 | 125705 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008691.84445 | 2116822.80562 | 37.792882385661 | -122.41385998166001 | (37.792882385661, -122.41385998166) | |||
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
| 123269 | 123269 | 40459 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 256 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41544 | 6008229.9197421 | 2097395.17552334 | 37.739512678985896 | -122.414083219638 | (37.7395126789859, -122.414083219638) | ||
| 126856 | 126856 | 98969 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 34327 | 34327 | 221111 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 204 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008081.346469999 | 2097637.2486099997 | 37.7401690124009 | -122.414614048819 | (37.7401690124009, -122.414614048819) | |||
| 65610 | 65610 | 221154 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 445 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008062.65586 | 2096770.15245 | 37.737787106693396 | -122.41461732863998 | (37.7377871066934, -122.41461732864) | |||
| 30473 | 30473 | 221155 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 449 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008058.6001 | 2096752.2718 | 37.7377377824817 | -122.41463008643 | (37.7377377824817, -122.41463008643) | |||
| 147727 | 147727 | 221156 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 461 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008056.95305 | 2096731.8919400002 | 37.737681731314105 | -122.41463433930299 | (37.7376817313141, -122.414634339303) | |||
| 152775 | 152775 | 221112 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008049.49369 | 2096950.1796799998 | 37.738280682507 | -122.41467557324499 | (37.738280682507, -122.414675573245) | |||
| 168109 | 168109 | 221113 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 402 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008047.83195 | 2096931.9804900002 | 37.738230618159 | -122.414680031183 | (37.738230618159, -122.414680031183) | |||
| 62915 | 62915 | 221114 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 424 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008042.92027 | 2096868.3927 | 37.7380557440706 | -122.414692514653 | (37.7380557440706, -122.414692514653) | |||
| 117024 | 117024 | 221115 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 442 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008034.6897599995 | 2096781.24622 | 37.7378159965066 | -122.414714806163 | (37.7378159965066, -122.414714806163) |
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");