356 rows where qSpecies_id = 91 sorted by DBH

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
112295 63956 Permitted Site 7 Schinus molle :: California Pepper 91 4232 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/1992 12:00:00 AM       6002352.24062254 2101234.22323777 37.7497219215876 -122.434680095003 (37.7497219215876, -122.434680095003) 2 4 5 28862 22
117522 45371 Permitted Site 7 Schinus molle :: California Pepper 91 165 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 49668 6001878.15662511 2108576.11606242 37.7698540525754 -122.436845011254 (37.7698540525754, -122.436845011254) 15 5 5 29492 9
121062 46566 Permitted Site 7 Schinus molle :: California Pepper 91 3900 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2002 12:00:00 AM     Permit Number 44701 6002455.82917315 2102994.91492425 37.7545622428397 -122.434447752947 (37.7545622428397, -122.434447752947) 2 4 5 28862 22
122621 33145 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/09/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
125492 119663 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 4 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
132843 119662 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 3 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
132958 32950 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 6 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
136995 46069 Permitted Site 7 Schinus molle :: California Pepper 91 3746 21st St 2 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
138709 52003 Permitted Site 7 Schinus molle :: California Pepper 91 375 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/2005 12:00:00 AM     Permit Number 48220 6004122.23435698 2098354.44856915 37.7419150515767 -122.428354161004 (37.7419150515767, -122.428354161004) 2 7 5 63 7
145663 119666 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 7 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
148145 119668 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 9 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
148538 66525 Permitted Site 7 Schinus molle :: California Pepper 91 4121 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29699 6002362.5628629 2102351.70560046 37.7527908488566 -122.434724299907 (37.7527908488566, -122.434724299907) 2 4 5 28862 22
148800 84811 Permitted Site 7 Schinus molle :: California Pepper 91 654 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2007 12:00:00 AM     Permit No. 49280 5997579.9 2108309.3 37.7688762175244 -122.451693255762 (37.7688762175244, -122.451693255762) 15 5 11 29492 9
149656 40810 Permitted Site 7 Schinus molle :: California Pepper 91 240 Maywood Dr 3 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
156347 63010 Permitted Site 7 Schinus molle :: California Pepper 91 9 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1986 12:00:00 AM     Permit Number 23424 6007395.1381387 2098224.27155142 37.7417422703287 -122.417028268249 (37.7417422703287, -122.417028268249) 2 7 7 28859 2
156673 63979 Permitted Site 7 Schinus molle :: California Pepper 91 801 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24719 6003748.05431866 2103616.18796413 37.7563413791419 -122.430023213091 (37.7563413791419, -122.430023213091) 2 4 5 28862 22
158396 115363 Undocumented 4 Schinus molle :: California Pepper 91 1709 REVERE AVE 1 Front Yard : Yard Tree Private 2           6014548 2094736 37.7325639703463 -122.392051962294 (37.7325639703463, -122.392051962294) 10 3 8 58 1
158555 104220 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
158691 112685 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 2 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
159315 32765 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 1 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
159589 51810 Permitted Site 7 Schinus molle :: California Pepper 91 4432 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2005 12:00:00 AM     Permit Number 48056 6001326.40602228 2104686.21381833 37.7591419642331 -122.43847475852 (37.7591419642331, -122.43847475852) 2 4 5 28862 3
162055 99797 Undocumented 4 Schinus molle :: California Pepper 91 703-705 Elizabeth St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
164036 46334 Permitted Site 7 Schinus molle :: California Pepper 91 3776 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44584 6005338.11992395 2101398.90311865 37.7503431540329 -122.424366507573 (37.7503431540329, -122.424366507573) 2 4 5 28859 19
167969 41655 Permitted Site 7 Schinus molle :: California Pepper 91 112 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2000 12:00:00 AM     Permit Number 42124 6001962.23129662 2108338.50531125 37.7692064101731 -122.436537189813 (37.7692064101731, -122.436537189813) 15 5 5 29492 9
168602 62517 Permitted Site 7 Schinus molle :: California Pepper 91 4315 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22698 6001100.3292402 2103290.9987582 37.7552981802714 -122.439156639775 (37.7552981802714, -122.439156639775) 2 4 5 28862 22
169069 112686 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 3 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
172414 256223 Property Tree 8 Schinus molle :: California Pepper 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree Rec/Park 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
172673 32951 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 5 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
173467 35617 Permitted Site 7 Schinus molle :: California Pepper 91 42 Walter St 3 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
178192 64253 Permitted Site 7 Schinus molle :: California Pepper 91 238 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/1988 12:00:00 AM     Permit Number 25052 6004384.37597616 2098713.60490953 37.7429160426191 -122.427473340495 (37.7429160426191, -122.427473340495) 2 7 5 63 22
180003 119664 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 5 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
184088 108112 Permitted Site 7 Schinus molle :: California Pepper 91 690 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003299.11292 2109682.74913 37.7729732522628 -122.432008994211 (37.7729732522628, -122.432008994211) 15 9 11 29492 10
185477 52692 Permitted Site 7 Schinus molle :: California Pepper 91 4362ON CASTRO 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/30/2006 12:00:00 AM     Permit Number 48760 6000868.9362336 2103304.07672076 37.755320919647 -122.439957801702 (37.755320919647, -122.439957801702) 2 4 5 28862 38
189872 60508 Permitted Site 7 Schinus molle :: California Pepper 91 282 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM   3x3 Permit Number 24310 6004065.51901322 2099574.2006491 37.7452610006153 -122.428637192649 (37.7452610006153, -122.428637192649) 2 7 5 63 22
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
159362 68308 DPW Maintained 1 Schinus molle :: California Pepper 91 2178 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 0   Permit Number 32119 5981736.58109187 2100266.85539552 37.7458738657157 -122.505896923616 (37.7458738657157, -122.505896923616) 1 8 3 29491 35
115227 239665 DPW Maintained 1 Schinus molle :: California Pepper 91 3977 22nd St 7 : Tree Private 2     1     6001970.62949 2102924.44279 37.7543411893077 -122.436120656556 (37.7543411893077, -122.436120656556) 2 4 5 28862 22
128125 197491 DPW Maintained 1 Schinus molle :: California Pepper 91 900x Carolina St 23 Median : Yard Tree DPW 1     1     6012477.42612 2103497.47149 37.7565059267156 -122.399825482885 (37.7565059267156, -122.399825482885) 10 3 8 28856 29
162473 239604 DPW Maintained 1 Schinus molle :: California Pepper 91 3980 22nd St 1 : Tree Private 2     1     6001965.58933 2102953.14284 37.7544197064144 -122.436140140357 (37.7544197064144, -122.436140140357) 2 4 5 28862 22
194508 203796 DPW Maintained 1 Schinus molle :: California Pepper 91 460 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993728.30174 2101878.83793 37.7509985054805 -122.464548580761 (37.7509985054805, -122.464548580761) 1 8 4 29491 12
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
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
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
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
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
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
109460 122117 DPW Maintained 1 Schinus molle :: California Pepper 91 141 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5990819.37104 2114444.89613 37.7853333844834 -122.475525275427 (37.7853333844834, -122.475525275427) 11 6 2 54 26
125113 214170 DPW Maintained 1 Schinus molle :: California Pepper 91 158 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5999431.23761 2093723.53638 37.7289331003841 -122.444241352082 (37.7289331003841, -122.444241352082) 9 7 4 63 40
130978 20249 DPW Maintained 1 Schinus molle :: California Pepper 91 1880 Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2000 12:00:00 AM 10 3X3   6002546.9119 2114591.5393 37.7864088846335 -122.43496207541 (37.7864088846335, -122.43496207541) 13 9 11 29490 27
136874 136371 DPW Maintained 1 Schinus molle :: California Pepper 91 3518 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002669.28578 2120724.92735 37.8032565295236 -122.434977502225 (37.8032565295236, -122.434977502225) 13 9 1 57 17
137756 239587 DPW Maintained 1 Schinus molle :: California Pepper 91 105 Elsie St 1 Sidewalk: Curb side : Pot Tree Private 2     10 Width 5ft   6007266.87289 2098693.35025 37.7430230396951 -122.417505004957 (37.7430230396951, -122.417505004957) 2 7 7 28859 2

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