183 rows where qLegalStatus_id = 7 and qSpecies_id = 6

View and edit SQL

These facets timed out: 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)
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
3013 109184 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5 Santa Rosa Ave 2 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
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
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
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
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
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
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
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
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
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
31662 27080 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 799X Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 2X3   6006577.59669 2093640.72947 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915) 9 7 7 309 5
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
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
33564 27026 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2005 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
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
37255 108775 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
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
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
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
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
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
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
54619 108768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
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
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
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
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
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
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
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
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
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
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
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
94732 88465 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 3 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
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
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
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
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
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
108067 27003 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
108222 108764 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);