Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10208 | 10208 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999984.0 | 2103563.0 | 37.7559814441149 | -122.44303676104799 | (37.7559814441149, -122.443036761048) | |||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 20477 | 20477 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 23001 | 23001 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 363 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | |||||
| 47274 | 47274 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 51543 | 51543 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 180 Yukon St | Back Yard : Cutout 16 | Tree 1 | Private 1 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.44240692055901 | (37.7570738455347, -122.442406920559) | ||||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 79421 | 79421 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 79568 | 79568 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 2 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 79699 | 79699 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 126X Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6017060.745069999 | 2098543.2218400002 | 37.74315702656929 | -122.38362967653299 | (37.7431570265693, -122.383629676533) | |||
| 82542 | 82542 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 82760 | 82760 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 82967 | 82967 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 945 Sacramento St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.40810904235501 | (37.7928004918921, -122.408109042355) | ||||
| 83026 | 83026 | 105765 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 95 ORA WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6001454.9 | 2097857.0 | 37.7403978808149 | -122.437541306682 | (37.7403978808149, -122.437541306682) | ||||
| 83189 | 83189 | 104146 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1710-1738 Diamond St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6001979.7 | 2099047.6 | 37.743696813668706 | -122.43581192261101 | (37.7436968136687, -122.435811922611) | ||||
| 83772 | 83772 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1160 Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.40155068012699 | (37.8018575696458, -122.401550680127) | |||
| 84141 | 84141 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 84668 | 84668 | 116500 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 1 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 85387 | 85387 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 612 WISCONSIN ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.39929622330901 | (37.7594155491308, -122.399296223309) | |||||
| 87085 | 87085 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | ||||
| 87325 | 87325 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 39 MAGELLAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.46115713573299 | (37.7490976851152, -122.461157135733) | ||||
| 88130 | 88130 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 88169 | 88169 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 88523 | 88523 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 3 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 89464 | 89464 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1201 Holloway Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992431.5 | 2091178.1 | 37.721542125529396 | -122.46825464021099 | (37.7215421255294, -122.468254640211) | |||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 91730 | 91730 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1155@Sansome Battery St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | |||
| 91767 | 91767 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||||
| 93109 | 93109 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470x Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669828998 | (37.7982025127238, -122.40501669829) | ||||
| 93506 | 93506 | 98151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 850 Rockdale Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | ||||
| 94160 | 94160 | 113187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3340 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008444.0 | 2099179.0 | 37.7444226899799 | -122.41346914528499 | (37.7444226899799, -122.413469145285) | |||
| 95713 | 95713 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 95808 | 95808 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1@Carl Irving St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 96813 | 96813 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||||
| 96978 | 96978 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1556X O'Farrell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | |||||
| 97425 | 97425 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 98089 | 98089 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1860 09TH AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494.0 | 2102835.0 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | ||
| 98650 | 98650 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 98982 | 98982 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 340 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | |||||
| 99765 | 99765 | 115276 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 598X PORTOLA DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997411.0 | 2099824.0 | 37.74556803712711 | -122.451665301061 | (37.7455680371271, -122.451665301061) | ||||
| 100647 | 100647 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 101535 | 101535 | 116502 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 3 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 101621 | 101621 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 290 Stonecrest Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Permit Number 770927 | 5990725.0 | 2092655.0 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | |||
| 103031 | 103031 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 105112 | 105112 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2620 Larkin St | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | Permit Number 56959 | 6006630.0 | 2120172.0 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | ||||
| 105499 | 105499 | 121242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 16th Ave | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 5990933.0 | 2110561.0 | 37.7746758635803 | -122.474848566269 | (37.7746758635803, -122.474848566269) | ||||
| 105748 | 105748 | 120595 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 106566 | 106566 | 108177 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 201 PANORAMA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 3x3 | 5997273.1 | 2100946.6 | 37.7486425219839 | -122.452223122411 | (37.7486425219839, -122.452223122411) | |||
| 106826 | 106826 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1060 Clayton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 99 | 5998985.0 | 2106259.0 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | ||||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 109312 | 109312 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 109456 | 109456 | 104868 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 110474 | 110474 | 91110 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 111177 | 111177 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 111635 | 111635 | 110951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 112127 | 112127 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 112470 | 112470 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 342 HILL ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 778799 | 6004048.0 | 2103384.0 | 37.755720828524204 | -122.42896934322901 | (37.7557208285242, -122.428969343229) | |||
| 112832 | 112832 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 MIGUEL ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6003334.2 | 2097391.9 | 37.739227491928894 | -122.431010244874 | (37.7392274919289, -122.431010244874) | ||||
| 113067 | 113067 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||
| 113201 | 113201 | 104169 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470X Roosevelt Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999944.58235 | 2106286.8942299997 | 37.7634583383964 | -122.443368723848 | (37.7634583383964, -122.443368723848) | |||||
| 113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
| 115648 | 115648 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 945 Sacramento St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.40810904235501 | (37.7928004918921, -122.408109042355) | ||||
| 115908 | 115908 | 85032 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Panorama Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997300.0 | 2101977.0 | 37.7514732863106 | -122.452204440653 | (37.7514732863106, -122.452204440653) | |||||
| 116298 | 116298 | 102467 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 36 Saint Germain Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997576.7 | 2104111.9 | 37.757351037011 | -122.451401547119 | (37.757351037011, -122.451401547119) | |||||
| 116721 | 116721 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||||
| 117872 | 117872 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1545 05th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.759717614770295 | -122.46137521578699 | (37.7597176147703, -122.461375215787) | |||
| 118196 | 118196 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | ||||
| 118230 | 118230 | 120598 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 119513 | 119513 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | |||
| 119901 | 119901 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | |||||
| 120295 | 120295 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | |||
| 121907 | 121907 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1100X Divisadero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001418.0 | 2112151.0 | 37.7796436231931 | -122.43869287533899 | (37.7796436231931, -122.438692875339) | |||||
| 122346 | 122346 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.779498769084604 | -122.46395756623998 | (37.7794987690846, -122.46395756624) | ||||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 124358 | 124358 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 533 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 124444 | 124444 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 125219 | 125219 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 7X CASTRO ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002014.1 | 2108690.0 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | ||||
| 125238 | 125238 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | ||||
| 125242 | 125242 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150x FONT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976.0 | 2089133.0 | 37.715842612516106 | -122.473136789074 | (37.7158426125161, -122.473136789074) | ||
| 126406 | 126406 | 105768 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 98X GOLD MINE DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6001350.0 | 2099153.0 | 37.7439504273559 | -122.437996817375 | (37.7439504273559, -122.437996817375) | ||||
| 126422 | 126422 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 36 ARBOR ST | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | |||||
| 126828 | 126828 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999865.0 | 2112093.0 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | ||||
| 127034 | 127034 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99 Divisadero St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | ||||||
| 128022 | 128022 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150 Raccoon Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 3x3 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | |||
| 128852 | 128852 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 112 EUGENIA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.42065307255301 | (37.7415223501304, -122.420653072553) | ||||
| 139674 | 139674 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 25 MIDCREST WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5997992.0 | 2100464.0 | 37.747358577228496 | -122.44970241305 | (37.7473585772285, -122.44970241305) | ||||
| 140531 | 140531 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 141303 | 141303 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700X Panorama Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | |||||
| 141746 | 141746 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 520X Oak Park Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.756074592877496 | -122.46025354267599 | (37.7560745928775, -122.460253542676) | |||
| 142848 | 142848 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 140x TOPAZ WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Permit Number 775551 | 6001767.0 | 2098265.0 | 37.741535893008106 | -122.436491384585 | (37.7415358930081, -122.436491384585) | |||
| 143196 | 143196 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 144561 | 144561 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 8 Keystone Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 5994105.0 | 2092664.0 | 37.72571856099329 | -122.46257757783 | (37.7257185609933, -122.46257757783) |
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");