trees
7,322 rows where qSpecies_id = 1 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74851 | 95717 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Avalon Ave | 2 | 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 | |
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 | |
64860 | 95713 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 649 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767469 | 6004389.1114 | 2092283.11873 | 37.7252596422974 | -122.42699906688 | (37.7252596422974, -122.42699906688) | 9 | 7 | 6 | 28861 | 5 |
9772 | 95689 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | 1 | 8 | 3 | 29491 | 35 | |
168944 | 95645 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3 | 3c3 | Permit Number 767416 | 5984764.15602 | 2110237.73854 | 37.7734288681466 | -122.49616366215 | (37.7734288681466, -122.49616366215) | 11 | 6 | 2 | 55 | 26 |
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 | |
168215 | 95595 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
126500 | 95594 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
58067 | 95593 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
139895 | 95586 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767376 | 6006909.4 | 2099383.2 | 37.7448970917972 | -122.418789965072 | (37.7448970917972, -122.418789965072) | 2 | 7 | 7 | 28859 | 2 | |
162568 | 95558 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147#3 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767352 | 6004990 | 2098703 | 37.7429211592946 | -122.425378504341 | (37.7429211592946, -122.425378504341) | 2 | 7 | 5 | 63 | 22 | |
166901 | 95545 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 662 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767343 | 6001616.8 | 2099449.8 | 37.7447805391145 | -122.437095531197 | (37.7447805391145, -122.437095531197) | 2 | 7 | 5 | 63 | 22 | |
180400 | 95544 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 660 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767331 | 6001639 | 2099430 | 37.7447274348519 | -122.437017350685 | (37.7447274348519, -122.437017350685) | 2 | 7 | 5 | 63 | 22 | |
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 | |
193565 | 95523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2944 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 23x3 | Permit Number 767315 | 5985332.6897 | 2105713.6699 | 37.7610403347331 | -122.493863589694 | (37.7610403347331, -122.493863589694) | 1 | 8 | 3 | 56 | 35 |
180219 | 95522 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1440 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767314 | 5990004.0532 | 2105874.3755 | 37.7617537915054 | -122.47771929258 | (37.7617537915054, -122.47771929258) | 1 | 8 | 3 | 56 | 35 |
98349 | 95520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1214 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767312 | 5985232.1017 | 2106922.0105 | 37.7643522146303 | -122.49430054434 | (37.7643522146303, -122.49430054434) | 1 | 8 | 3 | 56 | 35 |
85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
145506 | 95508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.44854 | 2112162.31032 | 37.7787845389083 | -122.492087745218 | (37.7787845389083, -122.492087745218) | 11 | 6 | 2 | 55 | 26 | |||
123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
152325 | 95504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.22924 | 37.7790780474023 | -122.492099187045 | (37.7790780474023, -122.492099187045) | 11 | 6 | 2 | 55 | 26 | |||
194074 | 95493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.17376 | 2111397.5149 | 37.7766863664514 | -122.491928594282 | (37.7766863664514, -122.491928594282) | 11 | 6 | 2 | 55 | 26 | |||
62037 | 95492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.63252 | 2111419.06509 | 37.7767455639501 | -122.491928594276 | (37.7767455639501, -122.491928594276) | 11 | 6 | 2 | 55 | 26 | |||
148543 | 95440 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1875 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767302 | 5986272.1126 | 2102492.7844 | 37.7522515850844 | -122.490377626303 | (37.7522515850844, -122.490377626303) | 1 | 8 | 3 | 56 | 35 |
9127 | 95439 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | 1 | 8 | 3 | 56 | 35 | |
56962 | 95428 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767293 | 5989315.6 | 2103729.9 | 37.7558256605685 | -122.479943411619 | (37.7558256605685, -122.479943411619) | 1 | 8 | 3 | 56 | 35 | |
184516 | 95427 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767293 | 5989315.6 | 2103729.9 | 37.7558256605685 | -122.479943411619 | (37.7558256605685, -122.479943411619) | 1 | 8 | 3 | 56 | 35 | |
149398 | 95426 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767293 | 5989315.6 | 2103729.9 | 37.7558256605685 | -122.479943411619 | (37.7558256605685, -122.479943411619) | 1 | 8 | 3 | 56 | 35 | |
71946 | 95424 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
5291 | 95249 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
70028 | 95248 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483@ Anza 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
39961 | 952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x6 | 6002047.34922 | 2093382.65925 | 37.7281460362049 | -122.435172906015 | (37.7281460362049, -122.435172906015) | 9 | 7 | 6 | 28861 | 25 | |||
30337 | 95112 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54040 | 6001677.19032 | 2093316.95797 | 37.7279446087442 | -122.436447856 | (37.7279446087442, -122.436447856) | 9 | 7 | 6 | 28861 | 25 |
113651 | 95107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 140 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54036 | 6003089.39769 | 2094398.8785 | 37.7309954634676 | -122.431643031908 | (37.7309954634676, -122.431643031908) | 9 | 7 | 5 | 28861 | 25 |
147697 | 95031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010911.6433 | 2087052.7919 | 37.7112648985932 | -122.404083270279 | (37.7112648985932, -122.404083270279) | 9 | 7 | 8 | 309 | 39 | ||||
66456 | 95030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010891.1447 | 2087063.4869 | 37.7112931195577 | -122.404154871184 | (37.7112931195577, -122.404154871184) | 9 | 7 | 8 | 309 | 39 | ||||
100201 | 95022 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010735.1769 | 2087146.3726 | 37.7115119909256 | -122.404699769405 | (37.7115119909256, -122.404699769405) | 9 | 7 | 8 | 309 | 39 | ||||
113294 | 95021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 51 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010652.9596 | 2087185.8102 | 37.711615683002 | -122.404986710459 | (37.711615683002, -122.404986710459) | 9 | 7 | 8 | 309 | 39 | ||||
168940 | 95009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010165.2261 | 2087437.3639 | 37.712279121941 | -122.406690172249 | (37.712279121941, -122.406690172249) | 9 | 7 | 8 | 309 | 39 | ||||
158455 | 95000 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 9x15 | 6010171.1456 | 2087482.6157 | 37.712403705394 | -122.40667289957 | (37.712403705394, -122.40667289957) | 9 | 7 | 8 | 309 | 39 | |||
19159 | 94999 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010257.4842 | 2087438.4037 | 37.7122871384537 | -122.406371372412 | (37.7122871384537, -122.406371372412) | 9 | 7 | 8 | 309 | 39 | |||
173731 | 94998 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6010267.0774 | 2087433.8156 | 37.712275077109 | -122.406337892214 | (37.712275077109, -122.406337892214) | 9 | 7 | 8 | 309 | 39 | |||
139817 | 94989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 44 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010751.8878 | 2087184.0277 | 37.7116163182342 | -122.404644660956 | (37.7116163182342, -122.404644660956) | 9 | 7 | 8 | 309 | 39 | ||||
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 | ||
55837 | 94871 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.388400481487 | (37.7393228299093, -122.388400481487) | 10 | 3 | 8 | 58 | 1 | ||
179571 | 94789 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 54 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/2010 12:00:00 AM | 3x3 | Permit Number 53887 | 6002570 | 2096102 | 37.7356423917642 | -122.433560343926 | (37.7356423917642, -122.433560343926) | 2 | 7 | 5 | 63 | 7 | |
145713 | 94743 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 619 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2010 12:00:00 AM | 3x3 | Permit Number 53878 | 6006057.7 | 2099749 | 37.7458535038836 | -122.421760968395 | (37.7458535038836, -122.421760968395) | 2 | 7 | 5 | 28859 | 2 | ||
193785 | 94733 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 73 Wood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53864 | 5998395.9807 | 2113346.8794 | 37.7827548145961 | -122.449233480921 | (37.7827548145961, -122.449233480921) | 15 | 6 | 1 | 54 | 31 |
43261 | 94721 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53856 | 5997800.8659 | 2113535.8879 | 37.7832397250428 | -122.451305952337 | (37.7832397250428, -122.451305952337) | 15 | 6 | 1 | 54 | 31 |
140214 | 94702 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 646 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53842 | 5992259.75626 | 2111021.30286 | 37.7760165260393 | -122.470292619455 | (37.7760165260393, -122.470292619455) | 11 | 6 | 2 | 54 | 11 |
62612 | 94603 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 524 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | 6005514 | 2105912 | 37.7627449949017 | -122.424079213818 | (37.7627449949017, -122.424079213818) | 8 | 4 | 5 | 28859 | 19 | ||
112028 | 94597 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2555 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010710.5 | 2086281.9 | 37.7091369436285 | -122.404724239792 | (37.7091369436285, -122.404724239792) | 10 | 3 | 8 | 309 | 1 | ||||
139331 | 94594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2446 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6010864.44098 | 2086844.85353 | 37.710691304128 | -122.404231788559 | (37.710691304128, -122.404231788559) | 9 | 7 | 8 | 309 | 39 | |||
49099 | 94593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2442 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6010872.81854 | 2086861.10948 | 37.7107364078213 | -122.404203977038 | (37.7107364078213, -122.404203977038) | 9 | 7 | 8 | 309 | 39 | |||
179441 | 94563 | Section 143 10 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Oak St | 3 | Sidewalk: Curb side : | Tree | Private 2 | 09/15/2010 12:00:00 AM | Permit Number 53745 | 6005493 | 2110231 | 37.7746027492624 | -122.424459067949 | (37.7746027492624, -122.424459067949) | 7 | 9 | 11 | 28852 | 10 | |||
131268 | 94546 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5998905 | 2107457 | 37.7666118166914 | -122.447048501471 | (37.7666118166914, -122.447048501471) | 15 | 5 | 11 | 29492 | 9 | |||
145485 | 94545 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5998905 | 2107457 | 37.7666118166914 | -122.447048501471 | (37.7666118166914, -122.447048501471) | 15 | 5 | 11 | 29492 | 9 | |||
46636 | 94470 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997654.5 | 2094143 | 37.7299833218121 | -122.450413859523 | (37.7299833218121, -122.450413859523) | 9 | 7 | 4 | 28861 | 40 | ||||
122972 | 94461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1476 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53679 | 6007084.41158 | 2117757.47134 | 37.7953583406805 | -122.419488130584 | (37.7953583406805, -122.419488130584) | 5 | 1 | 10 | 28858 | 32 | |
25997 | 94227 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53569 | 6014444.75955 | 2111890.9514 | 37.7796620503017 | -122.393609125164 | (37.7796620503017, -122.393609125164) | 6 | 2 | 9 | 28856 | 6 | |
189566 | 94177 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 763 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53591 | 6011590.4038 | 2104788.03706 | 37.7600000437731 | -122.402983908204 | (37.7600000437731, -122.402983908204) | 10 | 3 | 8 | 28856 | 29 | |
82354 | 94156 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2174 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53539 | 5990747.7 | 2100602.7 | 37.7473222890042 | -122.474762558157 | (37.7473222890042, -122.474762558157) | 1 | 8 | 4 | 29491 | 40 | |
103547 | 94130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Massasoit St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53496 | 6010073 | 2099348 | 37.7449780589808 | -122.407848289369 | (37.7449780589808, -122.407848289369) | 2 | 7 | 7 | 28859 | 2 | |||
123592 | 93488 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1606 Guerrero St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53237 | 6005836 | 2099575 | 37.745363234828 | -122.422515215131 | (37.745363234828, -122.422515215131) | 2 | 7 | 5 | 28859 | 22 | |||
189683 | 93480 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.46712 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | 5 | 1 | 10 | 28858 | 21 | |
10594 | 93463 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 01:05:00 PM | 3 | 3x3 | 5987772.1588 | 2098929.0107 | 37.7425539090053 | -122.484928867121 | (37.7425539090053, -122.484928867121) | 1 | 8 | 3 | 29491 | 35 | ||
103252 | 93401 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999912.1103 | 2111918.5701 | 37.7789196472896 | -122.443885677827 | (37.7789196472896, -122.443885677827) | 15 | 5 | 11 | 29490 | 16 | ||
9032 | 93400 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999886.3903 | 2111916.5396 | 37.7789126049307 | -122.443974507336 | (37.7789126049307, -122.443974507336) | 15 | 5 | 11 | 29490 | 16 | ||
92453 | 93399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999866.7618 | 2111912.817 | 37.7789012639267 | -122.44404214236 | (37.7789012639267, -122.44404214236) | 15 | 5 | 11 | 29490 | 16 | ||
160017 | 93398 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2299 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999064.1945 | 2111800.6301 | 37.7785474120766 | -122.446810456436 | (37.7785474120766, -122.446810456436) | 15 | 5 | 11 | 54 | 16 | ||
141301 | 9324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 121X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2013 12:00:00 AM | 2 | 2x2 | 6001251.6599184 | 2098662.874612 | 37.7425990657228 | -122.438301748303 | (37.7425990657228, -122.438301748303) | 2 | 7 | 5 | 63 | 7 | ||
114878 | 93233 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 306 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:18:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | 8 | 4 | 5 | 28862 | 3 | ||
68462 | 93192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2750 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53198 | 5985395.3318 | 2103003.1574 | 37.7536016817207 | -122.493447228537 | (37.7536016817207, -122.493447228537) | 1 | 8 | 3 | 56 | 35 | |
173857 | 93165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 431 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53186 | 5987768.5184 | 2113065.56921 | 37.7813688172441 | -122.485978885969 | (37.7813688172441, -122.485978885969) | 11 | 6 | 2 | 55 | 26 | |
46605 | 93026 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3865 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2010 12:00:00 AM | 3x3 | Permit Number 53142 | 6002696 | 2102965 | 37.7544937337812 | -122.433615041679 | (37.7544937337812, -122.433615041679) | 2 | 4 | 5 | 28862 | 22 | ||
49770 | 92869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2009 12:00:00 AM | 3x3 | Permit Number 53086 | 6005474 | 2108327 | 37.7693737513235 | -122.424389339236 | (37.7693737513235, -122.424389339236) | 8 | 4 | 5 | 28853 | 19 | ||
112338 | 928 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1285 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 10 | 3X4 | 6002746.05074 | 2094024.26586 | 37.7299473944576 | -122.432803287742 | (37.7299473944576, -122.432803287742) | 9 | 7 | 6 | 28861 | 25 | ||
41572 | 92781 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52997 | 6006262 | 2110430 | 37.775192551515 | -122.421813078941 | (37.775192551515, -122.421813078941) | 7 | 9 | 11 | 28852 | 10 | |
148671 | 92780 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52997 | 6006262 | 2110430 | 37.775192551515 | -122.421813078941 | (37.775192551515, -122.421813078941) | 7 | 9 | 11 | 28852 | 10 | |
139255 | 92779 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52997 | 6006262 | 2110430 | 37.775192551515 | -122.421813078941 | (37.775192551515, -122.421813078941) | 7 | 9 | 11 | 28852 | 10 | ||
89845 | 92771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11X Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52987 | 6011718.00391 | 2087394.03862 | 37.7122469154382 | -122.401320234359 | (37.7122469154382, -122.401320234359) | 10 | 3 | 8 | 309 | 1 | |
94607 | 92770 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11X Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52987 | 6011727.52736 | 2087378.40257 | 37.7122045133022 | -122.401286220195 | (37.7122045133022, -122.401286220195) | 10 | 3 | 8 | 309 | 1 | |
60031 | 92769 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52987 | 6011741.63714 | 2087368.31596 | 37.7121776046838 | -122.401236743995 | (37.7121776046838, -122.401236743995) | 10 | 3 | 8 | 309 | 1 | |
56918 | 92768 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11x Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52987 | 6011754.0548 | 2087363.01517 | 37.7121637425493 | -122.401193452412 | (37.7121637425493, -122.401193452412) | 10 | 3 | 8 | 309 | 1 | |
155763 | 92749 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52978 | 5982987.8536 | 2098677.8731 | 37.741584528853 | -122.50145274491 | (37.741584528853, -122.50145274491) | 1 | 8 | 3 | 29491 | 35 |
52570 | 92725 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 148 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52960 | 6010020.7 | 2100130.7 | 37.7471242537146 | -122.408084322885 | (37.7471242537146, -122.408084322885) | 2 | 7 | 7 | 28859 | 2 | |
71525 | 92666 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 791 San Bruno Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
137489 | 92545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1582 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52881 | 5985626.4913 | 2104469.3454 | 37.7576409495344 | -122.492755821012 | (37.7576409495344, -122.492755821012) | 1 | 8 | 3 | 56 | 35 | |
94625 | 9254 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6500X Geary Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 2X3 | 5986710.23998 | 2112596.16281 | 37.7800182322354 | -122.489605435074 | (37.7800182322354, -122.489605435074) | 11 | 6 | 2 | 55 | 26 | ||
57803 | 92532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1561 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52877 | 5985578.9968 | 2104595.7831 | 37.7579853351637 | -122.49292938719 | (37.7579853351637, -122.49292938719) | 1 | 8 | 3 | 56 | 35 | |
179911 | 9252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6500X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/1993 12:00:00 AM | 3 | 3X3 | 5986738.4494 | 2112596.65346 | 37.7800212263112 | -122.48950788341 | (37.7800212263112, -122.48950788341) | 11 | 6 | 2 | 55 | 26 | ||
147561 | 9251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6500X Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/1993 12:00:00 AM | 3 | 2X3 | 5986757.88302 | 2112599.10461 | 37.7800290909757 | -122.489440834967 | (37.7800290909757, -122.489440834967) | 11 | 6 | 2 | 55 | 26 | ||
57371 | 9250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6500X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2001 12:00:00 AM | 3 | 2X3 | 5986768.58618 | 2112597.64851 | 37.7800257177576 | -122.48940370132 | (37.7800257177576, -122.48940370132) | 11 | 6 | 2 | 55 | 26 | ||
156363 | 92471 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 914 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52853 | 5990275.6556 | 2100442.5616 | 37.7468552258234 | -122.476383140393 | (37.7468552258234, -122.476383140393) | 1 | 8 | 3 | 29491 | 35 |
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 | |
60474 | 92463 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3504 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 52850 | 5983354.8124 | 2104279.9828 | 37.7569879148604 | -122.500598085539 | (37.7569879148604, -122.500598085539) | 1 | 8 | 3 | 56 | 35 |
25238 | 92461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3445 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52849 | 5983517.9831 | 2104231.1385 | 37.7568633797032 | -122.500030178068 | (37.7568633797032, -122.500030178068) | 1 | 8 | 3 | 56 | 35 |
63137 | 92459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3445 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52849 | 5983483.9499 | 2104230.4645 | 37.7568595316753 | -122.500147825824 | (37.7568595316753, -122.500147825824) | 1 | 8 | 3 | 56 | 35 |
92043 | 92456 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2395 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52846 | 5981742.1 | 2098798.2 | 37.7418416710163 | -122.505768982243 | (37.7418416710163, -122.505768982243) | 1 | 8 | 3 | 29491 | 35 | |
186858 | 92455 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2379 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52845 | 5981718.2 | 2098908.8 | 37.7421439412615 | -122.505859816895 | (37.7421439412615, -122.505859816895) | 1 | 8 | 3 | 29491 | 35 |
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) );