trees
81 rows where qSpecies_id = 34 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26444 | 13357 | DPW Maintained 1 | Persea americana :: Avocado 34 | 638 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010007.9165631 | 2090278.8375457 | 37.7200724231428 | -122.407434081538 | (37.7200724231428, -122.407434081538) | 10 | 3 | 7 | 309 | 28 | |||
167366 | 946 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1430 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002284.93229 | 2093705.08311 | 37.729044827466 | -122.434374616167 | (37.729044827466, -122.434374616167) | 9 | 7 | 6 | 28861 | 25 | |||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
151 | 233915 | DPW Maintained 1 | Persea americana :: Avocado 34 | 998 York St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009943.01185 | 2103432.65253 | 37.7561863328563 | -122.408585854469 | (37.7561863328563, -122.408585854469) | 2 | 4 | 7 | 28859 | 19 | |||
8670 | 194260 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1310 Indiana St | 24 | : Yard | Tree | Private 2 | 1 | 6014928.75103 | 2102386.78077 | 37.7535925594679 | -122.391270223251 | (37.7535925594679, -122.391270223251) | 10 | 3 | 8 | 28856 | 29 | ||||
10095 | 132064 | DPW Maintained 1 | Persea americana :: Avocado 34 | 92 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008105.09756 | 2119109.30674 | 37.7991275819391 | -122.416052161003 | (37.7991275819391, -122.416052161003) | 5 | 1 | 10 | 308 | 32 | ||||
14857 | 194268 | Undocumented 4 | Persea americana :: Avocado 34 | 900 Quint St | 3 | Side Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6014100.15686 | 2097559.70841 | 37.7402924173605 | -122.393797854205 | (37.7402924173605, -122.393797854205) | 10 | 3 | 8 | 58 | 1 | |||
16198 | 132062 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2800 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005724.41535 | 2120015.0914 | 37.8014804961952 | -122.424354598679 | (37.8014804961952, -122.424354598679) | 5 | 9 | 1 | 28858 | 32 | |||
17468 | 6907 | Permitted Site 7 | Persea americana :: Avocado 34 | 333 Fell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005876.17496 | 2110669.29389 | 37.7758278290987 | -122.423164749384 | (37.7758278290987, -122.423164749384) | 7 | 9 | 11 | 28852 | 10 | |||
18324 | 109414 | Significant Tree 6 | Persea americana :: Avocado 34 | 4 GUY PL | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6014378.1 | 2114502.6 | 37.7868293368446 | -122.394022608955 | (37.7868293368446, -122.394022608955) | 6 | 2 | 9 | 28855 | 6 | ||||
21613 | 194265 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2045 19th St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6011630.99539 | 2105089.40534 | 37.7608298005882 | -122.402864716533 | (37.7608298005882, -122.402864716533) | 10 | 3 | 8 | 28856 | 29 | |||
22135 | 244945 | DPW Maintained 1 | Persea americana :: Avocado 34 | 301 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005884.7273 | 2110672.5554 | 37.775837267046 | -122.423135396505 | (37.775837267046, -122.423135396505) | 7 | 9 | 11 | 28852 | 10 | |||
26742 | 210896 | DPW Maintained 1 | Persea americana :: Avocado 34 | 475 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994825.96432 | 2100056.8652 | 37.7460590438856 | -122.460620765639 | (37.7460590438856, -122.460620765639) | 1 | 8 | 4 | 59 | 40 | |||
33904 | 178078 | DPW Maintained 1 | Persea americana :: Avocado 34 | 230 Rhine St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5994079.51921 | 2086287.10063 | 37.7082076509257 | -122.462203390794 | (37.7082076509257, -122.462203390794) | 8 | 28588 | ||||||
34249 | 30350 | DPW Maintained 1 | Persea americana :: Avocado 34 | 440 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1956 12:00:00 AM | 20 | Permit Number 33 | 6012926.23946 | 2104997.75127 | 37.7606503768407 | -122.398378580732 | (37.7606503768407, -122.398378580732) | 10 | 3 | 8 | 28856 | 29 | ||
34875 | 181825 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2306 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986109.1541 | 2099495.1904 | 37.7440114838474 | -122.490720617968 | (37.7440114838474, -122.490720617968) | 1 | 8 | 3 | 29491 | 35 | |||
42327 | 105285 | Undocumented 4 | Persea americana :: Avocado 34 | 1055 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998993.5 | 2106394.4 | 37.7636992400688 | -122.446665934844 | (37.7636992400688, -122.446665934844) | 15 | 5 | 11 | 29492 | 9 | ||||
46517 | 210894 | DPW Maintained 1 | Persea americana :: Avocado 34 | 20 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5995638.85534 | 2090053.81981 | 37.7186398424234 | -122.457086468664 | (37.7186398424234, -122.457086468664) | 9 | 8 | 6 | 28861 | 24 | |||
49238 | 194271 | DPW Maintained 1 | Persea americana :: Avocado 34 | 981 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013188.13717 | 2089502.23425 | 37.7181175161869 | -122.396386656119 | (37.7181175161869, -122.396386656119) | 10 | 3 | 8 | 58 | 1 | ||||
54582 | 178076 | DPW Maintained 1 | Persea americana :: Avocado 34 | 184 Mount Vernon Ave | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 5998937.21643 | 2089402.34913 | 37.7170399224441 | -122.445638593654 | (37.7170399224441, -122.445638593654) | 9 | 7 | 6 | 28861 | 25 | ||||
61056 | 248086 | DPW Maintained 1 | Persea americana :: Avocado 34 | 64 Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6010586.08965 | 2100411.89734 | 37.7479280005978 | -122.406149049637 | (37.7479280005978, -122.406149049637) | 2 | 7 | 7 | 28859 | 2 | |||
66226 | 120799 | DPW Maintained 1 | Persea americana :: Avocado 34 | 4400 Fulton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 5ft | 5989706.31677 | 2109943.60327 | 37.7729095002423 | -122.479046692921 | (37.7729095002423, -122.479046692921) | 11 | 6 | 2 | 55 | 26 | |||
66575 | 255607 | Undocumented 4 | Persea americana :: Avocado 34 | 347 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006753 | 2104097 | 37.7578313031701 | -122.419665158689 | (37.7578313031701, -122.419665158689) | 2 | 4 | 7 | 28859 | 19 | ||||
66903 | 233917 | Significant Tree 6 | Persea americana :: Avocado 34 | 1011 South Van Ness Ave | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 6007639.59401 | 2103741.67603 | 37.756905567467 | -122.416573768674 | (37.756905567467, -122.416573768674) | 2 | 4 | 7 | 28859 | 19 | |||
69318 | 233921 | DPW Maintained 1 | Persea americana :: Avocado 34 | 4110 22nd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6001448.62339 | 2102939.09436 | 37.7543517482496 | -122.437926932283 | (37.7543517482496, -122.437926932283) | 2 | 4 | 5 | 28862 | 22 | |||
70089 | 194258 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1270 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015024.42192 | 2102663.2368 | 37.7543569580196 | -122.390958689992 | (37.7543569580196, -122.390958689992) | 10 | 3 | 8 | 28856 | 29 | |||
74213 | 233920 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1816 Castro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6002583.4958 | 2100252.3284 | 37.7470389955649 | -122.433810234375 | (37.7470389955649, -122.433810234375) | 2 | 7 | 5 | 63 | 22 | ||||
80312 | 210899 | DPW Maintained 1 | Persea americana :: Avocado 34 | 91 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999501.55632 | 2095473.78302 | 37.7337428797134 | -122.444123970747 | (37.7337428797134, -122.444123970747) | 9 | 7 | 4 | 63 | 40 | |||
82023 | 251383 | DPW Maintained 1 | Persea americana :: Avocado 34 | 49x Milan Ter | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997587 | 2087495 | 37.7117256005197 | -122.450168218052 | (37.7117256005197, -122.450168218052) | 9 | 7 | 6 | 28861 | 25 | ||||
91894 | 199960 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1250 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017933.4982 | 2092697.8939 | 37.7271551121655 | -122.380205768947 | (37.7271551121655, -122.380205768947) | 10 | 3 | 8 | 58 | 1 | |||
97609 | 210901 | DPW Maintained 1 | Persea americana :: Avocado 34 | 326 Detroit St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999451.91396 | 2094291.39231 | 37.7304934798799 | -122.444210661811 | (37.7304934798799, -122.444210661811) | 9 | 7 | 4 | 63 | 40 | |||
99252 | 210898 | DPW Maintained 1 | Persea americana :: Avocado 34 | 714 Detroit St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | 5999457.20499 | 2095395.49192 | 37.7335253804911 | -122.44427168171 | (37.7335253804911, -122.44427168171) | 9 | 7 | 4 | 63 | 40 | ||||
101123 | 256285 | Significant Tree 6 | Persea americana :: Avocado 34 | 155x Caledonia St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6006400 | 2106945 | 37.765631353558 | -122.421088199968 | (37.765631353558, -122.421088199968) | 8 | 4 | 7 | 28853 | 19 | ||||
101770 | 194269 | DPW Maintained 1 | Persea americana :: Avocado 34 | 44 Maddux Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6012736.16954 | 2095503.08046 | 37.7345694538031 | -122.398369742184 | (37.7345694538031, -122.398369742184) | 10 | 3 | 8 | 58 | 1 | |||
103682 | 178079 | DPW Maintained 1 | Persea americana :: Avocado 34 | 70 La Grande Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005235.97843 | 2091865.3286 | 37.7241603326208 | -122.424041830676 | (37.7241603326208, -122.424041830676) | 9 | 7 | 6 | 28861 | 5 | |||
105174 | 202041 | DPW Maintained 1 | Persea americana :: Avocado 34 | 98 Exeter St | 2 | : | Tree | Private 2 | 6 | Width 1ft | 6012452.09567 | 2090741.64379 | 37.7214796982207 | -122.399017796349 | (37.7214796982207, -122.399017796349) | 10 | 3 | 8 | 58 | 1 | |||
106320 | 33311 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1550 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 12 | Permit Number 42771 | 6005499.96948 | 2119274.08442 | 37.7994332039441 | -122.42507852865 | (37.7994332039441, -122.42507852865) | 13 | 9 | 1 | 57 | 17 | |
111296 | 194266 | DPW Maintained 1 | Persea americana :: Avocado 34 | 608 Texas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6013796.40708 | 2104277.77726 | 37.7587219200867 | -122.395318605083 | (37.7587219200867, -122.395318605083) | 10 | 3 | 8 | 28856 | 29 | |||
114795 | 194259 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1310 Indiana St | 22 | : Yard | Tree | Private 2 | 1 | 6014914.86206 | 2102424.38068 | 37.753695030018 | -122.391320882968 | (37.753695030018, -122.391320882968) | 10 | 3 | 8 | 28856 | 29 | ||||
114962 | 210893 | DPW Maintained 1 | Persea americana :: Avocado 34 | 20 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995639.59833 | 2090031.72379 | 37.718579214642 | -122.457082303022 | (37.718579214642, -122.457082303022) | 9 | 8 | 6 | 28861 | 24 | |||
119706 | 194261 | DPW Maintained 1 | Persea americana :: Avocado 34 | 651 Indiana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014939.02651 | 2105368.68341 | 37.7617807949616 | -122.391443134989 | (37.7617807949616, -122.391443134989) | 10 | 3 | 8 | 28856 | 29 | |||
120698 | 233914 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1100 San Jose Ave | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6004613.07877 | 2096547.03368 | 37.7369800631845 | -122.426528310442 | (37.7369800631845, -122.426528310442) | 2 | 7 | 5 | 63 | 7 | ||||
123626 | 46781 | DPW Maintained 1 | Persea americana :: Avocado 34 | 62 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44872 | 6002499.29216 | 2093456.84356 | 37.7283753831173 | -122.433615824308 | (37.7283753831173, -122.433615824308) | 9 | 7 | 6 | 28861 | 25 | |
126885 | 132060 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2830 Filbert St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 5ft | 5999380.69747 | 2118432.66555 | 37.796775320567 | -122.44619273972 | (37.796775320567, -122.44619273972) | 13 | 9 | 1 | 57 | 17 | |||
130300 | 132061 | DPW Maintained 1 | Persea americana :: Avocado 34 | 15 Marion Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008345.93147 | 2119358.10738 | 37.7998242642284 | -122.415236412952 | (37.7998242642284, -122.415236412952) | 5 | 1 | 10 | 308 | 32 | ||||
130796 | 119278 | Undocumented 4 | Persea americana :: Avocado 34 | 20 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995666 | 2090047 | 37.7186226756846 | -122.456992148169 | (37.7186226756846, -122.456992148169) | 9 | 8 | 6 | 28861 | 24 | ||||
131275 | 233913 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2801 Mariposa St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6009155.31558 | 2105892.63028 | 37.7628967259343 | -122.411483776778 | (37.7628967259343, -122.411483776778) | 8 | 4 | 7 | 28859 | 19 | |||
131636 | 178074 | DPW Maintained 1 | Persea americana :: Avocado 34 | 200 Rome St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5998626.69263 | 2088877.91153 | 37.7155822032235 | -122.446674208866 | (37.7155822032235, -122.446674208866) | 9 | 7 | 6 | 28861 | 25 | |||
132278 | 233918 | DPW Maintained 1 | Persea americana :: Avocado 34 | 60 Murray St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6004967.71802 | 2095266.36658 | 37.7334836807325 | -122.425211061736 | (37.7334836807325, -122.425211061736) | 2 | 7 | 7 | 28861 | 2 | |||
132289 | 210895 | DPW Maintained 1 | Persea americana :: Avocado 34 | 178 Tara St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5997929.2878 | 2090647.62509 | 37.7204015648627 | -122.449212166725 | (37.7204015648627, -122.449212166725) | 9 | 8 | 6 | 28861 | 24 | |||
133063 | 256624 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2 Fallon Pl | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6008936 | 2118597 | 37.7977675960784 | -122.413140700683 | (37.7977675960784, -122.413140700683) | 3 | 1 | 10 | 308 | 21 | |||||
139362 | 255610 | DPW Maintained 1 | Persea americana :: Avocado 34 | 355X San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006938 | 2104061 | 37.7577428748963 | -122.419022796788 | (37.7577428748963, -122.419022796788) | 2 | 4 | 7 | 28859 | 19 | ||||
140956 | 194267 | DPW Maintained 1 | Persea americana :: Avocado 34 | 91 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 9ft | 6010928.66819 | 2096415.01821 | 37.7369725871245 | -122.404683089975 | (37.7369725871245, -122.404683089975) | 10 | 3 | 8 | 58 | 1 | |||
140961 | 194264 | DPW Maintained 1 | Persea americana :: Avocado 34 | 128 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013683.86946 | 2106397.49876 | 37.7645359516861 | -122.395856347502 | (37.7645359516861, -122.395856347502) | 14 | 3 | 8 | 28856 | 29 | |||
141098 | 194263 | DPW Maintained 1 | Persea americana :: Avocado 34 | 800 19th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6014959.86504 | 2105335.6122 | 37.7616911451419 | -122.39136875027 | (37.7616911451419, -122.39136875027) | 10 | 3 | 8 | 28856 | 29 | |||
141124 | 100244 | Property Tree 8 | Persea americana :: Avocado 34 | 71 Sanchez St | Back Yard : Yard | Tree | Private 2 | Interior courtyard | 6003507 | 2107903 | 37.7680982797144 | -122.431162830878 | (37.7680982797144, -122.431162830878) | 7 | 9 | 5 | 28862 | 3 | |||||
143379 | 256626 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2 Fallon Pl | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6008936 | 2118597 | 37.7977675960784 | -122.413140700683 | (37.7977675960784, -122.413140700683) | 3 | 1 | 10 | 308 | 21 | |||||
147507 | 119277 | Undocumented 4 | Persea americana :: Avocado 34 | 20 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995666 | 2090047 | 37.7186226756846 | -122.456992148169 | (37.7186226756846, -122.456992148169) | 9 | 8 | 6 | 28861 | 24 | ||||
159885 | 178080 | DPW Maintained 1 | Persea americana :: Avocado 34 | 202 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008024.94769 | 2092933.54254 | 37.7272504886183 | -122.41447630234 | (37.7272504886183, -122.41447630234) | 9 | 3 | 7 | 309 | 28 | |||
162953 | 194262 | DPW Maintained 1 | Persea americana :: Avocado 34 | 599 Indiana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6014908.4103 | 2105804.70057 | 37.7629763042371 | -122.391579509996 | (37.7629763042371, -122.391579509996) | 14 | 3 | 8 | 28856 | 29 | |||
163138 | 178077 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1551 San Jose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6001736.5287 | 2094206.75551 | 37.7303911613047 | -122.436306375544 | (37.7303911613047, -122.436306375544) | 9 | 7 | 6 | 28861 | 25 | |||
163756 | 1475 | Permitted Site 7 | Persea americana :: Avocado 34 | 237 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3 | 5995488.21536 | 2114688.25731 | 37.7862711314145 | -122.45939022597 | (37.7862711314145, -122.45939022597) | 11 | 6 | 1 | 54 | 11 | |||
165632 | 199689 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2000 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015575.7202 | 2092859.8959 | 37.7274695697001 | -122.388367957316 | (37.7274695697001, -122.388367957316) | 10 | 3 | 8 | 58 | 1 | |||
167482 | 178081 | DPW Maintained 1 | Persea americana :: Avocado 34 | 913 Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008142.94596 | 2093501.21518 | 37.728815824271 | -122.414108525499 | (37.728815824271, -122.414108525499) | 9 | 3 | 7 | 309 | 28 | |||
169065 | 108625 | Property Tree 8 | Persea americana :: Avocado 34 | 100 GENEBERN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6004991.8 | 2095242.4 | 37.7334192343039 | -122.425126098693 | (37.7334192343039, -122.425126098693) | 2 | 7 | 7 | 28861 | 2 | ||||
170605 | 256625 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2 Fallon Pl | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6008936 | 2118597 | 37.7977675960784 | -122.413140700683 | (37.7977675960784, -122.413140700683) | 3 | 1 | 10 | 308 | 21 | |||||
172650 | 255483 | Significant Tree 6 | Persea americana :: Avocado 34 | 1295 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6010340.83328 | 2101731.71507 | 37.7515382084299 | -122.407090155993 | (37.7515382084299, -122.407090155993) | 10 | 4 | 7 | 28859 | 19 | ||||
175300 | 132063 | DPW Maintained 1 | Persea americana :: Avocado 34 | 45 Havens St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6007652.14902 | 2119387.88526 | 37.7998670117008 | -122.417639276452 | (37.7998670117008, -122.417639276452) | 5 | 1 | 1 | 28858 | 32 | ||||
178114 | 194270 | DPW Maintained 1 | Persea americana :: Avocado 34 | 311 Townsend St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6013353.50351 | 2110262.56609 | 37.775130177638 | -122.397270057492 | (37.775130177638, -122.397270057492) | 14 | 2 | 9 | 28856 | 20 | |||
178501 | 210900 | DPW Maintained 1 | Persea americana :: Avocado 34 | 326 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999451.31373 | 2094274.71088 | 37.7304476423273 | -122.444211538632 | (37.7304476423273, -122.444211538632) | 9 | 7 | 4 | 63 | 40 | |||
179412 | 178075 | DPW Maintained 1 | Persea americana :: Avocado 34 | 200 Rome St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5998616.5971 | 2088867.694 | 37.7155535715259 | -122.446708368702 | (37.7155535715259, -122.446708368702) | 9 | 7 | 6 | 28861 | 25 | |||
179943 | 233916 | DPW Maintained 1 | Persea americana :: Avocado 34 | 3178 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008600.98611 | 2100616.94315 | 37.7483797759052 | -122.413027970288 | (37.7483797759052, -122.413027970288) | 2 | 4 | 7 | 28859 | 19 | |||
180263 | 233922 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1 Harlow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6003978.84702 | 2106451.05276 | 37.7641383101589 | -122.429427206713 | (37.7641383101589, -122.429427206713) | 8 | 4 | 5 | 28862 | 3 | |||
185497 | 246695 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1 Bonview St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6007634.96405 | 2098994.37065 | 37.7438702793061 | -122.416253557858 | (37.7438702793061, -122.416253557858) | 2 | 7 | 7 | 28859 | 2 | ||||
185503 | 246696 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1 Bonview St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6007645.436 | 2099008.47184 | 37.7439095868695 | -122.4162183467 | (37.7439095868695, -122.4162183467) | 2 | 7 | 7 | 28859 | 2 | ||||
186058 | 248211 | DPW Maintained 1 | Persea americana :: Avocado 34 | 67 Fair Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007036.37972 | 2099436.77793 | 37.7450513535288 | -122.418354689821 | (37.7450513535288, -122.418354689821) | 2 | 7 | 7 | 28859 | 2 | |||
186757 | 210897 | DPW Maintained 1 | Persea americana :: Avocado 34 | 188 Marietta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998834.07718 | 2097829.51554 | 37.740173059348 | -122.44660106611 | (37.740173059348, -122.44660106611) | 9 | 7 | 4 | 59 | 40 | |||
187757 | 143117 | DPW Maintained 1 | Persea americana :: Avocado 34 | 1689 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004350.9426 | 2119740.536 | 37.8006489854254 | -122.42908784499 | (37.8006489854254, -122.42908784499) | 13 | 9 | 1 | 57 | 17 | |||
190672 | 233923 | DPW Maintained 1 | Persea americana :: Avocado 34 | 20 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002185.25785 | 2096400.06868 | 37.7364389824814 | -122.434911853513 | (37.7364389824814, -122.434911853513) | 2 | 7 | 5 | 63 | 7 | |||
192056 | 233919 | DPW Maintained 1 | Persea americana :: Avocado 34 | 60 Murray St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6004972.94282 | 2095265.21393 | 37.7334808109789 | -122.425192916113 | (37.7334808109789, -122.425192916113) | 2 | 7 | 7 | 28861 | 2 | |||
193450 | 233912 | DPW Maintained 1 | Persea americana :: Avocado 34 | 2801 Mariposa St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6009119.38716 | 2105891.31096 | 37.7628910880777 | -122.411607947957 | (37.7628910880777, -122.411607947957) | 8 | 4 | 7 | 28859 | 19 |
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) );