trees
3,965 rows where qSpecies_id = 70 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57112 | 122188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 7ft | 5991455.25466 | 2115068.89976 | 37.7870835661247 | -122.473370861161 | (37.7870835661247, -122.473370861161) | 11 | 6 | 1 | 61 | 33 | |||
184531 | 142664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008968.9034 | 2121287.3605 | 37.80515650344 | -122.41321719022 | (37.80515650344, -122.41321719022) | 3 | 1 | 10 | 308 | 23 | |||
180909 | 140779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000037.9186 | 2112803.9662 | 37.7813578932052 | -122.443514076205 | (37.7813578932052, -122.443514076205) | 15 | 5 | 1 | 29490 | 16 | |||
22759 | 220218 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004730.92104 | 2103164.34461 | 37.7551563384039 | -122.426591942883 | (37.7551563384039, -122.426591942883) | 2 | 4 | 5 | 28862 | 22 | |||
91036 | 220219 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004727.2771 | 2103184.40621 | 37.7552112168496 | -122.426605973183 | (37.7552112168496, -122.426605973183) | 2 | 4 | 5 | 28862 | 22 | |||
115838 | 220217 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004733.05876 | 2103154.09475 | 37.7551283155433 | -122.426583820187 | (37.7551283155433, -122.426583820187) | 2 | 4 | 5 | 28862 | 22 | |||
73425 | 125001 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001511.47441 | 2120975.96758 | 37.8038800115288 | -122.439002139235 | (37.8038800115288, -122.439002139235) | 13 | 9 | 1 | 57 | 17 | |||
137693 | 120205 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 886 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5988240.03361 | 2109952.00285 | 37.7728473031828 | -122.484119294259 | (37.7728473031828, -122.484119294259) | 11 | 6 | 2 | 55 | 26 | |||
16854 | 14553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | 15 | 5 | 11 | 29492 | 16 | |||
19982 | 142665 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008980.7551 | 2121289.4217 | 37.8051628283357 | -122.413176321677 | (37.8051628283357, -122.413176321677) | 3 | 1 | 10 | 308 | 23 | |||
99090 | 204014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Santa Monica Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993866.19059 | 2097272.31926 | 37.73835811504 | -122.463737442625 | (37.73835811504, -122.463737442625) | 1 | 8 | 4 | 59 | 40 | |||
31329 | 66977 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1992 12:00:00 AM | 3x3 | Permit Number 51959 | 6008713.44526342 | 2098219.93166523 | 37.7418044249338 | -122.412469676471 | (37.7418044249338, -122.412469676471) | 10 | 7 | 7 | 28859 | 2 | ||
74761 | 174977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001002.85904 | 2088768.34496 | 37.7154168062239 | -122.4384532767 | (37.7154168062239, -122.4384532767) | 9 | 7 | 6 | 28861 | 5 | |||
100203 | 174978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001016.58593 | 2088794.32712 | 37.7154889282344 | -122.438407690968 | (37.7154889282344, -122.438407690968) | 9 | 7 | 6 | 28861 | 5 | |||
173929 | 174979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6001031.1498 | 2088817.30686 | 37.7155528538591 | -122.438358997196 | (37.7155528538591, -122.438358997196) | 9 | 7 | 6 | 28861 | 5 | |||
28825 | 30290 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 2 | 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 | |||
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 | |||
165440 | 10335 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 860 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4x4 | 6002028.0975 | 2109143.8299 | 37.7714213748567 | -122.436367006921 | (37.7714213748567, -122.436367006921) | 15 | 5 | 11 | 29492 | 9 | |||
101389 | 174994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 86 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000642.03466 | 2088027.29642 | 37.7133615216919 | -122.439647347957 | (37.7133615216919, -122.439647347957) | 9 | 7 | 6 | 28861 | 5 | |||
34748 | 125237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007164.82088 | 2113970.50384 | 37.7849647912426 | -122.418941177317 | (37.7849647912426, -122.418941177317) | 7 | 9 | 9 | 28858 | 36 | |||
75041 | 125238 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007174.46526 | 2113971.94732 | 37.7849692977471 | -122.418907913185 | (37.7849692977471, -122.418907913185) | 7 | 9 | 9 | 28858 | 36 | |||
108287 | 125240 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007211.93246 | 2113977.19739 | 37.7849858227912 | -122.418778660814 | (37.7849858227912, -122.418778660814) | 7 | 9 | 9 | 28858 | 36 | |||
139706 | 125239 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007196.23625 | 2113975.33069 | 37.7849798135129 | -122.418832832384 | (37.7849798135129, -122.418832832384) | 7 | 9 | 9 | 28858 | 36 | |||
102879 | 120367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5988179.32225 | 2110142.47058 | 37.7733667396691 | -122.484343271227 | (37.7733667396691, -122.484343271227) | 11 | 6 | 2 | 55 | 26 | |||
104965 | 258052 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 856 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x6 | 5991236 | 2091663 | 37.7228044207006 | -122.472422451465 | (37.7228044207006, -122.472422451465) | 9 | 8 | 4 | 64 | 40 | ||||
15872 | 203996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5996332.32562 | 2094668.87187 | 37.7313514789886 | -122.455022734117 | (37.7313514789886, -122.455022734117) | 9 | 7 | 4 | 59 | 40 | |||
25711 | 111769 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 MONTEREY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996319 | 2094654 | 37.7313098799379 | -122.455067728735 | (37.7313098799379, -122.455067728735) | 9 | 7 | 4 | 28861 | 40 | ||||
67508 | 10334 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6002067 | 2109164 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | 15 | 5 | 11 | 29492 | 9 | |||
187593 | 203230 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 85 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994340.44327 | 2101857.15763 | 37.7509742462784 | -122.462430178205 | (37.7509742462784, -122.462430178205) | 1 | 8 | 4 | 29491 | 40 | |||
60685 | 142660 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 85 Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6008994.668 | 2121289.937 | 37.8051650242759 | -122.41312821069 | (37.8051650242759, -122.41312821069) | 3 | 1 | 10 | 308 | 23 | |||
157461 | 188704 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 85 Bay View St | 1 | : | Tree | Private 2 | 31 | Width 5ft | 6013901.34741 | 2094806.92994 | 37.7327228057098 | -122.394292577538 | (37.7327228057098, -122.394292577538) | 10 | 3 | 8 | 58 | 1 | |||
43618 | 113057 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988174.67863 | 2110213.36174 | 37.7735611166607 | -122.484364534338 | (37.7735611166607, -122.484364534338) | 11 | 6 | 2 | 55 | 26 | |||
148727 | 113056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5988176.09683 | 2110229.83232 | 37.7736064228649 | -122.48436083687 | (37.7736064228649, -122.48436083687) | 11 | 6 | 2 | 55 | 26 | |||
148762 | 104745 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 5988152.6 | 2110221.5 | 37.7735821764225 | -122.484441503692 | (37.7735821764225, -122.484441503692) | 11 | 6 | 2 | 55 | 26 | ||||
148042 | 174976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 842 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001033.7824 | 2088915.45345 | 37.7158224921953 | -122.438356925152 | (37.7158224921953, -122.438356925152) | 9 | 7 | 6 | 28861 | 5 | |||
75058 | 187731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016728.56547 | 2095062.09483 | 37.733580186956 | -122.384535854255 | (37.733580186956, -122.384535854255) | 10 | 3 | 8 | 58 | 1 | |||
115021 | 187729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016756.98827 | 2095025.70414 | 37.7334818371106 | -122.384435053735 | (37.7334818371106, -122.384435053735) | 10 | 3 | 8 | 58 | 1 | |||
175125 | 187730 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016747.91216 | 2095034.61845 | 37.7335058121437 | -122.384467053408 | (37.7335058121437, -122.384467053408) | 10 | 3 | 8 | 58 | 1 | |||
185107 | 187732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016720.53621 | 2095079.35768 | 37.7336271432802 | -122.384564816022 | (37.7336271432802, -122.384564816022) | 10 | 3 | 8 | 58 | 1 | |||
121057 | 140112 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6009019.9173 | 2121317.2474 | 37.8052414292046 | -122.41304276436 | (37.8052414292046, -122.41304276436) | 3 | 1 | 10 | 308 | 23 | |||
125494 | 140113 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009000.3362 | 2121315.7016 | 37.8052360856065 | -122.41311041807 | (37.8052360856065, -122.41311041807) | 3 | 1 | 10 | 308 | 23 | |||
98177 | 218114 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Lopez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5993940.18965 | 2100447.16397 | 37.7470797051661 | -122.463711957653 | (37.7470797051661, -122.463711957653) | 1 | 8 | 4 | 29491 | 40 | |||
117440 | 218115 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5993939.71503 | 2100424.54797 | 37.7470175800072 | -122.463711957636 | (37.7470175800072, -122.463711957636) | 1 | 8 | 4 | 29491 | 40 | |||
174835 | 221386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001443.12285 | 2107638.5593 | 37.7672550195357 | -122.438282603375 | (37.7672550195357, -122.438282603375) | 15 | 5 | 5 | 29492 | 3 | |||
189638 | 221385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001442.14467 | 2107662.58176 | 37.767320923637 | -122.438287707917 | (37.767320923637, -122.438287707917) | 15 | 5 | 5 | 29492 | 3 | |||
29875 | 120994 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
30371 | 120985 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
58924 | 120989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
73451 | 120986 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
74773 | 120987 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
75352 | 120992 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
94629 | 120990 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
113136 | 120984 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
117469 | 120988 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
140458 | 120993 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
144925 | 120991 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
166953 | 74710 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
175838 | 74557 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
19963 | 55630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.65482 | 37.7968976958139 | -122.403523149777 | (37.7968976958139, -122.403523149777) | 3 | 1 | 10 | 308 | 4 | ||
139746 | 100371 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 836 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Permit Number 22564 | 6011703.37581 | 2118243.83114 | 37.7969528476575 | -122.403539900553 | (37.7969528476575, -122.403539900553) | 3 | 1 | 10 | 308 | 4 | |||
184296 | 104943 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||||
57473 | 203823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 830 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996652.15177 | 2095040.88377 | 37.7323912769404 | -122.453943898404 | (37.7323912769404, -122.453943898404) | 9 | 7 | 4 | 59 | 40 | ||||
2155 | 174995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 83 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000678.32688 | 2088039.79794 | 37.71339791366 | -122.439522805332 | (37.71339791366, -122.439522805332) | 9 | 7 | 6 | 28861 | 5 | |||
21247 | 203924 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 828 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990829.70497 | 2101134.74222 | 37.7487878900543 | -122.474517815648 | (37.7487878900543, -122.474517815648) | 1 | 8 | 4 | 29491 | 12 | |||
94121 | 203923 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 828 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990846.91254 | 2101136.37412 | 37.7487933678174 | -122.474458431617 | (37.7487933678174, -122.474458431617) | 1 | 8 | 4 | 29491 | 12 | |||
180748 | 10329 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 826 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6002169.5428 | 2109164.521 | 37.7714862234563 | -122.435879222083 | (37.7714862234563, -122.435879222083) | 15 | 5 | 11 | 29492 | 9 | |||
36795 | 125302 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010002.45629 | 2118162.14134 | 37.7966333922736 | -122.409419745449 | (37.7966333922736, -122.409419745449) | 3 | 1 | 10 | 308 | 4 | |||
63643 | 125300 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010027.66692 | 2118166.59425 | 37.7966470313847 | -122.40933282505 | (37.7966470313847, -122.40933282505) | 3 | 1 | 10 | 308 | 4 | |||
152037 | 125299 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010044.08646 | 2118168.03346 | 37.7966519030275 | -122.409276111123 | (37.7966519030275, -122.409276111123) | 3 | 1 | 10 | 308 | 4 | |||
157269 | 125301 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010016.58615 | 2118164.86892 | 37.7966416732215 | -122.409371045347 | (37.7966416732215, -122.409371045347) | 3 | 1 | 10 | 308 | 4 | |||
138154 | 6986 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003463.44232 | 2110444.61834 | 37.7750744723339 | -122.431494958587 | (37.7750744723339, -122.431494958587) | 15 | 9 | 11 | 29492 | 10 | |||
190240 | 139460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001026.3641 | 2111511.4487 | 37.777865290258 | -122.440001839118 | (37.777865290258, -122.440001839118) | 15 | 5 | 11 | 29490 | 41 | |||
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 | |||
55680 | 137663 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 820 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6003458.892 | 2110384.4612 | 37.7749090377732 | -122.431506403609 | (37.7749090377732, -122.431506403609) | 15 | 9 | 11 | 29492 | 10 | |||
110379 | 187728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016765.26263 | 2095017.29072 | 37.7334591930792 | -122.384405860861 | (37.7334591930792, -122.384405860861) | 10 | 3 | 8 | 58 | 1 | |||
185599 | 174993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000637.15099 | 2088042.26781 | 37.7134023518192 | -122.439665300239 | (37.7134023518192, -122.439665300239) | 9 | 7 | 6 | 28861 | 5 | |||
14555 | 247858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Bradford St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.409495368525 | (37.7414618274161, -122.409495368525) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||
15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
84479 | 247552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6000078.15418 | 2108371.82358 | 37.7691906501663 | -122.443056484487 | (37.7691906501663, -122.443056484487) | 15 | 5 | 11 | 29492 | 9 | |||
28393 | 175015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 5 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6013189.92411 | 2087076.36729 | 37.7114566649583 | -122.39621055537 | (37.7114566649583, -122.39621055537) | 10 | 3 | 8 | 309 | 1 | |||
39635 | 175016 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.7114694389303 | -122.396206518314 | (37.7114694389303, -122.396206518314) | 10 | 3 | 8 | 309 | 1 | |||
101254 | 175012 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6013182.79855 | 2087056.15726 | 37.7114007756959 | -122.396233767795 | (37.7114007756959, -122.396233767795) | 10 | 3 | 8 | 309 | 1 | |||
149369 | 175013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | 10 | 3 | 8 | 309 | 1 | |||
190199 | 175014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 8ft | 6013188.07866 | 2087071.75218 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | 10 | 3 | 8 | 309 | 1 | |||
86761 | 203723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5992575.32299 | 2098617.50593 | 37.7419771883912 | -122.468298426337 | (37.7419771883912, -122.468298426337) | 1 | 8 | 4 | 59 | 40 | |||
75884 | 221410 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Digby St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6002579.41102 | 2097685.70424 | 37.7399914124663 | -122.433640955874 | (37.7399914124663, -122.433640955874) | 2 | 7 | 5 | 63 | 7 | |||
45596 | 220291 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Bernal Heights Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009472.19626 | 2098218.47153 | 37.7418429672886 | -122.409846051065 | (37.7418429672886, -122.409846051065) | 10 | 7 | 7 | 28859 | 2 | |||
4954 | 24213 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35242 | 24203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35467 | 24214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
39608 | 24202 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
57732 | 24215 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
104543 | 24216 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3.5x3.5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
125868 | 24210 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
161485 | 24208 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x6 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
171234 | 24212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2002 12:00:00 AM | 9 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | ||
172644 | 24201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
9246 | 254278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 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) );