Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 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) | ||
| 43355 | 43355 | 41527 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.261969999 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | ||
| 46634 | 46634 | 84745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 18 | Permit No. 49304 | 6015113.5864699995 | 2111549.96085 | 37.7787629081139 | -122.39127150119499 | (37.7787629081139, -122.391271501195) | ||
| 47057 | 47057 | 84747 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | ||
| 49819 | 49819 | 49090 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Permit Number 46240 | 6005000.86531 | 2092599.96167 | 37.7261641966181 | -122.424906823795 | (37.7261641966181, -122.424906823795) | |||
| 51490 | 51490 | 67305 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2317 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1992 12:00:00 AM | 18 | Permit Number 30786 | 6000748.48964 | 2119604.08725 | 37.800069752172604 | -122.44154398128299 | (37.8000697521726, -122.441543981283) | ||
| 53512 | 53512 | 33314 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.803038340517396 | -122.425775331487 | (37.8030383405174, -122.425775331487) | |
| 54279 | 54279 | 33558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | |
| 59148 | 59148 | 49326 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.4980200003 | 37.7754851058895 | -122.39756387047501 | (37.7754851058895, -122.397563870475) | ||
| 62683 | 62683 | 33555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.4696400003 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | ||
| 62777 | 62777 | 49327 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 17 | Permit Number 46321 | 6013204.31889 | 2110464.18207 | 37.77567546267289 | -122.397800268992 | (37.7756754626729, -122.397800268992) | ||
| 63685 | 63685 | 84744 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | ||
| 65233 | 65233 | 33556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996225.02102 | 2110420.81163 | 37.774596191384 | -122.456532373263 | (37.774596191384, -122.456532373263) | ||
| 69461 | 69461 | 49325 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | ||
| 71965 | 71965 | 50023 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1704 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46757 | 6005976.3873 | 2092403.4615900002 | 37.7256797039307 | -122.421520544445 | (37.7256797039307, -122.421520544445) | |
| 75228 | 75228 | 84746 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | |||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 120058 | 120058 | 33554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996192.1418699995 | 2110415.99351 | 37.7745810743751 | -122.456645759522 | (37.7745810743751, -122.456645759522) | ||
| 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) | ||||
| 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) | ||||
| 133518 | 133518 | 68285 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | |
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 154180 | 154180 | 84748 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | ||
| 155287 | 155287 | 46765 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 14 | Permit Number 44862 | 6003326.43729 | 2094178.5740200002 | 37.7304039901516 | -122.430807830618 | (37.7304039901516, -122.430807830618) | |
| 156933 | 156933 | 62745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1986 12:00:00 AM | 13 | Permit Number 23093 | 6009715.48574 | 2111589.25493 | 37.7785697418509 | -122.409948497336 | (37.7785697418509, -122.409948497336) | ||
| 158682 | 158682 | 65148 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 17 | Permit Number 27125 | 5984217.18812 | 2112512.23092 | 37.7796419140825 | -122.498223688652 | (37.7796419140825, -122.498223688652) | ||
| 160511 | 160511 | 33315 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 19 | Permit Number 37460 | 6005351.66292 | 2120593.2650099997 | 37.8030469569032 | -122.42568566546001 | (37.8030469569032, -122.42568566546) | |
| 165043 | 165043 | 84749 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | ||
| 170194 | 170194 | 67454 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 18 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 24 | Permit Number 30963 | 5996314.7251699995 | 2112137.62024 | 37.7793152462196 | -122.456346235157 | (37.7793152462196, -122.456346235157) | ||
| 181166 | 181166 | 33557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996239.10441 | 2110423.85984 | 37.774605369516394 | -122.456483876805 | (37.7746053695164, -122.456483876805) | ||
| 181886 | 181886 | 49328 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 19 | Permit Number 46321 | 6013181.12431 | 2110489.32106 | 37.775743196927294 | -122.397882269155 | (37.7757431969273, -122.397882269155) | ||
| 184973 | 184973 | 62210 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.821959999 | 2093620.4443599998 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) | |
| 186449 | 186449 | 52601 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1360WASHINGTON Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | 12 | Permit Number 48694 | 6008501.73087 | 2117208.37484 | 37.7939303854283 | -122.414545082491 | (37.7939303854283, -122.414545082491) | ||
| 189103 | 189103 | 96941 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | ||||
| 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) | ||
| 11503 | 11503 | 27099 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 681 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6005896.77811 | 2093584.4181099997 | 37.7289178631699 | -122.421879597869 | (37.7289178631699, -122.421879597869) | |||
| 21082 | 21082 | 28787 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2518 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006949.0139999995 | 2103676.1713 | 37.7566868442816 | -122.418957411892 | (37.7566868442816, -122.418957411892) | |||
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 10445 | 10445 | 24508 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5088 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 3 | 3X3 | 6000357.2418 | 2089366.5868 | 37.717022698354604 | -122.440727697577 | (37.7170226983546, -122.440727697577) | ||
| 10773 | 10773 | 28540 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4754 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001487.6438 | 2091153.5571 | 37.7219936282262 | -122.43694830738701 | (37.7219936282262, -122.436948307387) | ||
| 11110 | 11110 | 28537 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | ||
| 11123 | 11123 | 28555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | ||
| 11137 | 11137 | 28558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4667 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001923.346 | 2091737.9699 | 37.723623049111296 | -122.435483982262 | (37.7236230491113, -122.435483982262) | ||
| 11198 | 11198 | 28556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | ||
| 11318 | 11318 | 27101 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X3 | 6005857.71837 | 2093582.84449 | 37.7289113394736 | -122.42201451865101 | (37.7289113394736, -122.422014518651) | |||
| 11469 | 11469 | 28551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4885 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001150.501 | 2090506.6381 | 37.720198166433896 | -122.438067406183 | (37.7201981664339, -122.438067406183) | ||
| 11757 | 11757 | 15734 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4476 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 3 | 3X3 | 6002423.6538 | 2092643.0339 | 37.726136553633395 | -122.43381916618 | (37.7261365536334, -122.43381916618) | ||
| 11995 | 11995 | 15738 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.725554668943204 | -122.434262847922 | (37.7255546689432, -122.434262847922) | ||
| 12072 | 12072 | 28800 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4505 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002480.3523 | 2092620.1218 | 37.7260768594239 | -122.433621526187 | (37.7260768594239, -122.433621526187) | |||
| 12148 | 12148 | 15777 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.43777008073401 | (37.7209091632567, -122.437770080734) | ||
| 12396 | 12396 | 15742 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.725448291506204 | -122.43434171007601 | (37.7254482915062, -122.434341710076) | ||
| 12407 | 12407 | 28550 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | ||
| 13194 | 13194 | 28543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5050 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 14 | 3X3 | 6000463.3087 | 2089534.8309 | 37.717490698541106 | -122.44037313550601 | (37.7174906985411, -122.440373135506) | ||
| 18122 | 18122 | 15443 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006851.2872 | 2105349.6458 | 37.7612763139256 | -122.419414104618 | (37.7612763139256, -122.419414104618) | |||
| 18126 | 18126 | 15514 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2756 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007024.332 | 2102304.0728 | 37.752923617389705 | -122.418599638138 | (37.7529236173897, -122.418599638138) | |||
| 18216 | 18216 | 24604 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 6 | 3X3 | 6006726.6671 | 2107610.9661 | 37.7674783489788 | -122.420005592363 | (37.7674783489788, -122.420005592363) | ||
| 19316 | 19316 | 15543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | ||
| 20857 | 20857 | 15519 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2768 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007027.5439 | 2102261.5951 | 37.7528071641561 | -122.41858551881901 | (37.7528071641561, -122.418585518819) | |||
| 21091 | 21091 | 15502 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2712 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102444.8849 | 37.7533099602486 | -122.41862774204901 | (37.7533099602486, -122.418627742049) | |||
| 21745 | 21745 | 15549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007044.5756 | 2101802.0469 | 37.7515463084579 | -122.41849403667 | (37.7515463084579, -122.41849403667) | |||
| 22135 | 22135 | 15500 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2710 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102497.935 | 37.7534556236904 | -122.41863150374701 | (37.7534556236904, -122.418631503747) |
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");