Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1932 | 1932 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1936 | 1936 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1938 | 1938 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2846 | 2846 | 253262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
| 2856 | 2856 | 253264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 18617 | 18617 | 48631 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
| 34301 | 34301 | 96815 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
| 42753 | 42753 | 43930 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 79565 | 79565 | 84717 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 79611 | 79611 | 51058 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2516REVISED Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2004 12:00:00 AM | Permit Number 47527 | 6006947.90092687 | 2103694.34844389 | 37.756736691852495 | -122.41896255050501 | (37.7567366918525, -122.418962550505) | |||
| 80663 | 80663 | 96817 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
| 81025 | 81025 | 43933 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 81310 | 81310 | 84715 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 82678 | 82678 | 43932 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 83280 | 83280 | 84707 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 84014 | 84014 | 99843 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 84544 | 84544 | 59584 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 491-497 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1998 12:00:00 AM | 3x3 | Permit Number 18977 | 6003187.0 | 2102698.0 | 37.7537884621117 | -122.43189797261499 | (37.7537884621117, -122.431897972615) | |
| 85176 | 85176 | 104920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 85571 | 85571 | 87751 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 19 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | 3x3 | Permit Number 768033 | 6002648.0 | 2105790.0 | 37.7622477813974 | -122.433982960078 | (37.7622477813974, -122.433982960078) | ||
| 87642 | 87642 | 104512 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 491-497 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003187.0 | 2102698.0 | 37.7537884621117 | -122.43189797261499 | (37.7537884621117, -122.431897972615) | |||
| 87686 | 87686 | 82269 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
| 87968 | 87968 | 116597 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 90707 | 90707 | 84712 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 91617 | 91617 | 121443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 92697 | 92697 | 96814 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
| 96091 | 96091 | 97445 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900@Gough Pacific Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 96328 | 96328 | 48632 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 96749 | 96749 | 93115 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 397 San Jose Ave | 1 | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | ||
| 97601 | 97601 | 98960 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 401 Grove St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 99196 | 99196 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 461X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005199.36333 | 2111122.83043 | 37.777034912059605 | -122.425538300101 | (37.7770349120596, -122.425538300101) | |||||
| 99232 | 99232 | 84714 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 100661 | 100661 | 45177 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44025 | 6010386.35714914 | 2098720.11226765 | 37.743271553676294 | -122.406720510672 | (37.7432715536763, -122.406720510672) | ||
| 100997 | 100997 | 84709 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 101258 | 101258 | 104921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 101862 | 101862 | 82273 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 102510 | 102510 | 84710 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 103480 | 103480 | 44363 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 641 HAMPSHIRE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43733 | 6010162.0 | 2105312.9 | 37.761361331815 | -122.407961104543 | (37.761361331815, -122.407961104543) | |||
| 104061 | 104061 | 121442 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 104086 | 104086 | 104511 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 491-497 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003187.0 | 2102698.0 | 37.7537884621117 | -122.43189797261499 | (37.7537884621117, -122.431897972615) | |||
| 104098 | 104098 | 112500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 301 SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003576.0 | 2106249.0 | 37.763560705802895 | -122.430806117119 | (37.7635607058029, -122.430806117119) | ||||
| 104153 | 104153 | 121416 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | ||||
| 104231 | 104231 | 44365 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 641 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43734 | 6010137.34166098 | 2105310.67869349 | 37.7613538520301 | -122.408046231145 | (37.7613538520301, -122.408046231145) | |||
| 105688 | 105688 | 47457 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 106675 | 106675 | 84713 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 107366 | 107366 | 101903 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 107982 | 107982 | 47458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 108060 | 108060 | 47312 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1346 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 45243 | 6010314.34342457 | 2101370.8021383 | 37.750545738734104 | -122.40715632352101 | (37.7505457387341, -122.407156323521) | ||
| 108424 | 108424 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 230 Lakeview Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | |||||
| 109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
| 110201 | 110201 | 32558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 110388 | 110388 | 112172 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010071.0 | 2112545.0 | 37.7812139111906 | -122.40878607767901 | (37.7812139111906, -122.408786077679) | ||||
| 110616 | 110616 | 101905 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 110672 | 110672 | 121440 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 110865 | 110865 | 43931 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 111624 | 111624 | 104922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | missing? | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 112953 | 112953 | 118305 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 113128 | 113128 | 98959 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 401 Grove St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 115552 | 115552 | 121441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 116360 | 116360 | 96816 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
| 118894 | 118894 | 84711 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 119208 | 119208 | 94635 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3973 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53782 | 6003202.2 | 2104721.0 | 37.759343999852796 | -122.431989854822 | (37.7593439998528, -122.431989854822) | ||
| 119296 | 119296 | 84708 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 119677 | 119677 | 85177 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 479 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2012 12:00:00 AM | 4x19 | Permit Number 768801 | 6006816.0 | 2100993.0 | 37.7493119792947 | -122.419227096542 | (37.7493119792947, -122.419227096542) | ||
| 119689 | 119689 | 46396 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2363 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | ||
| 119817 | 119817 | 105068 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 117 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006924.9 | 2098775.6 | 37.743229631270104 | -122.41869328836 | (37.7432296312701, -122.41869328836) | ||||
| 123620 | 123620 | 84716 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 124295 | 124295 | 118306 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 124601 | 124601 | 116596 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 124863 | 124863 | 99842 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 126644 | 126644 | 121439 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 127089 | 127089 | 82270 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 127368 | 127368 | 108203 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1875 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006816.6 | 2107468.6 | 37.767092511704995 | -122.41968442346001 | (37.767092511705, -122.41968442346) | ||||
| 128872 | 128872 | 104513 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 491-497 Alvarado St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003187.0 | 2102698.0 | 37.7537884621117 | -122.43189797261499 | (37.7537884621117, -122.431897972615) | |||
| 138405 | 138405 | 32559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 139139 | 139139 | 49324 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | Permit Number 46321 | 6013145.06683573 | 2110537.17362663 | 37.775872581057 | -122.39801035954599 | (37.775872581057, -122.398010359546) | |||
| 139224 | 139224 | 96035 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767674 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | |
| 139382 | 139382 | 30858 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 140194 | 140194 | 48630 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 142378 | 142378 | 99841 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 142615 | 142615 | 82272 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 142737 | 142737 | 99840 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 142918 | 142918 | 116595 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 144227 | 144227 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 455X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 144405 | 144405 | 82271 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 144760 | 144760 | 104926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 145462 | 145462 | 32560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 146191 | 146191 | 101904 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
| 1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
| 1634 | 1634 | 199504 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | |
| 1642 | 1642 | 199503 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.983080001 | 2111924.50305 | 37.7795342467397 | -122.40725478770099 | (37.7795342467397, -122.407254787701) | |
| 2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) |
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");