trees

356 rows where qSpecies_id = 91 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
33717 99818 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
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
34897 136370 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6000983.74683 2118556.26599 37.7972061120278 -122.440654703763 (37.7972061120278, -122.440654703763) 13 9 1 57 17
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
35370 35616 Permitted Site 7 Schinus molle :: California Pepper 91 42 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1998 12:00:00 AM     Permit Number 38971 6003128.23907612 2108063.84146095 37.7685184402848 -122.432484413704 (37.7685184402848, -122.432484413704) 15 5 5 28862 3
36387 251333 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007705.96721 2102462.31706 37.7533964721949 -122.416253615419 (37.7533964721949, -122.416253615419) 2 4 7 28859 19
36540 49625 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM 6   Permit Number 768701 6007969.67353 2109667.22612 37.773194308705 -122.415851810006 (37.773194308705, -122.415851810006) 8 2 9 28853 19
36697 33682 DPW Maintained 1 Schinus molle :: California Pepper 91 417 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 8   Permit Number 37761 6005332.3776 2111131.0936 37.7770651154691 -122.425078750067 (37.7770651154691, -122.425078750067) 7 9 11 28852 10
37249 35756 DPW Maintained 1 Schinus molle :: California Pepper 91 6838 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 8   Permit Number 39022 5985797.58958 2112563.51135 37.7798752557854 -122.492760252761 (37.7798752557854, -122.492760252761) 11 6 2 55 26
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
40104 156622 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007708.67537 2102405.47581 37.7532405513196 -122.416240224501 (37.7532405513196, -122.416240224501) 2 4 7 28859 19
40288 239571 DPW Maintained 1 Schinus molle :: California Pepper 91 254 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2     33 Width 3ft   6004273.21361 2098704.8278 37.742885654747 -122.427857083959 (37.742885654747, -122.427857083959) 2 7 5 63 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
43385 136376 DPW Maintained 1 Schinus molle :: California Pepper 91 2880 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5999781.6675 2117438.62155 37.7940688297731 -122.444733809114 (37.7940688297731, -122.444733809114) 13 9 1 57 27
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
44107 111384 DPW Maintained 1 Schinus molle :: California Pepper 91 340 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6014593.21542 2112428.75748 37.7811469919725 -122.393133189548 (37.7811469919725, -122.393133189548) 6 2 9 28856 6
46065 136368 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000986.41607 2118529.18744 37.797131913463 -122.440643524276 (37.797131913463, -122.440643524276) 13 9 1 57 17
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
49320 32953 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 3 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
51033 12258 DPW Maintained 1 Schinus molle :: California Pepper 91 601 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004950.99275 2110977.71573 37.7766224258639 -122.426387156922 (37.7766224258639, -122.426387156922) 7 9 11 28852 10
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
54324 239588 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6007705.96721 2102462.31706 37.7533964721949 -122.416253615419 (37.7533964721949, -122.416253615419) 2 4 7 28859 19
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
59175 46762 Permitted Site 7 Schinus molle :: California Pepper 91 220 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM 14 6x5 Permit Number 44860 6007156.68652731 2098808.76351871 37.7433337382313 -122.417894179823 (37.7433337382313, -122.417894179823) 2 7 7 28859 2
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
59453 49620 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/30/2008 12:00:00 AM 5 3x3 Permit Number 768701 6007925.38179 2109711.75094 37.7733140732115 -122.416008175135 (37.7733140732115, -122.416008175135) 8 2 9 28853 19
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
61318 136374 DPW Maintained 1 Schinus molle :: California Pepper 91 2858 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5999876.11536 2117451.30478 37.7941090438496 -122.444407922699 (37.7941090438496, -122.444407922699) 13 9 1 57 27
63400 242003 DPW Maintained 1 Schinus molle :: California Pepper 91 920 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007974.01021 2102435.99237 37.7533392591026 -122.415324800104 (37.7533392591026, -122.415324800104) 2 4 7 28859 19
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
63489 113030 Undocumented 4 Schinus molle :: California Pepper 91 200x ESMERALDA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     10 9x9   6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
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
63916 239643 DPW Maintained 1 Schinus molle :: California Pepper 91 37 Ford St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003364.63638 2105630.60252 37.7618507577208 -122.431493007021 (37.7618507577208, -122.431493007021) 15 4 5 28862 3
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
70623 138859 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6004948.1933 2110978.3343 37.7766239660594 -122.426396885095 (37.7766239660594, -122.426396885095) 7 9 11 28852 10
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
73636 136377 DPW Maintained 1 Schinus molle :: California Pepper 91 633 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009222.09013 2115205.65792 37.7884718549403 -122.41191097002 (37.7884718549403, -122.41191097002) 5 1 10 28852 21
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
81055 239662 DPW Maintained 1 Schinus molle :: California Pepper 91 1128 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002485.47315 2102221.41113 37.7524400683713 -122.434289939928 (37.7524400683713, -122.434289939928) 2 4 5 28862 22
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
82754 239645 DPW Maintained 1 Schinus molle :: California Pepper 91 4 Ford St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003486.01122 2105681.39131 37.7619970900117 -122.431076844836 (37.7619970900117, -122.431076844836) 15 4 5 28862 3
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
83952 109126 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 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
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
91095 197506 DPW Maintained 1 Schinus molle :: California Pepper 91 1079 Le Conte Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012767.16405 2089807.75284 37.7189329737454 -122.397863208018 (37.7189329737454, -122.397863208018) 10 3 8 58 1
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
95494 136372 DPW Maintained 1 Schinus molle :: California Pepper 91 2005 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5999418.04323 2115732.63691 37.7893638888782 -122.445869229291 (37.7893638888782, -122.445869229291) 13 6 1 29490 31
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
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
98903 239612 DPW Maintained 1 Schinus molle :: California Pepper 91 220 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007237.85888 2098768.99356 37.7432291067493 -122.417610687906 (37.7432291067493, -122.417610687906) 2 7 7 28859 2
98928 136366 DPW Maintained 1 Schinus molle :: California Pepper 91 2323 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001763.72183 2119055.52403 37.7986213292711 -122.437991580064 (37.7986213292711, -122.437991580064) 13 9 1 57 17
99586 117533 Undocumented 4 Schinus molle :: California Pepper 91 870 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002404 2109622 37.7727556633357 -122.435100948925 (37.7727556633357, -122.435100948925) 15 5 11 29492 9
99960 239625 DPW Maintained 1 Schinus molle :: California Pepper 91 811 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002472.06672 2103464.35538 37.7558521357906 -122.434425161094 (37.7558521357906, -122.434425161094) 2 4 5 28862 22
99964 97673 Permitted Site 7 Schinus molle :: California Pepper 91 547 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003039 2098885 37.7433104678167 -122.43213751159 (37.7433104678167, -122.43213751159) 2 7 5 63 22
100553 100750 Undocumented 4 Schinus molle :: California Pepper 91 757 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002448 2103795 37.7567586405263 -122.434532032094 (37.7567586405263, -122.434532032094) 2 4 5 28862 3
101688 50158 DPW Maintained 1 Schinus molle :: California Pepper 91 1863@ ORTEGA 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2003 12:00:00 AM 4   Permit Number 46871 5985958.4054 2102559.7986 37.7524172606528 -122.491467392102 (37.7524172606528, -122.491467392102) 1 8 3 56 35
103494 239624 DPW Maintained 1 Schinus molle :: California Pepper 91 817 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002470.85858 2103435.32507 37.7557723569304 -122.434427263721 (37.7557723569304, -122.434427263721) 2 4 5 28862 22
103771 62518 Permitted Site 7 Schinus molle :: California Pepper 91 4367 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22700 6000826.50003313 2103245.32733573 37.7551571922749 -122.440100345908 (37.7551571922749, -122.440100345908) 2 4 5 28862 22
104806 12260 DPW Maintained 1 Schinus molle :: California Pepper 91 611 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6004921 2111005 37.7766956463335 -122.426492853872 (37.7766956463335, -122.426492853872) 7 9 11 28852 10
104997 245452 DPW Maintained 1 Schinus molle :: California Pepper 91 2700 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6008618.5823 2106848.9813 37.7654925250272 -122.413407794567 (37.7654925250272, -122.413407794567) 8 4 7 28853 19
105314 239626 DPW Maintained 1 Schinus molle :: California Pepper 91 3885 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002499.39714 2103536.73091 37.7560524130043 -122.434335817949 (37.7560524130043, -122.434335817949) 2 4 5 28862 22
107727 136369 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6000984.79842 2118544.66291 37.7971743129098 -122.440650232318 (37.7971743129098, -122.440650232318) 13 9 1 57 17

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