356 rows where qSpecies_id = 91 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)
60629 106612 Significant Tree 6 Schinus molle :: California Pepper 91 1189 TENNESSEE ST   Front Yard : Yard Tree Private 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
191230 88822 Permitted Site 7 Schinus molle :: California Pepper 91 1011 Castro St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51709 6002511 2102645 37.7536045914774 -122.434231943794 (37.7536045914774, -122.434231943794) 2 4 5 28862 22
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
2766 247224 DPW Maintained 1 Schinus molle :: California Pepper 91 135 Divisadero St 1 : Tree Private 2   08/07/2019 12:00:00 AM 3 Width 3ft   6001887.60725 2108459.11842 37.7695333431173 -122.436803945272 (37.7695333431173, -122.436803945272) 15 5 5 29492 9
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
4861 40879 Permitted Site 7 Schinus molle :: California Pepper 91 38 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM     Permit Number 41789 6008346.99191908 2110451.53839796 37.775369049965 -122.414602124139 (37.775369049965, -122.414602124139) 8 2 9 28853 34
5132 239574 DPW Maintained 1 Schinus molle :: California Pepper 91 322 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 12x9   6003766 2099569 37.7452297653441 -122.429672508032 (37.7452297653441, -122.429672508032) 2 7 5 63 22
6990 97154 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174) 10 3 8 58 1
8068 32395 DPW Maintained 1 Schinus molle :: California Pepper 91 222 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 6 8x6 Permit Number 36936 6005810.68419 2096104.55108 37.735832735077 -122.42235621788 (37.735832735077, -122.42235621788) 2 7 7 28859 2
10299 239628 DPW Maintained 1 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003717.59485 2103189.68577 37.7551685799882 -122.430098127942 (37.7551685799882, -122.430098127942) 2 4 5 28862 22
11330 166753 Planning Code 138.1 required 2 Schinus molle :: California Pepper 91 350 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2019 12:00:00 AM 3 4x4 Permit Number 781737 6002856.72425 2101550.76622 37.7506197011549 -122.43295818429 (37.7506197011549, -122.43295818429) 2 4 5 28862 22
11918 239570 DPW Maintained 1 Schinus molle :: California Pepper 91 540 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x6   6003051.59742 2098931.52845 37.7434389383601 -122.432097274966 (37.7434389383601, -122.432097274966) 2 7 5 63 22
11956 72875 DPW Maintained 1 Schinus molle :: California Pepper 91 2506 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989254.9412 2098243.205 37.7407571191622 -122.47975172868 (37.7407571191622, -122.47975172868) 1 8 3 29491 35
13005 40812 Permitted Site 7 Schinus molle :: California Pepper 91 240 Maywood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
13181 239606 DPW Maintained 1 Schinus molle :: California Pepper 91 179 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997457.76068 2107065.24918 37.7654533761877 -122.452025957451 (37.7654533761877, -122.452025957451) 15 5 11 29492 9
13884 258775 DPW Maintained 1 Schinus molle :: California Pepper 91 833 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999913 2102615 37.7533744192224 -122.443214216983 (37.7533744192224, -122.443214216983) 2 5 5 63 38
15530 239630 DPW Maintained 1 Schinus molle :: California Pepper 91 431 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 3ft   6003562.89343 2102710.70444 37.7538446475336 -122.430598954102 (37.7538446475336, -122.430598954102) 2 4 5 28862 22
16110 173720 DPW Maintained 1 Schinus molle :: California Pepper 91 1799x 25th St 1 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
16131 55409 Permitted Site 7 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/27/1987 12:00:00 AM     Permit Number 11349 6003719.33886967 2103195.40450941 37.7551843810696 -122.430092504551 (37.7551843810696, -122.430092504551) 2 4 5 28862 22
17498 49624 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 8   Permit Number 46480 6007909.99126 2109730.21129 37.7733638956484 -122.416062720842 (37.7733638956484, -122.416062720842) 8 2 9 28853 19
17499 264647 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
17752 70594 DPW Maintained 1 Schinus molle :: California Pepper 91 342 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6004127.79616 2091299.57805 37.7225442769693 -122.427832358882 (37.7225442769693, -122.427832358882) 9 7 6 28861 5
18196 54018 DPW Maintained 1 Schinus molle :: California Pepper 91 850 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 3x3 Permit Number 785014 5985129.09281 2110070.96029 37.7729923119367 -122.494889012959 (37.7729923119367, -122.494889012959) 11 6 2 55 26
23970 136382 DPW Maintained 1 Schinus molle :: California Pepper 91 1015 Vallejo St 1 Front Yard : Yard Tree Private 2     14     6008613.87178 2118642.82165 37.7978753218528 -122.414258600758 (37.7978753218528, -122.414258600758) 5 1 10 308 21
27405 33584 Permitted Site 7 Schinus molle :: California Pepper 91 149 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM     Permit Number 37692 6007187.40748461 2098136.50319387 37.7414895902405 -122.417740314034 (37.7414895902405, -122.417740314034) 2 7 7 28859 2
30132 62463 DPW Maintained 1 Schinus molle :: California Pepper 91 1906 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1985 12:00:00 AM 9   Permit Number 22631 5999997.0295 2111289.4853 37.7771971847485 -122.443546707231 (37.7771971847485, -122.443546707231) 15 5 11 29490 16
31200 53044 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2006 12:00:00 AM 11 3x3 Permit Number 49022 6000981.43692 2118569.50402 37.797242328631 -122.440663646636 (37.797242328631, -122.440663646636) 13 9 1 57 17
32623 138856 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6004940.3956 2111052.9695 37.7768284552741 -122.426429175067 (37.7768284552741, -122.426429175067) 7 9 11 28852 10
33743 5505 DPW Maintained 1 Schinus molle :: California Pepper 91 785 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 6X8   6005062.26258 2103781.17825 37.756868745618 -122.425489962193 (37.756868745618, -122.425489962193) 2 4 5 28859 19
33981 59467 Permitted Site 7 Schinus molle :: California Pepper 91 225 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1980 12:00:00 AM     Permit Number 18832 6003936.96875248 2095250.30733216 37.7333813011767 -122.428773510363 (37.7333813011767, -122.428773510363) 9 7 5 28861 25
34168 68064 Permitted Site 7 Schinus molle :: California Pepper 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31801 5993434.8119843 2102472.74927138 37.7526123103472 -122.465606631992 (37.7526123103472, -122.465606631992) 1 8 4 29491 12
35105 46070 Permitted Site 7 Schinus molle :: California Pepper 91 3746 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44454 6003440.19743527 2103634.04731282 37.7563729765603 -122.431089163341 (37.7563729765603, -122.431089163341) 2 4 5 28862 3
38542 197482 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 1 : Tree Private 2     10 Width 3ft   6007465.83226 2109669.87011 37.7731732303985 -122.417594855315 (37.7731732303985, -122.417594855315) 8 2 9 28853 19
39126 52643 Permitted Site 7 Schinus molle :: California Pepper 91 4264REVISED 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/2006 12:00:00 AM     Permit Number 48726 6000793.82011207 2102903.5552845 37.7542169085305 -122.440188854974 (37.7542169085305, -122.440188854974) 2 4 5 28862 22
40901 122721 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.413960264957 (37.796903132994, -122.413960264957) 5 1 10 308 21
41914 62527 Permitted Site 7 Schinus molle :: California Pepper 91 4255 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22709 6000857.54483189 2102854.89709726 37.7540869327376 -122.439964990906 (37.7540869327376, -122.439964990906) 2 4 5 28862 22
43893 66181 DPW Maintained 1 Schinus molle :: California Pepper 91 1705 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1990 12:00:00 AM 14   Permit Number 29258 6014623.91982 2096111.26058 37.7363443702049 -122.391885618526 (37.7363443702049, -122.391885618526) 10 3 8 58 1
47659 53355 Permitted Site 7 Schinus molle :: California Pepper 91 4131 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1969 12:00:00 AM     Permit Number 6248 6002301.07087845 2102348.37639489 37.752778216412 -122.434936712045 (37.752778216412, -122.434936712045) 2 4 5 28862 22
47789 59597 Permitted Site 7 Schinus molle :: California Pepper 91 636 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1981 12:00:00 AM   6x25 Permit Number 18994 6001186.92515468 2102684.94576678 37.7536390322156 -122.438813738462 (37.7536390322156, -122.438813738462) 2 4 5 28862 22
48059 202092 DPW Maintained 1 Schinus molle :: California Pepper 91 29 Carr St 1 : Tree Private 2     20 Width 3ft   6013102.77465 2090939.87812 37.7220602474585 -122.396782452268 (37.7220602474585, -122.396782452268) 10 3 8 58 1
48994 249781 DPW Maintained 1 Schinus molle :: California Pepper 91 119 Pfeiffer St 1 Back Yard : Yard Tree Private 2     9 Width 0ft   6010443.51385 2121141.6092 37.8048389819848 -122.408103813361 (37.8048389819848, -122.408103813361) 3 1 10 308 23
51524 239649 DPW Maintained 1 Schinus molle :: California Pepper 91 3616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004202.79012 2103671.51063 37.7565190253373 -122.428454521557 (37.7565190253373, -122.428454521557) 2 4 5 28862 3
52524 136373 DPW Maintained 1 Schinus molle :: California Pepper 91 2858 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5999883.33678 2117451.31751 37.7941094908262 -122.444382936819 (37.7941094908262, -122.444382936819) 13 9 1 57 27
54411 214169 DPW Maintained 1 Schinus molle :: California Pepper 91 266 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6000318.85701 2094968.44865 37.7324019411004 -122.441262082491 (37.7324019411004, -122.441262082491) 9 7 5 63 40
55243 239585 DPW Maintained 1 Schinus molle :: California Pepper 91 838 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5998709.19727 2107219.09568 37.7659474025784 -122.44770861806 (37.7659474025784, -122.44770861806) 15 5 11 29492 9
57476 55227 DPW Maintained 1 Schinus molle :: California Pepper 91 211 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1972 12:00:00 AM 13   Permit Number 11145 5988668.09914 2113889.94192 37.7836846949952 -122.48292724876 (37.7836846949952, -122.48292724876) 11 6 2 55 26
58803 239578 DPW Maintained 1 Schinus molle :: California Pepper 91 4092 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6003302.87663 2100696.16376 37.7482984592023 -122.431354355844 (37.7482984592023, -122.431354355844) 2 4 5 28862 22
58835 197505 DPW Maintained 1 Schinus molle :: California Pepper 91 1705 Newcomb Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6014625.38984 2096105.59346 37.7363288910633 -122.391880139859 (37.7363288910633, -122.391880139859) 10 3 8 58 1
59190 183549 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5989226.3762 2097721.7265 37.7393236152619 -122.479812344828 (37.7393236152619, -122.479812344828) 1 8 3 29491 35
59784 45068 DPW Maintained 1 Schinus molle :: California Pepper 91 2227 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM 4   Permit Number 43949 5987902.9352 2100130.6194 37.7458608246267 -122.4845648054 (37.7458608246267, -122.4845648054) 1 8 3 29491 35
60322 49747 DPW Maintained 1 Schinus molle :: California Pepper 91 1266 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 7   Permit Number 46546 6011753.83246 2088984.50512 37.7166160162035 -122.401308097113 (37.7166160162035, -122.401308097113) 10 7 8 309 39
60508 239566 DPW Maintained 1 Schinus molle :: California Pepper 91 3441 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6006878.39898 2100850.62787 37.748924571708 -122.419001222341 (37.748924571708, -122.419001222341) 2 4 7 28859 19
61023 46902 Permitted Site 7 Schinus molle :: California Pepper 91 1416 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44958 5990552.94389775 2105736.96364621 37.7614083342209 -122.47581088419 (37.7614083342209, -122.47581088419) 1 8 4 56 12
62623 239602 DPW Maintained 1 Schinus molle :: California Pepper 91 890 Castro St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6002438.31508 2103064.33818 37.7547518683248 -122.434513284763 (37.7547518683248, -122.434513284763) 2 4 5 28862 22
63478 42173 DPW Maintained 1 Schinus molle :: California Pepper 91 466 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM 11   Permit Number 42461 6010347.47254 2109513.35928 37.7729052153318 -122.407615799844 (37.7729052153318, -122.407615799844) 14 2 9 28853 34
63611 62514 Permitted Site 7 Schinus molle :: California Pepper 91 4221 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22694 6001435.41662208 2103337.91403702 37.7554460598899 -122.438001170091 (37.7554460598899, -122.438001170091) 2 4 5 28862 22
65791 247660 DPW Maintained 1 Schinus molle :: California Pepper 91 117 Divisadero St 1 : Tree Private 2     10 Width 4ft   6001900.46366 2108395.08084 37.7693582424224 -122.436754890829 (37.7693582424224, -122.436754890829) 15 5 5 29492 9
67293 62515 Permitted Site 7 Schinus molle :: California Pepper 91 4229 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22695 6001411.06683037 2103335.42666413 37.7554378453979 -122.43808520078 (37.7554378453979, -122.43808520078) 2 4 5 28862 22
70122 239595 DPW Maintained 1 Schinus molle :: California Pepper 91 4131 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002300.0276 2102351.40526 37.7527864737179 -122.434940536483 (37.7527864737179, -122.434940536483) 2 4 5 28862 22
70184 50941 Permitted Site 7 Schinus molle :: California Pepper 91 871 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47603 6003770.24487259 2103216.54935313 37.7552453228177 -122.429917964884 (37.7552453228177, -122.429917964884) 2 4 5 28862 22
71031 239642 DPW Maintained 1 Schinus molle :: California Pepper 91 37 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003350.6343 2105630.89155 37.7618507577148 -122.431541455278 (37.7618507577148, -122.431541455278) 15 4 5 28862 3
71330 42296 Permitted Site 7 Schinus molle :: California Pepper 91 250 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 7 4x5 Permit Number 42524 5999448.10009127 2093930.90110115 37.7295034375942 -122.444197952384 (37.7295034375942, -122.444197952384) 9 7 4 63 40
73495 239599 DPW Maintained 1 Schinus molle :: California Pepper 91 1627 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003378.62695 2098678.67199 37.7427631886738 -122.430948447709 (37.7427631886738, -122.430948447709) 2 7 5 63 22
75500 32955 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
75526 108931 Undocumented 4 Schinus molle :: California Pepper 91 1099x NATOMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2 Permit Number 774500 6007500 2109279 37.772101916333 -122.417448958018 (37.772101916333, -122.417448958018) 8 2 9 28853 19
76751 49937 DPW Maintained 1 Schinus molle :: California Pepper 91 2591 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2003 12:00:00 AM 4   Permit Number 46696 5988296.2269 2097703.198 37.7392186595719 -122.483026991295 (37.7392186595719, -122.483026991295) 1 8 3 29491 35
76756 239659 DPW Maintained 1 Schinus molle :: California Pepper 91 155 States St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6001303.69127 2106216.90984 37.7633435891615 -122.438662997693 (37.7633435891615, -122.438662997693) 15 5 5 28862 3
77030 239621 DPW Maintained 1 Schinus molle :: California Pepper 91 489 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 3ft   6001854.41167 2103000.82295 37.7545443074853 -122.436528033262 (37.7545443074853, -122.436528033262) 2 4 5 28862 22
77871 214162 DPW Maintained 1 Schinus molle :: California Pepper 91 56 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5995350.86908 2090273.63849 37.7192268694992 -122.458097813856 (37.7192268694992, -122.458097813856) 9 8 6 28861 24
78868 239576 DPW Maintained 1 Schinus molle :: California Pepper 91 3971 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004073.25036 2100697.787 37.7483465459652 -122.428690539642 (37.7483465459652, -122.428690539642) 2 4 5 63 22
79145 62516 Permitted Site 7 Schinus molle :: California Pepper 91 4239 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1986 12:00:00 AM   3x3 Permit Number 52133 6001380.62959357 2103332.31744832 37.7554275771996 -122.438190239105 (37.7554275771996, -122.438190239105) 2 4 5 28862 22
80743 247658 DPW Maintained 1 Schinus molle :: California Pepper 91 129 Divisadero St 1 : Tree Private 2     10 Width 3ft   6001895.26535 2108435.04385 37.7694676755344 -122.436775732636 (37.7694676755344, -122.436775732636) 15 5 5 29492 9
81470 61782 Permitted Site 7 Schinus molle :: California Pepper 91 2107 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1985 12:00:00 AM 20   Permit Number 21804 6012179.15182 2102325.12749 37.7532702936903 -122.400774668711 (37.7532702936903, -122.400774668711) 10 3 8 28856 29
81568 239652 DPW Maintained 1 Schinus molle :: California Pepper 91 759 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002456.72459 2103769.12094 37.7566880780974 -122.434500008993 (37.7566880780974, -122.434500008993) 2 4 5 28862 3
81834 239609 DPW Maintained 1 Schinus molle :: California Pepper 91 98 Winfield St 1 Sidewalk: Curb side : Pot Tree Private 2     25 Width 3ft   6007121.02113 2098861.91271 37.7434776667546 -122.41802126889 (37.7434776667546, -122.41802126889) 2 7 7 28859 2
82801 239584 DPW Maintained 1 Schinus molle :: California Pepper 91 863 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5998665.55754 2107188.82134 37.7658617826328 -122.447857378524 (37.7658617826328, -122.447857378524) 15 5 11 29492 9
83160 239664 DPW Maintained 1 Schinus molle :: California Pepper 91 1140 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6002488.98028 2102184.88968 37.7523399882133 -122.434275200945 (37.7523399882133, -122.434275200945) 2 4 5 28862 22
84224 239582 DPW Maintained 1 Schinus molle :: California Pepper 91 43 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5998416.52248 2107203.63932 37.765888231668 -122.448719802287 (37.765888231668, -122.448719802287) 15 5 11 29492 9
85704 239634 DPW Maintained 1 Schinus molle :: California Pepper 91 871 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003772.61458 2103201.71767 37.7552047327212 -122.429908711835 (37.7552047327212, -122.429908711835) 2 4 5 28862 22
86380 173724 DPW Maintained 1 Schinus molle :: California Pepper 91 1101 Connecticut St 1 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
86523 179423 DPW Maintained 1 Schinus molle :: California Pepper 91 103 Vienna St 1 Sidewalk: Property side : Yard Tree Private 2     18     6004767.82112 2092745.17359 37.7265497503523 -122.425722776001 (37.7265497503523, -122.425722776001) 9 7 6 28861 5
86676 214165 DPW Maintained 1 Schinus molle :: California Pepper 91 428 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5996451.80809 2106977.82649 37.7651556637169 -122.455498978198 (37.7651556637169, -122.455498978198) 15 5 11 29492 12
87765 247489 DPW Maintained 1 Schinus molle :: California Pepper 91 868 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6002408.5917 2109542.1708 37.7725367328675 -122.435079355167 (37.7725367328675, -122.435079355167) 15 5 11 29492 9
89257 33655 DPW Maintained 1 Schinus molle :: California Pepper 91 542 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 22   Permit Number 37744 6004783.29295 2110728.72543 37.775929278336 -122.426949542114 (37.775929278336, -122.426949542114) 7 9 11 28852 10
89326 239635 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003778.26076 2103599.43748 37.7562970969591 -122.429917553956 (37.7562970969591, -122.429917553956) 2 4 5 28862 22
89477 142226 DPW Maintained 1 Schinus molle :: California Pepper 91 542 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6004780.8856 2110726.6251 37.7759233752217 -122.426957720143 (37.7759233752217, -122.426957720143) 7 9 11 28852 10
89962 239567 DPW Maintained 1 Schinus molle :: California Pepper 91 3435 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6006895.64188 2100851.73373 37.7489285791008 -122.418941674643 (37.7489285791008, -122.418941674643) 2 4 7 28859 19
90678 112684 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 1 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
92722 37473 Permitted Site 7 Schinus molle :: California Pepper 91 1453 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44951 5992709.117019 2105576.23529487 37.7610917906482 -122.468341951453 (37.7610917906482, -122.468341951453) 1 8 4 56 12
93453 53873 Permitted Site 7 Schinus molle :: California Pepper 91 3669 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24724 6003927.57680575 2103608.86941248 37.7563314496504 -122.429401840118 (37.7563314496504, -122.429401840118) 2 4 5 28862 22
94142 46335 Permitted Site 7 Schinus molle :: California Pepper 91 3441 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44585 6006853.77058428 2100846.52070985 37.7489119074947 -122.419086096292 (37.7489119074947, -122.419086096292) 2 4 7 28859 19
94236 239572 DPW Maintained 1 Schinus molle :: California Pepper 91 396 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003432.67407 2098660.37482 37.7427160111273 -122.43076026277 (37.7427160111273, -122.43076026277) 2 7 5 63 22
94363 63682 Permitted Site 7 Schinus molle :: California Pepper 91 1366 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 24337 6003879.47043965 2100314.74724677 37.7472838389262 -122.429333315407 (37.7472838389262, -122.429333315407) 2 7 5 63 22
94390 100751 Undocumented 4 Schinus molle :: California Pepper 91 767 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002451 2103738 37.7566023024977 -122.434517581577 (37.7566023024977, -122.434517581577) 2 4 5 28862 3
95974 239591 DPW Maintained 1 Schinus molle :: California Pepper 91 1436 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001977.64645 2099818.19455 37.7458125684911 -122.435874148776 (37.7458125684911, -122.435874148776) 2 7 5 63 22
96303 110276 Permitted Site 7 Schinus molle :: California Pepper 91 3364 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2015 12:00:00 AM 3 5x5 Permit Number 775124 6007285 2101529 37.7508101157283 -122.417643266234 (37.7508101157283, -122.417643266234) 2 4 7 28859 19
96475 63982 Permitted Site 7 Schinus molle :: California Pepper 91 744 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24725 6004289.96903589 2104522.67899109 37.7588610652906 -122.428213684799 (37.7588610652906, -122.428213684799) 2 4 5 28862 3
97929 217735 DPW Maintained 1 Schinus molle :: California Pepper 91 723 Frederick St 1 : Tree Private 2     7 Width 3ft   5996116.65034 2107229.99676 37.7658288206775 -122.456676438985 (37.7658288206775, -122.456676438985) 15 5 11 29492 12
98484 239610 DPW Maintained 1 Schinus molle :: California Pepper 91 342 Prospect Ave 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 3ft   6006341.94877 2097874.88988 37.7407236449682 -122.420645058033 (37.7407236449682, -122.420645058033) 2 7 7 28859 2
98626 104776 Undocumented 4 Schinus molle :: California Pepper 91 767 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6002481.8 2103753.5 37.7566466101352 -122.434412172394 (37.7566466101352, -122.434412172394) 2 4 5 28862 3

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