307 rows where qCareAssistant = "" and qSpecies_id = 47 sorted by PlotSize

View and edit SQL

qCareAssistant

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)
929 257972 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2091 44th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3     5982601.27724 2100898.28737 37.7476584613609 -122.502953711343 (37.7476584613609, -122.502953711343) 1 8 3 29491 35
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
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
3158 44124 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 751 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/29/2000 12:00:00 AM     Permit Number 43628 5981028.36208653 2110606.15983469 37.774220913121 -122.509113438342 (37.774220913121, -122.509113438342) 11 6 2 55 26
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
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                    
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
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
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
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
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
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
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
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
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
31184 218289 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 13 Sidewalk: Curb side : Yard Tree Private 2     28     5991265.02617 2095485.25519 37.7333010580894 -122.472600653515 (37.7333010580894, -122.472600653515) 1 8 4 64 40
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
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
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
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
40263 227676 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 427 Valley St 1 Sidewalk: Curb side : Yard Tree Private 2     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762) 2 7 5 63 22
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
47603 218294 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 18 Sidewalk: Curb side : Yard Tree Private 2     9     5991183.55146 2095353.09261 37.7329334566034 -122.472872697534 (37.7329334566034, -122.472872697534) 1 8 4 64 40
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
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
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
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
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
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
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
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
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
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
76135 98307 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05848 2110712.18551 37.7753089605415 -122.461804398804 (37.7753089605415, -122.461804398804) 11 6 2 54 11
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
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
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
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
90219 41465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3445 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2000 12:00:00 AM 24   Permit Number 42050 5983633.32729372 2103553.20607522 37.755008735539 -122.499581179885 (37.755008735539, -122.499581179885) 1 8 3 56 35
90709 218280 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 7 Sidewalk: Curb side : Yard Tree Private 2     30     5991369.16642 2095649.34471 37.7337576340075 -122.472252572693 (37.7337576340075, -122.472252572693) 1 8 4 64 40
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
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
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
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
99585 59481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05513 2110730.54303 37.7753593652253 -122.461805741777 (37.7753593652253, -122.461805741777) 11 6 2 54 11
107383 54526 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4530 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777496 5981479.33824 2110998.92324 37.7753259029383 -122.507582607669 (37.7753259029383, -122.507582607669) 11 6 2 55 26
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
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
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
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
117562 217831 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 21 Sidewalk: Property side : Yard Tree Private 2     22     5991381.66969 2095739.82508 37.734006793868 -122.472215938837 (37.734006793868, -122.472215938837) 1 8 4 64 40
118985 227671 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 60 Front Yard : Yard Tree Private 2     10     6005087.18528 2097058.71456 37.7384118144577 -122.424925504521 (37.7384118144577, -122.424925504521) 2 7 5 63 7
121679 227674 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 83 Front Yard : Yard Tree Private 2     15     6005065.10158 2097012.05309 37.7382824451638 -122.424998540269 (37.7382824451638, -122.424998540269) 2 7 5 63 7
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
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
135265 218293 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 17 Sidewalk: Curb side : Yard Tree Private 2     22     5991192.67429 2095369.91493 37.7329801745819 -122.472842384068 (37.7329801745819, -122.472842384068) 1 8 4 64 40
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
136204 35418 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 221 Crestmont Dr 3 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
136897 102790 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3445 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     17   Permit Number 42050 5983633 2103554 37.7550108962308 -122.499582370415 (37.7550108962308, -122.499582370415) 1 8 3 56 35
137363 84886 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3138 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM     Permit No. 49329 5983290 2099514 37.7438980447125 -122.500469849117 (37.7438980447125, -122.500469849117) 1 8 3 29491 35
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
141197 227672 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 62 Front Yard : Yard Tree Private 2     15     6005095.2123 2097053.48648 37.7383979127325 -122.424897379118 (37.7383979127325, -122.424897379118) 2 7 5 28859 7
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
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
148893 42597 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1950 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 7   Permit Number 42667 6005420.67346 2116544.61332 37.7919342879744 -122.425158599805 (37.7919342879744, -122.425158599805) 13 9 1 28858 27
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
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
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
154772 85386 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1239 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49657 5981144.8 2106623.2 37.7632917298848 -122.508414943002 (37.7632917298848, -122.508414943002) 1 8 3 56 35
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
156310 227675 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 104 Front Yard : Yard Tree Private 2     27     6005040.40727 2096975.56438 37.7381808604543 -122.425081325568 (37.7381808604543, -122.425081325568) 2 7 5 63 7
158626 50817 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47   1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2004 12:00:00 AM     Permit Number 47340 5995605.94135709 2094497.43585496 37.7308390591092 -122.457521563876 (37.7308390591092, -122.457521563876) 9 7 4 28861 40
161986 122182 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 14th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10     5991497.78568 2114857.01928 37.7865042639669 -122.473208256238 (37.7865042639669, -122.473208256238) 11 6 1 54 33
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
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
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
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
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
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
181040 227673 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 64 Front Yard : Yard Tree Private 2     12     6005078.09924 2097049.53511 37.7383860965292 -122.424956266738 (37.7383860965292, -122.424956266738) 2 7 5 63 7
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
181949 218284 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 50x Junipero Serra Frontage West 0 Median : Yard Tree DPW 1     28     5991438.8932 2095398.77837 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523) 1 8 4 64 40
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
185884 35419 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 221 Crestmont Dr 1 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
186347 207117 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 41 Ralston St 9 Back Yard : Yard Tree Private 2     19     5992170.67066 2088214.06867 37.7133885481037 -122.468940655584 (37.7133885481037, -122.468940655584) 9 8 6 64 24
187087 207108 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 89 Ralston St 3 Back Yard : Yard Tree Private 2     13     5992168.92954 2088415.82729 37.7139424279717 -122.468961347182 (37.7139424279717, -122.468961347182) 9 8 6 64 24

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