trees
307 rows where qCareAssistant = "" and qSpecies_id = 47 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | |
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 | |||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||||
84866 | 227691 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006868.92044 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | 2 | 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 | ||
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 | |||||
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 | |||||
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 | |||
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 | |||
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 | |||
107721 | 23670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 317 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006937.9415449 | 2098264.8464559 | 37.7418279505329 | -122.41861198258 | (37.7418279505329, -122.41861198258) | 2 | 7 | 7 | 28859 | 2 | |||
111648 | 46761 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.7251564045519 | -122.421056498489 | (37.7251564045519, -122.421056498489) | 9 | 7 | 7 | 309 | 5 | |||
137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 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 | ||||
16464 | 207116 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 5992178.8337 | 2088240.41516 | 37.7134613608383 | -122.468914357628 | (37.7134613608383, -122.468914357628) | 9 | 8 | 6 | 64 | 24 | ||||
19861 | 207114 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 23 | 5992175.21623 | 2088282.16276 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | 9 | 8 | 6 | 64 | 24 | ||||
29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
29255 | 176982 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999995.5387 | 2089705.60981 | 37.7179329735202 | -122.442002247903 | (37.7179329735202, -122.442002247903) | 9 | 7 | 6 | 28861 | 25 | |||
36093 | 207107 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992169.55859 | 2088419.40871 | 37.7139522980308 | -122.468959433443 | (37.7139522980308, -122.468959433443) | 9 | 8 | 6 | 64 | 24 | ||||
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 | |||
47089 | 12917 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | 9 | 7 | 6 | 28861 | 25 | |||
48894 | 976 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 6001942.44101 | 2093088.00211 | 37.7273310167784 | -122.435514506557 | (37.7273310167784, -122.435514506557) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
63319 | 207110 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | 9 | 8 | 6 | 64 | 24 | ||||
64604 | 207109 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 14 | 5992170.77084 | 2088338.0326 | 37.7137289289241 | -122.468949325066 | (37.7137289289241, -122.468949325066) | 9 | 8 | 6 | 64 | 24 | ||||
71469 | 176984 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 | |||
75879 | 176985 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5998574.33272 | 2088565.20963 | 37.7147206041402 | -122.446832699994 | (37.7147206041402, -122.446832699994) | 9 | 7 | 6 | 28861 | 25 | |||
94127 | 119281 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992077 | 2088275 | 37.7135504383964 | -122.469268843393 | (37.7135504383964, -122.469268843393) | 9 | 8 | 6 | 64 | 24 | ||||
95742 | 176981 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 1ft | 5999571.4621 | 2089300.92693 | 37.7167976306892 | -122.443439037193 | (37.7167976306892, -122.443439037193) | 9 | 7 | 6 | 28861 | 25 | |||
99445 | 9277 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000049.09202 | 2089751.67924 | 37.7180625213905 | -122.441820442737 | (37.7180625213905, -122.441820442737) | 9 | 7 | 6 | 28861 | 25 | |||
101273 | 12918 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | 9 | 7 | 6 | 28861 | 25 | |||
105561 | 973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | 9 | 7 | 6 | 28861 | 25 | |||
131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 | ||||
132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
139898 | 105256 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185684 | (37.7195776934466, -122.42687185684) | 9 | 7 | 6 | 28861 | 5 | ||
142860 | 207111 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | 9 | 8 | 6 | 64 | 24 | ||||
148733 | 24276 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 350X Winding Way | 14 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.7100038012068 | -122.438925891137 | (37.7100038012068, -122.438925891137) | 9 | 7 | 6 | 28861 | 5 | |||
174244 | 207112 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 12 | 5992171.74672 | 2088295.87352 | 37.7136132266511 | -122.468942885919 | (37.7136132266511, -122.468942885919) | 9 | 8 | 6 | 64 | 24 | ||||
174502 | 16565 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.7168706139428 | -122.443365227339 | (37.7168706139428, -122.443365227339) | 9 | 7 | 6 | 28861 | 25 | |||
177625 | 207115 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 8 | 5992168.43399 | 2088239.25639 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | 9 | 8 | 6 | 64 | 24 | ||||
177777 | 16566 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.7168063779221 | -122.443430230482 | (37.7168063779221, -122.443430230482) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
181786 | 176983 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 |
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) );