trees
183 rows where qLegalStatus_id = 7 and qSpecies_id = 6 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
| 18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
| 45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |
| 58225 | 88206 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 187 Beaumont Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51211 | 5996832.5 | 2111680.5 | 37.7780898241501 | -122.454522014682 | (37.7780898241501, -122.454522014682) | 15 | 6 | 2 | 54 | 16 | |||
| 60329 | 255502 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 248 Arlington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781971 | 6004730.8147 | 2096705.01729 | 37.7374205056678 | -122.426132488181 | (37.7374205056678, -122.426132488181) | 2 | 7 | 5 | 63 | 7 | |
| 64938 | 256897 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 66000 | 88139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |
| 68875 | 88095 | 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 | |||
| 88149 | 88094 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1474 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51098 | 5983765.2 | 2105129.7 | 37.7593450832678 | -122.499241618892 | (37.7593450832678, -122.499241618892) | 1 | 8 | 3 | 56 | 35 | |||
| 108409 | 88108 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1935 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51112 | 5981615.2 | 2101901.1 | 37.7503538981052 | -122.50643780728 | (37.7503538981052, -122.50643780728) | 1 | 8 | 3 | 29491 | 35 | |||
| 108856 | 88244 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585 | 2105809 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | 15 | 5 | 5 | 28862 | 3 | |||
| 110666 | 254576 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2138 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781492 | 5982342.68444 | 2100548.37441 | 37.7466824957237 | -122.50382198427 | (37.7466824957237, -122.50382198427) | 1 | 8 | 3 | 29491 | 35 | |
| 117364 | 88527 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1501 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51477 | 5994255.6 | 2105256.2 | 37.7603022580943 | -122.462970154312 | (37.7603022580943, -122.462970154312) | 1 | 5 | 4 | 56 | 12 | |||
| 132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
| 134165 | 258203 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2422 41st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781120 | 5983650.02463 | 2098655.15546 | 37.741561019666 | -122.499161539913 | (37.741561019666, -122.499161539913) | 1 | 8 | 3 | 29491 | 35 | |
| 139732 | 88255 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220 | 2108137 | 37.7684397634087 | -122.44946678759 | (37.7684397634087, -122.44946678759) | 15 | 5 | 11 | 29492 | 9 | |||
| 146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
| 164479 | 88270 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346 | 2106829 | 37.7649697094425 | -122.442019266807 | (37.7649697094425, -122.442019266807) | 15 | 5 | 5 | 28862 | 3 | ||
| 166093 | 88438 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421 | 2117567 | 37.7949666840821 | -122.411389656386 | (37.7949666840821, -122.411389656386) | 3 | 1 | 10 | 28857 | 4 | |||
| 166701 | 254575 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2446 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781489 | 5983035.61421 | 2098477.14413 | 37.7410361869592 | -122.501272763587 | (37.7410361869592, -122.501272763587) | 1 | 8 | 3 | 29491 | 35 | |
| 167767 | 88087 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | 1 | 8 | 3 | 56 | 35 | |||
| 171435 | 258215 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2400 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | Permit Number 783182 | 5983025.27936 | 2098776.48804 | 37.7418574964013 | -122.501330634264 | (37.7418574964013, -122.501330634264) | 1 | 8 | 3 | 29491 | 35 | ||
| 188002 | 88645 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2500x Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51618 | 6006882.7 | 2119972.1 | 37.8014277902223 | -122.420343352043 | (37.8014277902223, -122.420343352043) | 5 | 1 | 1 | 28858 | 32 | |||
| 1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
| 9616 | 92857 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | |||
| 15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
| 17128 | 39895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | 2 | 4 | 5 | 28862 | 3 | ||
| 18773 | 255529 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782018 | ||||||||||
| 19677 | 39613 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
| 19897 | 102064 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | 2 | 7 | 7 | 28859 | 2 | |
| 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 | ||
| 23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 23899 | 95684 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.419274361386 | (37.72572301772, -122.419274361386) | 9 | 7 | 7 | 309 | 5 | |
| 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 | |||
| 24945 | 89565 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5001X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782749 | 5983089.78021 | 2111680.23644 | 37.777291329944 | -122.502062233879 | (37.777291329944, -122.502062233879) | 11 | 6 | 2 | 55 | 26 |
| 29015 | 41825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2511 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42211 | 5998436.39026341 | 2111725.32035622 | 37.7783047466177 | -122.44897683474 | (37.7783047466177, -122.44897683474) | 15 | 6 | 2 | 54 | 16 | |||
| 29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
| 29816 | 95998 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |
| 32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
| 32952 | 37416 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.7484676127991 | -122.435948474317 | (37.7484676127991, -122.435948474317) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 41094 | 51607 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) | 15 | 5 | 11 | 29492 | 9 |
| 41225 | 82433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.407911712216 | (37.745350741274, -122.407911712216) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 47337 | 83396 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.7610136443426 | -122.43411515125 | (37.7610136443426, -122.43411515125) | 15 | 4 | 5 | 28862 | 3 | ||
| 49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
| 50859 | 114691 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | |||
| 51502 | 94694 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
| 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 | |
| 53141 | 71841 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 1 | 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 | ||
| 59014 | 95404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | 2 | 7 | 5 | 63 | 22 | |
| 60630 | 81333 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53535 | 5993364.90659405 | 2104537.49939321 | 37.7582775482109 | -122.46599839572 | (37.7582775482109, -122.46599839572) | 1 | 8 | 4 | 56 | 12 | ||
| 76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
| 79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
| 79116 | 58020 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4020 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 11:16:00 AM | 3 | Permit Number 16987 | 5983299.23983496 | 2106318.86318391 | 37.7625828423592 | -122.500941055889 | (37.7625828423592, -122.500941055889) | 1 | 8 | 3 | 56 | 35 | ||
| 80064 | 83344 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.7605927188575 | -122.43872224382 | (37.7605927188575, -122.43872224382) | 2 | 4 | 5 | 28862 | 3 | ||
| 86000 | 37052 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 156 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49822 | 6005524.96145532 | 2099948.44891125 | 37.7463710884027 | -122.423617283508 | (37.7463710884027, -122.423617283508) | 2 | 7 | 5 | 28859 | 22 | ||
| 87404 | 88256 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
| 89162 | 88397 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.7817097621118 | -122.487138517946 | (37.7817097621118, -122.487138517946) | 11 | 6 | 2 | 55 | 26 | ||
| 89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 91359 | 103118 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 443 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | Permit Number 769638 | 5992399.1 | 2090786.9 | 37.72046611452 | -122.468338191478 | (37.72046611452, -122.468338191478) | 9 | 8 | 6 | 64 | 24 | |||
| 92191 | 105012 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 96120 | 27315 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1330X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009430.10492 | 2094285.00827 | 37.7310401662886 | -122.409714013149 | (37.7310401662886, -122.409714013149) | 9 | 3 | 7 | 309 | 28 | ||
| 97607 | 43061 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3050 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 53563 | 5983775.74745702 | 2098849.58098564 | 37.7421022336559 | -122.498741199638 | (37.7421022336559, -122.498741199638) | 1 | 8 | 3 | 29491 | 35 | |||
| 99236 | 46892 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
| 103589 | 49895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1411 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46669 | 6007945.54854347 | 2107355.95750477 | 37.7668467518318 | -122.415771573837 | (37.7668467518318, -122.415771573837) | 8 | 4 | 7 | 28853 | 19 |
| 104233 | 102092 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 106631 | 51232 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 114382 | 102384 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 116336 | 41826 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2517 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42212 | 5998421.57666404 | 2111723.27260806 | 37.7782982768263 | -122.449027932684 | (37.7782982768263, -122.449027932684) | 15 | 6 | 2 | 54 | 16 | |||
| 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 | |
| 117931 | 74157 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768269 | 6008310.54477322 | 2097714.64471242 | 37.740394399357 | -122.413827044611 | (37.740394399357, -122.413827044611) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 122458 | 87640 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | 10 | 3 | 8 | 58 | 1 | |||
| 125722 | 82079 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1648 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50227 | 6009276.07844564 | 2099765.78028808 | 37.7460805446245 | -122.410633408071 | (37.7460805446245, -122.410633408071) | 2 | 7 | 7 | 28859 | 2 | ||
| 134136 | 84680 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | 9 | 8 | 4 | 28861 | 24 | ||
| 134804 | 82755 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | 2 | 7 | 7 | 28859 | 2 | ||
| 137235 | 88480 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837 | 2096254 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | 10 | 3 | 8 | 58 | 1 | ||
| 141188 | 83302 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2366 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50740 | 5982401.73888916 | 2099005.47811571 | 37.7424496018256 | -122.503503550435 | (37.7424496018256, -122.503503550435) | 1 | 8 | 3 | 29491 | 35 | ||
| 142495 | 88724 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
| 144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
| 148517 | 109183 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 148668 | 49802 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071 | 2106574 | 37.765042114519 | -122.394529717904 | (37.765042114519, -122.394529717904) | 14 | 3 | 8 | 28856 | 29 | ||
| 148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
| 149039 | 83301 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 150135 | 50120 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769150 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||
| 152474 | 94162 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53533 | 5993469.4 | 2103573.4 | 37.7556364086322 | -122.465566975178 | (37.7556364086322, -122.465566975178) | 1 | 8 | 4 | 56 | 12 | ||
| 154918 | 52292 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48451 | 6006201.82590602 | 2099532.89904471 | 37.7452682661505 | -122.421247257698 | (37.7452682661505, -122.421247257698) | 2 | 7 | 5 | 28859 | 2 | ||
| 155024 | 83961 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50859 | 5997460.19616594 | 2106774.33360384 | 37.7646547355545 | -122.451996543237 | (37.7646547355545, -122.451996543237) | 15 | 5 | 11 | 29492 | 9 | ||
| 156212 | 27014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1518 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 6 | 3X3 | 6010461.99919 | 2094665.45469 | 37.7321425639198 | -122.40617335478 | (37.7321425639198, -122.40617335478) | 10 | 3 | 7 | 309 | 28 | ||
| 158967 | 79726 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | 5 | 1 | 10 | 28858 | 21 | ||
| 159117 | 51978 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | 2 | 4 | 5 | 28862 | 3 | ||
| 163948 | 42105 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 |
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) );