Street_Tree_List

Data source: data.sfgov.org

970 rows where qSpecies = 75

View and edit SQL

Suggested facets: qSiteInfo, PlantType, qCaretaker, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
334 246360 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1932 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6006755.8259 2107130.7038 37.76616130474321 -122.419870652653 (37.7661613047432, -122.419870652653)
602 15498 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2704 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007015.1629 2102569.9783 37.7536532168709 -122.41865020170799 (37.7536532168709, -122.418650201708)
988 199496 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 87 06th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 Width 4ft   6010015.0817 2112492.094 37.781065511609604 -122.40897579419399 (37.7810655116096, -122.408975794194)
1512 243955 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 80 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007056.3814199995 2109908.18867 37.773804548164705 -122.419028109365 (37.7738045481647, -122.419028109365)
1514 243952 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007022.68787 2110044.22077 37.7741761624211 -122.41915431212601 (37.7741761624211, -122.419154312126)
1515 243950 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 13 Width 5ft Permit Number 47529 6007004.81099 2110130.42285 37.774411845966895 -122.419222267617 (37.7744118459669, -122.419222267617)
1516 243951 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007014.66541 2110083.11128 37.774282494675795 -122.419184822535 (37.7742824946758, -122.419184822535)
1518 243948 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 11 Width 5ft Permit Number 47529 6006987.09759 2110205.04369 37.774615739356705 -122.41928883630399 (37.7746157393567, -122.419288836304)
1519 243949 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 12 Width 5ft Permit Number 47529 6006997.017419999 2110160.92453 37.7744951573695 -122.41925139124399 (37.7744951573695, -122.419251391244)
1521 243954 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007048.80869 2109949.46518 37.773917457170796 -122.41905723302 (37.7739174571708, -122.41905723302)
1533 243953 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007037.92355 2109985.61989 37.7740161163944 -122.41909745161301 (37.7740161163944, -122.419097451613)
1601 102430 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.779496235110706 -122.407028471514 (37.7794962351107, -122.407028471514)
1602 102429 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.40707656363399 (37.7795357369219, -122.407076563634)
1634 199504 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342)
1642 199503 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.983080001 2111924.50305 37.7795342467397 -122.40725478770099 (37.7795342467397, -122.407254787701)
1932 252826 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 5 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1933 252830 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 9 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 3 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 6 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
2846 253262 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2853 253248 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2856 253264 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2868 253247 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2897 253249 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
3732 15513 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2763 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6007075.5942 2102308.8178 37.7529395319689 -122.41842269980101 (37.7529395319689, -122.418422699801)
4287 181059 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 5810 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 03:37:00 PM 3 Width 3ft   5997243.54219 2086644.28205 37.7093700633606 -122.451293980329 (37.7093700633606, -122.451293980329)
4970 253749 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 2x Rhode Island St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5020 253748 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 2x Rhode Island St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
6773 45307 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 561 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/25/2005 12:00:00 AM 20 5x5 Permit Number 44145 6000554.5197 2110946.4965 37.7762872030081 -122.44159355669599 (37.7762872030081, -122.441593556696)
9740 173671 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 299x Beale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9752 173678 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 299x Beale St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
10174 173886 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 2931 20th St 1 Front Yard : Yard 7 Tree 1 Private 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10190 173887 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 2931 20th St 2 Front Yard : Yard 7 Tree 1 Private 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10322 15786 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 4840 Mission St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/04/2013 12:00:00 AM 12 3x3   6001077.7653 2090502.844 37.7201836118857 -122.43831855702 (37.7201836118857, -122.43831855702)
10337 1859 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     18 6   6010721.136519999 2086497.1887700001 37.7097286779125 -122.404702624138 (37.7097286779125, -122.404702624138)
10427 28552 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4839 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6001308.3124 2090760.3284 37.7209037164668 -122.437540063841 (37.7209037164668, -122.437540063841)
10432 28549 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4963 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6000879.9631 2090072.8632 37.71899172902071 -122.438971492831 (37.7189917290207, -122.438971492831)
10435 28548 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 5095 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6000516.105 2089501.9034 37.7174032930481 -122.440188283496 (37.7174032930481, -122.440188283496)
10445 24508 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 5088 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1995 12:00:00 AM 3 3X3   6000357.2418 2089366.5868 37.717022698354604 -122.440727697577 (37.7170226983546, -122.440727697577)
10446 1841 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6011283.06964 2087344.7309400002 37.712087250691 -122.40282003911301 (37.712087250691, -122.402820039113)
10447 28554 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4753 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6001590.7646 2091209.3547 37.722152696500004 -122.436595837081 (37.7221526965, -122.436595837081)
10497 28546 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 5125 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6000380.5163 2089281.6434 37.716790788359795 -122.440641159733 (37.7167907883598, -122.440641159733)
10503 15772 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4769 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2007 12:00:00 AM 3 3x3   6001557.6417 2091157.3044 37.722007895755794 -122.436706610694 (37.7220078957558, -122.436706610694)
10560 95252 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 4539 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002365.436000001 2092436.2557 37.7255654834992 -122.434005647145 (37.7255654834992, -122.434005647145)
10709 28542 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 5036 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/08/2003 12:00:00 AM 12 3X3   6000555.9648 2089678.6918 37.7178909833984 -122.44006317666401 (37.7178909833984, -122.440063176664)
10723 1798 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 6 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12 6   6012206.26499 2088043.30695 37.714056906280604 -122.39967820720899 (37.7140569062806, -122.399678207209)
10771 28544 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 5060 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/08/2003 12:00:00 AM 12 3X3   6000449.8979 2089508.0094 37.7174162891529 -122.440417567822 (37.7174162891529, -122.440417567822)
10773 28540 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4754 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001487.6438 2091153.5571 37.7219936282262 -122.43694830738701 (37.7219936282262, -122.436948307387)
10981 1860 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2     6 6   6010703.231369999 2086455.7019 37.709613762523205 -122.404761589082 (37.7096137625232, -122.404761589082)
11001 15823 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 5051 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/08/2003 12:00:00 AM 12 3x3   6000607.6416 2089644.9294 37.717801221251 -122.439882133799 (37.717801221251, -122.439882133799)
11110 28537 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4716 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001661.0091 2091431.1044 37.7227655627881 -122.436368881923 (37.7227655627881, -122.436368881923)
11123 28555 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4743 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001652.2787 2091307.3716 37.722425324335 -122.436390209739 (37.722425324335, -122.436390209739)
11132 1820 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2   12/30/1991 12:00:00 AM 3 6   6011846.03792 2087600.59079 37.7128212089973 -122.400892211026 (37.7128212089973, -122.400892211026)
11137 28558 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4667 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001923.346 2091737.9699 37.723623049111296 -122.435483982262 (37.7236230491113, -122.435483982262)
11170 1796 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2     12 6   6012245.53967 2088092.97358 37.714195470207 -122.39954594300899 (37.714195470207, -122.399545943009)
11198 28556 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4717 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001738.1279 2091443.2433 37.7228032751332 -122.436103167424 (37.7228032751332, -122.436103167424)
11231 16408 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1186X Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     42 TR   6001104.60764 2087178.31507 37.7110567247495 -122.43798776335 (37.7110567247495, -122.43798776335)
11318 27101 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 675 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 3X3   6005857.71837 2093582.84449 37.7289113394736 -122.42201451865101 (37.7289113394736, -122.422014518651)
11400 1858 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6010736.7682300005 2086529.19155 37.709817424799 -122.404650849269 (37.709817424799, -122.404650849269)
11469 28551 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4885 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001150.501 2090506.6381 37.720198166433896 -122.438067406183 (37.7201981664339, -122.438067406183)
11493 15784 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 4840 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/02/2015 02:53:00 PM 3 3X3   6001135.2157 2090596.8347 37.7204449566644 -122.438126700052 (37.7204449566644, -122.438126700052)
11503 27099 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 681 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 2X2   6005896.77811 2093584.4181099997 37.7289178631699 -122.421879597869 (37.7289178631699, -122.421879597869)
11567 1857 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6010751.52595 2086559.13987 37.7099004816803 -122.404601950438 (37.7099004816803, -122.404601950438)
11580 1821 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2   12/30/1991 12:00:00 AM 6 6   6011817.461569999 2087571.87835 37.712740776339295 -122.400988964593 (37.7127407763393, -122.400988964593)
11630 1793 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6012296.32723 2088174.84774 37.7144231111167 -122.399376144697 (37.7144231111167, -122.399376144697)
11710 1795 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6012264.68095 2088118.8470599998 37.714267580549105 -122.399481598293 (37.7142675805491, -122.399481598293)
11757 15734 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4476 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1995 12:00:00 AM 3 3X3   6002423.6538 2092643.0339 37.726136553633395 -122.43381916618 (37.7261365536334, -122.43381916618)
11802 28539 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4734 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6001578.802999999 2091300.8769999999 37.7224033163499 -122.436643733228 (37.7224033163499, -122.436643733228)
11934 1822 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6011791.38112 2087549.257 37.7126772077525 -122.401077519005 (37.7126772077525, -122.401077519005)
11995 15738 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4516 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM 12 3X3   6002290.9845 2092433.856 37.725554668943204 -122.434262847922 (37.7255546689432, -122.434262847922)
12072 28800 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4505 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002480.3523 2092620.1218 37.7260768594239 -122.433621526187 (37.7260768594239, -122.433621526187)
12148 15777 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4826 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2013 12:00:00 AM 14 3X3   6001241.8395 2090763.6886 37.7209091632567 -122.43777008073401 (37.7209091632567, -122.437770080734)
12160 1842 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     6 6   6011254.373459999 2087325.01114 37.7120315017345 -122.402917835889 (37.7120315017345, -122.402917835889)
12292 1840 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6011305.78262 2087356.70002 37.7121213835762 -122.40274237725401 (37.7121213835762, -122.402742377254)
12396 15742 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4534 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/1999 12:00:00 AM 12 3X3   6002267.3808 2092395.6017 37.725448291506204 -122.43434171007601 (37.7254482915062, -122.434341710076)
12407 28550 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4919 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3X3   6001014.7517 2090296.9851 37.7196147854688 -122.438521631633 (37.7196147854688, -122.438521631633)
12846 15741 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4531 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2000 12:00:00 AM 12 3x3   6002397.2069 2092488.3059999999 37.7257102048968 -122.433899536724 (37.7257102048968, -122.433899536724)
12880 28799 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4575 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6002251.5336 2092256.7834 37.7250662282166 -122.434386571875 (37.7250662282166, -122.434386571875)
12884 15778 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4830 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 15 3x3   6001221.4914 2090732.7596 37.7208230821415 -122.437838203744 (37.7208230821415, -122.437838203744)
13033 15743 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4545 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2001 12:00:00 AM 12 3x3   6002337.7208 2092395.6969 37.7254525452522 -122.434098558087 (37.7254525452522, -122.434098558087)
13075 15809 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4971 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 16 3x3   6000847.9253 2090031.6718 37.7188768038041 -122.43907928418501 (37.7188768038041, -122.439079284185)
13119 28560 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4631 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6002010.8853 2091868.7717 37.7239871728 -122.43519072585501 (37.7239871728, -122.435190725855)
13149 28547 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 5109 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 12 3x3   6000411.4099 2089335.4212 37.7169402093066 -122.44053823097799 (37.7169402093066, -122.440538230978)
13185 98922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2507 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 6x6   5989831.2863 2098268.2421 37.7408593296697 -122.47776079641599 (37.7408593296697, -122.477760796416)
13194 28543 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 5050 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2003 12:00:00 AM 14 3X3   6000463.3087 2089534.8309 37.717490698541106 -122.44037313550601 (37.7174906985411, -122.440373135506)
13232 1794 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6012280.2141 2088145.3083400002 37.7143411037303 -122.399429765893 (37.7143411037303, -122.399429765893)
13652 21866 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015620.2045 2106919.86703 37.766077793471396 -122.38919550889099 (37.7660777934714, -122.389195508891)
13825 21872 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015641.71858 2106711.03714 37.7655055845439 -122.38910651286601 (37.7655055845439, -122.389106512866)
13833 95855 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 185 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6010497.41028 2112077.91159 37.7799552706525 -122.407277965014 (37.7799552706525, -122.407277965014)
13848 21865 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015619.46662 2106949.47478 37.7661590490173 -122.38920012868601 (37.7661590490173, -122.389200128686)
13867 102421 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 101 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010161.06831 2112431.87946 37.780908353287394 -122.40846650275199 (37.7809083532874, -122.408466502752)
14065 95854 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 185 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6010514.67057 2112059.04775 37.779904440962504 -122.407216923546 (37.7799044409625, -122.407216923546)
14256 102418 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 201 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010625.41098 2111944.3761400003 37.7795957765601 -122.406825737323 (37.7795957765601, -122.406825737323)
14545 21876 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/11/1997 12:00:00 AM 3 3X3   6015645.96934 2106615.37755 37.7652431596794 -122.389085130597 (37.7652431596794, -122.389085130597)
14750 21878 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015649.24797 2106571.51851 37.765122914002205 -122.389070727941 (37.7651229140022, -122.389070727941)
15166 102426 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 100 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010110.9527900005 2112392.33205 37.780796958746 -122.408637087058 (37.780796958746, -122.408637087058)
15167 21867 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/15/2008 12:00:00 AM 3 3X3   6015621.91024 2106888.57721 37.765991972979606 -122.389187423983 (37.7659919729796, -122.389187423983)
15554 21874 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015644.57338 2106657.85439 37.7653597144938 -122.38909292500901 (37.7653597144938, -122.389092925009)
15971 21858 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1830 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/14/2000 12:00:00 AM 6 3X3   6015621.795940001 2107069.76565 37.7664894707397 -122.389200472218 (37.7664894707397, -122.389200472218)
16399 21870 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1900 03rd St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/1995 12:00:00 AM 3 3X3   6015638.72465 2106753.7729 37.765622761707604 -122.38911985249399 (37.7656227617076, -122.389119852494)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 517.426ms · Data source: data.sfgov.org