Street_Tree_List

Data source: data.sfgov.org

1,729 rows where qSpecies = 54 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

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)
188973 188973 200161 Undocumented 2 :: 54 1083 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014425.6299 2089982.8806 37.7195060625081 -122.392142737787 (37.7195060625081, -122.392142737787)
188653 188653 246020 Undocumented 2 :: 54 1629 Haight St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5998306.6251 2108576.7946 37.7696522823625 -122.449198848796 (37.7696522823625, -122.449198848796)
188648 188648 182915 Undocumented 2 :: 54 2711 47th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654)
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)
188408 188408 184199 Undocumented 2 :: 54 1467 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984626.0238 2105215.694 37.759631661619295 -122.496270860499 (37.7596316616193, -122.496270860499)
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)
188216 188216 182185 Undocumented 2 :: 54 1638 25th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5988431.9652 2104143.1815 37.756909042216 -122.483029559375 (37.756909042216, -122.483029559375)
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)
188170 188170 181697 Undocumented 2 :: 54 1360 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5982163.8853 2105835.7898 37.761189733060704 -122.50483197223 (37.7611897330607, -122.50483197223)
188135 188135 184183 Undocumented 2 :: 54 1626 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5980986.1522 2103988.6176 37.7560485722666 -122.50876802825701 (37.7560485722666, -122.508768028257)
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)
188070 188070 184620 DPW Maintained 3 :: 54 3000x Noriega St 2 Median : Cutout 11 Tree 1 DPW 2     0 Width 0ft   5984460.1938 2102931.6946 37.753350719104795 -122.496675818993 (37.7533507191048, -122.496675818993)
187871 187871 247375 Undocumented 2 :: 54 465 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002165.262999999 2110077.3982 37.7739925143767 -122.43595935728901 (37.7739925143767, -122.435959357289)
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)
187689 187689 183805 Undocumented 2 :: 54 2229 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987594.83 2100098.1873 37.7457538274629 -122.485627796731 (37.7457538274629, -122.485627796731)
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)
187469 187469 200742 Undocumented 2 :: 54 1454 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6015834.4667 2094922.2745 37.733146784173606 -122.38761728786601 (37.7331467841736, -122.387617287866)
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)
187223 187223 184579 Undocumented 2 :: 54 1726 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981040.0278 2103288.2098 37.7541286275124 -122.50852971834101 (37.7541286275124, -122.508529718341)
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)
187015 187015 183723 Undocumented 2 :: 54 2251 35th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985430.1991 2099886.7383 37.7450468837647 -122.493097094872 (37.7450468837647, -122.493097094872)
186840 186840 184309 Undocumented 2 :: 54 1567 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984649.0239 2104514.7444 37.7577083967054 -122.496139600622 (37.7577083967054, -122.496139600622)
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)
186765 186765 182650 Undocumented 2 :: 54 2104 Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987459.8613 2102381.6381 37.752015706495 -122.48626209833901 (37.752015706495, -122.486262098339)
186420 186420 200171 Undocumented 2 :: 54 1059 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014549.7127 2089886.9679 37.7192495938582 -122.391707122944 (37.7192495938582, -122.391707122944)
186344 186344 141278 Undocumented 2 :: 54 341 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5998088.6091 2112581.9615 37.7806369643003 -122.450241697295 (37.7806369643003, -122.450241697295)
186311 186311 244447 Undocumented 2 :: 54 418 Rose St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004438.1156 2109646.5981 37.772938497462 -122.428066467687 (37.772938497462, -122.428066467687)
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)
186274 186274 143336 Undocumented 2 :: 54 1858 UNION ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004106.6848 2118733.7418 37.797870758582 -122.429861223474 (37.797870758582, -122.429861223474)
186268 186268 183859 Undocumented 2 :: 54 2247 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987908.9096 2099989.7957 37.745474508042996 -122.484533819529 (37.745474508043, -122.484533819529)
186266 186266 141426 Undocumented 2 :: 54 305 LINDEN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005885.4207 2110859.7551 37.776351311195995 -122.42314630715299 (37.776351311196, -122.423146307153)
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)
185965 185965 140443 Undocumented 2 :: 54 1101 FILLMORE ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6003331.4074 2112177.9445 37.7798262712775 -122.432075500833 (37.7798262712775, -122.432075500833)
185918 185918 248310 Undocumented 2 :: 54 1361 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5999210.5699 2108358.152 37.7691036064762 -122.446056416567 (37.7691036064762, -122.446056416567)
185802 185802 200181 Undocumented 2 :: 54 1175 Ingerson Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     0 Width 0ft   6013299.4945 2090456.4074 37.7207436812319 -122.396068570714 (37.7207436812319, -122.396068570714)
185684 185684 184726 Undocumented 2 :: 54 1643 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5983737.3459 2103958.8726 37.7561286853049 -122.49925143388799 (37.7561286853049, -122.499251433888)
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)
185215 185215 142228 Undocumented 2 :: 54 550 LINDEN ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004723.2776 2110721.3880000003 37.775905737853705 -122.42715662811001 (37.7759057378537, -122.42715662811)
185128 185128 185827 Undocumented 2 :: 54 2041 34th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985688.7443 2101313.9256 37.748980671146604 -122.49230817773899 (37.7489806711466, -122.492308177739)
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)
184743 184743 182188 Undocumented 2 :: 54 1622 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5989666.9072 2104301.6406 37.7574159119847 -122.478770304356 (37.7574159119847, -122.478770304356)
184510 184510 244966 Undocumented 2 :: 54 250 Lily St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005265.6412 2110100.505 37.7742315998648 -122.42523625993401 (37.7742315998648, -122.425236259934)
184360 184360 183098 Undocumented 2 :: 54 2243 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5982634.3107 2099839.8811 37.744754312497896 -122.502761151096 (37.7447543124979, -122.502761151096)
184350 184350 181778 Undocumented 2 :: 54 1519 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5988463.5546 2098954.3923 37.74266384664261 -122.482540111805 (37.7426638466426, -122.482540111805)
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)
184028 184028 139040 Undocumented 2 :: 54 1434 BAKER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000201.4256 2113926.1108 37.7844483365891 -122.44302903507099 (37.7844483365891, -122.443029035071)
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)
183852 183852 185806 Undocumented 2 :: 54 1655 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5989757.0236 2101653.2343 37.7501493233055 -122.478265008437 (37.7501493233055, -122.478265008437)
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)
183839 183839 185608 Undocumented 2 :: 54 2271 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5986394.4169 2100930.0555 37.7479678972378 -122.489839763557 (37.7479678972378, -122.489839763557)
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)
183785 183785 141123 Undocumented 2 :: 54 144 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5998637.0216 2112710.0541 37.7810200422428 -122.448353710975 (37.7810200422428, -122.448353710975)
183773 183773 184423 Undocumented 2 :: 54 3737 Quintara St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981790.0458 2100770.5329 37.7472599703804 -122.50574938598301 (37.7472599703804, -122.505749385983)
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)
183643 183643 244942 Undocumented 2 :: 54 200 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005544.3019 2109980.4712 37.7739177547615 -122.42426378250299 (37.7739177547615, -122.424263782503)
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)
183313 183313 139054 Undocumented 2 :: 54 1480 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5999713.5777 2113947.3354 37.78447878674479 -122.44471834133499 (37.7844787867448, -122.444718341335)
183282 183282 138897 Undocumented 2 :: 54 620 Linden St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004450.0046 2110683.2919 37.7757856778871 -122.428099234722 (37.7757856778871, -122.428099234722)
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)
183058 183058 141642 Undocumented 2 :: 54 38 ATALAYA TER 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5998855.464 2110898.4587 37.7760583555584 -122.44746757696899 (37.7760583555584, -122.447467576969)
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)
182449 182449 200194 Undocumented 2 :: 54 1011 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014781.1104 2089713.2519999999 37.718785446443206 -122.390895127615 (37.7187854464432, -122.390895127615)
182304 182304 181975 Undocumented 2 :: 54 2708 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987607.3474 2098305.6377 37.7408326905399 -122.485452994275 (37.7408326905399, -122.485452994275)
182140 182140 182335 Undocumented 2 :: 54 1511 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985878.1025 2104923.4495 37.758902503836495 -122.491919090609 (37.7589025038365, -122.491919090609)
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)
182050 182050 200501 Undocumented 2 :: 54 1550 Armstrong Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6014687.5837 2092287.487 37.7258485955534 -122.39139827547399 (37.7258485955534, -122.391398275474)
181992 181992 138928 Undocumented 2 :: 54 658 IVY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004198.4672 2110994.6791 37.7766264359363 -122.428991572071 (37.7766264359363, -122.428991572071)
181915 181915 246180 Undocumented 2 :: 54 1588 Waller St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5997959.8858 2108225.8157 37.768668745448295 -122.450372898384 (37.7686687454483, -122.450372898384)
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)
181617 181617 200202 Undocumented 2 :: 54 1090 Ingerson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6013720.7054 2090215.6197 37.72010595277 -122.394595711042 (37.72010595277, -122.394595711042)
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)
181514 181514 182823 Undocumented 2 :: 54 2309 Noriega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5986816.3686 2102977.6207 37.753614586404794 -122.48853115934999 (37.7536145864048, -122.48853115935)
181442 181442 181522 Undocumented 2 :: 54 1279 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984580.8884 2106481.9946 37.7631059241302 -122.496520402894 (37.7631059241302, -122.496520402894)
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)
181373 181373 182320 Undocumented 2 :: 54 2955 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985629.9299 2104986.0725 37.7590599403455 -122.49278198746401 (37.7590599403455, -122.492781987464)
181306 181306 185833 Undocumented 2 :: 54 2091 34th Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985698.6694 2101072.9677 37.748319646443 -122.49225611672199 (37.748319646443, -122.492256116722)

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 447.165ms · Data source: data.sfgov.org