161 rows where qSpecies_id = 96 sorted by Supervisor Districts

View and edit SQL

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)
20410 126359 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6007620.5753 2119577.58313 37.8003860977102 -122.417761987128 (37.8003860977102, -122.417761987128) 5 1 1 28858 32
28938 126364 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007584.0296 2119571.97409 37.8003686400458 -122.417888052307 (37.8003686400458, -122.417888052307) 5 1 1 28858 32
35470 126362 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6007597.96218 2119573.74544 37.8003742878151 -122.417839965548 (37.8003742878151, -122.417839965548) 5 1 1 28858 32
48886 126363 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007594.76747 2119573.62389 37.8003737742816 -122.417851011923 (37.8003737742816, -122.417851011923) 5 1 1 28858 32
70399 121205 Significant Tree 6 Cotoneaster SPP :: Cotoneaster 96 930 Chestnut St 1 Front Yard : Yard Tree Private 2     20 3x3   6007386.5238 2120591.43483 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145) 5 1 1 28858 32
71395 126365 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1151 Lombard St 6 Sidewalk: Property side : Yard Tree Private 2     9     6006751.38188 2120096.64647 37.8017623625961 -122.42080661943 (37.8017623625961, -122.42080661943) 5 1 1 28858 32
75124 126356 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 101 Marina Blvd 3 Front Yard : Yard Tree Private 2     8     6002934.90654 2121377.37848 37.8050630669581 -122.434104982679 (37.8050630669581, -122.434104982679) 13 9 1 57 17
81196 250505 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21     5987243.87038 2115583.56444 37.7882519230241 -122.487978957983 (37.7882519230241, -122.487978957983) 11 6 1 55 33
114113 126361 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007604.93039 2119574.72474 37.8003773688712 -122.417815922163 (37.8003773688712, -122.417815922163) 5 1 1 28858 32
132532 249676 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2400 Baker St 8 Front Yard : Yard Tree Private 2     15     5999736.34659 2117174.55896 37.7933411972934 -122.444871632924 (37.7933411972934, -122.444871632924) 13 9 1 57 27
143058 122924 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2 11th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5992431.96311 2114886.35785 37.7866388652474 -122.469978400459 (37.7866388652474, -122.469978400459) 11 6 1 54 11
151568 126358 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2700 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6006530.21172 2120848.51447 37.803814332215 -122.421625403593 (37.803814332215, -122.421625403593) 5 9 1 28858 32
191212 126360 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007607.19826 2119575.42635 37.8003794229421 -122.41780812417 (37.8003794229421, -122.41780812417) 5 1 1 28858 32
10292 249831 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 4 Front Yard : Yard Tree Private 2     9 Width 0ft   6011175.54294 2120361.59598 37.802738216951 -122.40551556629 (37.802738216951, -122.40551556629) 3 1 10 308 23
17076 126371 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 37 Median : Yard Tree DPW 1     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046) 3 1 10 308 23
48088 249827 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 6 Front Yard : Yard Tree Private 2     6 Width 0ft   6011143.97494 2120350.69369 37.8027065167616 -122.405624039843 (37.8027065167616, -122.405624039843) 3 1 10 308 23
52277 126370 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 31 Median : Yard Tree DPW 1     10 Width 8ft   6011433.37611 2120083.33032 37.801988580771 -122.404603727506 (37.801988580771, -122.404603727506) 3 1 10 308 23
62670 126368 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 4 Sidewalk: Property side : Yard Tree Private 2     10     6008550.57003 2119171.07932 37.799322230301 -122.414515043334 (37.799322230301, -122.414515043334) 5 1 10 308 32
93688 126367 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     6     6008558.64868 2119172.9159 37.7993277269402 -122.414487218323 (37.7993277269402, -122.414487218323) 5 1 10 308 32
96964 126366 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 99 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     56     6008010.57204 2119080.43937 37.7990430042822 -122.416377206564 (37.7990430042822, -122.416377206564) 5 1 10 308 32
115956 249832 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 5 Front Yard : Yard Tree Private 2     8 Width 0ft   6011163.78015 2120353.28367 37.802714735662 -122.405555685946 (37.802714735662, -122.405555685946) 3 1 10 308 23
165925 108733 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12X MacOndray Ln 1 Front Yard : Yard Tree Private 2     6     6008571.72163 2119174.99094 37.7993341588901 -122.41444212811 (37.7993341588901, -122.41444212811) 5 1 10 308 32
174251 126357 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 53 Priest St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6008293.62277 2117215.49565 37.79393824372 -122.41526566339 (37.79393824372, -122.41526566339) 5 1 10 28858 21
192482 126369 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 30 Median : Yard Tree DPW 1     8 Width 8ft   6011435.17205 2120070.79941 37.8019542743222 -122.404596630044 (37.8019542743222, -122.404596630044) 3 1 10 308 23
6438 29970 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500X Junipero Serra Blvd 14 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991349.07674 2093718.94394 37.7284560756763 -122.472181363504 (37.7284560756763, -122.472181363504) 9 8 4 64 40
9822 16139 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 370 Monterey Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   5999751.27991 2094724.82015 37.7317006461585 -122.443206831334 (37.7317006461585, -122.443206831334) 9 7 4 63 40
12496 259559 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100 Public Park 2 Unaccepted Street : Yard Tree Private 2       3x3   5994005 2098340 37.7412976975938 -122.463334966929 (37.7412976975938, -122.463334966929) 1 8 4 59 40
16595 206473 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 10ft   5999743.81209 2095477.4356 37.7337667261604 -122.443286685744 (37.7337667261604, -122.443286685744) 9 7 4 63 40
24080 206453 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 38 : Tree Private 2     8 Width 0ft   5991335.38967 2093546.90913 37.72798291897 -122.47221614477 (37.72798291897, -122.47221614477) 9 8 4 64 40
27186 206459 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 5 Median : Cutout Tree DPW 1     6 Width 3ft   5995500.0924 2096986.41631 37.7376671119383 -122.458067560678 (37.7376671119383, -122.458067560678) 9 7 4 59 40
39535 206483 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 11 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5995097.24504 2099302.48565 37.7440033097179 -122.459628089474 (37.7440033097179, -122.459628089474) 1 8 4 59 40
39648 206450 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 7 : Tree Private 2     3 Width 0ft   5991349.40355 2093772.63762 37.7286035240126 -122.472184145995 (37.7286035240126, -122.472184145995) 9 8 4 64 40
40874 206488 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 19 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994928.93938 2099242.2168 37.7438281469548 -122.460205682656 (37.7438281469548, -122.460205682656) 1 8 4 59 40
41713 206477 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 20 Median : Yard Tree DPW 1     5     5993822.05067 2096524.01563 37.7363009158535 -122.463835755623 (37.7363009158535, -122.463835755623) 1 8 4 59 40
47071 206479 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 23 Median : Yard Tree DPW 1     13     5993821.59658 2096532.53346 37.7363242775317 -122.463837943662 (37.7363242775317, -122.463837943662) 1 8 4 59 40
49356 206465 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 423 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   5998611.46189 2095226.73921 37.7330137372936 -122.447183504829 (37.7330137372936, -122.447183504829) 9 7 4 59 40
50925 206457 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900 Junipero Serra Blvd 104 : Tree Private 2     10 Width 0ft   5991133.57353 2090407.88322 37.719352251183 -122.472685046772 (37.719352251183, -122.472685046772) 9 8 4 64 40
55033 206433 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 401x Ortega St 2 Median : Cutout Tree DPW 1     7 Width 2ft   5992711.67251 2102602.15843 37.7529258983243 -122.468116765071 (37.7529258983243, -122.468116765071) 1 8 4 56 12
55887 206458 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900 Junipero Serra Blvd 105 : Tree Private 2     8 Width 0ft   5991134.51165 2090396.03266 37.7193197667672 -122.472680940494 (37.7193197667672, -122.472680940494) 9 8 4 64 40
75541 253981 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 433 Detroit St 3 Unaccepted Street : Yard Tree Private 2       Width 10ft   5999422.35392 2094544.1981 37.7311859389748 -122.444331015365 (37.7311859389748, -122.444331015365) 9 7 4 59 40
78546 206437 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Marietta Dr 49 Median : Cutout Tree DPW 1     9 Width 5ft   5999552.56318 2097488.97673 37.7392790352022 -122.444092377567 (37.7392790352022, -122.444092377567) 9 7 4 59 40
81437 206434 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2466 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992373.85184 2098639.0417 37.7420246816026 -122.468996609624 (37.7420246816026, -122.468996609624) 1 8 4 29491 40
95463 206471 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 714 Detroit St 7 Side Yard : Yard Tree Private 2     40     5999468.77343 2095408.32034 37.7335612643209 -122.444232607974 (37.7335612643209, -122.444232607974) 9 7 4 63 40
103204 206469 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 7 Side Yard : Yard Tree Private 2     7     5999419.31958 2095424.67998 37.7336033625016 -122.444404758876 (37.7336033625016, -122.444404758876) 9 7 4 59 40
105242 206455 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 700 Junipero Serra Blvd 62 : Tree Private 2     3 Width 0ft   5991225.43334 2092378.31731 37.7247678930137 -122.472511102603 (37.7247678930137, -122.472511102603) 9 8 4 64 40
112914 206435 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2330 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5992341.16366 2099574.90495 37.7445924349065 -122.469177732164 (37.7445924349065, -122.469177732164) 1 8 4 29491 40
112935 206487 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 18 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994954.72324 2099244.06144 37.7438346949325 -122.46011666235 (37.7438346949325, -122.46011666235) 1 8 4 59 40
116071 206490 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 21 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5994866.12622 2099244.72495 37.743831420489 -122.460423055998 (37.743831420489, -122.460423055998) 1 8 4 59 40
117050 206436 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Marietta Dr 48 Median : Cutout Tree DPW 1     26 Width 5ft   5999547.88846 2097490.32273 37.7392824643167 -122.4441086373 (37.7392824643167, -122.4441086373) 9 7 4 59 40
119995 206481 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 9 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5995111.8827 2099315.29579 37.7440393248702 -122.459578403721 (37.7440393248702, -122.459578403721) 1 8 4 59 40
121273 206470 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 11 Side Yard : Yard Tree Private 2     1     5999427.71603 2095403.50686 37.7335457051627 -122.444374208926 (37.7335457051627, -122.444374208926) 9 7 4 59 40
124388 206484 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 13 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5995031.51325 2099251.39623 37.7438592509066 -122.459851673524 (37.7438592509066, -122.459851673524) 1 8 4 59 40
124782 206485 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 14 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5995003.2981 2099247.81347 37.7438477908555 -122.459948974773 (37.7438477908555, -122.459948974773) 1 8 4 59 40
129949 206476 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 19 Median : Yard Tree DPW 1     16     5993821.62847 2096518.98246 37.7362870716885 -122.463836850114 (37.7362870716885, -122.463836850114) 1 8 4 59 40
133342 206478 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 21 Median : Yard Tree DPW 1     6     5993823.40178 2096528.08405 37.7363121645844 -122.463831379524 (37.7363121645844, -122.463831379524) 1 8 4 59 40
133625 206454 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 46 : Tree Private 2     9 Width 0ft   5991330.30791 2093483.47791 37.7278084585838 -122.472229090527 (37.7278084585838, -122.472229090527) 9 8 4 64 40
136256 206460 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 6 Median : Cutout Tree DPW 1     7 Width 3ft   5995511.53066 2096986.44816 37.737667856597 -122.458028015699 (37.737667856597, -122.458028015699) 9 7 4 59 40
139921 206439 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 171 Flood Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   5999612.35761 2094047.36229 37.7298325825057 -122.443638462765 (37.7298325825057, -122.443638462765) 9 7 4 63 40
139941 206452 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 37 : Tree Private 2     12 Width 0ft   5991336.42216 2093557.70772 37.7280126289541 -122.472213362281 (37.7280126289541, -122.472213362281) 9 8 4 64 40
141062 206431 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 951 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5990974.62554 2103115.26643 37.7542342869058 -122.474161176918 (37.7542342869058, -122.474161176918) 1 8 4 56 12
142959 206474 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 230 Edna St 1 Side Yard : Yard Tree Private 2     13     5998806.12443 2095305.20487 37.7332403061898 -122.446516151203 (37.7332403061898, -122.446516151203) 9 7 4 59 40
143948 206468 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 6 Side Yard : Yard Tree Private 2     6     5999438.31164 2095424.28533 37.7336033624897 -122.444339069698 (37.7336033624897, -122.444339069698) 9 7 4 63 40
149011 206456 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 700 Junipero Serra Blvd 84 : Tree Private 2     30 Width 0ft   5991229.90591 2092186.81387 37.7242423310074 -122.472481686706 (37.7242423310074, -122.472481686706) 9 8 4 64 40
150537 206432 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1501 16th Ave 2 Side Yard : Yard Tree Private 2     5 Width 6ft   5991165.77974 2105142.87216 37.7598126286617 -122.473648022834 (37.7598126286617, -122.473648022834) 1 8 4 56 12
153035 29606 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900X Junipero Serra Blvd 15 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991168.88017 2091040.07708 37.7210901433828 -122.472609073864 (37.7210901433828, -122.472609073864) 9 8 4 64 40
154268 206451 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 13 : Tree Private 2     33 Width 0ft   5991343.11877 2093722.6763 37.7284659790048 -122.472202232259 (37.7284659790048, -122.472202232259) 9 8 4 64 40
160993 206482 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 10 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5995108.20456 2099311.1994 37.7440278657044 -122.459590825184 (37.7440278657044, -122.459590825184) 1 8 4 59 40
161187 206466 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 1 Side Yard : Yard Tree Private 2     7     5999436.63595 2095454.00589 37.7336848725516 -122.444346998137 (37.7336848725516, -122.444346998137) 9 7 4 59 40
162099 206467 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 5 Side Yard : Yard Tree Private 2     10     5999430.1593 2095426.08584 37.7336078411342 -122.444367383951 (37.7336078411342, -122.444367383951) 9 7 4 59 40
163793 206489 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 20 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5994901.42281 2099243.38936 37.7438297837176 -122.460300912772 (37.7438297837176, -122.460300912772) 1 8 4 59 40
166857 206461 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 7 Median : Cutout Tree DPW 1     7 Width 3ft   5995522.71914 2096987.57001 37.7376715797638 -122.457989413181 (37.7376715797638, -122.457989413181) 9 7 4 59 40
167420 29575 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 400X Junipero Serra Blvd 4 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3X3   5991376.3613 2094248.55248 37.7299118271724 -122.472125628008 (37.7299118271724, -122.472125628008) 9 8 4 64 40
172680 206449 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3020 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5990639.74875 2095092.07511 37.7321852719367 -122.4747337006 (37.7321852719367, -122.4747337006) 1 8 4 64 40
175329 206480 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 8 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5995119.81246 2099322.28434 37.7440589696581 -122.459551490632 (37.7440589696581, -122.459551490632) 1 8 4 59 40
176634 206438 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Marietta Dr 50 Median : Cutout Tree DPW 1     7 Width 5ft   5999556.58513 2097486.39574 37.7392721778577 -122.4440782861 (37.7392721778577, -122.4440782861) 9 7 4 59 40
182609 206462 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 8 Median : Cutout Tree DPW 1     7 Width 3ft   5995528.33875 2096982.84241 37.7376589218079 -122.457969641597 (37.7376589218079, -122.457969641597) 9 7 4 59 40
183444 206448 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3804 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   5990608.23629 2090475.97577 37.7195087925673 -122.474505889762 (37.7195087925673, -122.474505889762) 9 8 4 64 40
186299 206486 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 15 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5994998.43576 2099244.33833 37.743837969341 -122.459965535799 (37.743837969341, -122.459965535799) 1 8 4 59 40
193215 206472 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 714 Detroit St 11 Side Yard : Yard Tree Private 2     7     5999457.34155 2095426.05031 37.7336092944368 -122.444273404802 (37.7336092944368, -122.444273404802) 9 7 4 63 40
358 222991 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 7 Sidewalk: Curb side : Pot Tree Private 2     24     6002568.09263 2099485.22731 37.7449318417374 -122.433808677655 (37.7449318417374, -122.433808677655) 2 7 5 63 22
5537 222985 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 517 Day St 1 Sidewalk: Curb side : Pot Tree Private 2     28 Width 10ft   6002550.62453 2098561.77605 37.7423952688291 -122.433803088343 (37.7423952688291, -122.433803088343) 2 7 5 63 7
7476 246435 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 501 Duncan St 1 Front Yard : Yard Tree Private 2     5 Width 5ft   6003234.36598 2099765.52854 37.7457392692468 -122.431524834927 (37.7457392692468, -122.431524834927) 2 7 5 63 22
8429 206463 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 6ft   6001362.70768 2094968.7442 37.732462159688 -122.4376532749 (37.732462159688, -122.4376532749) 9 7 5 63 40
9746 233891 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 255 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     12     6000523.6418 2102837.35853 37.7540197626178 -122.441118447281 (37.7540197626178, -122.441118447281) 2 4 5 28862 22
9896 222994 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 3 Median : Cutout Tree DPW 1     8 Width 4ft   6002676.05036 2100055.6268 37.746504150749 -122.433476134415 (37.746504150749, -122.433476134415) 2 7 5 63 22
15365 223010 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 28 Front Yard : Yard Tree Private 2     5     6004358.20734 2096003.62684 37.7354735791371 -122.427370816017 (37.7354735791371, -122.427370816017) 2 7 5 28861 2
21004 223014 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 130 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000989.36557 2097560.44411 37.7395571289679 -122.439129688289 (37.7395571289679, -122.439129688289) 2 7 5 63 7
22261 246436 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 498 Duncan St 2 Front Yard : Yard Tree Private 2     16 Width 3ft   6003348.10613 2099802.17179 37.7458463290596 -122.431134153243 (37.7458463290596, -122.431134153243) 2 7 5 63 22
24533 223001 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3944 22nd St 7 Front Yard : Yard Tree Private 2     44     6002181.90808 2102965.21527 37.7544651419609 -122.435392918875 (37.7544651419609, -122.435392918875) 2 4 5 28862 22
25208 223005 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 246 Bemis St 3 Sidewalk: Curb side : Yard Tree Private 2     18     6003031.63093 2096309.97053 37.7362396126721 -122.431979155322 (37.7362396126721, -122.431979155322) 2 7 5 63 7
25664 222988 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 4 Sidewalk: Curb side : Pot Tree Private 2     12     6002598.0607 2099487.20989 37.7449389859493 -122.433705195344 (37.7449389859493, -122.433705195344) 2 7 5 63 22
26158 222996 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 6 Median : Cutout Tree DPW 1     6 Width 4ft   6002734.51591 2100059.43623 37.7465179274696 -122.433274239339 (37.7465179274696, -122.433274239339) 2 7 5 63 22
26558 222998 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3955 21st St 2 Front Yard : Yard Tree Private 2     28     6002164.76896 2103518.38211 37.7559830321046 -122.435491759762 (37.7559830321046, -122.435491759762) 2 4 5 28862 22
29884 246437 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 498 Duncan St 3 Front Yard : Yard Tree Private 2     18 Width 3ft   6003348.65362 2099794.40948 37.7458250465875 -122.431131706158 (37.7458250465875, -122.431131706158) 2 7 5 63 22
43929 222986 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 1 Sidewalk: Curb side : Pot Tree Private 2     21     6002638.36895 2099488.81638 37.7449456841067 -122.433565931724 (37.7449456841067, -122.433565931724) 2 7 5 63 22
52269 223007 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1200 San Jose Ave 8 Front Yard : Yard Tree Private 2     19     6004038.31137 2095943.30588 37.735289853946 -122.428472518792 (37.735289853946, -122.428472518792) 2 7 5 28861 7
53512 222992 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 8 Sidewalk: Curb side : Pot Tree Private 2     22     6002556.21356 2099484.40965 37.7449289225421 -122.433849694824 (37.7449289225421, -122.433849694824) 2 7 5 63 22
59932 222978 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 749 Dolores St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 8ft   6005048.47497 2104094.54483 37.7577283976651 -122.425559946538 (37.7577283976651, -122.425559946538) 2 4 5 28859 19
60015 222980 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 San Jose Ave 49 Sidewalk: Property side : Yard Tree Private 2     6     6004766.24957 2096663.35836 37.737308122382 -122.426007008515 (37.737308122382, -122.426007008515) 2 7 5 63 7
64051 222987 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 3 Sidewalk: Curb side : Pot Tree Private 2     5     6002610.5339 2099487.49124 37.7449404662242 -122.433662085451 (37.7449404662242, -122.433662085451) 2 7 5 63 22

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)
);