Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 2637 | 2637 | 37816 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.6668300005 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) |
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 10290 | 10290 | 37814 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) |
| 12958 | 12958 | 37815 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) |
| 19047 | 19047 | 23032 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.757845377874204 | -122.42109817336599 | (37.7578453778742, -122.421098173366) | ||
| 19744 | 19744 | 66789 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.80052509557579 | -122.42292350049 | (37.8005250955758, -122.42292350049) |
| 25501 | 25501 | 141630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999025.3732 | 2110414.9246 | 37.774740403045996 | -122.446845016858 | (37.774740403046, -122.446845016858) | |||
| 26908 | 26908 | 219997 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 80 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007927.7529 | 2099409.5439400002 | 37.7450267121064 | -122.41527054312 | (37.7450267121064, -122.41527054312) | |||
| 30607 | 30607 | 38043 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.44341765838199 | (37.7855000811005, -122.443417658382) | |
| 31368 | 31368 | 40190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | ||
| 32980 | 32980 | 30799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.114019999 | 2095231.84638 | 37.733226875715296 | -122.43509850062 | (37.7332268757153, -122.43509850062) | |
| 33357 | 33357 | 220021 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001964.613530001 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | |||
| 33826 | 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) | |||
| 35351 | 35351 | 42685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | |
| 37273 | 37273 | 37949 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.39722464979602 | (37.7586622221997, -122.397224649796) | |
| 42347 | 42347 | 203665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.728549449599704 | -122.444327421686 | (37.7285494495997, -122.444327421686) | |||
| 42561 | 42561 | 203661 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5997537.55728 | 2095290.5878599999 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | |||
| 44341 | 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) | |||
| 44479 | 44479 | 220686 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004903.16789 | 2110400.7033700002 | 37.775035387294295 | -122.426511501216 | (37.7750353872943, -122.426511501216) | |||
| 44560 | 44560 | 54500 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.39717901909599 | (37.760298732933, -122.397179019096) | |
| 45099 | 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) | |||
| 45390 | 45390 | 220087 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | |||
| 45531 | 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) | |||
| 45939 | 45939 | 138342 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | |||
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 47710 | 47710 | 44248 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1960 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2001 12:00:00 AM | 8 | Permit Number 43683 | 5999863.264769999 | 2121264.87303 | 37.8045793513217 | -122.44472662894199 | (37.8045793513217, -122.444726628942) | ||
| 47962 | 47962 | 219999 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005999.49716 | 2097639.92479 | 37.740059177277004 | -122.421812441905 | (37.740059177277, -122.421812441905) | |||
| 56697 | 56697 | 35266 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.42230648984699 | (37.798273260158, -122.422306489847) |
| 58771 | 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) | |||
| 60147 | 60147 | 220040 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 816 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001002.40026 | 2102614.77247 | 37.7534358534934 | -122.439446835117 | (37.7534358534934, -122.439446835117) | |||
| 61827 | 61827 | 138346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | |||
| 64130 | 64130 | 248395 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997659.0251 | 2108142.2349 | 37.768422030688896 | -122.451407517669 | (37.7684220306889, -122.451407517669) | |||
| 64628 | 64628 | 71308 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.44271758887699 | (37.7781096083019, -122.442717588877) | ||
| 65413 | 65413 | 137613 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.778040516588604 | -122.436931690487 | (37.7780405165886, -122.436931690487) | |||
| 68937 | 68937 | 48447 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2600 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 8 | Permit Number 45819 | 5999656.5928 | 2113671.6674 | 37.783718621904896 | -122.44489566584998 | (37.7837186219049, -122.44489566585) | ||
| 70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
| 70549 | 70549 | 40816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | ||
| 73601 | 73601 | 40189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | ||
| 75622 | 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) | |||
| 78948 | 78948 | 37828 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2006 12:00:00 AM | 8 | 3x3 | Permit Number 48867 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 93136 | 93136 | 37837 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 93807 | 93807 | 43210 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 350 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 43001 | 6008795.91385 | 2094346.1745799999 | 37.7311725561519 | -122.41191084861299 | (37.7311725561519, -122.411910848613) | |
| 95511 | 95511 | 49584 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | ||
| 99251 | 99251 | 19283 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
| 99304 | 99304 | 44327 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1586 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2001 12:00:00 AM | 8 | 2x3 | Permit Number 43713 | 5997934.27114243 | 2105194.99069947 | 37.7603454014574 | -122.45024300053001 | (37.7603454014574, -122.45024300053) | |
| 102349 | 102349 | 34758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | |
| 103976 | 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) | |||
| 129705 | 129705 | 220028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | |||
| 130349 | 130349 | 220027 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001922.66093 | 2102622.7782400004 | 37.7535101653675 | -122.43626495635701 | (37.7535101653675, -122.436264956357) | |||
| 130794 | 130794 | 188513 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.39479799565399 | (37.7659112417232, -122.394797995654) | |||
| 135734 | 135734 | 219995 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.10477 | 2099694.15634 | 37.745811754609896 | -122.415071624753 | (37.7458117546099, -122.415071624753) | |||
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 148365 | 148365 | 203637 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | |||
| 148974 | 148974 | 174958 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | |||
| 152716 | 152716 | 40191 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.320719999 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | ||
| 154249 | 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) | ||
| 157543 | 157543 | 139098 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.44495327295601 | (37.7837140544374, -122.444953272956) | |||
| 158356 | 158356 | 220012 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006012.224219999 | 2102309.19405 | 37.7528806462302 | -122.42210006667601 | (37.7528806462302, -122.422100066676) | |||
| 161456 | 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) | ||
| 161597 | 161597 | 220697 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | |||
| 161989 | 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) | |||
| 162065 | 162065 | 220000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006013.90538 | 2097631.08265 | 37.7400357112669 | -122.421761996217 | (37.7400357112669, -122.421761996217) | |||
| 170022 | 170022 | 220032 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4496 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000063.08667 | 2101692.20447 | 37.7508492036437 | -122.442628935085 | (37.7508492036437, -122.442628935085) | |||
| 170339 | 170339 | 140104 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1750 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999428.844 | 2110866.7552 | 37.776004055577204 | -122.44548183036301 | (37.7760040555772, -122.445481830363) | |||
| 172105 | 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) | |||
| 174105 | 174105 | 220030 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.752897751333705 | -122.435109978657 | (37.7528977513337, -122.435109978657) | |||
| 174318 | 174318 | 220076 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4512 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6001006.90228 | 2104666.0365299997 | 37.7590683830131 | -122.43957830609 | (37.7590683830131, -122.43957830609) | |||
| 175370 | 175370 | 103893 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999294.1521 | 2110847.1267 | 37.7759424705585 | -122.445946351246 | (37.7759424705585, -122.445946351246) | |||
| 176295 | 176295 | 249709 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2901 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999701.30683 | 2117014.48804 | 37.7928996850292 | -122.44498136009899 | (37.7928996850292, -122.444981360099) | ||||
| 178755 | 178755 | 220034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 622 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002480.9934 | 2100067.1600599997 | 37.7465247497217 | -122.43415144344699 | (37.7465247497217, -122.434151443447) | |||
| 184798 | 184798 | 248081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.40662106962799 | (37.7472540585408, -122.406621069628) | |||
| 186993 | 186993 | 44745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.42036685635401 | (37.7952406976494, -122.420366856354) | ||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) |
JSON shape: default, array, newline-delimited
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");