Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 100 | 106679 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2014 12:00:00 AM | 10 | 3x3 | Permit Number 773028 | 5999374.7893199995 | 2116379.94206 | 37.7911387486163 | -122.44606546047702 | (37.7911387486163, -122.446065460477) | |
| 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) | ||
| 1024 | 1024 | 97943 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3003 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768278 | 5999754.4115699995 | 2116356.69568 | 37.791096591089 | -122.44475031260099 | (37.791096591089, -122.444750312601) | |
| 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) | ||||
| 1180 | 1180 | 251470 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.0846799999 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | |
| 1240 | 1240 | 241867 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 633 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1987 12:00:00 AM | 8 | Width 2ft | Permit Number 24800 | 6008703.52023 | 2095884.2711099999 | 37.735390653541295 | -122.412338944781 | (37.7353906535413, -122.412338944781) | |
| 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) | ||||
| 1582 | 1582 | 45051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43936 | 5988218.295 | 2100043.5647 | 37.7456401553342 | -122.483467967859 | (37.7456401553342, -122.483467967859) | |
| 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) | |||
| 1697 | 1697 | 42640 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.42583071712299 | (37.7982497015198, -122.425830717123) |
| 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) | |||
| 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) | |||
| 2072 | 2072 | 136839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1911 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | Width 4ft | Permit Number 52344 | 6003883.81928 | 2118306.5649 | 37.7966852175075 | -122.43060190297199 | (37.7966852175075, -122.430601902972) | |
| 2084 | 2084 | 200756 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1698 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 07/23/2010 12:00:00 AM | 2 | Width 0ft | Permit Number 53643 | 6014807.3749 | 2094642.3361 | 37.732321185493 | -122.39114868869899 | (37.732321185493, -122.391148688699) | |
| 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) | ||||
| 2152 | 2152 | 242277 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 117 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 46994 | 6001802.4938199995 | 2096648.3509099998 | 37.7370989679366 | -122.43625299088801 | (37.7370989679366, -122.436252990888) | |
| 2244 | 2244 | 34670 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2001X Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 38339 | 6003296.78192 | 2118922.23396 | 37.798342411735604 | -122.432677184799 | (37.7983424117356, -122.432677184799) | |
| 2245 | 2245 | 5919 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2007 12:00:00 AM | 12 | 3x3 | Permit Number 52201 | 6004140.9874 | 2112910.1496 | 37.7818825900403 | -122.42932703435 | (37.7818825900403, -122.42932703435) | |
| 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) | ||
| 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) | |
| 3101 | 3101 | 102774 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 31200 | 6005947.91695 | 2119337.23456 | 37.7996318920616 | -122.42353296190201 | (37.7996318920616, -122.423532961902) | ||
| 3186 | 3186 | 218743 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.5324099995 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | |
| 3298 | 3298 | 28315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.9906200003 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | |
| 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) | ||||
| 3512 | 3512 | 241416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1985 12:00:00 AM | 12 | Width 2ft | Permit Number 22471 | 6004614.54132 | 2095950.25242 | 37.7353415190975 | -122.42648077318 | (37.7353415190975, -122.42648077318) | |
| 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) |
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");