trees
7,322 rows where qSpecies_id = 1 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 7674 | 259377 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1486 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015207.81311 | 2093285.95013 | 37.7286190359645 | -122.389669569097 | (37.7286190359645, -122.389669569097) | 10 | 3 | 8 | 58 | 1 | ||
| 7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 7867 | 62156 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2165 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 9 | Permit Number 22270 | 5999843.40545 | 2120869.57146 | 37.8034928263957 | -122.444766922157 | (37.8034928263957, -122.444766922157) | 13 | 9 | 1 | 57 | 17 | |
| 7879 | 44719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1996 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43840 | 5989755.3727 | 2101809.9749 | 37.7505795958207 | -122.478282176517 | (37.7505795958207, -122.478282176517) | 1 | 8 | 3 | 29491 | 35 | ||
| 7999 | 62155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2252 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 13 | Permit Number 22269 | 5999444.38711 | 2120859.49312 | 37.8034423753191 | -122.446147011887 | (37.8034423753191, -122.446147011887) | 13 | 9 | 1 | 57 | 17 | |
| 8139 | 72882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2610 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988659.6012 | 2097522.8498 | 37.7387446083711 | -122.481757414628 | (37.7387446083711, -122.481757414628) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8231 | 258103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5994656.53411 | 2112804.2386 | 37.7810502710743 | -122.462130924837 | (37.7810502710743, -122.462130924837) | 11 | 6 | 2 | 54 | 11 | |||||
| 8300 | 62006 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1985 12:00:00 AM | 7 | Permit Number 22075 | 6004472.06597 | 2120817.82099 | 37.8036137870071 | -122.428745548466 | (37.8036137870071, -122.428745548466) | 13 | 9 | 1 | 28858 | 17 | |
| 8581 | 84551 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 711 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987529.79137 | 2111085.31496 | 37.7759176835965 | -122.486659304996 | (37.7759176835965, -122.486659304996) | 11 | 6 | 2 | 55 | 26 | |||
| 8646 | 84388 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012568.10677 | 2099031.13024 | 37.7442473722189 | -122.399198367617 | (37.7442473722189, -122.399198367617) | 10 | 3 | 8 | 58 | 1 | |||
| 8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | ||||
| 8862 | 84382 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012627.48932 | 2098986.68874 | 37.7441286545312 | -122.398989915558 | (37.7441286545312, -122.398989915558) | 10 | 3 | 8 | 58 | 1 | |||
| 8909 | 259799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011890.92519 | 2088681.18109 | 37.7157907972077 | -122.400812935252 | (37.7157907972077, -122.400812935252) | 10 | 7 | 8 | 309 | 39 | |||
| 9054 | 73399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010326.19468 | 2093255.95612 | 37.7282647808735 | -122.406543575948 | (37.7282647808735, -122.406543575948) | 10 | 3 | 7 | 309 | 28 | |||
| 9203 | 30559 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011712.00106 | 2086211.42806 | 37.7089993673055 | -122.401257930213 | (37.7089993673055, -122.401257930213) | 10 | 3 | 8 | 309 | 1 | ||
| 9324 | 115422 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 594 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.468143782961 | (37.7772088768112, -122.468143782961) | 11 | 6 | 2 | 54 | 11 | ||
| 9338 | 49154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1807 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | 5 | Permit Number 46276 | 6008254.79988 | 2118664.91004 | 37.7979157949336 | -122.41550265903 | (37.7979157949336, -122.41550265903) | 5 | 1 | 10 | 28858 | 21 | |
| 9442 | 41077 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1999 12:00:00 AM | 4 | Permit Number 41835 | 6009599.89061 | 2108767.81668 | 37.7708162529988 | -122.410149139686 | (37.7708162529988, -122.410149139686) | 8 | 2 | 9 | 28853 | 34 | ||
| 9465 | 260400 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
| 9636 | 84385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012596.88679 | 2099009.26073 | 37.7441889270701 | -122.399097317095 | (37.7441889270701, -122.399097317095) | 10 | 3 | 8 | 58 | 1 | |||
| 9650 | 71158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 728 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009232.04509 | 2115488.13377 | 37.7892480238112 | -122.411896496347 | (37.7892480238112, -122.411896496347) | 5 | 1 | 10 | 28857 | 21 | |||
| 9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
| 9752 | 78754 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 725 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009214.42032 | 2110420.4005 | 37.7753322481181 | -122.411599274911 | (37.7753322481181, -122.411599274911) | 8 | 2 | 9 | 28853 | 34 | |||
| 9876 | 72263 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002374.01007 | 2091556.78865 | 37.7231511511793 | -122.433913172559 | (37.7231511511793, -122.433913172559) | 9 | 7 | 6 | 28861 | 5 | |||
| 9887 | 84280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016140.4247 | 2093648.9439 | 37.7296674147143 | -122.386470746676 | (37.7296674147143, -122.386470746676) | 10 | 3 | 8 | 58 | 1 | |||
| 9992 | 242301 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6003131.09192 | 2097221.83137 | 37.7387490116556 | -122.431700361905 | (37.7387490116556, -122.431700361905) | 2 | 7 | 5 | 63 | 7 | ||||
| 10039 | 62160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2129 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22275 | 6000012.6105 | 2120894.62285 | 37.8035712652717 | -122.444183183902 | (37.8035712652717, -122.444183183902) | 13 | 9 | 1 | 57 | 17 | |
| 10045 | 71608 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994331.5401 | 2086682.33238 | 37.7093073724942 | -122.461361017415 | (37.7093073724942, -122.461361017415) | 9 | 8 | 6 | 28861 | 25 | |||
| 10080 | 73378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983190.43873 | 2110910.57285 | 37.775183970413 | -122.501657073915 | (37.775183970413, -122.501657073915) | 11 | 6 | 2 | 55 | 26 | |||
| 10145 | 71168 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2186 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988245.3089 | 2100453.2879 | 37.7467667189168 | -122.483404589395 | (37.7467667189168, -122.483404589395) | 1 | 8 | 3 | 29491 | 35 | |||
| 10376 | 70746 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 47 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004868.29808 | 2090880.64628 | 37.7214358445608 | -122.425242812318 | (37.7214358445608, -122.425242812318) | 9 | 7 | 6 | 28861 | 5 | |||
| 10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 10640 | 41309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2000 12:00:00 AM | Permit Number 41981 | 5992910.03093479 | 2098919.83529447 | 37.7428266345167 | -122.467163100034 | (37.7428266345167, -122.467163100034) | 1 | 8 | 4 | 59 | 40 | |||
| 10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
| 10954 | 75645 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011131.8005 | 2118945.02958 | 37.7988462254172 | -122.405567109137 | (37.7988462254172, -122.405567109137) | 3 | 1 | 10 | 308 | 23 | |||
| 11066 | 96252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
| 11112 | 42195 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1045 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42471 | 6010370.94214 | 2109173.76071 | 37.7719740698767 | -122.407510668177 | (37.7719740698767, -122.407510668177) | 14 | 2 | 9 | 28853 | 34 | |
| 11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 11357 | 35354 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1137 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38816 | 6011684.12521 | 2103052.05971 | 37.7552386668468 | -122.402537695179 | (37.7552386668468, -122.402537695179) | 10 | 3 | 8 | 28856 | 29 | |
| 11388 | 101208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 11401 | 62392 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 177 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1985 12:00:00 AM | 8 | Permit Number 22542 | 6001320.92135 | 2093374.94478 | 37.7280835764879 | -122.437683636003 | (37.7280835764879, -122.437683636003) | 9 | 7 | 6 | 28861 | 25 | |
| 11454 | 62127 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 690 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 7 | Permit Number 22234 | 6001602.06126 | 2093154.58913 | 37.7274945115477 | -122.43669596096 | (37.7274945115477, -122.43669596096) | 9 | 7 | 6 | 28861 | 25 | |
| 11501 | 72262 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 339 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002453.69682 | 2091602.93785 | 37.7232823883568 | -122.433641008038 | (37.7232823883568, -122.433641008038) | 9 | 7 | 6 | 28861 | 5 | |||
| 11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 11724 | 81872 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3132 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003807.91186 | 2119539.89269 | 37.8000673168179 | -122.430952625964 | (37.8000673168179, -122.430952625964) | 13 | 9 | 1 | 57 | 17 | |||
| 11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 11880 | 42194 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1016 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | 14 | 2 | 9 | 28853 | 34 | ||
| 12024 | 66137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3248 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/1990 12:00:00 AM | 5 | Permit Number 29200 | 5999873.32355 | 2119767.07624 | 37.8004673775197 | -122.444584102586 | (37.8004673775197, -122.444584102586) | 13 | 9 | 1 | 57 | 17 | |
| 12138 | 59616 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1011 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2011 12:00:00 AM | 2 | Permit Number 767194 | 6015550.11535 | 2104384.66837 | 37.7591127987462 | -122.389260889583 | (37.7591127987462, -122.389260889583) | 10 | 3 | 8 | 28856 | 29 | ||
| 12342 | 25 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 736 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/1995 12:00:00 AM | 0 | 6003903.5250844 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | 7 | 9 | 5 | 28862 | 3 | |||
| 12476 | 78459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2912 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990004.06273 | 2095836.28778 | 37.7341918338916 | -122.476985746011 | (37.7341918338916, -122.476985746011) | 1 | 8 | 4 | 64 | 35 | |||
| 12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 12796 | 83871 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6016609.56128 | 2096718.62341 | 37.7381221005503 | -122.385062666315 | (37.7381221005503, -122.385062666315) | 10 | 3 | 8 | 58 | 1 | |||
| 12958 | 36213 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 12998 | 80732 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1951 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013374.43232 | 2096002.02585 | 37.7359749889588 | -122.396197995467 | (37.7359749889588, -122.396197995467) | 10 | 3 | 8 | 58 | 1 | |||
| 13066 | 71437 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 37 Moss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010216.42289 | 2111356.07876 | 37.777957557144 | -122.408199106408 | (37.777957557144, -122.408199106408) | 14 | 2 | 9 | 28853 | 34 | |||
| 13079 | 75759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011137.27895 | 2118914.33148 | 37.7987622422292 | -122.405545988575 | (37.7987622422292, -122.405545988575) | 3 | 1 | 10 | 308 | 23 | |||
| 13150 | 44035 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1147 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | 2 | 4 | 5 | 28862 | 22 | |||
| 13160 | 36755 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39521 | 6011153.23525132 | 2095168.62195256 | 37.733562795365 | -122.403818978685 | (37.733562795365, -122.403818978685) | 10 | 3 | 8 | 58 | 1 | |||
| 13188 | 51663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2041 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | 6 | Permit Number 47942 | 5999392.0644 | 2115915.2572 | 37.7898638328006 | -122.445972252917 | (37.7898638328006, -122.445972252917) | 13 | 6 | 1 | 29490 | 31 | ||
| 13218 | 33859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 163 Wood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | 5 | Permit Number 37857 | 5998466.457 | 2112830.5323 | 37.7813410910062 | -122.448952457158 | (37.7813410910062, -122.448952457158) | 15 | 6 | 2 | 54 | 16 | ||
| 13224 | 84394 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012485.34131 | 2099091.8442 | 37.7444094669397 | -122.399488816268 | (37.7444094669397, -122.399488816268) | 10 | 3 | 8 | 58 | 1 | |||
| 13294 | 85220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 22nd Ave | 3 | : | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.7762210417533 | -122.481313842154 | (37.7762210417533, -122.481313842154) | 11 | 6 | 2 | 55 | 26 | ||
| 13316 | 83384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 Connecticut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
| 13535 | 82196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988380.7024 | 2104309.4625 | 37.7573626218542 | -122.483219031327 | (37.7573626218542, -122.483219031327) | 1 | 8 | 3 | 56 | 35 | |||
| 13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 13785 | 62042 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1985 12:00:00 AM | 1 | Permit Number 771040 | 6014174.50222 | 2112903.23417 | 37.7824265275979 | -122.394614975523 | (37.7824265275979, -122.394614975523) | 6 | 2 | 9 | 28856 | 6 | ||
| 13837 | 84396 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012453.41363 | 2099114.94176 | 37.7444711082579 | -122.399600837636 | (37.7444711082579, -122.399600837636) | 10 | 3 | 8 | 58 | 1 | |||
| 13850 | 38853 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1414 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 5 | Permit Number 40680 | 5989618.1466 | 2105710.715 | 37.7612820207033 | -122.479042002425 | (37.7612820207033, -122.479042002425) | 1 | 8 | 3 | 56 | 35 | |
| 13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 14052 | 73573 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 37 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010226.1048 | 2111344.18291 | 37.7779254360491 | -122.408164773908 | (37.7779254360491, -122.408164773908) | 14 | 2 | 9 | 28853 | 34 | |||
| 14058 | 260595 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | ||
| 14344 | 84278 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6016119.4924 | 2093666.0202 | 37.7297131440727 | -122.386544302761 | (37.7297131440727, -122.386544302761) | 10 | 3 | 8 | 58 | 1 | |||
| 14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14366 | 32816 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3770 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37175 | 6003302.6047116 | 2103041.70072149 | 37.7547387357637 | -122.431522720463 | (37.7547387357637, -122.431522720463) | 2 | 4 | 5 | 28862 | 22 | ||
| 14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14454 | 32825 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246 | -122.440510188354 | (37.752585873246, -122.440510188354) | 2 | 4 | 5 | 28862 | 22 | ||
| 14735 | 74953 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1104 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989482.2278 | 2097687.6237 | 37.7392448382864 | -122.478925239859 | (37.7392448382864, -122.478925239859) | 1 | 8 | 3 | 29491 | 35 | |||
| 14934 | 66586 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 267 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | 9 | Permit Number 29776 | 6004192.59606 | 2091857.6961 | 37.7240804116702 | -122.427648104894 | (37.7240804116702, -122.427648104894) | 9 | 7 | 6 | 28861 | 5 | |
| 15081 | 31416 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4036 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 6 | Permit Number 35003 | 6001929.8185 | 2103551.20105 | 37.7560597982317 | -122.436306643531 | (37.7560597982317, -122.436306643531) | 2 | 4 | 5 | 28862 | 3 | |
| 15103 | 70103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 235 Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000491.71169 | 2091975.9188 | 37.7241949888819 | -122.440449937109 | (37.7241949888819, -122.440449937109) | 9 | 7 | 6 | 28861 | 25 | |||
| 15255 | 259404 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1443 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015439.42332 | 2092015.64337 | 37.7251438663465 | -122.388780227503 | (37.7251438663465, -122.388780227503) | 10 | 3 | 8 | 58 | 1 | ||
| 15266 | 62148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.8044108714347 | -122.446073454522 | (37.8044108714347, -122.446073454522) | 13 | 9 | 1 | 57 | 17 | |
| 15281 | 261514 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 535 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | 3 | 5983764.83173 | 2112189.27219 | 37.7787286289905 | -122.499764682948 | (37.7787286289905, -122.499764682948) | 11 | 6 | 2 | 55 | 26 | |||
| 15373 | 84395 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012475.47106 | 2099099.19515 | 37.7444291009223 | -122.399523461754 | (37.7444291009223, -122.399523461754) | 10 | 3 | 8 | 58 | 1 | |||
| 15439 | 52132 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4 | Permit Number 48314 | 6002447.9484 | 2111559.2112 | 37.7780772580819 | -122.435087505539 | (37.7780772580819, -122.435087505539) | 15 | 5 | 11 | 29492 | 41 | |
| 15442 | 48410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2002 12:00:00 AM | 4 | Permit Number 45790 | 5999879.07462 | 2118793.03652 | 37.7977932524078 | -122.444494158697 | (37.7977932524078, -122.444494158697) | 13 | 9 | 1 | 57 | 17 | |
| 15462 | 71581 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994022.88639 | 2086563.0023 | 37.7089619510012 | -122.462419116553 | (37.7089619510012, -122.462419116553) | 9 | 8 | 6 | 28861 | 25 | |||
| 15541 | 72268 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 382 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6002278.02989 | 2091405.67188 | 37.7227307711806 | -122.434234158593 | (37.7227307711806, -122.434234158593) | 9 | 7 | 6 | 28861 | 5 | |||
| 15632 | 72249 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 327 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002262.97318 | 2091806.41787 | 37.7238302751247 | -122.434314843048 | (37.7238302751247, -122.434314843048) | 9 | 7 | 6 | 28861 | 5 | |||
| 15682 | 79032 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1475 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6015238.0441 | 2092152.5097 | 37.7255085106933 | -122.389485934479 | (37.7255085106933, -122.389485934479) | 10 | 3 | 8 | 58 | 1 | |||
| 15689 | 84390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012549.35386 | 2099045.14684 | 37.7442848136983 | -122.399264195308 | (37.7442848136983, -122.399264195308) | 10 | 3 | 8 | 58 | 1 | |||
| 15877 | 72004 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1923 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987214.1384 | 2102168.3069 | 37.7514156316864 | -122.487096166595 | (37.7514156316864, -122.487096166595) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );