Street_Tree_List

Data source: data.sfgov.org

630 rows where qSiteInfo = 2 and qSpecies = 54 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, PlantType, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 630 ✖
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189029 189029 140863 Undocumented 2 :: 54 106 JORDAN AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5996246.41 2113718.2127 37.7836512118011 -122.45669690496901 (37.7836512118011, -122.456696904969)
189016 189016 182660 Undocumented 2 :: 54 1890 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986007.8679 2102386.3122 37.75194380463171 -122.49128357776199 (37.7519438046317, -122.491283577762)
188435 188435 186529 Undocumented 2 :: 54 1500 37th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984686.823 2104775.4574 37.7584264560006 -122.496028111274 (37.7584264560006, -122.496028111274)
188344 188344 183795 Undocumented 2 :: 54 2290 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985480.5542 2099650.3252 37.744400702172605 -122.492905567796 (37.7444007021726, -122.492905567796)
188296 188296 182616 Undocumented 2 :: 54 1856 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987553.0951 2102630.1854 37.7527035840583 -122.485957928463 (37.7527035840583, -122.485957928463)
188195 188195 183817 Undocumented 2 :: 54 2133 Rivera St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986490.2175 2100252.0265 37.74611180538629 -122.48945864467301 (37.7461118053863, -122.489458644673)
188133 188133 183803 Undocumented 2 :: 54 2222 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986396.7617 2100091.5728 37.7456657864188 -122.489770000258 (37.7456657864188, -122.489770000258)
187803 187803 182417 Undocumented 2 :: 54 1544 36th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984999.4264 2104687.6498 37.758203665254996 -122.494940531373 (37.758203665255, -122.494940531373)
187768 187768 182630 Undocumented 2 :: 54 1858 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986937.5539 2102606.5337 37.752602752659705 -122.488084813705 (37.7526027526597, -122.488084813705)
187701 187701 182499 Undocumented 2 :: 54 1567 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985270.2162 2104558.8043 37.7578657392797 -122.493994540633 (37.7578657392797, -122.493994540633)
187636 187636 183293 Undocumented 2 :: 54 1286 42nd Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983075.6533 2106421.6609 37.76285196523921 -122.50172195396401 (37.7628519652392, -122.501721953964)
187627 187627 184329 Undocumented 2 :: 54 1571 42nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983101.4912 2104441.3261 37.757416043664996 -122.501486086821 (37.757416043665, -122.501486086821)
187448 187448 184439 Undocumented 2 :: 54 2131 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5982299.7091 2100588.462 37.7467900380649 -122.503973554813 (37.7467900380649, -122.503973554813)
187361 187361 182210 Undocumented 2 :: 54 1590 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985631.6222 2104402.5116 37.757457742400796 -122.49273315414801 (37.7574577424008, -122.492733154148)
187360 187360 185788 Undocumented 2 :: 54 1911 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986591.7328 2102227.8108 37.7515427017776 -122.48925286425501 (37.7515427017776, -122.489252864255)
187265 187265 183138 Undocumented 2 :: 54 3521 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981925.3562 2099416.4074 37.7435498815044 -122.50518115930201 (37.7435498815044, -122.505181159302)
187264 187264 182228 Undocumented 2 :: 54 1674 21st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989678.7682 2103975.7002 37.7565216554044 -122.478705447978 (37.7565216554044, -122.478705447978)
187250 187250 181883 Undocumented 2 :: 54 2362 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986739.9723 2099172.336 37.7431618411675 -122.48851569655001 (37.7431618411675, -122.48851569655)
187217 187217 185849 Undocumented 2 :: 54 2010 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986971.0019 2101557.3753 37.749723998312895 -122.487892067667 (37.7497239983129, -122.487892067667)
186774 186774 185814 Undocumented 2 :: 54 2046 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989455.7955 2101408.9048 37.7494609681644 -122.479288789487 (37.7494609681644, -122.479288789487)
186300 186300 183883 Undocumented 2 :: 54 2130 24th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988850.4477 2100968.5581 37.7482167156371 -122.481349831083 (37.7482167156371, -122.481349831083)
186147 186147 182765 Undocumented 2 :: 54 1762 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986291.289 2103252.0043 37.7543373159435 -122.490367159029 (37.7543373159435, -122.490367159029)
185376 185376 184529 Undocumented 2 :: 54 1996 Lower Great Hwy 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981188.5011 2101512.3535 37.7492613780766 -122.50788448891899 (37.7492613780766, -122.507884488919)
185311 185311 184600 Undocumented 2 :: 54 1767 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984384.3874 2103165.544 37.7539883630109 -122.496955228039 (37.7539883630109, -122.496955228039)
184961 184961 183873 Undocumented 2 :: 54 2254 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987953.2904 2099959.924 37.7453950726433 -122.484378169146 (37.7453950726433, -122.484378169146)
184322 184322 183815 Undocumented 2 :: 54 2137 Rivera St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986412.1243 2100248.6126 37.746097872473506 -122.48972842623199 (37.7460978724735, -122.489728426232)
184004 184004 185782 Undocumented 2 :: 54 1939 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986599.433999999 2102039.387 37.751025790613205 -122.489212380971 (37.7510257906132, -122.489212380971)
183851 183851 183451 Undocumented 2 :: 54 2515 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988280.1843 2098179.6898 37.7405260477437 -122.48311737481701 (37.7405260477437, -122.483117374817)
183828 183828 183865 Undocumented 2 :: 54 2254 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988574.1949 2099980.8342 37.745488621810395 -122.48223273912 (37.7454886218104, -122.48223273912)
183805 183805 182740 Undocumented 2 :: 54 1758 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986288.2261 2103274.6696 37.7543993697777 -122.490379418445 (37.7543993697777, -122.490379418445)
183796 183796 182261 Undocumented 2 :: 54 1458 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984977.3774 2105263.7356 37.759784145824796 -122.495059264357 (37.7597841458248, -122.495059264357)
183672 183672 200636 Undocumented 2 :: 54 1301 Quesada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6016782.3625 2093458.8747 37.729181036936396 -122.384238246013 (37.7291810369364, -122.384238246013)
183469 183469 181965 Undocumented 2 :: 54 2423 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987019.5087 2098756.0771 37.7420352120933 -122.48751857494499 (37.7420352120933, -122.487518574945)
183358 183358 182230 Undocumented 2 :: 54 1423 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986783.0013 2105561.4949 37.7607072513694 -122.48883647166402 (37.7607072513694, -122.488836471664)
183233 183233 186926 Undocumented 2 :: 54 2800 Sunset Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985157.2666 2096011.7096 37.734391129301 -122.493755335707 (37.734391129301, -122.493755335707)
182932 182932 183826 Undocumented 2 :: 54 2206 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986393.3478 2100193.5633 37.745945625589705 -122.489789304245 (37.7459456255897, -122.489789304245)
182895 182895 182662 Undocumented 2 :: 54 2500 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986210.6491 2102339.3676 37.751826754324796 -122.490578887559 (37.7518267543248, -122.490578887559)
182893 182893 185839 Undocumented 2 :: 54 2000 35th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985427.385 2101213.0209999997 37.748688331560395 -122.493204513888 (37.7486883315604, -122.493204513888)
182855 182855 183774 Undocumented 2 :: 54 2283 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985743.4251 2099704.0943 37.7445637066802 -122.492000585748 (37.7445637066802, -122.492000585748)
182702 182702 184160 Undocumented 2 :: 54 3538 Lawton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983222.1931 2104276.0104 37.75696922144979 -122.50105643194999 (37.7569692214498, -122.50105643195)
182607 182607 181593 Undocumented 2 :: 54 1667 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984670.7327 2103856.2674 37.755901673356206 -122.49601594642401 (37.7559016733562, -122.496015946424)
182077 182077 182223 Undocumented 2 :: 54 2850 Lawton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985346.1154 2104348.9791 37.7572940580172 -122.493716591749 (37.7572940580172, -122.493716591749)
181680 181680 183460 Undocumented 2 :: 54 2531 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989523.5075 2098113.9575 37.740417837399505 -122.478813687602 (37.7404178373995, -122.478813687602)
181678 181678 182929 Undocumented 2 :: 54 2635 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981797.6603 2097141.2975 37.737295543609996 -122.50545409100799 (37.73729554361, -122.505454091008)
181628 181628 183542 Undocumented 2 :: 54 2598 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988033.5951 2097670.443 37.7391134369583 -122.483932641735 (37.7391134369583, -122.483932641735)
181569 181569 182618 Undocumented 2 :: 54 1867 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985341.9215 2102504.3913 37.752229082513 -122.493595181955 (37.752229082513, -122.493595181955)
181519 181519 184636 Undocumented 2 :: 54 1655 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984668.374 2103926.3557 37.7560939782323 -122.496029273942 (37.7560939782323, -122.496029273942)
181436 181436 182186 Undocumented 2 :: 54 1638 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988430.2421 2104156.5357 37.75694560898 -122.48303649718099 (37.75694560898, -122.483036497181)
181424 181424 182239 Undocumented 2 :: 54 1434 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985592.8101 2105449.5872 37.7603304525285 -122.492944506053 (37.7603304525285, -122.492944506053)
181267 181267 182396 Undocumented 2 :: 54 1522 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985925.6496 2104840.5319999997 37.7586776143061 -122.491748548818 (37.7586776143061, -122.491748548818)
181014 181014 182208 Undocumented 2 :: 54 1666 21st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989675.9216 2104008.911 37.7566126781149 -122.47871772119301 (37.7566126781149, -122.478717721193)
180963 180963 182617 Undocumented 2 :: 54 1870 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986004.9641 2102510.2071 37.7522838165719 -122.491302737104 (37.7522838165719, -122.491302737104)
180812 180812 182781 Undocumented 2 :: 54 1742 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985353.0616 2103349.1064 37.7545490898351 -122.49361889547701 (37.7545490898351, -122.493618895477)
180796 180796 183719 Undocumented 2 :: 54 2262 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987954.1438 2099907.4352 37.7452510020103 -122.484371369268 (37.7452510020103, -122.484371369268)
180769 180769 182537 Undocumented 2 :: 54 1586 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985941.1501 2104457.4168 37.7576265915257 -122.491666739682 (37.7576265915257, -122.491666739682)
180718 180718 182713 Undocumented 2 :: 54 1718 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985659.6593 2103506.866 37.75500018565621 -122.49257023245899 (37.7550001856562, -122.492570232459)
180716 180716 182582 Undocumented 2 :: 54 2274 20th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5990131.8885 2099913.0313 37.7453929349849 -122.47684158440201 (37.7453929349849, -122.476841584402)
180164 180164 183139 Undocumented 2 :: 54 3539 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981846.5394 2099413.7013 37.7435378134359 -122.505453483048 (37.7435378134359, -122.505453483048)
180034 180034 185789 Undocumented 2 :: 54 1915 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986592.7596 2102199.5729 37.751465228095796 -122.489247237561 (37.7514652280958, -122.489247237561)
180018 180018 184711 Undocumented 2 :: 54 1619 41st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983422.7912 2104108.9895 37.756522405688294 -122.500350351105 (37.7565224056883, -122.500350351105)
179934 179934 185601 Undocumented 2 :: 54 1200 Quintara St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989640.5487 2101098.6399 37.7486197911777 -122.478627227884 (37.7486197911777, -122.478627227884)
179798 179798 184537 Undocumented 2 :: 54 1920 Lower Great Hwy 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981149.921 2101972.2688 37.750521902570604 -122.50805202692601 (37.7505219025706, -122.508052026926)
179718 179718 182600 Undocumented 2 :: 54 1959 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985980.7032 2101896.5884 37.7505975691069 -122.4913414752 (37.7505975691069, -122.4913414752)
179192 179192 182994 Undocumented 2 :: 54 2085 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989637.5208 2098316.5193 37.7409806392129 -122.478434287218 (37.7409806392129, -122.478434287218)
179131 179131 184543 Undocumented 2 :: 54 3419 Moraga St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983659.9786 2103558.2129 37.7550240466182 -122.499489383511 (37.7550240466182, -122.499489383511)
179050 179050 186412 Undocumented 2 :: 54 1601 Sunset Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984810.0324 2103749.2702 37.7556160465723 -122.49552631838101 (37.7556160465723, -122.495526318381)
178952 178952 183207 Undocumented 2 :: 54 2487 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981762.9721 2098176.699 37.7401364295663 -122.505650753582 (37.7401364295663, -122.505650753582)
178904 178904 183885 Undocumented 2 :: 54 1390 Quintara St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988878.4835 2101013.894 37.7483428259954 -122.481256204658 (37.7483428259954, -122.481256204658)
178876 178876 200201 Undocumented 2 :: 54 1090 Ingerson Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6013694.5474 2090234.3998 37.7201560648851 -122.394687445541 (37.7201560648851, -122.394687445541)
178846 178846 184127 Undocumented 2 :: 54 1638 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985330.3253 2104050.8162 37.7564744613327 -122.493749228243 (37.7564744613327, -122.493749228243)
178394 178394 182815 Undocumented 2 :: 54 2111 Noriega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987460.7639 2102999.1421 37.753711258436496 -122.486304306666 (37.7537112584365, -122.486304306666)
178348 178348 183841 Undocumented 2 :: 54 2222 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987945.6091 2100141.7146 37.745893774112794 -122.48441806049802 (37.7458937741128, -122.484418060498)
178183 178183 184327 Undocumented 2 :: 54 1566 42nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983143.5077 2104481.5092 37.7575288427339 -122.50134375171899 (37.7575288427339, -122.501343751719)
178140 178140 184288 Undocumented 2 :: 54 1514 41st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983440.9844 2104806.182 37.7584377683924 -122.500338977609 (37.7584377683924, -122.500338977609)
178130 178130 182483 Undocumented 2 :: 54 1555 32nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986198.1756 2104640.4864 37.75814426828779 -122.49079132320699 (37.7581442682878, -122.490791323207)
178124 178124 140889 Undocumented 2 :: 54 145 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5996520.3624 2113408.7259 37.7828171689042 -122.455726761043 (37.7828171689042, -122.455726761043)
177991 177991 182247 Undocumented 2 :: 54 1454 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985597.5878 2105309.9322 37.759947278047 -122.49291769541 (37.759947278047, -122.49291769541)
177939 177939 200226 Undocumented 2 :: 54 1131 Fitzgerald Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6015013.4132 2090222.9153 37.720197768832605 -122.390127728915 (37.7201977688326, -122.390127728915)
177054 177054 183851 Undocumented 2 :: 54 2235 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986665.607000001 2100041.6444 37.7455443899531 -122.48883671629999 (37.7455443899531, -122.4888367163)
176960 176960 182283 Undocumented 2 :: 54 1480 Kirkham St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984982.9221 2105136.6498 37.759435528213295 -122.49503071720501 (37.7594355282133, -122.495030717205)
176831 176831 184891 Undocumented 2 :: 54 1201 Sunset Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984723.2958 2106746.9726 37.7638418212229 -122.49604742094299 (37.7638418212229, -122.496047420943)
176810 176810 182055 Undocumented 2 :: 54 1358 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987435.6115 2106037.3813 37.76205196967079 -122.486614358562 (37.7620519696708, -122.486614358562)
176664 176664 181595 Undocumented 2 :: 54 1683 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984673.7654 2103756.5264 37.7556279898559 -122.49599810063299 (37.7556279898559, -122.495998100633)
176607 176607 181872 Undocumented 2 :: 54 2330 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985803.3054 2099347.2154 37.7435873132981 -122.491767267489 (37.7435873132981, -122.491767267489)
176590 176590 182501 Undocumented 2 :: 54 1571 32nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986201.2632 2104545.9513 37.757884881279104 -122.490773689302 (37.7578848812791, -122.490773689302)
176500 176500 182653 Undocumented 2 :: 54 1867 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986887.7244 2102551.4802 37.752448683587204 -122.488253085126 (37.7524486835872, -122.488253085126)
176452 176452 200497 Undocumented 2 :: 54 1110 Gilman Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6014977.2953 2089975.1673 37.7195154981888 -122.39023527774799 (37.7195154981888, -122.390235277748)
176431 176431 183053 Undocumented 2 :: 54 2601 19th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5990456.6898 2097547.4037 37.738916368412106 -122.47554578609 (37.7389163684121, -122.47554578609)
176424 176424 184124 Undocumented 2 :: 54 1639 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985907.4128 2104065.5276 37.7565485998964 -122.491754566542 (37.7565485998964, -122.491754566542)
176078 176078 182726 Undocumented 2 :: 54 1738 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987522.687999999 2103443.5293 37.754935034598205 -122.48612278117399 (37.7549350345982, -122.486122781174)
175484 175484 184095 Undocumented 2 :: 54 1611 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985901.3945 2104240.0581 37.757027460882 -122.49178822773099 (37.757027460882, -122.491788227731)
175461 175461 182445 Undocumented 2 :: 54 1530 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985616.5233 2104773.8077 37.7584763359765 -122.492812718757 (37.7584763359765, -122.492812718757)
175149 175149 139288 Undocumented 2 :: 54 850 STEINER ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6003023.9373 2111228.5503 37.7772020350349 -122.433071323703 (37.7772020350349, -122.433071323703)
175076 175076 183866 Undocumented 2 :: 54 2246 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987024.9208 2099969.9524 37.7453685059232 -122.487589015437 (37.7453685059232, -122.487589015437)
174948 174948 200699 Undocumented 2 :: 54 1501 Lane St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6015860.7307 2095472.4329 37.734658863200295 -122.38756485421699 (37.7346588632003, -122.387564854217)
174502 174502 183986 Undocumented 2 :: 54 1678 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985651.3009 2103798.7166 37.7558010384249 -122.49262063086799 (37.7558010384249, -122.492620630868)
174451 174451 184706 Undocumented 2 :: 54 1614 39th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984085.5969 2104145.8869 37.7566625986032 -122.49806089331999 (37.7566625986032, -122.49806089332)
174225 174225 184482 Undocumented 2 :: 54 2019 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5982585.5063 2101354.8182 37.748911041069796 -122.503042038753 (37.7489110410698, -122.503042038753)
174104 174104 184725 Undocumented 2 :: 54 1647 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984666.3522 2103976.5631 37.7562317154001 -122.49603996978 (37.7562317154001, -122.49603996978)
173957 173957 182333 Undocumented 2 :: 54 1492 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984985.2048 2105079.0997 37.759277645293004 -122.495018579042 (37.759277645293, -122.495018579042)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 1122.783ms · Data source: data.sfgov.org