Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9735 | 9735 | 173670 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012236.0 | 2086860.0 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | ||||
| 78635 | 78635 | 60467 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883.0 | 2089135.0 | 37.716188348676894 | -122.45271971026699 | (37.7161883486769, -122.452719710267) | |||
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 87101 | 87101 | 96694 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 103442 | 103442 | 96695 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 106263 | 106263 | 96692 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 107261 | 107261 | 96693 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 110630 | 110630 | 92744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52968 | 6009200.0 | 2091312.0 | 37.722864017361395 | -122.41029969523998 | (37.7228640173614, -122.41029969524) | |||
| 111110 | 111110 | 116685 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x BIRD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005912.0 | 2105722.0 | 37.762245762674496 | -122.42268916815901 | (37.7622457626745, -122.422689168159) | ||||
| 126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) | ||||
| 129396 | 129396 | 93074 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 301 Executive Park Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 142373 | 142373 | 87850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.45163459365601 | (37.7437272652603, -122.451634593656) | |||
| 182278 | 182278 | 210908 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1351 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994231.8356099995 | 2106400.1375599997 | 37.7634418445856 | -122.463135347428 | (37.7634418445856, -122.463135347428) | |||
| 52544 | 52544 | 186008 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985026.892000001 | 2101640.0667 | 37.749837450044495 | -122.494620873169 | (37.7498374500445, -122.494620873169) | |||
| 60454 | 60454 | 234382 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.40741821967501 | (37.7561790447523, -122.407418219675) | |||
| 159203 | 159203 | 132067 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3038 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999089.102080001 | 2119262.1852 | 37.799036302553 | -122.44726145536 | (37.799036302553, -122.44726145536) | |||
| 14829 | 14829 | 95065 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | |||
| 54583 | 54583 | 132068 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3601 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999659.130480001 | 2120925.06177 | 37.803634670174496 | -122.445408603735 | (37.8036346701745, -122.445408603735) | |||
| 59423 | 59423 | 194280 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016126.44291 | 2100241.55687 | 37.747768618243605 | -122.38697869801202 | (37.7477686182436, -122.386978698012) | ||||
| 70062 | 70062 | 234377 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008587.9096 | 2108086.3181 | 37.768888242332004 | -122.413601406792 | (37.768888242332, -122.413601406792) | |||
| 100781 | 100781 | 109174 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.46264404963699 | (37.7270439629203, -122.462644049637) | |
| 137503 | 137503 | 234343 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 6005056.066269999 | 2103868.0427200003 | 37.7571069049763 | -122.42551757317601 | (37.7571069049763, -122.425517573176) | |||
| 158189 | 158189 | 234383 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3483 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005156.87556 | 2103096.1087599997 | 37.7549930502992 | -122.425114011399 | (37.7549930502992, -122.425114011399) | |||
| 179975 | 179975 | 234373 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 9ft | 6004999.25531 | 2105001.6441599997 | 37.76021629747461 | -122.42579473344401 | (37.7602162974746, -122.425794733444) | |||
| 24453 | 24453 | 185441 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985106.1344 | 2099492.3058 | 37.7439449206951 | -122.49418856991899 | (37.7439449206951, -122.494188569919) | |||
| 32150 | 32150 | 186007 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985000.2752 | 2101640.5507 | 37.749837221065 | -122.49471294958 | (37.749837221065, -122.49471294958) | |||
| 181517 | 181517 | 194279 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | ||||
| 23789 | 23789 | 234390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005245.617219999 | 2098983.50062 | 37.7437057887861 | -122.42451459797199 | (37.7437057887861, -122.424514597972) | |||
| 30590 | 30590 | 118002 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.780580098776795 | -122.49679463074699 | (37.7805800987768, -122.496794630747) | |||
| 42292 | 42292 | 234344 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 751 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005051.924 | 2103931.9938 | 37.757282265587 | -122.42553644996299 | (37.757282265587, -122.425536449963) | |||
| 47083 | 47083 | 186006 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985010.9219 | 2101633.2915 | 37.7498179124605 | -122.494675598244 | (37.7498179124605, -122.494675598244) | |||
| 47741 | 47741 | 194278 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 22nd St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6012817.610719999 | 2103799.38432 | 37.7573538722899 | -122.398670182286 | (37.7573538722899, -122.398670182286) | ||||
| 174857 | 174857 | 234391 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005241.74432 | 2098978.16752 | 37.743690926593295 | -122.424527610268 | (37.7436909265933, -122.424527610268) | |||
| 187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
| 20932 | 20932 | 5679 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.1721900003 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | ||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 59904 | 59904 | 187497 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.42395239669399 | (37.7093649785846, -122.423952396694) | ||||
| 180226 | 180226 | 186180 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984958.094 | 2103565.49 | 37.755120105782204 | -122.49500073187099 | (37.7551201057822, -122.495000731871) | |||
| 136550 | 136550 | 186179 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984928.6664 | 2103564.4514 | 37.755115531312704 | -122.49510242297701 | (37.7551155313127, -122.495102422977) | |||
| 163198 | 163198 | 234393 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561001 | (37.7442097715744, -122.42885628561) | |||
| 175193 | 175193 | 182680 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985854.1638 | 2103629.5919999997 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | |||
| 46040 | 46040 | 187495 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005184.36761 | 2086469.76682 | 37.709342367834395 | -122.423836763664 | (37.7093423678344, -122.423836763664) | ||||
| 61791 | 61791 | 182681 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985882.7747 | 2103629.0901 | 37.75534882242739 | -122.491807644065 | (37.7553488224274, -122.491807644065) | |||
| 134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
| 149136 | 149136 | 234366 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 9 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006381.599330001 | 2099941.08815 | 37.746399194477206 | -122.420654601644 | (37.7463991944772, -122.420654601644) | |||
| 157052 | 157052 | 210909 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 151 Garcia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994659.02084 | 2099296.69557 | 37.7439622025921 | -122.46114293900601 | (37.7439622025921, -122.461142939006) | |||
| 163407 | 163407 | 187499 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854947999 | (37.7093979531098, -122.42400854948) | ||||
| 185824 | 185824 | 234392 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1379 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6005257.78896 | 2100266.47383 | 37.7472292273428 | -122.424563754022 | (37.7472292273428, -122.424563754022) | |||
| 43396 | 43396 | 194272 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1022 Minna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007547.687530001 | 2109714.25342 | 37.7732997020571 | -122.41731485230801 | (37.7732997020571, -122.417314852308) | |||
| 48420 | 48420 | 187504 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | ||||
| 149367 | 149367 | 234380 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | |||
| 25123 | 25123 | 210904 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1539 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990882.40967 | 2107206.58351 | 37.7654626131273 | -122.47477868020201 | (37.7654626131273, -122.474778680202) | |||
| 48676 | 48676 | 210905 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1545 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990857.32948 | 2107205.82169 | 37.76545906800929 | -122.47486537036501 | (37.7654590680093, -122.474865370365) | |||
| 55136 | 55136 | 234387 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005043.99676 | 2102621.6014400003 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | |||
| 63620 | 63620 | 234384 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 899 Hampshire St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6010216.7904900005 | 2104076.88773 | 37.757970587791 | -122.407684453188 | (37.757970587791, -122.407684453188) | |||
| 131685 | 131685 | 210910 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387005 | -122.461135900907 | (37.743908769387, -122.461135900907) | |||
| 150774 | 150774 | 118706 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5982550.59501 | 2110970.7524 | 37.7753116033094 | -122.50387485804899 | (37.7753116033094, -122.503874858049) | |||
| 170283 | 170283 | 234385 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 384 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004737.93375 | 2109866.7423400003 | 37.773559918201606 | -122.427045042888 | (37.7735599182016, -122.427045042888) | |||
| 173622 | 173622 | 234381 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Eugenia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.41992640079599 | (37.74136892295, -122.419926400796) | ||||
| 23525 | 23525 | 187316 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.744263118481705 | -122.494303219592 | (37.7442631184817, -122.494303219592) | |||
| 159189 | 159189 | 234375 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.760238249920604 | -122.425809806971 | (37.7602382499206, -122.425809806971) | |||
| 130104 | 130104 | 210913 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5990641.4505900005 | 2103071.06132 | 37.754093605056795 | -122.47531013997101 | (37.7540936050568, -122.475310139971) | |||
| 29021 | 29021 | 234332 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6004849.34041 | 2105800.52772 | 37.7624013694379 | -122.42637009990601 | (37.7624013694379, -122.426370099906) | |||
| 39479 | 39479 | 234374 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6004996.87402 | 2105008.5457599997 | 37.760235113069896 | -122.425803460464 | (37.7602351130699, -122.425803460464) | |||
| 58910 | 58910 | 234395 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6008499.5527 | 2096078.48845 | 37.735912484272205 | -122.413057867339 | (37.7359124842722, -122.413057867339) | |||
| 151716 | 151716 | 194282 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | ||||
| 181931 | 181931 | 247638 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.40975139021499 | (37.7373232876386, -122.409751390215) | ||||
| 73625 | 73625 | 178085 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012726.322790001 | 2087488.8573099999 | 37.712563474091894 | -122.397841808652 | (37.7125634740919, -122.397841808652) | |||
| 163255 | 163255 | 132126 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | |||
| 9337 | 9337 | 113319 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005986.0 | 2109035.0 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | |||
| 32517 | 32517 | 234386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004984.24145 | 2103652.12046 | 37.7565099745835 | -122.42575060280899 | (37.7565099745835, -122.425750602809) | |||
| 44784 | 44784 | 132123 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.795397945911205 | -122.394743875326 | (37.7953979459112, -122.394743875326) | |||
| 48105 | 48105 | 118707 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.775310661099795 | -122.503888560039 | (37.7753106610998, -122.503888560039) | |||
| 54210 | 54210 | 132125 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014258.525909999 | 2117571.02815 | 37.79524788055 | -122.39465126585199 | (37.79524788055, -122.394651265852) | |||
| 54710 | 54710 | 132121 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945031999 | (37.7955313378499, -122.39482945032) | |||
| 160623 | 160623 | 234336 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6004864.2449199995 | 2105581.16954 | 37.7617999064621 | -122.42630293226101 | (37.7617999064621, -122.426302932261) | |||
| 163388 | 163388 | 233927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 389 Webster St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | |||
| 186247 | 186247 | 118708 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | |||
| 131575 | 131575 | 132122 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.39479193780599 | (37.7954646414426, -122.394791937806) | |||
| 170253 | 170253 | 178084 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.39781106804199 | (37.7126358803078, -122.397811068042) | |||
| 17598 | 17598 | 9369 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | |||
| 176298 | 176298 | 247642 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 632 Banks St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.41307547425501 | (37.7354426820387, -122.413075474255) | |||
| 55424 | 55424 | 210903 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.47315388853599 | (37.7517188372786, -122.473153888536) | |||
| 64753 | 64753 | 233931 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 451 Florida St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6009251.45318 | 2106264.05651 | 37.763921969247704 | -122.411177507234 | (37.7639219692477, -122.411177507234) | |||
| 157078 | 157078 | 120819 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587101999 | (37.7856385654779, -122.47984587102) | |||
| 42394 | 42394 | 201687 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | ||||
| 177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
| 181231 | 181231 | 234403 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006066.151819999 | 2108969.9418900004 | 37.771172536524794 | -122.42238679931101 | (37.7711725365248, -122.422386799311) | |||
| 184903 | 184903 | 201683 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010259.3376400005 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | ||||
| 25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
| 56280 | 56280 | 194309 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 The Embarcadero | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.79270265166021 | -122.39120994708 | (37.7927026516602, -122.39120994708) | |||
| 71126 | 71126 | 194298 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.794733763298105 | -122.394181185735 | (37.7947337632981, -122.394181185735) | |||
| 71688 | 71688 | 182873 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | |||
| 130546 | 130546 | 194303 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014498.26565 | 2117280.42263 | 37.794463271518296 | -122.39380137055599 | (37.7944632715183, -122.393801370556) | |||
| 156465 | 156465 | 187520 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6012373.80363 | 2088075.5295400003 | 37.7141547210285 | -122.399101386534 | (37.7141547210285, -122.399101386534) | |||
| 164993 | 164993 | 118208 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 578 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | |||
| 179308 | 179308 | 124647 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Arguello Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5995536.8608800005 | 2115835.19472 | 37.789423108579996 | -122.459305014392 | (37.78942310858, -122.459305014392) | ||||
| 28217 | 28217 | 210914 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 317 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5993048.097569999 | 2099658.5212 | 37.744862847537206 | -122.46673939310301 | (37.7448628475372, -122.466739393103) | |||
| 28249 | 28249 | 194306 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014568.03404 | 2117229.07965 | 37.7943261725661 | -122.393556366426 | (37.7943261725661, -122.393556366426) | |||
| 35095 | 35095 | 132128 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014303.114130001 | 2117497.5911 | 37.7950487184753 | -122.39449183764299 | (37.7950487184753, -122.394491837643) |
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");