Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 4414 | 4414 | 1175 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2900 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 10:42:00 AM | 3 | 3X3 | 5996816.67595 | 2087452.1631200002 | 37.711563867747 | -122.452827563661 | (37.711563867747, -122.452827563661) | ||
| 4489 | 4489 | 253086 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:29:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4500 | 4500 | 253085 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:40:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4556 | 4556 | 136909 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.806170828478606 | -122.410261867902 | (37.8061708284786, -122.410261867902) | |||
| 4577 | 4577 | 143490 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 08:48:00 AM | 0 | Width 0ft | 6010035.0683 | 2119214.1514 | 37.7995237814105 | -122.40938118017401 | (37.7995237814105, -122.409381180174) | ||
| 4578 | 4578 | 136910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2210 Stockton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6009806.2153 | 2121790.84358 | 37.8065859141719 | -122.410355131177 | (37.8065859141719, -122.410355131177) | |||
| 4691 | 4691 | 15528 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2792 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:40:00 AM | 3 | 3X3 | 6007034.2153 | 2102142.536 | 37.752480630640605 | -122.41855400595101 | (37.7524806306406, -122.418554005951) | ||
| 4785 | 4785 | 18290 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/1992 12:00:00 AM | 6 | 4X4 | 6002339.9537 | 2114048.2121 | 37.784905293391795 | -122.43563921223101 | (37.7849052933918, -122.435639212231) | ||
| 4837 | 4837 | 86169 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1393 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2017 07:03:00 PM | 3 | 3x3 | 5988639.6168 | 2105878.5637 | 37.761686013326894 | -122.482438582138 | (37.7616860133269, -122.482438582138) | ||
| 5292 | 5292 | 14530 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999227.9935 | 2110423.9359 | 37.774776718941105 | -122.44614476286999 | (37.7747767189411, -122.44614476287) | |||
| 5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
| 5493 | 5493 | 22601 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005919.22221 | 2112752.51326 | 37.781550271357204 | -122.42316394935601 | (37.7815502713572, -122.423163949356) | |||
| 5745 | 5745 | 18285 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002494.2739 | 2114068.183 | 37.784968892425496 | -122.435106743694 | (37.7849688924255, -122.435106743694) | |||
| 5967 | 5967 | 6877 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 240 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2002 12:00:00 AM | 12 | 3X3 | 6006250.63337 | 2110777.45516 | 37.7761459385303 | -122.42187708516899 | (37.7761459385303, -122.421877085169) | ||
| 6033 | 6033 | 6956 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 618 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004409.9923 | 2110521.0663 | 37.7753379822624 | -122.428226083232 | (37.7753379822624, -122.428226083232) | ||
| 6102 | 6102 | 18286 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002462.1995 | 2114065.7623 | 37.7849604244555 | -122.435217537512 | (37.7849604244555, -122.435217537512) | ||
| 6123 | 6123 | 22781 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1860 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/1997 12:00:00 AM | 6 | 3X3 | 6001097.5794 | 2112139.8111 | 37.7795946678368 | -122.439800543691 | (37.7795946678368, -122.439800543691) | ||
| 6149 | 6149 | 14526 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 637 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999136.9105 | 2110609.5392 | 37.775281136182606 | -122.446473192139 | (37.7752811361826, -122.446473192139) | |||
| 6166 | 6166 | 93399 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999866.7618 | 2111912.817 | 37.7789012639267 | -122.44404214236 | (37.7789012639267, -122.44404214236) | ||
| 6490 | 6490 | 8647 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2761 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5998533.8029 | 2113119.8829 | 37.7821394236041 | -122.448740321446 | (37.7821394236041, -122.448740321446) | |||
| 6518 | 6518 | 97735 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.978999999 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) |
| 6545 | 6545 | 18287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1990 12:00:00 AM | 6 | 4X4 | 6002436.1769 | 2114064.5519 | 37.7849556232365 | -122.435307480647 | (37.7849556232365, -122.435307480647) | ||
| 6601 | 6601 | 8611 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2486 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/1999 12:00:00 AM | 3 | 3X3 | 5999862.6992 | 2113354.3551 | 37.7828591248206 | -122.444159809177 | (37.7828591248206, -122.444159809177) | ||
| 6811 | 6811 | 93401 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999912.1103 | 2111918.5701 | 37.7789196472896 | -122.443885677827 | (37.7789196472896, -122.443885677827) | ||
| 6895 | 6895 | 6225 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1220 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6005060.4446 | 2113384.1056 | 37.783235967029206 | -122.426179889067 | (37.7832359670292, -122.426179889067) | |||
| 7060 | 7060 | 18284 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/1992 12:00:00 AM | 6 | 4X4 | 6002520.9017 | 2114071.8140000002 | 37.784980374208104 | -122.43501487991301 | (37.7849803742081, -122.435014879913) | ||
| 7237 | 7237 | 6949 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004493.7 | 2110528.4326 | 37.7753629442722 | -122.42793704383699 | (37.7753629442722, -122.427937043837) | ||
| 7514 | 7514 | 14490 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998985.0486 | 2111710.2278 | 37.7782946690144 | -122.44707774367399 | (37.7782946690144, -122.447077743674) | |||
| 7861 | 7861 | 8161 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1102 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002408.427999999 | 2111279.278 | 37.7773063874437 | -122.43520419289699 | (37.7773063874437, -122.435204192897) | |||
| 7880 | 7880 | 22767 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1686 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2003 12:00:00 AM | 3 | 4X4 | 6001987.8205 | 2112260.207 | 37.779975877853296 | -122.43672944267401 | (37.7799758778533, -122.436729442674) | ||
| 7890 | 7890 | 6910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 368 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005671.181 | 2110697.5154 | 37.7758937479577 | -122.423875883731 | (37.7758937479577, -122.423875883731) | ||
| 8023 | 8023 | 93398 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2299 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999064.1945 | 2111800.6301 | 37.778547412076605 | -122.446810456436 | (37.7785474120766, -122.446810456436) | ||
| 8139 | 8139 | 26934 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1590 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6002010.1563 | 2111919.4162 | 37.7790414215793 | -122.436627772948 | (37.7790414215793, -122.436627772948) | |||
| 8323 | 8323 | 8158 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1086 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002587.9005 | 2111305.7426 | 37.7773892425571 | -122.434585232983 | (37.7773892425571, -122.434585232983) | ||
| 8574 | 8574 | 26199 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005870.33887 | 2112746.1622900004 | 37.7815300743983 | -122.42333261090799 | (37.7815300743983, -122.423332610908) | |||
| 8720 | 8720 | 22649 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003938.1475 | 2112482.5866 | 37.7806971228818 | -122.429998257146 | (37.7806971228818, -122.429998257146) | |||
| 8869 | 8869 | 18295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002211.6561 | 2114031.8723 | 37.7848531404575 | -122.43608191019699 | (37.7848531404575, -122.436081910197) | ||
| 8980 | 8980 | 17002 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999484.07976 | 2121214.10704 | 37.8044183160192 | -122.446035175776 | (37.8044183160192, -122.446035175776) | |||
| 9015 | 9015 | 22602 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005851.84947 | 2112745.07106 | 37.78152603462821 | -122.423396497843 | (37.7815260346282, -122.423396497843) | |||
| 9021 | 9021 | 14488 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998978.3148 | 2111745.3393 | 37.778390691402 | -122.447103565775 | (37.778390691402, -122.447103565775) | |||
| 9512 | 9512 | 19511 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000658.415 | 2112657.2603 | 37.7809904437075 | -122.44135693728902 | (37.7809904437075, -122.441356937289) | |||
| 9728 | 9728 | 173660 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1252 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6004044.0 | 2112543.0 | 37.7808689972899 | -122.429636372405 | (37.7808689972899, -122.429636372405) | |||
| 9731 | 9731 | 173661 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1252 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6004044.0 | 2112543.0 | 37.7808689972899 | -122.429636372405 | (37.7808689972899, -122.429636372405) | |||
| 9796 | 9796 | 11975 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 10048 | 10048 | 8607 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2428 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2013 12:00:00 AM | 3 | 3x3 | 6000088.3544 | 2113383.7236 | 37.7829526339517 | -122.443381249115 | (37.7829526339517, -122.443381249115) | ||
| 10271 | 10271 | 23679 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/22/1996 12:00:00 AM | 3 | 3X3 | 6006873.81307 | 2098156.36278 | 37.741526467966104 | -122.41882602631901 | (37.7415264679661, -122.418826026319) | ||
| 10307 | 10307 | 86419 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2315 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988234.1046 | 2099528.0173 | 37.7442255186266 | -122.483375515142 | (37.7442255186266, -122.483375515142) | ||
| 10318 | 10318 | 85892 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2450 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988312.1108 | 2098619.8624 | 37.741736504024104 | -122.483039240723 | (37.7417365040241, -122.483039240723) | ||
| 10331 | 10331 | 85901 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2282 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099782.4008 | 37.7449259990071 | -122.48327470902399 | (37.7449259990071, -122.483274709024) | ||
| 10341 | 10341 | 15974 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.8422700001 | 37.708425499112394 | -122.453517403906 | (37.7084254991124, -122.453517403906) | ||
| 10360 | 10360 | 26292 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999828.34203 | 2092450.5563700001 | 37.725460439341 | -122.442777166756 | (37.725460439341, -122.442777166756) | ||
| 10361 | 10361 | 85899 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2318 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988279.9607 | 2099513.9728 | 37.744189624849895 | -122.48321592732201 | (37.7441896248499, -122.483215927322) | ||
| 10363 | 10363 | 26319 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2021 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999671.6195 | 2092116.9094 | 37.7245353858939 | -122.443294987371 | (37.7245353858939, -122.443294987371) | |||
| 10390 | 10390 | 15866 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5425 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999452.413380001 | 2088067.62767 | 37.7134044805159 | -122.44376197563801 | (37.7134044805159, -122.443761975638) | ||
| 10394 | 10394 | 86079 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2321 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987612.7621 | 2099475.5619 | 37.7440453083682 | -122.48552010724701 | (37.7440453083682, -122.485520107247) | ||
| 10406 | 10406 | 85906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2254 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988263.956 | 2099971.0192 | 37.7454436220707 | -122.483304764 | (37.7454436220707, -122.483304764) | ||
| 10412 | 10412 | 85909 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2234 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988258.4084 | 2100094.7734 | 37.745783095491 | -122.483333016616 | (37.745783095491, -122.483333016616) | ||
| 10413 | 10413 | 86491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | ||
| 10425 | 10425 | 86502 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987758.3934 | 2105633.7162 | 37.760962426895105 | -122.48546837116999 | (37.7609624268951, -122.48546837117) | ||
| 10431 | 10431 | 26328 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1857 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000421.70721 | 2093270.90592 | 37.7277467399142 | -122.440784780799 | (37.7277467399142, -122.440784780799) | |||
| 10437 | 10437 | 115185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | ||||
| 10439 | 10439 | 85915 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1842 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988172.4166 | 2102753.7471 | 37.7530789231841 | -122.483825289739 | (37.7530789231841, -122.483825289739) | ||
| 10442 | 10442 | 26317 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | ||
| 10458 | 10458 | 86423 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2375 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 5 | 3x3 | 5988246.7954 | 2099163.0294 | 37.7432240967268 | -122.48330488393101 | (37.7432240967268, -122.483304883931) | ||
| 10471 | 10471 | 85976 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2366 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987669.9554 | 2099192.3029 | 37.743270886293395 | -122.48530156746 | (37.7432708862934, -122.48530156746) | ||
| 10476 | 10476 | 86185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1711 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 5988711.8007 | 2103655.3081 | 37.755585752564 | -122.482026056094 | (37.755585752564, -122.482026056094) | ||
| 10480 | 10480 | 86529 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1495 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987733.4428 | 2105147.1779 | 37.7596250718264 | -122.485518957406 | (37.7596250718264, -122.485518957406) | ||
| 10496 | 10496 | 26330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1819 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 3 | 3X3 | 6000559.89469 | 2093519.29133 | 37.728436617934605 | -122.440324871112 | (37.7284366179346, -122.440324871112) | ||
| 10515 | 10515 | 26289 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999881.61737 | 2092526.205 | 37.725671190068795 | -122.44259842829901 | (37.7256711900688, -122.442598428299) |
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");