home / trees

Street_Tree_List

Data source: data.sfgov.org

414 rows where qSpecies = 67

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
355 100385 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1800 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/09/2012 12:00:00 AM   3x3 Permit Number 769433 5990171.0 2106556.0 37.7636350362567 -122.477191710239 (37.7636350362567, -122.477191710239) 1 8 3 56 35
3825 104308 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 652 Lakeview Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/18/2013 12:00:00 AM   3x3 Permit Number 770798 5995451.6 2089938.7 37.7183129950309 -122.45772540476801 (37.7183129950309, -122.457725404768) 9 8 6 28861 24
6330 107340 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 300X EUGENIA AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/01/2014 12:00:00 AM 3 3x3 Permit Number 773835 6006696.0 2098030.0 37.7411694904711 -122.419431881915 (37.7411694904711, -122.419431881915) 2 7 7 28859 2
7307 108430 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 3025 21st St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772569 6008074.01196 2103843.74387 37.75721024446911 -122.415078608854 (37.7572102444691, -122.415078608854) 2 4 7 28859 19
7313 108436 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 200-212X Lexington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772675 6006463.9009300005 2104927.47787 37.7600953129132 -122.42072394127399 (37.7600953129132, -122.420723941274) 2 4 7 28859 19
7314 108437 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 200-212X Lexington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772675 6006463.9009300005 2104927.47787 37.7600953129132 -122.42072394127399 (37.7600953129132, -122.420723941274) 2 4 7 28859 19
7479 108597 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 3103 Harrison St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774586 6009067.61972 2100561.3865799997 37.7482534137383 -122.41141043143601 (37.7482534137383, -122.411410431436) 2 4 7 28859 2
7480 108598 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 3103 Harrison St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774586 6009067.61972 2100561.3865799997 37.7482534137383 -122.41141043143601 (37.7482534137383, -122.411410431436) 2 4 7 28859 2
8336 109449 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 73 Fountain St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/18/2015 12:00:00 AM 3 3x3 Permit Number 773467 6000399.0 2101283.9 37.7497472407948 -122.441438023758 (37.7497472407948, -122.441438023758) 2 4 5 28862 22
9640 111041 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2700X Gough St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6004870.73043 2118877.40927 37.7983084704282 -122.427227648441 (37.7983084704282, -122.427227648441) 13 9 1 57 17
9641 111042 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2700X Gough St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6004867.45543 2118890.27835 37.7983436204214 -122.42723989811 (37.7983436204214, -122.42723989811) 13 9 1 57 17
13428 115200 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 716 Dolores St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/19/2016 12:00:00 AM     Permit Number 774286 6004934.3 2104152.6 37.757881351563704 -122.425958943462 (37.7578813515637, -122.425958943462) 2 4 5 28862 3
13607 115370 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 481 Anderson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/28/2016 12:00:00 AM 3   Permit Number 773523 6007887.0 2096619.6 37.7373638523191 -122.41521400363101 (37.7373638523191, -122.415214003631) 2 7 7 28859 2
15587 117434 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 71 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/14/2016 12:00:00 AM 3   Permit Number 775886 6000675.587280001 2092024.5104 37.7243388786085 -122.43981779016899 (37.7243388786085, -122.439817790169) 9 7 6 28861 25
16490 118491 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 8245 Geary Blvd 10 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5981413.1487300005 2112317.48344 37.7789423808296 -122.507909444403 (37.7789423808296, -122.507909444403) 11 6 2 55 26
16678 11883 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 400X Keith St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   6017703.731269999 2096843.30561 37.73852491679771 -122.381288201801 (37.7385249167977, -122.381288201801) 10 3 8 58 1
17899 120436 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 235 22nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   5988981.189809999 2113759.0156900003 37.7833434210971 -122.481834493116 (37.7833434210971, -122.481834493116) 11 6 2 55 26
17985 120537 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 300X EUGENIA AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778832 6006696.0 2098030.0 37.7411694904711 -122.419431881915 (37.7411694904711, -122.419431881915) 2 7 7 28859 2
21323 12389 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 1450 Laguna St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 4x4   6004617.476430001 2113882.98777 37.7845807261574 -122.427747939391 (37.7845807261574, -122.427747939391) 13 9 11 28858 41
21426 123985 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 15 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   5993608.318469999 2115347.64983 37.787973377301896 -122.465942059673 (37.7879733773019, -122.465942059673) 11 6 1 54 11
30329 132211 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2700 Gough St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6004866.108030001 2118906.26122 37.7983874290946 -122.427245699623 (37.7983874290946, -122.427245699623) 13 9 1 57 17
30330 132212 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2654 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   6000265.269640001 2118199.18789 37.7961847294893 -122.443115149071 (37.7961847294893, -122.443115149071) 13 9 1 57 17
30331 132213 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2678 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   6000167.6867 2118186.05064 37.7961430935947 -122.443451860639 (37.7961430935947, -122.443451860639) 13 9 1 57 17
30332 132214 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2678 Union St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   6000146.66842 2118183.0353 37.7961336156155 -122.44352437116801 (37.7961336156155, -122.443524371168) 13 9 1 57 17
30333 132215 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2860 Filbert St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   5999237.1134 2118402.93591 37.7966854900001 -122.446687431602 (37.7966854900001, -122.446687431602) 13 9 1 57 17
30334 132216 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2860 Filbert St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5999249.48209 2118404.0666799997 37.7966893013211 -122.44664471470101 (37.7966893013211, -122.446644714701) 13 9 1 57 17
30335 132217 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2860 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   5999261.04653 2118404.81755 37.796692023583496 -122.446604753326 (37.7966920235835, -122.446604753326) 13 9 1 57 17
30336 132218 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2860 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   5999271.44145 2118406.78235 37.796698012158 -122.44656892611799 (37.796698012158, -122.446568926118) 13 9 1 57 17
38177 139831 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 925 GOLDEN GATE AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6005175.7373 2112309.654 37.7802923037704 -122.42570452289 (37.7802923037704, -122.42570452289) 7 9 11 28852 41
38184 139838 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 875 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6005379.6259 2112337.1416 37.7803792970953 -122.42500113355301 (37.7803792970953, -122.425001133553) 7 9 11 28852 41
38188 139841 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 855 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6005489.2243 2112352.6717 37.7804281291994 -122.424623086227 (37.7804281291994, -122.424623086227) 7 9 11 28852 41
38192 139845 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 833 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6005645.4131 2112373.0828 37.780492992722294 -122.424084207294 (37.7804929927223, -122.424084207294) 7 9 11 28852 41
38194 139847 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 829 Golden Gate Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6005684.1962 2112380.7290000003 37.78051617693011 -122.42395058197799 (37.7805161769301, -122.423950581978) 7 9 11 28852 41
38294 139937 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 800 GOLDEN GATE AVE 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6005368.7488 2112395.1092 37.7805378474705 -122.425042888178 (37.7805378474705, -122.425042888178) 7 9 11 28852 41
38303 139945 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 900 GOLDEN GATE AVE 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6005081.183999999 2112356.1174 37.7804145374079 -122.426034935273 (37.7804145374079, -122.426034935273) 7 9 11 28852 41
38304 139946 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 900 GOLDEN GATE AVE 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6005060.605 2112352.3265 37.780402965441205 -122.426105857766 (37.7804029654412, -122.426105857766) 7 9 11 28852 41
38314 139955 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 900 GOLDEN GATE AVE 18 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   6004851.0238 2112323.6242 37.7803123083991 -122.426828852854 (37.7803123083991, -122.426828852854) 7 9 11 28852 41
40363 141826 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1020 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6004640.8141 2112287.0177 37.7801999083923 -122.427553457164 (37.7801999083923, -122.427553457164) 7 9 11 29490 41
40364 141827 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1040 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6004564.2329 2112276.6178 37.7801670209735 -122.427817645466 (37.7801670209735, -122.427817645466) 7 9 11 29490 41
42437 14514 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 507 Masonic Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     30 3X3   5999077.3967 2111056.5759 37.776505184882204 -122.446711235239 (37.7765051848822, -122.446711235239) 15 5 2 29492 16
42986 150468 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 100 Southern Heights Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/24/2017 12:00:00 AM 3 Width 2ft Permit Number 776550 6012105.23351 2104143.6419 37.758259412251206 -122.401158068605 (37.7582594122512, -122.401158068605) 10 3 8 28856 29
42987 150469 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 100 Southern Heights Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/24/2017 12:00:00 AM 3 Width 2ft Permit Number 776550 6012042.59416 2104165.28662 37.758315349182794 -122.40137622523899 (37.7583153491828, -122.401376225239) 10 3 8 28856 29
45110 16950 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 630 Oak St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6003955.1515 2110112.5344 37.774190507936794 -122.42977033764099 (37.7741905079368, -122.429770337641) 7 9 11 29492 10
49600 178355 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2 Moneta Ct 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 1ft   5997930.01019 2088108.42362 37.7134295446025 -122.449026847907 (37.7134295446025, -122.449026847907) 9 7 6 28861 25
49601 178356 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 700 Olmstead St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     4 Width 3ft   6009662.10656 2090649.3043799999 37.7210702863525 -122.40865555551301 (37.7210702863525, -122.408655555513) 9 3 7 309 28
49602 178357 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 700 Olmstead St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 2ft   6009625.93878 2090631.7553 37.7210200744845 -122.408779340021 (37.7210200744845, -122.408779340021) 9 3 7 309 28
49603 178358 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 54 Naples St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6004690.167219999 2093211.8468799999 37.7278267435864 -122.426024429306 (37.7278267435864, -122.426024429306) 9 7 6 28861 5
49604 178359 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 235 Madrid St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 2ft   6003629.76511 2092456.5835099998 37.72569297073721 -122.42963641778401 (37.7256929707372, -122.429636417784) 9 7 6 28861 5
49605 178360 Permitted Site 2 Pistacia chinensis :: Chinese Pistache 67 114 Sweeny St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/06/2018 12:00:00 AM 3 3x3 Permit Number 781343 6009991.862930001 2095011.3305799998 37.733065957324705 -122.40782310796001 (37.7330659573247, -122.40782310796) 10 3 7 309 28
66229 194526 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1 25th St 15 : Yard 25 Tree 1 Private 2     5     6014989.61274 2102184.78595 37.7530413020381 -122.39104563107401 (37.7530413020381, -122.391045631074) 10 3 8 28856 29
66230 194527 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1 25th St 16 : Yard 25 Tree 1 Private 2     3     6014969.95823 2102191.83984 37.7530595798584 -122.39111409374901 (37.7530595798584, -122.391114093749) 10 3 8 28856 29
66231 194528 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1 25th St 21 : Yard 25 Tree 1 Private 2     3     6014977.555240001 2102273.87418 37.7532852503289 -122.391093555018 (37.7532852503289, -122.391093555018) 10 3 8 28856 29
66232 194529 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1 25th St 23 : Yard 25 Tree 1 Private 2     2     6014967.185409999 2102296.35434 37.753346400626 -122.39113098750201 (37.753346400626, -122.391130987502) 10 3 8 28856 29
66234 194530 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 616 Carolina St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 6ft   6012360.41946 2105070.75065 37.760819281207496 -122.400340636111 (37.7608192812075, -122.400340636111) 10 3 8 28856 29
66235 194531 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2221 26th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6011908.13677 2101346.9263299997 37.75056924647 -122.401643151235 (37.75056924647, -122.401643151235) 10 3 8 28856 1
66236 194532 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2200 Alameda St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 2ft   6010402.10466 2107886.85819 37.7684422757183 -122.407312137446 (37.7684422757183, -122.407312137446) 8 4 8 28853 19
66237 194533 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2200 Alameda St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   6010348.85424 2107885.73513 37.7684362115906 -122.40749624758001 (37.7684362115906, -122.40749624758) 8 4 8 28853 19
66238 194534 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 25 Lucy St 1 : 14 Tree 1 Private 2     1 Width 4ft   6014175.87087 2093939.45878 37.7303561623911 -122.39328279268 (37.7303561623911, -122.39328279268) 10 3 8 58 1
66239 194535 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 360 Ritch St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   6014325.43113 2111634.88834 37.7789523278141 -122.39400400667601 (37.7789523278141, -122.394004006676) 6 2 9 28856 34
66240 194536 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 150 Berry St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 5ft   6014975.613419999 2110964.1515200003 37.777146749063895 -122.39170783784701 (37.7771467490639, -122.391707837847) 6 2 9 28856 20
66241 194537 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6012568.21907 2107279.5932299998 37.7668958572755 -122.39977704717899 (37.7668958572755, -122.399777047179) 14 3 8 28856 20
66242 194538 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6012547.8455300005 2107301.3097099997 37.7669543500844 -122.399849041507 (37.7669543500844, -122.399849041507) 14 3 8 28856 20
66243 194539 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 4ft   6012519.55617 2107331.8232299997 37.767036556231 -122.39994903353599 (37.767036556231, -122.399949033536) 14 3 8 28856 20
66245 194540 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   6012505.10498 2107346.22269 37.7670752882293 -122.400000029601 (37.7670752882293, -122.400000029601) 14 3 8 28856 20
66246 194541 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   6012465.166730001 2107386.76068 37.7671843696864 -122.40014101808998 (37.7671843696864, -122.40014101809) 14 3 8 28856 20
66247 194542 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 4 08th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   6012450.21381 2107404.91238 37.7672333764343 -122.40019401333599 (37.7672333764343, -122.400194013336) 14 3 8 28856 20
66248 194543 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 184 Hooper St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 4ft   6012559.7859 2107618.8810799997 37.7678269955571 -122.399830043335 (37.7678269955571, -122.399830043335) 14 3 8 28856 20
66249 194544 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 184 Hooper St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   6012545.36949 2107606.50724 37.767792216065104 -122.399879039311 (37.7677922160651, -122.399879039311) 14 3 8 28856 20
66250 194545 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 184 Hooper St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 4ft   6012495.5993 2107561.45835 37.76766574711311 -122.400048025518 (37.7676657471131, -122.400048025518) 14 3 8 28856 20
66251 194546 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 184 Hooper St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 4ft   6012481.42509 2107546.77644 37.7676246435913 -122.40009602143 (37.7676246435913, -122.40009602143) 14 3 8 28856 20
66252 194547 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 590 Keith St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 4ft   6017544.15385 2096613.95658 37.737886359456205 -122.381824001685 (37.7378863594562, -122.381824001685) 10 3 8 58 1
71150 199686 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2000 Jennings St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6015608.757 2092907.6605 37.7276025523971 -122.388257080086 (37.7276025523971, -122.388257080086) 10 3 8 58 1
71151 199687 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2000 Jennings St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6015600.4454 2092895.2979 37.7275681466115 -122.388284951178 (37.7275681466115, -122.388284951178) 10 3 8 58 1
71152 199688 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2000 Jennings St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 0ft   6015592.0163 2092881.2495 37.7275291054366 -122.388313110838 (37.7275291054366, -122.388313110838) 10 3 8 58 1
71160 199695 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1350 Underwood Ave 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     2 Width 0ft   6015882.1777 2092801.0091 37.7273248550401 -122.387304416847 (37.7273248550401, -122.387304416847) 10 3 8 58 1
71482 199989 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1054 Revere Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6018046.698 2092242.698 37.7259114771391 -122.379782821602 (37.7259114771391, -122.379782821602) 10 3 8 58 1
71489 199995 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1094 Revere Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 0ft   6017857.177999999 2092387.3649 37.7262982485858 -122.380448036499 (37.7262982485858, -122.380448036499) 10 3 8 58 1
72180 200624 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1382 Newcomb Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   6016324.8756 2094912.2277 37.7331463494491 -122.385921096754 (37.7331463494491, -122.385921096754) 10 3 8 58 1
83089 211310 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1645 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 2ft   5993991.2178 2104316.50873 37.7577068768914 -122.46381631408 (37.7577068768914, -122.46381631408) 1 5 4 56 12
83090 211311 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 652 Lakeview Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   5995443.13465 2089926.3908400002 37.7182787106718 -122.457753775529 (37.7182787106718, -122.457753775529) 9 8 6 28861 24
83091 211312 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2331 12th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5992605.95071 2099584.48851 37.7446340456409 -122.46826285635099 (37.7446340456409, -122.468262856351) 1 8 4 29491 40
83092 211313 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2331 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   5992606.241280001 2099598.3023200002 37.7446719916245 -122.468262856359 (37.7446719916245, -122.468262856359) 1 8 4 29491 40
83093 211314 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1950 08th Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 3ft   5993864.84081 2102208.58731 37.7519117832189 -122.46410035414301 (37.7519117832189, -122.464100354143) 1 8 4 29491 12
83094 211315 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1950 08th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 3ft   5993849.45223 2102159.58974 37.7517763614982 -122.46415001292401 (37.7517763614982, -122.464150012924) 1 8 4 29491 12
83095 211316 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 45 Linares Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 3ft   5993952.85587 2102199.15235 37.7518909495221 -122.463795303226 (37.7518909495221, -122.463795303226) 1 8 4 29491 40
83096 211317 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 45 Linares Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 3ft   5993928.12229 2102221.5591700003 37.7519510476114 -122.463882461023 (37.7519510476114, -122.463882461023) 1 8 4 29491 12
83097 211318 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 355 Staples Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   5997726.4515 2093787.9234799999 37.72901248352571 -122.450139532341 (37.7290124835257, -122.450139532341) 9 7 4 28861 40
99717 22826 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 84 Turquoise Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/02/2015 02:48:00 PM 3 3x3   5999343.3761 2099052.93009 37.743561341476 -122.444928046502 (37.743561341476, -122.444928046502) 2 7 5 63 7
105241 233359 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 93 Webster St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 4ft   6004257.74689 2109007.55308 37.7711736292001 -122.428644822623 (37.7711736292001, -122.428644822623) 7 9 11 29492 10
105243 233360 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 40 Dorland St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   6005303.62865 2105767.86216 37.7623373467104 -122.42479655971 (37.7623373467104, -122.42479655971) 8 4 5 28859 19
105244 233361 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 28 Camp St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/30/2017 12:00:00 AM 3 Width 3ft   6005734.12152 2106385.89097 37.7640586131313 -122.42335158033501 (37.7640586131313, -122.423351580335) 8 4 5 28859 19
105245 233362 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 154 Julian Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   6006411.92043 2106982.4341700003 37.76573481092829 -122.421049627935 (37.7657348109283, -122.421049627935) 8 4 7 28853 19
105246 233363 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1750 Harrison St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6008602.87705 2108217.80859 37.7692501250135 -122.413558936315 (37.7692501250135, -122.413558936315) 8 4 7 28853 19
105247 233364 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 200 Lexington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6006470.8211900005 2104891.7812900003 37.75999768845939 -122.42069747321301 (37.7599976884594, -122.420697473213) 2 4 7 28859 19
105248 233365 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 200 Lexington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6006473.17565 2104847.55108 37.75987637530879 -122.420686190322 (37.7598763753088, -122.420686190322) 2 4 7 28859 19
105249 233366 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 2964 25th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6009652.81284 2101635.24983 37.7512348095611 -122.409462618807 (37.7512348095611, -122.409462618807) 2 4 7 28859 19
105250 233367 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 1113 Hampshire St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 4ft   6010291.70011 2102620.11112 37.753974797412 -122.407322687398 (37.753974797412, -122.407322687398) 10 4 7 28859 19
105251 233368 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 3505 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   6006128.237380001 2104906.34475 37.7600183620686 -122.421883341755 (37.7600183620686, -122.421883341755) 2 4 5 28859 19
105252 233369 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 3698 24th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6005236.6856 2101975.24545 37.7519199283811 -122.42475827109101 (37.7519199283811, -122.424758271091) 2 4 5 28859 19
105254 233370 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 67 3698 24th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6005218.25871 2101973.53157 37.7519141816957 -122.424821872029 (37.7519141816957, -122.424821872029) 2 4 5 28859 19

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 24.012ms · Data source: data.sfgov.org