trees
3,965 rows where qSpecies_id = 70 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 10 | 3 | 8 | 58 | 1 | ||
28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
163065 | 97223 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | 10 | 3 | 8 | 58 | 1 | ||
166809 | 97222 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | |||
88312 | 97090 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2756 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6002131.41317 | 2117668.55194 | 37.7948339684692 | -122.436619923275 | (37.7948339684692, -122.436619923275) | 13 | 9 | 1 | 29490 | 27 | |||
174589 | 97089 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2756 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6002122.15814 | 2117670.11356 | 37.7948377303266 | -122.436652058756 | (37.7948377303266, -122.436652058756) | 13 | 9 | 1 | 29490 | 27 | |||
37644 | 96907 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 390X 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 9x6 | 6003983.7 | 2100148 | 37.7468318900011 | -122.428961010832 | (37.7468318900011, -122.428961010832) | 2 | 7 | 5 | 63 | 22 | |||
101546 | 96646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
164381 | 96645 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
158853 | 96630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6016481.76683 | 2097857.04453 | 37.7412409044377 | -122.385583836944 | (37.7412409044377, -122.385583836944) | 10 | 3 | 8 | 58 | 1 | |||
153939 | 96536 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
119214 | 96535 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
141047 | 96534 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
36882 | 96532 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
133315 | 96531 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
16020 | 96530 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
66241 | 96357 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | ||||
77387 | 96356 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | |||
121802 | 96216 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
46043 | 96215 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 26 | 4x4 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
68625 | 96214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 3x3 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
98383 | 96212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
45359 | 96211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
17687 | 95675 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2207 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6x6 | 6001981.9652 | 2114296.4072 | 37.7855664339568 | -122.436895509024 | (37.7855664339568, -122.436895509024) | 13 | 6 | 11 | 29490 | 13 | |||
22904 | 95659 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 499@Cervantes Marina Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000674 | 2121505 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | 13 | 9 | 1 | 57 | 17 | |||
124560 | 95658 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 499@Cervantes Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000674 | 2121505 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | 13 | 9 | 1 | 57 | 17 | |||
91547 | 95374 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999358 | 2120844 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | 13 | 9 | 1 | 57 | 17 | |||||
40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
38215 | 95363 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 3x3 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | ||
148170 | 95362 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | ||
142765 | 95361 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 10 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
112086 | 95360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
141758 | 95359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
157769 | 95358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 25 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
68655 | 95330 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 771 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x4.5 | 6002023 | 2108753 | 37.7703479631409 | -122.436356663462 | (37.7703479631409, -122.436356663462) | 15 | 5 | 5 | 29492 | 9 | |||
122339 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
61054 | 95204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000344.57367 | 2117164.06236 | 37.7933470689532 | -122.442766376677 | (37.7933470689532, -122.442766376677) | 13 | 9 | 1 | 57 | 27 | |||
109464 | 94916 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1922 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | 1 | 8 | 4 | 29491 | 12 | ||||
49173 | 94915 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1922 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 16 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | 1 | 8 | 4 | 29491 | 12 | |||
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
174908 | 94796 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5987953.6 | 2114461.6 | 37.7852127054212 | -122.485441077382 | (37.7852127054212, -122.485441077382) | 11 | 6 | 2 | 55 | 26 | ||||
114544 | 94795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.7851666498848 | -122.485198457494 | (37.7851666498848, -122.485198457494) | 11 | 6 | 2 | 55 | 26 | |
62131 | 94648 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | ||||
133480 | 94646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Middle Point Rd | 35 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
175371 | 94602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.94586 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | 13 | 9 | 1 | 57 | 27 | ||
34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
26266 | 9406 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6001730.26656 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) | 2 | 7 | 5 | 63 | 7 | |||
40440 | 9405 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 473 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6001706.5922 | 2097649.68492 | 37.7398429487944 | -122.436656219905 | (37.7398429487944, -122.436656219905) | 2 | 7 | 5 | 63 | 7 | |||
109892 | 9404 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 467 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001682.49889 | 2097629.47548 | 37.7397860891552 | -122.436738078025 | (37.7397860891552, -122.436738078025) | 2 | 7 | 5 | 63 | 7 | |||
170689 | 9403 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 461 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1998 12:00:00 AM | 6 | 3x3 | 6001657.4794 | 2097610.87801 | 37.7397336029134 | -122.436823253716 | (37.7397336029134, -122.436823253716) | 2 | 7 | 5 | 63 | 7 | ||
159539 | 9402 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 455 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001635.08411 | 2097595.41214 | 37.7396898644026 | -122.43689958007 | (37.7396898644026, -122.43689958007) | 2 | 7 | 5 | 63 | 7 | |||
107944 | 9393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 425 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001396.09892 | 2097471.96881 | 37.7393373319396 | -122.437717048529 | (37.7393373319396, -122.437717048529) | 2 | 7 | 5 | 63 | 7 | |||
83243 | 9391 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 419 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001359.02907 | 2097474.01092 | 37.7393408312224 | -122.437845365595 | (37.7393408312224, -122.437845365595) | 2 | 7 | 5 | 63 | 7 | |||
11723 | 93875 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997572 | 2107825 | 37.7675460011803 | -122.451685641377 | (37.7675460011803, -122.451685641377) | 15 | 5 | 11 | 29492 | 9 | |||||
85626 | 9376 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 312 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/1992 12:00:00 AM | 35 | 2X2 | 6001090.99664 | 2097832.55819 | 37.7403100728411 | -122.438797787215 | (37.7403100728411, -122.438797787215) | 2 | 7 | 5 | 63 | 7 | ||
74212 | 93121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | 11 | 6 | 1 | 54 | 31 | ||
161712 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | 9 | 7 | 4 | 59 | 40 | ||||
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
104618 | 92788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | 15 | 5 | 5 | 29492 | 3 | |||
186118 | 91400 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | 11 | 6 | 1 | 54 | 31 | |
79529 | 91061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.7938265856891 | -122.437816473953 | (37.7938265856891, -122.437816473953) | 13 | 9 | 1 | 29490 | 27 | |
175572 | 89458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.87116 | 37.7781711994801 | -122.485874733482 | (37.7781711994801, -122.485874733482) | 11 | 6 | 2 | 55 | 26 | ||
150425 | 89312 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
192979 | 89262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Polk St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||||
158472 | 89213 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
133602 | 89212 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
70861 | 89211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
138773 | 88989 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51741 | 5997688 | 2111682 | 37.7781429711136 | -122.451562655149 | (37.7781429711136, -122.451562655149) | 15 | 6 | 2 | 54 | 16 | ||||
39912 | 88823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51710 | 5998275 | 2110294 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | 15 | 5 | 11 | 29492 | 16 | ||||
95376 | 88602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155 | (37.7639914803102, -122.45650607155) | 15 | 5 | 11 | 29492 | 12 | |||
171472 | 88460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999588.65387 | 2118008.60001 | 37.7956228231833 | -122.445442657457 | (37.7956228231833, -122.445442657457) | 13 | 9 | 1 | 57 | 17 | |
128012 | 88459 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999585.78852 | 2118019.58187 | 37.795652812882 | -122.445453362079 | (37.795652812882, -122.445453362079) | 13 | 9 | 1 | 57 | 17 | |
71424 | 88458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 19 | 3x3 | Permit Number 51419 | 5999585.28862 | 2118036.11604 | 37.7956981827846 | -122.445456281295 | (37.7956981827846, -122.445456281295) | 13 | 9 | 1 | 57 | 17 | |
104514 | 87964 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
105134 | 87963 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
66217 | 87839 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
88938 | 87293 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
123206 | 87292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
25335 | 87291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
71908 | 87252 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.7098574142528 | -122.414638464087 | (37.7098574142528, -122.414638464087) | 9 | 7 | 8 | 309 | 39 | |||
13825 | 87087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | 13 | 6 | 1 | 29490 | 27 | ||
49696 | 87086 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50031 | 6002046 | 2118096 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | 13 | 9 | 1 | 57 | 17 | |||
150374 | 87050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | 6 | 2 | 9 | 28856 | 34 | ||
46769 | 87049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | 6 | 2 | 9 | 28856 | 34 | |
81766 | 87010 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
2063 | 87007 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
25512 | 87006 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
174127 | 87005 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
50374 | 87004 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
164945 | 87003 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
5419 | 87002 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | ||
63703 | 86887 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Casa Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.438963625045 | (37.8057359986938, -122.438963625045) | 13 | 9 | 1 | 57 | 17 | ||||
88134 | 8616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999337.0471 | 2113224.2861 | 37.7824719871656 | -122.445968980903 | (37.7824719871656, -122.445968980903) | 15 | 5 | 1 | 54 | 16 | |||
168560 | 85508 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
183443 | 85504 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
77073 | 85503 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 |
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) );