406 rows where qSpecies_id = 47 sorted by SiteOrder

View and edit SQL

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)
98973 250332 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 141 27th Ave 1 : Tree Private 2   05/08/2002 12:00:00 AM 4 Width 3ft Permit Number 45150 5987387.77846 2115003.34197 37.7866671925889 -122.487438428541 (37.7866671925889, -122.487438428541) 11 6 1 55 33
99585 59481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05513 2110730.54303 37.7753593652253 -122.461805741777 (37.7753593652253, -122.461805741777) 11 6 2 54 11
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
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
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
102436 184168 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3732 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5982616.4158 2104253.9424 37.7568730399942 -122.503149769389 (37.7568730399942, -122.503149769389) 1 8 3 56 35
102767 109138 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 759 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773583 5985365.40132 2110729.9835 37.7748156320332 -122.494120186241 (37.7748156320332, -122.494120186241) 11 6 2 55 26
102941 227682 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008186.7931 2096476.12564 37.7369867469298 -122.41416732858 (37.7369867469298, -122.41416732858) 2 7 7 28859 2
103582 83279 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2147 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50736 5982298.4490102 2100494.71161235 37.7465325514695 -122.503970969286 (37.7465325514695, -122.503970969286) 1 8 3 29491 35
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
105029 43632 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50556 5996213.47474732 2098545.79305022 37.7419897418411 -122.455713757113 (37.7419897418411, -122.455713757113) 9 7 4 59 40
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
107125 84447 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2266 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50738 5982378.18226568 2099687.61773546 37.7443211838051 -122.503635505549 (37.7443211838051, -122.503635505549) 1 8 3 29491 35
107383 54526 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4530 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777496 5981479.33824 2110998.92324 37.7753259029383 -122.507582607669 (37.7753259029383, -122.507582607669) 11 6 2 55 26
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
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
109823 52980 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 531 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2006 12:00:00 AM     Permit Number 49067 5992711.66457877 2090721.03501475 37.7203033137371 -122.467252978798 (37.7203033137371, -122.467252978798) 9 8 6 64 24
111648 46761 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 343 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44859 6006106.65621717 2092210.20384218 37.7251564045519 -122.421056498489 (37.7251564045519, -122.421056498489) 9 7 7 309 5
113634 47351 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 246 Monticello St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45277 5991716.56988019 2090163.16086716 37.7187140338834 -122.470652049529 (37.7187140338834, -122.470652049529) 9 8 6 64 24
113945 50219 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2726 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2004 12:00:00 AM 8 3x3 Permit Number 46926 5987073.25597 2111201.47184 37.776209992885 -122.488247096133 (37.776209992885, -122.488247096133) 11 6 2 55 26
113972 50292 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
114789 207103 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 40 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5995614.83933 2092751.51074 37.7260456803487 -122.457364540844 (37.7260456803487, -122.457364540844) 9 7 4 28861 40
115683 129467 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1331 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6006504.31748 2119710.78815 37.8006889650949 -122.421634156713 (37.8006889650949, -122.421634156713) 13 9 1 28858 32
118542 138270 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 218 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998383.8821 2112677.2272 37.7809154323836 -122.449227076582 (37.7809154323836, -122.449227076582) 15 6 2 54 16
119732 47881 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1454 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50547 5982810.24276317 2105223.95269531 37.759547805419 -122.502551248021 (37.759547805419, -122.502551248021) 1 8 3 56 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
121895 50489 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2003 12:00:00 AM     Permit Number 47126 5995378.87438655 2091597.86421043 37.722864487352 -122.458096796728 (37.722864487352, -122.458096796728) 9 8 4 28861 24
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
123096 45360 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 458 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46747 5993277.37926203 2090218.01876098 37.7189547935486 -122.46526098645 (37.7189547935486, -122.46526098645) 9 8 6 64 24
123108 227677 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003907.02908 2099270.15617 37.7444171939021 -122.429163548878 (37.7444171939021, -122.429163548878) 2 7 5 63 22
123946 83251 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2210 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50737 5982365.40001882 2100051.8832382 37.7453206044327 -122.503706674483 (37.7453206044327, -122.503706674483) 1 8 3 29491 35
127819 227694 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 239 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999877.66163 2104769.07166 37.7592869569347 -122.443491144794 (37.7592869569347, -122.443491144794) 2 4 5 28862 3
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
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
128606 82810 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2730 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50728 5983104.2980141 2096628.76061893 37.7359650625832 -122.500898621502 (37.7359650625832, -122.500898621502) 1 8 3 29491 35
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
129636 45429 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 1 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
130752 1383 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2550X Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X2   6002248.65699 2096984.18535 37.7380464314256 -122.434734413124 (37.7380464314256, -122.434734413124) 2 7 5 63 7
131273 207113 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 53 Ralston St 1 Back Yard : Yard Tree Private 2     5     5992170.39113 2088282.95309 37.7135776719473 -122.468946631596 (37.7135776719473, -122.468946631596) 9 8 6 64 24
132662 176986 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 745 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002864.08823 2089338.03726 37.7170867510327 -122.432060704959 (37.7170867510327, -122.432060704959) 9 7 6 28861 5
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
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
134621 227679 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003556.92712 2099495.03666 37.7450148383554 -122.430390170187 (37.7450148383554, -122.430390170187) 2 7 5 63 22
136029 186000 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1883 47th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595) 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
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
137534 50423 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 75 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47076 5995600.08487961 2090390.5729412 37.7195622602365 -122.457244829317 (37.7195622602365, -122.457244829317) 9 8 6 28861 24
137873 227692 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 75 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006684.36987 2096973.81613 37.7382687898828 -122.419397184857 (37.7382687898828, -122.419397184857) 2 7 7 28859 2
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
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
142493 227693 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002979.94012 2100929.17253 37.7489199393117 -122.432487701248 (37.7489199393117, -122.432487701248) 2 4 5 28862 22
145811 129483 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     17     6012307.75016 2120551.40866 37.8033226386787 -122.401610879045 (37.8033226386787, -122.401610879045) 3 1 10 28860 6
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
145982 227697 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 109 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003800.52049 2108768.8119 37.7704922173631 -122.430209350707 (37.7704922173631, -122.430209350707) 15 9 11 29492 10
146162 207104 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995372.52306 2091590.05793 37.7228426882306 -122.458118187099 (37.7228426882306, -122.458118187099) 9 8 4 28861 24
147419 227696 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 50 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6003774.74871 2108065.24722 37.7685589402651 -122.43024829315 (37.7685589402651, -122.43024829315) 7 9 5 28862 3
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
148994 47225 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1643 Felton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM     Permit Number 45170 6006193.94874397 2092417.83045771 37.7257314225765 -122.420769469994 (37.7257314225765, -122.420769469994) 9 7 7 309 5
149652 183373 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2728 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985578.5174 2096788.4906 37.7365485996681 -122.492356136884 (37.7365485996681, -122.492356136884) 1 8 3 29491 35
150862 234 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2994 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     35 2X3   5990616.60068 2095284.10448 37.7327111945568 -122.474827739114 (37.7327111945568, -122.474827739114) 1 8 4 64 40
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
154538 926 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6002807.70183 2094157.47604 37.7303166558715 -122.432599664217 (37.7303166558715, -122.432599664217) 9 7 5 28861 25
154772 85386 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1239 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49657 5981144.8 2106623.2 37.7632917298848 -122.508414943002 (37.7632917298848, -122.508414943002) 1 8 3 56 35
155190 227690 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 307 Bocana St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6006885.1558 2097215.40267 37.7389434396991 -122.418720092463 (37.7389434396991, -122.418720092463) 2 7 7 28859 2
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
158350 37082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1268 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.7629344086854 -122.504939947841 (37.7629344086854, -122.504939947841) 1 8 3 56 35
158626 50817 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47   1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2004 12:00:00 AM     Permit Number 47340 5995605.94135709 2094497.43585496 37.7308390591092 -122.457521563876 (37.7308390591092, -122.457521563876) 9 7 4 28861 40
159025 253462 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
161455 40483 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 165 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41562 5996732.70371963 2089259.1130924 37.7165205210888 -122.453248158457 (37.7165205210888, -122.453248158457) 9 8 6 28861 24
161986 122182 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 14th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10     5991497.78568 2114857.01928 37.7865042639669 -122.473208256238 (37.7865042639669, -122.473208256238) 11 6 1 54 33
163946 117519 Undocumented 4 Leptospermum laevigatum :: Australian Tea Tree 47 1601 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998904 2109014 37.7708868872166 -122.447164026359 (37.7708868872166, -122.447164026359) 15 5 11 29492 9
164867 118789 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 718 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5981995.4955 2110847.43445 37.7749403522663 -122.505785898051 (37.7749403522663, -122.505785898051) 11 6 2 55 26
165308 83228 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4234 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50748 5982916.47531802 2098139.9083931 37.7401032328077 -122.50165975231 (37.7401032328077, -122.50165975231) 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
165614 183438 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2506 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5988326.6233 2098215.7152 37.7406276663345 -122.482959448414 (37.7406276663345, -122.482959448414) 1 8 3 29491 35
165906 84133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 23 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 5 3x3 Permit Number 50705 6011012.12355 2088466.51247 37.7151523039101 -122.403835398892 (37.7151523039101, -122.403835398892) 9 7 8 309 39
166199 79279 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2706 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50726 5983101.82229012 2096724.27729962 37.7362271801162 -122.50091424264 (37.7362271801162, -122.50091424264) 1 8 3 29491 35
166333 244098 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1601 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5998815.2972 2108995.6351 37.7708313932465 -122.447469528169 (37.7708313932465, -122.447469528169) 15 5 11 29492 9
167551 207139 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 208 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996097.00713 2094250.77954 37.7301899955731 -122.455806057116 (37.7301899955731, -122.455806057116) 9 7 4 28861 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
171915 82814 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2724 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50727 5983103.67908303 2096652.63979189 37.7360305919754 -122.500902526777 (37.7360305919754, -122.500902526777) 1 8 3 29491 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
174228 227684 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2560 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002253.36783 2096984.49578 37.7380475512412 -122.434718147625 (37.7380475512412, -122.434718147625) 2 7 5 63 7
174440 246123 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 35 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 Width 0ft Permit Number 779621 5998184.8878 2108385.4066 37.7691198159889 -122.449606139087 (37.7691198159889, -122.449606139087) 15 5 11 29492 9
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
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
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
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
179306 191395 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 1 Front Yard : Yard Tree Private 2     22     6010771.29847 2107917.19939 37.7685462418407 -122.406037260315 (37.7685462418407, -122.406037260315) 8 4 8 28853 19
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
181261 36317 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 208 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51552 5996115.78800404 2094224.07875239 37.7301177594719 -122.455739200241 (37.7301177594719, -122.455739200241) 9 7 4 28861 40
181516 182942 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2671 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5982115.1 2096931.8144 37.7367390358824 -122.504341059874 (37.7367390358824, -122.504341059874) 1 8 3 29491 35
182837 890 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1146 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 4X4   6003547.94647 2094400.70663 37.7310264639915 -122.430057882374 (37.7310264639915, -122.430057882374) 9 7 5 28861 25
184163 184574 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1706 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5981029.903 2103411.5484 37.7544666834786 -122.508573887519 (37.7544666834786, -122.508573887519) 1 8 3 56 35
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
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
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
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
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
190719 109133 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 774 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773526 5985442.4 2110611.6 37.7744950899459 -122.493845109753 (37.7744950899459, -122.493845109753) 11 6 2 55 26

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