trees
1,121 rows where qSpecies_id = 6 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
28853 | 88712 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004166 | 2109783 | 37.7732976245409 | -122.429017475211 | (37.7732976245409, -122.429017475211) | 7 | 9 | 11 | 29492 | 10 | ||
29195 | 34680 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.431295719127 | (37.7996008996227, -122.431295719127) | 13 | 9 | 1 | 57 | 17 | |
29272 | 129388 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006666.99925 | 2119949.93729 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | 5 | 9 | 1 | 28858 | 32 | |||
41709 | 129378 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | 13 | 9 | 1 | 29490 | 27 | |||
42678 | 87855 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2537 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50783 | 6006632 | 2119882 | 37.8011662683494 | -122.421204486113 | (37.8011662683494, -122.421204486113) | 5 | 9 | 1 | 28858 | 32 | ||
43690 | 52885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.7924687577648 | -122.436169092224 | (37.7924687577648, -122.436169092224) | 13 | 9 | 1 | 29490 | 27 | ||
52224 | 129373 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | 13 | 9 | 1 | 57 | 17 | |||
53066 | 54871 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 250 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778523 | 6005357.45103895 | 2109955.71553685 | 37.7738392293497 | -122.424908369576 | (37.7738392293497, -122.424908369576) | 7 | 9 | 11 | 28852 | 10 | |
57139 | 83205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | 13 | 9 | 1 | 57 | 17 | |
63396 | 129389 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006655.24817 | 2120043.69212 | 37.8016115444852 | -122.421135524881 | (37.8016115444852, -122.421135524881) | 5 | 9 | 1 | 28858 | 32 | |||
67418 | 255648 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2834 Polk St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779253 | 6006100.90264 | 2120497.78973 | 37.8028271147622 | -122.423086110708 | (37.8028271147622, -122.423086110708) | 5 | 9 | 1 | 28858 | 32 | |
74064 | 42693 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |
92442 | 129379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1765 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005697.11148 | 2117184.40611 | 37.793706610722 | -122.424247645012 | (37.793706610722, -122.424247645012) | 13 | 9 | 1 | 28858 | 27 | |||
95828 | 129377 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002239.2844 | 2116842.37021 | 37.7925716168296 | -122.436187522037 | (37.7925716168296, -122.436187522037) | 13 | 9 | 1 | 29490 | 27 | |||
116939 | 67239 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 3x9 | Permit Number 30703 | 6003792.49486353 | 2108815.33294247 | 37.770619498227 | -122.430240430849 | (37.770619498227, -122.430240430849) | 15 | 9 | 11 | 29492 | 10 | |
119734 | 227100 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004326.55063 | 2108840.26945 | 37.7707182026243 | -122.428394902803 | (37.7707182026243, -122.428394902803) | 7 | 9 | 11 | 28852 | 10 | |||
120895 | 88732 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | 13 | 9 | 11 | 29490 | 13 | ||
124185 | 227585 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003798.52213 | 2108785.73673 | 37.7705385756322 | -122.430217470683 | (37.7705385756322, -122.430217470683) | 15 | 9 | 11 | 29492 | 10 | |||
129850 | 244513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 500 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | 7 | 9 | 11 | 29492 | 10 | |||
135075 | 52442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.431503592933 | (37.7920224826905, -122.431503592933) | 13 | 9 | 1 | 29490 | 27 | |
136198 | 255789 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2240 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003983 | 2116665 | 37.7921835181407 | -122.430141547967 | (37.7921835181407, -122.430141547967) | 13 | 9 | 1 | 29490 | 27 | ||||
142719 | 124805 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2798 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781937 | 5999607.72686 | 2118800.07594 | 37.7977970943207 | -122.445433600384 | (37.7977970943207, -122.445433600384) | 13 | 9 | 1 | 57 | 17 | |
160845 | 227580 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 23 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003811.04552 | 2108200.21185 | 37.7689315761679 | -122.430132375016 | (37.7689315761679, -122.430132375016) | 7 | 9 | 5 | 28862 | 3 | |||
163097 | 129372 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999985.51807 | 2120890.75849 | 37.8035591091338 | -122.444276660352 | (37.8035591091338, -122.444276660352) | 13 | 9 | 1 | 57 | 17 | |||
169832 | 65853 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.441501736515 | (37.8013609996628, -122.441501736515) | 13 | 9 | 1 | 57 | 17 | |
178838 | 88733 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51668 | 6004334 | 2108794 | 37.7705915794801 | -122.428365836994 | (37.7705915794801, -122.428365836994) | 7 | 9 | 11 | 28852 | 10 | ||
179565 | 129387 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.8010643609816 | -122.421036932226 | (37.8010643609816, -122.421036932226) | 5 | 9 | 1 | 28858 | 32 | |||
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
2908 | 93406 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2015 11:15:00 AM | 3 | 3x3 | 5988828.0589 | 2099030.2661 | 37.7428933746541 | -122.48128533094 | (37.7428933746541, -122.48128533094) | 1 | 8 | 3 | 29491 | 35 | ||
4850 | 262150 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
6557 | 264929 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 4725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784398 | 5981118.81181 | 2106198.14775 | 37.7621231273763 | -122.508473270866 | (37.7621231273763, -122.508473270866) | 1 | 8 | 3 | 56 | 35 | |
6683 | 262152 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
9692 | 183446 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | 1 | 8 | 3 | 29491 | 35 | ||
10037 | 183693 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | 1 | 8 | 3 | 56 | 35 | ||
10383 | 264872 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 06:03:00 PM | 3 | 4x6 | 5985846 | 2098694 | 37.7417962544182 | -122.491571569344 | (37.7417962544182, -122.491571569344) | 1 | 8 | 3 | 29491 | 35 | |
12204 | 164659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785596 | 5994533.58351 | 2098539.8464 | 37.7418768645301 | -122.461521809887 | (37.7418768645301, -122.461521809887) | 1 | 8 | 4 | 59 | 40 | |
12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
13074 | 264871 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2430 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2020 12:00:00 AM | 3 | 4x6 | 5985228 | 2098648 | 37.7416338152793 | -122.493704989969 | (37.7416338152793, -122.493704989969) | 1 | 8 | 3 | 29491 | 35 | ||
13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
13541 | 60816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2110 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 4 | Permit Number 20494 | 5989779.2235 | 2100978.3623 | 37.7482975910503 | -122.478138904702 | (37.7482975910503, -122.478138904702) | 1 | 8 | 3 | 29491 | 35 | |
13622 | 207003 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992355.41935 | 2099194.17897 | 37.7435478822362 | -122.469100735806 | (37.7435478822362, -122.469100735806) | 1 | 8 | 4 | 29491 | 40 | |||
14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
14691 | 69919 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
15585 | 258769 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1633 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2019 12:00:00 AM | 3 | 3x3 | 5988962.35654 | 2103065.4403 | 37.7539807026125 | -122.481116375927 | (37.7539807026125, -122.481116375927) | 1 | 8 | 3 | 56 | 35 | ||
16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
16581 | 258150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2485 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5989205.22412 | 2098441.55094 | 37.7412988370865 | -122.479938140892 | (37.7412988370865, -122.479938140892) | 1 | 8 | 3 | 29491 | 35 | |||
18909 | 262153 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
19297 | 58021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971657 | (37.7625717348083, -122.50121971657) | 1 | 8 | 3 | 56 | 35 | ||
19468 | 95897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.480765700813 | (37.7555618218669, -122.480765700813) | 1 | 8 | 3 | 56 | 35 |
19993 | 182699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.7558399109499 | -122.480728726959 | (37.7558399109499, -122.480728726959) | 1 | 8 | 3 | 56 | 35 | |||
20055 | 206989 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | 1 | 8 | 11 | 56 | 12 | |||
20319 | 106193 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638004 | -122.499011481047 | (37.742177638004, -122.499011481047) | 1 | 8 | 3 | 29491 | 35 | ||||
20394 | 48661 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1300 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2005 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.7638910715093 | -122.468357408335 | (37.7638910715093, -122.468357408335) | 1 | 8 | 11 | 56 | 12 | ||
21675 | 50111 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 250 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46832 | 5992489.27392501 | 2099148.73533454 | 37.7434308389356 | -122.468634598074 | (37.7434308389356, -122.468634598074) | 1 | 8 | 4 | 29491 | 40 | ||
23031 | 88096 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
23262 | 51411 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.480966595693 | (37.7581930050331, -122.480966595693) | 1 | 8 | 3 | 56 | 35 | |
24639 | 43060 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3054 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 53563 | 5983697 | 2098912 | 37.7422690003261 | -122.499018090006 | (37.7422690003261, -122.499018090006) | 1 | 8 | 3 | 29491 | 35 | |||
25168 | 83917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50173 | 5981576.71105327 | 2104986.37444115 | 37.7588229209977 | -122.506799717054 | (37.7588229209977, -122.506799717054) | 1 | 8 | 3 | 56 | 35 | |
25751 | 182700 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.480679561224 | (37.7558407372502, -122.480679561224) | 1 | 8 | 3 | 56 | 35 | |||
27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
29174 | 183692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | 1 | 8 | 3 | 56 | 35 | ||
30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
30373 | 184599 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | 1 | 8 | 3 | 56 | 35 | |||
30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
30582 | 183121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | 1 | 8 | 3 | 29491 | 35 | |||
31883 | 84000 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.472084716598 | (37.7451230278663, -122.472084716598) | 1 | 8 | 4 | 29491 | 40 | |
32050 | 92441 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) | 1 | 8 | 3 | 56 | 35 |
32976 | 207036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990861.16949 | 2098351.90974 | 37.7411487751831 | -122.474205983836 | (37.7411487751831, -122.474205983836) | 1 | 8 | 4 | 29491 | 40 | |||
34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
34355 | 80237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.493852234736 | (37.7558298048279, -122.493852234736) | 1 | 8 | 3 | 56 | 35 | |||
35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
36596 | 50110 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 250 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46832 | 5992489.27392501 | 2099148.73533454 | 37.7434308389356 | -122.468634598074 | (37.7434308389356, -122.468634598074) | 1 | 8 | 4 | 29491 | 40 | ||
36793 | 95431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) | 1 | 8 | 3 | 29491 | 35 |
37185 | 83309 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.7582079811023 | -122.503696933051 | (37.7582079811023, -122.503696933051) | 1 | 8 | 3 | 56 | 35 | |
37491 | 95899 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) | 1 | 8 | 3 | 56 | 35 |
39271 | 37722 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3001 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 04:53:00 PM | 3 | 3x3 | Permit Number 774917 | 5983850.6165 | 2098795.1757 | 37.7419572424052 | -122.498478312402 | (37.7419572424052, -122.498478312402) | 1 | 8 | 3 | 29491 | 35 | |
39349 | 98850 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
39727 | 182826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136929 | (37.7539396409234, -122.48943136929) | 1 | 8 | 3 | 56 | 35 | |||
40337 | 254524 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/10/2015 07:56:00 AM | 3 | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |
41357 | 255423 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
41606 | 207031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1528 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992776.06817 | 2105054.20165 | 37.7596622898883 | -122.468072424026 | (37.7596622898883, -122.468072424026) | 1 | 8 | 4 | 56 | 12 | |||
41654 | 112585 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
41781 | 207002 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992354.33739 | 2099175.8386 | 37.7434974617379 | -122.469103142406 | (37.7434974617379, -122.469103142406) | 1 | 8 | 4 | 29491 | 40 | |||
42322 | 24532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.507091481475 | (37.7607233666377, -122.507091481475) | 1 | 8 | 3 | 56 | 35 | ||
44272 | 92401 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.7643199783579 | -122.494515603708 | (37.7643199783579, -122.494515603708) | 1 | 8 | 3 | 56 | 35 |
44650 | 206994 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992653.289 | 2105901.13559 | 37.761980656709 | -122.468558674846 | (37.761980656709, -122.468558674846) | 1 | 8 | 4 | 56 | 12 | |||
44798 | 184494 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | 1 | 8 | 3 | 56 | 35 | |||
46414 | 112583 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | |||
48643 | 98849 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | |
48766 | 207033 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.7491407714503 | -122.466516461993 | (37.7491407714503, -122.466516461993) | 1 | 8 | 4 | 29491 | 12 | |||
49016 | 257890 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1266 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782773 | 5983690.81524 | 2106537.44734 | 37.7632059962022 | -122.499602915235 | (37.7632059962022, -122.499602915235) | 1 | 8 | 3 | 56 | 35 | |
50062 | 254193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1265 Monterey Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781221 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 |
50194 | 183672 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | 1 | 8 | 3 | 56 | 35 | |||
50370 | 109275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) | 1 | 8 | 3 | 56 | 35 |
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) );