trees
91 rows where qSpecies_id = 381
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19026 | 112232 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5999559.4748 | 2111943.9518 | 37.7789692179466 | -122.445107405519 | (37.7789692179466, -122.445107405519) | 15 | 5 | 1 | 29490 | 16 | |||
19696 | 218972 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | Permit Number 779535 | 5997475.95566 | 2098006.28819 | 37.7405807633888 | -122.451309623139 | (37.7405807633888, -122.451309623139) | 9 | 7 | 4 | 59 | 40 | ||
22393 | 112219 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999801.7848 | 2111978.4708 | 37.7790778255592 | -122.444271642134 | (37.7790778255592, -122.444271642134) | 15 | 5 | 1 | 29490 | 16 | |||
22748 | 4236 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 4015 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003796.1789191 | 2100385.9218973 | 37.7474745521244 | -122.429626406668 | (37.7474745521244, -122.429626406668) | 2 | 4 | 5 | 63 | 22 | |||
22920 | 112217 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999859.3165 | 2111987.2698 | 37.7791052675019 | -122.444073249698 | (37.7791052675019, -122.444073249698) | 15 | 5 | 1 | 29490 | 16 | |||
23809 | 22543 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1416X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X6 | 6002329.27888 | 2093769.42378 | 37.7292240094582 | -122.434225904616 | (37.7292240094582, -122.434225904616) | 9 | 7 | 6 | 28861 | 25 | |||
25832 | 192182 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014968.94289 | 2116029.56114 | 37.7910548409688 | -122.392085238363 | (37.7910548409688, -122.392085238363) | 6 | 2 | 9 | 28855 | 6 | |||
27162 | 112228 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999656.6019 | 2111958.8423 | 37.7790156466584 | -122.444772475715 | (37.7790156466584, -122.444772475715) | 15 | 5 | 1 | 29490 | 16 | |||
28486 | 986 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1634 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001643.13591 | 2092619.68288 | 37.7260281147961 | -122.436515696352 | (37.7260281147961, -122.436515696352) | 9 | 7 | 6 | 28861 | 25 | |||
29587 | 112207 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000150.3593 | 2112028.2188 | 37.7792343016328 | -122.443069358849 | (37.7792343016328, -122.443069358849) | 15 | 5 | 1 | 29490 | 16 | |||
29725 | 192176 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6015058.68394 | 2115944.87304 | 37.7908272891018 | -122.391768810997 | (37.7908272891018, -122.391768810997) | 6 | 2 | 9 | 28855 | 6 | |||
31509 | 61146 | Permitted Site 7 | Fraxinus americana :: American Ash 381 | 218 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 21000 | 5997856.78022338 | 2109854.41813893 | 37.7731345685047 | -122.450846975383 | (37.7731345685047, -122.450846975383) | 15 | 5 | 11 | 29492 | 16 | ||
31885 | 128806 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010753.62234 | 2121642.08784 | 37.806230530884 | -122.407065943542 | (37.806230530884, -122.407065943542) | 3 | 1 | 10 | 308 | 23 | |||
34095 | 192184 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014951.26578 | 2116048.5878 | 37.7911061023123 | -122.392147732225 | (37.7911061023123, -122.392147732225) | 6 | 2 | 9 | 28855 | 6 | |||
34607 | 112199 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6000361.5345 | 2112057.6615 | 37.7793271820734 | -122.442340932958 | (37.7793271820734, -122.442340932958) | 15 | 5 | 1 | 29490 | 16 | |||
38160 | 192193 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014938.13468 | 2116178.28244 | 37.7914614847122 | -122.392202240147 | (37.7914614847122, -122.392202240147) | 6 | 2 | 9 | 28855 | 6 | |||
38543 | 112222 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999751.0216 | 2111973.3945 | 37.7790609910565 | -122.444446887136 | (37.7790609910565, -122.444446887136) | 15 | 5 | 1 | 29490 | 16 | |||
39837 | 112205 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000191.9852 | 2112033.972 | 37.7792524717433 | -122.442925771356 | (37.7792524717433, -122.442925771356) | 15 | 5 | 1 | 29490 | 16 | |||
40455 | 192187 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6014922.34565 | 2116076.94881 | 37.7911823693173 | -122.3922497801 | (37.7911823693173, -122.3922497801) | 6 | 2 | 9 | 28855 | 6 | |||
40499 | 192195 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6014955.9111 | 2116194.51925 | 37.7915070542455 | -122.392141869558 | (37.7915070542455, -122.392141869558) | 6 | 2 | 9 | 28855 | 6 | |||
44652 | 22542 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1416X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X6 | 6002345.30363 | 2093794.47674 | 37.7292937087186 | -122.434172296015 | (37.7292937087186, -122.434172296015) | 9 | 7 | 6 | 28861 | 25 | |||
44690 | 112203 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000273.8832 | 2112045.1399 | 37.7792878048325 | -122.442643255191 | (37.7792878048325, -122.442643255191) | 15 | 5 | 1 | 29490 | 16 | |||
44725 | 17327 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006652.60436 | 2108850.55128 | 37.7708777828196 | -122.420349758438 | (37.7708777828196, -122.420349758438) | 8 | 2 | 9 | 28853 | 19 | |||
45625 | 192191 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6014914.80311 | 2116152.19352 | 37.7913885550754 | -122.39228114217 | (37.7913885550754, -122.39228114217) | 6 | 2 | 9 | 28855 | 6 | |||
47143 | 112221 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999767.2658 | 2111975.0866 | 37.7790665639672 | -122.444390813692 | (37.7790665639672, -122.444390813692) | 15 | 5 | 1 | 29490 | 16 | |||
50348 | 112227 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999670.4772 | 2111960.8729 | 37.7790220139758 | -122.44472462162 | (37.7790220139758, -122.44472462162) | 15 | 5 | 1 | 29490 | 16 | |||
51678 | 225379 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1556 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007034.72267 | 2107351.45555 | 37.7667831452642 | -122.418921659306 | (37.7667831452642, -122.418921659306) | 8 | 4 | 7 | 28853 | 19 | |||
52283 | 23563 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2940 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 6005640.89624 | 2120504.56885 | 37.8028197593833 | -122.424678452667 | (37.8028197593833, -122.424678452667) | 5 | 9 | 1 | 28858 | 32 | |||
52835 | 176482 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 751 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009094.68593 | 2092828.45865 | 37.7270219888582 | -122.410770790642 | (37.7270219888582, -122.410770790642) | 9 | 3 | 7 | 309 | 28 | |||
54970 | 112220 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999785.2022 | 2111976.4403 | 37.7790713042385 | -122.444328861929 | (37.7790713042385, -122.444328861929) | 15 | 5 | 1 | 29490 | 16 | |||
55726 | 112230 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999608.2076 | 2111950.3818 | 37.7789896544652 | -122.444939282166 | (37.7789896544652, -122.444939282166) | 15 | 5 | 1 | 29490 | 16 | |||
57809 | 176484 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 751 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009148.6586 | 2092846.14487 | 37.7270735775638 | -122.410585455665 | (37.7270735775638, -122.410585455665) | 9 | 3 | 7 | 309 | 28 | |||
58487 | 112216 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999876.9145 | 2111991.6693 | 37.7791183512882 | -122.444012687447 | (37.7791183512882, -122.444012687447) | 15 | 5 | 1 | 29490 | 16 | |||
59578 | 192189 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014899.53632 | 2116102.22671 | 37.7912505100498 | -122.392330469077 | (37.7912505100498, -122.392330469077) | 6 | 2 | 9 | 28855 | 6 | |||
60546 | 112229 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999625.4671 | 2111952.4123 | 37.778996214713 | -122.444879720826 | (37.778996214713, -122.444879720826) | 15 | 5 | 1 | 29490 | 16 | |||
65630 | 112208 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000131.4077 | 2112027.2035 | 37.7792304332977 | -122.443134847125 | (37.7792304332977, -122.443134847125) | 15 | 5 | 1 | 29490 | 16 | |||
65986 | 192178 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6015027.50587 | 2115974.64571 | 37.7909073071818 | -122.391878769291 | (37.7909073071818, -122.391878769291) | 6 | 2 | 9 | 28855 | 6 | |||
69951 | 192186 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6014933.05778 | 2116063.98242 | 37.7911473614027 | -122.392211808925 | (37.7911473614027, -122.392211808925) | 6 | 2 | 9 | 28855 | 6 | |||
70065 | 128807 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010751.17773 | 2121662.93366 | 37.8062876315397 | -122.407075873864 | (37.8062876315397, -122.407075873864) | 3 | 1 | 10 | 308 | 23 | |||
70151 | 112231 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999586.5486 | 2111947.336 | 37.7789800553383 | -122.44501399007 | (37.7789800553383, -122.44501399007) | 15 | 5 | 1 | 29490 | 16 | |||
73098 | 137618 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000 TURK BLVD | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999494.1594 | 2111936.8449 | 37.7789459760178 | -122.445332845737 | (37.7789459760178, -122.445332845737) | 15 | 5 | 1 | 54 | 16 | |||
73362 | 218965 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 110 Edgewood Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 5996620.68148 | 2106396.26972 | 37.7635685464754 | -122.4548728666 | (37.7635685464754, -122.4548728666) | 15 | 5 | 11 | 29492 | 12 | |||
80848 | 192183 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014959.29976 | 2116038.8631 | 37.7910798466 | -122.392119254319 | (37.7910798466, -122.392119254319) | 6 | 2 | 9 | 28855 | 6 | |||
82402 | 192192 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014928.99529 | 2116169.34325 | 37.7914364323013 | -122.392233237069 | (37.7914364323013, -122.392233237069) | 6 | 2 | 9 | 28855 | 6 | |||
82904 | 192177 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6015044.75368 | 2115956.99358 | 37.7908597960042 | -122.391817857305 | (37.7908597960042, -122.391817857305) | 6 | 2 | 9 | 28855 | 6 | |||
89683 | 128802 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010774.40927 | 2121527.84155 | 37.8059180020812 | -122.406985948869 | (37.8059180020812, -122.406985948869) | 3 | 1 | 10 | 308 | 23 | |||
91165 | 192185 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6014943.40955 | 2116055.80461 | 37.7911254818008 | -122.392175419669 | (37.7911254818008, -122.392175419669) | 6 | 2 | 9 | 28855 | 6 | |||
95207 | 192188 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6014909.81903 | 2116090.63513 | 37.7912192532274 | -122.392294079819 | (37.7912192532274, -122.392294079819) | 6 | 2 | 9 | 28855 | 6 | |||
95398 | 112233 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999535.7853 | 2111942.5981 | 37.7789641488857 | -122.445189259355 | (37.7789641488857, -122.445189259355) | 15 | 5 | 1 | 29490 | 16 | |||
99297 | 989 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1654 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6001587.11696 | 2092507.46593 | 37.7257168090816 | -122.436701320907 | (37.7257168090816, -122.436701320907) | 9 | 7 | 6 | 28861 | 25 | |||
99788 | 128799 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010785.19281 | 2121446.81831 | 37.8056961357319 | -122.406942916281 | (37.8056961357319, -122.406942916281) | 3 | 1 | 10 | 308 | 23 | |||
100877 | 112226 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999690.1056 | 2111964.2571 | 37.7790324262058 | -122.444656962607 | (37.7790324262058, -122.444656962607) | 15 | 5 | 1 | 29490 | 16 | |||
102134 | 192181 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6014979.69188 | 2116018.41542 | 37.791024834186 | -122.392047267172 | (37.791024834186, -122.392047267172) | 6 | 2 | 9 | 28855 | 6 | |||
103226 | 79790 | Permitted Site 7 | Fraxinus americana :: American Ash 381 | 1367 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52440 | 6008963.36292155 | 2109590.31438919 | 37.7730389407256 | -122.41240905716 | (37.7730389407256, -122.41240905716) | 8 | 2 | 9 | 28853 | 34 | ||
104878 | 17328 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006653.98787 | 2108819.46705 | 37.7707925108849 | -122.420342766214 | (37.7707925108849, -122.420342766214) | 8 | 2 | 9 | 28853 | 19 | |||
106198 | 112212 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000031.5732 | 2112011.6361 | 37.7791819962456 | -122.443479096263 | (37.7791819962456, -122.443479096263) | 15 | 5 | 1 | 29490 | 16 | |||
106794 | 17325 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2016 12:00:00 AM | 3 | 3x3 | 6006651.4447 | 2108878.46794 | 37.7709543699737 | -122.420355751511 | (37.7709543699737, -122.420355751511) | 8 | 2 | 9 | 28853 | 19 | ||
107323 | 112210 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000061.0159 | 2112016.0356 | 37.7791957551898 | -122.443377558283 | (37.7791957551898, -122.443377558283) | 15 | 5 | 1 | 29490 | 16 | |||
107824 | 128803 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6010772.33613 | 2121543.44092 | 37.8059607180809 | -122.406994223527 | (37.8059607180809, -122.406994223527) | 3 | 1 | 10 | 308 | 23 | |||
108750 | 192190 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6014904.23889 | 2116143.28316 | 37.7913635026863 | -122.392317070973 | (37.7913635026863, -122.392317070973) | 6 | 2 | 9 | 28855 | 6 | |||
110238 | 128805 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010758.93625 | 2121613.40498 | 37.8061520722219 | -122.407045530742 | (37.8061520722219, -122.407045530742) | 3 | 1 | 10 | 308 | 23 | |||
114807 | 112204 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000217.3668 | 2112038.033 | 37.7792650692531 | -122.44283825785 | (37.7792650692531, -122.44283825785) | 15 | 5 | 1 | 29490 | 16 | |||
121101 | 84273 | Permitted Site 7 | Fraxinus americana :: American Ash 381 | 3420 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50589 | 6007432.35867316 | 2104438.63663813 | 37.7588076039256 | -122.417339857257 | (37.7588076039256, -122.417339857257) | 2 | 4 | 7 | 28859 | 19 | ||
122910 | 112214 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999912.7872 | 2111996.4072 | 37.7791334066275 | -122.443888930048 | (37.7791334066275, -122.443888930048) | 15 | 5 | 1 | 29490 | 16 | |||
124876 | 112225 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999706.3499 | 2111966.626 | 37.7790398575412 | -122.444600937512 | (37.7790398575412, -122.444600937512) | 15 | 5 | 1 | 29490 | 16 | |||
125298 | 112201 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000313.4786 | 2112051.2315 | 37.7793067878446 | -122.442506716118 | (37.7793067878446, -122.442506716118) | 15 | 5 | 1 | 29490 | 16 | |||
131395 | 120314 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 178 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5988704.36476 | 2114157.60504 | 37.7844217323407 | -122.482821407456 | (37.7844217323407, -122.482821407456) | 11 | 6 | 2 | 55 | 26 | |||
135505 | 112209 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000086.736 | 2112020.0967 | 37.7792083726121 | -122.44328887392 | (37.7792083726121, -122.44328887392) | 15 | 5 | 1 | 29490 | 16 | |||
137508 | 112211 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000045.7869 | 2112014.0051 | 37.7791893114958 | -122.443430095603 | (37.7791893114958, -122.443430095603) | 15 | 5 | 1 | 29490 | 16 | |||
138559 | 176481 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 751 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6009070.61182 | 2092821.38895 | 37.7270012270993 | -122.410853515679 | (37.7270012270993, -122.410853515679) | 9 | 3 | 7 | 309 | 28 | |||
149961 | 176479 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1624 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001670.19338 | 2092689.01218 | 37.7262200148265 | -122.436427120331 | (37.7262200148265, -122.436427120331) | 9 | 7 | 6 | 28861 | 25 | |||
150310 | 192194 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6014948.50747 | 2116187.80459 | 37.7914882062707 | -122.392167016412 | (37.7914882062707, -122.392167016412) | 6 | 2 | 9 | 28855 | 6 | |||
150468 | 17329 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006657.292 | 2108797.54474 | 37.7707325036273 | -122.420329780922 | (37.7707325036273, -122.420329780922) | 8 | 2 | 9 | 28853 | 19 | |||
154468 | 112206 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000170.3262 | 2112030.9262 | 37.7792428738926 | -122.443000479785 | (37.7792428738926, -122.443000479785) | 15 | 5 | 1 | 29490 | 16 | |||
156628 | 128801 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010778.48493 | 2121493.15112 | 37.8058229788108 | -122.406969397716 | (37.8058229788108, -122.406969397716) | 3 | 1 | 10 | 308 | 23 | |||
160492 | 128804 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010764.51043 | 2121581.8591 | 37.8060657669756 | -122.407024015346 | (37.8060657669756, -122.407024015346) | 3 | 1 | 10 | 308 | 23 | |||
161149 | 112224 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999721.5789 | 2111968.3181 | 37.7790453725975 | -122.444548376071 | (37.7790453725975, -122.444548376071) | 15 | 5 | 1 | 29490 | 16 | |||
161393 | 192196 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 77 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6014973.5029 | 2116205.54717 | 37.7915383110903 | -122.392081773252 | (37.7915383110903, -122.392081773252) | 6 | 2 | 9 | 28855 | 6 | |||
162430 | 112200 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 6000341.5676 | 2112055.2926 | 37.7793195396336 | -122.442409836485 | (37.7793195396336, -122.442409836485) | 15 | 5 | 1 | 29490 | 16 | |||
164035 | 143110 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 566 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 6010230.9083 | 2119932.1131 | 37.8015060984123 | -122.408754179532 | (37.8015060984123, -122.408754179532) | 3 | 1 | 10 | 308 | 23 | |||
166138 | 112234 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999518.8642 | 2111940.5676 | 37.7789576077977 | -122.445247649985 | (37.7789576077977, -122.445247649985) | 15 | 5 | 1 | 29490 | 16 | |||
166697 | 35778 | Permitted Site 7 | Fraxinus americana :: American Ash 381 | 3426 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51390 | 6007395.20860977 | 2104436.57542117 | 37.7587998540815 | -122.417468193596 | (37.7587998540815, -122.417468193596) | 2 | 4 | 7 | 28859 | 19 | ||
170811 | 128798 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010788.13884 | 2121419.29471 | 37.8056207275841 | -122.406930779942 | (37.8056207275841, -122.406930779942) | 3 | 1 | 10 | 308 | 23 | |||
175259 | 112215 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5999896.5429 | 2111994.715 | 37.7791278336753 | -122.443945003918 | (37.7791278336753, -122.443945003918) | 15 | 5 | 1 | 29490 | 16 | |||
176356 | 176483 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 751 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009120.13043 | 2092835.04217 | 37.7270414924457 | -122.410683293803 | (37.7270414924457, -122.410683293803) | 9 | 3 | 7 | 309 | 28 | |||
178171 | 192179 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6015008.84996 | 2115990.5046 | 37.7909498163315 | -122.391944427912 | (37.7909498163315, -122.391944427912) | 6 | 2 | 9 | 28855 | 6 | |||
178801 | 17326 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 150 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2015 12:00:00 AM | 24 | 3X3 | 6006652.92291 | 2108866.07298 | 37.7709204196628 | -122.420349758429 | (37.7709204196628, -122.420349758429) | 8 | 2 | 9 | 28853 | 19 | ||
183250 | 3378 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 6042 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 5988776.43373 | 2114029.70842 | 37.7840747573181 | -122.482562701651 | (37.7840747573181, -122.482562701651) | 11 | 6 | 2 | 55 | 26 | ||
186500 | 192180 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 209 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6014994.30773 | 2116006.28065 | 37.7909923263706 | -122.391995847526 | (37.7909923263706, -122.391995847526) | 6 | 2 | 9 | 28855 | 6 | |||
187230 | 176480 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 89 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004600.65706 | 2092987.51005 | 37.7272057050533 | -122.426317902365 | (37.7272057050533, -122.426317902365) | 9 | 7 | 6 | 28861 | 5 | |||
188272 | 128800 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 1970 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010780.9231 | 2121471.98773 | 37.8057650058121 | -122.406959467428 | (37.8057650058121, -122.406959467428) | 3 | 1 | 10 | 308 | 23 |
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) );