trees
835 rows where qSpecies_id = 122 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40817 | 120111 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6004952 | 2108176 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | 8 | 4 | 5 | 28853 | 19 | |||
41100 | 68174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612 | -122.45363471008 | (37.778437859612, -122.45363471008) | 15 | 6 | 2 | 54 | 16 | ||
41116 | 220668 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007462.21417 | 2105696.0479 | 37.7622618441433 | -122.417325709834 | (37.7622618441433, -122.417325709834) | 8 | 4 | 7 | 28859 | 19 | |||
41217 | 67483 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 556 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 7 | Permit Number 31006 | 6002164.8912 | 2110413.7271 | 37.7749159685838 | -122.435984714323 | (37.7749159685838, -122.435984714323) | 15 | 5 | 11 | 29492 | 10 | |
41465 | 67531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.7658520487611 | -122.394795132512 | (37.7658520487611, -122.394795132512) | 14 | 3 | 8 | 28856 | 20 | ||
41632 | 220030 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.7528977513337 | -122.435109978657 | (37.7528977513337, -122.435109978657) | 2 | 4 | 5 | 28862 | 22 | |||
41929 | 35367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.7237949110596 | -122.401914809778 | (37.7237949110596, -122.401914809778) | 10 | 3 | 7 | 309 | 28 | ||
42005 | 220095 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 5 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.434075672856 | (37.7364715774983, -122.434075672856) | 2 | 7 | 5 | 63 | 7 | |||
42433 | 30931 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | 9 | 8 | 6 | 28861 | 24 | ||
43377 | 23032 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.7578453778742 | -122.421098173366 | (37.7578453778742, -122.421098173366) | 2 | 4 | 7 | 28859 | 19 | ||
43669 | 43708 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | 9 | 8 | 6 | 28861 | 24 | ||
44119 | 220040 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 816 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001002.40026 | 2102614.77247 | 37.7534358534934 | -122.439446835117 | (37.7534358534934, -122.439446835117) | 2 | 4 | 5 | 28862 | 22 | |||
44328 | 203663 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998288.80546 | 2093783.09686 | 37.7290313953773 | -122.448195092827 | (37.7290313953773, -122.448195092827) | 9 | 7 | 4 | 28861 | 40 | |||
44339 | 220001 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | 2 | 7 | 7 | 28859 | 2 | |||
44531 | 64135 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 674 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31501 | 6002183.05937143 | 2098884.5643421 | 37.7432607055203 | -122.435097097554 | (37.7432607055203, -122.435097097554) | 2 | 7 | 5 | 63 | 22 | ||
44577 | 203627 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994260.23727 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | 9 | 8 | 4 | 59 | 40 | |||
45594 | 220080 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002959.28499 | 2103850.36087 | 37.7569396589602 | -122.432767777111 | (37.7569396589602, -122.432767777111) | 2 | 4 | 5 | 28862 | 3 | |||
45862 | 246075 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.448545275143 | (37.7692654626532, -122.448545275143) | 15 | 5 | 11 | 29492 | 9 | |||
46210 | 63850 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | 15 | 5 | 11 | 29492 | 10 | ||
46532 | 42111 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
46763 | 138140 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1942 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999833.7647 | 2111267.0068 | 37.7771261520231 | -122.444109874692 | (37.7771261520231, -122.444109874692) | 15 | 5 | 11 | 29490 | 16 | |||
47256 | 220078 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4021 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003547.22001 | 2104169.95636 | 37.7578505193113 | -122.430757284236 | (37.7578505193113, -122.430757284236) | 2 | 4 | 5 | 28862 | 3 | |||
47911 | 203643 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.472459222532 | (37.7417056300124, -122.472459222532) | 1 | 8 | 4 | 29491 | 40 | |||
49717 | 42335 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | 9 | 7 | 4 | 28861 | 40 | ||
50050 | 220002 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 8ft | 6009383.35593 | 2096884.07021 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | 10 | 7 | 7 | 28859 | 2 | |||
50159 | 98340 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
50427 | 40817 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.7859580674702 | -122.438226135379 | (37.7859580674702, -122.438226135379) | 13 | 6 | 1 | 29490 | 27 | |
50530 | 174963 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 27 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005106.80972 | 2093312.66064 | 37.7281270946664 | -122.424591254394 | (37.7281270946664, -122.424591254394) | 9 | 7 | 6 | 28861 | 5 | |||
51715 | 220032 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4496 24th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000063.08667 | 2101692.20447 | 37.7508492036437 | -122.442628935085 | (37.7508492036437, -122.442628935085) | 2 | 4 | 5 | 28862 | 22 | |||
52115 | 220667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007176.02734 | 2107716.44116 | 37.7677932655629 | -122.418458791748 | (37.7677932655629, -122.418458791748) | 8 | 4 | 7 | 28853 | 19 | |||
52547 | 65160 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | 2 | 4 | 5 | 28862 | 22 | ||
52636 | 46270 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.7324565829795 | -122.435548678389 | (37.7324565829795, -122.435548678389) | 9 | 7 | 5 | 63 | 40 | ||
53265 | 220067 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.7561898411013 | -122.431964909158 | (37.7561898411013, -122.431964909158) | 2 | 4 | 5 | 28862 | 22 | |||
53662 | 31436 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4336 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 12 | Permit Number 35011 | 6000994.34179 | 2103320.57873 | 37.7553733681958 | -122.439525295576 | (37.7553733681958, -122.439525295576) | 2 | 4 | 5 | 28862 | 38 | |
54060 | 108677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Otsego Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.82413 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | 9 | 7 | 6 | 28861 | 25 | |
54989 | 67804 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | 2 | 4 | 5 | 28862 | 22 | ||
55154 | 220686 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004903.16789 | 2110400.70337 | 37.7750353872943 | -122.426511501216 | (37.7750353872943, -122.426511501216) | 7 | 9 | 11 | 28852 | 10 | |||
55729 | 220043 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000611.23622 | 2102612.95968 | 37.753408606731 | -122.440799429852 | (37.753408606731, -122.440799429852) | 2 | 4 | 5 | 28862 | 22 | |||
56106 | 220074 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) | 2 | 4 | 5 | 28862 | 3 | |||
56636 | 220073 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 147 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002697.13556 | 2105044.08938 | 37.7602024793668 | -122.433759704173 | (37.7602024793668, -122.433759704173) | 2 | 4 | 5 | 28862 | 3 | |||
56879 | 67907 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | 9 | 7 | 4 | 28861 | 40 | ||
57052 | 220072 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002632.83888 | 2105513.14285 | 37.7614867382526 | -122.434015605341 | (37.7614867382526, -122.434015605341) | 15 | 4 | 5 | 28862 | 3 | |||
58105 | 220037 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4263 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002187.26734 | 2100592.35577 | 37.7479501382903 | -122.435204673663 | (37.7479501382903, -122.435204673663) | 2 | 4 | 5 | 63 | 22 | |||
58218 | 34625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) | 1 | 8 | 3 | 56 | 35 |
58697 | 45250 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.1880044 | 2098465.43898756 | 37.7417803963921 | -122.455027784646 | (37.7417803963921, -122.455027784646) | 9 | 7 | 4 | 59 | 40 | ||
58988 | 64511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 833 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 11 | Permit Number 25392 | 6000435.9873 | 2111865.4379 | 37.7788036283278 | -122.442069568781 | (37.7788036283278, -122.442069568781) | 15 | 5 | 11 | 29490 | 16 | |
59224 | 61737 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | 2 | 4 | 5 | 28862 | 22 | ||
59334 | 220047 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997716.00381 | 2106428.96316 | 37.7637210849721 | -122.451086869165 | (37.7637210849721, -122.451086869165) | 15 | 5 | 11 | 29492 | 9 | |||
59827 | 117033 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
59859 | 113028 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 101 WINFIELD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x5 | 6007142 | 2098801 | 37.7433115947954 | -122.417944411944 | (37.7433115947954, -122.417944411944) | 2 | 7 | 7 | 28859 | 2 | |||
59945 | 33582 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37690 | 6007165.20249785 | 2098095.43390853 | 37.7413755735349 | -122.417814180983 | (37.7413755735349, -122.417814180983) | 2 | 7 | 7 | 28859 | 2 | |||
60882 | 61342 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | 7 | 9 | 11 | 28852 | 10 | ||
60994 | 203664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999403.20337 | 2093610.52776 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | 9 | 7 | 4 | 28861 | 40 | |||
61503 | 64794 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | 2 | 7 | 5 | 63 | 22 | ||
61987 | 67673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969016 | -122.393277319642 | (37.733518969016, -122.393277319642) | 10 | 3 | 8 | 58 | 1 | ||
62285 | 203225 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993973.71625 | 2104850.02282 | 37.759170760037 | -122.463915566851 | (37.759170760037, -122.463915566851) | 1 | 5 | 4 | 56 | 12 | |||
62316 | 31180 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | 9 | 8 | 6 | 64 | 24 | ||
62359 | 61344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.427218716009 | (37.7748381087345, -122.427218716009) | 7 | 9 | 11 | 28852 | 10 | ||
62374 | 68758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32681 | 6004133.43114203 | 2105726.5811327 | 37.762157835439 | -122.428840893 | (37.762157835439, -122.428840893) | 8 | 4 | 5 | 28862 | 3 | ||
62902 | 43173 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 382 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42982 | 6005820.96717 | 2091946.15603 | 37.7244152778362 | -122.42202534829 | (37.7244152778362, -122.42202534829) | 9 | 7 | 7 | 309 | 5 | |
63154 | 203629 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | 9 | 7 | 4 | 59 | 40 | |||
63342 | 48833 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.434211402781 | (37.7535333013465, -122.434211402781) | 2 | 4 | 5 | 28862 | 22 | |||
63385 | 87024 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49965 | 6001199 | 2102605 | 37.7534202073623 | -122.438766252724 | (37.7534202073623, -122.438766252724) | 2 | 4 | 5 | 28862 | 22 | |||
63797 | 49970 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 577 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2003 12:00:00 AM | 3x3 | Permit Number 46721 | 5984701.98485126 | 2111935.6867193 | 37.7780873043924 | -122.496504036563 | (37.7780873043924, -122.496504036563) | 11 | 6 | 2 | 55 | 26 | ||
64191 | 51723 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1148 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2005 12:00:00 AM | Permit Number 47992 | 6008632.05923166 | 2101854.75826991 | 37.7517802835227 | -122.413008028247 | (37.7517802835227, -122.413008028247) | 2 | 4 | 7 | 28859 | 19 | ||
64202 | 253615 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221 | 2118816 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | 13 | 9 | 10 | 28858 | 32 | ||
64954 | 220029 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002428.99773 | 2102359.29201 | 37.7528154507744 | -122.434495098689 | (37.7528154507744, -122.434495098689) | 2 | 4 | 5 | 28862 | 22 | |||
64962 | 66113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | 7 | 9 | 11 | 29492 | 10 | ||
64977 | 34443 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.7405096935375 | -122.427643467723 | (37.7405096935375, -122.427643467723) | 2 | 7 | 5 | 63 | 7 | ||
65212 | 33257 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.487622710626 | (37.7377581609646, -122.487622710626) | 1 | 8 | 3 | 29491 | 35 | ||
65997 | 203662 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 337 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.444392887823 | (37.7304249920009, -122.444392887823) | 9 | 7 | 4 | 28861 | 40 | |||
66498 | 220060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.7519698479443 | -122.421950664996 | (37.7519698479443, -122.421950664996) | 2 | 4 | 5 | 28859 | 19 | |||
66532 | 67603 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216 | (37.7642517131045, -122.39677434216) | 14 | 3 | 8 | 28856 | 29 | ||
67846 | 51518 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.7317370088004 | -122.447203111837 | (37.7317370088004, -122.447203111837) | 9 | 7 | 4 | 59 | 40 | |||
67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
68143 | 31468 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 523 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 9 | Permit Number 35034 | 6002955.92893 | 2102097.86396 | 37.7521275287632 | -122.432654202633 | (37.7521275287632, -122.432654202633) | 2 | 4 | 5 | 28862 | 22 | |
68255 | 42696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | 5 | 1 | 10 | 28858 | 32 | |
68287 | 245868 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.7751317575952 | -122.426087670118 | (37.7751317575952, -122.426087670118) | 7 | 9 | 11 | 28852 | 10 | |||
68294 | 66858 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.577 | 2110362.2819 | 37.7745740983013 | -122.448158471707 | (37.7745740983013, -122.448158471707) | 15 | 5 | 11 | 29492 | 16 | ||
68402 | 220016 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.7455556250083 | -122.446286498542 | (37.7455556250083, -122.446286498542) | 2 | 7 | 5 | 63 | 22 | |||
68768 | 50067 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 408 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46795 | 6003569.75244558 | 2105901.71860795 | 37.7626068007008 | -122.430802940638 | (37.7626068007008, -122.430802940638) | 15 | 4 | 5 | 28862 | 3 | ||
68986 | 35558 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | 2 | 4 | 5 | 28859 | 19 | ||
69468 | 124758 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.7942702662113 | -122.419903713582 | (37.7942702662113, -122.419903713582) | 13 | 9 | 10 | 28858 | 32 | |||
69469 | 220695 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3706 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004965.60953 | 2102543.32238 | 37.7534644213631 | -122.425736121051 | (37.7534644213631, -122.425736121051) | 2 | 4 | 5 | 28862 | 22 | |||
70503 | 50653 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953359 | -122.452612074363 | (37.710694953359, -122.452612074363) | 9 | 7 | 6 | 28861 | 25 | |||
70512 | 64256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 191 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | 2 | 7 | 5 | 63 | 22 | ||
71243 | 50520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | 11 | 6 | 2 | 54 | 16 | |
71322 | 66256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | 9 | 7 | 4 | 59 | 40 | ||
72403 | 61747 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2016 12:00:00 AM | 3 | Permit Number 21753 | 6004950.72602956 | 2100792.08081868 | 37.7486550770793 | -122.425662958373 | (37.7486550770793, -122.425662958373) | 2 | 4 | 5 | 28862 | 22 | |
72507 | 35266 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.422306489847 | (37.798273260158, -122.422306489847) | 13 | 9 | 10 | 28858 | 32 |
73002 | 37857 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | ||
73126 | 45525 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1700 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2001 12:00:00 AM | Permit Number 44286 | 5999707.83752219 | 2110208.85696406 | 37.7742135578008 | -122.444469428603 | (37.7742135578008, -122.444469428603) | 15 | 5 | 11 | 29492 | 16 | |||
73895 | 84017 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50426 | 6002531.06648038 | 2102355.71188239 | 37.7528114140683 | -122.434141870719 | (37.7528114140683, -122.434141870719) | 2 | 4 | 5 | 28862 | 22 | ||
74457 | 38531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | 2 | 7 | 7 | 28859 | 2 | ||
75755 | 39220 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1143 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.7529009461356 | -122.422831161336 | (37.7529009461356, -122.422831161336) | 2 | 4 | 5 | 28859 | 19 | ||
76011 | 124753 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2109 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999833.99614 | 2116225.74938 | 37.7907415881946 | -122.444465538654 | (37.7907415881946, -122.444465538654) | 13 | 6 | 1 | 29490 | 27 | |||
76050 | 37317 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | 2 | 4 | 5 | 28862 | 22 | ||
76179 | 121723 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6001086 | 2095247 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | 9 | 7 | 5 | 63 | 40 | ||||
76223 | 33122 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.7985412065447 | -122.438525775033 | (37.7985412065447, -122.438525775033) | 13 | 9 | 1 | 57 | 17 | ||
76417 | 66117 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.7760279254083 | -122.430248650411 | (37.7760279254083, -122.430248650411) | 7 | 9 | 11 | 29492 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );