Street_Tree_List

Data source: data.sfgov.org

704 rows where qCaretaker = 1 and qSpecies = 75

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, DBH, PlotSize

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
16698 102419 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 201 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010609.192559999 2111959.7498 37.7796370815369 -122.40688292791799 (37.7796370815369, -122.406882927918)
16718 102428 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 184 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010438.87034 2112046.078 37.779864586616505 -122.407478236832 (37.7798645866165, -122.407478236832)
17051 15346 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1900 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006752.3955 2107277.3553 37.766563781951106 -122.419892925221 (37.7665637819511, -122.419892925221)
17359 15544 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2831 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007105.1669 2101841.7215 37.7516586567519 -122.418287316619 (37.7516586567519, -122.418287316619)
17504 15470 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2467 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/1992 12:00:00 AM 12 4X4   6006982.3266 2104010.3832 37.757606388854605 -122.418865906959 (37.7576063888546, -122.418865906959)
17590 15399 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2027 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006845.0791 2106513.4435 37.7644714807654 -122.419518145883 (37.7644714807654, -122.419518145883)
17751 15573 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2899 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007123.7446 2101516.8013 37.7507675455055 -122.41820003848999 (37.7507675455055, -122.41820003849)
17764 25281 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1970 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   5993695.8734 2092795.8439 37.726057002173796 -122.464001452223 (37.7260570021738, -122.464001452223)
17840 105162 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1600X OAKDALE AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 5x5   6015006.0 2095503.0 37.734695414582795 -122.390522107646 (37.7346954145828, -122.390522107646)
17971 15480 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2601 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/01/1994 12:00:00 AM 12 4X4   6007030.0978 2103104.2466 37.755121036020604 -122.418636437773 (37.7551210360206, -122.418636437773)
18122 15443 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2230 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6006851.2872 2105349.6458 37.7612763139256 -122.419414104618 (37.7612763139256, -122.419414104618)
18126 15514 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2756 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007024.332 2102304.0728 37.752923617389705 -122.418599638138 (37.7529236173897, -122.418599638138)
18216 24604 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1850 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2004 12:00:00 AM 6 3X3   6006726.6671 2107610.9661 37.7674783489788 -122.420005592363 (37.7674783489788, -122.420005592363)
18617 48631 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1501 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2002 12:00:00 AM     Permit Number 45927 5991498.56479756 2105191.60606182 37.759965706466296 -122.472500646803 (37.7599657064663, -122.472500646803)
18762 15566 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2875 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007116.1618 2101613.8603 37.7510336206374 -122.41823314117799 (37.7510336206374, -122.418233141178)
19149 25280 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1970 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   5993723.9477 2092778.9993 37.7260123689359 -122.46390317969102 (37.7260123689359, -122.463903179691)
19316 15543 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2830 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/1994 12:00:00 AM 18 3X3   6007038.8586 2101864.2983 37.7517169147733 -122.418518220595 (37.7517169147733, -122.418518220595)
19489 15400 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2035 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006850.0111 2106406.7679 37.7641788523727 -122.419493518679 (37.7641788523727, -122.419493518679)
19811 15562 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2869 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007115.4036 2101660.115 37.7511605828473 -122.418239042192 (37.7511605828473, -122.418239042192)
19832 15404 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2040 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006793.6148 2106462.6587 37.764329138697 -122.41969254355601 (37.764329138697, -122.419692543556)
20000 15524 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2779 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6007088.4849 2102183.7027 37.752596720125396 -122.41836925076099 (37.7525967201254, -122.418369250761)
20013 15512 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2749 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007073.3194 2102357.3473 37.753072654833296 -122.418434007286 (37.7530726548333, -122.418434007286)
20065 15349 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1906 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/1993 12:00:00 AM 12 4X4   6006754.9683 2107231.9019 37.7664391225711 -122.419880800641 (37.7664391225711, -122.419880800641)
20108 15398 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2029 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006849.6288 2106465.6722 37.7643405682415 -122.41949902025699 (37.7643405682415, -122.419499020257)
20366 15504 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2729 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007071.0446 2102456.6811 37.7533452746903 -122.418448916916 (37.7533452746903, -122.418448916916)
20420 15557 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2859 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007111.2331 2101709.0236 37.7512946399846 -122.41825693151199 (37.7512946399846, -122.418256931512)
20427 25283 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1970 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   5993582.3286 2092852.6163 37.7262063408999 -122.46439808667 (37.7262063408999, -122.46439808667)
20499 31376 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 634 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/2004 12:00:00 AM 18 3x3 Permit Number 34978 5991167.871719999 2099111.64976 37.7432525889424 -122.47320092310301 (37.7432525889424, -122.473200923103)
20577 15523 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2777 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007081.6604 2102211.0006 37.7526712897583 -122.418394786513 (37.7526712897583, -122.418394786513)
20675 15518 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2765 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007077.869 2102263.3214 37.752814737300604 -122.418411607402 (37.7528147373006, -122.418411607402)
20677 15503 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2721 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007064.9784 2102504.4523 37.7534761019861 -122.418473282249 (37.7534761019861, -122.418473282249)
20793 15419 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2090 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006808.7621 2106205.8751 37.7636249243563 -122.41962193297199 (37.7636249243563, -122.419621932972)
20857 15519 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2768 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007027.5439 2102261.5951 37.7528071641561 -122.41858551881901 (37.7528071641561, -122.418585518819)
20884 15410 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2065 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006857.2115 2106321.6003 37.7639454076577 -122.41946257191601 (37.7639454076577, -122.419462571916)

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 545.957ms · Data source: data.sfgov.org