406 rows where qSpecies_id = 47 sorted by qAddress

View and edit SQL

qCaretaker_id

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)
13849 117428 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47   2 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776915                    
158626 50817 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47   1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2004 12:00:00 AM     Permit Number 47340 5995605.94135709 2094497.43585496 37.7308390591092 -122.457521563876 (37.7308390591092, -122.457521563876) 9 7 4 28861 40
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
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
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
90709 218280 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 7 Sidewalk: Curb side : Yard Tree Private 2     30     5991369.16642 2095649.34471 37.7337576340075 -122.472252572693 (37.7337576340075, -122.472252572693) 1 8 4 64 40
135265 218293 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 17 Sidewalk: Curb side : Yard Tree Private 2     22     5991192.67429 2095369.91493 37.7329801745819 -122.472842384068 (37.7329801745819, -122.472842384068) 1 8 4 64 40
192189 217850 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 5 Sidewalk: Curb side : Yard Tree Private 2     25     5991375.86862 2095660.38148 37.7337883260711 -122.47223020567 (37.7337883260711, -122.47223020567) 1 8 4 64 40
88904 116681 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100 Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
157287 115975 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 100 SAN JOSE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006168 2102576 37.7536220187283 -122.421580311855 (37.7536220187283, -122.421580311855) 2 4 5 28859 19
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
118985 227671 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 60 Front Yard : Yard Tree Private 2     10     6005087.18528 2097058.71456 37.7384118144577 -122.424925504521 (37.7384118144577, -122.424925504521) 2 7 5 63 7
121679 227674 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 83 Front Yard : Yard Tree Private 2     15     6005065.10158 2097012.05309 37.7382824451638 -122.424998540269 (37.7382824451638, -122.424998540269) 2 7 5 63 7
141197 227672 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 62 Front Yard : Yard Tree Private 2     15     6005095.2123 2097053.48648 37.7383979127325 -122.424897379118 (37.7383979127325, -122.424897379118) 2 7 5 28859 7
156310 227675 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 104 Front Yard : Yard Tree Private 2     27     6005040.40727 2096975.56438 37.7381808604543 -122.425081325568 (37.7381808604543, -122.425081325568) 2 7 5 63 7
181040 227673 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 64 Front Yard : Yard Tree Private 2     12     6005078.09924 2097049.53511 37.7383860965292 -122.424956266738 (37.7383860965292, -122.424956266738) 2 7 5 63 7
105029 43632 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50556 5996213.47474732 2098545.79305022 37.7419897418411 -122.455713757113 (37.7419897418411, -122.455713757113) 9 7 4 59 40
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
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
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
78182 113478 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100x ESMERALDA AVE 5 Unaccepted Street : Yard Tree DPW 1     8     6006917 2098966 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398) 2 7 7 28859 2
65610 237552 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 102 Hancock St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003566.97457 2105097.88602 37.7603995118464 -122.430755182518 (37.7603995118464, -122.430755182518) 2 4 5 28862 3
77195 237551 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 102 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003586.068 2105101.14828 37.7604095509682 -122.430689380017 (37.7604095509682, -122.430689380017) 2 4 5 28862 3
112053 129476 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1077 Front St 5 Sidewalk: Curb side : Yard Tree Private 2     17     6012591.30532 2120127.94056 37.8021757161919 -122.4005998549 (37.8021757161919, -122.4005998549) 3 1 10 28860 6
156277 129475 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1077 Front St 4 Sidewalk: Curb side : Yard Tree Private 2     19     6012586.09993 2120128.51859 37.8021770130129 -122.4006179088 (37.8021770130129, -122.4006179088) 3 1 10 28860 6
155046 129469 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1085 Vallejo St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808) 5 1 10 308 21
145982 227697 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 109 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003800.52049 2108768.8119 37.7704922173631 -122.430209350707 (37.7704922173631, -122.430209350707) 15 9 11 29492 10
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
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
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
138353 129473 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     14     6012532.2991 2120205.04389 37.8023841322847 -122.400809466192 (37.8023841322847, -122.400809466192) 3 1 10 28860 6
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
80039 129480 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     18     6012320.77236 2120522.45554 37.8032438670795 -122.401563778859 (37.8032438670795, -122.401563778859) 3 1 10 28860 6
182552 129482 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     8     6012315.37501 2120537.75286 37.803285568636 -122.401583532467 (37.803285568636, -122.401583532467) 3 1 10 28860 6
81378 50428 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 11 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47081 5996479.47890892 2089951.8399169 37.7184080697361 -122.454173429085 (37.7184080697361, -122.454173429085) 9 8 6 28861 24
83035 33301 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1120 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37453 6009052.27411403 2116787.86536385 37.7928066833324 -122.412610401728 (37.7928066833324, -122.412610401728) 3 1 10 28857 21
174441 889 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1136X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6003353.03343 2094335.58352 37.7308366096666 -122.430727084074 (37.7308366096666, -122.430727084074) 9 7 5 28861 25
63526 882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1138X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.97393 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056) 9 7 5 28861 25
157305 34725 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 114 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38379 5981286.97907127 2111325.91865707 37.776212402307 -122.508272287748 (37.776212402307, -122.508272287748) 11 6 2 55 26
182837 890 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1146 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 4X4   6003547.94647 2094400.70663 37.7310264639915 -122.430057882374 (37.7310264639915, -122.430057882374) 9 7 5 28861 25
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
177935 121420 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1155x Prague St 1 Median : Cutout Tree DPW 1       3x3   6000780 2086820 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343) 9 7 6 28861 5
66800 49718 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1195 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2003 12:00:00 AM     Permit Number 46529 6014698.72785663 2090465.4227663 37.7208461876659 -122.391232442758 (37.7208461876659, -122.391232442758) 10 3 8 58 1
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
93238 129477 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     15     6012514.7758 2120236.23138 37.8024687881724 -122.400872298239 (37.8024687881724, -122.400872298239) 3 1 10 28860 6
152884 129478 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     17     6012509.68294 2120230.66756 37.8024532271953 -122.400889531035 (37.8024532271953, -122.400889531035) 3 1 10 28860 6
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
98776 129484 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     14     6012303.28877 2120555.11364 37.8033325627054 -122.401626578498 (37.8033325627054, -122.401626578498) 3 1 10 28860 6
145003 129486 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     13     6012297.60436 2120565.6201 37.803361093695 -122.401646988622 (37.803361093695, -122.401646988622) 3 1 10 28860 6
145811 129483 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     17     6012307.75016 2120551.40866 37.8033226386787 -122.401610879045 (37.8033226386787, -122.401610879045) 3 1 10 28860 6
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
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
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
127928 186748 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153) 1 8 3 56 35
133352 186762 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.495594492387 (37.7637647274179, -122.495594492387) 1 8 3 56 35
136020 186747 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984869.1172 2106666.6331 37.7636297714118 -122.495537150576 (37.7636297714118, -122.495537150576) 1 8 3 56 35
138219 186752 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106688.9488 37.7636899929755 -122.495600877764 (37.7636899929755, -122.495600877764) 1 8 3 56 35
149988 186750 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106678.2761 37.7636606887382 -122.495600090514 (37.7636606887382, -122.495600090514) 1 8 3 56 35
157835 186754 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984863.7808 2106693.8 37.763704051609 -122.495557611102 (37.763704051609, -122.495557611102) 1 8 3 56 35
185713 186760 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984860.8701 2106711.7495 37.7637531654529 -122.495569002148 (37.7637531654529, -122.495569002148) 1 8 3 56 35
192203 186749 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877) 1 8 3 56 35
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
154772 85386 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1239 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49657 5981144.8 2106623.2 37.7632917298848 -122.508414943002 (37.7632917298848, -122.508414943002) 1 8 3 56 35
28788 50114 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1252 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46839 5992244.12505327 2098460.15223335 37.7415260004029 -122.469432140867 (37.7415260004029, -122.469432140867) 1 8 4 29491 40
141612 183278 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1255 42nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5983028.2339 2106536.9311 37.7631656789881 -122.501894487796 (37.7631656789881, -122.501894487796) 1 8 3 56 35
158350 37082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1268 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.7629344086854 -122.504939947841 (37.7629344086854, -122.504939947841) 1 8 3 56 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
154538 926 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6002807.70183 2094157.47604 37.7303166558715 -122.432599664217 (37.7303166558715, -122.432599664217) 9 7 5 28861 25
53088 33391 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 129 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37510 5993545.21642202 2093774.31911417 37.7287349718633 -122.464593277929 (37.7287349718633, -122.464593277929) 9 8 4 59 40
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
77823 31942 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1300 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39715 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807627 (37.761983899941, -122.50916807627) 1 8 3 56 35
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
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
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
94578 207099 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990478.55232 2106260.78747 37.7628423007597 -122.476106431162 (37.7628423007597, -122.476106431162) 1 8 3 56 12
120655 207100 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990476.61635 2106239.99978 37.7627851110794 -122.476111608564 (37.7627851110794, -122.476111608564) 1 8 3 56 12
115683 129467 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1331 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6006504.31748 2119710.78815 37.8006889650949 -122.421634156713 (37.8006889650949, -122.421634156713) 13 9 1 28858 32
19390 47850 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1342 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.500551730195 (37.7617206013965, -122.500551730195) 1 8 3 56 35
2561 50575 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1347 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM 0   Permit Number 47190 5983353.97136461 2105974.76120709 37.7616412492229 -122.50072631562 (37.7616412492229, -122.50072631562) 1 8 3 56 35
105324 32605 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1370 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37071 5984960.54583105 2105873.44387063 37.7614572492102 -122.49516243722 (37.7614572492102, -122.49516243722) 1 8 3 56 35
77625 32594 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1379 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1996 12:00:00 AM 1   Permit Number 37062 5985531.05347187 2105840.85496484 37.7614011533067 -122.49318691517 (37.7614011533067, -122.49318691517) 1 8 3 56 35
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
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
94439 186509 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 10 unknown : Yard Tree Private 2     7 Width 0ft   5980901.3856 2105130.6001 37.759179132228 -122.509145973072 (37.759179132228, -122.509145973072) 1 8 3 56 35
149118 186513 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 14 unknown : Yard Tree Private 2     5 Width 0ft   5980894.1374 2105147.1675 37.759224194224 -122.509172270667 (37.759224194224, -122.509172270667) 1 8 3 56 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
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
79037 200614 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 55 Median : Cutout Tree DPW 1     6 Width 0ft   6016432.4764 2095111.6325 37.7336998293082 -122.385562980445 (37.7336998293082, -122.385562980445) 10 3 8 58 1
102287 200612 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 53 Median : Cutout Tree DPW 1     4 Width 0ft   6016428.559 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213) 10 3 8 58 1
113599 200616 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 57 Median : Cutout Tree DPW 1     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914) 10 3 8 58 1
125224 200619 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 60 Median : Cutout Tree DPW 1     8 Width 0ft   6016453.0429 2095085.1899 37.7336283611401 -122.385490033201 (37.7336283611401, -122.385490033201) 10 3 8 58 1
98973 250332 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 141 27th Ave 1 : Tree Private 2   05/08/2002 12:00:00 AM 4 Width 3ft Permit Number 45150 5987387.77846 2115003.34197 37.7866671925889 -122.487438428541 (37.7866671925889, -122.487438428541) 11 6 1 55 33
99619 67131 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1439 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM     Permit Number 30551 5994253.6761319 2105720.38065143 37.7615766669983 -122.463010486718 (37.7615766669983, -122.463010486718) 1 5 11 56 12
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
119732 47881 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1454 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50547 5982810.24276317 2105223.95269531 37.759547805419 -122.502551248021 (37.759547805419, -122.502551248021) 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
21677 51414 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1531 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM 0   Permit Number 47738 5988357.88494646 2104888.81015522 37.7589520258954 -122.48334041038 (37.7589520258954, -122.48334041038) 1 8 3 56 35
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
148288 30756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1547 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 1   Permit Number 34637 6015015.9888 2093715.5638 37.7297880302088 -122.390362726863 (37.7297880302088, -122.390362726863) 10 3 8 58 1
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

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