406 rows where qSpecies_id = 47 sorted by qCaretaker_id

View and edit SQL

These facets timed out: 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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
63526 882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1138X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.97393 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056) 9 7 5 28861 25
68936 13417 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 400 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999553.15658 2097034.91654 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717) 9 7 4 59 40
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
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
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
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
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
100968 1262 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X5   5992602.03225 2087509.49597 37.7114788737215 -122.467398529617 (37.7114788737215, -122.467398529617) 9 8 4 64 24
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
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
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
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
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
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
128589 18878 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2305 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     26 3X3   6003659.52132 2115878.15996 37.7900047293604 -122.431204600475 (37.7900047293604, -122.431204600475) 13 9 1 29490 27
131012 207124 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 5 Front Yard : Yard Tree DPW 1   08/18/2016 09:54:00 AM 9 Width 0ft   5991335.55729 2095661.67857 37.7337895545331 -122.472369667134 (37.7337895545331, -122.472369667134) 1 8 4 64 40
134083 24808 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 7117 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/22/1996 12:00:00 AM 3 3X3   5984967.23631 2112432.54215 37.7794670623637 -122.495623106999 (37.7794670623637, -122.495623106999) 11 6 2 55 26
136968 29586 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500X Junipero Serra Blvd 21 Median : Cutout Tree DPW 1     9 3X3   5991342.7865 2093687.81781 37.7283702470744 -122.472200841009 (37.7283702470744, -122.472200841009) 9 8 4 64 40
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
159820 29601 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900X Junipero Serra Blvd 10 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991172.09001 2091066.888 37.7211639453471 -122.472599932234 (37.7211639453471, -122.472599932234) 9 8 4 64 40
161260 26830 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3590X 19th Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/1999 12:00:00 AM 8 3x18   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219) 9 8 4 64 40
169833 2477 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2307X Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x4   6003648.68016 2115921.80581 37.7901239554137 -122.43124522669 (37.7901239554137, -122.43124522669) 13 9 1 29490 27
172236 207126 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 3 Front Yard : Yard Tree DPW 1   08/18/2016 09:59:00 AM 13 Width 0ft   5991329.52565 2095655.77453 37.7337729944342 -122.472390089849 (37.7337729944342, -122.472390089849) 1 8 4 64 40
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
174988 29627 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900X Junipero Serra Blvd 36 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 12 3X3   5991152.87782 2090760.03066 37.7203202787275 -122.472643981031 (37.7203202787275, -122.472643981031) 9 8 4 64 40
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
180157 24738 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 7700 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1996 12:00:00 AM 3 3X3   5983089.13202 2112566.68135 37.7797252106941 -122.502130088809 (37.7797252106941, -122.502130088809) 11 6 2 55 26
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
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
183941 207125 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 4 Front Yard : Yard Tree DPW 1   08/18/2016 09:56:00 AM 13 Width 0ft   5991332.89244 2095658.50101 37.7337806755214 -122.47237864866 (37.7337806755214, -122.47237864866) 1 8 4 64 40
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
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
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
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
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
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
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
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
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
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
18160 79486 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2323 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 0 3x3 Permit Number 50743 5981719.67239804 2099271.03998771 37.7431386384508 -122.505881575612 (37.7431386384508, -122.505881575612) 1 8 3 29491 35
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
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
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
25754 47111 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.7409195061747 -122.418109646545 (37.7409195061747, -122.418109646545) 2 7 7 28859 2
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
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
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
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
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
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
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

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