trees
54 rows where qSpecies_id = 306 sorted by DBH descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114983 | 237968 | DPW Maintained 1 | Prunus persica :: Peach 306 | 200 Saint Marys Ave | 3 | Side Yard : Yard | Tree | Private 2 | 8 | Width 2ft | 6003940.67465 | 2095963.2417 | 37.7353390675306 | -122.428811505646 | (37.7353390675306, -122.428811505646) | 2 | 7 | 5 | 63 | 7 | |||
133167 | 246613 | DPW Maintained 1 | Prunus persica :: Peach 306 | 3100 Harrison St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009023.1984 | 2100278.78628 | 37.7474749643959 | -122.411544076298 | (37.7474749643959, -122.411544076298) | 2 | 7 | 7 | 28859 | 2 | |||
193235 | 214378 | DPW Maintained 1 | Prunus persica :: Peach 306 | 395 Byxbee St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991937.18063 | 2091148.28644 | 37.7214317022804 | -122.469961182865 | (37.7214317022804, -122.469961182865) | 9 | 8 | 6 | 64 | 24 | |||
127947 | 135884 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1859 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003987.03627 | 2119366.5077 | 37.799601394234 | -122.430320409782 | (37.799601394234, -122.430320409782) | 13 | 9 | 1 | 57 | 17 | |||
64949 | 201335 | DPW Maintained 1 | Prunus persica :: Peach 306 | 55 Bitting Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6012667.25651 | 2092686.59474 | 37.7268321257865 | -122.398410441015 | (37.7268321257865, -122.398410441015) | 10 | 3 | 8 | 58 | 1 | |||
21484 | 237966 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1504 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009388.93573 | 2107704.51398 | 37.7678848435368 | -122.410803732805 | (37.7678848435368, -122.410803732805) | 8 | 4 | 7 | 28853 | 19 | |||
26725 | 135885 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1859 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004003.5441 | 2119369.22764 | 37.7996097975212 | -122.430263480884 | (37.7996097975212, -122.430263480884) | 13 | 9 | 1 | 57 | 17 | |||
28814 | 184384 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2219 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988214.0276 | 2100177.9874 | 37.7460089960905 | -122.48349257657 | (37.7460089960905, -122.48349257657) | 1 | 8 | 3 | 29491 | 35 | |||
51287 | 135889 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1490 Jefferson St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002136.8028 | 2121593.38731 | 37.8056108422398 | -122.436882382335 | (37.8056108422398, -122.436882382335) | 13 | 9 | 1 | 57 | 17 | |||
82122 | 135890 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1688 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006732.25394 | 2116394.84513 | 37.791597067388 | -122.420609880156 | (37.791597067388, -122.420609880156) | 13 | 9 | 10 | 28858 | 21 | |||
91208 | 135887 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2656 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999215.3432 | 2117963.55375 | 37.7954778200959 | -122.446731130538 | (37.7954778200959, -122.446731130538) | 13 | 9 | 1 | 57 | 17 | |||
150248 | 178868 | DPW Maintained 1 | Prunus persica :: Peach 306 | 226 Capistrano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6001152.02182 | 2093288.15436 | 37.72783566488 | -122.438261311004 | (37.72783566488, -122.438261311004) | 9 | 7 | 6 | 28861 | 25 | ||||
14648 | 196364 | DPW Maintained 1 | Prunus persica :: Peach 306 | 50 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | Width 6ft | 6015741.67537 | 2099771.1312 | 37.7464556143433 | -122.388276389169 | (37.7464556143433, -122.388276389169) | 10 | 3 | 8 | 58 | 1 | |||
27361 | 101337 | DPW Maintained 1 | Prunus persica :: Peach 306 | 331 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013334.33153 | 2094255.43982 | 37.7311769925043 | -122.396214268668 | (37.7311769925043, -122.396214268668) | 10 | 3 | 8 | 58 | 1 | |||
107986 | 178867 | DPW Maintained 1 | Prunus persica :: Peach 306 | 499 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012639.93984 | 2086703.27401 | 37.7104016064098 | -122.398085299203 | (37.7104016064098, -122.398085299203) | 10 | 3 | 8 | 309 | 1 | |||
160230 | 178864 | DPW Maintained 1 | Prunus persica :: Peach 306 | 414 Holyoke St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009739.60622 | 2092455.24833 | 37.7260333713169 | -122.408514986972 | (37.7260333713169, -122.408514986972) | 10 | 3 | 7 | 309 | 28 | |||
161970 | 196366 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1797 Bancroft Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 1ft | 6013425.40251 | 2092793.82346 | 37.7271687591255 | -122.395797040827 | (37.7271687591255, -122.395797040827) | 10 | 3 | 8 | 58 | 1 | |||
162708 | 135888 | DPW Maintained 1 | Prunus persica :: Peach 306 | 3640 Fillmore St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002178.56281 | 2120826.30921 | 37.8035070221959 | -122.436682923487 | (37.8035070221959, -122.436682923487) | 13 | 9 | 1 | 57 | 17 | |||
22000 | 178863 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1555 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 1ft | 5998718.88038 | 2089220.60137 | 37.7165284168318 | -122.446380206079 | (37.7165284168318, -122.446380206079) | 9 | 7 | 6 | 28861 | 25 | |||
38951 | 196360 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1098 Mississippi St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6014197.98434 | 2102073.23717 | 37.7526910529733 | -122.393775449385 | (37.7526910529733, -122.393775449385) | 10 | 3 | 8 | 28856 | 29 | |||
56760 | 237970 | DPW Maintained 1 | Prunus persica :: Peach 306 | 338 Hoffman Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000612.37809 | 2101781.63613 | 37.7511260581198 | -122.44073585409 | (37.7511260581198, -122.44073585409) | 2 | 4 | 5 | 28862 | 22 | |||
72902 | 178865 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1260 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 6000973.92591 | 2087218.66979 | 37.711160097323 | -122.438442319358 | (37.711160097323, -122.438442319358) | 9 | 7 | 6 | 28861 | 5 | |||
75987 | 196363 | DPW Maintained 1 | Prunus persica :: Peach 306 | 602 Arthur Ave | 32 | Front Yard : Yard | Tree | Private 2 | 3 | 6015675.62912 | 2099887.25389 | 37.7467708033235 | -122.388512875771 | (37.7467708033235, -122.388512875771) | 3 | 8 | 58 | 1 | |||||
91828 | 196365 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1501 Quint St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013254.59439 | 2096337.43524 | 37.7368892847014 | -122.396635831278 | (37.7368892847014, -122.396635831278) | 10 | 3 | 8 | 58 | 1 | |||
117744 | 201334 | DPW Maintained 1 | Prunus persica :: Peach 306 | 55 Bitting Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6012664.46076 | 2092688.72471 | 37.7268378185048 | -122.398420255305 | (37.7268378185048, -122.398420255305) | 10 | 3 | 8 | 58 | 1 | |||
121562 | 214376 | DPW Maintained 1 | Prunus persica :: Peach 306 | 258 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995669.69459 | 2091665.50575 | 37.7230669206897 | -122.457096389101 | (37.7230669206897, -122.457096389101) | 9 | 8 | 4 | 28861 | 24 | |||
139077 | 135886 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2656 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5999216.79826 | 2117950.14141 | 37.7954410764998 | -122.446725130283 | (37.7954410764998, -122.446725130283) | 13 | 9 | 1 | 57 | 17 | |||
147309 | 143435 | DPW Maintained 1 | Prunus persica :: Peach 306 | 771 Stockton Tunl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6010446.4978 | 2116858.7221 | 37.7930793884288 | -122.407791300377 | (37.7930793884288, -122.407791300377) | 3 | 1 | 10 | 28857 | 4 | |||
152959 | 196362 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1800 Illinois St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6016258.97414 | 2100621.98176 | 37.7488205237488 | -122.386546929908 | (37.7488205237488, -122.386546929908) | 10 | 3 | 8 | 58 | 1 | |||
66040 | 196370 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2199 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6011909.97713 | 2096732.96046 | 37.7379003871043 | -122.401312582911 | (37.7379003871043, -122.401312582911) | 10 | 3 | 8 | 58 | 1 | ||||
6950 | 101443 | DPW Maintained 1 | Prunus persica :: Peach 306 | 771 Stockton Tunl | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Permit Number 25247 | 6010450.0538 | 2116823.4858 | 37.7929828371273 | -122.407776510606 | (37.7929828371273, -122.407776510606) | 3 | 1 | 10 | 28857 | 4 | |||
26230 | 181324 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1231 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988605.3688 | 2106915.6786 | 37.764531655962 | -122.482633032246 | (37.764531655962, -122.482633032246) | 1 | 8 | 3 | 56 | 35 | |||
52730 | 101445 | DPW Maintained 1 | Prunus persica :: Peach 306 | 771 Stockton Tunl | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Permit Number 25247 | 6010467.187 | 2116750.7503 | 37.7927840821229 | -122.407712097586 | (37.7927840821229, -122.407712097586) | 3 | 1 | 10 | 28857 | 4 | |||
63144 | 18562 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1700X Quesada Ave | 17 | Median : Cutout | Tree | DPW 1 | 2 | 19 | 6014525.25123 | 2095171.81516 | 37.7337593670062 | -122.392161079069 | (37.7337593670062, -122.392161079069) | 10 | 3 | 8 | 58 | 1 | |||
89181 | 196361 | DPW Maintained 1 | Prunus persica :: Peach 306 | 628 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | 6013522.64846 | 2104174.29793 | 37.7584225591685 | -122.396258142101 | (37.7584225591685, -122.396258142101) | 10 | 3 | 8 | 28856 | 29 | ||||
98810 | 178870 | DPW Maintained 1 | Prunus persica :: Peach 306 | 815 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6004750.07437 | 2092064.03384 | 37.7246784877951 | -122.42573566598 | (37.7246784877951, -122.42573566598) | 9 | 7 | 6 | 28861 | 5 | |||
143327 | 101444 | DPW Maintained 1 | Prunus persica :: Peach 306 | 771 Stockton Tunl | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Permit Number 25247 | 6010458.7821 | 2116783.7237 | 37.7928741486166 | -122.40774350511 | (37.7928741486166, -122.40774350511) | 3 | 1 | 10 | 28857 | 4 | |||
152170 | 237967 | DPW Maintained 1 | Prunus persica :: Peach 306 | 401 Treat Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008541.28947 | 2106101.07232 | 37.7634345996517 | -122.413622230594 | (37.7634345996517, -122.413622230594) | 8 | 4 | 7 | 28859 | 19 | |||
172139 | 178866 | DPW Maintained 1 | Prunus persica :: Peach 306 | 399 Blanken Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6012557.98502 | 2087115.49547 | 37.7115289201036 | -122.398397459273 | (37.7115289201036, -122.398397459273) | 10 | 3 | 8 | 309 | 1 | |||
135198 | 196358 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1001 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6015624.21755 | 2102039.10579 | 37.7526764893538 | -122.388840855824 | (37.7526764893538, -122.388840855824) | 10 | 3 | 8 | 28856 | 1 | |||
92679 | 202087 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1 Gould St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012840.70181 | 2091116.62942 | 37.7225309805051 | -122.397700770686 | (37.7225309805051, -122.397700770686) | 10 | 3 | 8 | 58 | 1 | ||||
104277 | 202146 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1985 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6012947.25754 | 2093513.84205 | 37.7291191719044 | -122.397500470083 | (37.7291191719044, -122.397500470083) | 10 | 3 | 8 | 58 | 1 | |||
11516 | 87817 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1355 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50663 | 5986770.4716 | 2106043.3952 | 37.7620296855783 | -122.488915231563 | (37.7620296855783, -122.488915231563) | 1 | 8 | 3 | 56 | 35 | |
30010 | 196359 | DPW Maintained 1 | Prunus persica :: Peach 306 | 800 19th St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6014968.36503 | 2105336.64635 | 37.7616944564422 | -122.391339424287 | (37.7616944564422, -122.391339424287) | 10 | 3 | 8 | 28856 | 29 | |||
78912 | 196367 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2330 Lane St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6013951.01633 | 2092918.10313 | 37.7275392321454 | -122.393988681342 | (37.7275392321454, -122.393988681342) | 10 | 3 | 8 | 58 | 1 | ||||
83525 | 237969 | DPW Maintained 1 | Prunus persica :: Peach 306 | 2859 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6009005.59942 | 2101845.39571 | 37.7517755377248 | -122.411715609385 | (37.7517755377248, -122.411715609385) | 2 | 4 | 7 | 28859 | 19 | |||
87161 | 196368 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1700 Armstrong Ave | 2 | Side Yard : Yard | Tree | Private 2 | 1 | 6013900.47248 | 2092876.94341 | 37.727423406649 | -122.394160532785 | (37.727423406649, -122.394160532785) | 10 | 3 | 8 | 58 | 1 | ||||
102529 | 214377 | DPW Maintained 1 | Prunus persica :: Peach 306 | 236 Thrift St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5994663.97663 | 2089666.08777 | 37.7175191882258 | -122.460428125463 | (37.7175191882258, -122.460428125463) | 9 | 8 | 6 | 28861 | 24 | |||
124852 | 214379 | DPW Maintained 1 | Prunus persica :: Peach 306 | 126 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5992730.44467 | 2088078.02471 | 37.7130473300322 | -122.466996012851 | (37.7130473300322, -122.466996012851) | 9 | 8 | 6 | 64 | 24 | |||
146343 | 214380 | DPW Maintained 1 | Prunus persica :: Peach 306 | 175 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6000261.06186 | 2095194.23891 | 37.7330186161072 | -122.441478089768 | (37.7330186161072, -122.441478089768) | 9 | 7 | 5 | 63 | 40 | ||||
169570 | 178869 | DPW Maintained 1 | Prunus persica :: Peach 306 | 246 Ottawa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998340.87696 | 2089358.35442 | 37.7168850582627 | -122.447696678667 | (37.7168850582627, -122.447696678667) | 9 | 7 | 6 | 28861 | 25 | ||||
178259 | 196369 | DPW Maintained 1 | Prunus persica :: Peach 306 | 1499 Rankin St | 5 | Side Yard : Yard | Tree | Private 2 | 1 | Width 3ft | 6012673.95486 | 2096676.86192 | 37.7377889466986 | -122.398667184835 | (37.7377889466986, -122.398667184835) | 10 | 3 | 8 | 58 | 1 | |||
9075 | 121724 | Undocumented 4 | Prunus persica :: Peach 306 | 439X ARLINGTON ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
29044 | 256487 | Undocumented 4 | Prunus persica :: Peach 306 | 901 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014644 | 2089423 | 37.7179808627223 | -122.391348788107 | (37.7179808627223, -122.391348788107) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );