Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35131 | 35131 | 88579 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 767 19th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51519 | 5990042.4275400005 | 2110151.2798 | 37.773499236106204 | -122.477899243352 | (37.7734992361062, -122.477899243352) | ||
| 47317 | 47317 | 89328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 376 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52512 | 5990923.61484 | 2112893.52496 | 37.7810797921954 | -122.475051338659 | (37.7810797921954, -122.475051338659) | ||
| 58422 | 58422 | 88590 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 879 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51534 | 5988496.55616 | 2110024.26731 | 37.7730606531011 | -122.483237261836 | (37.7730606531011, -122.483237261836) | ||
| 59589 | 59589 | 88375 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 365 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51353 | 5991523.32351 | 2112975.7244700002 | 37.7813402274639 | -122.472982663209 | (37.7813402274639, -122.472982663209) | ||
| 66686 | 66686 | 88558 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 422 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51503 | 5990315.69001 | 2112483.17966 | 37.7799178466375 | -122.47712443654801 | (37.7799178466375, -122.477124436548) | ||
| 75295 | 75295 | 88331 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 635 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51319 | 6002224.0 | 2090226.0 | 37.7194885890815 | -122.434336629443 | (37.7194885890815, -122.434336629443) | |||
| 79063 | 79063 | 89042 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231.0 | 2115470.0 | 37.789198174235295 | -122.411898830301 | (37.7891981742353, -122.411898830301) | |||
| 79846 | 79846 | 117347 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||||||
| 79919 | 79919 | 94871 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 Innes Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.38840048148701 | (37.7393228299093, -122.388400481487) | ||
| 80634 | 80634 | 89346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 82526 | 82526 | 88406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1716 Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055.0 | 2117126.0 | 37.7936228211286 | -122.41954507638901 | (37.7936228211286, -122.419545076389) | |||
| 82966 | 82966 | 88341 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823.0 | 2090807.0 | 37.721231068747294 | -122.425394157088 | (37.7212310687473, -122.425394157088) | |||
| 85883 | 85883 | 88089 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1870 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51092 | 5984476.8 | 2102440.2 | 37.752002183643704 | -122.49658212531601 | (37.7520021836437, -122.496582125316) | |||
| 85966 | 85966 | 106373 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 189 College Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | 3X3 | Permit Number 771157 | 6004972.1 | 2095958.7 | 37.7353849208155 | -122.425245160296 | (37.7353849208155, -122.425245160296) | |||
| 87824 | 87824 | 88198 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 468 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51202 | 6010823.8 | 2112095.6 | 37.7800221004896 | -122.40615007798401 | (37.7800221004896, -122.406150077984) | |||
| 87975 | 87975 | 88196 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 451 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51200 | 6011010.0 | 2112139.0 | 37.7801516798572 | -122.40550898254601 | (37.7801516798572, -122.405508982546) | |||
| 89260 | 89260 | 88128 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 814 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51153 | 6001284.0 | 2099705.0 | 37.7454623352517 | -122.438264566721 | (37.7454623352517, -122.438264566721) | |||
| 90473 | 90473 | 88194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 415 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51198 | 6011246.0 | 2112365.0 | 37.7807854162198 | -122.404708461336 | (37.7807854162198, -122.404708461336) | |||
| 90995 | 90995 | 89345 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 91659 | 91659 | 87769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Chenery St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50473 | 6000787.0 | 2096209.0 | 37.7358348629687 | -122.439732514448 | (37.7358348629687, -122.439732514448) | |||
| 91856 | 91856 | 108500 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 133 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773778 | 5993020.3424 | 2114605.60013 | 37.7859019761698 | -122.467922339348 | (37.7859019761698, -122.467922339348) | |
| 98242 | 98242 | 87774 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 89 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50479 | 6002385.3 | 2096237.8 | 37.736004786014796 | -122.43420862730801 | (37.7360047860148, -122.434208627308) | ||
| 98833 | 98833 | 94130 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Massasoit St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53496 | 6010073.0 | 2099348.0 | 37.7449780589808 | -122.40784828936899 | (37.7449780589808, -122.407848289369) | |||
| 99205 | 99205 | 88343 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51328 | 6004013.1 | 2089324.0 | 37.717113283576204 | -122.428088120605 | (37.7171132835762, -122.428088120605) | |||
| 99508 | 99508 | 88097 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1883 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51100 | 5983774.4 | 2102354.2 | 37.751724874757 | -122.49900473519399 | (37.751724874757, -122.499004735194) | |||
| 100099 | 100099 | 88603 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3317 Washington St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51548 | 5998920.0 | 2115920.0 | 37.789849888127605 | -122.44760588737499 | (37.7898498881276, -122.447605887375) | |||
| 100589 | 100589 | 88197 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 452 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51201 | 6010979.0 | 2112145.0 | 37.780166421042104 | -122.405616648952 | (37.7801664210421, -122.405616648952) | |||
| 100699 | 100699 | 86717 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 396 Capp St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196.0 | 2105003.0 | 37.760343914238796 | -122.418197308773 | (37.7603439142388, -122.418197308773) | ||||
| 102459 | 102459 | 88404 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51381 | 6007655.0 | 2116328.0 | 37.7914654879488 | -122.417412441264 | (37.7914654879488, -122.417412441264) | |||
| 102878 | 102878 | 86742 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 146 28th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49709 | 6004940.0 | 2099613.0 | 37.7454169862193 | -122.42561614308998 | (37.7454169862193, -122.42561614309) | ||||
| 104045 | 104045 | 88333 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51321 | 6003357.0 | 2091009.0 | 37.7217027796011 | -122.43047610401301 | (37.7217027796011, -122.430476104013) | |||
| 104225 | 104225 | 88250 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4901 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51236 | 5997843.0 | 2105622.0 | 37.7615126378881 | -122.450589449092 | (37.7615126378881, -122.450589449092) | |||
| 104499 | 104499 | 88199 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 480 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51207 | 6010751.4 | 2112033.7 | 37.7798480877104 | -122.406396180597 | (37.7798480877104, -122.406396180597) | |||
| 107234 | 107234 | 88600 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1681 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51544 | 6003389.0 | 2098448.0 | 37.7421304044314 | -122.43089612187599 | (37.7421304044314, -122.430896121876) | |||
| 108201 | 108201 | 88405 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1140 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51382 | 6007541.2 | 2118862.0 | 37.7984168187982 | -122.41798590203699 | (37.7984168187982, -122.417985902037) | |||
| 108482 | 108482 | 88279 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3104 Buchanan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51271 | 6003396.0 | 2118973.0 | 37.798487428479596 | -122.432337488027 | (37.7984874284796, -122.432337488027) | |||
| 108507 | 108507 | 93488 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1606 Guerrero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53237 | 6005836.0 | 2099575.0 | 37.745363234828 | -122.422515215131 | (37.745363234828, -122.422515215131) | |||
| 112102 | 112102 | 87778 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 428 Cayuga Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50509 | 6002088.1 | 2093915.1 | 37.729610311417 | -122.435070094369 | (37.729610311417, -122.435070094369) | |||
| 114774 | 114774 | 87779 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 658 Cayuga Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50510 | 6001646.6 | 2093292.7 | 37.7278762635986 | -122.4365518718 | (37.7278762635986, -122.4365518718) | |||
| 115000 | 115000 | 88502 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Topeka Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51440 | 6012361.0 | 2095362.9 | 37.7341636411904 | -122.399656997878 | (37.7341636411904, -122.399656997878) | |||
| 115459 | 115459 | 88311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51302 | 6005208.0 | 2092949.0 | 37.7271342768906 | -122.42421558283002 | (37.7271342768906, -122.42421558283) | |||
| 115475 | 115475 | 88125 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51131 | 6002546.0 | 2096093.0 | 37.735616318079295 | -122.433642678051 | (37.7356163180793, -122.433642678051) | |||
| 116151 | 116151 | 87780 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 731 Cayuga Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50512 | 6001494.8 | 2092776.9 | 37.726451366920294 | -122.43703973419399 | (37.7264513669203, -122.437039734194) | |||
| 116411 | 116411 | 88493 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1771 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51435 | 6012552.0 | 2095619.0 | 37.7348774836514 | -122.39901461564301 | (37.7348774836514, -122.399014615643) | |||
| 116421 | 116421 | 88344 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1127 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51329 | 6004077.0 | 2089373.5 | 37.7172528149217 | -122.42787077390301 | (37.7172528149217, -122.427870773903) | |||
| 119005 | 119005 | 88237 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 294 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51226 | 5997108.3 | 2112520.1 | 37.780410959581 | -122.45362856909901 | (37.780410959581, -122.453628569099) | |||
| 119037 | 119037 | 88334 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 470 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51322 | 6003225.0 | 2090876.0 | 37.721330112648104 | -122.430922905786 | (37.7213301126481, -122.430922905786) | |||
| 120716 | 120716 | 106300 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 687 28th St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | |||||
| 122193 | 122193 | 88437 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 424 Garfield St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51401 | 5992930.0 | 2090509.0 | 37.71973371849371 | -122.46648286823 | (37.7197337184937, -122.46648286823) | |||
| 122692 | 122692 | 89294 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 227 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 51900 | 6010130.2 | 2111260.4 | 37.7776900173559 | -122.408490632427 | (37.7776900173559, -122.408490632427) | |||
| 125265 | 125265 | 86714 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 858 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49701 | 6001009.0 | 2099689.0 | 37.745402758221005 | -122.43921432433201 | (37.745402758221, -122.439214324332) | ||||
| 125503 | 125503 | 88316 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 447 Edinburg St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093.0 | 37.7219225920035 | -122.43114302422501 | (37.7219225920035, -122.431143024225) | |||
| 125507 | 125507 | 88130 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 822 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234.0 | 2099702.0 | 37.745451254018796 | -122.43843724352399 | (37.7454512540188, -122.438437243524) | |||
| 125664 | 125664 | 86716 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 396 Capp St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196.0 | 2105003.0 | 37.760343914238796 | -122.418197308773 | (37.7603439142388, -122.418197308773) | ||||
| 126931 | 126931 | 88325 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 346 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623.0 | 2091442.0 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | |||
| 127615 | 127615 | 94887 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1570 Underwood Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53953 | 6014750.0 | 2093656.9 | 37.729612192968204 | -122.39127818835199 | (37.7296121929682, -122.391278188352) | ||
| 127913 | 127913 | 88195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51199 | 6011062.0 | 2112189.0 | 37.7802918756168 | -122.405332612017 | (37.7802918756168, -122.405332612017) | |||
| 129143 | 129143 | 86715 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 868 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49700 | 6001011.7 | 2099706.8 | 37.7454517864355 | -122.439206263756 | (37.7454517864355, -122.439206263756) | ||||
| 134599 | 134599 | 88574 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 508 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51514 | 5990337.58297 | 2111891.03116 | 37.778293240831 | -122.477005418758 | (37.778293240831, -122.477005418758) | ||
| 138028 | 138028 | 88584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 686 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51527 | 5988498.88719 | 2111336.2362900004 | 37.776663090168796 | -122.483325390193 | (37.7766630901688, -122.483325390193) | ||
| 138817 | 138817 | 88105 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1509 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51109 | 5981537.1 | 2104800.5 | 37.758310230191796 | -122.506922920506 | (37.7583102301918, -122.506922920506) | |||
| 141173 | 141173 | 86718 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 396 Capp St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196.0 | 2105003.0 | 37.760343914238796 | -122.418197308773 | (37.7603439142388, -122.418197308773) | ||||
| 141844 | 141844 | 88129 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 814 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51153 | 6001284.0 | 2099705.0 | 37.7454623352517 | -122.438264566721 | (37.7454623352517, -122.438264566721) | |||
| 142380 | 142380 | 88342 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51328 | 6004013.1 | 2089324.0 | 37.717113283576204 | -122.428088120605 | (37.7171132835762, -122.428088120605) | |||
| 142515 | 142515 | 88328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 691 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51316 | 6001466.3 | 2089490.7 | 37.7174265827267 | -122.436903104291 | (37.7174265827267, -122.436903104291) | |||
| 149326 | 149326 | 88963 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 680 27th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51728 | 5987564.38128 | 2111326.55276 | 37.776582071141604 | -122.48655736777201 | (37.7765820711416, -122.486557367772) | ||
| 150399 | 150399 | 88578 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1799 Cabrillo St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51517 | 5990110.26399 | 2110629.43192 | 37.7748160474001 | -122.477699547866 | (37.7748160474001, -122.477699547866) | ||
| 157998 | 157998 | 88374 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 39 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51352 | 5991453.97729 | 2114946.07033 | 37.7867462367263 | -122.473366318389 | (37.7867462367263, -122.473366318389) | ||
| 165517 | 165517 | 88587 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 819 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51530 | 5988484.506469999 | 2110381.54672 | 37.774040941831394 | -122.48330513764401 | (37.7740409418314, -122.483305137644) | ||
| 178705 | 178705 | 88583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 666 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51526 | 5988492.757809999 | 2111460.25568 | 37.7770032560271 | -122.483355686755 | (37.7770032560271, -122.483355686755) | ||
| 100 | 100 | 106679 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2014 12:00:00 AM | 10 | 3x3 | Permit Number 773028 | 5999374.7893199995 | 2116379.94206 | 37.7911387486163 | -122.44606546047702 | (37.7911387486163, -122.446065460477) | |
| 326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
| 1024 | 1024 | 97943 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3003 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768278 | 5999754.4115699995 | 2116356.69568 | 37.791096591089 | -122.44475031260099 | (37.791096591089, -122.444750312601) | |
| 1118 | 1118 | 26811 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001133.0786 | 2112143.4834 | 37.7796067716282 | -122.43967800032301 | (37.7796067716282, -122.439678000323) | |||
| 1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
| 1240 | 1240 | 241867 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 633 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1987 12:00:00 AM | 8 | Width 2ft | Permit Number 24800 | 6008703.52023 | 2095884.2711099999 | 37.735390653541295 | -122.412338944781 | (37.7353906535413, -122.412338944781) | |
| 1725 | 1725 | 24940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2733 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X3 | 5998612.3168 | 2113129.3587 | 37.782169931054604 | -122.44846938258301 | (37.7821699310546, -122.448469382583) | ||
| 2084 | 2084 | 200756 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1698 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 07/23/2010 12:00:00 AM | 2 | Width 0ft | Permit Number 53643 | 6014807.3749 | 2094642.3361 | 37.732321185493 | -122.39114868869899 | (37.732321185493, -122.391148688699) | |
| 2152 | 2152 | 242277 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 117 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 46994 | 6001802.4938199995 | 2096648.3509099998 | 37.7370989679366 | -122.43625299088801 | (37.7370989679366, -122.436252990888) | |
| 2245 | 2245 | 5919 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2007 12:00:00 AM | 12 | 3x3 | Permit Number 52201 | 6004140.9874 | 2112910.1496 | 37.7818825900403 | -122.42932703435 | (37.7818825900403, -122.42932703435) | |
| 3186 | 3186 | 218743 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.5324099995 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | |
| 3298 | 3298 | 28315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.9906200003 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | |
| 3327 | 3327 | 140458 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | Width 0ft | 6003273.7425 | 2112436.298 | 37.7805323760013 | -122.432293445455 | (37.7805323760013, -122.432293445455) | ||
| 3512 | 3512 | 241416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1985 12:00:00 AM | 12 | Width 2ft | Permit Number 22471 | 6004614.54132 | 2095950.25242 | 37.7353415190975 | -122.42648077318 | (37.7353415190975, -122.42648077318) | |
| 3863 | 3863 | 6898 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005831.3408 | 2110713.462 | 37.775946573797995 | -122.423322982857 | (37.775946573798, -122.423322982857) | ||
| 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) | |
| 4496 | 4496 | 30326 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 946 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:13:00 AM | 3 | Permit Number 17 | 5995052.87017 | 2090222.4724 | 37.7190692525106 | -122.459124173264 | (37.7190692525106, -122.459124173264) | ||
| 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 | ||||||
| 4638 | 4638 | 180016 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 7 | Width 3ft | 5997041.774780001 | 2087538.2490700001 | 37.711813136431 | -122.452055773566 | (37.711813136431, -122.452055773566) | ||
| 4709 | 4709 | 253656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 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) | ||
| 5307 | 5307 | 8160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002453.143999999 | 2111285.6659999997 | 37.777326466446 | -122.435049962975 | (37.777326466446, -122.435049962975) | ||
| 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) |
| 5767 | 5767 | 14527 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999201.3001 | 2110597.4992 | 37.7752517549466 | -122.44624958831801 | (37.7752517549466, -122.446249588318) | |||
| 5829 | 5829 | 7833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006176.68475 | 2113023.80022 | 37.7823096849858 | -122.42229253146999 | (37.7823096849858, -122.42229253147) | |||
| 6259 | 6259 | 110082 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3028 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773127 | 6003845.53754 | 2119275.91303 | 37.799344628804796 | -122.43080357774299 | (37.7993446288048, -122.430803577743) | |
| 6480 | 6480 | 6980 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 802 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003550.3934 | 2110396.3103 | 37.7749467581504 | -122.431190726971 | (37.7749467581504, -122.431190726971) | ||
| 6659 | 6659 | 10663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.77563176944871 | -122.432267067771 | (37.7756317694487, -122.432267067771) | ||
| 6672 | 6672 | 22644 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1244 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2000 12:00:00 AM | 3 | 3X3 | 6004038.676 | 2112547.7701 | 37.7808817933373 | -122.429655131034 | (37.7808817933373, -122.429655131034) |
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");