trees

161 rows where qSpecies_id = 96 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
24533 223001 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3944 22nd St 7 Front Yard : Yard Tree Private 2     44     6002181.90808 2102965.21527 37.7544651419609 -122.435392918875 (37.7544651419609, -122.435392918875) 2 4 5 28862 22
7476 246435 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 501 Duncan St 1 Front Yard : Yard Tree Private 2     5 Width 5ft   6003234.36598 2099765.52854 37.7457392692468 -122.431524834927 (37.7457392692468, -122.431524834927) 2 7 5 63 22
15365 223010 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 28 Front Yard : Yard Tree Private 2     5     6004358.20734 2096003.62684 37.7354735791371 -122.427370816017 (37.7354735791371, -122.427370816017) 2 7 5 28861 2
41713 206477 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 20 Median : Yard Tree DPW 1     5     5993822.05067 2096524.01563 37.7363009158535 -122.463835755623 (37.7363009158535, -122.463835755623) 1 8 4 59 40
46352 176065 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Mansell St 13 Median : Cutout Tree DPW 1     5 Width 0ft   6010824.42328 2090455.49566 37.7206031577782 -122.404624109729 (37.7206031577782, -122.404624109729) 10 7 7 309 28
64051 222987 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 3 Sidewalk: Curb side : Pot Tree Private 2     5     6002610.5339 2099487.49124 37.7449404662242 -122.433662085451 (37.7449404662242, -122.433662085451) 2 7 5 63 22
87397 206443 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 581 Head St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5993478.4128 2089802.60481 37.7178257581409 -122.464535950688 (37.7178257581409, -122.464535950688) 9 8 6 64 24
128445 246631 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3320 Harrison St 2 Front Yard : Yard Tree Private 2     5     6009034.5576 2099266.31462 37.7446955781356 -122.411433278945 (37.7446955781356, -122.411433278945) 2 7 7 28859 2
150537 206432 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1501 16th Ave 2 Side Yard : Yard Tree Private 2     5 Width 6ft   5991165.77974 2105142.87216 37.7598126286617 -122.473648022834 (37.7598126286617, -122.473648022834) 1 8 4 56 12
151568 126358 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2700 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6006530.21172 2120848.51447 37.803814332215 -122.421625403593 (37.803814332215, -122.421625403593) 5 9 1 28858 32
162272 222999 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3955 21st St 3 Front Yard : Yard Tree Private 2     53     6002171.06087 2103519.51853 37.7559865097873 -122.435470081578 (37.7559865097873, -122.435470081578) 2 4 5 28862 22
96964 126366 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 99 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     56     6008010.57204 2119080.43937 37.7990430042822 -122.416377206564 (37.7990430042822, -122.416377206564) 5 1 10 308 32
25308 176072 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 653 Peru Ave 2 Side Yard : Yard Tree Private 2     6     6005100.84385 2092592.61654 37.7261496752474 -122.424560681043 (37.7261496752474, -122.424560681043) 9 7 6 28861 5
26158 222996 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 6 Median : Cutout Tree DPW 1     6 Width 4ft   6002734.51591 2100059.43623 37.7465179274696 -122.433274239339 (37.7465179274696, -122.433274239339) 2 7 5 63 22
27186 206459 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 5 Median : Cutout Tree DPW 1     6 Width 3ft   5995500.0924 2096986.41631 37.7376671119383 -122.458067560678 (37.7376671119383, -122.458067560678) 9 7 4 59 40
48088 249827 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 6 Front Yard : Yard Tree Private 2     6 Width 0ft   6011143.97494 2120350.69369 37.8027065167616 -122.405624039843 (37.8027065167616, -122.405624039843) 3 1 10 308 23
60015 222980 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 San Jose Ave 49 Sidewalk: Property side : Yard Tree Private 2     6     6004766.24957 2096663.35836 37.737308122382 -122.426007008515 (37.737308122382, -122.426007008515) 2 7 5 63 7
68292 222995 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 5 Median : Cutout Tree DPW 1     6 Width 4ft   6002718.47536 2100057.70158 37.7465122545352 -122.433329581817 (37.7465122545352, -122.433329581817) 2 7 5 63 22
93688 126367 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     6     6008558.64868 2119172.9159 37.7993277269402 -122.414487218323 (37.7993277269402, -122.414487218323) 5 1 10 308 32
105606 176066 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x Mansell St 6 Median : Cutout Tree DPW 1     6 Width 0ft   6010525.86554 2090356.25733 37.7203139789786 -122.40564914889 (37.7203139789786, -122.40564914889) 10 7 8 309 28
121991 247635 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 351 Bradford St 2 Sidewalk: Curb side : Yard Tree Private 2     6     6009489.54624 2096539.61504 37.7372341639148 -122.409667589601 (37.7372341639148, -122.409667589601) 10 7 7 28859 2
133342 206478 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Terrace Dr 21 Median : Yard Tree DPW 1     6     5993823.40178 2096528.08405 37.7363121645844 -122.463831379524 (37.7363121645844, -122.463831379524) 1 8 4 59 40
141062 206431 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 951 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5990974.62554 2103115.26643 37.7542342869058 -122.474161176918 (37.7542342869058, -122.474161176918) 1 8 4 56 12
143948 206468 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 6 Side Yard : Yard Tree Private 2     6     5999438.31164 2095424.28533 37.7336033624897 -122.444339069698 (37.7336033624897, -122.444339069698) 9 7 4 63 40
165925 108733 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12X MacOndray Ln 1 Front Yard : Yard Tree Private 2     6     6008571.72163 2119174.99094 37.7993341588901 -122.41444212811 (37.7993341588901, -122.41444212811) 5 1 10 308 32
188863 222983 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 90 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007949.21318 2098212.09839 37.7417399985009 -122.415111593326 (37.7417399985009, -122.415111593326) 2 7 7 28859 2
55033 206433 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 401x Ortega St 2 Median : Cutout Tree DPW 1     7 Width 2ft   5992711.67251 2102602.15843 37.7529258983243 -122.468116765071 (37.7529258983243, -122.468116765071) 1 8 4 56 12
59140 206442 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 488 Arch St 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 6ft   5992758.93765 2090436.99405 37.719526135091 -122.467068932605 (37.719526135091, -122.467068932605) 9 8 6 64 24
81437 206434 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2466 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992373.85184 2098639.0417 37.7420246816026 -122.468996609624 (37.7420246816026, -122.468996609624) 1 8 4 29491 40
103204 206469 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 7 Side Yard : Yard Tree Private 2     7     5999419.31958 2095424.67998 37.7336033625016 -122.444404758876 (37.7336033625016, -122.444404758876) 9 7 4 59 40
112914 206435 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2330 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5992341.16366 2099574.90495 37.7445924349065 -122.469177732164 (37.7445924349065, -122.469177732164) 1 8 4 29491 40
124388 206484 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 13 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5995031.51325 2099251.39623 37.7438592509066 -122.459851673524 (37.7438592509066, -122.459851673524) 1 8 4 59 40
136256 206460 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 6 Median : Cutout Tree DPW 1     7 Width 3ft   5995511.53066 2096986.44816 37.737667856597 -122.458028015699 (37.737667856597, -122.458028015699) 9 7 4 59 40
161187 206466 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 747 Detroit St 1 Side Yard : Yard Tree Private 2     7     5999436.63595 2095454.00589 37.7336848725516 -122.444346998137 (37.7336848725516, -122.444346998137) 9 7 4 59 40
166857 206461 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 7 Median : Cutout Tree DPW 1     7 Width 3ft   5995522.71914 2096987.57001 37.7376715797638 -122.457989413181 (37.7376715797638, -122.457989413181) 9 7 4 59 40
176244 190912 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 649 Delancey St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6015785.04565 2113121.03731 37.7831139729835 -122.389058364068 (37.7831139729835, -122.389058364068) 6 2 9 28856 6
176634 206438 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Marietta Dr 50 Median : Cutout Tree DPW 1     7 Width 5ft   5999556.58513 2097486.39574 37.7392721778577 -122.4440782861 (37.7392721778577, -122.4440782861) 9 7 4 59 40
182609 206462 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100x Casitas Ave 8 Median : Cutout Tree DPW 1     7 Width 3ft   5995528.33875 2096982.84241 37.7376589218079 -122.457969641597 (37.7376589218079, -122.457969641597) 9 7 4 59 40
193215 206472 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 714 Detroit St 11 Side Yard : Yard Tree Private 2     7     5999457.34155 2095426.05031 37.7336092944368 -122.444273404802 (37.7336092944368, -122.444273404802) 9 7 4 63 40
9896 222994 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 3 Median : Cutout Tree DPW 1     8 Width 4ft   6002676.05036 2100055.6268 37.746504150749 -122.433476134415 (37.746504150749, -122.433476134415) 2 7 5 63 22
21004 223014 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 130 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000989.36557 2097560.44411 37.7395571289679 -122.439129688289 (37.7395571289679, -122.439129688289) 2 7 5 63 7
24080 206453 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 38 : Tree Private 2     8 Width 0ft   5991335.38967 2093546.90913 37.72798291897 -122.47221614477 (37.72798291897, -122.47221614477) 9 8 4 64 40
55887 206458 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900 Junipero Serra Blvd 105 : Tree Private 2     8 Width 0ft   5991134.51165 2090396.03266 37.7193197667672 -122.472680940494 (37.7193197667672, -122.472680940494) 9 8 4 64 40
75124 126356 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 101 Marina Blvd 3 Front Yard : Yard Tree Private 2     8     6002934.90654 2121377.37848 37.8050630669581 -122.434104982679 (37.8050630669581, -122.434104982679) 13 9 1 57 17
91353 190917 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 68 Median : Yard Tree DPW 1     8     6012519.74637 2102837.21301 37.7546953603194 -122.399632767155 (37.7546953603194, -122.399632767155) 10 3 8 28856 29
95292 176064 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 200x Mansell St 18 Median : Cutout Tree DPW 1     8 Width 0ft   6011103.67645 2090538.55711 37.7208468308864 -122.403664655405 (37.7208468308864, -122.403664655405) 10 7 7 309 28
115956 249832 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 5 Front Yard : Yard Tree Private 2     8 Width 0ft   6011163.78015 2120353.28367 37.802714735662 -122.405555685946 (37.802714735662, -122.405555685946) 3 1 10 308 23
119785 223000 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3949 21st St 2 Front Yard : Yard Tree Private 2     8     6002182.77981 2103520.33537 37.7559894181953 -122.435429612092 (37.7559894181953, -122.435429612092) 2 4 5 28862 22
120735 222982 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1101 San Jose Ave 67 Sidewalk: Curb side : Yard Tree Private 2     8 Width 8ft   6005045.20057 2096625.52578 37.7372200041006 -122.425039854206 (37.7372200041006, -122.425039854206) 2 7 5 28859 2
192482 126369 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 30 Median : Yard Tree DPW 1     8 Width 8ft   6011435.17205 2120070.79941 37.8019542743222 -122.404596630044 (37.8019542743222, -122.404596630044) 3 1 10 308 23
10292 249831 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 4 Front Yard : Yard Tree Private 2     9 Width 0ft   6011175.54294 2120361.59598 37.802738216951 -122.40551556629 (37.802738216951, -122.40551556629) 3 1 10 308 23
28938 126364 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007584.0296 2119571.97409 37.8003686400458 -122.417888052307 (37.8003686400458, -122.417888052307) 5 1 1 28858 32
40608 190911 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1980 Revere Ave 1 Front Yard : Yard Tree Private 2     9     6013087.19308 2095914.17172 37.7357177729638 -122.397184944736 (37.7357177729638, -122.397184944736) 10 3 8 58 1
71395 126365 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1151 Lombard St 6 Sidewalk: Property side : Yard Tree Private 2     9     6006751.38188 2120096.64647 37.8017623625961 -122.42080661943 (37.8017623625961, -122.42080661943) 5 1 1 28858 32
78546 206437 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 300x Marietta Dr 49 Median : Cutout Tree DPW 1     9 Width 5ft   5999552.56318 2097488.97673 37.7392790352022 -122.444092377567 (37.7392790352022, -122.444092377567) 9 7 4 59 40
124782 206485 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 14 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5995003.2981 2099247.81347 37.7438477908555 -122.459948974773 (37.7438477908555, -122.459948974773) 1 8 4 59 40
133625 206454 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500 Junipero Serra Blvd 46 : Tree Private 2     9 Width 0ft   5991330.30791 2093483.47791 37.7278084585838 -122.472229090527 (37.7278084585838, -122.472229090527) 9 8 4 64 40
148002 222984 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 4699 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6000341.30715 2101074.37399 37.7491686459265 -122.441622492977 (37.7491686459265, -122.441622492977) 2 4 5 28862 22
163793 206489 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 20 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5994901.42281 2099243.38936 37.7438297837176 -122.460300912772 (37.7438297837176, -122.460300912772) 1 8 4 59 40
183444 206448 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3804 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   5990608.23629 2090475.97577 37.7195087925673 -122.474505889762 (37.7195087925673, -122.474505889762) 9 8 4 64 40
191212 126360 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007607.19826 2119575.42635 37.8003794229421 -122.41780812417 (37.8003794229421, -122.41780812417) 5 1 1 28858 32

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