406 rows where qSpecies_id = 47 sorted by Longitude

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)
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                    
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
75050 49654 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 81 Alpha St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM     Permit Number 46507 6011171.19956943 2088331.01703059 37.7147891465513 -122.403276034448 (37.7147891465513, -122.403276034448) 10 7 8 309 39
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
165906 84133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 23 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 5 3x3 Permit Number 50705 6011012.12355 2088466.51247 37.7151523039101 -122.403835398892 (37.7151523039101, -122.403835398892) 9 7 8 309 39
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
154236 247871 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 3 Side Yard : Yard Tree Private 2     18     6009746.3542 2098404.30325 37.7423685814537 -122.408911206692 (37.7423685814537, -122.408911206692) 10 7 7 28859 2
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
80406 247869 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 1 Side Yard : Yard Tree Private 2     9     6009720.84865 2098403.35069 37.7423645372013 -122.408999330354 (37.7423645372013, -122.408999330354) 10 7 7 28859 2
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
32588 63441 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 299 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1997 12:00:00 AM     Permit Number 24028 6008993.82853707 2096920.83270323 37.738253113659 -122.411408443517 (37.738253113659, -122.411408443517) 10 7 7 28859 2
104777 47604 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 645 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45440 6008713.69382569 2095849.48701302 37.7352957148385 -122.412301312985 (37.7352957148385, -122.412301312985) 10 7 7 28859 2
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
102941 227682 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008186.7931 2096476.12564 37.7369867469298 -122.41416732858 (37.7369867469298, -122.41416732858) 2 7 7 28859 2
71117 52492 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 390ON GATES Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48601 6008184.68107457 2096494.82661811 37.7370379770988 -122.414175953506 (37.7370379770988, -122.414175953506) 2 7 7 28859 2
134216 68097 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 49 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.7468442446896 -122.414234251858 (37.7468442446896, -122.414234251858) 2 7 7 28859 2
93754 227689 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 84 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008214.29979 2099586.39862 37.7455284159971 -122.41429222281 (37.7455284159971, -122.41429222281) 2 7 7 28859 2
32735 40449 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 255 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47061 6008102.60669454 2097399.44811028 37.7395172589666 -122.414523716357 (37.7395172589666, -122.414523716357) 2 7 7 28859 2
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
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
187678 48774 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 629 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684) 2 7 7 28859 2
185212 63714 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.415573763175 (37.7473672046192, -122.415573763175) 2 7 7 28859 2
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
139775 51442 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 775 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.416865768693 (37.7334476580973, -122.416865768693) 2 7 7 28859 2
175565 248189 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 216 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     11     6007400.67054 2098728.2959 37.7431265201804 -122.417044843446 (37.7431265201804, -122.417044843446) 2 7 7 28859 2
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
82654 116655 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
87869 116654 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2

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