trees
7,322 rows where qSpecies_id = 1 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20053 | 88130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 822 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234 | 2099702 | 37.7454512540188 | -122.438437243524 | (37.7454512540188, -122.438437243524) | 2 | 4 | 5 | 63 | 22 | |||
20288 | 26672 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495X Geneva Ave | 6 | 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 | |||
20387 | 40292 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3695X 24th St | 1 | 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 | ||
20403 | 217605 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5996058.7204 | 2091888.0044 | 37.7237001828408 | -122.455767688681 | (37.7237001828408, -122.455767688681) | 9 | 8 | 4 | 28861 | 24 | ||
20409 | 34062 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1960 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37964 | 6008029.26997895 | 2107027.39297988 | 37.7659492963405 | -122.415458730511 | (37.7659492963405, -122.415458730511) | 8 | 4 | 7 | 28853 | 19 | ||
21046 | 95730 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 207 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767476 | 6004003.2 | 2092421.6 | 37.7256180518537 | -122.428342990208 | (37.7256180518537, -122.428342990208) | 9 | 7 | 6 | 28861 | 5 | |
21110 | 87947 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50970 | 6000915.1 | 2105542.6 | 37.7614699863558 | -122.439958652567 | (37.7614699863558, -122.439958652567) | 15 | 5 | 5 | 28862 | 3 | ||
21609 | 75037 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51135 | 5988394.66653183 | 2103793.82497453 | 37.755947632918 | -122.483132944316 | (37.755947632918, -122.483132944316) | 1 | 8 | 3 | 56 | 35 | ||
21713 | 88316 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093 | 37.7219225920035 | -122.431143024225 | (37.7219225920035, -122.431143024225) | 9 | 7 | 6 | 28861 | 5 | |||
21800 | 49894 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 38 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/2012 12:00:00 AM | Permit Number 769410 | 6009978.40832944 | 2099202.86648775 | 37.7445742579885 | -122.408165137802 | (37.7445742579885, -122.408165137802) | 2 | 7 | 7 | 28859 | 2 | ||
21946 | 104709 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | Permit Number 769024 | 6011230.99687 | 2113233.86621 | 37.7831702808186 | -122.404821553875 | (37.7831702808186, -122.404821553875) | 12 | 2 | 9 | 28853 | 34 | |||
22046 | 35863 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1998 12:00:00 AM | Permit Number 39077 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
22494 | 32586 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1495 33rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | Permit Number 37056 | 5985867.67151542 | 2105066.25689491 | 37.7592940037764 | -122.49196567934 | (37.7592940037764, -122.49196567934) | 1 | 8 | 3 | 56 | 35 | ||
22771 | 36260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39271 | 5991253.03942343 | 2094450.93126102 | 37.730460371115 | -122.472566711187 | (37.730460371115, -122.472566711187) | 9 | 8 | 4 | 64 | 40 | ||
22950 | 116203 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
23109 | 217611 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5996185.5817 | 2091853.3157 | 37.7236122156709 | -122.455326647671 | (37.7236122156709, -122.455326647671) | 9 | 8 | 4 | 28861 | 24 | ||
23214 | 84608 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50841 | 6005059.05085072 | 2120549.16999723 | 37.8029093444786 | -122.426695114755 | (37.8029093444786, -122.426695114755) | 13 | 9 | 1 | 57 | 17 | ||
23278 | 88325 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 346 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623 | 2091442 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | 9 | 7 | 6 | 28861 | 5 | |||
23436 | 82875 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 3 | 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 | ||
23831 | 34208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 615 Edinburg St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38025 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |||
23904 | 88195 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51199 | 6011062 | 2112189 | 37.7802918756168 | -122.405332612017 | (37.7802918756168, -122.405332612017) | 14 | 2 | 9 | 28853 | 34 | |||
23964 | 51424 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 33 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | Permit Number 47746 | 6006388.07711494 | 2109118.29405382 | 37.7715980307524 | -122.421283782095 | (37.7715980307524, -122.421283782095) | 8 | 2 | 9 | 28853 | 19 | |||
24013 | 67828 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 710 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 3x3 | Permit Number 31489 | 5999080 | 2108181 | 37.768609734872 | -122.446495301803 | (37.768609734872, -122.446495301803) | 15 | 5 | 11 | 29492 | 9 | ||
24158 | 106174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 1 | 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 | ||||
24202 | 54896 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 168 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | 3x3 | Permit Number 10761 | 5997518.11388038 | 2107130.00064711 | 37.7656346240705 | -122.451821882169 | (37.7656346240705, -122.451821882169) | 15 | 5 | 11 | 29492 | 9 | ||
24203 | 88677 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 18 | 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 | ||
24246 | 26260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1550 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2003 12:00:00 AM | 16 | 3X3 | 6005878.3965356 | 2099932.1533401 | 37.746346288341 | -122.422393986743 | (37.746346288341, -122.422393986743) | 2 | 7 | 5 | 28859 | 22 | ||
24253 | 86716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 396 Capp St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196 | 2105003 | 37.7603439142388 | -122.418197308773 | (37.7603439142388, -122.418197308773) | 2 | 4 | 7 | 28859 | 19 | ||||
24258 | 36324 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 243 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39297 | 5996005.37027262 | 2094359.08502134 | 37.7304821167644 | -122.456130683218 | (37.7304821167644, -122.456130683218) | 9 | 7 | 4 | 28861 | 40 | ||
24611 | 217610 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | Width 0ft | 5996168.7329 | 2091856.7846 | 37.7236207736962 | -122.455385141266 | (37.7236207736962, -122.455385141266) | 9 | 8 | 4 | 28861 | 24 | ||
24633 | 116207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
24734 | 136867 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 7 | Width 4ft | Permit Number 773338 | 6006067.02029 | 2112827.44756 | 37.7817643621779 | -122.42265796469 | (37.7817643621779, -122.42265796469) | 7 | 9 | 11 | 28852 | 41 | |
25230 | 107929 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | ||
25625 | 15936 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
25698 | 105278 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 568-570 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x9 | Permit Number 771026 | 6002982 | 2104934 | 37.7599163606325 | -122.432766629071 | (37.7599163606325, -122.432766629071) | 2 | 4 | 5 | 28862 | 3 | ||
26134 | 22497 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6325 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1993 12:00:00 AM | 6 | 3x3 | 6013219.52561 | 2090374.53789 | 37.7205144342923 | -122.396339265181 | (37.7205144342923, -122.396339265181) | 10 | 3 | 8 | 58 | 1 | ||
26142 | 95527 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2320 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767318 | 5986850 | 2102357 | 37.7519124926116 | -122.488369249357 | (37.7519124926116, -122.488369249357) | 1 | 8 | 3 | 56 | 35 | |
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 |
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) );