Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127 | 127 | 18052 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | |||
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
| 219 | 219 | 138804 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002587.4194 | 2115073.5588 | 37.787734687268795 | -122.43485641346001 | (37.7877346872688, -122.43485641346) | |||
| 225 | 225 | 138808 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:29:00 AM | 5 | Width 0ft | 6002680.0299 | 2115089.4167 | 37.787783486631206 | -122.434537133485 | (37.7877834866312, -122.434537133485) | ||
| 229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
| 333 | 333 | 242579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 11 | Width 3ft | Permit Number 778239 | 6001257.943419999 | 2101462.97247 | 37.7502878270446 | -122.438480597209 | (37.7502878270446, -122.438480597209) | |
| 459 | 459 | 35612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768882 | 6000549.03074 | 2116799.12347 | 37.792356695946005 | -122.442032735847 | (37.792356695946, -122.442032735847) | |
| 555 | 555 | 242524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1902 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008008.060219999 | 2107332.79337 | 37.7667866624906 | -122.415553715331 | (37.7667866624906, -122.415553715331) | ||
| 583 | 583 | 7548 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5x5 | 6008321.80095 | 2101666.80438 | 37.751246783135 | -122.414067651319 | (37.751246783135, -122.414067651319) | |||
| 625 | 625 | 242532 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | ||
| 849 | 849 | 93578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 401X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009309.6837 | 2121148.6264 | 37.8047947000965 | -122.41202806393 | (37.8047947000965, -122.41202806393) | |
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
| 1003 | 1003 | 14837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1306 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002857.7118 | 2111688.5769 | 37.7784557229826 | -122.43367923622401 | (37.7784557229826, -122.433679236224) | ||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1241 | 1241 | 242526 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | ||
| 1243 | 1243 | 242621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.745585061615294 | -122.413502636934 | (37.7455850616153, -122.413502636934) | |||
| 1266 | 1266 | 242525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1916 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008012.49588 | 2107266.03409 | 37.7666036064 | -122.415533646066 | (37.7666036064, -122.415533646066) | ||
| 1270 | 1270 | 18055 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.786818213822706 | -122.443122531996 | (37.7868182138227, -122.443122531996) | |||
| 1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 2076 | 2076 | 14859 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1368 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002639.2367 | 2111656.2394 | 37.7783545332764 | -122.434432710417 | (37.7783545332764, -122.434432710417) | ||
| 2483 | 2483 | 201850 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 911 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011602.0 | 2112119.0 | 37.7801298483764 | -122.403459565618 | (37.7801298483764, -122.403459565618) | |||
| 2504 | 2504 | 55970 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.9939099997 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | ||
| 2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
| 2753 | 2753 | 198672 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 193 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | Width 4ft | 6010593.523440001 | 2111314.08538 | 37.777863361242105 | -122.406891615375 | (37.7778633612421, -122.406891615375) | ||
| 2806 | 2806 | 18057 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | |||
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3363 | 3363 | 7526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2004 12:00:00 AM | 3 | 3x3 | 6008303.39209 | 2102027.1918 | 37.7522352918412 | -122.414156805597 | (37.7522352918412, -122.414156805597) | ||
| 3378 | 3378 | 242510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008305.34942 | 2102000.42568 | 37.75216190805129 | -122.41414814334 | (37.7521619080513, -122.41414814334) | |||
| 3384 | 3384 | 242759 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000876.8584 | 2105865.2464 | 37.7623537170769 | -122.440114051125 | (37.7623537170769, -122.440114051125) | |||
| 3612 | 3612 | 18039 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2813 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000314.1463 | 2114749.1203 | 37.7867145338964 | -122.442698176369 | (37.7867145338964, -122.442698176369) | |||
| 3831 | 3831 | 30286 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 10 | Permit Number 132 | 6008896.76565 | 2117570.49119 | 37.794946853168604 | -122.41320383718599 | (37.7949468531686, -122.413203837186) | ||
| 4036 | 4036 | 242541 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2430 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2007 12:00:00 AM | 5 | Width 4ft | 6008178.84704 | 2104258.05912 | 37.758353750252105 | -122.41474536781901 | (37.7583537502521, -122.414745367819) | ||
| 4237 | 4237 | 14843 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1320 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002817.8815 | 2111683.4502 | 37.7784393862348 | -122.433816657579 | (37.7784393862348, -122.433816657579) | ||
| 4598 | 4598 | 18015 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000819.3499 | 2114877.5272 | 37.7870958927498 | -122.44095951208901 | (37.7870958927498, -122.440959512089) | |||
| 4811 | 4811 | 17931 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2416 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002234.6053 | 2115077.8001 | 37.7877262951282 | -122.43607738468398 | (37.7877262951282, -122.436077384684) | |||
| 5079 | 5079 | 137895 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1944 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2017 12:00:00 AM | 3 | Width 0ft | 6003925.565 | 2115178.3301 | 37.788098246385395 | -122.430234163647 | (37.7880982463854, -122.430234163647) | ||
| 5180 | 5180 | 17545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6003118.2023599995 | 2090743.3942599997 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | |||
| 5186 | 5186 | 180527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003103.45709 | 2090752.9991099997 | 37.720985491961 | -122.43133426946301 | (37.720985491961, -122.431334269463) | |||
| 5219 | 5219 | 242740 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4081 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | 5 | Width 2ft | Permit Number 47860 | 6001797.68474 | 2105832.52045 | 37.7623162396305 | -122.43692691855 | (37.7623162396305, -122.43692691855) | |
| 5267 | 5267 | 62038 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2015 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | Permit Number 773957 | 6000922.27992 | 2115385.7995599997 | 37.788497339028204 | -122.440639868553 | (37.7884973390282, -122.440639868553) | ||
| 5698 | 5698 | 17917 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2370 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002602.4145 | 2115123.2744 | 37.7878720449725 | -122.43480808996 | (37.7878720449725, -122.43480808996) | |||
| 6048 | 6048 | 14856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1360 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002668.0249 | 2111660.9717 | 37.7783691610679 | -122.434333459849 | (37.7783691610679, -122.434333459849) | ||
| 6069 | 6069 | 17933 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2418 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002186.7609 | 2115068.0006 | 37.7876966699691 | -122.43624221533301 | (37.7876966699691, -122.436242215333) | |||
| 6092 | 6092 | 46303 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 6216 | 6216 | 18017 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.786983384155505 | -122.440762994582 | (37.7869833841555, -122.440762994582) | |||
| 6355 | 6355 | 12261 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6004982.9117 | 2111116.4652 | 37.7770052022278 | -122.426286620749 | (37.7770052022278, -122.426286620749) | ||
| 6566 | 6566 | 2631 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004489.1648 | 2115039.2121 | 37.787748169652204 | -122.428274287097 | (37.7877481696522, -122.428274287097) | |||
| 6867 | 6867 | 18000 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2670 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001175.0601 | 2114930.6744 | 37.7872620743104 | -122.43973264788299 | (37.7872620743104, -122.439732647883) | |||
| 6994 | 6994 | 18053 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2852 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000250.2377 | 2114802.0314 | 37.7868561706627 | -122.442923085267 | (37.7868561706627, -122.442923085267) | |||
| 7448 | 7448 | 106350 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1853 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001488.8508 | 2114881.6293 | 37.7871452647326 | -122.43864348553001 | (37.7871452647326, -122.43864348553) | |||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 7539 | 7539 | 18051 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1999 12:00:00 AM | 6 | 3X3PL | 6000336.3598 | 2114811.683 | 37.786887581121704 | -122.442625816895 | (37.7868875811217, -122.442625816895) | ||
| 7586 | 7586 | 48883 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1515 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2002 12:00:00 AM | 4 | 5x4 | Permit Number 46089 | 6000106.0163 | 2114246.8974 | 37.7853236932557 | -122.44338216691901 | (37.7853236932557, -122.443382166919) | |
| 7715 | 7715 | 101523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001809.9749300005 | 2118762.85825 | 37.7978203759732 | -122.43781055733801 | (37.7978203759732, -122.437810557338) | |||
| 7771 | 7771 | 96366 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1326 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006664.3237 | 2118739.81484 | 37.7980319387709 | -122.421011488604 | (37.7980319387709, -122.421011488604) | |||
| 8034 | 8034 | 17992 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2619 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2012 12:00:00 AM | 3 | 3X3 | 6001295.2434 | 2114888.6615 | 37.787153557687795 | -122.439313827621 | (37.7871535576878, -122.439313827621) | ||
| 8226 | 8226 | 18032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000470.3136 | 2114777.4747 | 37.7868012889701 | -122.44215991241501 | (37.7868012889701, -122.442159912415) | |||
| 8302 | 8302 | 18045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2821 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.4327 | 2114739.0872 | 37.786681414860894 | -122.44303552029801 | (37.7866814148609, -122.443035520298) | |||
| 8354 | 8354 | 14848 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1341 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002736.8406 | 2111618.9725 | 37.778257747549894 | -122.434092397831 | (37.7782577475499, -122.434092397831) | ||
| 8472 | 8472 | 46875 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) |
| 8552 | 8552 | 14851 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1350 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002705.0947 | 2111666.0984 | 37.778385341741206 | -122.434205588327 | (37.7783853417412, -122.434205588327) | ||
| 8639 | 8639 | 18001 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2673 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001165.7528 | 2114873.8019 | 37.7871053873216 | -122.439760770078 | (37.7871053873216, -122.439760770078) | |||
| 8667 | 8667 | 6037 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | |
| 8832 | 8832 | 101524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | |||
| 9119 | 9119 | 18034 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2806 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000470.7399 | 2114833.2135 | 37.7869543575665 | -122.44216244014099 | (37.7869543575665, -122.442162440141) | |||
| 9245 | 9245 | 18044 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2819 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000236.9351 | 2114743.0132 | 37.7866933635797 | -122.442964869171 | (37.7866933635797, -122.442964869171) | |||
| 9284 | 9284 | 18024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2726 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000724.7507 | 2114865.5018 | 37.787057485761 | -122.441285940418 | (37.787057485761, -122.441285940418) | |||
| 9407 | 9407 | 18054 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2866 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.8283 | 2114794.6071 | 37.7868338806489 | -122.443038140312 | (37.7868338806489, -122.443038140312) | |||
| 9589 | 9589 | 9765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.778263187688296 | -122.440226567073 | (37.7782631876883, -122.440226567073) | ||
| 9736 | 9736 | 173668 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014587.0 | 2096103.0 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | ||||
| 9754 | 9754 | 25175 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | ||
| 9789 | 9789 | 91811 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | ||
| 10054 | 10054 | 173830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2114864.0 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | ||||
| 10167 | 10167 | 110034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008245.7 | 2102789.4 | 37.754324902547204 | -122.414410241803 | (37.7543249025472, -122.414410241803) | |||||
| 10250 | 10250 | 7523 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6008355.713819999 | 2102061.13803 | 37.752331439255705 | -122.413978269475 | (37.7523314392557, -122.413978269475) | |||
| 10288 | 10288 | 17565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.720429991522295 | -122.43015957951599 | (37.7204299915223, -122.430159579516) | |||
| 10325 | 10325 | 109498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2440 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5989239.6228 | 2098735.6386 | 37.74210832360679 | -122.479840718717 | (37.7421083236068, -122.479840718717) | |||
| 10346 | 10346 | 7524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008300.9450199995 | 2102065.01518 | 37.7523390088635 | -122.414167943693 | (37.7523390088635, -122.414167943693) | |||
| 10349 | 10349 | 17525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6002628.09189 | 2091001.6668200002 | 37.721641326157204 | -122.43299522107401 | (37.7216413261572, -122.432995221074) | |||
| 10351 | 10351 | 17502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002131.248869999 | 2091360.1957200002 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | |||
| 10371 | 10371 | 46304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10375 | 10375 | 17615 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004156.70512 | 2090037.9094200002 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | |||
| 10537 | 10537 | 17602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | |||
| 10554 | 10554 | 17590 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003668.70994 | 2090393.5126599998 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | |||
| 10722 | 10722 | 17551 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003191.74591 | 2090695.7695400002 | 37.720833355450104 | -122.43102499890699 | (37.7208333554501, -122.431024998907) | |||
| 10729 | 10729 | 17592 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.42943389227699 | (37.7200700675728, -122.429433892277) | |||
| 10763 | 10763 | 17492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.722862078497705 | -122.435288881679 | (37.7228620784977, -122.435288881679) | |||
| 10792 | 10792 | 17605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003999.6997 | 2090190.6100400002 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | |||
| 10866 | 10866 | 17524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | |||
| 10894 | 10894 | 17530 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002769.64699 | 2090910.4417700002 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | |||
| 10917 | 10917 | 17498 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.43487036238501 | (37.72266164479, -122.434870362385) | |||
| 10940 | 10940 | 17528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002717.3851 | 2090942.2754900001 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | |||
| 10968 | 10968 | 17595 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003715.34966 | 2090318.2223099999 | 37.719826349498895 | -122.42918815340401 | (37.7198263494989, -122.429188153404) |
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");