Street_Tree_List

Data source: data.sfgov.org

837 rows where qSpecies = 42 sorted by qAddress

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
45531 220666 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1 Dorland St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6005487.19676 2105743.72088 37.7622814268651 -122.42415994852199 (37.7622814268651, -122.424159948522)
23746 188514 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1 Mississippi St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6013990.927619999 2106981.7626099996 37.7661572890446 -122.394835230264 (37.7661572890446, -122.394835230264)
43560 67530 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/22/1992 12:00:00 AM 12   Permit Number 31068 6013998.45944 2106956.61768 37.766088665392296 -122.394807417822 (37.7660886653923, -122.394807417822)
19697 85509 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
77508 85510 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
108504 85500 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
117346 85502 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
118346 85501 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
88925 50661 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Santa Ynez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
125783 50663 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Santa Ynez Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
140001 50664 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Santa Ynez Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
145318 50662 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Santa Ynez Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
151048 220044 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 10 Arbor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002160.56118 2096968.3315700002 37.7379978987733 -122.43503787010201 (37.7379978987733, -122.435037870102)
34993 188525 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 10 Bell Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6016572.5482 2095212.67149 37.7339850114017 -122.38508574382799 (37.7339850114017, -122.385085743828)
41095 220673 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 100 Alemany Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009345.21028 2095878.12902 37.735409776738294 -122.410119940478 (37.7354097767383, -122.410119940478)
156715 220671 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 100 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009657.24605 2096276.1729599999 37.7365202047272 -122.409069188799 (37.7365202047272, -122.409069188799)
75622 203667 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 100 Judson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5999360.3584 2093511.22392 37.7283460957947 -122.444471133337 (37.7283460957947, -122.444471133337)
83688 42111 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 100 Judson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
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            
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            
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            
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            
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            
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            
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            
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            
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            
45189 220002 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1001 Jarboe Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 8ft   6009383.355930001 2096884.0702099998 37.7381740121064 -122.4100590501 (37.7381740121064, -122.4100590501)
178540 220003 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1001 Jarboe Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 8ft   6009365.07591 2096886.4272 37.738179459299296 -122.410122419925 (37.7381794592993, -122.410122419925)
108526 67589 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1005 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM     Permit Number 31156 6015546.93269222 2104381.58378925 37.7591041527051 -122.38927168143199 (37.7591041527051, -122.389271681432)
90886 42110 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 100@ Detroit Judson Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
102717 42112 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 100@ Detroit Judson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
74240 141691 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5996753.535 2112367.4021 37.7799713474759 -122.45484482437 (37.7799713474759, -122.45484482437)
135030 75408 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 De Long St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 5     5994441.08765 2086786.6315099997 37.7096000577555 -122.460989960739 (37.7096000577555, -122.460989960739)
149098 75250 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 De Long St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 6     5994476.95751 2086787.3271700002 37.7096040318843 -122.460866039547 (37.7096040318843, -122.460866039547)
176496 75331 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 De Long St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 6     5994458.53323 2086786.7483599999 37.709601382461294 -122.460929674682 (37.7096013824613, -122.460929674682)
25732 220090 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Ord Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000882.83826 2105748.10477 37.7620324153945 -122.44008496885401 (37.7620324153945, -122.440084968854)
58566 220089 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Ord Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6000884.7117 2105729.84303 37.7619823797984 -122.44007717983101 (37.7619823797984, -122.440077179831)
42028 188510 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 25 Front Yard : Yard 7 Tree 1 Private 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
55738 188509 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 12 Front Yard : Yard 7 Tree 1 Private 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
60414 188512 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 41 Front Yard : Yard 7 Tree 1 Private 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
169866 188508 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 3 Front Yard : Yard 7 Tree 1 Private 1     3     6014332.46782 2106283.64375 37.764259392178005 -122.393605035044 (37.764259392178, -122.393605035044)
177773 188511 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 33 Front Yard : Yard 7 Tree 1 Private 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
54358 219993 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Prospect Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13     6006993.27252 2098944.7494 37.7436979269164 -122.418468865069 (37.7436979269164, -122.418468865069)
89457 113028 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 WINFIELD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 5x5   6007142.0 2098801.0 37.7433115947954 -122.417944411944 (37.7433115947954, -122.417944411944)
161989 219992 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007124.70017 2098812.5831299997 37.7433424258272 -122.41800505138501 (37.7433424258272, -122.418005051385)
86515 48833 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1019 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2002 12:00:00 AM     Permit Number 46053 6002516.40077061 2102618.9246623 37.7535333013465 -122.43421140278099 (37.7535333013465, -122.434211402781)
51120 66858 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 103 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/15/1991 12:00:00 AM 9   Permit Number 30164 5998644.5770000005 2110362.2819 37.774574098301294 -122.448158471707 (37.7745740983013, -122.448158471707)
38639 174959 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 103 De Long St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5994397.11424 2086788.06602 37.709601466104104 -122.461142043293 (37.7096014661041, -122.461142043293)
156503 174960 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 103 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5994409.5991400005 2086788.1181299998 37.709602327657706 -122.461098897396 (37.7096023276577, -122.461098897396)
94760 67088 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 104 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1992 12:00:00 AM     Permit Number 30490 6010217.49465897 2100245.63061 37.7474508447186 -122.407411920985 (37.7474508447186, -122.407411920985)
59933 220069 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1047 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6003827.33604 2102174.6628400004 37.7523877808826 -122.42964622220501 (37.7523877808826, -122.429646222205)
53161 67491 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1053 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/08/1992 12:00:00 AM 11   Permit Number 31016 6011662.712180001 2103457.28078 37.7563501191849 -122.402640243074 (37.7563501191849, -122.402640243074)
34990 124760 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1055 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007817.3795 2119902.3991900003 37.8012890341312 -122.417103992782 (37.8012890341312, -122.417103992782)
74967 124761 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1055 Greenwich St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007856.93229 2119906.6476 37.8013029241584 -122.41696742351101 (37.8013029241584, -122.416967423511)
185661 124762 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1055 Greenwich St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007906.12641 2119914.20021 37.8013264288216 -122.416797725058 (37.8013264288216, -122.416797725058)
93774 98707 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 105X Ord St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
124870 98708 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 105X Ord St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2           6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
99531 37020 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1061 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM     Permit Number 39632 6008655.69574399 2102373.47059511 37.7532058777371 -122.412962961361 (37.7532058777371, -122.412962961361)
110343 67563 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1067 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM     Permit Number 31115 6011664.16143038 2103412.99241656 37.7562285940169 -122.40263211667299 (37.7562285940169, -122.402632116673)
161456 78061 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 107 Cambridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/16/2000 12:00:00 AM 8     6006671.077740001 2094291.78297 37.730903769473706 -122.41925294078699 (37.7309037694737, -122.419252940787)
177746 67583 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1081 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM 10   Permit Number 31148 6011670.3331699995 2103332.09659 37.756006816477104 -122.40260508405198 (37.7560068164771, -122.402605084052)
24822 250192 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 2 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
47761 250191 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 1 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011795.08799 2119945.2148 37.8016295579248 -122.40334230423099 (37.8016295579248, -122.403342304231)
135843 250193 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 3 Back Yard : Yard 13 Tree 1 Private 1     35 Width 0ft   6011782.399230001 2119949.71509 37.8016412059365 -122.403386530161 (37.8016412059365, -122.403386530161)
110886 62618 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 11 Brewster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/1988 12:00:00 AM     Permit Number 25075 6010492.04482679 2099848.37661279 37.7463754350507 -122.40643455260201 (37.7463754350507, -122.406434552602)
1536 251472 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Hiliritas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2017 12:00:00 AM 3 3x3 Permit Number 780012 6001589.0 2096875.0 37.7377091611847 -122.437007355935 (37.7377091611847, -122.437007355935)
12540 108677 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 11 Otsego Ave 1 Front Yard : Yard 7 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3   Permit Number 773206 6000966.57436 2092971.8241299998 37.7269565451936 -122.438879746024 (37.7269565451936, -122.438879746024)
114454 108678 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 11 Otsego Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 773206 6000980.19802 2092997.8380200001 37.727028748485395 -122.43883451276501 (37.7270287484854, -122.438834512765)
58771 220011 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 110 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006153.26604 2102345.16587 37.7529873705964 -122.421614871629 (37.7529873705964, -122.421614871629)
44341 220066 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1109 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002537.114630001 2102291.1496200003 37.7526344847082 -122.434116340213 (37.7526344847082, -122.434116340213)
88872 84017 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1109 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50426 6002531.06648038 2102355.71188239 37.7528114140683 -122.43414187071899 (37.7528114140683, -122.434141870719)
130712 67547 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1125 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM 9   Permit Number 31093 6011962.71401 2103154.98207 37.75553681818771 -122.40158148021798 (37.7555368181877, -122.401581480218)
168971 220018 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1129 Douglass St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6001364.34858 2100418.37342 37.7474256590636 -122.43803782498999 (37.7474256590636, -122.43803782499)
111062 37754 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1138 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/01/1998 12:00:00 AM     Permit Number 40101 6008628.86236582 2101910.8796111 37.7519342006623 -122.413023051242 (37.7519342006623, -122.413023051242)
162381 40685 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 114 Ney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/10/1999 12:00:00 AM 6   Permit Number 41668 6004151.556609999 2094012.13266 37.7299936942445 -122.42794342066001 (37.7299936942445, -122.42794342066)
33499 174962 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 114 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000450.3974 2092235.26707 37.724904747337106 -122.440611347459 (37.7249047473371, -122.440611347459)
185361 220004 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1142 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008637.13035 2101883.29537 37.751858924657796 -122.412992509104 (37.7518589246578, -122.412992509104)
85747 39220 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1143 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/1999 12:00:00 AM     Permit Number 41443 6005801.05573922 2102320.92573379 37.752900946135604 -122.422831161336 (37.7529009461356, -122.422831161336)
125085 39221 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1143 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/1999 12:00:00 AM     Permit Number 41443 6005801.05573922 2102320.92573379 37.752900946135604 -122.422831161336 (37.7529009461356, -122.422831161336)
144860 69216 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1144 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1994 12:00:00 AM     Permit Number 33267 6008630.78048604 2101877.2067938 37.751841850344704 -122.41301403743401 (37.7518418503447, -122.413014037434)
90206 51723 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1148 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/02/2005 12:00:00 AM     Permit Number 47992 6008632.05923166 2101854.75826991 37.7517802835227 -122.41300802824699 (37.7517802835227, -122.413008028247)
26472 220689 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 119 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004994.550369999 2099284.37518 37.744517739909 -122.42540413451401 (37.744517739909, -122.425404134514)
68717 203626 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 12 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5997325.36011 2099393.7124400004 37.7443816679834 -122.451930391889 (37.7443816679834, -122.451930391889)
112951 65654 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 12 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/2008 12:00:00 AM   3x3 Permit Number 51556 5997336.22410326 2099411.42392563 37.744430921643 -122.451894104171 (37.744430921643, -122.451894104171)
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)
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)
58064 220047 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1201 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5997716.00381 2106428.96316 37.7637210849721 -122.451086869165 (37.7637210849721, -122.451086869165)
101299 39622 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1998 12:00:00 AM     Permit Number 41021 5997705.33041065 2106460.2771729 37.7638064542355 -122.451126043319 (37.7638064542355, -122.451126043319)
109830 39623 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1201 Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1998 12:00:00 AM     Permit Number 41021 5997705.33041065 2106460.2771729 37.7638064542355 -122.451126043319 (37.7638064542355, -122.451126043319)
2164 10688 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1221 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/1991 12:00:00 AM 6 3X3   6002001.6656 2110480.73 37.7750906677438 -122.43655414222 (37.7750906677438, -122.43655414222)
30832 203666 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 123 Detroit St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5999405.93855 2093561.74161 37.728487406244604 -122.44431719010001 (37.7284874062446, -122.4443171901)

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