Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 10517 | 10517 | 86315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1567 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988369.7738 | 2104644.5921 | 37.7582821611406 | -122.483281391745 | (37.7582821611406, -122.483281391745) | ||
| 10522 | 10522 | 86133 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1606 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2007 12:00:00 AM | 3 | 3x3 | 5988734.1396 | 2104367.6919 | 37.757543066101206 | -122.482000985871 | (37.7575430661012, -122.482000985871) | ||
| 10556 | 10556 | 26324 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1923 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 3 | 2X2 | 6000151.26449 | 2092808.65787 | 37.7264621078328 | -122.44168654361401 | (37.7264621078328, -122.441686543614) | ||
| 10601 | 10601 | 15848 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5262 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/1995 12:00:00 AM | 12 | 3X3 | 5999882.62538 | 2088644.4129 | 37.715012731824004 | -122.442316398192 | (37.715012731824, -122.442316398192) | ||
| 10604 | 10604 | 85886 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2554 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988334.5039 | 2097925.2606 | 37.7398306126335 | -122.48291091869899 | (37.7398306126335, -122.482910918699) | ||
| 10606 | 10606 | 86484 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1698 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987824.3728 | 2103790.6728 | 37.75590577449189 | -122.48510495178002 | (37.7559057744919, -122.48510495178) | ||
| 10630 | 10630 | 85904 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2266 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988264.8095 | 2099896.34 | 37.745238622413396 | -122.48329633951799 | (37.7452386224134, -122.483296339518) | ||
| 10660 | 10660 | 15759 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4723 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/2015 07:55:00 AM | 1 | 3x3 | 6001700.9491 | 2091384.4332 | 37.722639683537295 | -122.43622747977699 | (37.7226396835373, -122.436227479777) | ||
| 10670 | 10670 | 86131 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1646 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2007 12:00:00 AM | 3 | 3x3 | 5988742.0508 | 2104105.9628 | 37.7568248885638 | -122.481954453758 | (37.7568248885638, -122.481954453758) | ||
| 10677 | 10677 | 86126 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1678 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2007 12:00:00 AM | 3 | 3x3 | 5988749.962 | 2103906.864 | 37.756278676893004 | -122.481912510186 | (37.756278676893, -122.481912510186) | ||
| 10777 | 10777 | 15856 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5344 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2011 12:00:00 AM | 3 | 3X3 | 5999603.85963 | 2088336.9506 | 37.714152617515396 | -122.44325785797501 | (37.7141526175154, -122.443257857975) | ||
| 10795 | 10795 | 85898 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2330 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988283.345 | 2099439.52 | 37.743985394057205 | -122.483198768994 | (37.7439853940572, -122.483198768994) | ||
| 10807 | 10807 | 86422 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988244.7649 | 2099187.3957 | 37.7432908819935 | -122.483313690553 | (37.7432908819935, -122.483313690553) | ||
| 10829 | 10829 | 15850 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5300 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/1995 12:00:00 AM | 6 | 3X3 | 5999720.51784 | 2088467.06066 | 37.714516521901395 | -122.44286398100901 | (37.7145165219014, -122.442863981009) | ||
| 10831 | 10831 | 15880 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5550 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3X3 | 5998971.33696 | 2087620.6531099998 | 37.712149738304504 | -122.445392619177 | (37.7121497383045, -122.445392619177) | ||
| 10878 | 10878 | 85963 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2562 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987716.7021 | 2097844.1824 | 37.7395720262586 | -122.485041043591 | (37.7395720262586, -122.485041043591) | ||
| 10880 | 10880 | 86487 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1654 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.2064 | 2104044.7342 | 37.7566026495976 | -122.48516566702 | (37.7566026495976, -122.48516566702) | ||
| 10883 | 10883 | 85965 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2538 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987711.4993 | 2097992.8541 | 37.739979936579296 | -122.485069937451 | (37.7399799365793, -122.485069937451) | ||
| 10891 | 10891 | 86489 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1642 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987810.0594 | 2104111.2911 | 37.7567852717409 | -122.485177975352 | (37.7567852717409, -122.485177975352) | ||
| 10896 | 10896 | 86428 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2523 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988281.3101 | 2098130.7178 | 37.74039164898279 | -122.483109893694 | (37.7403916489828, -122.483109893694) | ||
| 10902 | 10902 | 85926 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1726 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988143.554 | 2103529.5694 | 37.755207442281495 | -122.483981986678 | (37.7552074422815, -122.483981986678) | ||
| 10936 | 10936 | 85887 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2550 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988333.3781 | 2097953.6869 | 37.7399085983061 | -122.48291689400801 | (37.7399085983061, -122.482916894008) | ||
| 10965 | 10965 | 85900 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2290 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988270.7838 | 2099732.8991 | 37.744790204595496 | -122.483263703268 | (37.7447902045955, -122.483263703268) | ||
| 10983 | 10983 | 86424 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2405 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988256.4404 | 2098894.4917 | 37.7424873242353 | -122.48325185431601 | (37.7424873242353, -122.483251854316) | ||
| 11024 | 11024 | 86430 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2551 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988286.0948 | 2097955.3756 | 37.739910483672 | -122.483080501702 | (37.739910483672, -122.483080501702) | ||
| 11083 | 11083 | 86403 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1719 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988092.6268 | 2103574.9464 | 37.7553290702963 | -122.484161433351 | (37.7553290702963, -122.484161433351) | ||
| 11088 | 11088 | 86180 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1631 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988695.1715 | 2104201.3368 | 37.757084033370795 | -122.48212356471399 | (37.7570840333708, -122.482123564714) | ||
| 11097 | 11097 | 86522 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1391 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987709.9444 | 2105829.3334 | 37.7614967154267 | -122.485650289777 | (37.7614967154267, -122.485650289777) | ||
| 11099 | 11099 | 85971 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2450 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987691.276000001 | 2098592.281 | 37.7416246268236 | -122.48518383104499 | (37.7416246268236, -122.485183831045) | ||
| 11125 | 11125 | 15842 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999889.83361 | 2088564.50035 | 37.7147937208238 | -122.442285750192 | (37.7147937208238, -122.442285750192) | |||
| 11128 | 11128 | 86081 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2355 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987620.8843 | 2099266.7556 | 37.743472454852096 | -122.48547670287701 | (37.7434724548521, -122.485476702877) | ||
| 11136 | 11136 | 86312 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1551 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988369.2881 | 2104746.5916 | 37.7585621958971 | -122.48329054831899 | (37.7585621958971, -122.483290548319) | ||
| 11140 | 11140 | 26332 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1813 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 3 | 3X3 | 6000593.70734 | 2093580.7616299998 | 37.7286073263494 | -122.44021238571399 | (37.7286073263494, -122.440212385714) | ||
| 11162 | 11162 | 85985 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2310 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987659.1259 | 2099535.4626 | 37.7442124809785 | -122.485364188291 | (37.7442124809785, -122.485364188291) | ||
| 11166 | 11166 | 112236 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/2015 08:45:00 AM | 3 | 5999186.55259 | 2088995.9330400003 | 37.7159382286299 | -122.444747565144 | (37.7159382286299, -122.444747565144) | |||
| 11207 | 11207 | 85908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2238 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988258.8351 | 2100070.0225 | 37.745715160905206 | -122.48332972713001 | (37.7457151609052, -122.48332972713) | ||
| 11257 | 11257 | 15884 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5601 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998645.335530001 | 2087307.0570599998 | 37.7112700592303 | -122.446496823893 | (37.7112700592303, -122.446496823893) | ||
| 11269 | 11269 | 86499 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987762.5519 | 2105521.4381 | 37.7606543841746 | -122.4854457494 | (37.7606543841746, -122.4854457494) | ||
| 11271 | 11271 | 86187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1751 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988716.7284 | 2103418.2333 | 37.7549350953743 | -122.481991648576 | (37.7549350953743, -122.481991648576) | ||
| 11280 | 11280 | 26314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2079 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999392.715 | 2091721.352 | 37.723433368332 | -122.444230708575 | (37.723433368332, -122.444230708575) | ||
| 11309 | 11309 | 85983 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2316 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987662.8486 | 2099488.4219 | 37.7440835365709 | -122.485347865035 | (37.7440835365709, -122.485347865035) | ||
| 11355 | 11355 | 15910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997998.29527 | 2086965.8977599998 | 37.7102963344846 | -122.448708591324 | (37.7102963344846, -122.448708591324) | ||
| 11378 | 11378 | 85894 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2374 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988293.4976 | 2099156.5993 | 37.743209159222104 | -122.48314293074199 | (37.7432091592221, -122.483142930742) | ||
| 11407 | 11407 | 85964 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2546 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987713.0759 | 2097963.2143 | 37.7398986453239 | -122.485062312209 | (37.7398986453239, -122.485062312209) |
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");