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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 72211 | 72211 | 28774 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4626 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001950.98602 | 2092007.07057 | 37.724363508667295 | -122.43540767631 | (37.7243635086673, -122.43540767631) | |||
| 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) | ||
| 77716 | 77716 | 93966 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | |
| 79563 | 79563 | 109279 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
| 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) | |||
| 80955 | 80955 | 28559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4647 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6002004.69492 | 2091867.26763 | 37.7239826914316 | -122.435212017462 | (37.7239826914316, -122.435212017462) | ||
| 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) | ||||
| 81528 | 81528 | 25268 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1770 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5994565.40331 | 2092391.5082200002 | 37.724996868228104 | -122.460966269529 | (37.7249968682281, -122.460966269529) | ||
| 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) | ||
| 82761 | 82761 | 28581 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 83056 | 83056 | 108808 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 542 Moscow St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.42937193832199 | (37.7190626969286, -122.429371938322) | |
| 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) | ||||
| 83511 | 83511 | 15402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2035 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006860.91141 | 2106484.2261799998 | 37.764392148614505 | -122.41946131318501 | (37.7643921486145, -122.419461313185) | |||
| 83918 | 83918 | 28625 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1299 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | ||
| 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) | ||||
| 84329 | 84329 | 28440 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992376.3743900005 | 2094089.82777 | 37.7295338285402 | -122.46865695076099 | (37.7295338285402, -122.468656950761) | ||
| 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) | |
| 85226 | 85226 | 28451 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1931 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993990.72994 | 2092568.10284 | 37.725448669232605 | -122.462965643186 | (37.7254486692326, -122.462965643186) | ||
| 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) | ||
| 87014 | 87014 | 28580 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 87363 | 87363 | 28422 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2012 12:00:00 AM | 12 | 3x3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
| 87403 | 87403 | 28607 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5995745.87048 | 2091965.2251799998 | 37.723894253245895 | -122.456854733097 | (37.7238942532459, -122.456854733097) | ||
| 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) | ||
| 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) | ||||
| 88145 | 88145 | 28395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994199.42088 | 2092532.99697 | 37.725364295675995 | -122.462241677747 | (37.725364295676, -122.462241677747) | ||
| 89525 | 89525 | 28458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5992795.29206 | 2093448.6567 | 37.7277975223389 | -122.467162123346 | (37.7277975223389, -122.467162123346) | ||
| 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) | ||||
| 91124 | 91124 | 113402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | ||
| 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) | |||||
| 96201 | 96201 | 15401 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2035 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006859.26812 | 2106465.89528 | 37.7643417237025 | -122.41946569630699 | (37.7643417237025, -122.419465696307) | |||
| 96271 | 96271 | 28480 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
| 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) | ||
| 96358 | 96358 | 28436 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992168.55554 | 2094228.20045 | 37.729901757986 | -122.46938546297702 | (37.729901757986, -122.469385462977) | ||
| 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) | ||
| 97023 | 97023 | 93963 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
| 97375 | 97375 | 25262 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1712 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994776.63019 | 2092332.44962 | 37.724846859825895 | -122.46023180975901 | (37.7248468598259, -122.460231809759) | ||
| 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) | |||||
| 98043 | 98043 | 637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3205 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007653.0 | 2102067.0 | 37.7523080428222 | -122.41640878881701 | (37.7523080428222, -122.416408788817) | ||
| 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) | ||||
| 101404 | 101404 | 28450 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1933 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 18 | 3X3 | 5993979.747380001 | 2092573.4533099998 | 37.7254627277081 | -122.463003996644 | (37.7254627277081, -122.463003996644) | ||
| 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) | ||
| 102155 | 102155 | 28482 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2073 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993305.06135 | 2092906.64732 | 37.7263387103664 | -122.46536049980499 | (37.7263387103664, -122.465360499805) | ||
| 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) | ||||
| 103267 | 103267 | 28470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992499.15443 | 2093893.9061599998 | 37.729002968377294 | -122.46821824463301 | (37.7290029683773, -122.468218244633) | ||
| 103297 | 103297 | 28477 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992865.63839 | 2093261.95996 | 37.7272889595155 | -122.46690537001601 | (37.7272889595155, -122.466905370016) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 105853 | 105853 | 28478 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992874.48639 | 2093252.14618 | 37.7272625239656 | -122.46687406965 | (37.7272625239656, -122.46687406965) | ||
| 106224 | 106224 | 28592 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1338 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 4X4 | 5995676.5171 | 2092067.1693 | 37.7241701848162 | -122.457101845697 | (37.7241701848162, -122.457101845697) | ||
| 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) | ||
| 108531 | 108531 | 28471 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992502.64875 | 2093884.6455400002 | 37.728977742823794 | -122.46820549121 | (37.7289777428238, -122.46820549121) | ||
| 108922 | 108922 | 28439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992364.67777 | 2094097.6153099998 | 37.729554535492 | -122.46869795321999 | (37.729554535492, -122.46869795322) | ||
| 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) | |||
| 110465 | 110465 | 49637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
| 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) | ||
| 111111 | 111111 | 25275 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994210.04485 | 2092528.0363900003 | 37.725351286848394 | -122.462204592351 | (37.7253512868484, -122.462204592351) | ||
| 112457 | 112457 | 15556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2853 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007106.55999 | 2101746.86 | 37.7513982670828 | -122.41827577404 | (37.7513982670828, -122.41827577404) | |||
| 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) | |||||
| 114071 | 114071 | 93964 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
| 114278 | 114278 | 93962 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
| 116359 | 116359 | 28593 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1344 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 3x3 | 5995646.9889 | 2092076.7179900003 | 37.7241947074129 | -122.457204610061 | (37.7241947074129, -122.457204610061) | ||
| 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) | |||
| 117070 | 117070 | 15381 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1980 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006772.91405 | 2106836.7155400002 | 37.765355044821206 | -122.41979068552 | (37.7653550448212, -122.41979068552) | |||
| 117641 | 117641 | 15428 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1994 12:00:00 AM | 18 | 3X3 | 6006867.61446 | 2106023.64726 | 37.7631278842618 | -122.419405452183 | (37.7631278842618, -122.419405452183) | ||
| 117717 | 117717 | 28609 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1117 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996444.46775 | 2091779.60617 | 37.723424677500205 | -122.454426406995 | (37.7234246775002, -122.454426406995) | ||
| 117906 | 117906 | 28390 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1556 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995079.29349 | 2092240.59215 | 37.7246120461485 | -122.459178896827 | (37.7246120461485, -122.459178896827) | ||
| 118654 | 118654 | 28553 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4791 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001495.20995 | 2091053.11607 | 37.7217182698376 | -122.436914966203 | (37.7217182698376, -122.436914966203) | ||
| 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) | ||
| 119225 | 119225 | 28631 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1051 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5x5 | 5996604.51775 | 2091735.3595900002 | 37.7233123645372 | -122.45386995284099 | (37.7233123645372, -122.453869952841) | ||
| 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) | ||
| 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) | ||
| 120120 | 120120 | 28479 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3x3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
| 120258 | 120258 | 28637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 24 | 5XX5 | 5996975.36021 | 2091606.08521 | 37.7229786625948 | -122.452578702244 | (37.7229786625948, -122.452578702244) | ||
| 120677 | 120677 | 28435 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992163.8663800005 | 2094231.44033 | 37.7299103829045 | -122.469401909547 | (37.7299103829045, -122.469401909547) | ||
| 121147 | 121147 | 28431 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2439 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991850.14781 | 2094403.3644599998 | 37.7303643088426 | -122.470498978 | (37.7303643088426, -122.470498978) | ||
| 122080 | 122080 | 93965 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) |
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");