trees
1,121 rows where qSpecies_id = 6 sorted by DBH
This data as json, CSV (advanced)
qLegalStatus_id ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1126 | 262542 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015016 | 2090665 | 37.7214117898675 | -122.390149655616 | (37.7214117898675, -122.390149655616) | 10 | 3 | 8 | 58 | 1 | |||
1777 | 260927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 354 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5981645 | 2112753 | 37.7801518383055 | -122.507139709579 | (37.7801518383055, -122.507139709579) | 11 | 6 | 2 | 55 | 26 | ||||
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 | |||
9840 | 256599 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
10365 | 256095 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | ||||
10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
13676 | 262543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015062.6163 | 2090599.75011 | 37.7212352119804 | -122.389983958896 | (37.7212352119804, -122.389983958896) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
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 | |||
16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
16319 | 258436 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002636 | 2104802 | 37.7595342910111 | -122.433953838093 | (37.7595342910111, -122.433953838093) | 2 | 4 | 5 | 28862 | 3 | ||||
16338 | 261024 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 751 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989703 | 2110237 | 37.773714894321 | -122.479079631213 | (37.773714894321, -122.479079631213) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
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 | |||
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 | |
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 | |||
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 | |
24082 | 88257 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | 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 | ||
24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 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 | |||
25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
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 | |||
29256 | 256605 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
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 | |
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 | ||
31525 | 251509 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
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 | |||
32904 | 256600 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | |
51877 | 256607 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
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 | ||
53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
54999 | 101252 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992716.9 | 2106688.9 | 37.7641473244126 | -122.468395985577 | (37.7641473244126, -122.468395985577) | 11 | 8 | 11 | 56 | 12 | ||||
55354 | 92858 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
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 | |
59213 | 115174 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
61590 | 256576 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
63206 | 115239 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | 11 | 6 | 2 | 55 | 26 | |||
63992 | 39614 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 2 | 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 | ||
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 | |||
68252 | 106608 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 2 | 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 | ||
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 | |||
69435 | 114895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | 11 | 6 | 2 | 55 | 26 | |||
70541 | 256574 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
72790 | 40470 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
73269 | 92664 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 2 | 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 | |||
77162 | 102385 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 2 | 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 | ||
78293 | 116736 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |
79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
80264 | 105013 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 2 | 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 | ||||
84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
86722 | 94695 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 2 | 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 | |
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 | ||
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 | |||
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 | ||||
92562 | 256604 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
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 | |||
98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 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 | ||
99415 | 51233 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 2 | 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 | |||
101005 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 6 | 1499X 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | 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 | |||
103037 | 251507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
103947 | 51230 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 3 | 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 | |||
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 | |||
107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | 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 | |||
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 | |||
108745 | 92226 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
111712 | 253162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004481 | 2091226 | 37.7223622223708 | -122.426606175157 | (37.7223622223708, -122.426606175157) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 |
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) );