Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
| 9718 | 9718 | 105047 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | |||||
| 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) | |||||
| 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) | ||
| 58951 | 58951 | 107381 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 MOSS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | ||||||
| 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) | |||
| 120702 | 120702 | 97175 | 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) | |||||
| 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) | |||
| 127560 | 127560 | 108446 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 672 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.5397799998 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | |||
| 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) | ||||
| 129226 | 129226 | 107382 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 MOSS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | ||||||
| 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) | |||
| 139016 | 139016 | 115674 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1433 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | ||
| 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) | ||
| 364 | 364 | 182551 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2565 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986541.5452 | 2105693.4321 | 37.7610554202125 | -122.489681251316 | (37.7610554202125, -122.489681251316) | |||
| 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) | ||
| 982 | 982 | 18283 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | ||
| 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) | |
| 1097 | 1097 | 251443 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
| 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) | ||||
| 1180 | 1180 | 251470 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.0846799999 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | |
| 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) | |
| 1325 | 1325 | 141834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | |||
| 1344 | 1344 | 141858 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1110 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004615.4703 | 2112626.4811 | 37.781130557433706 | -122.427665325896 | (37.7811305574337, -122.427665325896) | |||
| 1354 | 1354 | 14491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999051.991 | 2111710.9656 | 37.77830051932229 | -122.446846219186 | (37.7783005193223, -122.446846219186) | |||
| 1373 | 1373 | 10189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1153 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2017 12:00:00 AM | 3 | 2x3 | 6005799.04863 | 2102230.07657 | 37.752651382065395 | -122.42283164626998 | (37.7526513820654, -122.42283164627) | ||
| 1436 | 1436 | 251534 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226.0 | 2102732.0 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | ||
| 1445 | 1445 | 22600 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.78154623162111 | -122.42327383483999 | (37.7815462316211, -122.42327383484) | |||
| 1458 | 1458 | 246242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
| 1482 | 1482 | 140438 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003482.3387 | 2112124.8891 | 37.779689150174704 | -122.43154957445299 | (37.7796891501747, -122.431549574453) | |||
| 1531 | 1531 | 5189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 509 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001637.7109 | 2110249.8513 | 37.7744360439082 | -122.43779659970501 | (37.7744360439082, -122.437796599705) | |||
| 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) | |
| 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) |
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");