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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3785 | 3785 | 136888 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3823 | 3823 | 102525 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 310 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769739 | 5998596.991169999 | 2115413.44206 | 37.7884405486385 | -122.448686963531 | (37.7884405486385, -122.448686963531) | |
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) | ||
3863 | 3863 | 6898 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005831.3408 | 2110713.462 | 37.775946573797995 | -122.423322982857 | (37.775946573798, -122.423322982857) | ||
3868 | 3868 | 253576 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
3880 | 3880 | 241545 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 116 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x12 | 6004745.13343 | 2097274.75809 | 37.7389856943281 | -122.426123530088 | (37.7389856943281, -122.426123530088) | |||
3882 | 3882 | 241544 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 116 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x12 | 6004777.35828 | 2097276.13496 | 37.7389912962031 | -122.426012209298 | (37.7389912962031, -122.426012209298) | |||
3889 | 3889 | 217588 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1490 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5995480.907000001 | 2092133.7981 | 37.7243418958878 | -122.45778285535101 | (37.7243418958878, -122.457782855351) | |||
3936 | 3936 | 162839 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 93 Lee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:47:00 PM | 3 | Width 0ft | 5996489.12925 | 2090422.7044 | 37.719701506488 | -122.45417406278 | (37.719701506488, -122.45417406278) | ||
3952 | 3952 | 214100 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:56:00 PM | 3 | Width 3ft | 5996085.5249 | 2091194.1399299998 | 37.7217965338776 | -122.455624901296 | (37.7217965338776, -122.455624901296) | ||
3966 | 3966 | 162837 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 93 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:45:00 PM | 3 | Width 0ft | 5996490.20917 | 2090455.8643 | 37.7197926177076 | -122.45417272368601 | (37.7197926177076, -122.454172723686) | ||
3977 | 3977 | 162840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 79 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:54:00 PM | 3 | Width 0ft | 5996488.6057 | 2090397.63567 | 37.71963264362321 | -122.45417406280501 | (37.7196326436232, -122.454174062805) | ||
3983 | 3983 | 216874 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 638 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 03:16:00 PM | 3 | Width 3ft | 5995925.14157 | 2089161.4426799999 | 37.7162060215686 | -122.456032419169 | (37.7162060215686, -122.456032419169) | ||
3986 | 3986 | 65721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 275 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 04:32:00 PM | 3 | Permit Number 28655 | 6000475.14424 | 2087458.3820900002 | 37.711789909637794 | -122.44018340596399 | (37.7117899096378, -122.440183405964) | |
4000 | 4000 | 159212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:30:00 AM | 3 | Width 0ft | 5998913.8827 | 2087989.6693 | 37.7131596931403 | -122.445617716786 | (37.7131596931403, -122.445617716786) | ||
4019 | 4019 | 159214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Ellington Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:15:00 AM | 3 | Width 0ft | 5998893.94136 | 2087968.62584 | 37.713100774055 | -122.44568512818199 | (37.713100774055, -122.445685128182) | ||
4029 | 4029 | 159224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 384 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:27:00 AM | 3 | Width 0ft | 5998600.7872 | 2087691.66315 | 37.7123235556611 | -122.44667844826701 | (37.7123235556611, -122.446678448267) | ||
4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
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) | ||
4043 | 4043 | 216875 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 668 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:30:00 PM | 3 | Width 3ft | 5995926.39205 | 2089208.92779 | 37.7163364763159 | -122.456031527941 | (37.7163364763159, -122.456031527941) | ||
4044 | 4044 | 159331 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 562 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:06:00 AM | 3 | Width 0ft | 5997894.14042 | 2087019.0117 | 37.7104362168201 | -122.449072394069 | (37.7104362168201, -122.449072394069) | ||
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) | ||
4136 | 4136 | 216727 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 78 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:54:00 AM | 3 | Width 3ft | 5995351.20141 | 2090413.7990299999 | 37.7196117361844 | -122.458106803489 | (37.7196117361844, -122.458106803489) | ||
4140 | 4140 | 216837 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:34:00 PM | 3 | Width 3ft | 5994365.2203 | 2088384.89347 | 37.713984142135104 | -122.461367955672 | (37.7139841421351, -122.461367955672) | ||
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) | ||
4496 | 4496 | 30326 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 946 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:13:00 AM | 3 | Permit Number 17 | 5995052.87017 | 2090222.4724 | 37.7190692525106 | -122.459124173264 | (37.7190692525106, -122.459124173264) | ||
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) | ||||
4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
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) | ||||
4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 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) | |||
5473 | 5473 | 52359 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007837.48852 | 2114654.59381 | 37.786880990198 | -122.41666243464199 | (37.786880990198, -122.416662434642) |
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) | |||
5549 | 5549 | 117113 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | |
5644 | 5644 | 81955 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 611 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769820 | 6007855.44707 | 2114525.76185 | 37.7865282590267 | -122.416591172348 | (37.7865282590267, -122.416591172348) |
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) | ||
5738 | 5738 | 117115 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005638.31982 | 2117909.64088 | 37.7956946025865 | -122.42450268015 | (37.7956946025865, -122.42450268015) | |
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) | |||
5891 | 5891 | 117112 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005683.22125 | 2117915.42136 | 37.7957130098979 | -122.424347724294 | (37.7957130098979, -122.424347724294) | |
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) | ||
6259 | 6259 | 110082 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3028 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773127 | 6003845.53754 | 2119275.91303 | 37.799344628804796 | -122.43080357774299 | (37.7993446288048, -122.430803577743) | |
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) | |||
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) |
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) |
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");