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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) |
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");