406 rows where qSpecies_id = 47 sorted by PlantDate

View and edit SQL

Suggested facets: qSiteInfo, qCaretaker_id, qCareAssistant, Fire Prevention Districts, Supervisor Districts, Neighborhoods (old)

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)
929 257972 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2091 44th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3     5982601.27724 2100898.28737 37.7476584613609 -122.502953711343 (37.7476584613609, -122.502953711343) 1 8 3 29491 35
1399 185502 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 56 unknown : Yard Tree Private 2     8 Width 0ft   5985117.0889 2098738.1726 37.7418749156753 -122.494095121998 (37.7418749156753, -122.494095121998) 1 8 3 29491 35
2126 191407 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 7 Front Yard : Yard Tree Private 2     12     6016225.71134 2100306.15132 37.747951477381 -122.386639933312 (37.747951477381, -122.386639933312)   3 8 58 1
2211 129471 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     9     6012526.59847 2120207.76193 37.8023912773999 -122.400829384367 (37.8023912773999, -122.400829384367) 3 1 10 28860 6
4229 80358 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 336 Campbell Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6011201.39619 2088230.44969 37.7145146953757 -122.403164591892 (37.7145146953757, -122.403164591892) 10 7 8 309 39
4749 227685 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5997626.03081 2107071.20572 37.765479368391 -122.451444382046 (37.765479368391, -122.451444382046) 15 5 11 29492 9
5099 261940 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Verna St 5 Unaccepted Street : Yard Tree Private 2       Width 3ft   5998303 2096292 37.7359210601709 -122.448326617787 (37.7359210601709, -122.448326617787) 9 7 4 59 40
6812 191370 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 63 Median : Yard Tree DPW 1     15     6012517.15762 2102887.31193 37.7548327767283 -122.399645237162 (37.7548327767283, -122.399645237162) 10 3 8 28856 29
9451 84120 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 336 Campbell Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011186.92342 2088226.0732 37.7145018701492 -122.403214308206 (37.7145018701492, -122.403214308206) 10 7 8 309 39
9810 257975 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2151 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5981994.87893 2100458.26928 37.7464146351308 -122.505017963467 (37.7464146351308, -122.505017963467) 1 8 3 29491 35
9903 257976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2518 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5982121.52259 2097949.45155 37.7395335660245 -122.504394221806 (37.7395335660245, -122.504394221806) 1 8 3 29491 35
10441 191402 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 8 Front Yard : Yard Tree Private 2     7     6010700.42675 2107913.45144 37.7685319866755 -122.406282136733 (37.7685319866755, -122.406282136733) 8 4 8 28853 19
11025 257974 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2442 45th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5982413.68522 2098481.44408 37.7410114510299 -122.503423449602 (37.7410114510299, -122.503423449602) 1 8 3 29491 35
13132 207127 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 2 Front Yard : Yard Tree Private 2     4 Width 0ft   5991327.69264 2095651.06492 37.7337599569436 -122.472396083831 (37.7337599569436, -122.472396083831) 1 8 4 64 40
14177 129468 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1151 Lombard St 5 Sidewalk: Property side : Yard Tree Private 2     11     6006718.96895 2120094.36111 37.8017542606157 -122.420918621021 (37.8017542606157, -122.420918621021) 5 1 1 28858 32
15284 191371 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 66 Median : Yard Tree DPW 1     13     6012518.79145 2102845.53786 37.7547181653131 -122.399636654017 (37.7547181653131, -122.399636654017) 10 3 8 28856 29
16464 207116 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 47 Ralston St 9 Back Yard : Yard Tree Private 2     8     5992178.8337 2088240.41516 37.7134613608383 -122.468914357628 (37.7134613608383, -122.468914357628) 9 8 6 64 24
16955 191397 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 3 Front Yard : Yard Tree Private 2     9     6010751.13717 2107916.66974 37.768543659889 -122.406106959582 (37.768543659889, -122.406106959582) 8 4 8 28853 19
17241 186756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 22 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458) 1 8 3 56 35
18824 257973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1527 43rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   5982781.38466 2104724.90462 37.7581758647866 -122.502614113501 (37.7581758647866, -122.502614113501) 1 8 3 56 35
19152 257977 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1675 38th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   5984366.45643 2103783.81819 37.7556849216133 -122.497062869805 (37.7556849216133, -122.497062869805) 1 8 3 56 35
19861 207114 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 53 Ralston St 2 Back Yard : Yard Tree Private 2     23     5992175.21623 2088282.16276 37.7135757806697 -122.468929896991 (37.7135757806697, -122.468929896991) 9 8 6 64 24
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
20311 129474 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     25     6012536.27851 2120200.91706 37.8023730229664 -122.400795405292 (37.8023730229664, -122.400795405292) 3 1 10 28860 6
21600 105136 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175X ESMERALDA AVE 2 unknown : Yard Tree DPW 1           6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
23023 185776 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2113 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987480.2363 2102327.5294 37.7518683261067 -122.486187667743 (37.7518683261067, -122.486187667743) 1 8 3 29491 35
24415 119095 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 6700 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5982534.89521 2109675.70682 37.7717548615052 -122.503833231018 (37.7717548615052, -122.503833231018) 11 6 2 55 26
24427 207105 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5995373.14858 2091601.55002 37.7228742787075 -122.458116856135 (37.7228742787075, -122.458116856135) 9 8 4 28861 24
24972 191392 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 3 Sidewalk: Curb side : Yard Tree Private 2     13     6011311.05886 2104374.20224 37.7588481426559 -122.403920910926 (37.7588481426559, -122.403920910926) 10 3 8 28856 29
25781 207137 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 103 : Tree Private 2     12 Width 0ft   5991231.72322 2092011.81443 37.7237619311543 -122.47246265254 (37.7237619311543, -122.47246265254) 9 8 4 64 40
26539 207135 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 99 : Tree Private 2     5 Width 0ft   5991243.40911 2092046.59438 37.7238581046423 -122.472424791093 (37.7238581046423, -122.472424791093) 9 8 4 64 40
27854 185961 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2001 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984861.3455 2101337.8929 37.7489980727428 -122.495171051634 (37.7489980727428, -122.495171051634) 1 8 3 29491 35
27885 200618 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 59 Median : Cutout Tree DPW 1     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.385517359434 (37.733637339432, -122.385517359434) 10 3 8 58 1
28693 191372 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2220 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011446.77315 2104664.66226 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161) 10 3 8 28856 29
29184 176980 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2315 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   5999548.76247 2089280.82364 37.7167411370713 -122.443516055124 (37.7167411370713, -122.443516055124) 9 7 6 28861 25
29255 176982 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2157 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5999995.5387 2089705.60981 37.7179329735202 -122.442002247903 (37.7179329735202, -122.442002247903) 9 7 6 28861 25
30167 207101 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990477.30542 2106226.48097 37.7627480320102 -122.476108237903 (37.7627480320102, -122.476108237903) 1 8 3 56 12
30568 129464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005282.18317 2116523.47353 37.7918684189526 -122.425636272008 (37.7918684189526, -122.425636272008) 13 9 1 28858 27
30997 1213 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3411 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   5993897.04108 2087339.7447 37.7110874546042 -122.462910367622 (37.7110874546042, -122.462910367622) 9 8 4 64 24
31184 218289 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 13 Sidewalk: Curb side : Yard Tree Private 2     28     5991265.02617 2095485.25519 37.7333010580894 -122.472600653515 (37.7333010580894, -122.472600653515) 1 8 4 64 40
31750 200604 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 61 Median : Cutout Tree DPW 1     8 Width 0ft   6016455.981 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084) 10 3 8 58 1
33940 129485 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 4 Sidewalk: Curb side : Yard Tree Private 2     10     6012301.33061 2120559.21941 37.803343726885 -122.401633643571 (37.803343726885, -122.401633643571) 3 1 10 28860 6
34278 181438 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1319 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5981181.6009 2106068.5638 37.761771027502 -122.508246492496 (37.761771027502, -122.508246492496) 1 8 3 56 35
34911 185504 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 58 unknown : Yard Tree Private 2     6 Width 0ft   5985115.0968 2098786.6474 37.7420078978362 -122.494105581845 (37.7420078978362, -122.494105581845) 1 8 3 29491 35
36093 207107 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 89 Ralston St 2 Back Yard : Yard Tree Private 2     11     5992169.55859 2088419.40871 37.7139522980308 -122.468959433443 (37.7139522980308, -122.468959433443) 9 8 6 64 24
36450 247870 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 2 Side Yard : Yard Tree Private 2     10     6009721.06953 2098395.0417 37.7423417348977 -122.408997980481 (37.7423417348977, -122.408997980481) 10 7 7 28859 2
36662 121603 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 749 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6012453.25739 2104452.2107 37.7591260835233 -122.399976111225 (37.7591260835233, -122.399976111225) 10 3 8 28856 29
37104 191369 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 62 Median : Yard Tree DPW 1     15     6012514.91638 2102899.16549 37.7548651990855 -122.399653820263 (37.7548651990855, -122.399653820263) 10 3 8 28856 29
37655 207106 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100 Tara St 2 : Tree Private 2     20 Width 0ft   5998100.60654 2090923.0946 37.7211677377768 -122.448639805789 (37.7211677377768, -122.448639805789) 9 8 6 28861 24
40263 227676 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 427 Valley St 1 Sidewalk: Curb side : Yard Tree Private 2     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762) 2 7 5 63 22
40373 186512 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 13 unknown : Yard Tree Private 2     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968) 1 8 3 56 35
40962 183209 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4212 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5982952.5112 2098143.3306 37.7401147458032 -122.501535410067 (37.7401147458032, -122.501535410067) 1 8 3 29491 35
42527 207128 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 1 Front Yard : Yard Tree Private 2     15 Width 0ft   5991324.62806 2095649.61894 37.7337558092758 -122.472406573513 (37.7337558092758, -122.472406573513) 1 8 4 64 40
43157 227687 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1003 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5997630.84664 2107024.34604 37.7653509793933 -122.451424345184 (37.7653509793933, -122.451424345184) 15 5 11 29492 9
43944 184307 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1553 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5982166.1739 2104530.0154 37.7576045827244 -122.50472730219 (37.7576045827244, -122.50472730219) 1 8 3 56 35
44818 191405 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 9 Front Yard : Yard Tree Private 2     8     6016216.75475 2100305.37684 37.7479488549636 -122.386670851103 (37.7479488549636, -122.386670851103)   3 8 58 1
45957 191393 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 4 Sidewalk: Curb side : Yard Tree Private 2     26     6011318.33835 2104379.19174 37.758862249405 -122.403896086039 (37.758862249405, -122.403896086039) 10 3 8 28856 29
46544 183430 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2508 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988945.948 2098228.8968 37.7406998772059 -122.480819050828 (37.7406998772059, -122.480819050828) 1 8 3 29491 35
46607 176987 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 5ft   6002815.8897 2094148.38707 37.7302921639516 -122.432570708688 (37.7302921639516, -122.432570708688) 9 7 5 28861 25
46709 191390 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     26     6011298.55233 2104376.91383 37.7588548893488 -122.403964355369 (37.7588548893488, -122.403964355369) 10 3 8 28856 29
47089 12917 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915) 9 7 6 28861 25
47603 218294 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 18 Sidewalk: Curb side : Yard Tree Private 2     9     5991183.55146 2095353.09261 37.7329334566034 -122.472872697534 (37.7329334566034, -122.472872697534) 1 8 4 64 40
47779 138264 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2600 GEARY BLVD 32 unknown : Yard Tree Private 2     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.446995936272 (37.7823276740968, -122.446995936272) 15 5 1 54 16
47837 227688 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 269 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6007769.10714 2097866.49845 37.7407809344798 -122.41570987722 (37.7407809344798, -122.41570987722) 2 7 7 28859 2
48894 976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X4   6001942.44101 2093088.00211 37.7273310167784 -122.435514506557 (37.7273310167784, -122.435514506557) 9 7 6 28861 25
49514 227681 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 145 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5997959.25406 2106183.43699 37.7630608557823 -122.450227846644 (37.7630608557823, -122.450227846644) 15 5 11 29492 9
49589 186745 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984852.3804 2106661.5394 37.763614805479 -122.495594661337 (37.763614805479, -122.495594661337) 1 8 3 56 35
49732 186510 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 11 unknown : Yard Tree Private 2     5 Width 0ft   5980902.4211 2105136.8129 37.7591962518414 -122.509142853237 (37.7591962518414, -122.509142853237) 1 8 3 56 35
50220 18882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2323 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   6003557.0695 2115907.13274 37.7900784748972 -122.43156114415 (37.7900784748972, -122.43156114415) 13 9 1 29490 27
52711 207102 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990480.89082 2106148.89617 37.7625352128593 -122.476090170539 (37.7625352128593, -122.476090170539) 1 8 3 56 12
53776 191401 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 7 Front Yard : Yard Tree Private 2     8     6010711.19096 2107913.74245 37.7685333878424 -122.406244924566 (37.7685333878424, -122.406244924566) 8 4 8 28853 19
54058 129472 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 4 Sidewalk: Curb side : Yard Tree Private 2     7     6012528.94679 2120206.6635 37.8023883923599 -122.400821180758 (37.8023883923599, -122.400821180758) 3 1 10 28860 6
54154 129479 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     10     6012506.13221 2120230.97584 37.8024538756 -122.400901840066 (37.8024538756, -122.400901840066) 3 1 10 28860 6
54525 191388 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 40 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6011282.56063 2104153.62595 37.7582408970175 -122.40400394893 (37.7582408970175, -122.40400394893) 10 3 8 28856 29
55330 186759 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 25 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984850.1974 2106711.7495 37.7637525404811 -122.495605915184 (37.7637525404811, -122.495605915184) 1 8 3 56 35
55583 191391 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6011306.2123 2104378.54497 37.7588597960547 -122.403937978273 (37.7588597960547, -122.403937978273) 10 3 8 28856 29
56036 909 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1217 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   6003163.68633 2094174.89484 37.7303846655151 -122.431370220756 (37.7303846655151, -122.431370220756) 9 7 6 28861 25
56832 227680 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1541 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6003988.60954 2099295.31119 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577) 2 7 5 63 22
56934 191400 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 6 Front Yard : Yard Tree Private 2     18     6010721.65743 2107914.21049 37.7685352584272 -122.406208754734 (37.7685352584272, -122.406208754734) 8 4 8 28853 19
58446 183252 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1300 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5980914.4873 2106074.217 37.7617708050911 -122.509170734828 (37.7617708050911, -122.509170734828) 1 8 3 56 35
58452 101254 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3700X Cesar Chavez St 1 Front Yard : Yard Tree DPW 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
58696 119085 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 886 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5982037.396 2109722.65545 37.7718545033558 -122.505557564286 (37.7718545033558, -122.505557564286) 11 6 2 55 26
59598 191367 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 548 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6011194.69766 2105791.52689 37.7627332975312 -122.404423107658 (37.7627332975312, -122.404423107658) 8 3 8 28856 29
60345 207132 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 87 : Tree Private 2     16 Width 0ft   5991236.29103 2092157.26983 37.7241615799784 -122.472457461649 (37.7241615799784, -122.472457461649) 9 8 4 64 40
60657 183431 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2506 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988944.9633 2098242.436 37.7407369950817 -122.480823446497 (37.7407369950817, -122.480823446497) 1 8 3 29491 35
61664 207136 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 100 : Tree Private 2     6 Width 0ft   5991240.31686 2092039.54753 37.7238385767639 -122.472434966904 (37.7238385767639, -122.472434966904) 9 8 4 64 40
62642 227686 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5997629.48637 2107046.84316 37.7654126728718 -122.451430672783 (37.7654126728718, -122.451430672783) 15 5 11 29492 9
63156 191394 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 5 Sidewalk: Curb side : Yard Tree Private 2     15     6011327.58138 2104381.4608 37.7588689961229 -122.403864278838 (37.7588689961229, -122.403864278838) 10 3 8 28856 29
63319 207110 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 59 Ralston St 1 Back Yard : Yard Tree Private 2     7     5992170.63195 2088310.84387 37.7136542672107 -122.468947827707 (37.7136542672107, -122.468947827707) 9 8 6 64 24
64416 183208 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4208 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5982977.5431 2098144.6836 37.7401199309313 -122.501448961428 (37.7401199309313, -122.501448961428) 1 8 3 29491 35
64604 207109 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 75 Ralston St 2 Back Yard : Yard Tree Private 2     14     5992170.77084 2088338.0326 37.7137289289241 -122.468949325066 (37.7137289289241, -122.468949325066) 9 8 6 64 24
66429 183655 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4000 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5982394.94 2104929.8732 37.7587159336991 -122.503965765246 (37.7587159336991, -122.503965765246) 1 8 3 56 35
66446 191396 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 2 Front Yard : Yard Tree Private 2     6     6010761.04996 2107917.30957 37.7685459711594 -122.406072716988 (37.7685459711594, -122.406072716988) 8 4 8 28853 19
67268 118441 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 5201 Anza St 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5982477.73735 2111660.7356 37.7772018111581 -122.504178007129 (37.7772018111581, -122.504178007129) 11 6 2 55 26
68936 13417 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 400 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999553.15658 2097034.91654 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717) 9 7 4 59 40
69315 138260 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2600 GEARY BLVD 28 unknown : Yard Tree Private 2     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676) 15 5 1 54 16
69319 129481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 4 Sidewalk: Curb side : Yard Tree Private 2     5     6012317.54236 2120532.77652 37.8032720257522 -122.401575682271 (37.8032720257522, -122.401575682271) 3 1 10 28860 6
69496 191376 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 19 Sidewalk: Curb side : Yard Tree Private 2     7     6011285.44743 2104312.53247 37.7586773802801 -122.404005147727 (37.7586773802801, -122.404005147727) 10 3 8 28856 29
71159 207133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 90 : Tree Private 2     10 Width 0ft   5991231.48328 2092142.91587 37.7241218892943 -122.472473035196 (37.7241218892943, -122.472473035196) 9 8 4 64 40
71469 176984 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     28 Width 3ft   5996985 2087493 37.71168564061 -122.45224873895 (37.71168564061, -122.45224873895) 9 7 6 28861 25

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