trees

3,587 rows where qSpecies_id = 28 sorted by qAddress

✎ View and edit SQL

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)
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8604 48746 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8893 50823 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
9839 48748 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10173 48744 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10360 30354 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1956 12:00:00 AM     Permit Number 43                    
11935 50824 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
12040 48742 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
12785 48747 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15071 48749 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15641 48745 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
18540 48750 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
110440 176058 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Crespi Dr 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989854.78687 2090110.33741 37.7184611570226 -122.477083556286 (37.7184611570226, -122.477083556286) 1 8 4 64 14
8634 176044 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     21     5990534.22824 2089263.30634 37.7161748133009 -122.474673246391 (37.7161748133009, -122.474673246391) 1 8 4 64 14
39739 176040 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989182.35151 2090508.47222 37.7195153009692 -122.479436972335 (37.7195153009692, -122.479436972335) 1 8 4 64 14
88918 176045 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     20     5990157.58815 2089581.85402 37.7170276349961 -122.475998332672 (37.7170276349961, -122.475998332672) 1 8 4 64 14
101312 176046 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     24     5990073.98867 2089647.08481 37.7172018948419 -122.47629205486 (37.7172018948419, -122.47629205486) 1 8 4 64 14
113662 176042 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     19     5989234.3289 2090278.89103 37.7188879474116 -122.479240521736 (37.7188879474116, -122.479240521736) 1 8 4 64 14
163419 176043 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     19     5989267.95492 2090414.23117 37.7192615104927 -122.479134185915 (37.7192615104927, -122.479134185915) 1 8 4 64 14
21900 176048 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788) 1 8 4 64 14
37254 176052 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     17     5989234.20998 2089407.11974 37.7164942740645 -122.47917719598 (37.7164942740645, -122.47917719598) 1 8 4 64 14
54735 176050 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     13     5989206.75613 2089405.10082 37.7164871361381 -122.47927194137 (37.7164871361381, -122.47927194137) 1 8 4 64 14
58195 176054 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     16     5989245.31981 2089315.24778 37.7162426617475 -122.479132078791 (37.7162426617475, -122.479132078791) 1 8 4 64 14
68726 176047 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     24     5988958.7133 2089588.42281 37.7169760831658 -122.480142699133 (37.7169760831658, -122.480142699133) 1 8 4 64 14
106648 176051 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989218.52603 2089406.15184 37.7164907055632 -122.479231336085 (37.7164907055632, -122.479231336085) 1 8 4 64 14
147050 176056 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     24     5989277.71826 2089365.90518 37.7163836358725 -122.479023798614 (37.7163836358725, -122.479023798614) 1 8 4 64 14
155164 176057 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     18     5989281.98257 2089351.51723 37.7163443777799 -122.479008007435 (37.7163443777799, -122.479008007435) 1 8 4 64 14
155266 176055 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard Tree Private 2     24     5989270.85841 2089380.99818 37.7164246791237 -122.479048612712 (37.7164246791237, -122.479048612712) 1 8 4 64 14
179912 176053 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     19     5989219.15665 2089312.55172 37.7162337395604 -122.479222313162 (37.7162337395604, -122.479222313162) 1 8 4 64 14
182033 176049 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     18     5989054.79394 2089564.29309 37.716915411303 -122.479808833919 (37.716915411303, -122.479808833919) 1 8 4 64 14
166866 189393 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 24th St 15 : Yard Tree Private 2     10     6017282.75412 2102644.41979 37.7544303427117 -122.383147413432 (37.7544303427117, -122.383147413432) 10 3 8 28856 29
34555 33952 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1 Arbor St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/09/1997 12:00:00 AM     Permit Number 37910 6002287.3237241 2097040.91143479 37.7382043832783 -122.434604778209 (37.7382043832783, -122.434604778209) 2 7 5 63 7
120293 246700 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Bonview St 6 Sidewalk: Curb side : Yard Tree Private 2     23     6007679.27037 2099071.40446 37.7440842882538 -122.416105810948 (37.7440842882538, -122.416105810948) 2 7 7 28859 2
95275 212173 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6001737.04216 2095788.25615 37.7347336277483 -122.436417746678 (37.7347336277483, -122.436417746678) 2 7 5 63 7
84462 248767 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5999684.37778 2101641.28638 37.7506877996061 -122.443934882898 (37.7506877996061, -122.443934882898) 2 5 5 63 38
103760 248770 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 4 Sidewalk: Curb side : Yard Tree Private 2     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.443797893655 (37.7509737525388, -122.443797893655) 2 5 5 63 38
116924 248773 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 8ft   5999776.82694 2101824.96428 37.7511974076537 -122.44362838044 (37.7511974076537, -122.44362838044) 2 5 5 63 38
138040 248768 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 6 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999691.3486 2101670.41928 37.7507681891085 -122.443912870204 (37.7507681891085, -122.443912870204) 2 5 5 63 38
154296 248772 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 2 Sidewalk: Curb side : Yard Tree Private 2     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491) 2 5 5 63 38
159994 248769 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 5 Sidewalk: Curb side : Yard Tree Private 2     14 Width 8ft   5999705.10082 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114) 2 5 5 63 38
191142 248771 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Cuesta Ct 3 Sidewalk: Curb side : Yard Tree Private 2     13 Width 8ft   5999742.36883 2101773.9828 37.7510554595584 -122.4437438777 (37.7510554595584, -122.4437438777) 2 5 5 63 38
66269 99611 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1 Entrada Ct 3 Sidewalk: Property side : Yard Tree Private 2           5992743 2092489 37.7251595224946 -122.467273147781 (37.7251595224946, -122.467273147781) 9 8 4 59 40
174389 126287 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Florence St 3 Sidewalk: Property side : Yard Tree Private 2     21     6008482.54317 2118328.02028 37.7970035775046 -122.41469074659 (37.7970035775046, -122.41469074659) 5 1 10 308 21
144905 212100 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 San Marcos Ave 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5993916.20186 2100058.21492 37.746010367202 -122.463766678685 (37.746010367202, -122.463766678685) 1 8 4 29491 40
5273 218292 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 16 Sidewalk: Curb side : Yard Tree Private 2     39     5991223.38049 2095418.74528 37.7331160279643 -122.472739784911 (37.7331160279643, -122.472739784911) 1 8 4 64 40
6176 217849 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 4 Sidewalk: Curb side : Yard Tree Private 2     33     5991387.06493 2095679.62189 37.7338418033391 -122.47219289908 (37.7338418033391, -122.47219289908) 1 8 4 64 40
83584 218291 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 15 Sidewalk: Curb side : Yard Tree Private 2     18     5991233.57986 2095433.30624 37.7331565991011 -122.472705584612 (37.7331565991011, -122.472705584612) 1 8 4 64 40
133078 218282 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 9 Sidewalk: Curb side : Yard Tree Private 2     12     5991361.16684 2095634.83429 37.7337173290882 -122.472279171949 (37.7337173290882, -122.472279171949) 1 8 4 64 40
167465 218290 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 14 Sidewalk: Curb side : Yard Tree Private 2     34     5991251.16534 2095467.63693 37.733251880466 -122.472647289653 (37.733251880466, -122.472647289653) 1 8 4 64 40
8101 248796 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Worth St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 4ft   6000890.35954 2103205.50188 37.7550514765476 -122.439876646295 (37.7550514765476, -122.439876646295) 2 4 5 28862 22
63778 254163 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 Brotherhood Way 1 Side Yard : Cutout Tree Private 2       Width 0ft   5993694.0595 2087568.46764 37.7117037797802 -122.463628505047 (37.7117037797802, -122.463628505047) 9 8 4 64 24
74693 189490 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 Cashmere St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6017365.32139 2095872.25334 37.7358399134893 -122.382390730173 (37.7358399134893, -122.382390730173) 10 3 8 58 1
126584 222106 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 Corwin St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001073.13519 2103957.39296 37.7571263896905 -122.439298447871 (37.7571263896905, -122.439298447871) 2 4 5 28862 38
130928 189484 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 Garlington Ct 1 : Tree Private 2     17 Width 8ft   6016756.63544 2094656.7103 37.7324686339128 -122.384410582284 (37.7324686339128, -122.384410582284) 10 3 8 58 1
185763 206307 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5994456.80406 2089957.2483 37.7183067254442 -122.461165314131 (37.7183067254442, -122.461165314131) 9 8 6 28861 24
3026 142443 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 58 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5997409.7349 2114492.5218 37.7858439854294 -122.452728168531 (37.7858439854294, -122.452728168531) 11 6 1 54 31
7933 142422 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 37 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816) 11 6 1 54 31
16576 142423 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 38 Sidewalk: Property side : Yard Tree Private 2     26 Width 0ft   5997605.1735 2114516.8881 37.7859220855908 -122.452053767548 (37.7859220855908, -122.452053767548) 11 6 1 54 31
24268 142433 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 48 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5997499.5859 2114503.0128 37.7858779390155 -122.452418068061 (37.7858779390155, -122.452418068061) 11 6 1 54 31
24554 142386 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 1 Sidewalk: Property side : Yard Tree Private 2     27 Width 0ft   5998114.6675 2114591.1717 37.7861552196694 -122.450296423393 (37.7861552196694, -122.450296423393) 11 6 1 54 31
25883 142395 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 10 Sidewalk: Property side : Yard Tree Private 2     30 Width 0ft   5997933.9503 2114564.4364 37.7860714676838 -122.450919725605 (37.7860714676838, -122.450919725605) 11 6 1 54 31
27609 142416 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 31 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5997686.3947 2114529.7482 37.7859620480803 -122.451773694005 (37.7859620480803, -122.451773694005) 11 6 1 54 31
28380 142413 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 28 Sidewalk: Property side : Yard Tree Private 2     22 Width 0ft   5997716.1759 2114533.1324 37.7859730457909 -122.451670903916 (37.7859730457909, -122.451670903916) 11 6 1 54 31
28660 142432 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 47 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5997511.0923 2114504.0281 37.785881385969 -122.452378332604 (37.785881385969, -122.452378332604) 11 6 1 54 31
33719 142414 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 29 Sidewalk: Property side : Yard Tree Private 2     24 Width 0ft   5997709.7458 2114531.1019 37.7859671023257 -122.451693003671 (37.7859671023257, -122.451693003671) 11 6 1 54 31
34929 142400 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 15 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5997877.4339 2114556.6527 37.7860468601303 -122.451114694716 (37.7860468601303, -122.451114694716) 11 6 1 54 31
36184 142399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 14 Sidewalk: Property side : Yard Tree Private 2     18 Width 0ft   5997888.9402 2114558.0064 37.7860512357958 -122.451074983866 (37.7860512357958, -122.451074983866) 11 6 1 54 31
37554 142436 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 51 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5997474.8811 2114498.9518 37.7858653731869 -122.452503246206 (37.7858653731869, -122.452503246206) 11 6 1 54 31
37841 142449 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 64 Sidewalk: Property side : Yard Tree Private 2     21 Width 0ft   5997336.6358 2114481.6923 37.7858100616233 -122.452980287706 (37.7858100616233, -122.452980287706) 11 6 1 54 31
40824 142418 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 33 Sidewalk: Property side : Yard Tree Private 2     25 Width 0ft   5997662.3668 2114527.0408 37.785953238114 -122.451856628165 (37.785953238114, -122.451856628165) 11 6 1 54 31
41589 142438 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 53 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5997453.3913 2114497.9365 37.7858613541886 -122.452577521257 (37.7858613541886, -122.452577521257) 11 6 1 54 31
44030 142446 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 61 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5997383.6764 2114487.7839 37.7858294832179 -122.45281798111 (37.7858294832179, -122.45281798111) 11 6 1 54 31
46750 142444 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 59 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5997400.5975 2114491.1681 37.785839744948 -122.452759683483 (37.785839744948, -122.452759683483) 11 6 1 54 31
50253 142390 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 5 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5998035.1384 2114578.3117 37.7861153578155 -122.450570644279 (37.7861153578155, -122.450570644279) 11 6 1 54 31
51451 142402 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 17 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5997856.7901 2114554.2838 37.7860391738166 -122.451185945453 (37.7860391738166, -122.451185945453) 11 6 1 54 31
57270 142393 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 8 Sidewalk: Property side : Yard Tree Private 2     18 Width 0ft   5997963.0546 2114567.8206 37.7860824259012 -122.45081927712 (37.7860824259012, -122.45081927712) 11 6 1 54 31
60603 142437 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 52 Sidewalk: Property side : Yard Tree Private 2     22 Width 0ft   5997464.7285 2114499.2902 37.7858657206584 -122.452538395628 (37.7858657206584, -122.452538395628) 11 6 1 54 31
69168 142401 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 16 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5997867.6196 2114554.9606 37.7860416521682 -122.451148527313 (37.7860416521682, -122.451148527313) 11 6 1 54 31
69312 142405 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 20 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5997821.9327 2114548.5306 37.7860213812263 -122.451306126982 (37.7860213812263, -122.451306126982) 11 6 1 54 31
69794 142429 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 44 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5997546.2881 2114509.7813 37.7858991990384 -122.452256980794 (37.7858991990384, -122.452256980794) 11 6 1 54 31
73708 142407 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 22 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5997811.1032 2114546.5 37.7860151856477 -122.451343447432 (37.7860151856477, -122.451343447432) 11 6 1 54 31
77211 142398 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 13 Sidewalk: Property side : Yard Tree Private 2     18 Width 0ft   5997898.7544 2114559.3601 37.7860555145741 -122.451041127193 (37.7860555145741, -122.451041127193) 11 6 1 54 31
77566 142417 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 32 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5997674.55 2114528.3945 37.785957652798 -122.451814575532 (37.785957652798, -122.451814575532) 11 6 1 54 31
78277 142388 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 3 Sidewalk: Property side : Yard Tree Private 2     30 Width 0ft   5998066.9501 2114582.3728 37.7861283292793 -122.450460877658 (37.7861283292793, -122.450460877658) 11 6 1 54 31
78860 142428 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 43 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5997554.4102 2114510.1197 37.7859005934783 -122.452228905142 (37.7859005934783, -122.452228905142) 11 6 1 54 31
84460 142450 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 65 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5997309.2236 2114478.6465 37.7858001276963 -122.453074905782 (37.7858001276963, -122.453074905782) 11 6 1 54 31
85270 142409 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 24 Sidewalk: Property side : Yard Tree Private 2     27 Width 0ft   5997773.8768 2114540.7469 37.7859972575145 -122.451471824947 (37.7859972575145, -122.451471824947) 11 6 1 54 31
90873 142396 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 11 Sidewalk: Property side : Yard Tree Private 2     22 Width 0ft   5997922.444 2114562.4059 37.7860652337565 -122.450959387654 (37.7860652337565, -122.450959387654) 11 6 1 54 31
95805 142447 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 62 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5997374.2006 2114486.4302 37.7858252233209 -122.452850666813 (37.7858252233209, -122.452850666813) 11 6 1 54 31
95854 142415 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 30 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5997700.27 2114531.1019 37.7859665596428 -122.451725787187 (37.7859665596428, -122.451725787187) 11 6 1 54 31
96048 142420 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 35 Sidewalk: Property side : Yard Tree Private 2     30 Width 0ft   5997641.3846 2114523.995 37.7859436733812 -122.451929000649 (37.7859436733812, -122.451929000649) 11 6 1 54 31
97094 142403 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 18 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5997842.5764 2114549.5458 37.7860253507043 -122.451234778957 (37.7860253507043, -122.451234778957) 11 6 1 54 31
99250 142435 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 50 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5997482.3264 2114500.9823 37.7858713749679 -122.452477634253 (37.7858713749679, -122.452477634253) 11 6 1 54 31
102129 142419 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 34 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5997648.4915 2114525.3487 37.7859477973415 -122.451904510544 (37.7859477973415, -122.451904510544) 11 6 1 54 31
103262 142387 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 0ft   5998077.7796 2114584.0649 37.7861335951467 -122.450423532667 (37.7861335951467, -122.450423532667) 11 6 1 54 31
104711 142391 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 6 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5998019.9094 2114574.9275 37.7861051940215 -122.450623088237 (37.7861051940215, -122.450623088237) 11 6 1 54 31
116866 142425 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 40 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5997580.8071 2114513.5039 37.7859113977237 -122.45213782389 (37.7859113977237, -122.45213782389) 11 6 1 54 31
118275 142424 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 39 Sidewalk: Property side : Yard Tree Private 2     30 Width 0ft   5997593.3287 2114514.5192 37.7859149027352 -122.452094576108 (37.7859149027352, -122.452094576108) 11 6 1 54 31
121067 142427 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 42 Sidewalk: Property side : Yard Tree Private 2     27 Width 0ft   5997563.2092 2114510.7965 37.7859029558443 -122.45219851204 (37.7859029558443, -122.45219851204) 11 6 1 54 31

Next page

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