356 rows where qSpecies_id = 91

View and edit SQL

Suggested facets: qLegalStatus_id, SiteOrder, qCaretaker_id, qCareAssistant, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods (old)

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)
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
888 246022 DPW Maintained 1 Schinus molle :: California Pepper 91 625 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998964.2184 2108548.4801 37.769612128289 -122.446922226392 (37.769612128289, -122.446922226392) 15 5 11 29492 9
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
3344 197494 DPW Maintained 1 Schinus molle :: California Pepper 91 401 Texas St 3 : Tree Private 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
3391 122720 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 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
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
3568 197493 DPW Maintained 1 Schinus molle :: California Pepper 91 950x Kansas St 7 Median : Yard Tree DPW 1     25     6011595.70122 2103803.27065 37.7572963894245 -122.402896325021 (37.7572963894245, -122.402896325021) 10 3 8 28856 29
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
6035 264650 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
6247 20077 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY55 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
6293 97158 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.397943616401 (37.7189762599209, -122.397943616401) 10 3 8 58 1
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
7042 264648 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
7939 264649 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 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
8265 19714 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY13 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
9411 33144 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37370 6001375.34520428 2103384.04824408 37.7555693169237 -122.438212219782 (37.7555693169237, -122.438212219782) 2 4 5 28862 3
9816 32952 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 4 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
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
11161 247593 DPW Maintained 1 Schinus molle :: California Pepper 91 800 Tompkins Ave 14 Front Yard : Yard Tree Private 2     11     6009015.3685 2096434.58029 37.736919178173 -122.411299627995 (37.736919178173, -122.411299627995) 10 7 7 28859 2
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
12625 97159 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.60574 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286) 10 3 8 58 1
12626 97156 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
12994 239597 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 6ft   6003266.18046 2100734.45358 37.7484015143127 -122.431483983218 (37.7484015143127, -122.431483983218) 2 4 5 28862 22
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
13603 239638 DPW Maintained 1 Schinus molle :: California Pepper 91 3689 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003857.31467 2103604.80906 37.7563163226577 -122.429644541356 (37.7563163226577, -122.429644541356) 2 4 5 28862 22
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
15670 19820 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY25 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 10ST                      
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
16158 19973 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
17171 239598 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 6ft   6003265.33612 2100745.73511 37.7484324428976 -122.431487708187 (37.7484324428976, -122.431487708187) 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
18330 97157 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771) 10 3 8 58 1
18353 97155 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.95173 37.7190672497343 -122.398087681509 (37.7190672497343, -122.398087681509) 10 3 8 58 1
18879 19971 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
19961 142238 DPW Maintained 1 Schinus molle :: California Pepper 91 689 HAYES ST 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6004757.5201 2110863.998 37.776299246383 -122.427048334097 (37.776299246383, -122.427048334097) 7 9 11 28852 10
20090 104219 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
20260 197489 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 42 Front Yard : Yard Tree Private 2     8     6015361.30396 2102471.04633 37.753847930956 -122.389780232768 (37.753847930956, -122.389780232768) 10 3 8 28856 29
20349 124365 DPW Maintained 1 Schinus molle :: California Pepper 91 69 Palm Ave 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   5995847.94198 2114000.61223 37.7844037185844 -122.458095888318 (37.7844037185844, -122.458095888318) 11 6 1 54 31
20433 239596 DPW Maintained 1 Schinus molle :: California Pepper 91 1816 Castro St 6 Sidewalk: Property side : Yard Tree Private 2     15     6002590.68382 2100212.92694 37.7469312162962 -122.433782563125 (37.7469312162962, -122.433782563125) 2 7 5 63 22
21141 51696 Permitted Site 7 Schinus molle :: California Pepper 91 4384@ TEMPLE 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2005 12:00:00 AM     Permit Number 47972 6000123.14739521 2105790.85513139 37.7621065191401 -122.442715506918 (37.7621065191401, -122.442715506918) 15 5 5 28862 3
23040 239637 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003808.38299 2103603.27195 37.7563093313217 -122.429813654389 (37.7563093313217, -122.429813654389) 2 4 5 28862 22
23225 239627 DPW Maintained 1 Schinus molle :: California Pepper 91 3885 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002571.81479 2103540.6818 37.7560673714328 -122.434085656222 (37.7560673714328, -122.434085656222) 2 4 5 28862 22
23648 239611 DPW Maintained 1 Schinus molle :: California Pepper 91 230 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6007188.60592 2098802.03139 37.7433170496408 -122.417783333431 (37.7433170496408, -122.417783333431) 2 7 7 28859 2
23853 35615 Permitted Site 7 Schinus molle :: California Pepper 91 42 Walter St 4 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
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
25942 197503 DPW Maintained 1 Schinus molle :: California Pepper 91 1799 25th St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6013488.947 2101929.32561 37.7522564753565 -122.396217358746 (37.7522564753565, -122.396217358746) 10 3 8 28856 1
26202 32764 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37139 5995268.23997636 2113729.87048347 37.7836270090334 -122.460081822154 (37.7836270090334, -122.460081822154) 11 6 2 54 11
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
29837 214153 DPW Maintained 1 Schinus molle :: California Pepper 91 391 Santa Ana Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5992476.67943 2094212.83068 37.7298773579434 -122.46831913414 (37.7298773579434, -122.46831913414) 9 8 4 59 40
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
32012 35755 DPW Maintained 1 Schinus molle :: California Pepper 91 6838 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 7   Permit Number 39022 5985827.97682 2112563.40957 37.7798767531698 -122.49265512383 (37.7798767531698, -122.49265512383) 11 6 2 55 26
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
33437 239641 DPW Maintained 1 Schinus molle :: California Pepper 91 3637 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004113.74882 2103625.61972 37.7563879806327 -122.428759186701 (37.7563879806327, -122.428759186701) 2 4 5 28862 22
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
35161 239594 DPW Maintained 1 Schinus molle :: California Pepper 91 636 Douglass St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6001191.4238 2102669.11785 37.7535958285084 -122.43879704705 (37.7535958285084, -122.43879704705) 2 4 5 28862 22
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
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
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
44499 197504 DPW Maintained 1 Schinus molle :: California Pepper 91 1798 Revere Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12     6014086.53204 2095170.83461 37.733732305508 -122.393677804596 (37.733732305508, -122.393677804596) 10 3 8 58 1
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
46169 197497 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 18 Sidewalk: Property side : Yard Tree Private 2     14     6013599.16401 2103957.68535 37.7578320454303 -122.395978336045 (37.7578320454303, -122.395978336045) 10 3 8 28856 29
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
47859 239656 DPW Maintained 1 Schinus molle :: California Pepper 91 701 Church St 39 Front Yard : Yard Tree Private 2     7 Width 3ft   6004336.93411 2104791.99581 37.759603202641 -122.428070449907 (37.759603202641, -122.428070449907) 2 4 5 28862 3
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
48977 173723 DPW Maintained 1 Schinus molle :: California Pepper 91 1799x 25th St 2 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 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
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
52252 247663 DPW Maintained 1 Schinus molle :: California Pepper 91 108 Divisadero St 2 : Tree Private 2     11 Width 3ft   6001959.36889 2108361.77304 37.7692701349494 -122.436548756347 (37.7692701349494, -122.436548756347) 15 5 5 29492 9
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
53347 239658 DPW Maintained 1 Schinus molle :: California Pepper 91 80 Uranus Ter 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   5999334.19979 2105297.48672 37.7607068452574 -122.445408687374 (37.7607068452574, -122.445408687374) 15 5 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)
);