Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
355 | 355 | 182552 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2565 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986555.5107 | 2105693.4321 | 37.7610562355745 | -122.489632951355 | (37.7610562355745, -122.489632951355) | |||
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) | |||
473 | 473 | 142160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
485 | 485 | 142163 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490X Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
1104 | 1104 | 218512 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
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) | |||
1439 | 1439 | 185582 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2227 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982934.0602 | 2099947.7625 | 37.74506813637971 | -122.501732671769 | (37.7450681363797, -122.501732671769) | |||
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) | |||
1467 | 1467 | 246243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 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) | |||
1540 | 1540 | 251588 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990886.0 | 2105639.0 | 37.7611586563939 | -122.47465184359501 | (37.7611586563939, -122.474651843595) | ||||
1833 | 1833 | 251748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | ||||
1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
2022 | 2022 | 198027 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010199.0 | 2110711.0 | 37.7761853461059 | -122.40821387035 | (37.7761853461059, -122.40821387035) | |||
2106 | 2106 | 252882 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 726 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | ||||
2118 | 2118 | 252900 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 598 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | ||||
2119 | 2119 | 252901 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 598 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | ||||
2286 | 2286 | 252896 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
2287 | 2287 | 252897 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501x Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
2485 | 2485 | 241979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4.5x9 | 6007964.4907599995 | 2096517.14345 | 37.7370868837581 | -122.41493883176202 | (37.7370868837581, -122.414938831762) | |||
2548 | 2548 | 246850 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Broderick St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001250.58672 | 2109911.08695 | 37.773483861619894 | -122.43911144826099 | (37.7734838616199, -122.439111448261) | |||
2590 | 2590 | 253131 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003684.78158 | 2092034.78148 | 37.724537911193295 | -122.429416163945 | (37.7245379111933, -122.429416163945) | ||||
2805 | 2805 | 241582 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 38X Java St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999751.0 | 2107467.0 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | |||
2814 | 2814 | 241583 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 38X Java St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999751.0 | 2107467.0 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | |||
2837 | 2837 | 241584 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 38X Java St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999751.0 | 2107467.0 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | |||
2841 | 2841 | 241585 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 38X Java St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5999751.0 | 2107467.0 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | |||
2867 | 2867 | 253263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2425 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
3409 | 3409 | 180620 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6002386.3591599995 | 2087019.9409599998 | 37.71069467209271 | -122.43354641464501 | (37.7106946720927, -122.433546414645) | |||
3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
3439 | 3439 | 251741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
3642 | 3642 | 237734 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 120 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000607.58156 | 2105643.6338 | 37.7617298897441 | -122.44102947734899 | (37.7617298897441, -122.441029477349) | |||
3769 | 3769 | 136887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3772 | 3772 | 136889 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3784 | 3784 | 242020 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3154 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007751.06691 | 2106208.47613 | 37.7636851003982 | -122.41636297119 | (37.7636851003982, -122.41636297119) | |||
3785 | 3785 | 136888 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3880 | 3880 | 241545 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 116 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x12 | 6004745.13343 | 2097274.75809 | 37.7389856943281 | -122.426123530088 | (37.7389856943281, -122.426123530088) | |||
3882 | 3882 | 241544 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 116 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x12 | 6004777.35828 | 2097276.13496 | 37.7389912962031 | -122.426012209298 | (37.7389912962031, -122.426012209298) | |||
3889 | 3889 | 217588 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1490 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5995480.907000001 | 2092133.7981 | 37.7243418958878 | -122.45778285535101 | (37.7243418958878, -122.457782855351) | |||
4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
4861 | 4861 | 106723 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2891 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 4x3 | 5999685.7618 | 2114314.7923 | 37.785486140561105 | -122.444840997242 | (37.7854861405611, -122.444840997242) | |||
5142 | 5142 | 241731 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005457.0 | 2108414.0 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | |||
5213 | 5213 | 180235 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | |||
5214 | 5214 | 253835 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | ||||
6543 | 6543 | 137954 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | ||||
7756 | 7756 | 105526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998177.9524 | 2112999.2356 | 37.781787802518004 | -122.449962699898 | (37.781787802518, -122.449962699898) | |||
8068 | 8068 | 106333 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 319 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997602.34127 | 2115286.79464 | 37.7880358825085 | -122.452119136194 | (37.7880358825085, -122.452119136194) | |||
9982 | 9982 | 120898 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001048.0 | 2105186.0 | 37.7604984146453 | -122.439473444132 | (37.7604984146453, -122.439473444132) | |||
10076 | 10076 | 142645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | |||||
10115 | 10115 | 173855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5xt | 6002114.0 | 2086554.0 | 37.7093998431938 | -122.43445445536699 | (37.7093998431938, -122.434454455367) | ||||
11090 | 11090 | 96865 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5991908.438490001 | 2087239.0013 | 37.7106960939316 | -122.469776068222 | (37.7106960939316, -122.469776068222) | |||
11346 | 11346 | 112661 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2450 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | |||
11793 | 11793 | 120892 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | |||
12743 | 12743 | 96867 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5991882.45781 | 2087240.6995 | 37.710699255031294 | -122.46986598602301 | (37.7106992550313, -122.469865986023) | |||
12795 | 12795 | 105355 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 202X Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002020.25197 | 2093863.8275799998 | 37.729465676201 | -122.435300985665 | (37.729465676201, -122.435300985665) | |||
22292 | 22292 | 136869 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 870 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005850.85875 | 2112804.67339 | 37.781689632098896 | -122.423404163691 | (37.7816896320989, -122.423404163691) | |||
22373 | 22373 | 249319 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1424 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007287.0 | 2117809.0 | 37.795511234235704 | -122.41879079594 | (37.7955112342357, -122.41879079594) | ||||
22898 | 22898 | 251143 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014077.0 | 2112469.0 | 37.781228798518 | -122.39492187068599 | (37.781228798518, -122.394921870686) | ||||
22904 | 22904 | 242178 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 210 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004906.66959 | 2103998.29361 | 37.757456100932394 | -122.42604351650499 | (37.7574561009324, -122.426043516505) | |||
22983 | 22983 | 241570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 172 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5997494.28086 | 2107124.8182599996 | 37.765619029516294 | -122.451903941019 | (37.7656190295163, -122.451903941019) | |||
23396 | 23396 | 218586 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3666 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990534.77048 | 2091965.7217599999 | 37.7235950079882 | -122.474868513494 | (37.7235950079882, -122.474868513494) | |||
23582 | 23582 | 198071 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012594.42015 | 2106953.7966 | 37.7660027531583 | -122.399663543738 | (37.7660027531583, -122.399663543738) | |||
23592 | 23592 | 218660 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70 Eastwood Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5995653.32428 | 2093064.51564 | 37.726907327111 | -122.45725413468901 | (37.726907327111, -122.457254134689) | |||
23695 | 23695 | 241802 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4069 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003451.70402 | 2100663.61229 | 37.7482175139282 | -122.430837392227 | (37.7482175139282, -122.430837392227) | |||
23699 | 23699 | 214975 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 74 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997001.95686 | 2099159.0831400002 | 37.7437189044963 | -122.453031713353 | (37.7437189044963, -122.453031713353) | |||
23716 | 23716 | 241945 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 695 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005844.90589 | 2099124.7801599996 | 37.744127535760605 | -122.422452435454 | (37.7441275357606, -122.422452435454) | |||
23734 | 23734 | 241450 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 409 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002417.31188 | 2100896.14905 | 37.748797343719296 | -122.434430907784 | (37.7487973437193, -122.434430907784) | |||
23837 | 23837 | 242256 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006379.216440001 | 2110444.9043099997 | 37.77524008469361 | -122.421408658888 | (37.7752400846936, -122.421408658888) | |||
23883 | 23883 | 121766 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016283.00583 | 2101329.6444900003 | 37.7507649488554 | -122.386513163975 | (37.7507649488554, -122.386513163975) | |||
23894 | 23894 | 241993 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 255 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008029.48279 | 2100278.42716 | 37.7474181883996 | -122.41498026533199 | (37.7474181883996, -122.414980265332) | |||
23902 | 23902 | 199811 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1450 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015226.5388 | 2091885.1788 | 37.724773835160896 | -122.389507046325 | (37.7247738351609, -122.389507046325) | |||
23968 | 23968 | 241692 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 29 Lapidge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006008.32813 | 2105323.3773 | 37.7611566726504 | -122.422327681493 | (37.7611566726504, -122.422327681493) | |||
24003 | 24003 | 180323 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6001502.91955 | 2092324.6782 | 37.7252101301195 | -122.436979304073 | (37.7252101301195, -122.436979304073) | |||
24008 | 24008 | 139609 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1726 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001791.0282 | 2112231.2719 | 37.7798852435228 | -122.437408161561 | (37.7798852435228, -122.437408161561) | |||
24030 | 24030 | 136773 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5997087.63405 | 2115382.9814299997 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | |||
24059 | 24059 | 180255 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003484.65095 | 2094730.37892 | 37.73192808471529 | -122.4303002173 | (37.7319280847153, -122.4303002173) | |||
24065 | 24065 | 242257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006301.70753 | 2110434.24272 | 37.7752064401631 | -122.42167602284401 | (37.7752064401631, -122.421676022844) | |||
24128 | 24128 | 198134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013337.1330699995 | 2095632.7165299999 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | |||
24129 | 24129 | 241540 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004426.52656 | 2097222.39048 | 37.738823891899294 | -122.427221397276 | (37.7388238918993, -122.427221397276) | |||
24141 | 24141 | 141073 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996922.9152 | 2113039.6769999997 | 37.7818269517638 | -122.45430743935499 | (37.7818269517638, -122.454307439355) | |||
24145 | 24145 | 242053 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1502 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005844.94211 | 2100162.61029 | 37.7469771833576 | -122.422526041343 | (37.7469771833576, -122.422526041343) | |||
24197 | 24197 | 241524 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000866.95617 | 2103693.7987599997 | 37.756390889032396 | -122.43999259229099 | (37.7563908890324, -122.439992592291) | |||
24224 | 24224 | 121780 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016262.62034 | 2101684.40187 | 37.7517379101009 | -122.38660839408001 | (37.7517379101009, -122.38660839408) | |||
24249 | 24249 | 182189 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1597 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987107.5308 | 2104409.623 | 37.757563460583896 | -122.487629461955 | (37.7575634605839, -122.487629461955) | |||
24262 | 24262 | 242026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 802 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005509.62096 | 2098361.5942 | 37.7420130803359 | -122.423557529552 | (37.7420130803359, -122.423557529552) | |||
24276 | 24276 | 181974 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2480 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987699.3981 | 2098394.3042 | 37.7410815078969 | -122.48514122541401 | (37.7410815078969, -122.485141225414) | |||
24284 | 24284 | 245176 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1171 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001395.4012 | 2109700.3673 | 37.7729135172039 | -122.438595413606 | (37.7729135172039, -122.438595413606) | |||
24333 | 24333 | 241847 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 660 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007627.71 | 2096284.3417 | 37.7364287310983 | -122.416086756116 | (37.7364287310983, -122.416086756116) | |||
24336 | 24336 | 180377 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4225 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003448.494580001 | 2093862.26026 | 37.7295423784809 | -122.43036330203998 | (37.7295423784809, -122.43036330204) | |||
24340 | 24340 | 241638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005425.11854 | 2107744.6412400003 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | |||
24379 | 24379 | 241475 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 939 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6000376.8686 | 2101955.8656599997 | 37.751591035515496 | -122.441562769933 | (37.7515910355155, -122.441562769933) | |||
24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
24408 | 24408 | 242147 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 179 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001096.371180001 | 2105407.08892 | 37.761108223480605 | -122.43932199843799 | (37.7611082234806, -122.439321998438) | |||
24516 | 24516 | 180327 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000920.894780001 | 2092230.1433299999 | 37.7249174601452 | -122.43898452870899 | (37.7249174601452, -122.438984528709) | ||||
24535 | 24535 | 180343 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999619.38918 | 2092151.92628 | 37.724628555645104 | -122.443478054271 | (37.7246285556451, -122.443478054271) | |||
24567 | 24567 | 198168 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 415 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011056.24871 | 2113055.31332 | 37.782670247486294 | -122.40541353641198 | (37.7826702474863, -122.405413536412) |
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");