trees
6,344 rows where qSpecies_id = 19 sorted by PlotSize
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11403 | 50704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 668 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 4 | Permit Number 47265 | 5990372.18083 | 2110858.00002 | 37.7754588289828 | -122.476810236416 | (37.7754588289828, -122.476810236416) | 11 | 6 | 2 | 55 | 26 | |
11435 | 36622 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
11447 | 49551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2020 01:56:00 PM | 3 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.409068185146 | (37.7783593364429, -122.409068185146) | 14 | 2 | 9 | 28853 | 34 | ||
11507 | 71409 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1510 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015375.9848 | 2094913.1689 | 37.7330963758454 | -122.389201760959 | (37.7330963758454, -122.389201760959) | 10 | 3 | 8 | 58 | 1 | |||
11746 | 57593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1976 12:00:00 AM | 3 | Permit Number 16461 | 6003141.6397 | 2110360.8759 | 37.7748262921144 | -122.432602160624 | (37.7748262921144, -122.432602160624) | 15 | 9 | 11 | 29492 | 10 | |
11758 | 41190 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2020 12:00:00 AM | 3 | Permit Number 782407 | 6003669.72123 | 2117044.16503 | 37.7932068601533 | -122.431252574158 | (37.7932068601533, -122.431252574158) | 13 | 9 | 1 | 29490 | 27 | ||
11765 | 65228 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 736 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 28015 | 6003178.33467 | 2089873.36869 | 37.7185744644174 | -122.431012691703 | (37.7185744644174, -122.431012691703) | 9 | 7 | 6 | 28861 | 5 | |
11817 | 33081 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
11841 | 34905 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
11917 | 77997 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009714.16253 | 2086968.85209 | 37.7109674364637 | -122.408216166539 | (37.7109674364637, -122.408216166539) | 9 | 7 | 8 | 309 | 39 | |||
12021 | 31607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5 Lucerne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1995 12:00:00 AM | 9 | Permit Number 35133 | 6012055.45942 | 2109792.65137 | 37.7737675473795 | -122.40172727021 | (37.7737675473795, -122.40172727021) | 14 | 2 | 9 | 28853 | 34 | ||
12170 | 70672 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009676.94569 | 2110892.33688 | 37.7766540087164 | -122.410032610029 | (37.7766540087164, -122.410032610029) | 8 | 2 | 9 | 28853 | 34 | |||
12228 | 34902 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
12268 | 31434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4301 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 4 | Permit Number 35009 | 6001045.87161 | 2103295.69948 | 37.7553079883939 | -122.439345307039 | (37.7553079883939, -122.439345307039) | 2 | 4 | 5 | 28862 | 22 | |
12494 | 261750 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 127 Edgehill Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
12547 | 60392 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1474 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 3 | Permit Number 19972 | 6015573.2956 | 2094772.4682 | 37.7327209763825 | -122.388509781451 | (37.7327209763825, -122.388509781451) | 10 | 3 | 8 | 58 | 1 | |
12684 | 124078 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 701 Funston Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991927.57036 | 2110249.98447 | 37.7738794837524 | -122.471385513439 | (37.7738794837524, -122.471385513439) | 11 | 6 | 2 | 54 | 11 | ||||
12707 | 72459 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 414 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997210.21776 | 2114935.94674 | 37.7870500780436 | -122.45345046559 | (37.7870500780436, -122.45345046559) | 11 | 6 | 1 | 54 | 31 | |||
12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13043 | 73643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007653.32796 | 2115427.9906 | 37.7889941892882 | -122.417354417981 | (37.7889941892882, -122.417354417981) | 13 | 1 | 10 | 28858 | 21 | |||
13114 | 44440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 131 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 11 | Permit Number 43772 | 6001589.30817 | 2087293.58304 | 37.7114007774922 | -122.43632076831 | (37.7114007774922, -122.43632076831) | 9 | 7 | 6 | 28861 | 5 | |
13166 | 46255 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2161 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 44539 | 6000416.49604 | 2120605.00843 | 37.802799094759 | -122.442764714729 | (37.802799094759, -122.442764714729) | 13 | 9 | 1 | 57 | 17 | |||
13201 | 67714 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 599 02ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1996 12:00:00 AM | Permit Number 31327 | 6014887 | 2112829 | 37.7822622831747 | -122.392144832206 | (37.7822622831747, -122.392144832206) | 6 | 2 | 9 | 28856 | 6 | ||
13284 | 49957 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 31 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2003 12:00:00 AM | 3 | Permit Number 46711 | 5998403.3691 | 2110924.5502 | 37.7761041502752 | -122.449033366306 | (37.7761041502752, -122.449033366306) | 15 | 6 | 2 | 29492 | 16 | |
13384 | 39889 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
13657 | 73537 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984627.56608 | 2094712.464 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | 1 | 8 | 4 | 64 | 35 | |||
13661 | 70340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 31 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009840.88523 | 2094336.42019 | 37.7312043435876 | -122.408297494042 | (37.7312043435876, -122.408297494042) | 10 | 3 | 7 | 309 | 28 | |||
13766 | 52739 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | 3 | Permit Number 48788 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | ||
13879 | 79434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004043.3643 | 2110877.3492 | 37.7762954962714 | -122.42951974871 | (37.7762954962714, -122.42951974871) | 7 | 9 | 11 | 28852 | 10 | |||
13886 | 34906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
13940 | 58372 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 520 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 6 | Permit Number 22168 | 6013233.92594 | 2104448.90475 | 37.7591604996691 | -122.397275936353 | (37.7591604996691, -122.397275936353) | 10 | 3 | 8 | 28856 | 29 | |
13970 | 92645 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 5 | Permit Number 52936 | 6007592.74468 | 2118879.97123 | 37.7984690641427 | -122.41780881572 | (37.7984690641427, -122.41780881572) | 5 | 1 | 10 | 28858 | 32 | ||
14106 | 36623 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14123 | 36635 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14151 | 69802 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 627 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5985028.72707 | 2111563.88652 | 37.7770855845831 | -122.495346307533 | (37.7770855845831, -122.495346307533) | 11 | 6 | 2 | 55 | 26 | |||
14361 | 79632 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 66 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002838.60108 | 2094532.20162 | 37.7313473196134 | -122.432519596596 | (37.7313473196134, -122.432519596596) | 9 | 7 | 5 | 28861 | 25 | |||
14464 | 44040 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.74454 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | 13 | 6 | 1 | 29490 | 27 | ||
14575 | 30998 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34777 | 6003940.50328 | 2117270.99344 | 37.7938450145991 | -122.430331841946 | (37.7938450145991, -122.430331841946) | 13 | 9 | 1 | 29490 | 27 | |
14584 | 43091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 146 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 2 | Permit Number 42926 | 6008599.48377 | 2113045.82808 | 37.7825065339989 | -122.413912252043 | (37.7825065339989, -122.413912252043) | 7 | 10 | 9 | 28852 | 36 | |
14786 | 69030 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1451 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33036 | 5984623.8069 | 2105296.0559 | 37.7598521830846 | -122.496284456968 | (37.7598521830846, -122.496284456968) | 1 | 8 | 3 | 56 | 35 | |
14816 | 45836 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 | |||
14919 | 78301 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 631 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5985028.23693 | 2111540.90163 | 37.7770224459764 | -122.495346307534 | (37.7770224459764, -122.495346307534) | 11 | 6 | 2 | 55 | 26 | |||
15059 | 254699 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
15119 | 55242 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 176 Escolta Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1972 12:00:00 AM | 2 | Permit Number 11162 | 5986318.2122 | 2097305.7128 | 37.7380119721821 | -122.489836759019 | (37.7380119721821, -122.489836759019) | 1 | 8 | 3 | 29491 | 35 | |
15139 | 59028 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 8 | Permit Number 33258 | 6007963.18877572 | 2102524.96947488 | 37.7535829618491 | -122.415368521483 | (37.7535829618491, -122.415368521483) | 2 | 4 | 7 | 28859 | 19 | |
15265 | 60385 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1418 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19965 | 6015851.3994 | 2094564.1651 | 37.7321644254987 | -122.38753377178 | (37.7321644254987, -122.38753377178) | 10 | 3 | 8 | 58 | 1 | |
15275 | 36627 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15299 | 96710 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2012 12:00:00 AM | Permit Number 767523 | 5987054 | 2098280 | 37.7407300421735 | -122.487364354837 | (37.7407300421735, -122.487364354837) | 1 | 8 | 3 | 29491 | 35 | |||
15484 | 36610 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15553 | 73555 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011765.85635 | 2112068.38095 | 37.7800000110193 | -122.402889147539 | (37.7800000110193, -122.402889147539) | 6 | 2 | 9 | 28856 | 34 | |||
15576 | 261749 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 127 Edgehill Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
15685 | 65904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1334 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | Permit Number 28912 | 5993661.3773817 | 2106405.83948229 | 37.7634246223214 | -122.465108777096 | (37.7634246223214, -122.465108777096) | 1 | 8 | 11 | 56 | 12 | ||
15712 | 42849 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1339 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 9 | Permit Number 42779 | 6007122.62792 | 2118418.9864 | 37.7971768480902 | -122.419402847888 | (37.7971768480902, -122.419402847888) | 5 | 1 | 10 | 28858 | 32 | |
15831 | 59843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 3 | Permit Number 19298 | 6016839.42379 | 2093825.06532 | 37.730189678993 | -122.384066468412 | (37.730189678993, -122.384066468412) | 10 | 3 | 8 | 58 | 1 | |
15897 | 72062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009233.34768 | 2115143.00173 | 37.7883004477513 | -122.411867591225 | (37.7883004477513, -122.411867591225) | 5 | 1 | 10 | 28852 | 21 | |||
16013 | 108100 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2390X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
16230 | 46377 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2247 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 2 | Permit Number 44614 | 5982946.355 | 2099827.607 | 37.7447389446862 | -122.501681271429 | (37.7447389446862, -122.501681271429) | 1 | 8 | 3 | 29491 | 35 | |
16416 | 72471 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6011955.18605 | 2119478.23212 | 37.8003562770843 | -122.402755428236 | (37.8003562770843, -122.402755428236) | 3 | 1 | 10 | 308 | 23 | |||
16454 | 62978 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1127 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23368 | 6008126.82627 | 2118560.34319 | 37.7976214864014 | -122.415938076582 | (37.7976214864014, -122.415938076582) | 5 | 1 | 10 | 28858 | 21 | |
16484 | 65292 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/1990 12:00:00 AM | 14 | Permit Number 29486 | 6010574.9893 | 2116273.6869 | 37.7914802149935 | -122.407305449035 | (37.7914802149935, -122.407305449035) | 5 | 1 | 10 | 28857 | 6 | |
16555 | 64522 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 3 | Permit Number 25404 | 6000636.5766 | 2110378.3465 | 37.7747318815941 | -122.441268925505 | (37.7747318815941, -122.441268925505) | 15 | 5 | 11 | 29492 | 16 | |
16682 | 34784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1245 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38420 | 6007703.93896299 | 2102409.74434789 | 37.7532520054251 | -122.416256906305 | (37.7532520054251, -122.416256906305) | 2 | 4 | 7 | 28859 | 19 | ||
16783 | 72307 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3445 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997784.14469 | 2116089.53168 | 37.7902503973763 | -122.451548055904 | (37.7902503973763, -122.451548055904) | 11 | 6 | 1 | 54 | 31 | |||
16881 | 66780 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1341 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 10 | Permit Number 30046 | 6006517.61971 | 2119019.77197 | 37.7987923596445 | -122.421539021018 | (37.7987923596445, -122.421539021018) | 13 | 9 | 10 | 28858 | 32 | |
17007 | 82838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1415 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016205.4223 | 2093876.0516 | 37.7302946051933 | -122.386261868118 | (37.7302946051933, -122.386261868118) | 10 | 3 | 8 | 58 | 1 | |||
17019 | 45465 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2901 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44246 | 6000256.9932138 | 2116755.78762604 | 37.7922210605835 | -122.44304007615 | (37.7922210605835, -122.44304007615) | 13 | 6 | 1 | 29490 | 27 | |||
17074 | 36961 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39590 | 5994276.23416 | 2115338.33445 | 37.7879863078616 | -122.463630532758 | (37.7879863078616, -122.463630532758) | 11 | 6 | 1 | 54 | 11 | |
17083 | 66960 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30297 | 6010166.58935 | 2111603.96693 | 37.7786354094288 | -122.408388988373 | (37.7786354094288, -122.408388988373) | 14 | 2 | 9 | 28853 | 34 | |
17104 | 34766 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1051 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38408 | 6008054.52837271 | 2101811.29200567 | 37.7516284982081 | -122.415002137966 | (37.7516284982081, -122.415002137966) | 2 | 4 | 7 | 28859 | 19 | |||
17350 | 34904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
17419 | 78112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1540 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6000678.8845 | 2114000.0679 | 37.7846786148444 | -122.44138250451 | (37.7846786148444, -122.44138250451) | 15 | 6 | 11 | 29490 | 13 | |||
17618 | 60092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3330 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 10 | Permit Number 19593 | 5998284.04875 | 2116203.47298 | 37.7905918645605 | -122.449826647393 | (37.7905918645605, -122.449826647393) | 13 | 6 | 1 | 54 | 31 | |
17674 | 44782 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 7 | Permit Number 43880 | 6010323.60515 | 2105536.49074 | 37.7619843079564 | -122.407417940892 | (37.7619843079564, -122.407417940892) | 8 | 4 | 8 | 28859 | 19 | |
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
17955 | 60377 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19957 | 6016692.94797 | 2093937.42445 | 37.7304900957418 | -122.384580682763 | (37.7304900957418, -122.384580682763) | 10 | 3 | 8 | 58 | 1 | |
17966 | 106220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2840 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6000008.65567 | 2117119.29999 | 37.7932050075534 | -122.4439254553 | (37.7932050075534, -122.4439254553) | 13 | 9 | 1 | 57 | 27 | ||||
17967 | 258162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 125 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | |||
18010 | 53063 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2414 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | 6 | Permit Number 49036 | 6002461.41479 | 2117112.6303 | 37.7933262991092 | -122.435438286059 | (37.7933262991092, -122.435438286059) | 13 | 9 | 1 | 29490 | 27 | ||
18043 | 60382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 2 | Permit Number 19962 | 6016050.49586 | 2094420.00347 | 37.7317796120287 | -122.38683539465 | (37.7317796120287, -122.38683539465) | 10 | 3 | 8 | 58 | 1 | |
18364 | 66788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1346 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 9 | Permit Number 30061 | 6006476.7124 | 2119411.4454 | 37.7998654891501 | -122.421708408323 | (37.7998654891501, -122.421708408323) | 13 | 9 | 1 | 28858 | 32 | |
18447 | 75296 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 242 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5997878.4968 | 2109650.2697 | 37.7725752726039 | -122.45075713318 | (37.7725752726039, -122.45075713318) | 15 | 5 | 11 | 29492 | 16 | |||
18489 | 70673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 32-34 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6009696.99241 | 2110873.64198 | 37.7766038004599 | -122.409961942206 | (37.7766038004599, -122.409961942206) | 8 | 2 | 9 | 28853 | 34 | |||
18634 | 65446 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 563 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 7 | Permit Number 31326 | 6014757.61987 | 2112880.29542 | 37.7823959443489 | -122.392596022687 | (37.7823959443489, -122.392596022687) | 6 | 2 | 9 | 28856 | 6 | |
19017 | 73429 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5999651.1871 | 2110920.9027 | 37.7761654213524 | -122.444716582684 | (37.7761654213524, -122.444716582684) | 15 | 5 | 11 | 29492 | 16 | |||
19128 | 36616 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19181 | 40558 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2418 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1999 12:00:00 AM | 7 | Permit Number 41804 | 6003105.8528 | 2116546.98238 | 37.7918097534735 | -122.433168052783 | (37.7918097534735, -122.433168052783) | 13 | 9 | 1 | 29490 | 27 | |
19200 | 31807 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 83 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | 7 | Permit Number 41863 | 6001923.66923 | 2108139.32404 | 37.768657316218 | -122.436656314365 | (37.768657316218, -122.436656314365) | 15 | 5 | 5 | 29492 | 3 | |
19247 | 63477 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2064 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/1986 12:00:00 AM | 9 | Permit Number 24071 | 5999717.1794 | 2111601.8073 | 37.7780387769008 | -122.444537246991 | (37.7780387769008, -122.444537246991) | 15 | 5 | 11 | 29490 | 16 | |
19413 | 33513 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 283 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37607 | 6006312.43871152 | 2098305.73442698 | 37.7419049842036 | -122.420777672299 | (37.7419049842036, -122.420777672299) | 2 | 7 | 7 | 28859 | 2 | |||
19479 | 81046 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997413.7835 | 2086913.91099 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | 9 | 7 | 6 | 28861 | 25 | |||
19738 | 60123 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 298 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19650 | 6004272.79376242 | 2096671.25180618 | 37.7373018951098 | -122.42771367587 | (37.7373018951098, -122.42771367587) | 2 | 7 | 5 | 63 | 7 | ||
19881 | 32358 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1660 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36912 | 6010095.76502785 | 2119756.50526668 | 37.8010163522878 | -122.409209439254 | (37.8010163522878, -122.409209439254) | 3 | 1 | 10 | 308 | 23 | |||
19929 | 44203 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 590 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43652 | 5991947.54509 | 2111428.22525 | 37.7771157685884 | -122.471402286754 | (37.7771157685884, -122.471402286754) | 11 | 6 | 2 | 54 | 11 | ||
20211 | 53592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1426 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 2 | Permit Number 6521 | 6006754.9579 | 2115825.0045 | 37.790033705848 | -122.420490858055 | (37.790033705848, -122.420490858055) | 13 | 9 | 10 | 28858 | 21 | ||
21128 | 98717 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500@Polk Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 49344 | 6006371.84738 | 2118011.66864 | 37.7960161416733 | -122.421971790069 | (37.7960161416733, -122.421971790069) | 13 | 9 | 10 | 28858 | 32 | |||
21165 | 61387 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1907 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1984 12:00:00 AM | 8 | Permit Number 21304 | 6003890.4452 | 2115106.1173 | 37.7878979790124 | -122.430350517837 | (37.7878979790124, -122.430350517837) | 13 | 9 | 11 | 29490 | 27 | ||
21190 | 93913 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1233 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/26/2010 12:00:00 AM | 3 | Permit Number 53384 | 6006791.18319 | 2115201.26263 | 37.7883231061636 | -122.42032123196 | (37.7883231061636, -122.42032123196) | 13 | 9 | 10 | 28858 | 21 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );