Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
qLegalStatus ✖
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) |
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");