356 rows where qSpecies_id = 91 sorted by PermitNotes

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)
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
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                      
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
8265 19714 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY13 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
54807 136367 DPW Maintained 1 Schinus molle :: California Pepper 91 689 Hayes St 5 : Tree Private 2     16 Width 3ft   6004762.56149 2110859.02755 37.7762858838177 -122.427030540428 (37.7762858838177, -122.427030540428) 7 9 11 28852 10
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
56212 197490 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 43 Front Yard : Yard Tree Private 2     13     6015358.4418 2102466.66646 37.7538357460423 -122.38978982496 (37.7538357460423, -122.38978982496) 10 3 8 28856 29
58030 197487 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 28 Front Yard : Yard Tree Private 2     11     6015378.84744 2102468.94598 37.7538431366753 -122.389719416144 (37.7538431366753, -122.389719416144) 10 3 8 28856 29
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
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
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
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
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
62891 214155 DPW Maintained 1 Schinus molle :: California Pepper 91 495 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5993543.01566 2101855.50119 37.7509237457529 -122.46518761832 (37.7509237457529, -122.46518761832) 1 8 4 29491 40
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
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
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
65868 197492 DPW Maintained 1 Schinus molle :: California Pepper 91 1501 25th St 20 Sidewalk: Curb side : Yard Tree Private 2     7     6014180.0421 2101964.05724 37.7523902711102 -122.393829855665 (37.7523902711102, -122.393829855665) 10 3 8 28856 1
67494 197496 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 17 Sidewalk: Property side : Yard Tree Private 2     11     6013599.60524 2103941.4739 37.7577875568584 -122.395975674052 (37.7577875568584, -122.395975674052) 10 3 8 28856 29
68839 119665 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 6 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
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
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
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
74800 214156 DPW Maintained 1 Schinus molle :: California Pepper 91 495 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   5993555.55486 2101853.98601 37.7509203085364 -122.465144146879 (37.7509203085364, -122.465144146879) 1 8 4 29491 40
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
78357 197485 DPW Maintained 1 Schinus molle :: California Pepper 91 15 Lafayette St 2 : Tree Private 2     13 Width 3ft   6007471.02195 2109700.81958 37.773258502312 -122.417579097413 (37.773258502312, -122.417579097413) 8 2 9 28853 19
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
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
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
81419 136381 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   6008695.6423 2118278.07408 37.7968784080765 -122.413949834731 (37.7968784080765, -122.413949834731) 5 1 10 308 21
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
82256 197486 DPW Maintained 1 Schinus molle :: California Pepper 91 1112 Tennessee St 2 Sidewalk: Curb side : Pot Tree Private 2     19 Width 6ft   6015516.35006 2103817.53146 37.7575536899561 -122.389338063096 (37.7575536899561, -122.389338063096) 10 3 8 28856 29

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