406 rows where 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)
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                        
713 38369 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4245 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 5   Permit Number 40431 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224) 1 8 3 56 35
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
2561 50575 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1347 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM 0   Permit Number 47190 5983353.97136461 2105974.76120709 37.7616412492229 -122.50072631562 (37.7616412492229, -122.50072631562) 1 8 3 56 35
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
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
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
8913 50707 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1658 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2004 12:00:00 AM 5   Permit Number 47266 5983788.66504778 2103867.70402192 37.75588137239 -122.499067221884 (37.75588137239, -122.499067221884) 1 8 3 56 35
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
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                        
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
13168 48530 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2251 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM 6   Permit Number 45852 5988214.95937948 2099991.18132471 37.7454961303111 -122.483475662249 (37.7454961303111, -122.483475662249) 1 8 3 29491 35
13174 68069 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 239 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1993 12:00:00 AM     Permit Number 31806 5993313.66059206 2103207.09024288 37.7546216328473 -122.466078949095 (37.7546216328473, -122.466078949095) 1 8 4 56 12
13250 45430 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.7227220958318 -122.463136201451 (37.7227220958318, -122.463136201451) 9 8 4 59 40
13580 260528 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2079 43rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3     5982908.95776 2100987.30444 37.7479209564484 -122.501896372368 (37.7479209564484, -122.501896372368) 1 8 3 29491 35
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
19390 47850 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1342 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.500551730195 (37.7617206013965, -122.500551730195) 1 8 3 56 35
19751 38367 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4245 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 5   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224) 1 8 3 56 35
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
21677 51414 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1531 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM 0   Permit Number 47738 5988357.88494646 2104888.81015522 37.7589520258954 -122.48334041038 (37.7589520258954, -122.48334041038) 1 8 3 56 35
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
26749 31667 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2571 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1995 12:00:00 AM     Permit Number 35175 5981777.56166178 2097600.02639588 37.7385539042174 -122.505557573977 (37.7385539042174, -122.505557573977) 1 8 3 29491 35
28788 50114 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1252 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46839 5992244.12505327 2098460.15223335 37.7415260004029 -122.469432140867 (37.7415260004029, -122.469432140867) 1 8 4 29491 40
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
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
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
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
34167 69291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 830 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33363 5991479.92264349 2102518.55863113 37.7526251419757 -122.472370253301 (37.7526251419757, -122.472370253301) 1 8 4 56 12
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
37486 46399 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2110 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 5   Permit Number 44629 5981721.80383178 2100709.75793181 37.7470890826019 -122.505980852245 (37.7470890826019, -122.505980852245) 1 8 3 29491 35
40068 31575 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1922 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM     Permit Number 35114 5989431.17806618 2102257.22974077 37.7517888142139 -122.479435972521 (37.7517888142139, -122.479435972521) 1 8 3 29491 35
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
42446 52384 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 36TA MARINA Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM     Permit Number 48509 6005730.58900637 2097520.8738626 37.7397171218166 -122.422733759035 (37.7397171218166, -122.422733759035) 2 7 7 28859 2
43896 38348 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1607 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 0   Permit Number 40415 5981863.96536039 2104143.69244361 37.7565260672017 -122.505743805317 (37.7565260672017, -122.505743805317) 1 8 3 56 35
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
51510 33405 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 390 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/04/1998 12:00:00 AM     Permit Number 40744 5992420.09105205 2094203.06284675 37.7298472692889 -122.468514054616 (37.7298472692889, -122.468514054616) 9 8 4 59 40
53088 33391 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 129 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37510 5993545.21642202 2093774.31911417 37.7287349718633 -122.464593277929 (37.7287349718633, -122.464593277929) 9 8 4 59 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
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
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
54666 31185 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 720 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34883 5992147.8527206 2089880.99524616 37.7179642061069 -122.469140766842 (37.7179642061069, -122.469140766842) 9 8 6 64 24
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
57475 45437 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 50 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44224 5993813.83621392 2092411.23769418 37.7250077648019 -122.463565764966 (37.7250077648019, -122.463565764966) 9 8 4 59 40
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
59472 52106 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 727 Rockdale Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM     Permit Number 48298 5997405.05193713 2098248.96190456 37.741243026323 -122.451572279627 (37.741243026323, -122.451572279627) 9 7 4 59 40
61805 47082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 5   Permit Number 45068 5996827.60082146 2111762.20695793 37.7783138890322 -122.45454486672 (37.7783138890322, -122.45454486672) 15 6 2 54 16
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
63902 46390 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2447 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 7   Permit Number 44623 5982678.99712077 2098464.70885711 37.7409810943186 -122.502504874921 (37.7409810943186, -122.502504874921) 1 8 3 29491 35
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
67862 37850 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 211 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40141 6003943.02561838 2092441.0681197 37.7256681018117 -122.428552395212 (37.7256681018117, -122.428552395212) 9 7 6 28861 5
68109 50881 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2040 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47391 5991642.80129947 2101534.85210656 37.7499335653235 -122.471735313093 (37.7499335653235, -122.471735313093) 1 8 4 29491 12
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
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
73341 47451 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
73352 34348 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 330 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38106 6004294.50938701 2096370.47715627 37.7364772644099 -122.427617172202 (37.7364772644099, -122.427617172202) 2 7 5 63 7
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
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
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
77625 32594 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1379 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1996 12:00:00 AM 1   Permit Number 37062 5985531.05347187 2105840.85496484 37.7614011533067 -122.49318691517 (37.7614011533067, -122.49318691517) 1 8 3 56 35
77823 31942 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1300 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39715 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807627 (37.761983899941, -122.50916807627) 1 8 3 56 35
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
81378 50428 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 11 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47081 5996479.47890892 2089951.8399169 37.7184080697361 -122.454173429085 (37.7184080697361, -122.454173429085) 9 8 6 28861 24
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
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
83616 68575 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 7633 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32467 5983299.26193695 2112364.72668983 37.7791830450299 -122.501388226383 (37.7791830450299, -122.501388226383) 11 6 2 55 26
84877 31600 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1631 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM     Permit Number 35126 5988991.64827869 2102380.23074862 37.7521010026968 -122.480964913447 (37.7521010026968, -122.480964913447) 1 8 3 29491 35
86130 52103 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 641 Rockdale Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM     Permit Number 48295 5997742.5728031 2098061.02519693 37.7407463206184 -122.450391713191 (37.7407463206184, -122.450391713191) 9 7 4 59 40
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
89095 46395 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2091 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 9   Permit Number 44627 5981974.76389525 2100876.77542895 37.7475625528023 -122.505118527994 (37.7475625528023, -122.505118527994) 1 8 3 29491 35
89540 33402 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 377 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1996 12:00:00 AM     Permit Number 37520 5992522.58969687 2094276.01733921 37.730053504422 -122.468165013068 (37.730053504422, -122.468165013068) 9 8 4 59 40
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
90861 31375 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 630 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM     Permit Number 34977 5991276.37232485 2099107.33925567 37.7432470351435 -122.472825445815 (37.7432470351435, -122.472825445815) 1 8 4 29491 40
92382 47550 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1681 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787) 2 7 5 63 22
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

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