Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
3793 | 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) | ||
12540 | 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) | |
15314 | 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 | ||||||||
15615 | 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 | ||||||||
18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
20390 | 20390 | 66640 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.756213630012496 | -122.407049963033 | (37.7562136300125, -122.407049963033) | ||
26644 | 26644 | 48033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.761346597247794 | -122.437156358638 | (37.7613465972478, -122.437156358638) | |||
27440 | 27440 | 35252 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.42252550983801 | (37.8005900423666, -122.422525509838) | |
30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
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) | ||
32571 | 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) | |
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) | |
34587 | 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) | ||
34898 | 34898 | 40295 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.42220732508801 | (37.7528895951686, -122.422207325088) | ||
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) | |
37323 | 37323 | 44456 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.710307180311105 | -122.432895389109 | (37.7103071803111, -122.432895389109) | |
38263 | 38263 | 68132 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241543998 | (37.7843775414062, -122.44131241544) | |
38771 | 38771 | 174961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000769.59798 | 2092028.9930200002 | 37.7243565377 | -122.43949313040899 | (37.7243565377, -122.439493130409) | ||||
38779 | 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) | |
40082 | 40082 | 38526 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199240996 | -122.437330933595 | (37.797420199241, -122.437330933595) | ||
40232 | 40232 | 50534 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.42959951321899 | (37.7968102295769, -122.429599513219) | ||
42992 | 42992 | 32891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
43560 | 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) | |
44083 | 44083 | 32557 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.43271855723499 | (37.7546666427143, -122.432718557235) | |||
44369 | 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) | |
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) | |
44833 | 44833 | 34144 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.740944124338895 | -122.428905023889 | (37.7409441243389, -122.428905023889) | ||
44871 | 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) | |
46001 | 46001 | 41430 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.39729645077699 | (37.7593731443828, -122.397296450777) | |
47055 | 47055 | 40817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.785958067470204 | -122.43822613537901 | (37.7859580674702, -122.438226135379) | |
47147 | 47147 | 73391 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 10 | 6001816.88591 | 2094039.23102 | 37.72993574283429 | -122.43601658701999 | (37.7299357428343, -122.43601658702) | ||
47279 | 47279 | 35103 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.43543753433399 | (37.7168332689419, -122.435437534334) | ||
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) | ||
50358 | 50358 | 35258 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.42317295609199 | (37.8015923223752, -122.423172956092) | |
50887 | 50887 | 43172 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 370 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42981 | 6005806.0739 | 2092004.6857099999 | 37.7245751476096 | -122.42208098844101 | (37.7245751476096, -122.422080988441) | |
51120 | 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) | ||
51454 | 51454 | 44091 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.913930001 | 2104520.92035 | 37.759251716121796 | -122.40388677626001 | (37.7592517161218, -122.40388677626) | ||
53161 | 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) | |
55604 | 55604 | 35336 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.40560053693501 | (37.7607157062843, -122.405600536935) | |
55919 | 55919 | 31468 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 523 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 9 | Permit Number 35034 | 6002955.92893 | 2102097.8639599998 | 37.752127528763204 | -122.432654202633 | (37.7521275287632, -122.432654202633) | |
58356 | 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) | ||
60100 | 60100 | 83227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.39716301566901 | (37.7601232913798, -122.397163015669) | ||
61126 | 61126 | 50520 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | |
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) | ||
65053 | 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) | |
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) | ||
75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
77700 | 77700 | 37051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.43023969551201 | (37.7427495797017, -122.430239695512) | ||
77854 | 77854 | 63851 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724183999 | (37.775063328726, -122.43667724184) | ||
79057 | 79057 | 32274 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | ||
79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
79886 | 79886 | 67804 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | ||
79951 | 79951 | 32740 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | ||
80747 | 80747 | 68174 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612005 | -122.45363471008001 | (37.778437859612, -122.45363471008) | ||
81201 | 81201 | 67531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.765852048761104 | -122.394795132512 | (37.7658520487611, -122.394795132512) | ||
81631 | 81631 | 64135 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 674 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31501 | 6002183.05937143 | 2098884.5643421 | 37.7432607055203 | -122.43509709755399 | (37.7432607055203, -122.435097097554) | ||
81838 | 81838 | 35367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.723794911059606 | -122.401914809778 | (37.7237949110596, -122.401914809778) | ||
81874 | 81874 | 65160 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | ||
81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
81990 | 81990 | 43708 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
82740 | 82740 | 67907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | ||
82846 | 82846 | 63850 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | ||
83688 | 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) | ||
84092 | 84092 | 30931 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | ||
84909 | 84909 | 33582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37690 | 6007165.20249785 | 2098095.43390853 | 37.741375573534896 | -122.41781418098302 | (37.7413755735349, -122.417814180983) | |||
85499 | 85499 | 35558 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
85747 | 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) | ||
85817 | 85817 | 45250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.188004401 | 2098465.43898756 | 37.7417803963921 | -122.45502778464599 | (37.7417803963921, -122.455027784646) | ||
85980 | 85980 | 61747 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2016 12:00:00 AM | 3 | Permit Number 21753 | 6004950.72602956 | 2100792.08081868 | 37.7486550770793 | -122.425662958373 | (37.7486550770793, -122.425662958373) | |
86084 | 86084 | 45525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1700 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | Permit Number 44286 | 5999707.83752219 | 2110208.85696406 | 37.7742135578008 | -122.444469428603 | (37.7742135578008, -122.444469428603) | |||
86247 | 86247 | 50653 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953358995 | -122.452612074363 | (37.710694953359, -122.452612074363) | |||
86248 | 86248 | 37317 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | ||
86515 | 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) | |||
86777 | 86777 | 38531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | ||
87234 | 87234 | 61737 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | ||
87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
87658 | 87658 | 67603 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216001 | (37.7642517131045, -122.39677434216) | ||
88063 | 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) | ||
88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
88327 | 88327 | 64256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | ||
88609 | 88609 | 67673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969015996 | -122.393277319642 | (37.733518969016, -122.393277319642) | ||
88651 | 88651 | 51518 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.731737008800394 | -122.44720311183701 | (37.7317370088004, -122.447203111837) | |||
88842 | 88842 | 66113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | ||
89217 | 89217 | 34443 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.740509693537504 | -122.427643467723 | (37.7405096935375, -122.427643467723) | ||
89262 | 89262 | 33122 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.798541206544705 | -122.438525775033 | (37.7985412065447, -122.438525775033) | ||
89405 | 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) | ||
89699 | 89699 | 50067 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 408 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46795 | 6003569.75244558 | 2105901.71860795 | 37.7626068007008 | -122.430802940638 | (37.7626068007008, -122.430802940638) | ||
90037 | 90037 | 68758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32681 | 6004133.43114203 | 2105726.5811326997 | 37.762157835439 | -122.42884089299999 | (37.762157835439, -122.428840893) | ||
90206 | 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) | ||
90373 | 90373 | 64794 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | ||
90541 | 90541 | 61342 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | ||
90603 | 90603 | 61344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.42721871600901 | (37.7748381087345, -122.427218716009) | ||
90974 | 90974 | 37857 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | ||
91732 | 91732 | 34299 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | ||
92505 | 92505 | 36515 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.41911373442801 | (37.735074223818, -122.419113734428) | ||
92717 | 92717 | 49840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 626@ CASTRO 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2003 12:00:00 AM | Permit Number 46623 | 6002452.84285908 | 2100074.93808821 | 37.7465445086172 | -122.434249340793 | (37.7465445086172, -122.434249340793) | |||
92979 | 92979 | 66117 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.77602792540829 | -122.430248650411 | (37.7760279254083, -122.430248650411) | ||
93188 | 93188 | 40860 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42377 | 6007537.55147065 | 2099272.41006031 | 37.744628235414204 | -122.416610080854 | (37.7446282354142, -122.416610080854) | ||
93635 | 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) |
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");