trees

192 rows where PlotSize = "" and qSpecies_id = 47 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

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)
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
184865 47963 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 558 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45693 5996827.75466141 2095403.22069376 37.7333962339357 -122.453362951949 (37.7333962339357, -122.453362951949) 9 7 4 59 40
139775 51442 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 775 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.416865768693 (37.7334476580973, -122.416865768693) 2 7 7 28859 2
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
192189 217850 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 5 Sidewalk: Curb side : Yard Tree Private 2     25     5991375.86862 2095660.38148 37.7337883260711 -122.47223020567 (37.7337883260711, -122.47223020567) 1 8 4 64 40
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
187678 48774 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 629 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684) 2 7 7 28859 2
104777 47604 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 645 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45440 6008713.69382569 2095849.48701302 37.7352957148385 -122.412301312985 (37.7352957148385, -122.412301312985) 10 7 7 28859 2
129532 52497 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 371 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48606 6007135.79724675 2096038.97616324 37.7357273409345 -122.417770123047 (37.7357273409345, -122.417770123047) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
157838 46382 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2495 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.7401721103617 -122.501371213543 (37.7401721103617, -122.501371213543) 1 8 3 29491 35
165329 46381 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2495 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.7401721103617 -122.501371213543 (37.7401721103617, -122.501371213543) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
100650 78557 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2234 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2016 12:00:00 AM 3   Permit Number 771299 5981748.2661 2099861.5988 37.7447618317919 -122.505826480334 (37.7447618317919, -122.505826480334) 1 8 3 29491 35
192707 49012 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2002 12:00:00 AM     Permit Number 46198 6003561.60300767 2099494.42119752 37.7450134133041 -122.430373957908 (37.7450134133041, -122.430373957908) 2 7 5 63 22
137505 34621 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 370 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3   Permit Number 778228 6003497.10528776 2099542.95496323 37.7451430220882 -122.430600441889 (37.7451430220882, -122.430600441889) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
122107 46973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1783 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 7   Permit Number 44992 5982214.0178657 2102979.50871383 37.7533501437558 -122.504446973742 (37.7533501437558, -122.504446973742) 1 8 3 56 35
138561 36089 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1706 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM     Permit Number 44997 5981032.08177403 2103436.82774177 37.7545362217712 -122.508568229446 (37.7545362217712, -122.508568229446) 1 8 3 56 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
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
128532 52554 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1719 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 8   Permit Number 48649 5984370.92860727 2103469.2332855 37.754821420905 -122.497024185091 (37.754821420905, -122.497024185091) 1 8 3 56 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
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
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
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
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
172448 46969 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1658 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 7   Permit Number 44989 5982547.49278996 2103828.23178681 37.7557001072445 -122.503356606053 (37.7557001072445, -122.503356606053) 1 8 3 56 35
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
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
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
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
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
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
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
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
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
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
192536 191375 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 16 Sidewalk: Curb side : Yard Tree Private 2     24     6011300.32576 2104333.131 37.7587347705187 -122.403955140934 (37.7587347705187, -122.403955140934) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
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
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
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
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

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