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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||
10548 | 10548 | 15906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | ||
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) | ||
10569 | 10569 | 26287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999929.748980001 | 2092596.2395400002 | 37.7258662323354 | -122.442437067416 | (37.7258662323354, -122.442437067416) | ||
10581 | 10581 | 1040 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2003X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6000664.666119999 | 2090352.04738 | 37.7197460535115 | -122.439735693745 | (37.7197460535115, -122.439735693745) | |||
10593 | 10593 | 26295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999779.73612 | 2092380.76964 | 37.7252660499833 | -122.44294018325701 | (37.7252660499833, -122.442940183257) | ||
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) | ||
10742 | 10742 | 115189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999437.68927 | 2089235.07738 | 37.716609193035396 | -122.443896694081 | (37.7166091930354, -122.443896694081) | ||||
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) | ||
10802 | 10802 | 112326 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:24:00 PM | 3 | 3x3 | 5998237.3346 | 2088425.37851 | 37.7143174021005 | -122.447987437577 | (37.7143174021005, -122.447987437577) | ||
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) | ||
10887 | 10887 | 15908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.210469999 | 2087081.2429799999 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | ||
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) | ||
10898 | 10898 | 112312 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:44:00 PM | 3 | 3x3 | 5998649.95946 | 2088647.23333 | 37.7149501426196 | -122.446577201695 | (37.7149501426196, -122.446577201695) | ||
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) | ||
10954 | 10954 | 15902 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.7453700001 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | ||
10960 | 10960 | 112316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 09:14:00 AM | 3 | 3x3 | 5998526.38122 | 2088580.63045 | 37.714760206699204 | -122.446999548499 | (37.7147602066992, -122.446999548499) | ||
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) | ||
10967 | 10967 | 112330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 01:58:00 PM | 3 | 3x3 | 5998125.15209 | 2088363.53994 | 37.7141411943457 | -122.448370732221 | (37.7141411943457, -122.448370732221) | ||
10977 | 10977 | 85968 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2484X 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987700.7518 | 2098366.2152 | 37.7410044617647 | -122.485134484434 | (37.7410044617647, -122.485134484434) | ||
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) | ||
11003 | 11003 | 30034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001399.41366 | 2091990.2767900003 | 37.7242860560331 | -122.437313179168 | (37.7242860560331, -122.437313179168) | ||
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) | ||
11115 | 11115 | 86507 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1338 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987741.385 | 2106153.4442 | 37.762388466852606 | -122.48556533753201 | (37.7623884668526, -122.485565337532) | ||
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) | ||
11224 | 11224 | 112322 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:56:00 PM | 3 | 3x3 | 5998335.48775 | 2088476.67454 | 37.7144638594022 | -122.447651873544 | (37.7144638594022, -122.447651873544) |
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");