406 rows where qSpecies_id = 47

View and edit SQL

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)
98776 129484 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 12 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     14     6012303.28877 2120555.11364 37.8033325627054 -122.401626578498 (37.8033325627054, -122.401626578498) 3 1 10 28860 6
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
99445 9277 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2161X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000049.09202 2089751.67924 37.7180625213905 -122.441820442737 (37.7180625213905, -122.441820442737) 9 7 6 28861 25
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
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
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
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
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
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
104265 129463 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2451 Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6002236.13059 2116512.00902 37.7916643510872 -122.436174782264 (37.7916643510872, -122.436174782264) 13 9 1 29490 27
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
105151 129466 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6005243.67184 2116520.57545 37.7918582853821 -122.425769315008 (37.7918582853821, -122.425769315008) 13 9 1 28858 27
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
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
105958 191384 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 35 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143) 10 3 8 28856 29
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
107523 123588 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 50 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   5994278.22027 2115268.89087 37.7877957491728 -122.463618619297 (37.7877957491728, -122.463618619297) 11 6 1 54 11
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
108126 50490 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 2 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
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
112053 129476 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1077 Front St 5 Sidewalk: Curb side : Yard Tree Private 2     17     6012591.30532 2120127.94056 37.8021757161919 -122.4005998549 (37.8021757161919, -122.4005998549) 3 1 10 28860 6
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
112832 50290 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 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
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
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
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
113892 191398 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2100 Alameda St 4 Front Yard : Yard Tree Private 2     14     6010740.07849 2107915.77093 37.7685405734149 -122.406145147482 (37.7685405734149, -122.406145147482) 8 4 8 28853 19
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
116625 45431 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 3 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
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
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
118845 47453 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
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
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
120655 207100 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1325 18th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990476.61635 2106239.99978 37.7627851110794 -122.476111608564 (37.7627851110794, -122.476111608564) 1 8 3 56 12
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
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
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
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
122863 129465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1974 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6005261.30695 2116522.05783 37.791863352156 -122.425708403014 (37.791863352156, -122.425708403014) 13 9 1 28858 27
123019 191383 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 34 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317) 10 3 8 28856 29
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
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
126406 207120 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 9 Front Yard : Yard Tree Private 2     21 Width 0ft   5991349.86178 2095682.72956 37.7338481831293 -122.472321746778 (37.7338481831293, -122.472321746778) 1 8 4 64 40
126484 118250 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 759 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5985366.8002 2110712.822 37.7747685933044 -122.494114082166 (37.7747685933044, -122.494114082166) 11 6 2 55 26
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
127928 186748 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153) 1 8 3 56 35
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
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
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
133352 186762 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.495594492387 (37.7637647274179, -122.495594492387) 1 8 3 56 35
133496 191385 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 37 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6011271.65755 2104161.44484 37.7582617567794 -122.404042206986 (37.7582617567794, -122.404042206986) 10 3 8 28856 29
133839 79951 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4332 Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50745 5981564.36989544 2101497.47247657 37.7492426575827 -122.50658364702 (37.7492426575827, -122.50658364702) 1 8 3 29491 35
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
134954 207131 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500 Junipero Serra Blvd 23 : Tree Private 2     14 Width 0ft   5991341.74557 2093676.61882 37.7283394372056 -122.472203623519 (37.7283394372056, -122.472203623519) 9 8 4 64 40
135265 218293 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1 Woodacre Dr 17 Sidewalk: Curb side : Yard Tree Private 2     22     5991192.67429 2095369.91493 37.7329801745819 -122.472842384068 (37.7329801745819, -122.472842384068) 1 8 4 64 40
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
136020 186747 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984869.1172 2106666.6331 37.7636297714118 -122.495537150576 (37.7636297714118, -122.495537150576) 1 8 3 56 35
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
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
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
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
137267 207138 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 123 : Tree Private 2     8 Width 0ft   5991217.22752 2091775.34767 37.7231118130309 -122.472495529957 (37.7231118130309, -122.472495529957) 9 8 4 64 40
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
138219 186752 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106688.9488 37.7636899929755 -122.495600877764 (37.7636899929755, -122.495600877764) 1 8 3 56 35
138353 129473 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 11 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     14     6012532.2991 2120205.04389 37.8023841322847 -122.400809466192 (37.8023841322847, -122.400809466192) 3 1 10 28860 6
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
139898 105256 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 162 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM   3x3 Permit Number 771043 6004383.3 2090213.9 37.7195776934466 -122.42687185684 (37.7195776934466, -122.42687185684) 9 7 6 28861 5
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
141612 183278 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1255 42nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5983028.2339 2106536.9311 37.7631656789881 -122.501894487796 (37.7631656789881, -122.501894487796) 1 8 3 56 35
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
142860 207111 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 59 Ralston St 2 Back Yard : Yard Tree Private 2     11     5992171.5605 2088305.6585 37.713640083085 -122.468944241206 (37.713640083085, -122.468944241206) 9 8 6 64 24

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