Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51442 | 51442 | 89489 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4300 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985343.483835 | 2111809.619888 | 37.7777787222019 | -122.494275598426 | (37.7777787222019, -122.494275598426) | |
| 102624 | 102624 | 89590 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4631 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984326.052581 | 2111733.134283 | 37.7775091228792 | -122.497789541411 | (37.7775091228792, -122.497789541411) | |
| 104936 | 104936 | 89515 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4726 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984027.6428 | 2111762.466354 | 37.7775721622219 | -122.498823991577 | (37.7775721622219, -122.498823991577) | |
| 119261 | 119261 | 90929 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4425 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984963.926317 | 2111755.997226 | 37.7776092710215 | -122.49558464338101 | (37.7776092710215, -122.495584643381) | |
| 390 | 390 | 251276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/09/1998 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 391 | 391 | 251275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/16/2011 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 679 | 679 | 187631 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | |
| 102543 | 102543 | 21639 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1641 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/14/2010 12:00:00 AM | 18 | 4X4 | Permit Number 53778 | 6004750.8195846 | 2114677.2774985 | 37.7867691895303 | -122.42734321826401 | (37.7867691895303, -122.427343218264) |
| 114637 | 114637 | 106120 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 6x9 | 5992954.7 | 2110649.6 | 37.775036084258794 | -122.46786160539301 | (37.7750360842588, -122.467861605393) | |||
| 116277 | 116277 | 102879 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.732453033840706 | -122.39102294843501 | (37.7324530338407, -122.391022948435) |
| 181574 | 181574 | 102134 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 769373 | 6015285.47231 | 2114577.79035 | 37.787086180420296 | -122.390888542866 | (37.7870861804203, -122.390888542866) |
| 1697 | 1697 | 42640 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.42583071712299 | (37.7982497015198, -122.425830717123) |
| 6518 | 6518 | 97735 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.978999999 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) |
| 77166 | 77166 | 77218 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 80671 | 80671 | 102030 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 92210 | 92210 | 102025 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 94066 | 94066 | 77325 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/18/1988 12:00:00 AM | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | |
| 99976 | 99976 | 102032 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 103838 | 103838 | 102029 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 104096 | 104096 | 112062 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/18/2015 12:00:00 AM | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | ||
| 105164 | 105164 | 102027 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 111333 | 111333 | 102034 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 118157 | 118157 | 102031 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 120376 | 120376 | 112063 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 123118 | 123118 | 112058 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 125030 | 125030 | 102033 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 126295 | 126295 | 102028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 127011 | 127011 | 102024 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 128300 | 128300 | 102022 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 140135 | 140135 | 112060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 140326 | 140326 | 102026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 141095 | 141095 | 112061 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 142587 | 142587 | 102023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 1582 | 1582 | 45051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43936 | 5988218.295 | 2100043.5647 | 37.7456401553342 | -122.483467967859 | (37.7456401553342, -122.483467967859) | |
| 3986 | 3986 | 65721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 275 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 04:32:00 PM | 3 | Permit Number 28655 | 6000475.14424 | 2087458.3820900002 | 37.711789909637794 | -122.44018340596399 | (37.7117899096378, -122.440183405964) | |
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 5473 | 5473 | 52359 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007837.48852 | 2114654.59381 | 37.786880990198 | -122.41666243464199 | (37.786880990198, -122.416662434642) |
| 5644 | 5644 | 81955 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 611 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769820 | 6007855.44707 | 2114525.76185 | 37.7865282590267 | -122.416591172348 | (37.7865282590267, -122.416591172348) |
| 6899 | 6899 | 52360 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007841.58942 | 2114643.58565 | 37.78685099511571 | -122.416647466318 | (37.7868509951157, -122.416647466318) |
| 7190 | 7190 | 59699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3188 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773904 | 5999466.917230001 | 2116043.86882 | 37.7902212404654 | -122.44572252287901 | (37.7902212404654, -122.445722522879) | |
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7391 | 7391 | 58164 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 8 | Permit Number 31200 | 6005960.50321 | 2119339.77329 | 37.7996395731743 | -122.423489589398 | (37.7996395731743, -122.423489589398) | |
| 7906 | 7906 | 42669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1374 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | 3x5 | Permit Number 46576 | 6007041.18345 | 2118110.17737 | 37.7963243483505 | -122.419662744764 | (37.7963243483505, -122.419662744764) |
| 8770 | 8770 | 48424 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/03/2014 12:00:00 AM | 3 | Permit Number 772479 | 6001994.11068 | 2118598.66634 | 37.7973800166165 | -122.437161635315 | (37.7973800166165, -122.437161635315) | |
| 8830 | 8830 | 71801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2170 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | 5997504.5785 | 2109900.8998 | 37.77324202696929 | -122.452068634732 | (37.7732420269693, -122.452068634732) | ||
| 9547 | 9547 | 68821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.44420161479799 | (37.7299216843992, -122.444201614798) | ||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 10635 | 10635 | 37208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1890 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | 3X3 | Permit Number 39774 | 5986318.0892 | 2102397.4434 | 37.751992489797004 | -122.49021162161101 | (37.751992489797, -122.490211621611) |
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 10923 | 10923 | 108952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2912 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769302 | 5990002.93775 | 2095864.20098 | 37.7342684111434 | -122.47699167433399 | (37.7342684111434, -122.476991674334) |
| 11913 | 11913 | 108546 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.8770599999 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) |
| 12346 | 12346 | 46852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 773811 | 6003293.98042 | 2090989.1519900002 | 37.7216447112248 | -122.43069253035101 | (37.7216447112248, -122.430692530351) | |
| 12441 | 12441 | 109572 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003097.99881 | 2091486.06514 | 37.72299801913329 | -122.431405440927 | (37.7229980191333, -122.431405440927) |
| 12665 | 12665 | 109570 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003082.6952599995 | 2091494.46608 | 37.7230202188994 | -122.431458941588 | (37.7230202188994, -122.431458941588) |
| 12843 | 12843 | 109569 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003067.9512 | 2091505.3817099999 | 37.7230493551309 | -122.431510687674 | (37.7230493551309, -122.431510687674) |
| 15555 | 15555 | 59677 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1700 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 10 | 3x3 | Permit Number 19103 | 6014064.15131 | 2093105.02491 | 37.728058768695995 | -122.393610646816 | (37.728058768696, -122.393610646816) |
| 16315 | 16315 | 51391 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 4 | 3x3 | Permit Number 47719 | 6007725.4963 | 2109499.14955 | 37.7727190799574 | -122.41668454444901 | (37.7727190799574, -122.416684544449) |
| 16667 | 16667 | 67335 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 673 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 6x4 | Permit Number 773101 | 6011565.01957 | 2105259.70071 | 37.7612937095442 | -122.403104877802 | (37.7612937095442, -122.403104877802) |
| 17668 | 17668 | 31387 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1314 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 12 | 3x3 | Permit Number 34980 | 5991923.9598 | 2098448.87942 | 37.741476540316796 | -122.470538331775 | (37.7414765403168, -122.470538331775) |
| 18370 | 18370 | 38265 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 711 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | 6 | 3x3 | Permit Number 40366 | 6015782.17100529 | 2103924.24418542 | 37.7578614341223 | -122.38842618690599 | (37.7578614341223, -122.388426186906) |
| 18382 | 18382 | 36313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | ||
| 19027 | 19027 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 19128 | 19128 | 95689 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | |
| 19354 | 19354 | 95439 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | |
| 19423 | 19423 | 32825 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246005 | -122.440510188354 | (37.752585873246, -122.440510188354) | ||
| 23667 | 23667 | 71626 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | ||
| 23757 | 23757 | 92367 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1938 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52780 | 5986020.4821 | 2102025.9665 | 37.7509551305239 | -122.491213439138 | (37.7509551305239, -122.491213439138) |
| 23803 | 23803 | 66974 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 290 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | 9 | Permit Number 30317 | 5996737.0249 | 2110855.143 | 37.7758181337994 | -122.45479264802 | (37.7758181337994, -122.45479264802) | |
| 23917 | 23917 | 83757 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1838 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767115 | 5984137.1702 | 2102639.4673 | 37.7525294126592 | -122.497771308698 | (37.7525294126592, -122.497771308698) |
| 23954 | 23954 | 30920 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 242 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34736 | 5995667.1416 | 2091560.8953099998 | 37.7227795387217 | -122.457097650843 | (37.7227795387217, -122.457097650843) | |
| 24098 | 24098 | 92296 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1387 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52741 | 5989259.6068 | 2105918.0206 | 37.761830398003795 | -122.480297199633 | (37.7618303980038, -122.480297199633) |
| 24532 | 24532 | 46400 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767122 | 5981730.59814192 | 2098955.65959072 | 37.7422733344517 | -122.50582042193301 | (37.7422733344517, -122.505820421933) |
| 24897 | 24897 | 45532 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 91 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 7 | Permit Number 44291 | 5988299.5289199995 | 2095312.45705 | 37.732654498611005 | -122.482840411668 | (37.732654498611, -122.482840411668) | |
| 25197 | 25197 | 42152 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 622 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42447 | 5989745.16846 | 2111083.69562 | 37.7760421357171 | -122.47899570903401 | (37.7760421357171, -122.478995709034) | |
| 25342 | 25342 | 94702 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 646 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53842 | 5992259.75626 | 2111021.3028599997 | 37.77601652603929 | -122.470292619455 | (37.7760165260393, -122.470292619455) |
| 25492 | 25492 | 62153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.804429482897795 | -122.44591327448 | (37.8044294828978, -122.44591327448) | |
| 26338 | 26338 | 71539 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011318.23655 | 2111544.7017900003 | 37.7785371054488 | -122.40440080264999 | (37.7785371054488, -122.40440080265) | ||
| 26466 | 26466 | 66583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 170 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 8 | Permit Number 29773 | 6004274.60458 | 2092554.4003299999 | 37.725998045968794 | -122.427414222707 | (37.7259980459688, -122.427414222707) | |
| 26757 | 26757 | 92423 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52816 | 5983956.38 | 2106631.2052 | 37.7634790074381 | -122.49869135601999 | (37.7634790074381, -122.49869135602) |
| 26855 | 26855 | 73378 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983190.4387300005 | 2110910.57285 | 37.775183970412996 | -122.501657073915 | (37.775183970413, -122.501657073915) | ||
| 27252 | 27252 | 49933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2619@ VICENTE 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | Permit Number 46693 | 5988614.8781 | 2097469.9952 | 37.7385968825528 | -122.48190817353998 | (37.7385968825528, -122.48190817354) | |
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 27424 | 27424 | 67404 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 614 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 8 | Permit Number 30903 | 5989745.14733 | 2111135.1502799997 | 37.776183414760794 | -122.47899954663 | (37.7761834147608, -122.47899954663) | |
| 27613 | 27613 | 36198 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1485 Armstrong Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | 4 | Permit Number 39261 | 6015078.9992 | 2091914.2806 | 37.7248455613423 | -122.39001910919599 | (37.7248455613423, -122.390019109196) | |
| 27864 | 27864 | 45493 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3017 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44269 | 5989985.33852 | 2095139.4383599998 | 37.7322773768865 | -122.476999578465 | (37.7322773768865, -122.476999578465) | |
| 27882 | 27882 | 67648 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1946 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 6 | Permit Number 31247 | 6013417.63825 | 2096018.4477 | 37.7360224839351 | -122.396049764692 | (37.7360224839351, -122.396049764692) | |
| 27917 | 27917 | 31593 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 4 | Permit Number 35122 | 5990086.846 | 2102416.3668 | 37.7522638247523 | -122.477180236453 | (37.7522638247523, -122.477180236453) | |
| 28065 | 28065 | 84526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1607 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985279.5041 | 2104240.0581 | 37.756991093889496 | -122.49393892942699 | (37.7569910938895, -122.493938929427) | |||
| 28110 | 28110 | 33156 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2462 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2006 12:00:00 AM | 4 | Permit Number 48987 | 5986142.1502 | 2098483.4784 | 37.7412355210533 | -122.490532108902 | (37.7412355210533, -122.490532108902) | |
| 28284 | 28284 | 84384 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | ||
| 28349 | 28349 | 52940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48927 | 6001124.83549 | 2092944.78759 | 37.7268913119605 | -122.43833070542 | (37.7268913119605, -122.43833070542) | |
| 28391 | 28391 | 67649 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1939 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 9 | Permit Number 31248 | 6013431.94199 | 2095958.6193099997 | 37.7358590033865 | -122.395996119237 | (37.7358590033865, -122.395996119237) | |
| 28442 | 28442 | 31875 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2201 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38286 | 5999315.13927 | 2116465.82732 | 37.7913711603999 | -122.446278027822 | (37.7913711603999, -122.446278027822) | |
| 28448 | 28448 | 37169 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.746236446392295 | -122.423472053683 | (37.7462364463923, -122.423472053683) | ||
| 28817 | 28817 | 62170 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 77 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 10 | Permit Number 22286 | 6000043.62237 | 2092067.5306099998 | 37.724421009198295 | -122.442005483689 | (37.7244210091983, -122.442005483689) | |
| 29211 | 29211 | 31416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4036 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 6 | Permit Number 35003 | 6001929.8185 | 2103551.20105 | 37.7560597982317 | -122.436306643531 | (37.7560597982317, -122.436306643531) | |
| 29412 | 29412 | 52502 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 143 Del Monte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48611 | 5999302.61821 | 2088650.1848099998 | 37.714995505320296 | -122.444321557211 | (37.7149955053203, -122.444321557211) | |
| 30014 | 30014 | 65731 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 244 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 9 | Permit Number 28665 | 6000099.76339 | 2087506.9392900001 | 37.711901858158704 | -122.44148430406 | (37.7119018581587, -122.44148430406) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");