Street_Tree_List

Data source: data.sfgov.org

837 rows where qSpecies = 42 sorted by XCoord

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location
1434 20063 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
3716 20054 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
5340 30595 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 265 Walter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34562          
6851 20056 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
7439 19729 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY14 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
7770 20060 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
8932 19577 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY3 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
10291 19793 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY19 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20ST            
11185 20057 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
15210 20061 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
15314 30594 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 265 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34562          
15394 20062 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
15615 30591 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 253 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34560          
15903 20055 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
16172 20064 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
16839 20059 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
65053 37086 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1426 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 0   Permit Number 39686 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192)
93635 35001 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 8028 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/1997 12:00:00 AM     Permit Number 38578 5982135.81465862 2112401.83483279 37.7792165374199 -122.50541575084101 (37.7792165374199, -122.505415750841)
109990 35000 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 8028 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/1997 12:00:00 AM     Permit Number 38578 5982135.81465862 2112401.83483279 37.7792165374199 -122.50541575084101 (37.7792165374199, -122.505415750841)
165790 55817 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1479 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2008 12:00:00 AM 5 3x3 Permit Number 50161 5982146.8936 2105055.9033 37.759047387316706 -122.50483294742399 (37.7590473873167, -122.504832947424)
127807 40209 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 546 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41391 5982267.21985305 2112050.10759861 37.778258529647005 -122.50493510260799 (37.778258529647, -122.504935102608)
93890 98217 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1501X 42nd Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
23355 76748 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/14/1994 12:00:00 AM 7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631)
184246 51499 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1518 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/13/2005 12:00:00 AM 1   Permit Number 47812 5983133.1181 2104773.3328 37.758329497976 -122.501401269082 (37.758329497976, -122.501401269082)
82962 29220 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1902X 41st Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
92157 29223 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1902X 41st Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
110361 29224 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1902X 41st Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
45099 184964 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1990 41st Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983545.7781 2101731.1432 37.7500007203614 -122.499749280915 (37.7500007203614, -122.499749280915)
60547 184904 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1990 41st Ave 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983548.4855 2101753.1406 37.7500612779998 -122.499741544392 (37.7500612779998, -122.499741544392)
33826 184961 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1990 41st Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983548.8239 2101628.2630000003 37.7497184185455 -122.4997311455 (37.7497184185455, -122.4997311455)
32571 69145 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2419 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/18/1994 12:00:00 AM 6   Permit Number 33179 5983608.7607 2098659.5816 37.741570751884 -122.499304541285 (37.741570751884, -122.499304541285)
114669 53682 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 879 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM     Permit Number 30735 5984157.5341821 2109855.55736393 37.7723439568609 -122.49823378959 (37.7723439568609, -122.49823378959)
90300 49970 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 577 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2003 12:00:00 AM   3x3 Permit Number 46721 5984701.98485126 2111935.6867193 37.7780873043924 -122.496504036563 (37.7780873043924, -122.496504036563)
3793 39226 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 770 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1998 12:00:00 AM 9   Permit Number 40869 5984798.64138 2110605.0729799997 37.774439483359 -122.49607147975 (37.774439483359, -122.49607147975)
64061 32346 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 35th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
78102 32344 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 35th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
107835 32345 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 35th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
135969 32347 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 35th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 10   Permit Number 37068 5985187.3443 2106976.3651 37.764498837803394 -122.494459352499 (37.7644988378034, -122.494459352499)
154995 32348 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 9   Permit Number 37068 5985188.5725 2106987.4184 37.764529258945 -122.49445591941799 (37.764529258945, -122.494455919418)
34587 78000 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2804 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/2000 12:00:00 AM 7     5985608.4149 2096224.5025 37.735001786065 -122.492211254352 (37.735001786065, -122.492211254352)
44369 42898 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2060 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/2002 12:00:00 AM 7   Permit Number 45580 5986523.9754 2097068.6969 37.737373201510295 -122.489107923346 (37.7373732015103, -122.489107923346)
74936 42897 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2016 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 7   Permit Number 42813 5986657.8903 2096958.6583 37.737078880033 -122.488636837876 (37.737078880033, -122.488636837876)
147832 42896 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2016 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 6   Permit Number 42813 5986675.0189 2096952.6028 37.737063252741706 -122.488577172427 (37.7370632527417, -122.488577172427)
118633 69308 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1550 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/16/1994 12:00:00 AM     Permit Number 33387 5986864.5682116 2104707.11140573 37.7583661086574 -122.488491577304 (37.7583661086574, -122.488491577304)
88063 33257 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2669 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/1996 12:00:00 AM     Permit Number 37434 5986956.33101058 2097199.71207947 37.7377581609646 -122.48762271062598 (37.7377581609646, -122.487622710626)
103259 33256 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2669 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/13/1996 12:00:00 AM     Permit Number 37434 5986956.33101058 2097199.71207947 37.7377581609646 -122.48762271062598 (37.7377581609646, -122.487622710626)
58356 71805 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2451 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/02/1990 12:00:00 AM 4     5987333.5642 2098599.3879 37.741623296224205 -122.486421183565 (37.7416232962242, -122.486421183565)
65658 183506 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2542 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5988021.6131 2097993.9577 37.7400010259161 -122.483997786352 (37.7400010259161, -122.483997786352)
44871 36124 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1324 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/29/1998 12:00:00 AM 10   Permit Number 39220 5988358.7841 2106301.1655 37.7628300220311 -122.483440838848 (37.7628300220311, -122.483440838848)
148872 31585 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1894 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/2007 12:00:00 AM 7 3x3 Permit Number 49864 5988492.0785 2102440.4028 37.7522371668693 -122.482696889121 (37.7522371668693, -122.482696889121)
10474 34625 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1466 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38307 5988697.9248 2105373.4338 37.76030245534 -122.482199912019 (37.76030245534, -122.482199912019)
173732 34626 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1474 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 0   Permit Number 38308 5988706.220433701 2105294.39494794 37.760085918568 -122.48216543102 (37.760085918568, -122.48216543102)
172105 182147 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1690 21st Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5989680.1915 2103890.3009 37.756287254354 -122.478694280415 (37.756287254354, -122.478694280415)
75611 182146 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1690 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5989681.6149 2103872.2722 37.756237834999 -122.478688039412 (37.756237834999, -122.478688039412)
154249 34233 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1690 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/25/1997 12:00:00 AM 8   Permit Number 38046 5989683.0382 2103856.1412 37.7561936262155 -122.47868193754299 (37.7561936262155, -122.478681937543)
145457 67397 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 615 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1992 12:00:00 AM     Permit Number 30894 5990626.25534689 2111189.00376145 37.776382409214705 -122.47595552081499 (37.7763824092147, -122.475955520815)
32938 203645 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2450 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991098.28096 2098726.3101 37.7421905156936 -122.473413447294 (37.7421905156936, -122.473413447294)
152749 203644 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2450 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991098.76282 2098712.81343 37.742153485208796 -122.47341079698799 (37.7421534852088, -122.473410796988)
56688 122010 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1342 Cabrillo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5991362.52356 2110673.50037 37.775009640229605 -122.473370979732 (37.7750096402296, -122.473370979732)
169675 203643 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2479 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991370.41192 2098543.97685 37.7417056300124 -122.47245922253201 (37.7417056300124, -122.472459222532)
154629 113718 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1342 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   14     5991385.6612 2110673.31757 37.7750104780928 -122.473290929077 (37.7750104780928, -122.473290929077)
55462 113717 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1342 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   12     5991400.52029 2110673.00421 37.775010478076794 -122.47323950591299 (37.7750104780768, -122.473239505913)
38779 68329 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1342 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 12   Permit Number 32144 5991421.402000001 2110674.853 37.7750167634254 -122.47316740712401 (37.7750167634254, -122.473167407124)
105423 41830 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1232 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/2001 12:00:00 AM     Permit Number 42216 5991454.19182704 2107029.2184828 37.765008732916705 -122.472788101582 (37.7650087329167, -122.472788101582)
120261 45313 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 359 Byxbee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/18/2001 12:00:00 AM     Permit Number 44150 5991933.83383604 2090925.21902291 37.7208190204058 -122.46995651824301 (37.7208190204058, -122.469956518243)
97815 67367 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 622 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/1992 12:00:00 AM     Permit Number 30860 5991947.66141854 2111184.68459598 37.7764470789457 -122.47138413483101 (37.7764470789457, -122.471384134831)
170043 203639 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 216 Ralston St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 5ft   5992221.12373 2089294.63928 37.7163584485498 -122.46884485801701 (37.7163584485498, -122.468844858017)
166995 203640 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 216 Ralston St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 5ft   5992221.60329 2089317.4306299998 37.7164210557753 -122.468844858002 (37.7164210557753, -122.468844858002)
165659 203641 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 608 Garfield St 1 : 4 Tree 1 Private 1     9 Width 3ft   5992400.09934 2090515.7050700001 37.7197215370907 -122.468315017932 (37.7197215370907, -122.468315017932)
107001 43661 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 370 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43304 5992506.56767844 2112958.60482073 37.781350097045 -122.46957990283 (37.781350097045, -122.46957990283)
142422 70953 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 76 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/2008 12:00:00 AM   3x3 Permit Number 50393 5992532.60289704 2098624.81220808 37.7419947820759 -122.468446668857 (37.7419947820759, -122.468446668857)
103976 98341 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 790X 11th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   5992573.13535 2110349.8527 37.7741910183852 -122.469159688197 (37.7741910183852, -122.469159688197)
125899 98340 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 790X 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5992573.13535 2110349.8527 37.7741910183852 -122.469159688197 (37.7741910183852, -122.469159688197)
119059 47172 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 310 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM     Permit Number 45136 5992595.84229454 2094810.68405906 37.731525796784 -122.46795064653 (37.731525796784, -122.46795064653)
125998 33399 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 300 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37517 5992600.35501271 2094892.48894855 37.7317506732587 -122.467940993296 (37.7317506732587, -122.467940993296)
98067 98339 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 3434 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5992637.0 2110058.2 37.77339390860929 -122.468917542393 (37.7733939086093, -122.468917542393)
162565 203221 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2398 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5992664.0139 2099193.92326 37.7435650062179 -122.468033683007 (37.7435650062179, -122.468033683007)
106159 64173 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 30 Cerritos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/17/1987 12:00:00 AM     Permit Number 24955 5992735.52734942 2093091.96966529 37.7268146975842 -122.467342804105 (37.7268146975842, -122.467342804105)
94512 37474 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1642 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM     Permit Number 39945 5992805.4256232 2104283.42646812 37.7575476379464 -122.467914829169 (37.7575476379464, -122.467914829169)
104133 64176 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 7 Cerritos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/2000 12:00:00 AM     Permit Number 24959 5992913.91992547 2093156.51419592 37.727002217924706 -122.466730800624 (37.7270022179247, -122.466730800624)
2852 215287 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 335 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft Permit Number 780412 5992944.71929 2103190.50616 37.7545548052666 -122.46735363008301 (37.7545548052666, -122.467353630083)
96828 68073 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 335 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/1993 12:00:00 AM     Permit Number 31811 5993016.05828809 2103198.83445662 37.7545817907356 -122.46710752853501 (37.7545817907356, -122.467107528535)
100490 46891 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1442 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2002 12:00:00 AM     Permit Number 44947 5993067.98197095 2105653.75631803 37.7613253640923 -122.46710643924999 (37.7613253640923, -122.46710643925)
179662 203222 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 120 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993081.79545 2099194.6713799997 37.7435911783029 -122.466589164064 (37.7435911783029, -122.466589164064)
89405 31180 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 344 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34878 5993129.55455829 2089868.58886975 37.717986817508 -122.465746580217 (37.717986817508, -122.465746580217)
36367 203642 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1700 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 5ft   5993150.97673 2103877.75625 37.7564537210662 -122.466690296437 (37.7564537210662, -122.466690296437)
62851 203648 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1907 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993437.25696 2102479.71785 37.7526315852957 -122.46559868313 (37.7526315852957, -122.46559868313)
101981 41993 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 75 Manor Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42333 5993572.90365136 2093435.37616672 37.7278059137082 -122.46447296226299 (37.7278059137082, -122.464472962263)
149197 203647 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 70 Manor Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5993596.72892 2093377.0999599998 37.7276472749004 -122.46438636913099 (37.7276472749004, -122.464386369131)
66468 203632 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5993831.29855 2094857.6984 37.7317261536347 -122.463682879865 (37.7317261536347, -122.463682879865)
158134 203631 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   5993837.01835 2094842.09298 37.7316836345786 -122.46366197331801 (37.7316836345786, -122.463661973318)
186555 203630 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   5993843.17005 2094826.47883 37.731641116434496 -122.46363957301 (37.7316411164345, -122.46363957301)
151268 203651 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5993846.97887 2094818.6059299998 37.731619718855704 -122.46362583408701 (37.7316197188557, -122.463625834087)
157925 203650 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   5993848.38247 2094813.0241599998 37.7316044735649 -122.46362057664699 (37.7316044735649, -122.463620576647)
178200 203649 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5993852.26622 2094804.8663700002 37.731582298063394 -122.46360655802201 (37.7315822980634, -122.463606558022)
61286 203225 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1575 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5993973.71625 2104850.02282 37.759170760036994 -122.463915566851 (37.759170760037, -122.463915566851)
184876 203227 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1575 07th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5993976.11047 2104705.81134 37.7587749306244 -122.463896818706 (37.7587749306244, -122.463896818706)
25195 203226 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1575 07th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5993976.59011 2104728.66377 37.7588377051234 -122.463896818678 (37.7588377051234, -122.463896818678)
126861 33356 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 200 Kenwood Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1996 12:00:00 AM     Permit Number 37493 5994058.57591139 2093537.34847989 37.7281138896418 -122.46280139081699 (37.7281138896418, -122.462801390817)
62900 203646 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 45 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994072.18954 2100047.28757 37.745989350944 -122.463226505408 (37.745989350944, -122.463226505408)

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