trees

406 rows where qSpecies_id = 47 sorted by PermitNotes descending

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
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
152407 36328 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 40 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944) 9 7 4 28861 40
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
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
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
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
157305 34725 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 114 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38379 5981286.97907127 2111325.91865707 37.776212402307 -122.508272287748 (37.776212402307, -122.508272287748) 11 6 2 55 26
188923 34718 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 626 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38373 5981358.16274912 2111480.6327423 37.7766413961782 -122.508037533581 (37.7766413961782, -122.508037533581) 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
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
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
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
105324 32605 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1370 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37071 5984960.54583105 2105873.44387063 37.7614572492102 -122.49516243722 (37.7614572492102, -122.49516243722) 1 8 3 56 35
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
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
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
177187 31580 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1841 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM     Permit Number 35119 5989049.89925793 2102807.07383274 37.7532763860102 -122.48079472189 (37.7532763860102, -122.48079472189) 1 8 3 56 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
121491 31546 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 6   Permit Number 35095 5998394.38199367 2112672.66987383 37.7809035197163 -122.449190424029 (37.7809035197163, -122.449190424029) 15 6 2 54 16
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
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
145902 31168 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 570 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34869 5993027.58275469 2090995.29108117 37.7210745862886 -122.466180882741 (37.7210745862886, -122.466180882741) 9 8 6 64 24
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
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
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
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
193986 68368 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 194 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1993 12:00:00 AM     Permit Number 32189 6002712.41508002 2094283.54436078 37.730657406687 -122.432938086411 (37.730657406687, -122.432938086411) 9 7 5 28861 25
193603 68315 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3820 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32128 5981623.22584135 2100818.01716678 37.7473805290726 -122.506329747472 (37.7473805290726, -122.506329747472) 1 8 3 29491 35
134216 68097 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 49 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.7468442446896 -122.414234251858 (37.7468442446896, -122.414234251858) 2 7 7 28859 2
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
99619 67131 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1439 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM     Permit Number 30551 5994253.6761319 2105720.38065143 37.7615766669983 -122.463010486718 (37.7615766669983, -122.463010486718) 1 5 11 56 12
185212 63714 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.415573763175 (37.7473672046192, -122.415573763175) 2 7 7 28859 2
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
178843 58925 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3925 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1994 12:00:00 AM     Permit Number 18201 5982715.08927534 2104886.86517056 37.7586166666309 -122.502855377053 (37.7586166666309, -122.502855377053) 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
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                        
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
1399 185502 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 56 unknown : Yard Tree Private 2     8 Width 0ft   5985117.0889 2098738.1726 37.7418749156753 -122.494095121998 (37.7418749156753, -122.494095121998) 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
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
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
5099 261940 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Verna St 5 Unaccepted Street : Yard Tree Private 2       Width 3ft   5998303 2096292 37.7359210601709 -122.448326617787 (37.7359210601709, -122.448326617787) 9 7 4 59 40
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
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                        
9810 257975 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2151 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5981994.87893 2100458.26928 37.7464146351308 -122.505017963467 (37.7464146351308, -122.505017963467) 1 8 3 29491 35
9903 257976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2518 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5982121.52259 2097949.45155 37.7395335660245 -122.504394221806 (37.7395335660245, -122.504394221806) 1 8 3 29491 35
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
11025 257974 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2442 45th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   5982413.68522 2098481.44408 37.7410114510299 -122.503423449602 (37.7410114510299, -122.503423449602) 1 8 3 29491 35
13132 207127 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 2 Front Yard : Yard Tree Private 2     4 Width 0ft   5991327.69264 2095651.06492 37.7337599569436 -122.472396083831 (37.7337599569436, -122.472396083831) 1 8 4 64 40
13504 207123 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 6 Front Yard : Yard Tree DPW 1   08/18/2016 09:51:00 AM 21 Width 0ft   5991338.6165 2095665.48618 37.7338001863266 -122.472359368113 (37.7338001863266, -122.472359368113) 1 8 4 64 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
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
17241 186756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 22 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458) 1 8 3 56 35
18824 257973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1527 43rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   5982781.38466 2104724.90462 37.7581758647866 -122.502614113501 (37.7581758647866, -122.502614113501) 1 8 3 56 35
19152 257977 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1675 38th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   5984366.45643 2103783.81819 37.7556849216133 -122.497062869805 (37.7556849216133, -122.497062869805) 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
22890 50289 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
23023 185776 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2113 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987480.2363 2102327.5294 37.7518683261067 -122.486187667743 (37.7518683261067, -122.486187667743) 1 8 3 29491 35
24415 119095 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 6700 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5982534.89521 2109675.70682 37.7717548615052 -122.503833231018 (37.7717548615052, -122.503833231018) 11 6 2 55 26
24427 207105 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5995373.14858 2091601.55002 37.7228742787075 -122.458116856135 (37.7228742787075, -122.458116856135) 9 8 4 28861 24
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
25781 207137 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 103 : Tree Private 2     12 Width 0ft   5991231.72322 2092011.81443 37.7237619311543 -122.47246265254 (37.7237619311543, -122.47246265254) 9 8 4 64 40
26539 207135 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 99 : Tree Private 2     5 Width 0ft   5991243.40911 2092046.59438 37.7238581046423 -122.472424791093 (37.7238581046423, -122.472424791093) 9 8 4 64 40
27854 185961 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2001 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984861.3455 2101337.8929 37.7489980727428 -122.495171051634 (37.7489980727428, -122.495171051634) 1 8 3 29491 35
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
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
30167 207101 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990477.30542 2106226.48097 37.7627480320102 -122.476108237903 (37.7627480320102, -122.476108237903) 1 8 3 56 12
30568 129464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005282.18317 2116523.47353 37.7918684189526 -122.425636272008 (37.7918684189526, -122.425636272008) 13 9 1 28858 27
30997 1213 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3411 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   5993897.04108 2087339.7447 37.7110874546042 -122.462910367622 (37.7110874546042, -122.462910367622) 9 8 4 64 24
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
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
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
34278 181438 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1319 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5981181.6009 2106068.5638 37.761771027502 -122.508246492496 (37.761771027502, -122.508246492496) 1 8 3 56 35
34911 185504 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 58 unknown : Yard Tree Private 2     6 Width 0ft   5985115.0968 2098786.6474 37.7420078978362 -122.494105581845 (37.7420078978362, -122.494105581845) 1 8 3 29491 35
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
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
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
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
40373 186512 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 13 unknown : Yard Tree Private 2     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968) 1 8 3 56 35
40962 183209 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4212 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5982952.5112 2098143.3306 37.7401147458032 -122.501535410067 (37.7401147458032, -122.501535410067) 1 8 3 29491 35
42527 207128 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 1 Front Yard : Yard Tree Private 2     15 Width 0ft   5991324.62806 2095649.61894 37.7337558092758 -122.472406573513 (37.7337558092758, -122.472406573513) 1 8 4 64 40
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
43944 184307 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1553 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5982166.1739 2104530.0154 37.7576045827244 -122.50472730219 (37.7576045827244, -122.50472730219) 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
46544 183430 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2508 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988945.948 2098228.8968 37.7406998772059 -122.480819050828 (37.7406998772059, -122.480819050828) 1 8 3 29491 35
46607 176987 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 5ft   6002815.8897 2094148.38707 37.7302921639516 -122.432570708688 (37.7302921639516, -122.432570708688) 9 7 5 28861 25
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

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