trees
406 rows where qSpecies_id = 47 sorted by Police Districts
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );