trees
39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );