trees
7,322 rows where qSpecies_id = 1 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41 | 159866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001590.27181 | 2091627.71254 | 37.7233013847479 | -122.436627471279 | (37.7233013847479, -122.436627471279) | 9 | 7 | 6 | 28861 | 25 | ||
| 44 | 159867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001543.73914 | 2091652.70256 | 37.7233673572035 | -122.436790113668 | (37.7233673572035, -122.436790113668) | 9 | 7 | 6 | 28861 | 25 | ||
| 48 | 159865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001621.37029 | 2091612.17517 | 37.7232604898693 | -122.436518858358 | (37.7232604898693, -122.436518858358) | 9 | 7 | 6 | 28861 | 25 | ||
| 49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
| 310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
| 540 | 35140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 911 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38670 | 6001882.60594 | 2088665.49745 | 37.7151844124098 | -122.435405132561 | (37.7151844124098, -122.435405132561) | 9 | 7 | 6 | 28861 | 5 | |
| 672 | 218447 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5997663.70622 | 2094120.17429 | 37.7299211747216 | -122.450380387859 | (37.7299211747216, -122.450380387859) | 9 | 7 | 4 | 28861 | 40 | |||
| 733 | 218511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43359 | 5996829.51445 | 2089654.64111 | 37.7176120972009 | -122.45294206803 | (37.7176120972009, -122.45294206803) | 9 | 8 | 6 | 28861 | 24 | |
| 762 | 161390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 467 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6002831.42521 | 2091188.97801 | 37.7221671723558 | -122.432305723439 | (37.7221671723558, -122.432305723439) | 9 | 7 | 6 | 28861 | 5 | ||
| 764 | 163220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 0ft | 5996567.29942 | 2088361.68289 | 37.714046904924 | -122.453755106407 | (37.714046904924, -122.453755106407) | 9 | 8 | 6 | 28861 | 24 | ||
| 811 | 160771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 667 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6003251.82484 | 2089320.66382 | 37.7170610223232 | -122.430719246496 | (37.7170610223232, -122.430719246496) | 9 | 7 | 6 | 28861 | 5 | ||
| 812 | 210575 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 778918 | 5996813.55952 | 2094844.51305 | 37.7318613433091 | -122.453371704763 | (37.7318613433091, -122.453371704763) | 9 | 7 | 4 | 59 | 40 | |
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
| 976 | 258329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998052 | 2087327 | 37.7112909098977 | -122.448548966881 | (37.7112909098977, -122.448548966881) | 9 | 7 | 6 | 28861 | 25 | ||||
| 1065 | 180355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.444239347485 | (37.7237213933189, -122.444239347485) | 9 | 7 | 6 | 28861 | 25 | |||
| 1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
| 1222 | 16326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 3 | 3X3 | 5996873.6825 | 2094683.9462 | 37.7314239112697 | -122.45315226118 | (37.7314239112697, -122.45315226118) | 9 | 7 | 4 | 59 | 40 | ||
| 1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
| 1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
| 1284 | 72257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 671 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002561.32843 | 2089744.29585 | 37.7181850777589 | -122.433136210491 | (37.7181850777589, -122.433136210491) | 9 | 7 | 6 | 28861 | 5 | |||
| 1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
| 1499 | 262277 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
| 1604 | 15896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.10589 | 37.7110235586697 | -122.446959612304 | (37.7110235586697, -122.446959612304) | 9 | 7 | 6 | 28861 | 5 | ||
| 1788 | 262276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
| 2128 | 52629 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2006 12:00:00 AM | 5 | Permit Number 48714 | 6000818.47433 | 2092706.59424 | 37.7262198574511 | -122.439372720173 | (37.7262198574511, -122.439372720173) | 9 | 7 | 6 | 28861 | 25 | |
| 2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
| 2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
| 2372 | 254866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x6 | 5996346 | 2087845 | 37.7126155239422 | -122.454482695042 | (37.7126155239422, -122.454482695042) | 9 | 8 | 6 | 28861 | 24 | ||
| 2477 | 26317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | 9 | 7 | 6 | 28861 | 25 | ||
| 2673 | 218475 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995091.16057 | 2091998.49619 | 37.7239479909859 | -122.459120352046 | (37.7239479909859, -122.459120352046) | 9 | 8 | 4 | 28861 | 24 | |||
| 2704 | 214942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 40 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993797.90543 | 2095609.88239 | 37.7337895410509 | -122.463852902986 | (37.7337895410509, -122.463852902986) | 9 | 8 | 4 | 59 | 40 | |||
| 2729 | 171547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006051.63014 | 2092221.41299 | 37.725184080371 | -122.421247513879 | (37.725184080371, -122.421247513879) | 9 | 7 | 7 | 309 | 5 | |||
| 2815 | 62472 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 9 | Permit Number 22643 | 6001469.26063 | 2093519.40721 | 37.7284886706995 | -122.43718116229 | (37.7284886706995, -122.43718116229) | 9 | 7 | 6 | 28861 | 25 | |
| 3012 | 15898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.15292 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | 9 | 7 | 6 | 28861 | 5 | ||
| 3015 | 217584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Randolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993971.4029 | 2088542.2845 | 37.7143936266554 | -122.462740537778 | (37.7143936266554, -122.462740537778) | 9 | 8 | 6 | 64 | 24 | |||
| 3459 | 84116 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1325 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50709 | 6008644.30779 | 2087548.3519 | 37.712498659051 | -122.411954776917 | (37.712498659051, -122.411954776917) | 9 | 7 | 8 | 309 | 39 | |
| 3618 | 122859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996503.07173 | 2087192.19332 | 37.7108320750073 | -122.453892694613 | (37.7108320750073, -122.453892694613) | 9 | 7 | 6 | 28861 | 25 | ||
| 3648 | 262535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6001472.85598 | 2090996.66296 | 37.7215619917613 | -122.43698819828 | (37.7215619917613, -122.43698819828) | 9 | 7 | 6 | 28861 | 5 | ||
| 3824 | 252901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 598 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | ||||
| 3843 | 25432 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2436 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1998 12:00:00 AM | 3 | 3X3 | 6010891.05193 | 2086887.18096 | 37.7108090136865 | -122.404142791654 | (37.7108090136865, -122.404142791654) | 9 | 7 | 8 | 309 | 39 | ||
| 3960 | 28454 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993123.43173 | 2093088.843 | 37.7268284984876 | -122.466001612774 | (37.7268284984876, -122.466001612774) | 9 | 8 | 4 | 59 | 40 | ||
| 3968 | 73735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002380.79151 | 2091565.74366 | 37.7231761244664 | -122.433890370255 | (37.7231761244664, -122.433890370255) | 9 | 7 | 6 | 28861 | 5 | |||
| 4314 | 261587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2700x San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5997075 | 2088509 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | 9 | 8 | 6 | 28861 | 24 | ||||
| 4529 | 160228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 960 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001238.61931 | 2088721.92434 | 37.7153027532862 | -122.437635063623 | (37.7153027532862, -122.437635063623) | 9 | 7 | 6 | 28861 | 5 | ||
| 4837 | 115185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | 9 | 7 | 6 | 28861 | 25 | ||||
| 4843 | 260426 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6009322.86982 | 2092462.23119 | 37.726029197201 | -122.409956117368 | (37.726029197201, -122.409956117368) | 9 | 3 | 7 | 309 | 28 | ||
| 4928 | 251750 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144 | 2086928 | 37.71048518025 | -122.430921281744 | (37.71048518025, -122.430921281744) | 9 | 7 | 6 | 28861 | 5 | ||
| 4962 | 71085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 336 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000237.45691 | 2087069.9768 | 37.7107099003031 | -122.440977070243 | (37.7107099003031, -122.440977070243) | 9 | 7 | 6 | 28861 | 5 | |||
| 4998 | 62129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 7 | Permit Number 22236 | 6001798.50341 | 2093490.78314 | 37.7284287857379 | -122.436040907355 | (37.7284287857379, -122.436040907355) | 9 | 7 | 6 | 28861 | 25 | |
| 5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
| 5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
| 5200 | 163651 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 260 Sagamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2019 05:56:00 AM | 3 | 4x6 | 5994434.35916 | 2087472.87678 | 37.7114839386972 | -122.461062922717 | (37.7114839386972, -122.461062922717) | 9 | 8 | 6 | 28861 | 24 | ||
| 5335 | 26050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 142 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 5995479.9938 | 2088097.6075 | 37.7132594193894 | -122.457494129816 | (37.7132594193894, -122.457494129816) | 9 | 8 | 6 | 28861 | 24 | ||
| 5422 | 122567 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 777809 | 5994026.14526 | 2086558.74537 | 37.7089504501359 | -122.46240754496 | (37.7089504501359, -122.46240754496) | 9 | 8 | 6 | 28861 | 25 | |
| 5461 | 91099 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2009 12:00:00 AM | 5 | 3x3 | Permit Number 51989 | 6007027 | 2091471 | 37.7231785479974 | -122.417822583514 | (37.7231785479974, -122.417822583514) | 9 | 7 | 7 | 309 | 28 | |
| 5481 | 112239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:41:00 AM | 3 | 5999153.8915 | 2088963.97845 | 37.7158486246797 | -122.444858161098 | (37.7158486246797, -122.444858161098) | 9 | 7 | 6 | 28861 | 25 | |||
| 5598 | 62124 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/1985 12:00:00 AM | 12 | Permit Number 22230 | 6001290.71631 | 2092388.94515 | 37.7253745288844 | -122.437717468513 | (37.7253745288844, -122.437717468513) | 9 | 7 | 6 | 28861 | 25 | |
| 5705 | 172247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002298.97974 | 2092038.38188 | 37.7244692398512 | -122.434206949586 | (37.7244692398512, -122.434206949586) | 9 | 7 | 6 | 28861 | 5 | ||
| 5765 | 112237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2015 08:35:00 AM | 3 | 5999175.75859 | 2088985.62206 | 37.71590930104 | -122.444784133402 | (37.71590930104, -122.444784133402) | 9 | 7 | 6 | 28861 | 25 | |||
| 5773 | 180020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 2ft | 6001294.85354 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | 9 | 7 | 6 | 28861 | 25 | |||
| 5890 | 65218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 28005 | 6002441.48783 | 2091581.27418 | 37.723222212016 | -122.433681664588 | (37.723222212016, -122.433681664588) | 9 | 7 | 6 | 28861 | 5 | |
| 5898 | 172286 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 930 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001778.14315 | 2086833.9607 | 37.7101494832819 | -122.435635245683 | (37.7101494832819, -122.435635245683) | 9 | 7 | 6 | 28861 | 5 | |||
| 5951 | 180245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002009.45925 | 2093875.90967 | 37.729498237948 | -122.435339160997 | (37.729498237948, -122.435339160997) | 9 | 7 | 6 | 28861 | 25 | |||
| 6157 | 180362 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 207 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003956.84775 | 2092462.08081 | 37.725726580201 | -122.428506110284 | (37.725726580201, -122.428506110284) | 9 | 7 | 6 | 28861 | 5 | |||
| 6240 | 113583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 466 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6001747.70462 | 2091066.77423 | 37.7217701198725 | -122.436043136802 | (37.7217701198725, -122.436043136802) | 9 | 7 | 6 | 28861 | 5 | ||
| 6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6371 | 179976 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998720.79345 | 2086710.36043 | 37.7096359749025 | -122.446193129116 | (37.7096359749025, -122.446193129116) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6525 | 160467 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 674 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001006.228 | 2089897.25165 | 37.7185167225441 | -122.438522469629 | (37.7185167225441, -122.438522469629) | 9 | 7 | 6 | 28861 | 5 | ||
| 6539 | 160484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001599.32466 | 2090089.5379 | 37.7190784175245 | -122.436486137419 | (37.7190784175245, -122.436486137419) | 9 | 7 | 6 | 28861 | 5 | ||
| 6566 | 160486 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001618.87365 | 2090077.82014 | 37.719047354019 | -122.436417726014 | (37.719047354019, -122.436417726014) | 9 | 7 | 6 | 28861 | 5 | ||
| 6573 | 262162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | ||
| 6627 | 218493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994696.5338 | 2089004.6688 | 37.7157049615873 | -122.460267696305 | (37.7157049615873, -122.460267696305) | 9 | 8 | 6 | 28861 | 24 | |||
| 6707 | 15866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5425 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999452.41338 | 2088067.62767 | 37.7134044805159 | -122.443761975638 | (37.7134044805159, -122.443761975638) | 9 | 7 | 6 | 28861 | 5 | ||
| 6757 | 121102 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 266 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | 3x3 | 6004508.59639 | 2090893.04337 | 37.7214495565251 | -122.426487084614 | (37.7214495565251, -122.426487084614) | 9 | 7 | 6 | 28861 | 5 | ||
| 6815 | 26065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 252 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994463.9745 | 2088114.2994 | 37.7132468380661 | -122.461007025599 | (37.7132468380661, -122.461007025599) | 9 | 8 | 6 | 28861 | 24 | |||
| 6874 | 258105 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5998652.17813 | 2087511.67596 | 37.7118322871785 | -122.446487885746 | (37.7118322871785, -122.446487885746) | 9 | 7 | 6 | 28861 | 25 | |||||
| 6951 | 180943 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 France Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 2ft | 6001409.71279 | 2090208.60686 | 37.719394577768 | -122.437150071831 | (37.719394577768, -122.437150071831) | 9 | 7 | 6 | 28861 | 5 | ||
| 7325 | 163652 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2019 06:18:00 AM | 3 | 6x7 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||
| 7438 | 15724 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4380 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2019 10:29:00 AM | 6 | 3X3 | 6002765.9079 | 2093158.2463 | 37.7275706265896 | -122.432672801251 | (37.7275706265896, -122.432672801251) | 9 | 7 | 6 | 28861 | 25 | ||
| 7473 | 122856 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996611.63138 | 2087256.15424 | 37.7110139206266 | -122.45352210466 | (37.7110139206266, -122.45352210466) | 9 | 7 | 6 | 28861 | 25 | ||
| 7480 | 180280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1204x Alemany Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.7300565721367 | -122.432867327564 | (37.7300565721367, -122.432867327564) | 9 | 7 | 6 | 28861 | 25 | |||
| 7504 | 73605 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | 9 | 8 | 6 | 28861 | 25 | |||
| 7830 | 262278 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 7891 | 218461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 444 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996522.09527 | 2089877.4414 | 37.7182062325102 | -122.454020752669 | (37.7182062325102, -122.454020752669) | 9 | 8 | 6 | 28861 | 24 | |||
| 8097 | 26292 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999828.34203 | 2092450.55637 | 37.725460439341 | -122.442777166756 | (37.725460439341, -122.442777166756) | 9 | 7 | 6 | 28861 | 25 | ||
| 8151 | 112241 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:34:00 AM | 3 | 5999126.802 | 2088939.36005 | 37.71577948212 | -122.444950025942 | (37.71577948212, -122.444950025942) | 9 | 7 | 6 | 28861 | 25 | |||
| 8280 | 254918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4477 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | 4x4 | 6002615 | 2092793 | 37.7265591830782 | -122.433168404528 | (37.7265591830782, -122.433168404528) | 9 | 7 | 6 | 28861 | 5 | ||
| 8349 | 163331 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 159 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780897 | 5995371.93865 | 2087733.0149 | 37.7122521261194 | -122.45784123641 | (37.7122521261194, -122.45784123641) | 9 | 8 | 6 | 28861 | 24 | |
| 8354 | 261712 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 31 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001602.2183 | 2091588.36368 | 37.7231940205575 | -122.436583359467 | (37.7231940205575, -122.436583359467) | 9 | 7 | 6 | 28861 | 25 | ||||
| 8501 | 180126 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 810 Vienna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002202.71232 | 2088746.89227 | 37.7154260791221 | -122.434304523347 | (37.7154260791221, -122.434304523347) | 9 | 7 | 6 | 28861 | 5 | |||
| 8506 | 258378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007594.19766 | 2093376.79647 | 37.7284433601031 | -122.415996783146 | (37.7284433601031, -122.415996783146) | 9 | 3 | 7 | 309 | 5 | |||
| 8591 | 214937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993802.32185 | 2095722.84394 | 37.7340999600407 | -122.463845830728 | (37.7340999600407, -122.463845830728) | 9 | 8 | 4 | 59 | 40 | |||
| 8780 | 15882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1995 12:00:00 AM | 6 | 3X3 | 5998936.25039 | 2087580.37032 | 37.7120371278738 | -122.445510993365 | (37.7120371278738, -122.445510993365) | 9 | 7 | 6 | 28861 | 25 | ||
| 8848 | 180194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 162 Tioga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6010134.95637 | 2089163.33615 | 37.7170165958166 | -122.406916365593 | (37.7170165958166, -122.406916365593) | 9 | 7 | 8 | 309 | 39 | ||||
| 8985 | 26035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1997 12:00:00 AM | 12 | 3X3 | 5996388.1269 | 2088087.32843 | 37.713283317556 | -122.454354585517 | (37.713283317556, -122.454354585517) | 9 | 8 | 6 | 28861 | 24 | ||
| 9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 9274 | 218494 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 772989 | 5994534.17979 | 2089038.5715 | 37.7157887100619 | -122.460831317629 | (37.7157887100619, -122.460831317629) | 9 | 8 | 6 | 28861 | 24 | |
| 9278 | 171265 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 186 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003981 | 2092626 | 37.7261780326476 | -122.428434296093 | (37.7261780326476, -122.428434296093) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );