Street_Tree_List

Data source: data.sfgov.org

490 rows where qSpecies = 66 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
118047 87776 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 333 Sussex St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129.0 2096659.0 37.737089918679 -122.43858232139401 (37.737089918679, -122.438582321394)
146007 87775 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 333 Sussex St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129.0 2096659.0 37.737089918679 -122.43858232139401 (37.737089918679, -122.438582321394)
249 251254 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 09th Ave 1 unknown : Cutout 12 Tree 1 MTA 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
539 206615 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
565 206617 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
1013 223102 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 247 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779888 6004283.79281 2099537.35517 37.74517218196571 -122.42787981341101 (37.7451721819657, -122.427879813411)
2031 251786 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 300 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
3387 161273 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 566 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
16913 24553 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 404 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6007222.65374 2097265.29025 37.7390994163072 -122.41755671238501 (37.7390994163072, -122.417556712385)
17396 28296 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1432 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.42264897149599 (37.7482499542668, -122.422648971496)
17882 52665 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1200 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM 3 3x3 Permit Number 774794 6000815.0 2109317.0 37.77182785317 -122.440575583218 (37.77182785317, -122.440575583218)
18010 24554 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 412 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6007266.67907 2097258.15357 37.7390822977194 -122.41740398679899 (37.7390822977194, -122.417403986799)
18096 24588 DPW Maintained 3 Crataegus laevigata :: English Hawthorn 66 820 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/1996 12:00:00 AM 20 3X3   6008195.26733 2097153.24719 37.7388464504963 -122.414185921141 (37.7388464504963, -122.414185921141)
18434 28792 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2731 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6008964.243480001 2102548.86607 37.753704789464294 -122.411908330514 (37.7537047894643, -122.411908330514)
18475 26484 DPW Maintained 3 Crataegus laevigata :: English Hawthorn 66 154 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6000987.64369 2098692.2557200002 37.7426647191989 -122.439216742684 (37.7426647191989, -122.439216742684)
19410 42456 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 570 Mangels Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42599 5997659.71395367 2095289.95204904 37.733132877616896 -122.45047848670099 (37.7331328776169, -122.450478486701)
19500 68125 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 172 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM     Permit Number 31874 6006033.71828156 2099220.36912277 37.744400650970604 -122.42180635131201 (37.7444006509706, -122.421806351312)
19529 24597 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 451 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1996 12:00:00 AM 6 3X3   6007425.33634 2097280.23764 37.7391518611665 -122.41685698498101 (37.7391518611665, -122.416856984981)
20561 28791 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2737 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.41189526514799 (37.7535963186214, -122.411895265148)
20614 65804 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2249 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/1990 12:00:00 AM     Permit Number 28772 5991003.52349052 2100099.94265799 37.7459566686168 -122.47384127538099 (37.7459566686168, -122.473841275381)
20665 24587 DPW Maintained 3 Crataegus laevigata :: English Hawthorn 66 804 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/1996 12:00:00 AM 18 3X3   6008146.87115 2097150.7739799998 37.738836941075 -122.414353078142 (37.738836941075, -122.414353078142)
20916 24556 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 416 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6007294.81147 2097256.19199 37.739078494466 -122.41730657855801 (37.739078494466, -122.417306578558)
22356 223022 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 6ft   6006257.519669999 2099541.04409 37.745293770294104 -122.42105525588998 (37.7452937702941, -122.42105525589)
25120 206614 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 432 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995034.15561 2100336.79731 37.7468396428317 -122.45992114704399 (37.7468396428317, -122.459921147044)
25122 206533 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 665 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995361.50595 2093791.16395 37.7288857636427 -122.45831551006201 (37.7288857636427, -122.458315510062)
25265 223034 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 578 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007664.494030001 2096661.03983 37.7374651296141 -122.41598624606199 (37.7374651296141, -122.415986246062)
26518 206504 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1959 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5993136.05327 2102151.01657 37.7517116786758 -122.46661639913602 (37.7517116786758, -122.466616399136)
27341 206556 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 32 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5993935.86279 2101082.16601 37.7488230103837 -122.463773001819 (37.7488230103837, -122.463773001819)
27743 206657 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 41 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994149.03126 2101531.53277 37.7500691388799 -122.463068471138 (37.7500691388799, -122.463068471138)
28309 206505 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1965 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993138.76599 2102124.2403700002 37.7516383146611 -122.46660507218701 (37.7516383146611, -122.466605072187)
29378 95906 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1323 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767607 5987385.7768 2106255.5896 37.7626482044987 -122.486802739667 (37.7626482044987, -122.486802739667)
29674 206651 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118)
29986 206673 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 370 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995261.57654 2095226.1050200001 37.7328200206111 -122.45876481406201 (37.7328200206111, -122.458764814062)
33381 206506 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1985 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5993143.71774 2101970.98373 37.7512177970674 -122.46657681008301 (37.7512177970674, -122.466576810083)
34016 206586 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 360 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993997.55659 2099722.78299 37.745094043463396 -122.46346102880699 (37.7450940434634, -122.463461028807)
34642 223020 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6006199.74889 2099432.38497 37.7449921601655 -122.421247303447 (37.7449921601655, -122.421247303447)
34880 206682 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 647 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995986.285069999 2096009.4987 37.7350126577011 -122.45631595293699 (37.7350126577011, -122.456315952937)
35057 31228 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2651 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/04/1995 12:00:00 AM 4   Permit Number 34914 5991736.03785 2097377.43168 37.738523749481104 -122.47111005511002 (37.7385237494811, -122.47111005511)
35264 206544 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 337 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994178.74316 2101030.22278 37.7486943803622 -122.462929360401 (37.7486943803622, -122.462929360401)
35553 223027 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 116 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6004711.2067599995 2102860.50548 37.754320952762 -122.426638485476 (37.754320952762, -122.426638485476)
35567 206696 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 230 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000774.6257 2094855.9884099998 37.7321191034008 -122.439678327791 (37.7321191034008, -122.439678327791)
36017 31915 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2287 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/1996 12:00:00 AM 4   Permit Number 35339 5991692.93382 2099879.32999 37.745390829638 -122.471441338374 (37.745390829638, -122.471441338374)
37239 41230 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 3618 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1999 12:00:00 AM 6 3x3 Permit Number 41935 6002625.18254 2121047.68706 37.804140238442 -122.43515322167102 (37.804140238442, -122.435153221671)
39280 206536 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 401 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994052.44062 2101520.15999 37.7500323476354 -122.463401659183 (37.7500323476354, -122.463401659183)
39350 223040 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 567 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007699.61186 2096703.5074099998 37.7375837106174 -122.41586783322799 (37.7375837106174, -122.415867833228)
39830 70315 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 226 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1994 12:00:00 AM 5     5997860.8667 2109778.6627 37.7729267975155 -122.450827376517 (37.7729267975155, -122.450827376517)
40135 206582 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 190 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993610.53275 2099775.23813 37.745215765798996 -122.464803087101 (37.745215765799, -122.464803087101)
40226 223024 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 979 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009975.926030001 2103539.78877 37.756482348291996 -122.40847958248399 (37.756482348292, -122.408479582484)
42708 206685 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 641 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996053.59921 2095980.96691 37.734938180348 -122.45608116333099 (37.734938180348, -122.456081163331)
42780 200073 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
42989 39658 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 311 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1998 12:00:00 AM     Permit Number 41051 5995887.27205834 2090529.96858098 37.7199614976995 -122.45626220721901 (37.7199614976995, -122.456262207219)
43403 223031 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 38 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5998471.48427 2106911.98504 37.7650905653978 -122.448508695418 (37.7650905653978, -122.448508695418)
43524 206628 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 20 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5994037.30563 2101977.91794 37.7512883623694 -122.463487212563 (37.7512883623694, -122.463487212563)
44246 206584 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 180 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993659.8453 2099783.1011200002 37.745240198571295 -122.464633144905 (37.7452401985713, -122.464633144905)
44510 218322 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 420 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5993190.15092 2099959.3697 37.745697098249394 -122.466270063011 (37.7456970982494, -122.466270063011)
46262 223026 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 114 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004706.47094 2102901.67728 37.7544337331488 -122.42665779482799 (37.7544337331488, -122.426657794828)
47365 141302 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 208 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998449.1975 2112684.3341 37.780938681749895 -122.449001631605 (37.7809386817499, -122.449001631605)
48597 47077 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 135 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2002 12:00:00 AM 3   Permit Number 45064 5996788.5617 2112098.8644 37.779236022786606 -122.454704245524 (37.7792360227866, -122.454704245524)
49358 206666 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993976.53914 2100938.08553 37.74842974584271 -122.46362188875901 (37.7484297458427, -122.463621888759)
49647 206622 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1912 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993175.38418 2102417.55667 37.752445798858396 -122.466499759777 (37.7524457988584, -122.466499759777)
50270 206508 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990927.20691 2104481.04629 37.7579816107755 -122.474424823051 (37.7579816107755, -122.474424823051)
50581 38530 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2550 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/1998 12:00:00 AM 3   Permit Number 40512 5986784.3655 2097886.9498 37.7396351026284 -122.48826775932 (37.7396351026284, -122.48826775932)
51397 206539 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 393 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994118.07071 2101419.5251 37.749759810788 -122.46316740736499 (37.749759810788, -122.463167407365)
51664 206697 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 860 Teresita Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998934.9538199995 2095541.69667 37.733897014518206 -122.446087759167 (37.7338970145182, -122.446087759167)
51810 206519 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2280 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991734.05463 2099933.45812 37.7455418303067 -122.471303093689 (37.7455418303067, -122.471303093689)
52114 223023 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006515.400219999 2104174.73701 37.7580313639845 -122.420492397202 (37.7580313639845, -122.420492397202)
52949 206549 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994338.43004 2100748.81738 37.7479309089808 -122.462356761175 (37.7479309089808, -122.462356761175)
53148 206498 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 245 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5993516.66966 2104572.87128 37.7583834242608 -122.465476106443 (37.7583834242608, -122.465476106443)
54773 206638 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 167 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994538.83302 2100858.6540099997 37.7482440304446 -122.46167174395 (37.7482440304446, -122.46167174395)
55162 206635 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994551.94388 2100907.9053700003 37.7483800169362 -122.461629977657 (37.7483800169362, -122.461629977657)
55179 184366 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2295 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987606.9921 2099709.6419 37.7446876937291 -122.485557233352 (37.7446876937291, -122.485557233352)
55439 223036 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2743 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008969.13541 2102480.10351 37.7535162573804 -122.411886554326 (37.7535162573804, -122.411886554326)
56091 206541 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 375 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994147.31458 2101302.53521 37.7494402708691 -122.463057794403 (37.7494402708691, -122.463057794403)
58009 206641 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 196 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994436.73351 2100801.00946 37.748079875384796 -122.462020618849 (37.7480798753848, -122.462020618849)
58097 206689 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 616 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5996145.20311 2095954.15677 37.734869823774 -122.45576252094901 (37.734869823774, -122.455762520949)
58785 206665 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 11 Santa Rita Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993870.76921 2100887.71242 37.748285339014295 -122.463983980089 (37.7482853390143, -122.463983980089)
59046 206654 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994247.90783 2101537.24109 37.7500905076701 -122.46272696707399 (37.7500905076701, -122.462726967074)
61636 223021 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006234.71683 2099501.18451 37.7451830394575 -122.421131274692 (37.7451830394575, -122.421131274692)
62392 206521 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2290 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991723.002619999 2099864.63418 37.7453522181485 -122.471336295754 (37.7453522181485, -122.471336295754)
62866 206570 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 4 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993230.1067699995 2099675.67045 37.7449204374235 -122.46611129043 (37.7449204374235, -122.46611129043)
63545 223038 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 10 Lippard Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002089.19721 2096067.16423 37.7355194490575 -122.435220170783 (37.7355194490575, -122.435220170783)
64063 122404 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 340 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6   5994085.0 2099826.0 37.74538248907739 -122.46316615516001 (37.7453824890774, -122.46316615516)
64939 206563 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2047 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993157.06576 2101533.95115 37.750018588 -122.466498890138 (37.750018588, -122.466498890138)
65033 31914 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2286 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 4   Permit Number 42223 5991731.014359999 2099907.3159 37.7454698746265 -122.471311701978 (37.7454698746265, -122.471311701978)
66424 206580 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 275 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993286.92729 2099684.15258 37.7449470052046 -122.46591543334401 (37.7449470052046, -122.465915433344)
66473 206691 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 582 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5996439.41867 2095873.6949599998 37.734665775709296 -122.45473950971599 (37.7346657757093, -122.454739509716)
68623 63086 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1209 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1986 12:00:00 AM 3   Permit Number 23570 5983326.3714 2106866.623 37.7640884282736 -122.500887729919 (37.7640884282736, -122.500887729919)
68999 206663 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 390 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994181.82756 2101452.31219 37.7498535084399 -122.46294931367399 (37.7498535084399, -122.462949313674)
69745 223042 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 Park St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006921.22556 2096271.82147 37.736354605390204 -122.418528488295 (37.7363546053902, -122.418528488295)
69773 223051 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 24 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001422.87059 2107990.68113 37.7682207070445 -122.438377882942 (37.7682207070445, -122.438377882942)
69893 223047 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 3864 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6004003.36703 2102490.39098 37.7532646621477 -122.429059987437 (37.7532646621477, -122.429059987437)
69957 98409 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 55 19th Ave 1 Sidewalk: Curb side : 21 Tree 1 Private 1           5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
69960 68121 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM     Permit Number 31868 6006245.31002458 2099503.96919514 37.745191282743896 -122.421094842871 (37.7451912827439, -122.421094842871)
70255 206531 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 San Aleso Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993348.57217 2094559.38972 37.730879244086296 -122.46533008801399 (37.7308792440863, -122.465330088014)
72290 82688 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1875 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM 2 3x3 Permit Number 51093 5984404.185 2102433.03 37.7519782422196 -122.496832705614 (37.7519782422196, -122.496832705614)
72564 206631 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 89 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994365.2652199995 2101880.85976 37.7510407556506 -122.462346061026 (37.7510407556506, -122.462346061026)
72707 190928 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1778 Quesada Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6014320.53257 2095360.07162 37.73426491189 -122.39288202418301 (37.73426491189, -122.392882024183)
73002 31750 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2546 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM 5   Permit Number 35238 5989885.0953 2098017.81 37.7401748305885 -122.477556447005 (37.7401748305885, -122.477556447005)
73565 223025 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 380 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6005467.6636 2101500.58617 37.750629666539396 -122.423925765973 (37.7506296665394, -122.423925765973)
73810 223029 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 170 Belgrave Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5997728.707169999 2104908.9589 37.75954826396 -122.450933321612 (37.75954826396, -122.450933321612)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 342.01ms · Data source: data.sfgov.org