Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189044 | 189044 | 181896 | Undocumented 2 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | |||
| 188881 | 188881 | 248375 | Undocumented 2 | Tree(s) :: 17 | 1605 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997870.7026 | 2108171.6093 | 37.7685148040368 | -122.45067746589199 | (37.7685148040368, -122.450677465892) | |||
| 188562 | 188562 | 53797 | Permitted Site 1 | Tree(s) :: 17 | 1718 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 0 | Permit Number 9489 | 5983493.18755195 | 2103436.99678987 | 37.7546814335819 | -122.500057225325 | (37.7546814335819, -122.500057225325) | ||
| 187762 | 187762 | 101517 | Permitted Site 1 | Tree(s) :: 17 | 170 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 15 | 3x3 | Permit Number 769472 | 6010021.5 | 2121128.5 | 37.804779349428294 | -122.409563317566 | (37.8047793494283, -122.409563317566) | |
| 187716 | 187716 | 56729 | Permitted Site 1 | Tree(s) :: 17 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | ||
| 187679 | 187679 | 183113 | Undocumented 2 | Tree(s) :: 17 | 2274 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982688.1277 | 2099641.1357 | 37.7442117751214 | -122.502560357892 | (37.7442117751214, -122.502560357892) | |||
| 187232 | 187232 | 42883 | Permitted Site 1 | Tree(s) :: 17 | 2511 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 2 | Permit Number 42804 | 5985798.1204 | 2098115.3222 | 37.740204561911 | -122.491694530042 | (37.740204561911, -122.491694530042) | |
| 187108 | 187108 | 185442 | Undocumented 2 | Tree(s) :: 17 | 2300 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985068.6448 | 2099480.8089 | 37.7439111594648 | -122.49431735118601 | (37.7439111594648, -122.494317351186) | |||
| 186658 | 186658 | 51576 | Permitted Site 1 | Tree(s) :: 17 | 1266 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | 0 | Permit Number 47870 | 5983696.81147736 | 2106537.65346328 | 37.7632069139906 | -122.49958219181002 | (37.7632069139906, -122.49958219181) | ||
| 185948 | 185948 | 218383 | Undocumented 2 | Tree(s) :: 17 | 398 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5993334.06783 | 2100029.01263 | 37.745896622722704 | -122.465777482764 | (37.7458966227227, -122.465777482764) | |||
| 185727 | 185727 | 105413 | Undocumented 2 | Tree(s) :: 17 | 1631 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010454.7 | 2120100.7 | 37.8019815285909 | -122.40799165142401 | (37.8019815285909, -122.407991651424) | |||
| 185539 | 185539 | 140148 | Undocumented 2 | Tree(s) :: 17 | 1819 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999094.2378 | 2110075.0205 | 37.7738110471204 | -122.446582340893 | (37.7738110471204, -122.446582340893) | |||
| 185238 | 185238 | 54501 | Permitted Site 1 | Tree(s) :: 17 | 981 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 9 | Permit Number 10294 | 6003131.59212331 | 2110978.68598933 | 37.776522075700996 | -122.432681058715 | (37.776522075701, -122.432681058715) | ||
| 184732 | 184732 | 182998 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988837.0147 | 2098290.3442 | 37.7408622633805 | -122.481200194801 | (37.7408622633805, -122.481200194801) | |||
| 184537 | 184537 | 38660 | Permitted Site 1 | Tree(s) :: 17 | 753 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | 6 | Permit Number 40583 | 6000472.7155 | 2111596.6364 | 37.7780676608903 | -122.441923213591 | (37.7780676608903, -122.441923213591) | ||
| 184180 | 184180 | 43547 | Permitted Site 1 | Tree(s) :: 17 | 1845 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 6 | Permit Number 43211 | 6000276.2358 | 2111277.2601 | 37.777179536921395 | -122.442579968638 | (37.7771795369214, -122.442579968638) | |
| 183570 | 183570 | 55470 | Permitted Site 1 | Tree(s) :: 17 | 1250 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2008 12:00:00 AM | 0 | 3x3 | Permit Number 51481 | 6001827.19703832 | 2110851.96844675 | 37.7761000796389 | -122.43718425257099 | (37.7761000796389, -122.437184252571) | |
| 183366 | 183366 | 56906 | Permitted Site 1 | Tree(s) :: 17 | 1887 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1974 12:00:00 AM | 0 | Permit Number 14147 | 5985648.5890945 | 2102388.7148450003 | 37.7519294017711 | -122.49252617444598 | (37.7519294017711, -122.492526174446) | ||
| 183222 | 183222 | 184542 | Undocumented 2 | Tree(s) :: 17 | 1701 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983751.3694 | 2103536.962 | 37.7549710592824 | -122.49917176279301 | (37.7549710592824, -122.499171762793) | |||
| 182985 | 182985 | 184165 | Undocumented 2 | Tree(s) :: 17 | 1587 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981553.7564 | 2104301.6861 | 37.7569416102721 | -122.506828318107 | (37.7569416102721, -122.506828318107) | |||
| 182616 | 182616 | 37194 | Permitted Site 1 | Tree(s) :: 17 | 1730 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 4 | Permit Number 39761 | 5986910.8577 | 2103468.9464 | 37.75496914634179 | -122.488240502595 | (37.7549691463418, -122.488240502595) | |
| 182443 | 182443 | 182953 | Undocumented 2 | Tree(s) :: 17 | 2412 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989852.4772 | 2098974.9262 | 37.7428009306659 | -122.477739171693 | (37.7428009306659, -122.477739171693) | |||
| 181878 | 181878 | 58387 | Permitted Site 1 | Tree(s) :: 17 | 1274 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1979 12:00:00 AM | 0 | Permit Number 17521 | 5982457.61947385 | 2106442.65871918 | 37.7628732978176 | -122.503861036332 | (37.7628732978176, -122.503861036332) | ||
| 181596 | 181596 | 74931 | Permitted Site 1 | Tree(s) :: 17 | 1440 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2012 12:00:00 AM | 5 | Permit Number 769218 | 5982493.6769 | 2105277.0579 | 37.759675009998 | -122.503650004455 | (37.759675009998, -122.503650004455) | ||
| 181557 | 181557 | 181793 | Undocumented 2 | Tree(s) :: 17 | 1335 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986245.1996 | 2098199.0349 | 37.7404605336373 | -122.490154887771 | (37.7404605336373, -122.490154887771) | |||
| 181275 | 181275 | 107668 | Undocumented 2 | Tree(s) :: 17 | 1900 NORIEGA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 5987954.3 | 2103103.9 | 37.754027649170496 | -122.48460525258801 | (37.7540276491705, -122.484605252588) | |||
| 180456 | 180456 | 217558 | Undocumented 2 | Tree(s) :: 17 | 111 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5995801.8375 | 2088036.5277 | 37.7131101902365 | -122.456377320317 | (37.7131101902365, -122.456377320317) | |||
| 180172 | 180172 | 45744 | Permitted Site 1 | Tree(s) :: 17 | 2390 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | 5 | Permit Number 44393 | 5984264.1619 | 2098921.872 | 37.742329358906495 | -122.49705777690001 | (37.7423293589065, -122.4970577769) | ||
| 179312 | 179312 | 242819 | Undocumented 2 | Tree(s) :: 17 | 173 Addison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002620.3556 | 2097408.25534 | 37.7392319251012 | -122.43347956444299 | (37.7392319251012, -122.433479564443) | |||
| 179209 | 179209 | 54146 | Permitted Site 1 | Tree(s) :: 17 | 1482 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 0 | Permit Number 9881 | 5984367.42341102 | 2105093.5901913997 | 37.75928124701571 | -122.49715620319401 | (37.7592812470157, -122.497156203194) | ||
| 179158 | 179158 | 55811 | Permitted Site 1 | Tree(s) :: 17 | 1435 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1973 12:00:00 AM | 6 | Permit Number 11858 | 5982133.47728316 | 2105331.56508435 | 37.7598034868382 | -122.504899773682 | (37.7598034868382, -122.504899773682) | ||
| 178596 | 178596 | 183350 | Undocumented 2 | Tree(s) :: 17 | 1226 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983375.0645 | 2106778.1026 | 37.7638482352302 | -122.500712771127 | (37.7638482352302, -122.500712771127) | |||
| 177909 | 177909 | 187258 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984954.3762 | 2098434.6407 | 37.7410319765896 | -122.494635349253 | (37.7410319765896, -122.494635349253) | |||
| 177706 | 177706 | 102655 | Permitted Site 1 | Tree(s) :: 17 | 2700 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769687 | 5982502.5 | 2096638.9 | 37.7359575501703 | -122.50297999341801 | (37.7359575501703, -122.502979993418) | |
| 177214 | 177214 | 102659 | Permitted Site 1 | Tree(s) :: 17 | 2700 45th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769687 | 5982502.5 | 2096638.9 | 37.7359575501703 | -122.50297999341801 | (37.7359575501703, -122.502979993418) | |
| 176967 | 176967 | 38692 | Permitted Site 1 | Tree(s) :: 17 | 1988 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | Permit Number 40606 | 5998373.5149 | 2110020.9141 | 37.773621290719 | -122.44907152769899 | (37.773621290719, -122.449071527699) | |
| 176390 | 176390 | 101873 | Undocumented 2 | Tree(s) :: 17 | 737 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | 11 | 3x3 | Permit Number 776173 | 6012702.0 | 2113175.0 | 37.7830907593936 | -122.39972830907101 | (37.7830907593936, -122.399728309071) | |
| 176245 | 176245 | 37117 | Permitted Site 1 | Tree(s) :: 17 | 4542 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3 | Permit Number 39708 | 5981604.0022 | 2106261.3364 | 37.762325208532204 | -122.506799899678 | (37.7623252085322, -122.506799899678) | |
| 176167 | 176167 | 245429 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009412.7194 | 2106896.5344 | 37.7656676512165 | -122.41066440163 | (37.7656676512165, -122.41066440163) | |||
| 175806 | 175806 | 246166 | Undocumented 2 | Tree(s) :: 17 | 699 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997552.2779 | 2108203.1035 | 37.7685830471749 | -122.45178113630199 | (37.7685830471749, -122.451781136302) | |||
| 175678 | 175678 | 45746 | Permitted Site 1 | Tree(s) :: 17 | 2390 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | 4 | Permit Number 44393 | 5984264.1619 | 2098961.7246 | 37.742438783316494 | -122.497060717848 | (37.7424387833165, -122.497060717848) | ||
| 174836 | 174836 | 101097 | Permitted Site 1 | Tree(s) :: 17 | 1390 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776812 | 5989713.0 | 2103139.0 | 37.754226286963394 | -122.478525879994 | (37.7542262869634, -122.478525879994) | |
| 174527 | 174527 | 244196 | Undocumented 2 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | |||
| 174418 | 174418 | 245423 | Undocumented 2 | Tree(s) :: 17 | 2440 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009278.6196 | 2106887.9748 | 37.7656366291234 | -122.411127620702 | (37.7656366291234, -122.411127620702) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 174156 | 174156 | 54859 | Permitted Site 1 | Tree(s) :: 17 | 1830 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 25 | Permit Number 10718 | 5999038.10946992 | 2110464.35352985 | 37.774876849819606 | -122.446804517086 | (37.7748768498196, -122.446804517086) | ||
| 173610 | 173610 | 53795 | Permitted Site 1 | Tree(s) :: 17 | 1714 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 0 | Permit Number 9487 | 5983492.31955345 | 2103462.89049457 | 37.754752479519205 | -122.50006214108299 | (37.7547524795192, -122.500062141083) | ||
| 172719 | 172719 | 99881 | Permitted Site 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 0 | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.38794111256901 | (37.7343393212403, -122.387941112569) | ||
| 172358 | 172358 | 55071 | Permitted Site 1 | Tree(s) :: 17 | 3730 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 0 | Permit Number 10965 | 5982718.68042954 | 2104258.25583287 | 37.7568908940411 | -122.502796425379 | (37.7568908940411, -122.502796425379) | ||
| 171966 | 171966 | 59345 | Permitted Site 1 | Tree(s) :: 17 | 124 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1997 12:00:00 AM | 0 | Permit Number 38544 | 5996249.80129188 | 2113584.85109083 | 37.7832852310544 | -122.45667552458099 | (37.7832852310544, -122.456675524581) | ||
| 171864 | 171864 | 185485 | Undocumented 2 | Tree(s) :: 17 | 2400 Sunset Blvd | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985115.7608 | 2098504.4307 | 37.741233045699296 | -122.49408249075898 | (37.7412330456993, -122.494082490759) | |||
| 171680 | 171680 | 71999 | Undocumented 2 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | ||
| 170648 | 170648 | 52779 | Permitted Site 1 | Tree(s) :: 17 | 1206@ LINCOLN 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2006 12:00:00 AM | 0 | Permit Number 48823 | 5986164.024171599 | 2107018.4609689997 | 37.7646715330126 | -122.491084428282 | (37.7646715330126, -122.491084428282) | ||
| 170604 | 170604 | 248347 | Undocumented 2 | Tree(s) :: 17 | 721 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999017.0621 | 2108165.2499 | 37.7685628940185 | -122.446711864634 | (37.7685628940185, -122.446711864634) | |||
| 170511 | 170511 | 184868 | Undocumented 2 | Tree(s) :: 17 | 1201 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984647.5418 | 2106829.3717 | 37.7640636286505 | -122.496315507283 | (37.7640636286505, -122.496315507283) | |||
| 170151 | 170151 | 45587 | Permitted Site 1 | Tree(s) :: 17 | 1750 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2014 12:00:00 AM | 4 | Permit Number 772727 | 5986287.001 | 2103325.5133 | 37.754538901135604 | -122.49038739521299 | (37.7545389011356, -122.490387395213) | |
| 169626 | 169626 | 137782 | Undocumented 2 | Tree(s) :: 17 | 2150 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999247.9506 | 2111533.9702 | 37.7778257282723 | -122.44615559025401 | (37.7778257282723, -122.446155590254) | |||
| 168871 | 168871 | 245449 | Undocumented 2 | Tree(s) :: 17 | 2798 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008185.848999999 | 2106828.0579 | 37.7654107681137 | -122.414903044666 | (37.7654107681137, -122.414903044666) | |||
| 168862 | 168862 | 140655 | Undocumented 2 | Tree(s) :: 17 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997284.8727 | 2109868.0812 | 37.7731393281573 | -122.452826253374 | (37.7731393281573, -122.452826253374) | |||
| 168745 | 168745 | 62012 | Permitted Site 1 | Tree(s) :: 17 | 1363 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1985 12:00:00 AM | 2 | Permit Number 22082 | 5983977.58757244 | 2105891.90177142 | 37.761450332565204 | -122.498563393002 | (37.7614503325652, -122.498563393002) | ||
| 168268 | 168268 | 246139 | Undocumented 2 | Tree(s) :: 17 | 636 Shrader St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5997577.8669 | 2108330.4431 | 37.7689341546251 | -122.45170181346 | (37.7689341546251, -122.45170181346) | |||
| 168113 | 168113 | 70380 | Undocumented 2 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | ||
| 167581 | 167581 | 141539 | Undocumented 2 | Tree(s) :: 17 | 40 CHABOT TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997745.2023 | 2111425.8484 | 37.7774429210765 | -122.451346293495 | (37.7774429210765, -122.451346293495) | |||
| 167295 | 167295 | 244211 | Undocumented 2 | Tree(s) :: 17 | 787 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002859.2926 | 2109561.26 | 37.7726147287694 | -122.43352170101002 | (37.7726147287694, -122.43352170101) | |||
| 166810 | 166810 | 200837 | Undocumented 2 | Tree(s) :: 17 | 1499 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6012066.6589 | 2106983.5566 | 37.766055033997 | -122.401491065628 | (37.766055033997, -122.401491065628) | |||
| 166806 | 166806 | 37099 | Permitted Site 1 | Tree(s) :: 17 | 1530 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 774502 | 5981587.98949699 | 2104658.53862904 | 37.7579234415311 | -122.506736396207 | (37.7579234415311, -122.506736396207) | |
| 166334 | 166334 | 59267 | Permitted Site 1 | Tree(s) :: 17 | 4417 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1980 12:00:00 AM | 7 | Permit Number 18602 | 5982005.4942 | 2106221.0655 | 37.762238270637496 | -122.50540832778098 | (37.7622382706375, -122.505408327781) | ||
| 165386 | 165386 | 30715 | Permitted Site 1 | Tree(s) :: 17 | 111 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2013 12:00:00 AM | 1 | Permit Number 769858 | 6005888.3509 | 2109985.2033 | 37.773950168784104 | -122.423073994835 | (37.7739501687841, -122.423073994835) | |
| 164110 | 164110 | 33681 | Permitted Site 1 | Tree(s) :: 17 | 417 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37761 | 6005353.591048 | 2111118.12961634 | 37.777030717838706 | -122.425004443456 | (37.7770307178387, -122.425004443456) | ||
| 163496 | 163496 | 245422 | Undocumented 2 | Tree(s) :: 17 | 2440 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009304.2983 | 2106887.9748 | 37.76563806915021 | -122.41103880337299 | (37.7656380691502, -122.411038803373) | |||
| 162598 | 162598 | 182996 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988803.3443 | 2098288.7961 | 37.740856055179 | -122.481316499792 | (37.740856055179, -122.481316499792) | |||
| 162290 | 162290 | 248305 | Undocumented 2 | Tree(s) :: 17 | 2445 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009252.3493 | 2106835.4345 | 37.7654908922731 | -122.41121477248501 | (37.7654908922731, -122.411214772485) | |||
| 161844 | 161844 | 66990 | Permitted Site 1 | Tree(s) :: 17 | 2501 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1992 12:00:00 AM | 0 | Permit Number 30342 | 5988273.30614375 | 2098276.97144044 | 37.7407927573559 | -122.483148285306 | (37.7407927573559, -122.483148285306) | ||
| 161836 | 161836 | 183622 | Undocumented 2 | Tree(s) :: 17 | 1423 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982443.5057 | 2105397.4688 | 37.7600026741936 | -122.50383243677601 | (37.7600026741936, -122.503832436776) | |||
| 161387 | 161387 | 225019 | Undocumented 2 | Tree(s) :: 17 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779083 | 6001573.01872 | 2104694.86149 | 37.7591797334691 | -122.437622474895 | (37.7591797334691, -122.437622474895) | |
| 161000 | 161000 | 244932 | Undocumented 2 | Tree(s) :: 17 | 276 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005259.2596 | 2109945.2207 | 37.7738048663185 | -122.425247283021 | (37.7738048663185, -122.425247283021) | |||
| 160087 | 160087 | 185119 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 5987585.1902 | 2095924.1623 | 37.734292492791205 | -122.485354895586 | (37.7342924927912, -122.485354895586) | |||
| 159984 | 159984 | 184386 | Undocumented 2 | Tree(s) :: 17 | 2206 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981432.167 | 2100021.6921 | 37.74518279309439 | -122.506931344351 | (37.7451827930944, -122.506931344351) | |||
| 159771 | 159771 | 66116 | Permitted Site 1 | Tree(s) :: 17 | 1934 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 0 | Permit Number 776048 | 6003423.31266609 | 2115338.97807743 | 37.7885108844538 | -122.431983344244 | (37.7885108844538, -122.431983344244) | ||
| 159665 | 159665 | 187219 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984931.5011 | 2098800.6417 | 37.7420355776419 | -122.494741419283 | (37.7420355776419, -122.494741419283) | |||
| 159583 | 159583 | 63922 | Permitted Site 1 | Tree(s) :: 17 | 1521 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1987 12:00:00 AM | 8 | Permit Number 24644 | 5989905.21079034 | 2105007.13296041 | 37.7593668395475 | -122.477997740662 | (37.7593668395475, -122.477997740662) | ||
| 159578 | 159578 | 113281 | Undocumented 2 | Tree(s) :: 17 | 1952 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 4 | 3x3 | Permit Number 776707 | 6003632.0 | 2118747.0 | 37.797880269687205 | -122.43150471262301 | (37.7978802696872, -122.431504712623) | |
| 159012 | 159012 | 247342 | Undocumented 2 | Tree(s) :: 17 | 415 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998861.9742 | 2109259.5681 | 37.771558753373604 | -122.447327071467 | (37.7715587533736, -122.447327071467) | |||
| 158746 | 158746 | 251040 | Undocumented 2 | Tree(s) :: 17 | 5455 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990029.1728 | 2112611.0353 | 37.780252275913206 | -122.478124966747 | (37.7802522759132, -122.478124966747) | |||
| 158557 | 158557 | 181796 | Undocumented 2 | Tree(s) :: 17 | 1821 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987227.4689 | 2099598.2398 | 37.7443596934286 | -122.486861354396 | (37.7443596934286, -122.486861354396) | |||
| 158053 | 158053 | 67879 | Permitted Site 1 | Tree(s) :: 17 | 2395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1993 12:00:00 AM | 0 | Permit Number 31571 | 5981736.0610128 | 2098797.96942293 | 37.741840682477495 | -122.505789845634 | (37.7418406824775, -122.505789845634) | ||
| 157955 | 157955 | 58911 | Permitted Site 1 | Tree(s) :: 17 | 1201 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2012 12:00:00 AM | 17 | Permit Number 769124 | 5990115.8149 | 2107069.3928 | 37.765041472479 | -122.47742010053301 | (37.765041472479, -122.477420100533) | ||
| 157924 | 157924 | 33679 | Permitted Site 1 | Tree(s) :: 17 | 447 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 5 | Permit Number 37759 | 6005216.65520522 | 2111098.99416985 | 37.77697044053021 | -122.425476785319 | (37.7769704405302, -122.425476785319) | ||
| 157112 | 157112 | 41217 | Permitted Site 1 | Tree(s) :: 17 | 417 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2012 12:00:00 AM | 1 | Permit Number 56581 | 6000146.8802 | 2110487.8057 | 37.775004521454896 | -122.44297074216601 | (37.7750045214549, -122.442970742166) | |
| 157087 | 157087 | 183864 | Undocumented 2 | Tree(s) :: 17 | 2254 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988575.0483 | 2099965.8983 | 37.7454476614099 | -122.482228694166 | (37.7454476614099, -122.482228694166) | |||
| 156770 | 156770 | 185189 | Undocumented 2 | Tree(s) :: 17 | 2500 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985143.9825 | 2097859.9805 | 37.73946521004989 | -122.49393742902299 | (37.7394652100499, -122.493937429023) | |||
| 156432 | 156432 | 183178 | Undocumented 2 | Tree(s) :: 17 | 2400 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984267.6273 | 2098780.6554 | 37.7419418195562 | -122.49703537374701 | (37.7419418195562, -122.497035373747) | |||
| 155872 | 155872 | 183000 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988864.8798 | 2098290.3442 | 37.740863883309295 | -122.481103848794 | (37.7408638833093, -122.481103848794) | |||
| 155529 | 155529 | 38549 | Permitted Site 1 | Tree(s) :: 17 | 1843 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40519 | 6015893.6443 | 2093219.8325 | 37.7284754960653 | -122.387293979367 | (37.7284754960653, -122.387293979367) | |
| 155125 | 155125 | 51086 | Permitted Site 1 | Tree(s) :: 17 | 4526 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 0 | Permit Number 769194 | 5981733.0 | 2106264.0 | 37.762340117458294 | -122.50635394981 | (37.7623401174583, -122.50635394981) | ||
| 154521 | 154521 | 181791 | Undocumented 2 | Tree(s) :: 17 | 1341 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986208.9885 | 2098197.3427 | 37.7404537725549 | -122.49027996541099 | (37.7404537725549, -122.490279965411) | |||
| 154389 | 154389 | 183001 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988878.4254 | 2098290.3442 | 37.740864670750106 | -122.48105701370199 | (37.7408646707501, -122.481057013702) | |||
| 153371 | 153371 | 70197 | Permitted Site 1 | Tree(s) :: 17 | 2215 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 6 | 6x12 | Permit Number 776755 | 5987589.2824 | 2100208.7125 | 37.74605697699771 | -122.485655089361 | (37.7460569769977, -122.485655089361) | |
| 153120 | 153120 | 141479 | Undocumented 2 | Tree(s) :: 17 | 2202 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998955.347999999 | 2111499.0776 | 37.7777132080241 | -122.44716528854201 | (37.7777132080241, -122.447165288542) | |||
| 153098 | 153098 | 181336 | Undocumented 2 | Tree(s) :: 17 | 1260 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5986177.8228 | 2106650.4552 | 37.763661897731104 | -122.49100962005 | (37.7636618977311, -122.49100962005) |
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");