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) | ||||
| 2953 | 2953 | 192045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.39786558493401 | (37.7746734191738, -122.397865584934) | |
| 2963 | 2963 | 192048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.5616599997 | 37.7748746334969 | -122.39761573260401 | (37.7748746334969, -122.397615732604) | |
| 2964 | 2964 | 192047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.399669999 | 2110155.0455099996 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | |
| 2979 | 2979 | 192049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.505969999 | 2110186.9808900002 | 37.77491796101779 | -122.397555323332 | (37.7749179610178, -122.397555323332) | |
| 2980 | 2980 | 192046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.774723291973096 | -122.39779074965 | (37.7747232919731, -122.39779074965) | |
| 3009 | 3009 | 192050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.39749938908501 | (37.774962173497, -122.397499389085) | |
| 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) | ||||
| 3449 | 3449 | 71297 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1943 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1987 12:00:00 AM | 9 | 3x3 | 6000711.2858 | 2112029.2136 | 37.7792689994665 | -122.441128958799 | (37.7792689994665, -122.441128958799) | ||
| 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) | |||
| 3936 | 3936 | 162839 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 93 Lee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:47:00 PM | 3 | Width 0ft | 5996489.12925 | 2090422.7044 | 37.719701506488 | -122.45417406278 | (37.719701506488, -122.45417406278) | ||
| 3952 | 3952 | 214100 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:56:00 PM | 3 | Width 3ft | 5996085.5249 | 2091194.1399299998 | 37.7217965338776 | -122.455624901296 | (37.7217965338776, -122.455624901296) | ||
| 3966 | 3966 | 162837 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 93 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:45:00 PM | 3 | Width 0ft | 5996490.20917 | 2090455.8643 | 37.7197926177076 | -122.45417272368601 | (37.7197926177076, -122.454172723686) | ||
| 3977 | 3977 | 162840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 79 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:54:00 PM | 3 | Width 0ft | 5996488.6057 | 2090397.63567 | 37.71963264362321 | -122.45417406280501 | (37.7196326436232, -122.454174062805) | ||
| 3983 | 3983 | 216874 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 638 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 03:16:00 PM | 3 | Width 3ft | 5995925.14157 | 2089161.4426799999 | 37.7162060215686 | -122.456032419169 | (37.7162060215686, -122.456032419169) | ||
| 4000 | 4000 | 159212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:30:00 AM | 3 | Width 0ft | 5998913.8827 | 2087989.6693 | 37.7131596931403 | -122.445617716786 | (37.7131596931403, -122.445617716786) | ||
| 4019 | 4019 | 159214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Ellington Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:15:00 AM | 3 | Width 0ft | 5998893.94136 | 2087968.62584 | 37.713100774055 | -122.44568512818199 | (37.713100774055, -122.445685128182) | ||
| 4029 | 4029 | 159224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 384 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:27:00 AM | 3 | Width 0ft | 5998600.7872 | 2087691.66315 | 37.7123235556611 | -122.44667844826701 | (37.7123235556611, -122.446678448267) | ||
| 4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
| 4043 | 4043 | 216875 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 668 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:30:00 PM | 3 | Width 3ft | 5995926.39205 | 2089208.92779 | 37.7163364763159 | -122.456031527941 | (37.7163364763159, -122.456031527941) | ||
| 4044 | 4044 | 159331 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 562 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:06:00 AM | 3 | Width 0ft | 5997894.14042 | 2087019.0117 | 37.7104362168201 | -122.449072394069 | (37.7104362168201, -122.449072394069) | ||
| 4136 | 4136 | 216727 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 78 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:54:00 AM | 3 | Width 3ft | 5995351.20141 | 2090413.7990299999 | 37.7196117361844 | -122.458106803489 | (37.7196117361844, -122.458106803489) | ||
| 4140 | 4140 | 216837 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:34:00 PM | 3 | Width 3ft | 5994365.2203 | 2088384.89347 | 37.713984142135104 | -122.461367955672 | (37.7139841421351, -122.461367955672) | ||
| 4188 | 4188 | 181057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | ||
| 4211 | 4211 | 136890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | ||
| 4217 | 4217 | 216856 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 269 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:36:00 AM | 3 | Width 3ft | 5994294.27802 | 2087746.4954799998 | 37.712227169014604 | -122.461566901007 | (37.7122271690146, -122.461566901007) | ||
| 4259 | 4259 | 252872 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | ||
| 4274 | 4274 | 252887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:23:00 PM | 3 | 3x3 | 5997288.0 | 2090319.0 | 37.719462535966294 | -122.45140518978998 | (37.7194625359663, -122.45140518979) | ||
| 4324 | 4324 | 251737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872.0 | 2086877.0 | 37.7103297297312 | -122.43185773233601 | (37.7103297297312, -122.431857732336) | ||
| 4357 | 4357 | 180599 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 130 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:49:00 AM | 3 | Width 2ft | 6004241.29986 | 2094286.4256099998 | 37.73075191805779 | -122.427652702223 | (37.7307519180578, -122.427652702223) | ||
| 4365 | 4365 | 252899 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390 San Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:05:00 PM | 3 | 3x3 | 5997900.0 | 2090079.0 | 37.7188385770119 | -122.449272458694 | (37.7188385770119, -122.449272458694) | ||
| 4366 | 4366 | 251751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 4382 | 4382 | 180600 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 142 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:52:00 AM | 3 | Width 2ft | 6004316.23114 | 2094289.2988 | 37.7307640454079 | -122.427393857542 | (37.7307640454079, -122.427393857542) | ||
| 4394 | 4394 | 251740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 240 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:43:00 AM | 3 | 3x3 | 6002635.0 | 2086674.0 | 37.709758897844296 | -122.432662361521 | (37.7097588978443, -122.432662361521) | ||
| 4396 | 4396 | 251750 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 4433 | 4433 | 180628 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.710390087913794 | -122.43495675757299 | (37.7103900879138, -122.434956757573) | ||
| 4466 | 4466 | 180840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:05:00 PM | 3 | Width 2ft | 5997679.45955 | 2086959.0123599998 | 37.7102591915804 | -122.449810052203 | (37.7102591915804, -122.449810052203) | ||
| 4469 | 4469 | 162767 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 910 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:46:00 AM | 3 | Width 0ft | 5995047.74881 | 2089994.6551299999 | 37.7184434259931 | -122.459125388251 | (37.7184434259931, -122.459125388251) | ||
| 4473 | 4473 | 180841 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:10:00 PM | 3 | Width 2ft | 5997726.08242 | 2086911.31353 | 37.710130888906896 | -122.449645479868 | (37.7101308889069, -122.449645479868) | ||
| 4503 | 4503 | 162771 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 954 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:37:00 AM | 3 | Width 0ft | 5995054.32818 | 2090275.3089700001 | 37.7192144129887 | -122.45912295737301 | (37.7192144129887, -122.459122957373) | ||
| 4509 | 4509 | 162768 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 914 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:51:00 AM | 3 | Width 0ft | 5995049.36731 | 2090021.5803099999 | 37.7185174491889 | -122.4591217424 | (37.7185174491889, -122.4591217424) | ||
| 4514 | 4514 | 162766 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 906 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:33:00 AM | 3 | Width 0ft | 5995047.57993 | 2089969.8003900002 | 37.7183751710697 | -122.459124173239 | (37.7183751710697, -122.459124173239) | ||
| 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) | |||
| 8119 | 8119 | 93480 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.467119999 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | |
| 8830 | 8830 | 71801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2170 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | 5997504.5785 | 2109900.8998 | 37.77324202696929 | -122.452068634732 | (37.7732420269693, -122.452068634732) | ||
| 9905 | 9905 | 136907 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779330 | 6011790.69425 | 2119110.61996 | 37.7993377175325 | -122.40329876353901 | (37.7993377175325, -122.403298763539) | |
| 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) | ||||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 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) | |||
| 11727 | 11727 | 105903 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 22 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011210.988390001 | 2087529.97721 | 37.71259187470061 | -122.40308219600901 | (37.7125918747006, -122.403082196009) |
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");