Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 36416 | 36416 | 183338 | Undocumented 2 | :: 54 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.50931286551399 | (37.7637711641625, -122.509312865514) | |||
| 51060 | 51060 | 183255 | Undocumented 2 | :: 54 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.762005388573606 | -122.509188082818 | (37.7620053885736, -122.509188082818) | |||
| 162558 | 162558 | 183254 | Undocumented 2 | :: 54 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.76192682906861 | -122.50918473520399 | (37.7619268290686, -122.509184735204) | |||
| 57516 | 57516 | 183251 | Undocumented 2 | :: 54 | 1370 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980924.7337 | 2105743.1516 | 37.7608623989944 | -122.50911071225599 | (37.7608623989944, -122.509110712256) | |||
| 151530 | 151530 | 183258 | Undocumented 2 | :: 54 | 1386 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980928.6203 | 2105658.3536 | 37.760629797231395 | -122.50909097348301 | (37.7606297972314, -122.509090973483) | |||
| 153577 | 153577 | 183633 | Undocumented 2 | :: 54 | 1448 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980945.5944 | 2105199.3929 | 37.759370623772 | -122.50899818869699 | (37.759370623772, -122.508998188697) | |||
| 163622 | 163622 | 183256 | Undocumented 2 | :: 54 | 4741 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980967.1327 | 2106185.8677 | 37.7620804693646 | -122.508996949452 | (37.7620804693646, -122.508996949452) | |||
| 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) | |||
| 134641 | 134641 | 184184 | Undocumented 2 | :: 54 | 1642 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5980990.4302 | 2103889.7643 | 37.7557774014806 | -122.508745894794 | (37.7557774014806, -122.508745894794) | |||
| 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) | |||
| 137015 | 137015 | 184582 | Undocumented 2 | :: 54 | 1730 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981040.9483 | 2103264.2784 | 37.754062972946 | -122.50852475863199 | (37.754062972946, -122.508524758632) | |||
| 178356 | 178356 | 184488 | Undocumented 2 | :: 54 | 1850 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981108.2951 | 2102469.7488 | 37.7518853891009 | -122.508232891189 | (37.7518853891009, -122.508232891189) | |||
| 167206 | 167206 | 184171 | Undocumented 2 | :: 54 | 4230 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981117.7231 | 2104203.7543 | 37.7566470308009 | -122.50832898893499 | (37.7566470308009, -122.508328988935) | |||
| 56605 | 56605 | 183337 | Undocumented 2 | :: 54 | 4709 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981120.829 | 2106873.2612 | 37.7639769129553 | -122.50851641382499 | (37.7639769129553, -122.508516413825) | |||
| 26507 | 26507 | 184509 | Undocumented 2 | :: 54 | 1886 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.5546 | 2102268.3878 | 37.751333525850896 | -122.50815826243401 | (37.7513335258509, -122.508158262434) | |||
| 49859 | 49859 | 184504 | Undocumented 2 | :: 54 | 1878 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.892999999 | 2102290.0468 | 37.751393015279 | -122.50815869964501 | (37.751393015279, -122.508158699645) | |||
| 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) | |||
| 41978 | 41978 | 184524 | Undocumented 2 | :: 54 | 1984 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981181.0558 | 2101584.0989 | 37.7494579320564 | -122.50791555821199 | (37.7494579320564, -122.507915558212) | |||
| 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) | |||
| 178886 | 178886 | 183351 | Undocumented 2 | :: 54 | 1214 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981199.8295 | 2106780.9272 | 37.7637280462203 | -122.508236325462 | (37.7637280462203, -122.508236325462) | |||
| 158331 | 158331 | 184392 | Undocumented 2 | :: 54 | 2040 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5981213.3751 | 2101162.7638 | 37.748302968665705 | -122.50777253673 | (37.7483029686657, -122.50777253673) | |||
| 180436 | 180436 | 184397 | Undocumented 2 | :: 54 | 2048 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981217.0977 | 2101115.7232 | 37.748174027722996 | -122.50775617404601 | (37.748174027723, -122.507756174046) | |||
| 180883 | 180883 | 184731 | Undocumented 2 | :: 54 | 1531 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981237.2508 | 2104496.4966 | 37.7574578608752 | -122.507937351177 | (37.7574578608752, -122.507937351177) | |||
| 171774 | 171774 | 184177 | Undocumented 2 | :: 54 | 1605 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981248.1823 | 2104131.4737 | 37.7564562562261 | -122.507872457928 | (37.7564562562261, -122.507872457928) | |||
| 44250 | 44250 | 184634 | DPW Maintained 3 | :: 54 | 4100x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981271.0577 | 2102821.0876 | 37.7528596561113 | -122.507696113948 | (37.7528596561113, -122.507696113948) | |||
| 178156 | 178156 | 184730 | Undocumented 2 | :: 54 | 1526 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981274.3167 | 2104688.5654 | 37.7579874108033 | -122.507823417876 | (37.7579874108033, -122.507823417876) | |||
| 177950 | 177950 | 181597 | Undocumented 2 | :: 54 | 1402 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981283.949 | 2105512.8626 | 37.7602512624102 | -122.507851276945 | (37.7602512624102, -122.507851276945) | |||
| 137256 | 137256 | 184633 | Undocumented 2 | :: 54 | 1817 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981297.1345 | 2102687.6924 | 37.7524949268988 | -122.50759603982 | (37.7524949268988, -122.50759603982) | |||
| 43692 | 43692 | 184528 | Undocumented 2 | :: 54 | 1961 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981337.7451 | 2101542.4731 | 37.7493528701871 | -122.507370643946 | (37.7493528701871, -122.507370643946) | |||
| 100579 | 100579 | 117313 | Permitted Site 1 | :: 54 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981355.6 | 2109736.3 | 37.7718518197324 | -122.50791691513099 | (37.7718518197324, -122.507916915131) | |||||
| 24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
| 150982 | 150982 | 184531 | Undocumented 2 | :: 54 | 4043 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981413.5516 | 2102117.7901 | 37.7509369936281 | -122.507151182389 | (37.7509369936281, -122.507151182389) | |||
| 173511 | 173511 | 184452 | Undocumented 2 | :: 54 | 2142 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981413.7208 | 2100483.5512 | 37.746449842726896 | -122.507029381635 | (37.7464498427269, -122.507029381635) | |||
| 131217 | 131217 | 184172 | Undocumented 2 | :: 54 | 4145 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981416.401000001 | 2104160.656 | 37.7565462922692 | -122.507292873512 | (37.7565462922692, -122.507292873512) | |||
| 164146 | 164146 | 184474 | Undocumented 2 | :: 54 | 2186 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981423.3658 | 2100215.0135 | 37.745713081334 | -122.506976114504 | (37.745713081334, -122.506976114504) | |||
| 55807 | 55807 | 184469 | Undocumented 2 | :: 54 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.74576606648579 | -122.506976375045 | (37.7457660664858, -122.506976375045) | |||
| 77222 | 77222 | 184515 | Undocumented 2 | :: 54 | 4042 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981427.7653 | 2102174.645 | 37.7510939382872 | -122.507106248147 | (37.7510939382872, -122.507106248147) | |||
| 137303 | 137303 | 184371 | Undocumented 2 | :: 54 | 2282 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981448.1763 | 2099546.5215 | 37.7438790499345 | -122.506840749339 | (37.7438790499345, -122.506840749339) | |||
| 116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 71799 | 71799 | 183287 | Undocumented 2 | :: 54 | 1259 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981476.8749 | 2106516.0091 | 37.7630169795519 | -122.50725847250901 | (37.7630169795519, -122.507258472509) | |||
| 135799 | 135799 | 183114 | Undocumented 2 | :: 54 | 3650 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981483.4357 | 2099456.1026 | 37.7436328611158 | -122.506712127755 | (37.7436328611158, -122.506712127755) | |||
| 171184 | 171184 | 183041 | Undocumented 2 | :: 54 | 2518 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981505.7715 | 2097922.8827 | 37.7394243796804 | -122.506521214497 | (37.7394243796804, -122.506521214497) | |||
| 130550 | 130550 | 183044 | Undocumented 2 | :: 54 | 2538 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981509.8326 | 2097796.9898 | 37.739078951665704 | -122.50649783936599 | (37.7390789516657, -122.506497839366) | |||
| 95413 | 95413 | 118419 | Undocumented 2 | :: 54 | 5507 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5981562.4785 | 2111629.449 | 37.7770620385939 | -122.507341801673 | (37.7770620385939, -122.507341801673) | ||||
| 129782 | 129782 | 183637 | Undocumented 2 | :: 54 | 1478 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981569.3227 | 2105033.4266 | 37.758951677708204 | -122.506828758953 | (37.7589516777082, -122.506828758953) | |||
| 73677 | 73677 | 184188 | Undocumented 2 | :: 54 | 1659 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981571.3272 | 2103786.0218 | 37.7555267773851 | -122.506729307239 | (37.7555267773851, -122.506729307239) | |||
| 172492 | 172492 | 183657 | Undocumented 2 | :: 54 | 1490 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981573.7378 | 2104946.7308 | 37.758713895791296 | -122.50680705930401 | (37.7587138957913, -122.506807059304) | |||
| 149039 | 149039 | 184191 | Undocumented 2 | :: 54 | 1679 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981575.9108 | 2103660.4307 | 37.7551822097756 | -122.50670414153099 | (37.7551822097756, -122.506704141531) | |||
| 54992 | 54992 | 184123 | Undocumented 2 | :: 54 | 1566 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981590.4236 | 2104415.5069999998 | 37.7572562892484 | -122.50670995310101 | (37.7572562892484, -122.506709953101) | |||
| 39829 | 39829 | 183315 | Undocumented 2 | :: 54 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981596.8931 | 2106261.3364 | 37.7623247898963 | -122.506824486966 | (37.7623247898963, -122.506824486966) | |||
| 109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
| 162177 | 162177 | 184618 | DPW Maintained 3 | :: 54 | 3900x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981674.4395 | 2102837.4254 | 37.7529282714167 | -122.506302380507 | (37.7529282714167, -122.506302380507) | |||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 36998 | 36998 | 184372 | Undocumented 2 | :: 54 | 2263 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981709.435 | 2099687.8805 | 37.7442825640676 | -122.50594787141 | (37.7442825640676, -122.50594787141) | |||
| 168574 | 168574 | 184154 | Undocumented 2 | :: 54 | 4036 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981710.2029 | 2104227.1296 | 37.756746110874296 | -122.506281748334 | (37.7567461108743, -122.506281748334) | |||
| 36154 | 36154 | 184467 | Undocumented 2 | :: 54 | 2182 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981733.5294 | 2100249.3634 | 37.7458256579494 | -122.50590617914699 | (37.7458256579494, -122.505906179147) | |||
| 149169 | 149169 | 184505 | Undocumented 2 | :: 54 | 3940 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981746.2202 | 2102187.1666 | 37.751147069673706 | -122.506005945548 | (37.7511470696737, -122.506005945548) | |||
| 161879 | 161879 | 184421 | Undocumented 2 | :: 54 | 3741 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981751.4657 | 2100769.1792 | 37.7472539827413 | -122.505882690421 | (37.7472539827413, -122.505882690421) | |||
| 158169 | 158169 | 183195 | Undocumented 2 | :: 54 | 2467 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981757.2189 | 2098306.9914 | 37.740493837912396 | -122.505680301686 | (37.7404938379124, -122.505680301686) | |||
| 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) | |||
| 179549 | 179549 | 183170 | Undocumented 2 | :: 54 | 2382 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981781.9237 | 2098892.7996 | 37.74210375914 | -122.505638298262 | (37.74210375914, -122.505638298262) | |||
| 36846 | 36846 | 183277 | Undocumented 2 | :: 54 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | |||
| 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) | |||
| 147904 | 147904 | 183186 | Undocumented 2 | :: 54 | 2446 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.1527 | 2098421.378 | 37.740810262110294 | -122.505550705456 | (37.7408102621103, -122.505550705456) | |||
| 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) | |||
| 137654 | 137654 | 182938 | Undocumented 2 | :: 54 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | |||
| 76338 | 76338 | 184424 | Undocumented 2 | :: 54 | 3735 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981804.597999999 | 2100770.5329 | 37.7472608268582 | -122.50569906643601 | (37.7472608268582, -122.505699066436) | |||
| 34742 | 34742 | 183206 | Undocumented 2 | :: 54 | 2486 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981807.3053 | 2098184.1443 | 37.7401594813682 | -122.50549802177 | (37.7401594813682, -122.50549802177) | |||
| 59328 | 59328 | 183210 | Undocumented 2 | :: 54 | 2494 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981807.3053 | 2098133.0426 | 37.740019170203205 | -122.50549423487499 | (37.7400191702032, -122.505494234875) | |||
| 29214 | 29214 | 182945 | Undocumented 2 | :: 54 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | |||
| 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) | |||
| 35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
| 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) | |||
| 147162 | 147162 | 182943 | Undocumented 2 | :: 54 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | |||
| 154543 | 154543 | 182944 | Undocumented 2 | :: 54 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.50524888568701 | (37.7365450979685, -122.505248885687) | |||
| 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) | |||
| 131228 | 131228 | 184727 | Undocumented 2 | :: 54 | 3941 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981943.3641 | 2104178.2266 | 37.756625560975706 | -122.505471780608 | (37.7566255609757, -122.505471780608) | |||
| 147569 | 147569 | 184894 | Undocumented 2 | :: 54 | 1784 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981950.5709 | 2102944.1962 | 37.753237686600706 | -122.505355395478 | (37.7532376866007, -122.505355395478) | |||
| 24313 | 24313 | 184893 | Undocumented 2 | :: 54 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.753189803786896 | -122.505346142178 | (37.7531898037869, -122.505346142178) | |||
| 41665 | 41665 | 184892 | Undocumented 2 | :: 54 | 1788 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981953.7924 | 2102910.6002 | 37.753145631025 | -122.505341765185 | (37.753145631025, -122.505341765185) | |||
| 123820 | 123820 | 184470 | Undocumented 2 | :: 54 | 2159 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981994.4526 | 2100401.9916 | 37.7462600872151 | -122.50501526782601 | (37.7462600872151, -122.505015267826) | |||
| 151546 | 151546 | 182946 | Undocumented 2 | :: 54 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | |||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 49826 | 49826 | 183146 | Undocumented 2 | :: 54 | 2314 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982075.842999999 | 2099327.1639 | 37.743313697016895 | -122.504654211145 | (37.7433136970169, -122.504654211145) | |||
| 53583 | 53583 | 183266 | Undocumented 2 | :: 54 | 1235 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982090.5566 | 2106669.6909 | 37.7634750727275 | -122.50514738366999 | (37.7634750727275, -122.50514738367) | |||
| 74865 | 74865 | 182936 | Undocumented 2 | :: 54 | 2643 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982105.6241 | 2097104.0711 | 37.737211448275794 | -122.50438657908998 | (37.7372114482758, -122.50438657909) | |||
| 35957 | 35957 | 183110 | Undocumented 2 | :: 54 | 3474 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982112.0542 | 2099478.6077 | 37.7437316497768 | -122.504540222201 | (37.7437316497768, -122.504540222201) | |||
| 134100 | 134100 | 183108 | Undocumented 2 | :: 54 | 3454 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982137.4358 | 2099478.9461 | 37.7437340718642 | -122.504452485254 | (37.7437340718642, -122.504452485254) | |||
| 153241 | 153241 | 183271 | Undocumented 2 | :: 54 | 1242 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982138.4385 | 2106630.5909 | 37.7633705325139 | -122.504978880674 | (37.7633705325139, -122.504978880674) | |||
| 170815 | 170815 | 183268 | Undocumented 2 | :: 54 | 1254 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982139.2748 | 2106566.1909 | 37.763193757767 | -122.504971215621 | (37.763193757767, -122.504971215621) | |||
| 149711 | 149711 | 183631 | Undocumented 2 | :: 54 | 1451 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982139.8696 | 2105211.8354 | 37.7594751192783 | -122.50486879402 | (37.7594751192783, -122.50486879402) | |||
| 179181 | 179181 | 181694 | Undocumented 2 | :: 54 | 1356 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982161.9827 | 2105857.6697 | 37.7612496970921 | -122.504840173741 | (37.7612496970921, -122.504840173741) |
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");