trees

1,732 rows where qLegalStatus_id = 6 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id ▼ qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
68924 113937 Significant Tree 6 Pinus radiata :: Monterey Pine 15 800 EL CAMINO DEL MAR 1 Front Yard : Yard Tree Private 2     35     5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
69364 114151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 10 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
70573 116500 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 1 Median : Yard Tree Private 2     45 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
72430 114147 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 4 Front Yard : Yard Tree Private 2     7     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
72767 114153 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 12 Front Yard : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
73917 120923 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 6 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
75471 98104 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1@Carl Irving St 8 Sidewalk: Property side : Yard Tree Private 2     15     5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
77157 112924 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2X Noe St   Sidewalk: Property side : Yard Tree Private 2           6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
81315 104261 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1556X O'Farrell St 1 Front Yard : Yard Tree Private 2           6003781.85581 2113525.38813 37.783551542878 -122.430613377711 (37.783551542878, -122.430613377711) 13 9 11 29490 41
81897 120931 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 14 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84037 107611 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470x Broadway 1 Back Yard : Yard Tree Private 2         Permit Number 774041 6011286.02608 2118707.45024 37.7982025127238 -122.40501669829 (37.7982025127238, -122.40501669829) 3 1 10 308 23
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
86997 116863 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 2 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
87199 116862 Significant Tree 6 Pinus radiata :: Monterey Pine 15 262X OAK PARK DR 1 Back Yard : Cutout Tree Private 2       10x10   5995091 2103085 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558) 1 5 4 63 12
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
92424 254257 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
93552 104749 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree Private 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
93603 95230 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1@Carl Irving St 6 Front Yard : Yard Tree Private 2   11/16/2010 12:00:00 AM 27     5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
94002 113187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3340 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008444 2099179 37.7444226899799 -122.413469145285 (37.7444226899799, -122.413469145285) 2 7 7 28859 2
94421 120922 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
95053 114148 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 7 Front Yard : Yard Tree Private 2     19     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95436 104406 Significant Tree 6 Pinus radiata :: Monterey Pine 15 290 Stonecrest Dr 1 Back Yard : Yard Tree Private 2     36   Permit Number 770927 5990725 2092655 37.7254986161427 -122.474261202586 (37.7254986161427, -122.474261202586) 9 8 4 64 40
95557 114140 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 5 Side Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
100026 254674 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 2 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
100356 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 4 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
101814 110427 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1860 09TH AVE 2 Front Yard : Yard Tree Private 2   05/12/2015 12:00:00 AM 3   Permit Number 775447 5993494 2102835 37.7536103714224 -122.465428263995 (37.7536103714224, -122.465428263995) 1 8 4 56 12
102553 253254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 270 Castenada Ave 1 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
103238 121134 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 2 Front Yard : Yard Tree Private 2       3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
104414 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
107818 98757 Significant Tree 6 Pinus radiata :: Monterey Pine 15 340 Castenada Ave 1 Front Yard : Yard Tree Private 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
107819 116502 Significant Tree 6 Pinus radiata :: Monterey Pine 15 71X PARKRIDGE DR 3 Median : Yard Tree Private 2     28 3x3   5999012 2102131 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287) 2 5 5 63 38
109594 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 2 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
110541 113044 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 3 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
114550 178337 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 3 Sidewalk: Property side : Yard Tree MTA 3     29     5998676.28102 2091524.00797 37.7228506076618 -122.446693087413 (37.7228506076618, -122.446693087413) 9 7 6 28861 25
116546 95242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2620 Larkin St   Front Yard : Yard Tree Private 2     37   Permit Number 56959 6006630 2120172 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572) 5 9 1 28858 32
116578 120595 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
117508 121242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 701 16th Ave 1 Back Yard : Cutout Tree Private 2     36     5990933 2110561 37.7746758635803 -122.474848566269 (37.7746758635803, -122.474848566269) 11 6 2 54 26
117949 254767 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900x Moraga St 1 Back Yard : Yard Tree Private 2       10x10   5991390 2103897 37.7564047756354 -122.47278171886 (37.7564047756354, -122.47278171886) 1 8 4 56 12
119122 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Sussex St 1 Sidewalk: Curb side : Yard Tree Private 2   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194 2096647 37.7370606668352 -122.438356728037 (37.7370606668352, -122.438356728037) 2 7 5 63 7
122782 255708 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 2 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
123285 107037 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1060 Clayton St 1 Front Yard : Yard Tree Private 2     99     5998985 2106259 37.7633269800406 -122.446685590868 (37.7633269800406, -122.446685590868) 15 5 5 29492 9
123534 104868 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 3 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
124817 120927 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 10 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
129885 111357 Significant Tree 6 Pinus radiata :: Monterey Pine 15 600x MANSELL ST 1 Front Yard : Cutout Tree DPW 1     48 3x3   6010142 2090267 37.7200474236955 -122.406969764511 (37.7200474236955, -122.406969764511) 10 3 8 309 28
129904 254673 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 1 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
132961 108177 Significant Tree 6 Pinus radiata :: Monterey Pine 15 201 PANORAMA DR 1 Front Yard : Yard Tree Private 2     22 3x3   5997273.1 2100946.6 37.7486425219839 -122.452223122411 (37.7486425219839, -122.452223122411) 1 5 4 63 38
133009 110951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
135834 102467 Significant Tree 6 Pinus radiata :: Monterey Pine 15 36 Saint Germain Ave 1 Front Yard : Yard Tree Private 2           5997576.7 2104111.9 37.757351037011 -122.451401547119 (37.757351037011, -122.451401547119) 15 5 4 28862 38
138623 91110 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
139664 254256 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
141742 110952 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 8 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
142019 104750 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard Tree Private 2   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
143508 256539 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
143770 110950 Significant Tree 6 Pinus radiata :: Monterey Pine 15 342 HILL ST   Front Yard : Yard Tree Private 2     15 3x3 Permit Number 778799 6004048 2103384 37.7557208285242 -122.428969343229 (37.7557208285242, -122.428969343229) 2 4 5 28862 22
144483 254258 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
144728 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1   08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
146688 110953 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 10 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
148062 85032 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Panorama Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5997300 2101977 37.7514732863106 -122.452204440653 (37.7514732863106, -122.452204440653) 1 5 4 63 38
149707 108978 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 MIGUEL ST 1 Front Yard : Yard Tree Private 2     44     6003334.2 2097391.9 37.7392274919289 -122.431010244874 (37.7392274919289, -122.431010244874) 2 7 5 63 7
150077 107187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 3 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
150406 251198 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2           6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
151692 104169 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470X Roosevelt Way 1 Front Yard : Yard Tree Private 2           5999944.58235 2106286.89423 37.7634583383964 -122.443368723848 (37.7634583383964, -122.443368723848) 15 5 5 29492 3
151937 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
153493 256541 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Warren Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995584 2102944 37.754029973308 -122.458208518647 (37.754029973308, -122.458208518647) 1 5 4 63 12
154657 100850 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
155662 105755 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1100X Divisadero St 1 Front Yard : Yard Tree Private 2           6001418 2112151 37.7796436231931 -122.438692875339 (37.7796436231931, -122.438692875339) 15 5 11 29490 41
157045 105845 Significant Tree 6 Pinus radiata :: Monterey Pine 15 355 Buena Vista Ave   Front Yard : Yard Tree Private 2           6000886.5 2107736.6 37.767492540377 -122.440214908068 (37.767492540377, -122.440214908068) 15 5 5 29492 3
157181 101138 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Front Yard : Yard Tree Private 2           5994035.6 2097938.3 37.7401964926879 -122.463200022957 (37.7401964926879, -122.463200022957) 1 8 4 59 40
157788 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
158598 117249 Significant Tree 6 Pinus radiata :: Monterey Pine 15 299x GRAYSTONE TER 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999641 2104067 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093) 2 5 5 28862 3
159982 102589 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5157 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415) 2 4 5 63 22
163180 254675 Significant Tree 6 Pinus radiata :: Monterey Pine 15 44X Starview Way 3 Back Yard : Yard Tree Private 2       10x10   5997596 2101581 37.7504029202392 -122.451152286969 (37.7504029202392, -122.451152286969) 1 5 4 63 38
163821 87242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
163986 121133 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Front Yard : Yard Tree Private 2     20 3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
166166 120598 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
167818 99950 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1545 05th Ave 1 Front Yard : Yard Tree Private 2   08/14/2012 12:00:00 AM     Permit Number 768941 5994712.1 2105033.7 37.7597176147703 -122.461375215787 (37.7597176147703, -122.461375215787) 1 5 4 56 12
168346 251480 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010641 2100362 37.7477940646116 -122.405955656592 (37.7477940646116, -122.405955656592) 2 7 7 28859 2
169643 251606 Significant Tree 6 Pinus radiata :: Monterey Pine 15 52R Amber Dr 1 Back Yard : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
171046 120928 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 11 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
173581 251197 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.433598998019 (37.7675105430125, -122.433598998019) 15 5 5 28862 3
173819 104916 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
176722 253637 Significant Tree 6 Pinus radiata :: Monterey Pine 15 701 Noe St 2 Front Yard : Yard Tree Private 2       Width 3ft   6003144.80454 2104133.37104 37.7577272573137 -122.432146391441 (37.7577272573137, -122.432146391441) 2 4 5 28862 3
177640 103084 Significant Tree 6 Pinus radiata :: Monterey Pine 15 30X Zircon Pl 1 Back Yard : Yard Tree Private 2           6002309.6 2098789.5 37.7430068656447 -122.434652757436 (37.7430068656447, -122.434652757436) 2 7 5 63 7
178015 120935 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 18 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
178069 104027 Significant Tree 6 Pinus radiata :: Monterey Pine 15 520X Oak Park Dr 1 Back Yard : Yard Tree Private 2   07/25/2013 12:00:00 AM     Permit Number 770238 5995008.5 2103700.7 37.7560745928775 -122.460253542676 (37.7560745928775, -122.460253542676) 1 5 4 63 12
178584 108144 Significant Tree 6 Pinus radiata :: Monterey Pine 15 140x TOPAZ WAY 2 Front Yard : Yard Tree Private 2     30   Permit Number 775551 6001767 2098265 37.7415358930081 -122.436491384585 (37.7415358930081, -122.436491384585) 2 7 5 63 7
178948 117208 Significant Tree 6 Pinus radiata :: Monterey Pine 15 25 MIDCREST WAY 1 Front Yard : Cutout Tree Private 2     20     5997992 2100464 37.7473585772285 -122.44970241305 (37.7473585772285, -122.44970241305) 1 5 4 63 38
180810 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 2 Front Yard : Cutout Tree Private 2   03/22/2017 12:00:00 AM 3     6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
183500 98157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 2 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
187303 118359 Significant Tree 6 Pinus radiata :: Monterey Pine 15 8 Keystone Way 1 Front Yard : Yard Tree Private 2     20 3x3   5994105 2092664 37.7257185609933 -122.46257757783 (37.7257185609933, -122.46257757783) 9 8 4 59 40
190157 117273 Significant Tree 6 Pinus radiata :: Monterey Pine 15 17 PEREGO TER 1 Back Yard : Yard Tree Private 2           5999542 2101494 37.7502752643571 -122.444416651791 (37.7502752643571, -122.444416651791) 2 5 5 63 38
190335 173903 Significant Tree 6 Pinus radiata :: Monterey Pine 15 675 Corbett Ave 1 Sidewalk: Property side : Yard Tree Private 2           5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
191593 91111 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
191992 94463 Significant Tree 6 Pinus radiata :: Monterey Pine 15 744 Carolina St 1 : Tree Private 2   06/10/2010 12:00:00 AM     Permit Number 53681 6012327.5 2104524.9 37.7593186601765 -122.400416148756 (37.7593186601765, -122.400416148756) 10 3 8 28856 29
192391 253097 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2 DPW 08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);