Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
25166 | 25166 | 188682 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6018053.21017 | 2096769.99546 | 37.738342908392504 | -122.38007476635299 | (37.7383429083925, -122.380074766353) | |||
25645 | 25645 | 188622 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 20 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.744220422250294 | -122.387236979699 | (37.7442204222503, -122.387236979699) | |||
29152 | 29152 | 247788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004361.25599 | 2098418.6984200003 | 37.742104989252894 | -122.427532277614 | (37.7421049892529, -122.427532277614) | |||
37898 | 37898 | 188683 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6018037.89274 | 2096788.1105 | 37.7383918036295 | -122.380128985564 | (37.7383918036295, -122.380128985564) | |||
39081 | 39081 | 188617 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 14 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6015982.63525 | 2098803.5164099997 | 37.743812092253606 | -122.38737568124901 | (37.7438120922536, -122.387375681249) | |||
39606 | 39606 | 188674 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1270 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6017349.18345 | 2096943.80807 | 37.7387812973263 | -122.382521060803 | (37.7387812973263, -122.382521060803) | |||
40124 | 40124 | 188694 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6017109.80778 | 2097388.18297 | 37.7399882351628 | -122.38337964268 | (37.7399882351628, -122.38337964268) | |||
53934 | 53934 | 188689 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 42 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6017291.85289 | 2097369.22431 | 37.739946237732205 | -122.38274888066799 | (37.7399462377322, -122.382748880668) | |||
55534 | 55534 | 188625 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 23 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016045.061840001 | 2099009.5348099996 | 37.744381233611605 | -122.38717418995701 | (37.7443812336116, -122.387174189957) | |||
67245 | 67245 | 188611 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 7 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6015930.35397 | 2098630.21882 | 37.7433333570534 | -122.387544371599 | (37.7433333570534, -122.387544371599) | |||
68287 | 68287 | 188668 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6016461.4138400005 | 2097522.4671400003 | 37.7403210967391 | -122.38563089846001 | (37.7403210967391, -122.38563089846) | |||
68769 | 68769 | 188670 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Fairfax Ave | 6 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016501.05956 | 2097495.23618 | 37.7402485196493 | -122.385491920814 | (37.7402485196493, -122.385491920814) | |||
70087 | 70087 | 188613 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 9 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6015951.71912 | 2098695.10264 | 37.7435126980454 | -122.387475021249 | (37.7435126980454, -122.387475021249) | |||
75882 | 75882 | 188619 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 17 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6015998.57647 | 2098868.23914 | 37.7439906904264 | -122.387325073699 | (37.7439906904264, -122.387325073699) | |||
116493 | 116493 | 188620 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 18 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016010.19673 | 2098906.8694599997 | 37.7440974048845 | -122.38728758724899 | (37.7440974048845, -122.387287587249) | |||
129938 | 129938 | 188673 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1224 Fairfax Ave | 6 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6017369.130609999 | 2096930.52417 | 37.738745924277396 | -122.382451168193 | (37.7387459242774, -122.382451168193) | |||
130423 | 130423 | 188601 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 22nd St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012564.34837 | 2103745.3380400003 | 37.7571913593991 | -122.39954227466299 | (37.7571913593991, -122.399542274663) | |||
132215 | 132215 | 250322 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 211 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5987406.48872 | 2114540.6222 | 37.785397787832 | -122.487339695585 | (37.785397787832, -122.487339695585) | |||
133664 | 133664 | 188610 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 6 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6015921.48725 | 2098607.18682 | 37.7432696247982 | -122.38757342419399 | (37.7432696247982, -122.387573424194) | |||
135667 | 135667 | 188669 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6016481.22908 | 2097508.4741700003 | 37.74028377128229 | -122.38556140964899 | (37.7402837712823, -122.385561409649) | |||
138690 | 138690 | 249574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6006046.96797 | 2113547.6658099997 | 37.78374077347271 | -122.42277853591801 | (37.7837407734727, -122.422778535918) | |||
149911 | 149911 | 188623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 21 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6016032.4125 | 2098973.62438 | 37.744281930464204 | -122.38721542476601 | (37.7442819304642, -122.387215424766) | |||
150530 | 150530 | 188614 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6015957.75681 | 2098712.25398 | 37.7435601265029 | -122.387455340492 | (37.7435601265029, -122.387455340492) | |||
157576 | 157576 | 247792 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113214996 | -122.42834067009 | (37.742063113215, -122.42834067009) | |||
159271 | 159271 | 188627 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 25 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016056.19485 | 2099050.87347 | 37.7444953575769 | -122.387138576789 | (37.7444953575769, -122.387138576789) | |||
161935 | 161935 | 188603 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 22nd St | 6 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012672.24718 | 2103750.00011 | 37.757210174125206 | -122.39916944362301 | (37.7572101741252, -122.399169443623) | |||
162261 | 162261 | 188695 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6017144.2813099995 | 2097363.3609 | 37.739921983914 | -122.38325871894101 | (37.739921983914, -122.383258718941) | |||
162925 | 162925 | 188609 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6015915.65511 | 2098586.79243 | 37.743213302955105 | -122.387592167846 | (37.7432133029551, -122.387592167846) | |||
163262 | 163262 | 188621 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 19 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016020.781169999 | 2098934.4548400003 | 37.7441737348321 | -122.387252912086 | (37.7441737348321, -122.387252912086) | |||
163763 | 163763 | 247789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004321.812940001 | 2098415.77613 | 37.742094734277 | -122.427668451138 | (37.742094734277, -122.427668451138) | |||
164337 | 164337 | 188628 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 26 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016060.05409 | 2099067.529 | 37.7445413039446 | -122.38712639369 | (37.7445413039446, -122.38712639369) | |||
164908 | 164908 | 188624 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 22 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016039.52279 | 2098990.21434 | 37.7443278768366 | -122.387191995632 | (37.7443278768366, -122.387191995632) | |||
168243 | 168243 | 188612 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 8 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6015945.00901 | 2098671.48737 | 37.7434474837177 | -122.38749657621099 | (37.7434474837177, -122.387496576211) | |||
169189 | 169189 | 203896 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.84308 | 2090479.6929400002 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | |||
177157 | 177157 | 188629 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 27 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6016065.14365 | 2099087.45333 | 37.7445962938924 | -122.387110184288 | (37.7445962938924, -122.387110184288) | |||
178098 | 178098 | 203895 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5990601.6715400005 | 2090472.14101 | 37.719497882902004 | -122.474528301759 | (37.719497882902, -122.474528301759) | |||
179978 | 179978 | 247790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004284.58274 | 2098414.05293 | 37.742087896749794 | -122.42779705870501 | (37.7420878967498, -122.427797058705) | |||
182051 | 182051 | 188615 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 12 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6015970.2074 | 2098765.17228 | 37.743706118853396 | -122.387415979867 | (37.7437061188534, -122.387415979867) | |||
187365 | 187365 | 203897 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | |||
189080 | 189080 | 188626 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 24 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6016050.39554 | 2099032.09801 | 37.7444434828812 | -122.38715732045799 | (37.7444434828812, -122.387157320458) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");