trees
3,965 rows where qSpecies_id = 70 sorted by Longitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64811 | 186915 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985160.3793 | 2096738.0161 | 37.7363855555031 | -122.493798079234 | (37.7363855555031, -122.493798079234) | 1 | 8 | 3 | 29491 | 35 | |||
5033 | 186921 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985168.1725 | 2096748.5598 | 37.7364149616327 | -122.493771912003 | (37.7364149616327, -122.493771912003) | 1 | 8 | 3 | 29491 | 35 | |||
189113 | 186913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985168.1725 | 2096717.3871 | 37.7363293697196 | -122.493769615567 | (37.7363293697196, -122.493769615567) | 1 | 8 | 3 | 29491 | 35 | |||
24647 | 186862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985163.1298 | 2096349.2748 | 37.7353183364912 | -122.493759932025 | (37.7353183364912, -122.493759932025) | 1 | 8 | 3 | 29491 | 35 | |||
98157 | 186916 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985173.6735 | 2096745.3508 | 37.7364064724097 | -122.493752656611 | (37.7364064724097, -122.493752656611) | 1 | 8 | 3 | 29491 | 35 | |||
89521 | 186896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985175.5072 | 2096596.8223 | 37.7359987600616 | -122.493735375196 | (37.7359987600616, -122.493735375196) | 1 | 8 | 3 | 29491 | 35 | |||
85723 | 186912 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985181.9251 | 2096714.1782 | 37.7363213635218 | -122.493721831405 | (37.7363213635218, -122.493721831405) | 1 | 8 | 3 | 29491 | 35 | |||
31929 | 186867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985177.3409 | 2096363.4859 | 37.7353581877907 | -122.493711846576 | (37.7353581877907, -122.493711846576) | 1 | 8 | 3 | 29491 | 35 | |||
140826 | 186883 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985186.5093 | 2096482.6754 | 37.735685986771 | -122.493688928468 | (37.735685986771, -122.493688928468) | 1 | 8 | 3 | 29491 | 35 | |||
68205 | 186870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985184.6756 | 2096368.5285 | 37.7353724625278 | -122.493686859622 | (37.7353724625278, -122.493686859622) | 1 | 8 | 3 | 29491 | 35 | |||
160432 | 186873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985190.6351 | 2096373.5712 | 37.7353866570824 | -122.493666627175 | (37.7353866570824, -122.493666627175) | 1 | 8 | 3 | 29491 | 35 | |||
94056 | 186869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985195.6777 | 2096363.4859 | 37.7353592605359 | -122.493648450371 | (37.7353592605359, -122.493648450371) | 1 | 8 | 3 | 29491 | 35 | |||
96341 | 186860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985194.9901 | 2096324.7493 | 37.7352528599252 | -122.493647974184 | (37.7352528599252, -122.493647974184) | 1 | 8 | 3 | 29491 | 35 | |||
168644 | 186937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985187.8383 | 2095962.6177 | 37.7342581245339 | -122.49364602471 | (37.7342581245339, -122.49364602471) | 1 | 8 | 3 | 29491 | 35 | |||
153278 | 186863 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985198.4283 | 2096348.358 | 37.7353178842658 | -122.493637826308 | (37.7353178842658, -122.493637826308) | 1 | 8 | 3 | 29491 | 35 | |||
19486 | 186864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.7204 | 2096355.2343 | 37.7353368988439 | -122.493630408308 | (37.7353368988439, -122.493630408308) | 1 | 8 | 3 | 29491 | 35 | |||
169723 | 186934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985194.2284 | 2095945.4652 | 37.7342114021566 | -122.493622668946 | (37.7342114021566, -122.493622668946) | 1 | 8 | 3 | 29491 | 35 | |||
4276 | 186874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 23 | Median : Yard | Tree | DPW 1 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | 1 | 8 | 3 | 29491 | 35 | |||
56374 | 186953 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985200.1141 | 2096083.1893 | 37.7345899002243 | -122.49361246529 | (37.7345899002243, -122.49361246529) | 1 | 8 | 3 | 29491 | 35 | |||
162035 | 186872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985206.6799 | 2096372.1959 | 37.7353838195134 | -122.493611053822 | (37.7353838195134, -122.493611053822) | 1 | 8 | 3 | 29491 | 35 | |||
93607 | 186932 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.2822 | 2095936.7208 | 37.7341877465081 | -122.493601095228 | (37.7341877465081, -122.493601095228) | 1 | 8 | 3 | 29491 | 35 | |||
134219 | 186871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985209.8888 | 2096365.778 | 37.7353663853906 | -122.493599486872 | (37.7353663853906, -122.493599486872) | 1 | 8 | 3 | 29491 | 35 | |||
174380 | 186952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 26 | Median : Yard | Tree | DPW 1 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.7345689363213 | -122.493595616872 | (37.7345689363213, -122.493595616872) | 1 | 8 | 3 | 29491 | 35 | |||
113691 | 186956 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985210.8764 | 2096098.6602 | 37.7346330087924 | -122.493576396522 | (37.7346330087924, -122.493576396522) | 1 | 8 | 3 | 29491 | 35 | |||
8592 | 186947 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985208.6903 | 2095991.5414 | 37.7343387611716 | -122.493576064205 | (37.7343387611716, -122.493576064205) | 1 | 8 | 3 | 29491 | 35 | |||
46787 | 186933 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985210.7082 | 2095939.4114 | 37.734195744096 | -122.493565247951 | (37.734195744096, -122.493565247951) | 1 | 8 | 3 | 29491 | 35 | |||
132027 | 186948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985216.762 | 2096002.3037 | 37.7343687837711 | -122.493548950858 | (37.7343687837711, -122.493548950858) | 1 | 8 | 3 | 29491 | 35 | |||
119209 | 186957 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985219.2845 | 2096104.714 | 37.734650122781 | -122.493547773215 | (37.734650122781, -122.493547773215) | 1 | 8 | 3 | 29491 | 35 | |||
98024 | 186945 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985218.4436 | 2095979.0975 | 37.7343051640866 | -122.493541427788 | (37.7343051640866, -122.493541427788) | 1 | 8 | 3 | 29491 | 35 | |||
110731 | 186949 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985222.3114 | 2096011.5526 | 37.7343945034212 | -122.493530446304 | (37.7343945034212, -122.493530446304) | 1 | 8 | 3 | 29491 | 35 | |||
70664 | 186942 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985223.4885 | 2095964.6356 | 37.7342657506702 | -122.493522920975 | (37.7342657506702, -122.493522920975) | 1 | 8 | 3 | 29491 | 35 | |||
11390 | 186929 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985223.4885 | 2095932.3487 | 37.7341770994248 | -122.493520542824 | (37.7341770994248, -122.493520542824) | 1 | 8 | 3 | 29491 | 35 | |||
64781 | 186950 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985227.0199 | 2096064.0189 | 37.7345388373659 | -122.493518032223 | (37.7345388373659, -122.493518032223) | 1 | 8 | 3 | 29491 | 35 | |||
161723 | 186944 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985227.8607 | 2095981.1154 | 37.7343112555829 | -122.493509018941 | (37.7343112555829, -122.493509018941) | 1 | 8 | 3 | 29491 | 35 | |||
65084 | 186946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985228.197 | 2095990.1961 | 37.7343362084437 | -122.493508525113 | (37.7343362084437, -122.493508525113) | 1 | 8 | 3 | 29491 | 35 | |||
160513 | 186927 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985227.188 | 2095919.2321 | 37.7341413011385 | -122.493506786548 | (37.7341413011385, -122.493506786548) | 1 | 8 | 3 | 29491 | 35 | |||
86660 | 186928 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985229.8786 | 2095924.6132 | 37.7341562336013 | -122.493497880781 | (37.7341562336013, -122.493497880781) | 1 | 8 | 3 | 29491 | 35 | |||
136611 | 186943 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985231.8966 | 2095978.7612 | 37.734305027664 | -122.493494892334 | (37.734305027664, -122.493494892334) | 1 | 8 | 3 | 29491 | 35 | |||
93704 | 186936 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985232.9055 | 2095957.9092 | 37.7342478326321 | -122.493489868422 | (37.7342478326321, -122.493489868422) | 1 | 8 | 3 | 29491 | 35 | |||
185899 | 120950 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5985459.2715 | 2102315.3249 | 37.7517168221741 | -122.493175446174 | (37.7517168221741, -122.493175446174) | 1 | 8 | 3 | 56 | 35 | |||
188801 | 120949 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5985472.8534 | 2102314.8398 | 37.7517162845821 | -122.493128443109 | (37.7517162845821, -122.493128443109) | 1 | 8 | 3 | 56 | 35 | |||
53120 | 3431 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 7050X California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | 11 | 6 | 1 | 55 | 33 | |||
73336 | 256346 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
154920 | 256347 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Sunset Blvd | 26 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
72979 | 258065 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3233 Irving St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5985670 | 2106323 | 37.7627331150852 | -122.492741876307 | (37.7627331150852, -122.492741876307) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
58285 | 119404 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5985884.36783 | 2113621.15402 | 37.7827843125196 | -122.492537964656 | (37.7827843125196, -122.492537964656) | 11 | 6 | 2 | 55 | 26 | |||
80184 | 119403 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5985885.52605 | 2113633.58545 | 37.782818513363 | -122.492534873565 | (37.782818513363, -122.492534873565) | 11 | 6 | 2 | 55 | 26 | |||
82170 | 119405 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5985885.41381 | 2113607.34088 | 37.7827464467742 | -122.492533328464 | (37.7827464467742, -122.492533328464) | 11 | 6 | 2 | 55 | 26 | |||
165767 | 181633 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1258 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 0ft | 5985863.7631 | 2106655.7682 | 37.7636581322222 | -122.492096230524 | (37.7636581322222, -122.492096230524) | 1 | 8 | 3 | 56 | 35 | |||
82075 | 182538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1587 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5985892.0188 | 2104435.802 | 37.7575643717373 | -122.491835062108 | (37.7575643717373, -122.491835062108) | 1 | 8 | 3 | 56 | 35 | |||
117660 | 250805 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 279 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5986180.52669 | 2114067.55703 | 37.784027318145 | -122.491546263649 | (37.784027318145, -122.491546263649) | 11 | 6 | 1 | 55 | 33 | |||
20506 | 250806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 279 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5986182.48717 | 2114056.18318 | 37.7839962033991 | -122.491538643706 | (37.7839962033991, -122.491538643706) | 11 | 6 | 1 | 55 | 33 | |||
173722 | 250672 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781557 | 5986349.68151 | 2114864.86182 | 37.7862263710027 | -122.491019750162 | (37.7862263710027, -122.491019750162) | 11 | 6 | 1 | 55 | 33 | |
63654 | 99198 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986369 | 2114825 | 37.786118050599 | -122.490949979792 | (37.786118050599, -122.490949979792) | 11 | 6 | 1 | 55 | 33 | |||||
142260 | 119514 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 741 31st Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5986354.98287 | 2110811.50583 | 37.775097324761 | -122.490703064954 | (37.775097324761, -122.490703064954) | 11 | 6 | 2 | 55 | 26 | ||||
33055 | 250847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5986528.24832 | 2114250.81305 | 37.7845508009207 | -122.490356775353 | (37.7845508009207, -122.490356775353) | 11 | 6 | 1 | 55 | 33 | |||
35200 | 250846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 4ft | 5986528.43338 | 2114238.12689 | 37.7845159791832 | -122.490355201546 | (37.7845159791832, -122.490355201546) | 11 | 6 | 1 | 55 | 33 | |||
76768 | 250845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 236 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986530.26367 | 2114217.25301 | 37.7844587724096 | -122.490347333357 | (37.7844587724096, -122.490347333357) | 11 | 6 | 1 | 55 | 33 | |||
42097 | 250843 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 242 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986531.75481 | 2114201.82149 | 37.7844164889825 | -122.490341039004 | (37.7844164889825, -122.490341039004) | 11 | 6 | 1 | 55 | 33 | |||
32544 | 105274 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
84707 | 105273 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
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 | ||||
85283 | 181806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5986469.7425 | 2099569.8124 | 37.7442374331929 | -122.489479287744 | (37.7442374331929, -122.489479287744) | 1 | 8 | 3 | 29491 | 35 | |||
185330 | 183773 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2042 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5986479.3356 | 2099626.2145 | 37.7443928582813 | -122.489450263799 | (37.7443928582813, -122.489450263799) | 1 | 8 | 3 | 29491 | 35 | |||
22035 | 185597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5986575.4427 | 2100993.2848 | 37.748152076203 | -122.489218440489 | (37.748152076203, -122.489218440489) | 1 | 8 | 3 | 29491 | 35 | |||
63405 | 185596 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5986592.7914 | 2100992.1774 | 37.7481500482316 | -122.48915836867 | (37.7481500482316, -122.48915836867) | 1 | 8 | 3 | 29491 | 35 | |||
47372 | 185595 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5986609.4018 | 2100992.9157 | 37.7481530449315 | -122.489100985509 | (37.7481530449315, -122.489100985509) | 1 | 8 | 3 | 29491 | 35 | |||
81400 | 116419 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1225 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5986738.0534 | 2106874.4884 | 37.7643097456723 | -122.489088454501 | (37.7643097456723, -122.489088454501) | 1 | 8 | 3 | 56 | 35 | |||
176014 | 116418 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1241 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5986739.8244 | 2106811.9125 | 37.7641380329526 | -122.48907772846 | (37.7641380329526, -122.48907772846) | 1 | 8 | 3 | 56 | 35 | |||
176765 | 181613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1257 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986743.9567 | 2106714.2116 | 37.7638700145218 | -122.489056253107 | (37.7638700145218, -122.489056253107) | 1 | 8 | 3 | 56 | 35 | |||
126463 | 181339 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1244 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5986791.6745 | 2106769.7073 | 37.7640251753545 | -122.488895293642 | (37.7640251753545, -122.488895293642) | 1 | 8 | 3 | 56 | 35 | |||
170541 | 181631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1266 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5986795.2178 | 2106670.4956 | 37.7637529742716 | -122.488875745058 | (37.7637529742716, -122.488875745058) | 1 | 8 | 3 | 56 | 35 | |||
57438 | 183599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 116 Escolta Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986611.9824 | 2097255.1837 | 37.7378903813657 | -122.488817350509 | (37.7378903813657, -122.488817350509) | 1 | 8 | 3 | 29491 | 35 | |||
26461 | 183598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 116 Escolta Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986616.6908 | 2097250.4752 | 37.7378777278495 | -122.488800725476 | (37.7378777278495, -122.488800725476) | 1 | 8 | 3 | 29491 | 35 | |||
66790 | 183383 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Escolta Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5986644.7173 | 2097225.5877 | 37.737811028918 | -122.488701996679 | (37.737811028918, -122.488701996679) | 1 | 8 | 3 | 29491 | 35 | |||
157972 | 250722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5987022.28567 | 2114476.78778 | 37.7852001042432 | -122.488664211695 | (37.7852001042432, -122.488664211695) | 11 | 6 | 1 | 55 | 33 | |||
32504 | 182250 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1446 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5986839.9658 | 2105413.0196 | 37.7603029032992 | -122.488628546405 | (37.7603029032992, -122.488628546405) | 1 | 8 | 3 | 56 | 35 | |||
171839 | 182253 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1462 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5986843.6409 | 2105313.4236 | 37.7600296545051 | -122.488608515704 | (37.7600296545051, -122.488608515704) | 1 | 8 | 3 | 56 | 35 | |||
86586 | 182252 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1462 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5986843.6409 | 2105302.7657 | 37.7600003908394 | -122.488607732339 | (37.7600003908394, -122.488607732339) | 1 | 8 | 3 | 56 | 35 | |||
85981 | 181922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2392 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986744.7102 | 2099010.2319 | 37.742717022992 | -122.488487403006 | (37.742717022992, -122.488487403006) | 1 | 8 | 3 | 29491 | 35 | |||
186120 | 181921 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986744.7102 | 2098996.695 | 37.7426798542726 | -122.488486408325 | (37.7426798542726, -122.488486408325) | 1 | 8 | 3 | 29491 | 35 | |||
52222 | 181923 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2394 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986746.4023 | 2099044.7509 | 37.7428119016984 | -122.488484088714 | (37.7428119016984, -122.488484088714) | 1 | 8 | 3 | 29491 | 35 | |||
36738 | 181920 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986747.0792 | 2098981.8045 | 37.7426391071586 | -122.488477122978 | (37.7426391071586, -122.488477122978) | 1 | 8 | 3 | 29491 | 35 | |||
130118 | 183381 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986717.8198 | 2097243.0342 | 37.7378631981114 | -122.488450531073 | (37.7378631981114, -122.488450531073) | 1 | 8 | 3 | 29491 | 35 | |||
134775 | 183382 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986718.0062 | 2097232.4085 | 37.7378340336236 | -122.488449105903 | (37.7378340336236, -122.488449105903) | 1 | 8 | 3 | 29491 | 35 | |||
21261 | 55934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1973 12:00:00 AM | 9 | Permit Number 11998 | 5986719.3111 | 2097252.7279 | 37.7378899014651 | -122.488446087215 | (37.7378899014651, -122.488446087215) | 1 | 8 | 3 | 29491 | 35 | ||
178154 | 184112 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1602 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5986874.2106 | 2104324.0911 | 37.7573150023067 | -122.488430080938 | (37.7573150023067, -122.488430080938) | 1 | 8 | 3 | 56 | 35 | |||
21920 | 184111 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1604 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5986875.3953 | 2104311.06 | 37.7572792915924 | -122.488425026161 | (37.7572792915924, -122.488425026161) | 1 | 8 | 3 | 56 | 35 | |||
169206 | 181919 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986766.2 | 2098960.6531 | 37.742582146722 | -122.488409455551 | (37.742582146722, -122.488409455551) | 1 | 8 | 3 | 29491 | 35 | |||
51747 | 184113 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986890.7956 | 2104347.1916 | 37.7573793976552 | -122.4883744219 | (37.7573793976552, -122.4883744219) | 1 | 8 | 3 | 56 | 35 | |||
27780 | 250630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5987115.47488 | 2114730.85404 | 37.7859031348758 | -122.488360488171 | (37.7859031348758, -122.488360488171) | 11 | 6 | 1 | 55 | 33 | |||
3359 | 250631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 4ft | 5987117.30977 | 2114718.25139 | 37.7858686386749 | -122.488353213533 | (37.7858686386749, -122.488353213533) | 11 | 6 | 1 | 55 | 33 | ||
87539 | 181918 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986786.8437 | 2098961.33 | 37.7425852097978 | -122.488338126362 | (37.7425852097978, -122.488338126362) | 1 | 8 | 3 | 29491 | 35 |
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) );