406 rows where qSpecies_id = 47 sorted by Police Districts

View and edit SQL

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)
93 260525 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
9695 260526 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3437x Rivera St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
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                    
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
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
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
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
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
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
80079 129470 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 45 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     10     6008463.14234 2119145.61201 37.7992473914164 -122.414815771241 (37.7992473914164, -122.414815771241) 5 1 10 308 32
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
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
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
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
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
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
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
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
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
174774 249938 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 339 Filbert St 3 Front Yard : Yard Tree Private 2     8 Width 0ft   6011244.68883 2120032.52194 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256) 3 1 10 308 23
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
76430 30765 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1593 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34646 6014616.43299999 2093667.83534348 37.7296348056211 -122.391740711397 (37.7296348056211, -122.391740711397) 10 3 8 58 1
77789 201278 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 28 Lydia Ave 1 : Tree Private 2     6 Width 2ft   6012862.05555 2092837.94578 37.7272585546286 -122.397747632568 (37.7272585546286, -122.397747632568) 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
95937 191368 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 60 Median : Yard Tree DPW 1     25     6012502.16132 2102909.31056 37.7548923442165 -122.399698643387 (37.7548923442165, -122.399698643387) 10 3 8 28856 29
95984 191373 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 13 Sidewalk: Curb side : Yard Tree Private 2     10     6011285.49599 2104337.84522 37.7587468861739 -122.40400676112 (37.7587468861739, -122.40400676112) 10 3 8 28856 29
98199 191377 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 27 Sidewalk: Curb side : Yard Tree Private 2     16     6011285.82751 2104250.98235 37.7585083985743 -122.403999501776 (37.7585083985743, -122.403999501776) 10 3 8 28856 29
99467 191408 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 5 Front Yard : Yard Tree Private 2     3     6016232.34971 2100308.61772 37.7479586171136 -122.38661714986 (37.7479586171136, -122.38661714986)   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
105958 191384 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 35 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143) 10 3 8 28856 29
108342 35388 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 753 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 7   Permit Number 38842 6011306.15832 2104840.46729 37.7601281288176 -122.403970671318 (37.7601281288176, -122.403970671318) 10 3 8 28856 29
112785 191378 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 28 Sidewalk: Curb side : Yard Tree Private 2     6     6011285.84337 2104240.29901 37.7584790653842 -122.40399869511 (37.7584790653842, -122.40399869511) 10 3 8 28856 29
113543 191379 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 29 Sidewalk: Curb side : Yard Tree Private 2     5     6011295.70989 2104243.81406 37.758489268176 -122.403964819445 (37.758489268176, -122.403964819445) 10 3 8 28856 29
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
122548 191380 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 30 Sidewalk: Curb side : Yard Tree Private 2     13     6011289.9844 2104226.04846 37.7584401679041 -122.403983370659 (37.7584401679041, -122.403983370659) 10 3 8 28856 29
123019 191383 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 34 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317) 10 3 8 28856 29
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
133496 191385 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 37 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6011271.65755 2104161.44484 37.7582617567794 -122.404042206986 (37.7582617567794, -122.404042206986) 10 3 8 28856 29
135665 191404 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 14 Front Yard : Yard Tree Private 2     20     6016173.59275 2100299.3088 37.7479298037296 -122.3868196817 (37.7479298037296, -122.3868196817)   3 8 58 1
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
163899 191389 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 43 Sidewalk: Curb side : Yard Tree Private 2     8 Width 9ft   6011309.9548 2104119.65272 37.7581491445771 -122.403906816767 (37.7581491445771, -122.403906816767) 10 3 8 28856 29
165316 191374 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 15 Sidewalk: Curb side : Yard Tree Private 2     10     6011292.66605 2104334.91271 37.7587392347502 -122.403981757255 (37.7587392347502, -122.403981757255) 10 3 8 28856 29
167360 191381 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 32 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6011271.17001 2104191.36243 37.7583438765916 -122.404045998546 (37.7583438765916, -122.404045998546) 10 3 8 28856 29
173115 191406 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 8 Front Yard : Yard Tree Private 2     5     6016222.17813 2100305.95006 37.7479507291578 -122.386652137081 (37.7479507291578, -122.386652137081)   3 8 58 1
179733 191387 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 39 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6011279.1597 2104155.21456 37.7582450689735 -122.404015822688 (37.7582450689735, -122.404015822688) 10 3 8 28856 29
181108 191382 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 33 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6011269.01089 2104184.59965 37.7583251868659 -122.404052989848 (37.7583251868659, -122.404052989848) 10 3 8 28856 29
182337 191386 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 38 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6011275.59142 2104157.94605 37.7582523696726 -122.404028355649 (37.7582523696726, -122.404028355649) 10 3 8 28856 29
192536 191375 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 16 Sidewalk: Curb side : Yard Tree Private 2     24     6011300.32576 2104333.131 37.7587347705187 -122.403955140934 (37.7587347705187, -122.403955140934) 10 3 8 28856 29
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
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
47586 57377 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3505 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006157.87748572 2102561.9990288 37.7535830045092 -122.421614323469 (37.7535830045092, -122.421614323469) 2 4 5 28859 19
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
54078 52269 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48434 6005520.49766263 2101354.49181367 37.7502315077339 -122.423732674774 (37.7502315077339, -122.423732674774) 2 4 5 28859 19
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
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
62191 255989 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003384.96446 2106555.65654 37.7643918851964 -122.431488741482 (37.7643918851964, -122.431488741482) 15 4 5 28862 3
63925 167503 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003389.60758 2106563.82057 37.7644145648084 -122.431473265088 (37.7644145648084, -122.431473265088) 15 4 5 28862 3
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
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
76454 227670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005513.92482 2101330.09926 37.7501641603604 -122.423753669923 (37.7501641603604, -122.423753669923) 2 4 5 28859 19
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
87369 81868 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3012-3014 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52207 6009486.0303434 2101043.89087343 37.749601722793 -122.409997630916 (37.749601722793, -122.409997630916) 2 4 7 28859 19
89012 227683 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 923 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007409.88053 2101914.88747 37.7518767015549 -122.417238758882 (37.7518767015549, -122.417238758882) 2 4 7 28859 19
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
113892 191398 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 4 Front Yard : Yard Tree Private 2     14     6010740.07849 2107915.77093 37.7685405734149 -122.406145147482 (37.7685405734149, -122.406145147482) 8 4 8 28853 19
127819 227694 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 239 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999877.66163 2104769.07166 37.7592869569347 -122.443491144794 (37.7592869569347, -122.443491144794) 2 4 5 28862 3
142493 227693 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002979.94012 2100929.17253 37.7489199393117 -122.432487701248 (37.7489199393117, -122.432487701248) 2 4 5 28862 22
154411 191399 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 5 Front Yard : Yard Tree Private 2     5     6010727.66479 2107914.72417 37.7685370048986 -122.406188011877 (37.7685370048986, -122.406188011877) 8 4 8 28853 19
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
174016 167504 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003358.46768 2106563.63668 37.7644122949287 -122.431580956196 (37.7644122949287, -122.431580956196) 15 4 5 28862 3
179306 191395 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 1 Front Yard : Yard Tree Private 2     22     6010771.29847 2107917.19939 37.7685462418407 -122.406037260315 (37.7685462418407, -122.406037260315) 8 4 8 28853 19
181779 191403 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 9 Front Yard : Yard Tree Private 2     5     6010692.20162 2107913.0668 37.7685304704432 -122.406310559796 (37.7685304704432, -122.406310559796) 8 4 8 28853 19
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
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
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
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
56247 35417 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 221 Crestmont Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38870 5995170.62655697 2103759.11614599 37.7562443131302 -122.459697089533 (37.7562443131302, -122.459697089533) 1 5 4 63 12
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
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

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