trees
3,965 rows where qSpecies_id = 70 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
140113 | 99600 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
140352 | 111337 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.473689301 | (37.7473430166558, -122.473689301) | 1 | 8 | 4 | 29491 | 40 | |
140579 | 109579 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 290x ARKANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012903 | 2105890 | 37.7630990003622 | -122.398521567136 | (37.7630990003622, -122.398521567136) | 14 | 3 | 8 | 28856 | 29 | |||
141812 | 98111 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999464.5 | 2115932.3 | 37.7899147638046 | -122.445722859438 | (37.7899147638046, -122.445722859438) | 13 | 6 | 1 | 29490 | 27 | ||||
141970 | 24924 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2199X Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | |||
143643 | 51624 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 25 Short St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101 | (37.7576271269874, -122.44286268101) | 2 | 4 | 5 | 28862 | 3 | |||
143973 | 32034 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
145334 | 13155 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.432180313982 | (37.8000494585448, -122.432180313982) | 13 | 9 | 1 | 57 | 17 | |||
145664 | 44211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1466 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43658 | 5990873.69248126 | 2105421.34105709 | 37.76056030978 | -122.474678523283 | (37.76056030978, -122.474678523283) | 1 | 8 | 4 | 56 | 12 | ||||
145746 | 11787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
147326 | 113989 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||||
147887 | 97258 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
148043 | 52878 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
148901 | 98921 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6000893.4 | 2109236.7 | 37.7716118335785 | -122.440298633253 | (37.7716118335785, -122.440298633253) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||
150637 | 14999 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1459X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
151451 | 49595 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1442 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46465 | 6005191.43444841 | 2099927.58829524 | 37.7462949778276 | -122.424769098336 | (37.7462949778276, -122.424769098336) | 2 | 7 | 5 | 63 | 22 | ||||
151507 | 112490 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | ||
152891 | 11815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
152984 | 11820 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
153430 | 104809 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 685 Marina Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | 13 | 9 | 1 | 57 | 17 | ||||
153545 | 13067 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 610 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.4116574143 | (37.803155386878, -122.4116574143) | 3 | 1 | 10 | 308 | 23 | |||
155772 | 6824 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
155994 | 99599 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
156355 | 36261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256484 | 37.7307369236006 | -122.472799488507 | (37.7307369236006, -122.472799488507) | 9 | 8 | 4 | 64 | 40 | ||
156825 | 99905 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
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 | |||
158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
159769 | 97889 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | 15 | 9 | 5 | 29492 | 10 | ||||
160018 | 24148 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | |||
161438 | 43868 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2005 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2000 12:00:00 AM | Permit Number 43485 | 6003969.62438381 | 2117970.99363298 | 37.7957686854896 | -122.430281044713 | (37.7957686854896, -122.430281044713) | 13 | 9 | 1 | 29490 | 27 | |||
161863 | 98758 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768795 | 6001830.6 | 2121663 | 37.8057845723141 | -122.437947027917 | (37.8057845723141, -122.437947027917) | 13 | 9 | 1 | 57 | 17 | |||
162472 | 99605 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
162549 | 99856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
162685 | 103476 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | 13 | 9 | 1 | 57 | 17 | |||
162752 | 5435 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
163441 | 30291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
164247 | 105787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 67- 69 CASA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 9x3 | Permit Number 773990 | 6001454.5 | 2121609.5 | 37.8056162809509 | -122.439244738513 | (37.8056162809509, -122.439244738513) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
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 | |||
165347 | 50952 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2340 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | Permit Number 47446 | 5992662.95043522 | 2099457.88176019 | 37.7442897076886 | -122.468056556621 | (37.7442897076886, -122.468056556621) | 1 | 8 | 4 | 29491 | 40 | |||
166143 | 50732 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1238 08TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | Permit Number 47282 | 5993659.1 | 2107052.1 | 37.7651989529315 | -122.465163596685 | (37.7651989529315, -122.465163596685) | 11 | 8 | 11 | 56 | 12 | |||
167049 | 50100 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1520 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.468559868986 | (37.7372891525979, -122.468559868986) | 1 | 8 | 4 | 59 | 40 | ||
167696 | 11773 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||||
170016 | 102630 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988081.5 | 2114873.1 | 37.7863500177909 | -122.485028789744 | (37.7863500177909, -122.485028789744) | 11 | 6 | 1 | 55 | 33 | |||||
170281 | 30332 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1783 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1956 12:00:00 AM | Permit Number 23 | 5983455.10471621 | 2103020.95546664 | 37.7535368651178 | -122.5001581692 | (37.7535368651178, -122.5001581692) | 1 | 8 | 3 | 56 | 35 | |||
171407 | 23573 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6005485.55606 | 2120793.85256 | 37.8036052836839 | -122.425236606678 | (37.8036052836839, -122.425236606678) | 13 | 9 | 1 | 28858 | 17 | |||
171881 | 55211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.7812686237346 | -122.443721790146 | (37.7812686237346, -122.443721790146) | 15 | 5 | 1 | 29490 | 16 | |||
173334 | 32419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
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 | ||||
175870 | 30854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
178622 | 100392 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
179699 | 32031 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
179775 | 48496 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2002 12:00:00 AM | Permit Number 45837 | 6001939.6131076 | 2108727.84798346 | 37.7702741635264 | -122.436643297557 | (37.7702741635264, -122.436643297557) | 15 | 5 | 5 | 29492 | 9 | |||
181398 | 49321 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 595 Marina Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
182129 | 53040 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | 2 | 4 | 5 | 28859 | 19 | ||
182952 | 30857 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||||
184283 | 99907 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
185981 | 50107 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.7369894427575 | -122.468964178249 | (37.7369894427575, -122.468964178249) | 1 | 8 | 4 | 59 | 40 | ||
186202 | 32032 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
186647 | 99603 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
186981 | 30853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
187450 | 31198 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 31 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34890 | 5998547.5134992 | 2106873.34897224 | 37.7649888273068 | -122.448242947738 | (37.7649888273068, -122.448242947738) | 15 | 5 | 11 | 29492 | 9 | ||||
189327 | 24933 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
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 | |
189388 | 99899 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||
189714 | 99906 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
190247 | 51623 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 25 Short St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101 | (37.7576271269874, -122.44286268101) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | |
191472 | 34879 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | 6 | 2 | 9 | 28855 | 6 | ||||
191606 | 39248 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
1875 | 261661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 741 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 5986614 | 2110873 | 37.7752812973329 | -122.489811603249 | (37.7752812973329, -122.489811603249) | 11 | 6 | 2 | 55 | 26 | ||||
3682 | 261986 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Bancroft Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | |||||
3798 | 262575 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Topaz Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001722 | 2097902 | 37.7405366227001 | -122.436621002014 | (37.7405366227001, -122.436621002014) | 2 | 7 | 5 | 63 | 7 | |||||
5712 | 258876 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Hayes St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 0ft | 6001504 | 2110473 | 37.7750411502564 | -122.438275119801 | (37.7750411502564, -122.438275119801) | 15 | 5 | 11 | 29492 | 10 | ||||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 | |||
33143 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 4 | 59 | 40 | |||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
54660 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
60308 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993700.7 | 2097327 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | 1 | 8 | 4 | 59 | 40 | |||||
61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 |
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) );