trees
7,322 rows where qSpecies_id = 1 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114477 | 102313 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
| 159609 | 102525 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 310 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769739 | 5998596.99117 | 2115413.44206 | 37.7884405486385 | -122.448686963531 | (37.7884405486385, -122.448686963531) | 13 | 6 | 1 | 54 | 31 | |
| 37001 | 102528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 210 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769937 | 5990573.88934 | 2113965.84312 | 37.7840038051653 | -122.476339553346 | (37.7840038051653, -122.476339553346) | 11 | 6 | 2 | 54 | 26 | |
| 76017 | 102529 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 3x3 | Permit Number 768962 | 6013046 | 2116920 | 37.7933928248556 | -122.398801114306 | (37.7933928248556, -122.398801114306) | 4 | 1 | 10 | 28860 | 6 | ||
| 6900 | 102545 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015962.79104 | 2107111.95809 | 37.7666242197475 | -122.38802396564 | (37.7666242197475, -122.38802396564) | 14 | 3 | 9 | 310 | 20 | ||
| 4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
| 83034 | 102593 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995407.1 | 2092042.4 | 37.7240866981498 | -122.458031382697 | (37.7240866981498, -122.458031382697) | 9 | 8 | 4 | 28861 | 24 | ||||
| 139907 | 102611 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010058.3307 | 2120952.6173 | 37.8042984828907 | -122.409423440249 | (37.8042984828907, -122.409423440249) | 3 | 1 | 10 | 308 | 23 | |||
| 188825 | 102612 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010060 | 2120948 | 37.8042858984606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | 3 | 1 | 10 | 308 | 23 | ||||
| 164366 | 102734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5735 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997875.71647 | 2086830.45832 | 37.7099174384228 | -122.449122496232 | (37.7099174384228, -122.449122496232) | 9 | 7 | 6 | 28861 | 5 | |
| 101486 | 102735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5735 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997893.47207 | 2086837.6698 | 37.7099382550256 | -122.449061648972 | (37.7099382550256, -122.449061648972) | 9 | 7 | 6 | 28861 | 5 | |
| 32424 | 102772 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1440 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 31199 | 6006025.32539 | 2119349.84654 | 37.7996708902593 | -122.423265997228 | (37.7996708902593, -122.423265997228) | 13 | 9 | 1 | 28858 | 32 | ||
| 102214 | 102774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1472 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 31200 | 6005947.91695 | 2119337.23456 | 37.7996318920616 | -122.423532961902 | (37.7996318920616, -122.423532961902) | 13 | 9 | 1 | 28858 | 32 | ||
| 58938 | 102792 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700X Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011271.9 | 2091582.1 | 37.7237215812631 | -122.403156521576 | (37.7237215812631, -122.403156521576) | 10 | 3 | 7 | 309 | 28 | |||
| 160345 | 102793 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700X Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011271.9 | 2091582.1 | 37.7237215812631 | -122.403156521576 | (37.7237215812631, -122.403156521576) | 10 | 3 | 7 | 309 | 28 | |||
| 153110 | 102794 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700X Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011271.9 | 2091582.1 | 37.7237215812631 | -122.403156521576 | (37.7237215812631, -122.403156521576) | 10 | 3 | 7 | 309 | 28 | |||
| 28775 | 1028 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1989X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
| 133801 | 102879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 |
| 101061 | 102880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 | |
| 61303 | 102959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 129783 | 102970 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 59549 | 103157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 283 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2013 12:00:00 AM | 3x3 | Permit Number 58700 | 5994183.3 | 2087984.2 | 37.7128734608265 | -122.461967697406 | (37.7128734608265, -122.461967697406) | 9 | 8 | 6 | 28861 | 24 | ||
| 114504 | 10317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 737 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2014 02:22:00 PM | 3 | 3X4 | 6002624.3068 | 2109179.48151 | 37.7715531241993 | -122.434307241096 | (37.7715531241993, -122.434307241096) | 15 | 5 | 11 | 29492 | 9 | ||
| 169248 | 103272 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | 13 | 1 | 10 | 28858 | 21 | |
| 146163 | 103386 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1745 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5999466.5405 | 2110479.9214 | 37.7749440607163 | -122.445323608912 | (37.7749440607163, -122.445323608912) | 15 | 5 | 11 | 29492 | 16 | |||
| 190904 | 103387 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 42 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2013 12:00:00 AM | 3x3 | Permit Number 769958 | 5995374.8 | 2090202.8 | 37.7190337388046 | -122.458009970496 | (37.7190337388046, -122.458009970496) | 9 | 8 | 6 | 28861 | 24 | ||
| 75677 | 103450 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 77417 | 103451 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 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 | ||||
| 27382 | 10349 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 978 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2012 12:00:00 AM | 3 | 4x6 | 6001439.9402 | 2109063.1942 | 37.7711665324235 | -122.438395689895 | (37.7711665324235, -122.438395689895) | 15 | 5 | 11 | 29492 | 9 | ||
| 5918 | 103690 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434 | -122.440180480455 | (37.804514981434, -122.440180480455) | 13 | 9 | 1 | 57 | 17 | ||
| 44158 | 103746 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1825 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2014 06:54:00 AM | 3 | 3x3 | 6008064.3 | 2107819.3 | 37.7681256571965 | -122.41539363615 | (37.7681256571965, -122.41539363615) | 8 | 4 | 7 | 28853 | 19 | ||
| 80627 | 103879 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 730 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2013 12:00:00 AM | 3 | 3x5 | Permit Number 770337 | 6006959.90652 | 2113301.63031 | 37.7831166871277 | -122.419602643968 | (37.7831166871277, -122.419602643968) | 7 | 9 | 9 | 28858 | 36 | |
| 32708 | 103952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 02:41:00 PM | 3 | 3x3 | 6010292.1 | 2112133.4 | 37.7800961360688 | -122.407992142491 | (37.7800961360688, -122.407992142491) | 14 | 2 | 9 | 28853 | 34 | ||
| 37556 | 1040 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2003X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6000664.66612 | 2090352.04738 | 37.7197460535115 | -122.439735693745 | (37.7197460535115, -122.439735693745) | 9 | 7 | 6 | 28861 | 25 | |||
| 148507 | 104016 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 223 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | 6x9 | Permit Number 770321 | 5997091.81503 | 2115451.91709 | 37.7884600072758 | -122.453897386378 | (37.7884600072758, -122.453897386378) | 11 | 6 | 1 | 54 | 31 | |
| 33174 | 104017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 223 Spruce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | 6x9 | Permit Number 770321 | 5997094.16493 | 2115432.10459 | 37.7884057421722 | -122.453887824776 | (37.7884057421722, -122.453887824776) | 11 | 6 | 1 | 54 | 31 | |
| 120816 | 104018 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 223 Spruce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | 6x9 | Permit Number 770321 | 5997096.64572 | 2115406.53557 | 37.7883356787049 | -122.453877394453 | (37.7883356787049, -122.453877394453) | 11 | 6 | 1 | 54 | 31 | |
| 74447 | 104019 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3700X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 6x9 | Permit Number 770321 | 5996887.9623 | 2115333.50627 | 37.7881231929119 | -122.454594123111 | (37.7881231929119, -122.454594123111) | 11 | 6 | 1 | 54 | 31 | ||
| 25042 | 104020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3700X Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 1 | 6x9 | Permit Number 770321 | 5997075.95217 | 2115381.62732 | 37.7882661008363 | -122.453947190815 | (37.7882661008363, -122.453947190815) | 11 | 6 | 1 | 54 | 31 | |
| 10204 | 104021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3700X Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 1 | 6x9 | Permit Number 770321 | 5997065.89783 | 2115379.84227 | 37.7882606230845 | -122.453981848003 | (37.7882606230845, -122.453981848003) | 11 | 6 | 1 | 54 | 31 | |
| 2937 | 104069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1340 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 3x3 | Permit Number 770297 | 6007143.4 | 2107674.1 | 37.7676751698972 | -122.418568643249 | (37.7676751698972, -122.418568643249) | 8 | 4 | 7 | 28853 | 19 | ||
| 169240 | 10437 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1472 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999082.1034 | 2108734.1403 | 37.7701286382207 | -122.446527827035 | (37.7701286382207, -122.446527827035) | 15 | 5 | 11 | 29492 | 9 | |||
| 72501 | 104464 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3260X 16TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 12:00:00 AM | 3 | 3x3 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | ||
| 71713 | 104465 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3260X 16TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | |||
| 145076 | 10449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1530 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2011 12:00:00 AM | 20 | 3x3 | Permit Number 768237 | 5998780.3696 | 2108692.1816 | 37.7699961910817 | -122.447568495974 | (37.7699961910817, -122.447568495974) | 15 | 5 | 11 | 29492 | 9 | |
| 74406 | 104517 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 166465 | 104518 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 74353 | 104519 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 13565 | 104520 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 74292 | 10453 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1530 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768237 | 5998812 | 2108694 | 37.7700029915433 | -122.447459218305 | (37.7700029915433, -122.447459218305) | 15 | 5 | 11 | 29492 | 9 | |
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 150521 | 104707 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 1 | 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 | |||
| 98000 | 104708 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 2 | 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 | |||
| 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 | |||
| 119849 | 104710 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 4 | 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 | |||
| 157058 | 104711 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 5 | 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 | |||
| 50606 | 104785 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 750 Holly Park Cir | 1 | Median : Cutout | Tree | DPW 1 | 12/21/2014 11:00:00 PM | 3 | 2x2 | 6006276.67386 | 2096799.83163 | 37.7377680961975 | -122.420794450652 | (37.7377680961975, -122.420794450652) | 2 | 7 | 7 | 28859 | 2 | ||
| 40075 | 104834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1202X Arguello Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/27/2014 12:00:00 AM | 1 | 1x4 | 5995869.9 | 2107172.9 | 37.7656578771265 | -122.457525759586 | (37.7656578771265, -122.457525759586) | 15 | 5 | 11 | 29492 | 12 | ||
| 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 | |||||
| 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 | ||
| 132131 | 105279 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 568-570 Noe St | 2 | 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 | ||
| 82450 | 105355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202X Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002020.25197 | 2093863.82758 | 37.729465676201 | -122.435300985665 | (37.729465676201, -122.435300985665) | 9 | 7 | 6 | 28861 | 25 | |||
| 75148 | 105367 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 BROAD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5994550.4 | 2088030.5 | 37.71302171758 | -122.460702242455 | (37.71302171758, -122.460702242455) | 9 | 8 | 6 | 28861 | 24 | |||
| 184770 | 105526 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 228 Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5998177.9524 | 2112999.2356 | 37.781787802518 | -122.449962699898 | (37.781787802518, -122.449962699898) | 15 | 6 | 2 | 54 | 16 | |||
| 46774 | 105833 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 385 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775232 | 5989019.18729 | 2112712.58155 | 37.7804724166057 | -122.481626370529 | (37.7804724166057, -122.481626370529) | 11 | 6 | 2 | 55 | 26 | |
| 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 | ||||
| 168196 | 105903 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011210.98839 | 2087529.97721 | 37.7125918747006 | -122.403082196009 | (37.7125918747006, -122.403082196009) | 9 | 7 | 8 | 309 | 39 | |
| 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 | ||
| 99719 | 106081 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 398X KIRKHAM ST | 1 | Median : Cutout | Tree | DPW 1 | 3 | 4x12 | 5993829 | 2105294 | 37.7603814652304 | -122.46444829698 | (37.7603814652304, -122.46444829698) | 1 | 8 | 11 | 56 | 12 | |||
| 144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||||
| 54128 | 106175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 2 | 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 | ||||
| 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 | ||||
| 78476 | 106177 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 4 | 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 | ||||
| 100973 | 106178 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 5 | 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 | ||||
| 66155 | 106179 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 6 | 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 | ||||
| 116057 | 106180 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 7 | 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 | ||||
| 99088 | 106181 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 8 | 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 | ||||
| 170498 | 106300 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 28th St | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | 2 | 7 | 5 | 63 | 22 | |||||
| 59222 | 106322 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1040 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6012164.19951 | 2103531.96134 | 37.7565831613987 | -122.400911161547 | (37.7565831613987, -122.400911161547) | 10 | 3 | 8 | 28856 | 29 | |
| 88945 | 106333 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 319 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997602.34127 | 2115286.79464 | 37.7880358825085 | -122.452119136194 | (37.7880358825085, -122.452119136194) | 11 | 6 | 1 | 54 | 31 | |||
| 190106 | 106334 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010616.31462 | 2110545.36774 | 37.7757539168402 | -122.406758583146 | (37.7757539168402, -122.406758583146) | 8 | 2 | 9 | 28853 | 34 | |||
| 76126 | 106373 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 189 College Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/23/2014 12:00:00 AM | 3X3 | Permit Number 771157 | 6004972.1 | 2095958.7 | 37.7353849208155 | -122.425245160296 | (37.7353849208155, -122.425245160296) | 2 | 7 | 5 | 28861 | 2 | |||
| 69296 | 1064 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 12 | 3X3 | 6000384.95261 | 2090073.81885 | 37.7189661758191 | -122.440682615124 | (37.7189661758191, -122.440682615124) | 9 | 7 | 6 | 28861 | 25 | ||
| 172824 | 10648 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 913 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 6 | 3X3 | 6003489.82671 | 2110685.15143 | 37.7757364121632 | -122.43142086376 | (37.7757364121632, -122.43142086376) | 15 | 9 | 11 | 29492 | 10 | ||
| 200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
| 54884 | 106679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2200 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2014 12:00:00 AM | 10 | 3x3 | Permit Number 773028 | 5999374.78932 | 2116379.94206 | 37.7911387486163 | -122.446065460477 | (37.7911387486163, -122.446065460477) | 13 | 6 | 1 | 29490 | 27 | |
| 55954 | 106687 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 651100 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2014 12:00:00 AM | 1 | 3X3 | Permit Number 771888 | 6012593.54903 | 2110426.38639 | 37.7755376523668 | -122.399910431946 | (37.7755376523668, -122.399910431946) | 14 | 2 | 9 | 28856 | 20 | |
| 93995 | 106688 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 651100 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2014 12:00:00 AM | 1 | 3X3 | Permit Number 771888 | 6012616.50612 | 2110446.22024 | 37.7755933914437 | -122.399832410353 | (37.7755933914437, -122.399832410353) | 14 | 2 | 9 | 28856 | 20 | |
| 80528 | 106723 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2891 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4x3 | 5999685.7618 | 2114314.7923 | 37.7854861405611 | -122.444840997242 | (37.7854861405611, -122.444840997242) | 15 | 6 | 1 | 29490 | 31 | |||
| 139823 | 106726 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2803 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2015 12:00:00 AM | 15 | 4x4 | Permit Number 776229 | 6000064.2 | 2114352.6 | 37.785611540482 | -122.443534433928 | (37.785611540482, -122.443534433928) | 15 | 6 | 1 | 29490 | 31 | |
| 177883 | 106727 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2803 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000064 | 2114352 | 37.7856098816315 | -122.443535082752 | (37.7856098816315, -122.443535082752) | 15 | 6 | 1 | 29490 | 31 | |||
| 192424 | 106899 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 63 BROSNAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x3 | 6005693 | 2108028.3 | 37.7685659568303 | -122.423610587475 | (37.7685659568303, -122.423610587475) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | ||
| 99038 | 107265 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 1 | 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 | ||||
| 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 | ||||
| 62256 | 107267 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 3 | 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 | ||||
| 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 | ||||
| 118514 | 107269 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 5 | 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 |
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) );