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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4188 | 4188 | 181057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | ||
| 4211 | 4211 | 136890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | ||
| 4217 | 4217 | 216856 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 269 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:36:00 AM | 3 | Width 3ft | 5994294.27802 | 2087746.4954799998 | 37.712227169014604 | -122.461566901007 | (37.7122271690146, -122.461566901007) | ||
| 4259 | 4259 | 252872 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | ||
| 4274 | 4274 | 252887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:23:00 PM | 3 | 3x3 | 5997288.0 | 2090319.0 | 37.719462535966294 | -122.45140518978998 | (37.7194625359663, -122.45140518979) | ||
| 4324 | 4324 | 251737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872.0 | 2086877.0 | 37.7103297297312 | -122.43185773233601 | (37.7103297297312, -122.431857732336) | ||
| 4357 | 4357 | 180599 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 130 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:49:00 AM | 3 | Width 2ft | 6004241.29986 | 2094286.4256099998 | 37.73075191805779 | -122.427652702223 | (37.7307519180578, -122.427652702223) | ||
| 4365 | 4365 | 252899 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390 San Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:05:00 PM | 3 | 3x3 | 5997900.0 | 2090079.0 | 37.7188385770119 | -122.449272458694 | (37.7188385770119, -122.449272458694) | ||
| 4366 | 4366 | 251751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 4382 | 4382 | 180600 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 142 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:52:00 AM | 3 | Width 2ft | 6004316.23114 | 2094289.2988 | 37.7307640454079 | -122.427393857542 | (37.7307640454079, -122.427393857542) | ||
| 4394 | 4394 | 251740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 240 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:43:00 AM | 3 | 3x3 | 6002635.0 | 2086674.0 | 37.709758897844296 | -122.432662361521 | (37.7097588978443, -122.432662361521) | ||
| 4396 | 4396 | 251750 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 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) | ||
| 4433 | 4433 | 180628 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.710390087913794 | -122.43495675757299 | (37.7103900879138, -122.434956757573) | ||
| 4466 | 4466 | 180840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:05:00 PM | 3 | Width 2ft | 5997679.45955 | 2086959.0123599998 | 37.7102591915804 | -122.449810052203 | (37.7102591915804, -122.449810052203) | ||
| 4469 | 4469 | 162767 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 910 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:46:00 AM | 3 | Width 0ft | 5995047.74881 | 2089994.6551299999 | 37.7184434259931 | -122.459125388251 | (37.7184434259931, -122.459125388251) | ||
| 4473 | 4473 | 180841 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:10:00 PM | 3 | Width 2ft | 5997726.08242 | 2086911.31353 | 37.710130888906896 | -122.449645479868 | (37.7101308889069, -122.449645479868) | ||
| 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) | ||
| 4503 | 4503 | 162771 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 954 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:37:00 AM | 3 | Width 0ft | 5995054.32818 | 2090275.3089700001 | 37.7192144129887 | -122.45912295737301 | (37.7192144129887, -122.459122957373) | ||
| 4509 | 4509 | 162768 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 914 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:51:00 AM | 3 | Width 0ft | 5995049.36731 | 2090021.5803099999 | 37.7185174491889 | -122.4591217424 | (37.7185174491889, -122.4591217424) | ||
| 4514 | 4514 | 162766 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 906 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:33:00 AM | 3 | Width 0ft | 5995047.57993 | 2089969.8003900002 | 37.7183751710697 | -122.459124173239 | (37.7183751710697, -122.459124173239) | ||
| 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) | |||
| 4638 | 4638 | 180016 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 7 | Width 3ft | 5997041.774780001 | 2087538.2490700001 | 37.711813136431 | -122.452055773566 | (37.711813136431, -122.452055773566) | ||
| 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) | ||
| 4699 | 4699 | 253658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4700 | 4700 | 253660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4702 | 4702 | 253657 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4703 | 4703 | 253659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4709 | 4709 | 253656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 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) | ||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4861 | 4861 | 106723 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2891 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 4x3 | 5999685.7618 | 2114314.7923 | 37.785486140561105 | -122.444840997242 | (37.7854861405611, -122.444840997242) | |||
| 5142 | 5142 | 241731 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005457.0 | 2108414.0 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | |||
| 5213 | 5213 | 180235 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | |||
| 5214 | 5214 | 253835 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | ||||
| 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) | |||
| 5307 | 5307 | 8160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002453.143999999 | 2111285.6659999997 | 37.777326466446 | -122.435049962975 | (37.777326466446, -122.435049962975) | ||
| 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) | |||
| 5663 | 5663 | 24487 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 618 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004392.5811 | 2110517.0483 | 37.7753259646513 | -122.428286026192 | (37.7753259646513, -122.428286026192) | ||
| 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) | |||
| 5767 | 5767 | 14527 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999201.3001 | 2110597.4992 | 37.7752517549466 | -122.44624958831801 | (37.7752517549466, -122.446249588318) | |||
| 5805 | 5805 | 22726 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1525 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1997 12:00:00 AM | 12 | 3X3 | 6002762.8064 | 2112322.4766 | 37.780190867266796 | -122.43405287482 | (37.7801908672668, -122.43405287482) | ||
| 5829 | 5829 | 7833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006176.68475 | 2113023.80022 | 37.7823096849858 | -122.42229253146999 | (37.7823096849858, -122.42229253147) | |||
| 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) | ||
| 6404 | 6404 | 7830 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006192.27553 | 2112919.76373 | 37.7820249056667 | -122.422231200417 | (37.7820249056667, -122.422231200417) | |||
| 6480 | 6480 | 6980 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 802 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003550.3934 | 2110396.3103 | 37.7749467581504 | -122.431190726971 | (37.7749467581504, -122.431190726971) | ||
| 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) | |||
| 6526 | 6526 | 7834 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006174.13895 | 2113043.71306 | 37.7823642171667 | -122.422302754063 | (37.7823642171667, -122.422302754063) | |||
| 6540 | 6540 | 7831 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006187.42417 | 2112935.31044 | 37.7820673194837 | -122.42224908883001 | (37.7820673194837, -122.42224908883) | |||
| 6543 | 6543 | 137954 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | ||||
| 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) | ||
| 6659 | 6659 | 10663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.77563176944871 | -122.432267067771 | (37.7756317694487, -122.432267067771) | ||
| 6672 | 6672 | 22644 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1244 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2000 12:00:00 AM | 3 | 3X3 | 6004038.676 | 2112547.7701 | 37.7808817933373 | -122.429655131034 | (37.7808817933373, -122.429655131034) | ||
| 6675 | 6675 | 6064 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1913 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001176.3696 | 2112440.1627 | 37.78042384150729 | -122.43954951236799 | (37.7804238415073, -122.439549512368) | |||
| 6708 | 6708 | 26658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 522 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 2X2 | 6004907.91771 | 2110588.9523400003 | 37.7755525415589 | -122.42650847769501 | (37.7755525415589, -122.426508477695) | ||
| 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) | |||
| 7019 | 7019 | 22735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | 3X3 | 6002477.0092 | 2112332.46 | 37.7802020553421 | -122.43504229111299 | (37.7802020553421, -122.435042291113) | ||
| 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) | ||
| 7130 | 7130 | 22744 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002647.0661 | 2112304.2018 | 37.780134120032294 | -122.43445196604401 | (37.7801341200323, -122.434451966044) | ||
| 7210 | 7210 | 7829 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006196.28269 | 2112899.08523 | 37.7819683535895 | -122.422215867866 | (37.7819683535895, -122.422215867866) | |||
| 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) | ||
| 7239 | 7239 | 28357 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3060 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2003 12:00:00 AM | 3 | 3X3 | 6000153.01588 | 2115483.23318 | 37.7887210301107 | -122.44330839538601 | (37.7887210301107, -122.443308395386) | ||
| 7243 | 7243 | 116776 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.41364847189399 | (37.7960980717264, -122.413648471894) | ||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7307 | 7307 | 7835 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1994 12:00:00 AM | 6 | 4x4 | 6006172.94925 | 2113057.71328 | 37.782402591234295 | -122.42230786493099 | (37.7824025912343, -122.422307864931) | ||
| 7363 | 7363 | 26659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 522 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004893.91605 | 2110587.9747 | 37.7755490656586 | -122.42655684321998 | (37.7755490656586, -122.42655684322) | ||
| 7390 | 7390 | 24488 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 730 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003912.5381 | 2110447.8419 | 37.7751087667975 | -122.42994166795 | (37.7751087667975, -122.42994166795) | ||
| 7415 | 7415 | 18997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3006 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2007 12:00:00 AM | 3 | 3X3PL | 6000330.42565 | 2115511.74748 | 37.7888094379519 | -122.44269663335301 | (37.7888094379519, -122.442696633353) | ||
| 7435 | 7435 | 14489 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5998982.1627 | 2111728.505 | 37.7783446886067 | -122.447089042698 | (37.7783446886067, -122.447089042698) | |||
| 7462 | 7462 | 6063 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1913 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001160.8022 | 2112439.8243 | 37.780422026336495 | -122.43960334291 | (37.7804220263365, -122.43960334291) | |||
| 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) | |||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 7575 | 7575 | 14521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 610 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999188.9854 | 2110718.1832 | 37.7755824190107 | -122.446300870977 | (37.7755824190107, -122.446300870977) | |||
| 7695 | 7695 | 6060 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001215.6265 | 2112445.5775 | 37.780440943348395 | -122.439414092915 | (37.7804409433484, -122.439414092915) | |||
| 7708 | 7708 | 7838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6006162.87093 | 2113106.46808 | 37.7825358914721 | -122.422346196719 | (37.7825358914721, -122.422346196719) | |||
| 7735 | 7735 | 116777 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.796092432072705 | -122.41369458194099 | (37.7960924320727, -122.413694581941) | ||
| 7756 | 7756 | 105526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998177.9524 | 2112999.2356 | 37.781787802518004 | -122.449962699898 | (37.781787802518, -122.449962699898) | |||
| 7808 | 7808 | 6061 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001229.8402 | 2112447.2696 | 37.7804463983122 | -122.43936504248998 | (37.7804463983122, -122.43936504249) | |||
| 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) | ||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 7974 | 7974 | 14529 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999204.1149 | 2110576.3883 | 37.775193950570795 | -122.446238332395 | (37.7751939505708, -122.446238332395) | |||
| 8018 | 8018 | 18995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3004 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2006 12:00:00 AM | 3 | 3X3PL | 6000360.72117 | 2115511.4863299998 | 37.7888104478801 | -122.44259179667101 | (37.7888104478801, -122.442591796671) | ||
| 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) |
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");