trees
7,322 rows where qSpecies_id = 1 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||||
| 22970 | 252896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 501x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 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 | |||
| 23430 | 111771 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1350 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992447 | 2106254 | 37.7629376108266 | -122.469297826347 | (37.7629376108266, -122.469297826347) | 1 | 8 | 11 | 56 | 12 | ||||
| 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 | ||
| 23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 24641 | 254195 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1265 Monterey Blvd | 2 | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 | |||
| 25244 | 107382 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 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 | |||
| 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 | |||
| 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 | ||
| 27147 | 251588 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | ||||
| 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 | ||
| 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 | ||||
| 28490 | 111716 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||
| 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 | ||
| 30347 | 107266 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 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 | |||
| 30766 | 254200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 728 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001420 | 2092797 | 37.7265023049847 | -122.437299752699 | (37.7265023049847, -122.437299752699) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 31856 | 110225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 32005 | 258331 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998216 | 2087138 | 37.7107813347674 | -122.447968545052 | (37.7107813347674, -122.447968545052) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | ||||
| 32450 | 103452 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 33610 | 107268 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 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 | ||
| 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 | ||
| 34479 | 105879 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2X HARRIET ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6010365 | 2111813 | 37.7792204741337 | -122.407717349172 | (37.7792204741337, -122.407717349172) | 14 | 2 | 9 | 28853 | 34 | ||||
| 34485 | 107032 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1816 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2014 12:00:00 AM | 3x3 | Permit Number 770866 | 6001738.71676 | 2112630.00996 | 37.7809771031987 | -122.437617693546 | (37.7809771031987, -122.437617693546) | 15 | 5 | 11 | 29490 | 41 | ||
| 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 | |
| 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 | |||
| 35605 | 116992 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
| 35820 | 253670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001095 | 2086792 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 36980 | 105047 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 278 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | 9 | 8 | 6 | 28861 | 24 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 |
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) );