Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker
qCareAssistant ✖
PlantType ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
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) | |||
390 | 390 | 251276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/09/1998 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
391 | 391 | 251275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/16/2011 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
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) | |||
546 | 546 | 12251 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | ||
677 | 677 | 107511 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.43851754404601 | (37.8004637136911, -122.438517544046) | ||
679 | 679 | 187631 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | |
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) | |||
873 | 873 | 93400 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999886.3903 | 2111916.5396 | 37.7789126049307 | -122.44397450733601 | (37.7789126049307, -122.443974507336) | ||
982 | 982 | 18283 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | ||
1082 | 1082 | 22639 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6004184.7636 | 2112567.9201 | 37.780945391127 | -122.429151179613 | (37.780945391127, -122.429151179613) | ||
1094 | 1094 | 251442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
1097 | 1097 | 251443 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
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) | |||
1118 | 1118 | 26811 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001133.0786 | 2112143.4834 | 37.7796067716282 | -122.43967800032301 | (37.7796067716282, -122.439678000323) | |||
1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
1325 | 1325 | 141834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | |||
1344 | 1344 | 141858 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1110 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004615.4703 | 2112626.4811 | 37.781130557433706 | -122.427665325896 | (37.7811305574337, -122.427665325896) | |||
1354 | 1354 | 14491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999051.991 | 2111710.9656 | 37.77830051932229 | -122.446846219186 | (37.7783005193223, -122.446846219186) | |||
1373 | 1373 | 10189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1153 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2017 12:00:00 AM | 3 | 2x3 | 6005799.04863 | 2102230.07657 | 37.752651382065395 | -122.42283164626998 | (37.7526513820654, -122.42283164627) | ||
1436 | 1436 | 251534 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226.0 | 2102732.0 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | ||
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) | |||
1445 | 1445 | 22600 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.78154623162111 | -122.42327383483999 | (37.7815462316211, -122.42327383484) | |||
1447 | 1447 | 139887 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | Width 0ft | 6002626.7608 | 2112299.1255 | 37.7801190291536 | -122.434521848172 | (37.7801190291536, -122.434521848172) | ||
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) | |||
1460 | 1460 | 139886 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 7 | Width 0ft | 6002599.6871 | 2112295.0644 | 37.78010634148521 | -122.434615217822 | (37.7801063414852, -122.434615217822) | ||
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) | |||
1469 | 1469 | 247378 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1991 12:00:00 AM | 5 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | ||
1482 | 1482 | 140438 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003482.3387 | 2112124.8891 | 37.779689150174704 | -122.43154957445299 | (37.7796891501747, -122.431549574453) | |||
1531 | 1531 | 5189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 509 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001637.7109 | 2110249.8513 | 37.7744360439082 | -122.43779659970501 | (37.7744360439082, -122.437796599705) | |||
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) | ||||
1649 | 1649 | 251584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
1725 | 1725 | 24940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2733 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X3 | 5998612.3168 | 2113129.3587 | 37.782169931054604 | -122.44846938258301 | (37.7821699310546, -122.448469382583) | ||
1758 | 1758 | 251601 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
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) | ||||
1940 | 1940 | 139586 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000731.3449 | 2112139.6442 | 37.779573356306 | -122.44106749101401 | (37.779573356306, -122.441067491014) | |||
1941 | 1941 | 139579 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1920 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 2 | Width 0ft | 6000679.6696 | 2112100.9749 | 37.779464236796606 | -122.4412434823 | (37.7794642367966, -122.4412434823) | ||
1942 | 1942 | 139585 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000729.6528 | 2112161.6416 | 37.7796336591807 | -122.4410749233 | (37.7796336591807, -122.4410749233) | |||
1944 | 1944 | 139582 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1920 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 2 | Width 0ft | 6000588.1654 | 2112088.9415 | 37.779425983334 | -122.441559169487 | (37.779425983334, -122.441559169487) | ||
1952 | 1952 | 139587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | |||
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) | ||||
2301 | 2301 | 22734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1990 12:00:00 AM | 18 | 3X3 | 6002510.1745 | 2112337.5363 | 37.780217876703794 | -122.434927920426 | (37.7802178767038, -122.434927920426) | ||
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) | ||||
2698 | 2698 | 21631 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004720.5557 | 2114675.0873 | 37.7867614641574 | -122.427447768121 | (37.7867614641574, -122.427447768121) | ||
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) | ||||
2896 | 2896 | 253266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992016.868969999 | 2094311.4593 | 37.730121598969205 | -122.469915916098 | (37.7301215989692, -122.469915916098) | |||
2928 | 2928 | 18294 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2005 12:00:00 AM | 3 | 4X4 | 6002231.627 | 2114034.293 | 37.7848609216487 | -122.436012990755 | (37.7848609216487, -122.436012990755) | ||
3321 | 3321 | 140459 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 5 | Width 0ft | 6003139.0674 | 2112416.8164 | 37.7804712472963 | -122.432757957966 | (37.7804712472963, -122.432757957966) | ||
3325 | 3325 | 140465 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2001 12:00:00 AM | 4 | Width 0ft | 6002943.0868 | 2112390.4269 | 37.780387671465505 | -122.433434060142 | (37.7803876714655, -122.433434060142) | ||
3327 | 3327 | 140458 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | Width 0ft | 6003273.7425 | 2112436.298 | 37.7805323760013 | -122.432293445455 | (37.7805323760013, -122.432293445455) | ||
3332 | 3332 | 140463 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | Width 0ft | 6003009.4486 | 2112400.1289 | 37.7804180754921 | -122.43320517732201 | (37.7804180754921, -122.433205177322) | ||
3352 | 3352 | 140464 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 4 | Width 0ft | 6002964.8193 | 2112393.1435 | 37.780396363522 | -122.433359071525 | (37.780396363522, -122.433359071525) | ||
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) | |||
3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3757 | 3757 | 6923 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.775739063409794 | -122.425084363796 | (37.7757390634098, -122.425084363796) | |||
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) | |||
3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3863 | 3863 | 6898 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005831.3408 | 2110713.462 | 37.775946573797995 | -122.423322982857 | (37.775946573798, -122.423322982857) | ||
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) | |||
4040 | 4040 | 253539 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 7 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
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) | ||
4075 | 4075 | 1149 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2678 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2017 08:44:00 AM | 3 | 3X3 | 5998020.45993 | 2088357.3562599998 | 37.7141182292418 | -122.448732141877 | (37.7141182292418, -122.448732141877) | ||
4116 | 4116 | 253537 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 5 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
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) |
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");