trees

3,965 rows where qSpecies_id = 70 sorted by Longitude descending

✎ View and edit SQL

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)
142865 118402 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5981581.19272 2111336.44811 37.7762586467108 -122.50725532177 (37.7762586467108, -122.50725532177) 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
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
38892 183276 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1258 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5982450.6111 2106538.8 37.7631368622084 -122.503892396491 (37.7631368622084, -122.503892396491) 1 8 3 56 35
53586 113984 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 538 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     28 3x3   5982879.61718 2112112.63686 37.7784662262945 -122.502821259971 (37.7784662262945, -122.502821259971) 11 6 2 55 26
96448 182905 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2721 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5982744.7337 2096592.2081 37.7358435812589 -122.502139054485 (37.7358435812589, -122.502139054485) 1 8 3 29491 35
155444 184513 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5983187.3894 2101698.6547 37.7498904791156 -122.500986185338 (37.7498904791156, -122.500986185338) 1 8 3 29491 35
18624 184510 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5983188.0663 2101709.4842 37.7499202536606 -122.500984645445 (37.7499202536606, -122.500984645445) 1 8 3 29491 35
88064 184511 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5983188.0663 2101701.7005 37.7498988817819 -122.500984069855 (37.7498988817819, -122.500984069855) 1 8 3 29491 35
27003 184514 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5983188.0663 2101693.9168 37.749877509903 -122.500983494265 (37.749877509903, -122.500983494265) 1 8 3 29491 35
151276 184512 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5983188.7431 2101700.3468 37.7498952046369 -122.500981629383 (37.7498952046369, -122.500981629383) 1 8 3 29491 35
38796 183644 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1479 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   5983388.9318 2105088.2135 37.7592090919823 -122.500539849248 (37.7592090919823, -122.500539849248) 1 8 3 56 35
125951 59324 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1370 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/2012 12:00:00 AM 1   Permit Number 769281 5983406.5406 2105829.5951 37.761245750287 -122.500533768842 (37.761245750287, -122.500533768842) 1 8 3 56 35
64061 184149 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1587 41st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5983414.0938 2104358.5155 37.7572070235512 -122.500398877559 (37.7572070235512, -122.500398877559) 1 8 3 56 35
183464 183320 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3921 Lincoln Way 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 0ft   5983535.7378 2106954.4614 37.7643418979877 -122.500170098294 (37.7643418979877, -122.500170098294) 1 8 3 56 35
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
89138 183318 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3915 Lincoln Way 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5983544.4671 2106954.7342 37.764343159359 -122.50013992674 (37.764343159359, -122.50013992674) 1 8 3 56 35
181130 183319 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3915 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5983558.1066 2106954.4614 37.7643432108416 -122.500092732113 (37.7643432108416, -122.500092732113) 1 8 3 56 35
194163 183710 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1205 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   5984255.4943 2106945.8685 37.7643605222858 -122.497680065967 (37.7643605222858, -122.497680065967) 1 8 3 56 35
86874 118211 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 822 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5984502.17858 2110227.24681 37.7733847121042 -122.497069091186 (37.7733847121042, -122.497069091186) 11 6 2 55 26
76246 118057 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 7 Sidewalk: Curb side : Yard Tree Private 2     17 Width 5ft   5984725.24308 2112619.58056 37.7799664419397 -122.496474057045 (37.7799664419397, -122.496474057045) 11 6 2 55 26
40131 113088 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5984725.43026 2112610.82785 37.7799424204954 -122.496472763467 (37.7799424204954, -122.496472763467) 11 6 2 55 26
68783 113087 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5984726.14635 2112591.82566 37.7798902879287 -122.496468883656 (37.7798902879287, -122.496468883656) 11 6 2 55 26
152626 113086 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5984727.03316 2112580.82435 37.7798601334655 -122.496465003816 (37.7798601334655, -122.496465003816) 11 6 2 55 26
188036 113085 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   5984727.7654 2112562.56652 37.7798100456413 -122.496461123088 (37.7798100456413, -122.496461123088) 11 6 2 55 26
85634 51571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3 Permit Number 47868 5984728.58104 2112539.46721 37.779746669398 -122.4964565965 (37.779746669398, -122.4964565965) 11 6 2 55 26
74199 764 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X 37th Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3   5984614.2914 2106873.7688 37.7641835827447 -122.496433785178 (37.7641835827447, -122.496433785178) 1 8 3 56 35
78454 118056 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 8 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   5984738.41738 2112623.76679 37.7799787079086 -122.49642879092 (37.7799787079086, -122.49642879092) 11 6 2 55 26
137077 113089 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 494 36th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5984740.35768 2112618.32743 37.7799638866667 -122.496421677178 (37.7799638866667, -122.496421677178) 11 6 2 55 26
105517 184809 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1250 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   5984621.3412 2106632.1075 37.7635204618116 -122.496391569493 (37.7635204618116, -122.496391569493) 1 8 3 56 35
157857 184857 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984627.4167 2106843.4213 37.7641010259615 -122.496386149808 (37.7641010259615, -122.496386149808) 1 8 3 56 35
183450 184855 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984629.3153 2106852.5345 37.7641261594658 -122.496380255685 (37.7641261594658, -122.496380255685) 1 8 3 56 35
153269 184835 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984633.1125 2106875.3177 37.764188938163 -122.496368803682 (37.764188938163, -122.496368803682) 1 8 3 56 35
169544 184854 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984632.7328 2106851.7751 37.764124274568 -122.496368379685 (37.764124274568, -122.496368379685) 1 8 3 56 35
72123 184840 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984633.1125 2106860.5086 37.7641482765436 -122.496367710892 (37.7641482765436, -122.496367710892) 1 8 3 56 35
178599 184839 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984633.4922 2106865.0653 37.7641608102021 -122.496366733886 (37.7641608102021, -122.496366733886) 1 8 3 56 35
110619 184856 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984633.4922 2106845.3199 37.7641065948922 -122.496365276841 (37.7641065948922, -122.496365276841) 1 8 3 56 35
75013 184867 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984635.0111 2106821.7773 37.7640420425175 -122.496358286248 (37.7640420425175, -122.496358286248) 1 8 3 56 35
137143 184865 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 54 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984635.3908 2106835.0674 37.7640785556344 -122.49635795369 (37.7640785556344, -122.49635795369) 1 8 3 56 35
192788 184841 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984637.2894 2106860.5086 37.7641485212291 -122.496353264421 (37.7641485212291, -122.496353264421) 1 8 3 56 35
123237 184879 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 68 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984636.1502 2106802.0319 37.7639878939354 -122.496352889461 (37.7639878939354, -122.496352889461) 1 8 3 56 35
45189 184853 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984637.6691 2106845.6996 37.7641078821268 -122.496350858396 (37.7641078821268, -122.496350858396) 1 8 3 56 35
3042 184887 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 75 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984636.53 2106768.6166 37.7638961671737 -122.496349110122 (37.7638961671737, -122.496349110122) 1 8 3 56 35
175899 184880 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 69 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984640.7069 2106797.4752 37.763975649452 -122.496336793184 (37.763975649452, -122.496336793184) 1 8 3 56 35
182725 118283 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3501 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5984718.37088 2110378.52154 37.7738127360315 -122.49633242684 (37.7738127360315, -122.49633242684) 11 6 2 55 26
59228 184858 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984642.9852 2106842.6618 37.7640998526008 -122.49633224767 (37.7640998526008, -122.49633224767) 1 8 3 56 35
154686 184875 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984644.1243 2106811.5248 37.7640144258904 -122.496326010311 (37.7640144258904, -122.496326010311) 1 8 3 56 35
146251 184864 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 53 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984647.1621 2106835.0674 37.7640792451971 -122.496317240818 (37.7640792451971, -122.496317240818) 1 8 3 56 35
53303 184881 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 70 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5984647.1621 2106788.362 37.7639510053125 -122.496313794444 (37.7639510053125, -122.496313794444) 1 8 3 56 35
35600 184852 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984650.5796 2106852.1548 37.7641263625826 -122.496306681732 (37.7641263625826, -122.496306681732) 1 8 3 56 35
142022 184851 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984650.5796 2106846.0793 37.7641096809697 -122.496306233424 (37.7641096809697, -122.496306233424) 1 8 3 56 35
89106 184838 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984655.5159 2106866.5842 37.7641662708164 -122.496290673488 (37.7641662708164, -122.496290673488) 1 8 3 56 35
109583 184859 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984655.8956 2106841.143 37.7640964386841 -122.496287482961 (37.7640964386841, -122.496287482961) 1 8 3 56 35
126841 184870 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5984657.0348 2106822.5367 37.7640454177531 -122.496282169928 (37.7640454177531, -122.496282169928) 1 8 3 56 35
38285 118282 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3501 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5984735.97667 2110379.78705 37.7738172420867 -122.49627161989 (37.7738172420867, -122.49627161989) 11 6 2 55 26
129394 184871 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 60 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984661.2117 2106828.9919 37.7640633865909 -122.496268199792 (37.7640633865909, -122.496268199792) 1 8 3 56 35
93813 184876 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984660.832 2106807.7277 37.7640049788393 -122.496267944002 (37.7640049788393, -122.496267944002) 1 8 3 56 35
41962 184847 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984668.0467 2106854.8129 37.7641346841684 -122.496246465144 (37.7641346841684, -122.496246465144) 1 8 3 56 35
175054 184863 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 52 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984668.8061 2106833.1689 37.764075300319 -122.496242241592 (37.764075300319, -122.496242241592) 1 8 3 56 35
112800 184882 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 71 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984668.0467 2106784.9445 37.763942845202 -122.496241309763 (37.763942845202, -122.496241309763) 1 8 3 56 35
137900 184836 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 25 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984671.8439 2106872.6597 37.7641839088875 -122.496234648785 (37.7641839088875, -122.496234648785) 1 8 3 56 35
145829 184850 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984672.2236 2106848.3576 37.764117204402 -122.49623154236 (37.764117204402, -122.49623154236) 1 8 3 56 35
41828 184862 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984672.6033 2106838.8646 37.764091161537 -122.496229528652 (37.764091161537, -122.496229528652) 1 8 3 56 35
179138 184878 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 67 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984672.2236 2106800.513 37.763985836593 -122.496228012074 (37.763985836593, -122.496228012074) 1 8 3 56 35
23871 184829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984677.5396 2106895.0631 37.7642457559536 -122.496216602354 (37.7642457559536, -122.496216602354) 1 8 3 56 35
144111 184877 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984676.4005 2106805.4493 37.7639996349525 -122.496213929862 (37.7639996349525, -122.496213929862) 1 8 3 56 35
32030 184888 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 77 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984676.0208 2106738.9985 37.7638171575071 -122.496210339991 (37.7638171575071, -122.496210339991) 1 8 3 56 35
36576 184846 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984679.0585 2106853.294 37.764131158732 -122.496208267019 (37.764131158732, -122.496208267019) 1 8 3 56 35
155432 184350 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1251 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     19 Width 0ft   5984674.1222 2106470.7267 37.7630804473372 -122.496197112117 (37.7630804473372, -122.496197112117) 1 8 3 56 35
92744 184849 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984683.2354 2106848.3576 37.7641178494327 -122.496193456316 (37.7641178494327, -122.496193456316) 1 8 3 56 35
185310 184837 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984687.4123 2106865.8247 37.7641660538384 -122.496180298656 (37.7641660538384, -122.496180298656) 1 8 3 56 35
162428 184860 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984687.0326 2106838.4849 37.7640909641996 -122.496179594648 (37.7640909641996, -122.496179594648) 1 8 3 56 35
35677 184848 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984690.0704 2106845.3199 37.7641099091262 -122.496169592258 (37.7641099091262, -122.496169592258) 1 8 3 56 35
189688 184884 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984688.9312 2106783.4256 37.7639398980625 -122.496168965531 (37.7639398980625, -122.496168965531) 1 8 3 56 35
97413 184861 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 50 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984691.2095 2106834.308 37.7640797402699 -122.496164839998 (37.7640797402699, -122.496164839998) 1 8 3 56 35
54313 184883 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984691.969 2106787.6025 37.7639515445938 -122.496158767034 (37.7639515445938, -122.496158767034) 1 8 3 56 35
117984 184874 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984695.3865 2106820.2584 37.7640414086876 -122.496149356564 (37.7640414086876, -122.496149356564) 1 8 3 56 35
187358 184774 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984678.2991 2105977.4713 37.7617263510589 -122.496146272255 (37.7617263510589, -122.496146272255) 1 8 3 56 35
43875 184830 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984698.4242 2106894.3037 37.7642448941783 -122.49614431352 (37.7642448941783, -122.49614431352) 1 8 3 56 35
134092 184797 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984676.0208 2105815.7109 37.761282068862 -122.496142217022 (37.761282068862, -122.496142217022) 1 8 3 56 35
134780 184352 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1251 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984691.969 2106499.9651 37.7631617731469 -122.496137544283 (37.7631617731469, -122.496137544283) 1 8 3 56 35
148466 186653 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1401 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984685.2528 2105582.1287 37.7606412582576 -122.496093054522 (37.7606412582576, -122.496093054522) 1 8 3 56 35
166800 184805 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5984688.1718 2105711.6678 37.7609971073609 -122.496092516316 (37.7609971073609, -122.496092516316) 1 8 3 56 35
130346 184776 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984696.9053 2105942.9168 37.7616325639121 -122.496079372469 (37.7616325639121, -122.496079372469) 1 8 3 56 35
63479 184773 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984703.3606 2105992.6601 37.7617695231787 -122.496060716498 (37.7617695231787, -122.496060716498) 1 8 3 56 35
35217 184777 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984706.0186 2105944.056 37.7616362256202 -122.496047937787 (37.7616362256202, -122.496047937787) 1 8 3 56 35
144118 774 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1500X 37th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3   5984689.126 2104618.0173 37.7579943042171 -122.496008531807 (37.7579943042171, -122.496008531807) 1 8 3 56 35
145402 20519 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984732.1426283 2106336.4245009 37.7627150896217 -122.495986533771 (37.7627150896217, -122.495986533771) 1 8 3 56 35
64430 773 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1500X 37th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3   5984696.2443 2104420.7984 37.7574532129065 -122.495969365063 (37.7574532129065, -122.495969365063) 1 8 3 56 35
147934 775 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X 37th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x10   5984704.1950867 2104278.9815789 37.7570642890053 -122.495931406805 (37.7570642890053, -122.495931406805) 1 8 3 56 35
30379 776 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X 37th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3   5984705.3515 2104090.9487 37.7565480706746 -122.495913536759 (37.7565480706746, -122.495913536759) 1 8 3 56 35
49117 186616 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1501 Sunset Blvd 87 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984717.3898 2104397.9779 37.7573917926116 -122.495894553165 (37.7573917926116, -122.495894553165) 1 8 3 56 35
143857 186610 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1501 Sunset Blvd 81 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984720.7396 2104420.1703 37.7574529229595 -122.495884605472 (37.7574529229595, -122.495884605472) 1 8 3 56 35
56308 20477 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1203X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5     6 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
68608 20475 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1203X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
97610 186611 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1501 Sunset Blvd 82 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984721.577 2104411.7958 37.7574299779546 -122.49588109169 (37.7574299779546, -122.49588109169) 1 8 3 56 35
140381 186602 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1501 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984723.2519 2104439.4316 37.7575059562709 -122.495877337913 (37.7575059562709, -122.495877337913) 1 8 3 56 35
137055 20510 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1211X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
52697 186638 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1401 Sunset Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 0ft   5984753.1907 2105493.3593 37.7604015013757 -122.495851543134 (37.7604015013757, -122.495851543134) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);