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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77857 | 77857 | 84000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.47208471659799 | (37.7451230278663, -122.472084716598) | |
| 77937 | 77937 | 106193 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638003994 | -122.499011481047 | (37.742177638004, -122.499011481047) | ||||
| 78895 | 78895 | 81730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774950 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | |
| 78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
| 79452 | 79452 | 54871 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778523 | 6005357.45103895 | 2109955.71553685 | 37.773839229349704 | -122.424908369576 | (37.7738392293497, -122.424908369576) | |
| 79989 | 79989 | 95720 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 80905 | 80905 | 90725 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4701X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980935.002069999 | 2110229.7439200003 | 37.773181881349004 | -122.509408420019 | (37.773181881349, -122.509408420019) | ||
| 81387 | 81387 | 83396 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.761013644342604 | -122.43411515125 | (37.7610136443426, -122.43411515125) | ||
| 81515 | 81515 | 94694 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
| 81686 | 81686 | 90243 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:19:00 AM | 3 | 3x3 | 5986256.13943 | 2111172.66934 | 37.7760832028982 | -122.491071565578 | (37.7760832028982, -122.491071565578) | ||
| 82028 | 82028 | 82433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.40791171221599 | (37.745350741274, -122.407911712216) | ||
| 83380 | 83380 | 101252 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992716.9 | 2106688.9 | 37.764147324412605 | -122.46839598557699 | (37.7641473244126, -122.468395985577) | ||||
| 84032 | 84032 | 92858 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
| 84200 | 84200 | 98848 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | ||
| 84274 | 84274 | 87855 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2537 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50783 | 6006632.0 | 2119882.0 | 37.8011662683494 | -122.421204486113 | (37.8011662683494, -122.421204486113) | ||
| 84495 | 84495 | 840 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.420684201 | 2105445.3666042998 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | ||
| 84962 | 84962 | 90278 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4332 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982097.18566 | 2111025.0008400003 | 37.7754338822902 | -122.50544730055 | (37.7754338822902, -122.50544730055) | ||
| 85355 | 85355 | 90715 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4530 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981529.23414 | 2110319.83024 | 37.773464252019004 | -122.507359614365 | (37.773464252019, -122.507359614365) | ||
| 85422 | 85422 | 88095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.49912702260201 | (37.7534794912156, -122.499127022602) | |||
| 85631 | 85631 | 95404 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | |
| 85798 | 85798 | 42693 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |
| 87024 | 87024 | 90734 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4519 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981558.45056 | 2110264.5871200003 | 37.773314291486294 | -122.507254453094 | (37.7733142914863, -122.507254453094) | ||
| 87710 | 87710 | 88139 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | |||
| 88283 | 88283 | 90713 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981576.37852 | 2110321.34111 | 37.773471177271105 | -122.507196650108 | (37.7734711772711, -122.507196650108) | ||
| 88455 | 88455 | 81333 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53535 | 5993364.90659405 | 2104537.49939321 | 37.7582775482109 | -122.46599839571999 | (37.7582775482109, -122.46599839572) | ||
| 89101 | 89101 | 90714 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981557.47501 | 2110321.74662 | 37.7734711772765 | -122.50726206903 | (37.7734711772765, -122.50726206903) | ||
| 89138 | 89138 | 88206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51211 | 5996832.5 | 2111680.5 | 37.7780898241501 | -122.45452201468201 | (37.7780898241501, -122.454522014682) | |||
| 90243 | 90243 | 90305 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4201X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982481.013259999 | 2110978.58794 | 37.775329025693104 | -122.504116133843 | (37.7753290256931, -122.504116133843) | ||
| 91576 | 91576 | 90720 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4634 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981186.20352 | 2110308.00833 | 37.7734115809285 | -122.508545307898 | (37.7734115809285, -122.508545307898) | ||
| 92563 | 92563 | 90277 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982116.47387 | 2111024.58745 | 37.7754338822795 | -122.505380548569 | (37.7754338822795, -122.505380548569) | ||
| 92744 | 92744 | 90280 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4344 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982056.98615 | 2111023.40443 | 37.775427133307204 | -122.505586239401 | (37.7754271333072, -122.505586239401) | ||
| 92779 | 92779 | 88094 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51098 | 5983765.2 | 2105129.7 | 37.759345083267796 | -122.499241618892 | (37.7593450832678, -122.499241618892) | |||
| 93530 | 93530 | 88397 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.781709762111795 | -122.487138517946 | (37.7817097621118, -122.487138517946) | ||
| 93834 | 93834 | 116736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988397.0 | 2103119.0 | 37.754094880795606 | -122.48307541499399 | (37.7540948807956, -122.483075414994) | ||||
| 94109 | 94109 | 102385 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.768410224110205 | -122.438031497558 | (37.7684102241102, -122.438031497558) | ||
| 94167 | 94167 | 88256 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536.0 | 2106665.0 | 37.76441609532 | -122.44826776566099 | (37.76441609532, -122.448267765661) | ||
| 94537 | 94537 | 83344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.760592718857495 | -122.43872224382 | (37.7605927188575, -122.43872224382) | ||
| 94653 | 94653 | 88465 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 96116 | 96116 | 94672 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.45021314346901 | (37.732430335747, -122.450213143469) | |
| 96167 | 96167 | 94695 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771.0 | 2106542.0 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | |
| 96405 | 96405 | 89539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5238 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982360.37978 | 2111711.22049 | 37.7773335253891 | -122.50458771883699 | (37.7773335253891, -122.504587718837) | ||
| 96869 | 96869 | 90309 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982775.05183 | 2110989.27027 | 37.7753756437209 | -122.503099794321 | (37.7753756437209, -122.503099794321) | ||
| 97094 | 97094 | 37052 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 156 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49822 | 6005524.96145532 | 2099948.44891125 | 37.746371088402704 | -122.423617283508 | (37.7463710884027, -122.423617283508) | ||
| 97343 | 97343 | 95721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 97731 | 97731 | 92226 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.41527458403401 | (37.7590797904057, -122.415274584034) | ||
| 98279 | 98279 | 120680 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717.0 | 2090174.0 | 37.719430440149104 | -122.42917217063999 | (37.7194304401491, -122.42917217064) | ||
| 98532 | 98532 | 115939 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316.0 | 2111712.0 | 37.7775090776113 | -122.49436347548901 | (37.7775090776113, -122.494363475489) | |
| 98955 | 98955 | 90723 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4750X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980837.13634 | 2110295.92473 | 37.773357823394605 | -122.50975186123199 | (37.7733578233946, -122.509751861232) | ||
| 99545 | 99545 | 88108 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1935 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51112 | 5981615.2 | 2101901.1 | 37.7503538981052 | -122.50643780728001 | (37.7503538981052, -122.50643780728) | |||
| 101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 102031 | 102031 | 90939 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4144 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982653.54392 | 2111040.34267 | 37.7755087308719 | -122.50352389434201 | (37.7755087308719, -122.503523894342) | ||
| 102266 | 102266 | 88244 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4330 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585.0 | 2105809.0 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | |||
| 102285 | 102285 | 102092 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391.0 | 37.744996275991504 | -122.414008688761 | (37.7449962759915, -122.414008688761) | |
| 102591 | 102591 | 49895 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1411 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46669 | 6007945.54854347 | 2107355.95750477 | 37.7668467518318 | -122.41577157383699 | (37.7668467518318, -122.415771573837) |
| 102671 | 102671 | 94671 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | |
| 103543 | 103543 | 105757 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | |
| 104034 | 104034 | 82079 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1648 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50227 | 6009276.07844564 | 2099765.78028808 | 37.7460805446245 | -122.410633408071 | (37.7460805446245, -122.410633408071) | ||
| 104102 | 104102 | 90248 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986089.18026 | 2111167.85377 | 37.7760602246469 | -122.491648759198 | (37.7760602246469, -122.491648759198) | ||
| 104405 | 104405 | 90971 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4101 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982789.9497 | 2110989.59501 | 37.775377411022205 | -122.503048284011 | (37.7753774110222, -122.503048284011) | ||
| 105236 | 105236 | 116735 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1799x 25TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988397.0 | 2103119.0 | 37.754094880795606 | -122.48307541499399 | (37.7540948807956, -122.483075414994) | ||||
| 105336 | 105336 | 102384 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.768410224110205 | -122.438031497558 | (37.7684102241102, -122.438031497558) | ||
| 105500 | 105500 | 92859 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | ||
| 106448 | 106448 | 88732 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | ||
| 106923 | 106923 | 88527 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1501 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51477 | 5994255.6 | 2105256.2 | 37.7603022580943 | -122.462970154312 | (37.7603022580943, -122.462970154312) | |||
| 107437 | 107437 | 95999 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054683998 | (37.7362914700729, -122.39132054684) | |
| 107504 | 107504 | 90238 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986478.45159 | 2111179.35168 | 37.7761145368708 | -122.49030303077299 | (37.7761145368708, -122.490303030773) | ||
| 107556 | 107556 | 109136 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.474359999 | 2111505.41074 | 37.7768703987748 | -122.49856689090299 | (37.7768703987748, -122.498566890903) |
| 107833 | 107833 | 87640 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | |||
| 108236 | 108236 | 27114 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 451 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2009 12:00:00 AM | 3 | 3x3 | 6004400.62614 | 2093530.84049 | 37.728686260787796 | -122.427048090034 | (37.7286862607878, -122.427048090034) | ||
| 110202 | 110202 | 84332 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | ||
| 110281 | 110281 | 116789 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007719.0 | 2095661.0 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | ||||
| 110297 | 110297 | 88724 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
| 111655 | 111655 | 102180 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) |
| 111831 | 111831 | 94654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689.0 | 2095884.0 | 37.73510724004171 | -122.429675988088 | (37.7351072400417, -122.429675988088) | |
| 112359 | 112359 | 82755 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | ||
| 112446 | 112446 | 83301 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | ||
| 112698 | 112698 | 88255 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220.0 | 2108137.0 | 37.7684397634087 | -122.44946678758998 | (37.7684397634087, -122.44946678759) | |||
| 114363 | 114363 | 90966 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4245 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982369.3768 | 2110976.86332 | 37.775317724630604 | -122.50450217585501 | (37.7753177246306, -122.504502175855) | ||
| 114553 | 114553 | 84680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | ||
| 115306 | 115306 | 83302 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2366 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50740 | 5982401.73888916 | 2099005.47811571 | 37.7424496018256 | -122.50350355043501 | (37.7424496018256, -122.503503550435) | ||
| 115634 | 115634 | 90743 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4429 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981841.9267 | 2110274.36208 | 37.773357823390896 | -122.50627461209801 | (37.7733578233909, -122.506274612098) | ||
| 115830 | 115830 | 95897 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.48076570081301 | (37.7555618218669, -122.480765700813) |
| 115928 | 115928 | 109183 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 5 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270.0 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) |
| 116014 | 116014 | 88480 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837.0 | 2096254.0 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | ||
| 116120 | 116120 | 113418 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007207.0 | 2095355.0 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | |||
| 116902 | 116902 | 90719 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4616 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981255.7970900005 | 2110310.22456 | 37.7734217675099 | -122.50830474267099 | (37.7734217675099, -122.508304742671) | ||
| 117474 | 117474 | 88087 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | |||
| 118027 | 118027 | 79726 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | ||
| 118167 | 118167 | 43321 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 283 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49915 | 6004368.565719999 | 2091597.24704 | 37.7233752280736 | -122.427021263027 | (37.7233752280736, -122.427021263027) | |
| 118463 | 118463 | 102093 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391.0 | 37.744996275991504 | -122.414008688761 | (37.7449962759915, -122.414008688761) | |
| 118655 | 118655 | 90283 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.7560900003 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | ||
| 118839 | 118839 | 88270 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346.0 | 2106829.0 | 37.764969709442504 | -122.44201926680701 | (37.7649697094425, -122.442019266807) | ||
| 119216 | 119216 | 42105 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 119242 | 119242 | 87861 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | ||
| 120493 | 120493 | 90705 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982162.77985 | 2110342.56704 | 37.773563978190495 | -122.505169810987 | (37.7735639781905, -122.505169810987) | ||
| 120684 | 120684 | 88438 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Mason St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421.0 | 2117567.0 | 37.794966684082105 | -122.41138965638599 | (37.7949666840821, -122.411389656386) | |||
| 120706 | 120706 | 94162 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1750 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53533 | 5993469.4 | 2103573.4 | 37.7556364086322 | -122.46556697517799 | (37.7556364086322, -122.465566975178) | ||
| 121973 | 121973 | 51978 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | ||
| 122015 | 122015 | 88207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51211 | 5996848.1239 | 2111670.4224 | 37.7780630497691 | -122.454467238117 | (37.7780630497691, -122.454467238117) | |
| 122176 | 122176 | 109275 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) |
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");