Street_Tree_List

Data source: data.sfgov.org

151 rows where qSiteInfo = 2 and qSpecies = 103

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 151 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3850 3850 207785 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
23367 23367 208982 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 320 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
23922 23922 208951 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5993021.57409 2096009.5815299999 37.734842246953896 -122.46656593187099 (37.7348422469539, -122.466565931871)
24218 24218 208954 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 600 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 8ft   5993495.97502 2095994.9515900002 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122)
24602 24602 208981 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 310 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 3ft   5993092.40274 2095921.0497 37.7346032476459 -122.466314622626 (37.7346032476459, -122.466314622626)
25657 25657 208945 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 234 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5992554.30272 2095990.82137 37.73476376044329 -122.46818007286001 (37.7347637604433, -122.46818007286)
26365 26365 208940 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     37 Width 10ft   5992201.32921 2095978.5342700002 37.7347096311457 -122.469399518468 (37.7347096311457, -122.469399518468)
26956 26956 208920 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 135 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.46910170710301 (37.734884974665, -122.469101707103)
28258 28258 208938 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 66 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5991979.81471 2095977.19537 37.7346931510662 -122.470165265142 (37.7346931510662, -122.470165265142)
28820 28820 209004 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 156 Kensington Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5994803.6888 2098556.09355 37.7419370183784 -122.460589057359 (37.7419370183784, -122.460589057359)
29038 29038 208963 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993939.166669999 2096822.57013 37.7371274206966 -122.463452499655 (37.7371274206966, -122.463452499655)
29186 29186 209002 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 4ft   5994119.61861 2096725.9639 37.736872559114104 -122.462821593742 (37.7368725591141, -122.462821593742)
29388 29388 207794 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 213 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993149.25155 2096563.99491 37.736371894833 -122.46616478658999 (37.736371894833, -122.46616478659)
30634 30634 207776 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 110 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 10ft   5993235.98614 2096867.2882599998 37.7372096663776 -122.46588694193001 (37.7372096663776, -122.46588694193)
30943 30943 208922 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 201 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5992403.02946 2096048.0013299999 37.7349120244605 -122.46870723116899 (37.7349120244605, -122.468707231169)
32381 32381 207778 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 124 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.46600517310699 (37.7369852648432, -122.466005173107)
33664 33664 207789 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 275 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.46619907325199 (37.735400404893, -122.466199073252)
33873 33873 208955 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 630 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 8ft   5993530.979180001 2095998.56422 37.7348413791301 -122.464803955838 (37.7348413791301, -122.464803955838)
34400 34400 207800 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 10ft   5993292.571380001 2096874.95335 37.737233976861205 -122.465691859205 (37.7372339768612, -122.465691859205)
36584 36584 208984 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 354 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 3ft   5993109.71634 2095669.50335 37.7339135629453 -122.466236489538 (37.7339135629453, -122.466236489538)
36761 36761 208976 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5994151.01662 2096664.6627200001 37.7367060496466 -122.462708592139 (37.7367060496466, -122.462708592139)
36907 36907 208993 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 31 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5993535.26127 2097150.77507 37.7380053101076 -122.46487280074899 (37.7380053101076, -122.464872800749)
40168 40168 208995 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 21 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 4ft   5993486.0432 2097190.73028 37.7381121792369 -122.465045871672 (37.7381121792369, -122.465045871672)
40215 40215 207788 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 285 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993135.10109 2096167.2284099997 37.7352816566244 -122.46618488553001 (37.7352816566244, -122.46618488553)
40777 40777 207799 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5993278.012180001 2096833.03373 37.7371180362587 -122.465739151856 (37.7371180362587, -122.465739151856)
41418 41418 207775 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 110 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 10ft   5993244.34274 2096906.29835 37.737317260394 -122.465860883191 (37.737317260394, -122.465860883191)
41832 41832 208941 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5992287.573419999 2095984.60456 37.734731282309106 -122.469101787134 (37.7347312823091, -122.469101787134)
43077 43077 191722 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 25th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6014479.640380001 2101959.5389 37.752394509601494 -122.392793471535 (37.7523945096015, -122.392793471535)
43824 43824 207767 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 20 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 10ft   5993205.662140001 2097402.75145 37.7386781648646 -122.466030683288 (37.7386781648646, -122.466030683288)
44792 44792 208974 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5994229.97779 2096604.2011400003 37.7365445844613 -122.462431207033 (37.7365445844613, -122.462431207033)
46031 46031 207784 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 270 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 10ft   5993081.2153199995 2096255.53806 37.735521023771604 -122.466377603044 (37.7355210237716, -122.466377603044)
47668 47668 208973 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 136 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   5994259.725980001 2096572.0955299998 37.7364581434207 -122.46232602774799 (37.7364581434207, -122.462326027748)
47715 47715 207770 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5993240.61068 2097284.1687 37.738354582507895 -122.465901234858 (37.7383545825079, -122.465901234858)
49984 49984 208918 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5992207.01448 2096041.6179 37.7348831715052 -122.46938445304899 (37.7348831715052, -122.469384453049)
50349 50349 208932 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 435 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     47 Width 10ft   5992980.53983 2096066.6285400002 37.734996515770604 -122.4667119458 (37.7349965157706, -122.4667119458)
51062 51062 224245 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 160 Coso Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32     6007485.6356 2099587.10163 37.7454893881214 -122.41681188667201 (37.7454893881214, -122.416811886672)
51100 51100 209006 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 172 Kensington Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5994773.63128 2098602.47798 37.7420626491773 -122.46069634646099 (37.7420626491773, -122.460696346461)
51382 51382 207780 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 250 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993075.61435 2096444.65306 37.7360399631594 -122.46641070800501 (37.7360399631594, -122.466410708005)
52160 52160 208998 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 10 Yerba Buena Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 4ft   5993381.76992 2097221.25805 37.7381899876824 -122.465408610532 (37.7381899876824, -122.465408610532)
52363 52363 208968 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993576.11533 2097077.3704400002 37.737806114757795 -122.46472622025298 (37.7378061147578, -122.464726220253)
52384 52384 208985 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 372 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     59 Width 3ft   5993126.32529 2095592.5648700001 37.7337032672843 -122.466173478533 (37.7337032672843, -122.466173478533)
53478 53478 207782 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 260 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 10ft   5993076.07579 2096352.6988099997 37.7357875063795 -122.466402431535 (37.7357875063795, -122.466402431535)
53855 53855 208983 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 330 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 3ft   5993097.51511 2095800.07009 37.73427136274 -122.466288158284 (37.73427136274, -122.466288158284)
53873 53873 207768 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 20 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5993209.58572 2097384.67012 37.7386287444209 -122.466015804002 (37.7386287444209, -122.466015804002)
54108 54108 176348 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 0 Fuente Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
54495 54495 118438 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 5201 Anza St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5982520.38622 2111663.82262 37.7772127952946 -122.50403070229099 (37.7772127952946, -122.504030702291)
55842 55842 207761 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 345 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5993145.033430001 2095739.54752 37.7341079244482 -122.46611947693701 (37.7341079244482, -122.466119476937)
56324 56324 208990 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 51 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5993670.13129 2097058.8329 37.7377606351295 -122.46439981849899 (37.7377606351295, -122.464399818499)
60450 60450 207766 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 14 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5993184.09693 2097461.91411 37.7388393665447 -122.46610954301799 (37.7388393665447, -122.466109543018)
60463 60463 207807 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 25 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 10ft   5993231.15579 2097483.74028 37.7389020106052 -122.46594842230199 (37.7389020106052, -122.465948422302)
61081 61081 208914 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 45 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 10ft   5991964.75621 2096031.6123 37.7348416956868 -122.470221288386 (37.7348416956868, -122.470221288386)
61439 61439 208913 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 25 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     52 Width 10ft   5991855.18446 2096027.3519599999 37.7348236624713 -122.470599802253 (37.7348236624713, -122.470599802253)
62096 62096 208915 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 47 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5992029.43062 2096033.53444 37.734850712276796 -122.469997828452 (37.7348507122768, -122.469997828452)
62516 62516 208926 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 301 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 10ft   5992668.30531 2096054.89965 37.7349462868375 -122.467790589077 (37.7349462868375, -122.467790589077)
63161 63161 208994 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 21 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 4ft   5993511.280230001 2097168.00802 37.7380512447772 -122.46495696559799 (37.7380512447772, -122.464956965598)
64951 64951 208942 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5992406.13159 2095989.66706 37.7347520323855 -122.468692262863 (37.7347520323855, -122.468692262863)
65353 65353 207764 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1520 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5993438.38203 2095281.4007599999 37.7328668869905 -122.46507202306299 (37.7328668869905, -122.465072023063)
65901 65901 208933 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 405 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 10ft   5992936.60702 2096064.2661700002 37.7349874937845 -122.466863664131 (37.7349874937845, -122.466863664131)
66266 66266 191737 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Helena St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6010885.73151 2096220.33708 37.736435634280895 -122.40481783988199 (37.7364356342809, -122.404817839882)
66396 66396 208966 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 6ft   5993666.080159999 2097016.89785 37.7376452584166 -122.46441078125099 (37.7376452584166, -122.464410781251)
67133 67133 209003 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 96 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 3ft   5994450.97172 2101378.39351 37.7496660456507 -122.462013248027 (37.7496660456507, -122.462013248027)
67445 67445 207804 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 55 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5993316.273159999 2097156.75234 37.738009093546 -122.46563037885099 (37.738009093546, -122.465630378851)
68451 68451 207786 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 10ft   5993081.96122 2096160.8531 37.735261085532706 -122.46636814486999 (37.7352610855327, -122.46636814487)
69214 69214 208986 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 372 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5993143.09775 2095558.09178 37.7336095804246 -122.46611298742701 (37.7336095804246, -122.466112987427)
69718 69718 208957 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 625 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993588.443419999 2096129.23717 37.73520348755321 -122.46461476908001 (37.7352034875532, -122.46461476908)
70660 70660 208956 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 630 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 8ft   5993584.21489 2095997.1565599998 37.7348405832115 -122.464619800786 (37.7348405832115, -122.464619800786)
71759 71759 208946 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 300 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598)
72305 72305 208950 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 10ft   5992985.54967 2096006.72468 37.734832323836706 -122.46669027215599 (37.7348323238367, -122.466690272156)
73251 73251 208996 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 11 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 4ft   5993421.96829 2097241.5815 37.7382481090644 -122.465271101502 (37.7382481090644, -122.465271101502)
73493 73493 224246 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 483 Valley St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     55     6002830.24391 2099168.61142 37.744077360782796 -122.432879592517 (37.7440773607828, -122.432879592517)
73538 73538 207772 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 60 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5993256.95856 2097201.9739 37.7381298392237 -122.46583874187 (37.7381298392237, -122.46583874187)
74106 74106 207797 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 145 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 10ft   5993240.654130001 2096747.6644599999 37.7368814785997 -122.465862113458 (37.7368814785997, -122.465862113458)
74311 74311 208919 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 10ft   5992247.91507 2096042.0705099998 37.734886777797996 -122.469243079632 (37.734886777798, -122.469243079632)
74972 74972 208988 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 85 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   5993834.637730001 2096941.34521 37.7374475244853 -122.463822519421 (37.7374475244853, -122.463822519421)
75055 75055 208997 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 10 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 4ft   5993343.646380001 2097250.7379 37.738268733207605 -122.465542562746 (37.7382687332076, -122.465542562746)
75518 75518 191738 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 920 Vermont St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39     6011311.04969 2104026.1978700003 37.757892599481 -122.40389645386699 (37.757892599481, -122.403896453867)
75990 75990 208962 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993970.2453 2096804.3744 37.7370792503013 -122.463343727552 (37.7370792503013, -122.463343727552)
76551 76551 224247 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 527 Powhattan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     46     6008745.222630001 2098103.60695 37.74148680607821 -122.412351580256 (37.7414868060782, -122.412351580256)
76666 76666 207779 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 126 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 10ft   5993175.19587 2096740.86685 37.7368590378112 -122.46608793591001 (37.7368590378112, -122.46608793591)
76846 76846 208931 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 435 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 10ft   5993027.44059 2096068.9282799999 37.735005536864904 -122.46654996171101 (37.7350055368649, -122.466549961711)
76936 76936 208937 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 64 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 10ft   5991925.34536 2095973.96809 37.734681140613105 -122.47035334753201 (37.7346811406131, -122.470353347532)
76953 76953 208935 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 3 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.47074216493401 (37.7346627188958, -122.470742164934)
77037 77037 208999 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 10 Yerba Buena Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 4ft   5993404.322790001 2097201.32336 37.7381365526709 -122.465329186907 (37.7381365526709, -122.465329186907)
77267 77267 207777 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 118 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34 Width 10ft   5993220.0955300005 2096827.0991599998 37.737098400464795 -122.465938963216 (37.7370984004648, -122.465938963216)
92772 92772 114075 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113956 113956 114069 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
114900 114900 208965 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 56 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5993745.43898 2096960.72106 37.7374955851482 -122.464132325055 (37.7374955851482, -122.464132325055)
127109 127109 208991 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 45 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5993638.39674 2097082.374 37.73782344378579 -122.46451124811199 (37.7378234437858, -122.464511248112)
130074 130074 207792 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 255 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5993127.3071800005 2096365.9249099998 37.7358267779692 -122.46622626692499 (37.7358267779692, -122.466226266925)
130326 130326 209005 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 172 Kensington Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5994782.01847 2098589.82391 37.7420283868014 -122.460666429624 (37.7420283868014, -122.460666429624)
130507 130507 207805 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 35 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 10ft   5993257.8737699995 2097404.51842 37.738686028527 -122.46585029007099 (37.738686028527, -122.465850290071)
131518 131518 208943 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 10ft   5992457.65692 2095992.19703 37.7347619554908 -122.46851430770701 (37.7347619554908, -122.468514307707)
131911 131911 207759 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 315 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993145.97421 2095838.45755 37.7343795610583 -122.46612340966999 (37.7343795610583, -122.46612340967)
133032 133032 209000 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 135 Yerba Buena Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 4ft   5994206.5655 2096669.1829099997 37.7367216600723 -122.462516864768 (37.7367216600723, -122.462516864768)
133286 133286 209001 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 125 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5994148.93284 2096709.76404 37.7368297666801 -122.462719067425 (37.7368297666801, -122.462719067425)
133823 133823 207795 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 213 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5993167.32945 2096610.60875 37.7365009277821 -122.466105670558 (37.7365009277821, -122.466105670558)
135413 135413 208934 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 405 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5992888.064180001 2096062.32962 37.734979374706505 -122.467031351742 (37.7349793747065, -122.467031351742)
137042 137042 207787 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 292 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5993086.25016 2096104.5741400002 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661)
137770 137770 208917 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5992152.90186 2096040.12972 37.734875958047496 -122.46957142927499 (37.7348759580475, -122.469571429275)
138466 138466 114076 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)

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 2569.933ms · Data source: data.sfgov.org