trees

58 rows where PlotSize = "Width 2ft" and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • Width 2ft · 58 ✖
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)
1806 221820 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 2ft   6007294.28583 2096507.5919 37.7370229743371 -122.417255362169 (37.7370229743371, -122.417255362169) 2 7 7 28859 2
2752 221825 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008302.15962 2096532.14097 37.7371470321954 -122.41377241466 (37.7371470321954, -122.41377241466) 2 7 7 28859 2
12895 221826 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008314.44854 2096531.09899 37.7371448612571 -122.413729852457 (37.7371448612571, -122.413729852457) 2 7 7 28859 2
19306 221827 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008328.718 2096529.81834 37.7371421461853 -122.413680425731 (37.7371421461853, -122.413680425731) 2 7 7 28859 2
20470 203539 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 350 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5999078.20964 2094394.83884 37.7307561925253 -122.445510042754 (37.7307561925253, -122.445510042754) 9 7 4 59 40
20543 203531 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 355 Granada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   5995610.31086 2092357.07195 37.7249623857941 -122.457351672459 (37.7249623857941, -122.457351672459) 9 7 4 28861 40
22793 221849 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6004448.4556 2095570.1665 37.7342884984186 -122.427027930603 (37.7342884984186, -122.427027930603) 2 7 5 28861 25
23185 241540 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 191 Fairmount St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 2ft Permit Number 780010 6004426.52656 2097222.39048 37.7388238918993 -122.427221397276 (37.7388238918993, -122.427221397276) 2 7 5 63 7
28695 221842 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 5 Marsily St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 2ft   6004251.52018 2095424.77714 37.7338781539609 -122.427698444448 (37.7338781539609, -122.427698444448) 2 7 5 28861 25
29348 221851 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6004484.38042 2095546.73676 37.7342261969882 -122.426902058798 (37.7342261969882, -122.426902058798) 2 7 5 28861 25
29613 218232 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 371 Wawona St 1 : Tree Private 2     33 Width 2ft   5991901.5455 2097060.86466 37.7376641082099 -122.47051476505 (37.7376641082099, -122.47051476505) 1 8 4 59 40
32001 221822 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 129 Ellert St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007356.42456 2097004.67982 37.7383913638823 -122.417075731561 (37.7383913638823, -122.417075731561) 2 7 7 28859 2
35034 221861 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 246 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004637.65749 2096950.59035 37.7380895280136 -122.426472056954 (37.7380895280136, -122.426472056954) 2 7 5 63 7
36536 175211 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6005436.48818 2093200.64124 37.7278381272226 -122.423443582752 (37.7278381272226, -122.423443582752) 9 7 6 28861 5
38029 203546 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 431 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 2ft   5997874.7531 2094083.70134 37.7298331050033 -122.449648149961 (37.7298331050033, -122.449648149961) 9 7 4 28861 40
38326 221845 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004371.42755 2095618.1193 37.7344158100226 -122.427297656166 (37.7344158100226, -122.427297656166) 2 7 5 28861 25
39358 203544 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 522 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   5997938.28847 2094411.07212 37.730735622335 -122.449452080662 (37.730735622335, -122.449452080662) 9 7 4 59 40
43199 221866 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 53 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002528.4957 2095557.08411 37.734143822686 -122.433664907521 (37.734143822686, -122.433664907521) 2 7 5 63 7
55860 175179 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 450 Italy Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6001771.83891 2089201.36797 37.7166495024579 -122.43582630935 (37.7166495024579, -122.43582630935) 9 7 6 28861 5
59779 221868 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5997080.14125 2106419.81481 37.7636595407827 -122.45328544896 (37.7636595407827, -122.45328544896) 15 5 11 29492 12
66471 221841 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 5 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6004259.60988 2095362.69857 37.7337081577855 -122.42766605444 (37.7337081577855, -122.42766605444) 2 7 5 28861 25
69139 221840 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 98 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   6004312.44121 2095336.44977 37.7336390727743 -122.427481531566 (37.7336390727743, -122.427481531566) 2 7 5 28861 25
71152 221844 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 127 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6004153.19016 2095736.31086 37.7347279926082 -122.428060594226 (37.7347279926082, -122.428060594226) 2 7 5 28861 25
72457 221800 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 170 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   6004805.17774 2099321.48503 37.7446089338676 -122.42606158838 (37.7446089338676, -122.42606158838) 2 7 5 63 22
76757 203585 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 122 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5999428.77785 2093578.76175 37.7285354426355 -122.444239456297 (37.7285354426355, -122.444239456297) 9 7 4 63 40
76975 203510 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1366 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5993979.28828 2106206.5915 37.7628958661671 -122.46399477014 (37.7628958661671, -122.46399477014) 1 5 11 56 12
80067 221843 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 124 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 2ft   6004594.79724 2095953.61848 37.7353496453739 -122.426549275423 (37.7353496453739, -122.426549275423) 2 7 5 28861 2
90909 203532 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 935 Rockdale Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5996459.44919 2098104.63925 37.7407925546419 -122.454831394377 (37.7407925546419, -122.454831394377) 9 7 4 59 40
93508 203530 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 355 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5995608.47907 2092372.56646 37.7250048247995 -122.457359125149 (37.7250048247995, -122.457359125149) 9 7 4 28861 40
95747 221850 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004464.56621 2095558.73638 37.7342580248697 -122.426971417216 (37.7342580248697, -122.426971417216) 2 7 5 28861 25
98589 203535 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 68 Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5994859.58645 2095502.43187 37.7335556327814 -122.460174598491 (37.7335556327814, -122.460174598491) 9 8 4 59 40
101049 203522 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 62 Aloha Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5991862.2088 2104389.33207 37.7577839146257 -122.471184538744 (37.7577839146257, -122.471184538744) 1 8 4 56 12
101822 203519 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1531 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994271.83336 2105139.6012 37.7599830430151 -122.462905551751 (37.7599830430151, -122.462905551751) 1 5 4 56 12
102836 203534 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 149 Casitas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995350.02472 2096965.99603 37.7376024192215 -122.45858493525 (37.7376024192215, -122.45858493525) 9 7 4 59 40
117834 221786 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Scott St 1 : Tree Private 2     20 Width 2ft   6002363.3837 2108638.99661 37.7700542727214 -122.435171122647 (37.7700542727214, -122.435171122647) 15 5 5 29492 9
119492 203554 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994942.92929 2088379.09284 37.7140014477918 -122.459370769157 (37.7140014477918, -122.459370769157) 9 8 6 28861 24
124027 124414 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 111 Cherry St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   5996072.31903 2115814.16927 37.7893961490256 -122.457450879091 (37.7893961490256, -122.457450879091) 11 6 1 54 31
125012 221854 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4418 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6000475.00831 2102295.38218 37.7525288566262 -122.441247749083 (37.7525288566262, -122.441247749083) 2 4 5 28862 22
127453 203538 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 313 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5999326.9827 2094355.31618 37.7306618716326 -122.444647158563 (37.7306618716326, -122.444647158563) 9 7 4 28861 40
130490 221857 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 679 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6002187.97645 2099712.96384 37.7455355755051 -122.435139333412 (37.7455355755051, -122.435139333412) 2 7 5 63 22
136628 221862 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 252 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004616.62035 2096933.09811 37.7380403090218 -122.426543547661 (37.7380403090218, -122.426543547661) 2 7 5 63 7
137299 203520 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1537 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994273.74981 2105115.42997 37.7599167854573 -122.462897170087 (37.7599167854573, -122.462897170087) 1 5 4 56 12
146558 117937 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 852 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5982958.99767 2109991.00517 37.7726455076262 -122.502389596139 (37.7726455076262, -122.502389596139) 11 6 2 55 26
150799 203533 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 149 Casitas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5995336.83178 2096965.96659 37.737601580145 -122.458630547087 (37.737601580145, -122.458630547087) 9 7 4 59 40
151328 203513 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 112 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5993653.12973 2102595.20165 37.7529611229783 -122.464860549271 (37.7529611229783, -122.464860549271) 1 8 4 56 12
151528 175210 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6005427.44885 2093231.28592 37.7279217605751 -122.423477009653 (37.7279217605751, -122.423477009653) 9 7 6 28861 5
153032 243747 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 217 Whitney St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 2ft Permit Number 780010 6004399.27823 2097187.62567 37.7387268946327 -122.427313133507 (37.7387268946327, -122.427313133507) 2 7 5 63 7
159787 203555 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5994968.99544 2088379.28856 37.7140034838548 -122.459280689461 (37.7140034838548, -122.459280689461) 9 8 6 28861 24
160387 203556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906 (37.7140014477822, -122.45920347906) 9 8 6 28861 24
161078 221858 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 677 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002223.92198 2099714.60458 37.7455421216803 -122.435015156842 (37.7455421216803, -122.435015156842) 2 7 5 63 22
166822 221848 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004429.19741 2095585.11426 37.7343284525969 -122.427095576708 (37.7343284525969, -122.427095576708) 2 7 5 28861 25
167184 221846 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6004388.2708 2095606.1808 37.7343839821397 -122.427238573395 (37.7343839821397, -122.427238573395) 2 7 5 28861 25
168312 175182 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 647 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002406.62971 2090005.70634 37.718894076269 -122.433689610108 (37.718894076269, -122.433689610108) 9 7 6 28861 5
172356 175209 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005385.77988 2093250.96165 37.7279734338052 -122.423622458831 (37.7279734338052, -122.423622458831) 9 7 6 28861 5
177042 221839 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 98 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6004329.20117 2095336.95284 37.7336414020218 -122.42742362331 (37.7336414020218, -122.42742362331) 2 7 5 28861 25
183128 175208 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005371.81589 2093231.88981 37.727920278496 -122.423669377345 (37.727920278496, -122.423669377345) 9 7 6 28861 5
186585 175207 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6005359.84242 2093211.49837 37.7278636122004 -122.423709320725 (37.7278636122004, -122.423709320725) 9 7 6 28861 5
192333 221847 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004411.28278 2095593.12873 37.7343494454616 -122.427158084072 (37.7343494454616, -122.427158084072) 2 7 5 28861 25

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