trees

161 rows where qSpecies_id = 96 sorted by qSiteInfo

✎ 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)
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
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
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
358 222991 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 7 Sidewalk: Curb side : Pot Tree Private 2     24     6002568.09263 2099485.22731 37.7449318417374 -122.433808677655 (37.7449318417374, -122.433808677655) 2 7 5 63 22
5537 222985 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 517 Day St 1 Sidewalk: Curb side : Pot Tree Private 2     28 Width 10ft   6002550.62453 2098561.77605 37.7423952688291 -122.433803088343 (37.7423952688291, -122.433803088343) 2 7 5 63 7
25664 222988 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 4 Sidewalk: Curb side : Pot Tree Private 2     12     6002598.0607 2099487.20989 37.7449389859493 -122.433705195344 (37.7449389859493, -122.433705195344) 2 7 5 63 22
43929 222986 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 1 Sidewalk: Curb side : Pot Tree Private 2     21     6002638.36895 2099488.81638 37.7449456841067 -122.433565931724 (37.7449456841067, -122.433565931724) 2 7 5 63 22
53512 222992 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 8 Sidewalk: Curb side : Pot Tree Private 2     22     6002556.21356 2099484.40965 37.7449289225421 -122.433849694824 (37.7449289225421, -122.433849694824) 2 7 5 63 22
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
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
104238 222989 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 5 Sidewalk: Curb side : Pot Tree Private 2     24     6002586.19946 2099486.51271 37.7449363986116 -122.433746159477 (37.7449363986116, -122.433746159477) 2 7 5 63 22
109356 222993 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 9 Sidewalk: Curb side : Pot Tree Private 2     17     6002546.22973 2099483.20236 37.7449250410506 -122.43388413076 (37.7449250410506, -122.43388413076) 2 7 5 63 22
138961 222990 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 6 Sidewalk: Curb side : Pot Tree Private 2     23     6002575.82203 2099485.96762 37.744934313062 -122.433782003739 (37.744934313062, -122.433782003739) 2 7 5 63 22
20410 126359 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6007620.5753 2119577.58313 37.8003860977102 -122.417761987128 (37.8003860977102, -122.417761987128) 5 1 1 28858 32
25208 223005 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 246 Bemis St 3 Sidewalk: Curb side : Yard Tree Private 2     18     6003031.63093 2096309.97053 37.7362396126721 -122.431979155322 (37.7362396126721, -122.431979155322) 2 7 5 63 7
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
35470 126362 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6007597.96218 2119573.74544 37.8003742878151 -122.417839965548 (37.8003742878151, -122.417839965548) 5 1 1 28858 32
39535 206483 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 11 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5995097.24504 2099302.48565 37.7440033097179 -122.459628089474 (37.7440033097179, -122.459628089474) 1 8 4 59 40
40874 206488 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 19 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994928.93938 2099242.2168 37.7438281469548 -122.460205682656 (37.7438281469548, -122.460205682656) 1 8 4 59 40
48886 126363 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007594.76747 2119573.62389 37.8003737742816 -122.417851011923 (37.8003737742816, -122.417851011923) 5 1 1 28858 32
59932 222978 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 749 Dolores St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 8ft   6005048.47497 2104094.54483 37.7577283976651 -122.425559946538 (37.7577283976651, -122.425559946538) 2 4 5 28859 19
79562 190920 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 895 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     15     6011337.392 2104186.31719 37.7583337232325 -122.403816617445 (37.7583337232325, -122.403816617445) 10 3 8 28856 29
81196 250505 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21     5987243.87038 2115583.56444 37.7882519230241 -122.487978957983 (37.7882519230241, -122.487978957983) 11 6 1 55 33
112935 206487 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 18 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994954.72324 2099244.06144 37.7438346949325 -122.46011666235 (37.7438346949325, -122.46011666235) 1 8 4 59 40
114113 126361 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007604.93039 2119574.72474 37.8003773688712 -122.417815922163 (37.8003773688712, -122.417815922163) 5 1 1 28858 32
116071 206490 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 21 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5994866.12622 2099244.72495 37.743831420489 -122.460423055998 (37.743831420489, -122.460423055998) 1 8 4 59 40
119995 206481 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 9 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5995111.8827 2099315.29579 37.7440393248702 -122.459578403721 (37.7440393248702, -122.459578403721) 1 8 4 59 40
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
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
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
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
143058 122924 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2 11th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5992431.96311 2114886.35785 37.7866388652474 -122.469978400459 (37.7866388652474, -122.469978400459) 11 6 1 54 11
145896 222981 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1101 San Jose Ave 65 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6005028.12161 2096593.96399 37.7371323777521 -122.425096658989 (37.7371323777521, -122.425096658989) 2 7 5 28859 2
160993 206482 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 10 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5995108.20456 2099311.1994 37.7440278657044 -122.459590825184 (37.7440278657044, -122.459590825184) 1 8 4 59 40
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
175329 206480 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 8 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5995119.81246 2099322.28434 37.7440589696581 -122.459551490632 (37.7440589696581, -122.459551490632) 1 8 4 59 40
186299 206486 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 15 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5994998.43576 2099244.33833 37.743837969341 -122.459965535799 (37.743837969341, -122.459965535799) 1 8 4 59 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
8429 206463 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 6ft   6001362.70768 2094968.7442 37.732462159688 -122.4376532749 (37.732462159688, -122.4376532749) 9 7 5 63 40
9746 233891 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 255 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     12     6000523.6418 2102837.35853 37.7540197626178 -122.441118447281 (37.7540197626178, -122.441118447281) 2 4 5 28862 22
16595 206473 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 10ft   5999743.81209 2095477.4356 37.7337667261604 -122.443286685744 (37.7337667261604, -122.443286685744) 9 7 4 63 40
49356 206465 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 423 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   5998611.46189 2095226.73921 37.7330137372936 -122.447183504829 (37.7330137372936, -122.447183504829) 9 7 4 59 40
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
62670 126368 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 4 Sidewalk: Property side : Yard Tree Private 2     10     6008550.57003 2119171.07932 37.799322230301 -122.414515043334 (37.799322230301, -122.414515043334) 5 1 10 308 32
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
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
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
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
99009 206464 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 171 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6001095.15632 2095353.35883 37.7335030062632 -122.438605809815 (37.7335030062632, -122.438605809815) 9 7 5 63 40
101689 223013 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 400 Prospect Ave 16 Sidewalk: Property side : Yard Tree Private 2     18     6006209.38075 2097598.06666 37.7399560781032 -122.421083777917 (37.7399560781032, -122.421083777917) 2 7 7 28859 2
108052 190921 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 875 Vermont St 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   6011349.18047 2104266.91512 37.7585556858022 -122.403781518727 (37.7585556858022, -122.403781518727) 10 3 8 28856 29
139921 206439 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 171 Flood Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   5999612.35761 2094047.36229 37.7298325825057 -122.443638462765 (37.7298325825057, -122.443638462765) 9 7 4 63 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
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
172680 206449 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3020 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5990639.74875 2095092.07511 37.7321852719367 -122.4747337006 (37.7321852719367, -122.4747337006) 1 8 4 64 40
174251 126357 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 53 Priest St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6008293.62277 2117215.49565 37.79393824372 -122.41526566339 (37.79393824372, -122.41526566339) 5 1 10 28858 21
175491 206447 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 193 Bright St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   5993726.91575 2088448.649 37.7141224416834 -122.46357878423 (37.7141224416834, -122.46357878423) 9 8 6 64 24
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
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
12496 259559 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100 Public Park 2 Unaccepted Street : Yard Tree Private 2       3x3   5994005 2098340 37.7412976975938 -122.463334966929 (37.7412976975938, -122.463334966929) 1 8 4 59 40
75541 253981 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 433 Detroit St 3 Unaccepted Street : Yard Tree Private 2       Width 10ft   5999422.35392 2094544.1981 37.7311859389748 -122.444331015365 (37.7311859389748, -122.444331015365) 9 7 4 59 40

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