trees

493 rows where qSpecies_id = 133 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
6774 249677 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2400 Baker St 9 Front Yard : Yard Tree Private 2     9     5999741.70445 2117184.69909 37.7933693451834 -122.444853823654 (37.7933693451834, -122.444853823654) 13 9 1 57 27
10338 31751 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2546 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35238 5989883.0648 2098033.3774 37.7402174568148 -122.477564605136 (37.7402174568148, -122.477564605136) 1 8 3 29491 35
27447 223034 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 578 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007664.49403 2096661.03983 37.7374651296141 -122.415986246062 (37.7374651296141, -122.415986246062) 2 7 7 28859 2
32357 126382 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1001 Vallejo St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 4ft   6008670.39988 2118624.74661 37.7978288673746 -122.414061717575 (37.7978288673746, -122.414061717575) 5 1 10 308 21
92618 223022 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 6ft   6006257.51967 2099541.04409 37.7452937702941 -122.42105525589 (37.7452937702941, -122.42105525589) 2 7 7 28859 2
116102 223039 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 543 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007708.38718 2096815.60919 37.7378920108046 -122.415845428432 (37.7378920108046, -122.415845428432) 2 7 7 28859 2
19680 206561 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 355 Yerba Buena Ave 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5995302.34368 2095238.16689 37.732855482695 -122.458624745542 (37.732855482695, -122.458624745542) 9 7 4 59 40
35026 206591 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Montalvo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993709.62503 2099698.37793 37.7450104397813 -122.464454865994 (37.7450104397813, -122.464454865994) 1 8 4 29491 40
39852 206617 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Garcia Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618) 1 8 4 59 40
45462 206618 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Garcia Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935) 1 8 4 59 40
54562 206595 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995084.10326 2100870.93077 37.7483091116899 -122.459787117476 (37.7483091116899, -122.459787117476) 1 8 4 29491 40
78570 206653 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5994496.6283 2101014.48441 37.748669471824 -122.46182898323 (37.748669471824, -122.46182898323) 1 8 4 29491 40
86127 32398 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 244 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.59209 37.7358062077876 -122.421800215602 (37.7358062077876, -122.421800215602) 2 7 7 28859 2
86236 190926 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1303 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.401373086604 (37.7529602155494, -122.401373086604) 10 3 8 28856 29
106812 206577 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 215 Dorantes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993636.26419 2099712.16168 37.7450440573323 -122.464709533316 (37.7450440573323, -122.464709533316) 1 8 4 29491 40
123636 182596 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 945 Rivera St 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5990197.9307 2100380.5725 37.7466805119975 -122.47664737489 (37.7466805119975, -122.47664737489) 1 8 3 29491 35
133928 206594 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995087.43611 2100841.34046 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604) 1 8 4 29491 40
140979 206548 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Dorantes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993741.10567 2099827.07051 37.7453656117262 -122.464355354239 (37.7453656117262, -122.464355354239) 1 8 4 29491 40
171037 182595 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 955 Rivera St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5990177.9035 2100379.6188 37.7466767317389 -122.4767165565 (37.7466767317389, -122.4767165565) 1 8 3 29491 35
186941 206575 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 120 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993692.18131 2099632.63233 37.744828913423 -122.464510409921 (37.744828913423, -122.464510409921) 1 8 4 29491 40
701 52560 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1742 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 7   Permit Number 48656 5984113.6499 2103302.6049 37.7543488257224 -122.497901608629 (37.7543488257224, -122.497901608629) 1 8 3 56 35
4563 223021 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006234.71683 2099501.18451 37.7451830394575 -122.421131274692 (37.7451830394575, -122.421131274692) 2 7 7 28859 2
8188 126379 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1136 Havens St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 7ft   6007507.74968 2119357.27743 37.7997748437807 -122.418136782297 (37.7997748437807, -122.418136782297) 5 1 1 28858 32
28527 206648 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 5 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994513.85188 2100887.12446 37.748320765087 -122.461760191398 (37.748320765087, -122.461760191398) 1 8 4 29491 40
38300 206652 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994516.45103 2100943.31749 37.7484752065739 -122.4617552775 (37.7484752065739, -122.4617552775) 1 8 4 29491 40
45592 206647 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994503.49405 2100867.53113 37.748266370491 -122.461794587759 (37.748266370491, -122.461794587759) 1 8 4 29491 40
54746 143086 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 459 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6010641.4481 2120294.7479 37.8025247902186 -122.407359099343 (37.8025247902186, -122.407359099343) 3 1 10 308 23
56805 206593 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 187 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5995062.08104 2100706.46988 37.7478562769412 -122.459851357851 (37.7478562769412, -122.459851357851) 1 8 4 29491 40
70335 206597 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5995049.66416 2100868.50319 37.7483004655893 -122.459906030335 (37.7483004655893, -122.459906030335) 1 8 4 29491 40
89550 65967 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2562 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM 7   Permit Number 28991 5989886.449 2097917.9756 37.7399007896882 -122.477544471364 (37.7399007896882, -122.477544471364) 1 8 3 29491 35
91882 121558 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 400X Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6003675 2102779 37.7540385213778 -122.430216135756 (37.7540385213778, -122.430216135756) 2 4 5 28862 22
95037 206600 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5995054.43703 2100813.29817 37.7481491609747 -122.459885527604 (37.7481491609747, -122.459885527604) 1 8 4 29491 40
101256 206522 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2204 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991046.63721 2100321.91518 37.7465686447317 -122.473708385358 (37.7465686447317, -122.473708385358) 1 8 4 29491 40
103424 206620 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2105 09th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993657.15968 2101227.85905 37.7492069822304 -122.464747327347 (37.7492069822304, -122.464747327347) 1 8 4 29491 40
110640 206559 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 355 Yerba Buena Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   5995306.63453 2095221.10602 37.7328088843117 -122.458608676455 (37.7328088843117, -122.458608676455) 9 7 4 59 40
110892 31752 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2642 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 7   Permit Number 35239 5989905.4007 2097381.577 37.7384290772799 -122.477439751256 (37.7384290772799, -122.477439751256) 1 8 3 29491 35
114209 206572 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 51 Cortes Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993215.16949 2099646.04946 37.7448382439064 -122.466160788211 (37.7448382439064, -122.466160788211) 1 8 4 29491 40
114823 223042 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 330 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006921.22556 2096271.82147 37.7363546053902 -122.418528488295 (37.7363546053902, -122.418528488295) 2 7 7 28859 2
117769 126378 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1976 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003585.79025 2118315.11213 37.7966917978451 -122.431633760802 (37.7966917978451, -122.431633760802) 13 9 1 57 17
148811 206520 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2290 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991725.72943 2099875.90905 37.7453833337792 -122.471327688331 (37.7453833337792, -122.471327688331) 1 8 4 29491 40
157023 206592 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Montalvo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993721.8716 2099672.65516 37.744940517497 -122.464410652624 (37.744940517497, -122.464410652624) 1 8 4 29491 40
160622 206650 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 7 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994518.14401 2100922.4103 37.748417898169 -122.461747907542 (37.748417898169, -122.461747907542) 1 8 4 29491 40
160913 206649 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 6 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994518.46873 2100904.00828 37.7483673895631 -122.461745450587 (37.7483673895631, -122.461745450587) 1 8 4 29491 40
164255 126380 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1136 Havens St 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 7ft   6007510.81799 2119357.46903 37.7997755425663 -122.418126178374 (37.7997755425663, -122.418126178374) 5 1 1 28858 32
169106 206621 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1912 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993175.25671 2102431.10448 37.7524829903015 -122.466501185193 (37.7524829903015, -122.466501185193) 1 8 4 29491 12
177885 223020 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 6ft   6006199.74889 2099432.38497 37.7449921601655 -122.421247303447 (37.7449921601655, -122.421247303447) 2 7 7 28859 2
190674 206519 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2280 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991734.05463 2099933.45812 37.7455418303067 -122.471303093689 (37.7455418303067, -122.471303093689) 1 8 4 29491 40
194061 206612 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 49 Sola Ave 5 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5994889.66342 2100721.49656 37.7478876192364 -122.460448654307 (37.7478876192364, -122.460448654307) 1 8 4 29491 40
17056 206626 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 40 Ventura Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994084.99265 2101862.22446 37.7509734449922 -122.463313912312 (37.7509734449922, -122.463313912312) 1 8 4 29491 40
25370 28296 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1432 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.422648971496 (37.7482499542668, -122.422648971496) 2 4 5 28859 19
26895 24597 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 451 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1996 12:00:00 AM 6 3X3   6007425.33634 2097280.23764 37.7391518611665 -122.416856984981 (37.7391518611665, -122.416856984981) 2 7 7 28859 2
33901 183040 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2562 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5989885.4338 2097934.2198 37.739945333152 -122.477549168466 (37.739945333152, -122.477549168466) 1 8 3 29491 35
39404 206537 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 401 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994067.3294 2101503.80633 37.7499883024325 -122.46334898679 (37.7499883024325, -122.46334898679) 1 8 4 29491 40
40090 206631 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 89 Ventura Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994365.26522 2101880.85976 37.7510407556506 -122.462346061026 (37.7510407556506, -122.462346061026) 1 8 4 29491 40
42334 206608 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2 Sola Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5994960.81371 2100721.5804 37.7478919422595 -122.460202627649 (37.7478919422595, -122.460202627649) 1 8 4 29491 40
46206 206638 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 167 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994538.83302 2100858.65401 37.7482440304446 -122.46167174395 (37.7482440304446, -122.46167174395) 1 8 4 29491 40
52294 28791 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2737 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.411895265148 (37.7535963186214, -122.411895265148) 2 4 7 28859 19
52410 206639 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 175 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994510.39425 2100823.87441 37.7481468973818 -122.461767562235 (37.7481468973818, -122.461767562235) 1 8 4 29491 40
55707 206642 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 196 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994408.53923 2100777.89876 37.7480147959636 -122.462116437149 (37.7480147959636, -122.462116437149) 1 8 4 29491 40
55830 41230 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3618 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1999 12:00:00 AM 6 3x3 Permit Number 41935 6002625.18254 2121047.68706 37.804140238442 -122.435153221671 (37.804140238442, -122.435153221671) 13 9 1 57 17
59033 126376 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 122 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6001336.2876 2121154.5777 37.8043604581295 -122.439621194774 (37.8043604581295, -122.439621194774) 13 9 1 57 17
64571 206665 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 11 Santa Rita Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993870.76921 2100887.71242 37.7482853390143 -122.463983980089 (37.7482853390143, -122.463983980089) 1 8 4 29491 40
68821 206588 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 348 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994058.29292 2099782.40477 37.7452612490171 -122.463255340382 (37.7452612490171, -122.463255340382) 1 8 4 29491 40
70967 28792 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2731 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008964.24348 2102548.86607 37.7537047894643 -122.411908330514 (37.7537047894643, -122.411908330514) 2 4 7 28859 19
74040 206590 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 340 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994099.18491 2099823.62069 37.745376773231 -122.463116933812 (37.745376773231, -122.463116933812) 1 8 4 29491 40
76261 26484 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 154 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6000987.64369 2098692.25572 37.7426647191989 -122.439216742684 (37.7426647191989, -122.439216742684) 2 7 5 63 7
77327 206601 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5995052.26314 2100785.00395 37.7480713471357 -122.459890995496 (37.7480713471357, -122.459890995496) 1 8 4 29491 40
77503 206587 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 348 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994044.71238 2099771.06427 37.7452293284847 -122.463301476481 (37.7452293284847, -122.463301476481) 1 8 4 29491 40
81319 206582 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 190 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993610.53275 2099775.23813 37.745215765799 -122.464803087101 (37.745215765799, -122.464803087101) 1 8 4 29491 40
81352 206602 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5995047.85902 2100763.4476 37.7480119055303 -122.459904663381 (37.7480119055303, -122.459904663381) 1 8 4 29491 40
98988 206622 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1912 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993175.38418 2102417.55667 37.7524457988584 -122.466499759777 (37.7524457988584, -122.466499759777) 1 8 4 29491 12
101084 206615 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Vasquez Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585) 1 8 4 59 40
101700 247588 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 800 Tompkins Ave 9 Front Yard : Yard Tree Private 2     6     6008943.01163 2096440.06729 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315) 10 7 7 28859 2
103756 206658 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 41 Alton Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994157.02115 2101539.85513 37.7500924502117 -122.463041445619 (37.7500924502117, -122.463041445619) 1 8 4 29491 40
103846 223050 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 18 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001422.84544 2108013.2139 37.7682825750187 -122.438379584463 (37.7682825750187, -122.438379584463) 15 5 5 29492 3
111111 137657 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2167 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5999659.4785 2111881.8514 37.7788044135747 -122.444756988886 (37.7788044135747, -122.444756988886) 15 5 11 29490 16
111783 206669 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 15 Sotelo Ave 4 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994007.62455 2100906.4247 37.7483446043367 -122.463512099503 (37.7483446043367, -122.463512099503) 1 8 4 29491 40
113884 206558 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 517 Laguna Honda Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5995506.85137 2100151.86426 37.7463590370584 -122.458273237436 (37.7463590370584, -122.458273237436) 1 5 4 59 40
118553 206677 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 228 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5994904.4684 2095946.32835 37.7347770452256 -122.460051576629 (37.7347770452256, -122.460051576629) 9 7 4 59 40
123013 31753 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2642 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 6   Permit Number 35239 5989905.4007 2097364.9943 37.738383545459 -122.477438539611 (37.738383545459, -122.477438539611) 1 8 3 29491 35
123767 223041 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 408 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft Permit Number 776709 6007256.61829 2097259.39898 37.7390851512711 -122.417438860719 (37.7390851512711, -122.417438860719) 2 7 7 28859 2
126152 206533 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 665 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995361.50595 2093791.16395 37.7288857636427 -122.458315510062 (37.7288857636427, -122.458315510062) 9 7 4 28861 40
128797 206534 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 665 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.458312597175 (37.7288535085691, -122.458312597175) 9 7 4 28861 40
129309 206564 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2044 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993156.7665 2101574.66751 37.7501303674196 -122.466502884014 (37.7501303674196, -122.466502884014) 1 8 4 29491 12
132095 206645 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994475.58114 2100840.87711 37.7481915783923 -122.461889176638 (37.7481915783923, -122.461889176638) 1 8 4 29491 40
132506 223049 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 45 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002666.83309 2105626.92623 37.7618010890622 -122.433906166852 (37.7618010890622, -122.433906166852) 15 4 5 28862 3
133368 247587 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 800 Tompkins Ave 8 Front Yard : Yard Tree Private 2     6     6008949.04431 2096428.80776 37.7368996080238 -122.411528533315 (37.7368996080238, -122.411528533315) 10 7 7 28859 2
144447 223037 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 203 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002071.56022 2096098.27883 37.7356038810064 -122.435283373351 (37.7356038810064, -122.435283373351) 2 7 5 63 7
148444 206651 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118) 1 8 4 29491 40
149638 223046 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 77 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005471.50149 2099604.561 37.7454238329391 -122.423777694396 (37.7454238329391, -122.423777694396) 2 7 5 28859 22
151607 206507 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1985 10th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   5993144.62205 2101960.97627 37.751190371338 -122.466572955586 (37.751190371338, -122.466572955586) 1 8 4 29491 12
152214 206574 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 120 Montalvo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993698.09593 2099619.5133 37.7447932328356 -122.464489006068 (37.7447932328356, -122.464489006068) 1 8 4 29491 40
157044 206570 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 4 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993230.10677 2099675.67045 37.7449204374235 -122.46611129043 (37.7449204374235, -122.46611129043) 1 8 4 29491 40
157257 223043 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 4107 Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008381.78974 2096055.87054 37.7358437688638 -122.413463422917 (37.7358437688638, -122.413463422917) 10 7 7 28859 2
162209 206598 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5995052.00135 2100847.98673 37.7482442669627 -122.459896462476 (37.7482442669627, -122.459896462476) 1 8 4 29491 40
171276 223044 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 13 Stoneman St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008324.57166 2099444.87133 37.7451460071793 -122.413900908902 (37.7451460071793, -122.413900908902) 2 7 7 28859 2
177882 206504 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1959 10th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   5993136.05327 2102151.01657 37.7517116786758 -122.466616399136 (37.7517116786758, -122.466616399136) 1 8 4 29491 12
178314 223033 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 281 Richland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006248.27078 2096110.49551 37.7358737315714 -122.420843728155 (37.7358737315714, -122.420843728155) 2 7 7 28859 2
184544 206666 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 15 Sotelo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993976.53914 2100938.08553 37.7484297458427 -122.463621888759 (37.7484297458427, -122.463621888759) 1 8 4 29491 40
184572 50986 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1120REVISED Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138) 5 1 1 28858 32

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