39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id

View and edit SQL

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)
26243 46462 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1117 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2002 12:00:00 AM     Permit Number 44666 5996472.56509168 2091769.89725998 37.7233996304944 -122.454328579229 (37.7233996304944, -122.454328579229) 9 8 4 28861 24
26433 28624 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1299 Ocean Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 3 3X3   5996025.31382 2091881.53932 37.7236805140054 -122.455882701682 (37.7236805140054, -122.455882701682) 9 8 4 28861 24
26468 33224 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 180 Vasquez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37414 5994590.17804179 2099200.2584756 37.7436934484873 -122.461373990317 (37.7436934484873, -122.461373990317) 1 8 4 59 40
26490 84084 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3664-3666 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50588 6005212.30175688 2104901.65121607 37.7599537774464 -122.425050791006 (37.7599537774464, -122.425050791006) 2 4 5 28859 19
26545 88331 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 635 Madrid St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51319 6002224 2090226 37.7194885890815 -122.434336629443 (37.7194885890815, -122.434336629443) 9 7 6 28861 5
26669 28630 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1299 Ocean Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 3 3X3   5996025.31382 2091881.53932 37.7236805140054 -122.455882701682 (37.7236805140054, -122.455882701682) 9 8 4 28861 24
26866 99838 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1399X FUNSTON AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3 Permit Number 44828 5992090 2106254 37.7629169745179 -122.470532554608 (37.7629169745179, -122.470532554608) 1 8 11 56 12
26874 49335 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1333 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51461 6006487.43488669 2105334.34827577 37.7612138104839 -122.420671432253 (37.7612138104839, -122.420671432253) 2 4 7 28859 19
27359 82052 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 201X Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52259 6009357.12193255 2099180.37438681 37.744477692202 -122.410311842873 (37.744477692202, -122.410311842873) 2 7 7 28859 2
27501 1231 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3601X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1992 12:00:00 AM 15 3X3   5993438.31243 2087500.59861 37.7115026878867 -122.464507504506 (37.7115026878867, -122.464507504506) 9 8 4 64 24
27663 39317 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3344 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/1998 12:00:00 AM     Permit Number 40893 6007219.04940289 2105598.34676892 37.7619798956613 -122.418159800155 (37.7619798956613, -122.418159800155) 8 4 7 28859 19
28128 86714 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 858 Duncan St   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49701 6001009 2099689 37.745402758221 -122.439214324332 (37.745402758221, -122.439214324332) 2 4 5 63 22
28233 17097 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1685 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1994 12:00:00 AM 6 3x3   5998961.33091 2109338.80165 37.7717819854662 -122.44698909517 (37.7717819854662, -122.44698909517) 15 5 11 29492 9
28933 1112 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2385 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1992 12:00:00 AM 10 3x3   5999333.8364 2089049.0837 37.7160925721821 -122.444242302293 (37.7160925721821, -122.444242302293) 9 7 6 28861 25
29666 42208 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 735 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42478 6013099.95011607 2112666.9423578 37.7817179260512 -122.398315895959 (37.7817179260512, -122.398315895959) 6 2 9 28856 34
30152 28602 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1415 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 3 3X3   5995560.80655 2092018.51871 37.7240299560752 -122.457498319043 (37.7240299560752, -122.457498319043) 9 8 4 28861 24
30171 38885 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3300 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM     Permit Number 768222 5996965.46840287 2112983.07502769 37.7816739778787 -122.45415613649 (37.7816739778787, -122.45415613649) 11 6 1 54 31
30435 10176 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1070 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2010 12:00:00 AM 0 3x3 Permit Number 53294 6005702.26311 2102736.9430799 37.7540376587481 -122.423202374429 (37.7540376587481, -122.423202374429) 2 4 5 28859 19
30736 42949 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 996 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42843 6007571.84518521 2103864.78808287 37.7572397945138 -122.416816791906 (37.7572397945138, -122.416816791906) 2 4 7 28859 19
30791 37483 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1231 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39952 5990766.46629453 2107018.80014303 37.7649402911763 -122.475165987831 (37.7649402911763, -122.475165987831) 11 8 3 56 12
30858 16329 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 798 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2015 01:28:00 PM 3 3X3   5996878.01135 2094753.32608 37.7316146598965 -122.453142302231 (37.7316146598965, -122.453142302231) 9 7 4 59 40
30872 88706 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2020 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 51653 6004475.4 2108255.2 37.769120165328 -122.427838335035 (37.769120165328, -122.427838335035) 7 9 5 28862 3
30917 28 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 742 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2011 12:00:00 AM 3 3x3   6003863.8671794 2107765.4342001 37.7677407737782 -122.429918651186 (37.7677407737782, -122.429918651186) 7 9 5 28862 3
31059 44055 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 751Divisadero Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2006 12:00:00 AM     Permit Number 43583 6002120.85770365 2108760.0753661 37.7703729501471 -122.436018680596 (37.7703729501471, -122.436018680596) 15 5 5 29492 9
31080 32313 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 201 Bennington St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36886 6007144.22803033 2097010.87398607 37.7383964323493 -122.417809844406 (37.7383964323493, -122.417809844406) 2 7 7 28859 2
31195 87957 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1398x MARIPOSA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50983 6013218 2106201 37.7639704813344 -122.397453893083 (37.7639704813344, -122.397453893083) 14 3 8 28856 29
31359 36983 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 4135 California St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39607 5994802.83395529 2114343.04174012 37.7852838325005 -122.461736411306 (37.7852838325005, -122.461736411306) 11 6 2 54 11
31772 88704 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2020 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 51653 6004475.4 2108255.2 37.769120165328 -122.427838335035 (37.769120165328, -122.427838335035) 7 9 5 28862 3
31953 22793 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1900 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2004 12:00:00 AM 3 3X3   6000859.91406 2112118.82857 37.7795235241193 -122.440621222807 (37.7795235241193, -122.440621222807) 15 5 1 29490 41
32071 86715 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 868 Duncan St   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49700 6001011.7 2099706.8 37.7454517864355 -122.439206263756 (37.7454517864355, -122.439206263756) 2 4 5 63 22
32565 106176 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1500 Van Ness Ave 3 Sidewalk: Curb side : Pot Tree Private 2         Permit Number 771770 6006417.5 2115761.6 37.7898405898041 -122.421653930851 (37.7898405898041, -122.421653930851) 13 9 10 28858 21
32597 28392 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1616 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2003 12:00:00 AM 3 3X3   5994990.37685 2092269.58619 37.7246865445791 -122.459488367015 (37.7246865445791, -122.459488367015) 9 8 4 28861 40
32696 40293 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3695X 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41437 6005149.32455817 2101953.724968 37.7518559035882 -122.425058847152 (37.7518559035882, -122.425058847152) 2 4 5 28859 19
32851 136853 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 628 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782762 6008257.35293 2114172.86388 37.7855818817524 -122.415175683534 (37.7855818817524, -122.415175683534) 13 10 9 28858 36
33236 26706 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 224X Cornwall St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   5994708.38646 2114247.12411 37.7850150313441 -122.462056210173 (37.7850150313441, -122.462056210173) 11 6 2 54 11
33295 88679 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 601 25th St 20 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748) 10 3 8 58 1
33307 40025 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 201 Middle Point Rd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41269 6018237.8883759 2095348.52577329 37.7344500201686 -122.379337522448 (37.7344500201686, -122.379337522448) 10 3 8 58 1
33427 87972 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1907 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51007 6000452.2 2111655.1 37.7782270179807 -122.441998381309 (37.7782270179807, -122.441998381309) 15 5 11 29490 16
33482 10062 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 497 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1997 12:00:00 AM 3 3X3   6005580.9933972 2106078.9124418 37.7632070792286 -122.423859376385 (37.7632070792286, -122.423859376385) 8 4 5 28859 19
33516 87910 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 337 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50935 6006807.9 2096075.7 37.735809718571 -122.418906397457 (37.735809718571, -122.418906397457) 2 7 7 28859 2
33569 108551 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 61-79X Santa Ysabel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773713 6000867.23405 2093153.75099 37.7274504222348 -122.439236196788 (37.7274504222348, -122.439236196788) 9 7 6 28861 25
33623 26669 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 495X Geneva Ave 3 Sidewalk: Curb side : Cutout Tree MTA 3     8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
33706 53037 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1701 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM 12 3x3 Permit Number 50944 6005276 2115519 37.7891100372749 -122.425586144928 (37.7891100372749, -122.425586144928) 13 9 1 28858 27
33863 91157 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 245 Fowler Ave 5 Sidewalk: Property side : Yard Tree Private 2     3 10x90 Permit Number 52034 5997288.6 2099113.8 37.743610991306 -122.452037308764 (37.743610991306, -122.452037308764) 9 7 4 59 40
34308 105924 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 995 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2014 12:00:00 AM   3x3 Permit Number 769111 6007873.5 2115092.6 37.7880856736468 -122.416568881841 (37.7880856736468, -122.416568881841) 13 1 10 28858 21
34380 248148 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 26 Massasoit St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM 3 Width 2ft Permit Number 53496 6010009.79788 2099371.25828 37.7450383826304 -122.408068471788 (37.7450383826304, -122.408068471788) 2 7 7 28859 2
34408 82876 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 100 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52475 6010457.79461314 2094219.31159395 37.730917314013 -122.406156470326 (37.730917314013, -122.406156470326) 10 3 7 309 28
34963 8825 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3910X Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1996 12:00:00 AM 3 3X3   5994869.79454 2112891.23375 37.7813014128549 -122.461399464652 (37.7813014128549, -122.461399464652) 11 6 2 54 11
34980 83907 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 786 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50515 6001252.05343795 2092407.65188088 37.7254236948459 -122.437852461444 (37.7254236948459, -122.437852461444) 9 7 6 28861 25
35057 33968 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1997 12:00:00 AM     Permit Number 37917 6007661.76235911 2121488.31416717 37.8056348004683 -122.417754973992 (37.8056348004683, -122.417754973992) 5 1 10 308 23
35195 95642 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 499 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/2011 12:00:00 AM   3x3 Permit Number 767412 6016343 2104894.1 37.7605555140891 -122.386554213192 (37.7605555140891, -122.386554213192) 10 3 8 310 29
35267 256901 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 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
35339 36401 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 98X COLON AVE 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39329 5996199 2093723 37.7287466926272 -122.455415326965 (37.7287466926272, -122.455415326965) 9 7 4 28861 40
35399 34520 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 201 Stillings Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/1997 12:00:00 AM     Permit Number 38229 5999437.15230869 2095745.6775321 37.7344857636851 -122.444366166746 (37.7344857636851, -122.444366166746) 9 7 4 59 40
35510 31783 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35254 5989534.846924 2097688.46988301 37.7392502171048 -122.478743370392 (37.7392502171048, -122.478743370392) 1 8 3 29491 35
35824 87908 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 119 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50928 6005524.6 2096705.9 37.7374677625458 -122.423388060981 (37.7374677625458, -122.423388060981) 2 7 7 28859 2
35850 17721 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1300X Pierce St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   01/28/2013 12:00:00 AM 3 3X3 Permit Number 768629 6002290.56024 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321) 15 5 11 29490 41
36026 6009 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1700X Eddy St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2008 12:00:00 AM 3 4X4   6002299.53279 2112652.56753 37.781070910956 -122.435679170736 (37.781070910956, -122.435679170736) 15 5 11 29490 41
36238 33970 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1997 12:00:00 AM     Permit Number 37917 6007661.76235911 2121488.31416717 37.8056348004683 -122.417754973992 (37.8056348004683, -122.417754973992) 5 1 10 308 23
36386 32365 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 101 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36916 6005767.33287279 2099031.81897703 37.7438679090482 -122.422714061246 (37.7438679090482, -122.422714061246) 2 7 7 28859 2
36664 40480 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 260 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2014 12:00:00 AM 3 3x4 Permit Number 772719 5996556.77238085 2091558.46328432 37.7228239115254 -122.454022229017 (37.7228239115254, -122.454022229017) 9 8 4 28861 24
36678 45038 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2303 24th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43927 5988847.11690672 2099646.08528379 37.744585360466 -122.48126452014 (37.744585360466, -122.48126452014) 1 8 3 29491 35
36771 37481 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1426 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39950 5991174.90965929 2105693.07747265 37.7613238750308 -122.473656583673 (37.7613238750308, -122.473656583673) 1 8 4 56 12
36944 14524 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 633 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5999110.06323 2110621.57238 37.775312642744 -122.446566928571 (37.775312642744, -122.446566928571) 15 5 11 29492 16
36975 35791 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 29 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39042 6006023.42439271 2105330.88066656 37.7611781266824 -122.422276003028 (37.7611781266824, -122.422276003028) 2 4 5 28859 19
37003 37916 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1300 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM 4 3x3 Permit Number 40178 6013279.95089898 2106637.32404771 37.765171979803 -122.397270220878 (37.765171979803, -122.397270220878) 14 3 8 28856 20
37214 30900 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 312 Hoffman St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34727 6000605.10855575 2101945.95840013 37.7515768334539 -122.440772778765 (37.7515768334539, -122.440772778765) 2 4 5 28862 22
37480 46087 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 246 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2001 12:00:00 AM     Permit Number 44464 6003518.20643074 2106832.04007823 37.7651583185222 -122.431047622386 (37.7651583185222, -122.431047622386) 15 4 5 28862 3
37641 51702 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 115 Manor Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50762 5993699.41109297 2093661.42014461 37.7284338669105 -122.464052029113 (37.7284338669105, -122.464052029113) 9 8 4 59 40
38087 62736 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 4455 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/1986 12:00:00 AM   3x3 Permit Number 50004 6001230.12062967 2105213.82146283 37.7605851686902 -122.438845567584 (37.7605851686902, -122.438845567584) 2 4 5 28862 3
38257 31997 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 4101 California St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1995 12:00:00 AM     Permit Number 35396 5994904.25505416 2114357.18842086 37.7853285132073 -122.461386553657 (37.7853285132073, -122.461386553657) 11 6 2 54 11
38352 217608 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1201 Ocean Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 5 Width 0ft   5996131.5665 2091869.1734 37.7236526577627 -122.455514513257 (37.7236526577627, -122.455514513257) 9 8 4 28861 24
38477 94887 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1570 Underwood Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53953 6014750 2093656.9 37.7296121929682 -122.391278188352 (37.7296121929682, -122.391278188352) 10 3 8 58 1
38541 38764 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945) 9 7 4 28861 25
38798 31007 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 106 Drake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34781 6001462.17793128 2086756.21041895 37.7099180463866 -122.436721720566 (37.7099180463866, -122.436721720566) 9 7 6 28861 5
38912 44515 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 135 Montecito Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM     Permit Number 43819 5996489.97139085 2094266.89703237 37.7302567951805 -122.454448699789 (37.7302567951805, -122.454448699789) 9 7 4 28861 40
39019 33225 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 180 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37414 5994590.17804179 2099200.2584756 37.7436934484873 -122.461373990317 (37.7436934484873, -122.461373990317) 1 8 4 59 40
39409 35858 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 827 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2002 12:00:00 AM     Permit Number 44931 6002288.79188076 2088794.75109809 37.7155623744331 -122.434010413526 (37.7155623744331, -122.434010413526) 9 7 6 28861 5
39647 35104 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 901 Edinburg St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 3 3x3 Permit Number 38646 6001673.16157429 2088830.08645148 37.7156244401162 -122.436140833024 (37.7156244401162, -122.436140833024) 9 7 6 28861 5
40265 32550 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 101 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM     Permit Number 37041 6006055.96272335 2109107.09574597 37.7715485533825 -122.4224317908 (37.7715485533825, -122.4224317908) 8 2 9 28853 19
40273 95790 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 149 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767533 6005988.9 2106409.4 37.7641375394288 -122.422472045587 (37.7641375394288, -122.422472045587) 8 4 5 28859 19
40279 92465 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3500 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/01/2008 12:00:00 AM   3x3 Permit Number 52850 5983435 2104281 37.7569954148981 -122.500320846178 (37.7569954148981, -122.500320846178) 1 8 3 56 35
40296 89346 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 110 Hoffman Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51930 6000570.6 2102426.2 37.75289349552 -122.440926561392 (37.75289349552, -122.440926561392) 2 4 5 28862 22
40703 32545 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 101 Valencia St 10 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM     Permit Number 37041 6006055.96272335 2109107.09574597 37.7715485533825 -122.4224317908 (37.7715485533825, -122.4224317908) 8 2 9 28853 19
40757 36230 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1485 Yosemite Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/05/1998 12:00:00 AM     Permit Number 39263 6015221.12155905 2092170.90026948 37.7255580692538 -122.389545718534 (37.7255580692538, -122.389545718534) 10 3 8 58 1
40842 28493 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1550 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM 16 3X3   6005878.3965356 2099932.1533401 37.746346288341 -122.422393986743 (37.746346288341, -122.422393986743) 2 7 5 28859 22
40948 51847 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 138 Cyril Magnin St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM   3x3 Permit Number 48071 6010188.39401853 2113860.37409529 37.7848321915742 -122.408472762748 (37.7848321915742, -122.408472762748) 14 10 10 28852 36
41101 27541 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1390 Illinois St 1 Sidewalk: Curb side : Cutout Tree Port 6   03/30/2006 12:00:00 AM 6 3X3   6016157.095863 2102619.361637 37.7542992711205 -122.387038518734 (37.7542992711205, -122.387038518734) 10 3 8 28856 29
41515 36210 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1455 Yosemite Ave 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/05/1998 12:00:00 AM     Permit Number 39262 6015374.49012429 2092056.56629028 37.7252526334632 -122.389007552668 (37.7252526334632, -122.389007552668) 10 3 8 58 1
41572 92781 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 150 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2009 12:00:00 AM 3 3x3 Permit Number 52997 6006262 2110430 37.775192551515 -122.421813078941 (37.775192551515, -122.421813078941) 7 9 11 28852 10
41679 26313 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2000X San Jose Ave 16 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973) 9 7 6 28861 25
41714 95716 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 950 Avalon Ave 1 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
42134 107923 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 495 09th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993087.78951 2112168.62834 37.7792146104853 -122.467511711649 (37.7792146104853, -122.467511711649) 11 6 2 54 11
42319 91098 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 535 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2009 12:00:00 AM   3x3 Permit Number 51988 6007027.8 2091471.2 37.7231791421759 -122.417819832233 (37.7231791421759, -122.417819832233) 9 7 7 309 28
42354 38538 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 4517 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1998 12:00:00 AM     Permit Number 40515 6015241.886192 2096337.56497418 37.7370000434098 -122.389764834673 (37.7370000434098, -122.389764834673) 10 3 8 58 1
42505 33732 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 73 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37795 6003855.80093987 2108827.04659377 37.7706552465529 -122.430022290128 (37.7706552465529, -122.430022290128) 7 9 11 29492 10
42526 88341 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 51 Prague St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51327 6004823 2090807 37.7212310687473 -122.425394157088 (37.7212310687473, -122.425394157088) 9 7 6 28861 5
42804 81923 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2524X Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50824 6006683.22400402 2119851.76004091 37.8010861247199 -122.421025080133 (37.8010861247199, -122.421025080133) 5 9 1 28858 32
43052 42950 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 996 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42843 6007571.84518521 2103864.78808287 37.7572397945138 -122.416816791906 (37.7572397945138, -122.416816791906) 2 4 7 28859 19
43296 37177 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 82 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1998 12:00:00 AM     Permit Number 39750 6006243.85281213 2099611.0315252 37.7454851695113 -122.421107482255 (37.7454851695113, -122.421107482255) 2 7 5 28859 2

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