Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27862 | 27862 | 194050 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2246 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012135.46921 | 2099441.05415 | 37.7453488151107 | -122.400723136672 | (37.7453488151107, -122.400723136672) | |||
29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
34540 | 34540 | 177827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 0ft | 5993584.63921 | 2087685.0546799998 | 37.712017594599295 | -122.46401514608 | (37.7120175945993, -122.46401514608) | |||
35354 | 35354 | 194072 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | 6011322.76778 | 2098041.04793 | 37.7414593371741 | -122.40343486513399 | (37.7414593371741, -122.403434865134) | ||||
35770 | 35770 | 194078 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011051.92232 | 2097388.39433 | 37.7396521585296 | -122.404325434065 | (37.7396521585296, -122.404325434065) | |||
36721 | 36721 | 210535 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700 Junipero Serra Blvd | 57 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991233.67359 | 2092413.03561 | 37.7248636977911 | -122.472485147273 | (37.7248636977911, -122.472485147273) | |||
39873 | 39873 | 210528 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 466 Bright St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 5993789.40568 | 2090279.07412 | 37.719151951468504 | -122.46349555378299 | (37.7191519514685, -122.463495553783) | |||
45905 | 45905 | 194094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011262.87795 | 2097995.57485 | 37.7413311325376 | -122.40363874593201 | (37.7413311325376, -122.403638745932) | |||
49015 | 49015 | 194093 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011244.42324 | 2097965.17707 | 37.7412466358374 | -122.40370041785299 | (37.7412466358374, -122.403700417853) | |||
50586 | 50586 | 194041 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6011789.4196 | 2105194.80325 | 37.761128044544705 | -122.40232420509899 | (37.7611280445447, -122.402324205099) | |||
56709 | 56709 | 194068 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011049.44747 | 2097157.45063 | 37.7390178981683 | -122.404317740371 | (37.7390178981683, -122.404317740371) | |||
56871 | 56871 | 194048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1242 19th St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013830.06416 | 2105268.62635 | 37.761444447624 | -122.395271611894 | (37.761444447624, -122.395271611894) | |||
57948 | 57948 | 194077 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011049.208459999 | 2097370.84853 | 37.7396038298609 | -122.404333582832 | (37.7396038298609, -122.404333582832) | |||
58582 | 58582 | 194070 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 41 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.40272769043501 | (37.7396392352499, -122.402727690435) | ||||
63644 | 63644 | 194067 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011054.01039 | 2097116.70237 | 37.73890626712029 | -122.404299096539 | (37.7389062671203, -122.404299096539) | |||
65577 | 65577 | 194073 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2275 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | 6011416.20922 | 2097909.60407 | 37.741103639116 | -122.403102531469 | (37.741103639116, -122.403102531469) | ||||
65653 | 65653 | 194076 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011046.281909999 | 2097328.37169 | 37.7394870339983 | -122.404340712651 | (37.7394870339983, -122.404340712651) | |||
66078 | 66078 | 246816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 186 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6010178.32327 | 2098854.3391299997 | 37.7436284695924 | -122.407449302058 | (37.7436284695924, -122.407449302058) | |||
70361 | 70361 | 177828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5993567.2586900005 | 2087687.58972 | 37.712023553524205 | -122.464075401566 | (37.7120235535242, -122.464075401566) | |||
71938 | 71938 | 194042 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6011788.47963 | 2105178.47145 | 37.761083148586394 | -122.402326307728 | (37.7610831485864, -122.402326307728) | |||
109421 | 109421 | 194074 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | 6011541.53422 | 2097819.64053 | 37.7408636163769 | -122.40266287538999 | (37.7408636163769, -122.40266287539) | ||||
130786 | 130786 | 194095 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 401 Barneveld Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011321.98821 | 2098077.1907900004 | 37.741558534187206 | -122.403440102771 | (37.7415585341872, -122.403440102771) | |||
132855 | 132855 | 194096 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 401 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011333.74765 | 2098094.50677 | 37.7416067369731 | -122.403400660313 | (37.7416067369731, -122.403400660313) | |||
133482 | 133482 | 232403 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3977 22nd St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 8ft | 6001960.85303 | 2102925.1671599997 | 37.754342622815706 | -122.43615451782301 | (37.7543426228157, -122.436154517823) | |||
148527 | 148527 | 210534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2523 Ocean Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991267.17989 | 2094746.77146 | 37.731273492456495 | -122.472539386291 | (37.7312734924565, -122.472539386291) | |||
149784 | 149784 | 210526 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 347 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5993225.43115 | 2089502.49868 | 37.7169871520095 | -122.46538860062999 | (37.7169871520095, -122.46538860063) | |||
155753 | 155753 | 194045 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013807.05349 | 2105290.79153 | 37.7615040286026 | -122.395352749639 | (37.7615040286026, -122.395352749639) | |||
162087 | 162087 | 194065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011662.94046 | 2097957.49597 | 37.7412489156133 | -122.40225278546002 | (37.7412489156133, -122.40225278546) | |||
162240 | 162240 | 194092 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Barneveld Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011234.12754 | 2097948.45103 | 37.741200134566704 | -122.403734840308 | (37.7412001345667, -122.403734840308) | |||
163421 | 163421 | 194046 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6013804.04007 | 2105323.21797 | 37.761592896918394 | -122.395365443572 | (37.7615928969184, -122.395365443572) | |||
168102 | 168102 | 194069 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 599 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011047.778940001 | 2097176.40588 | 37.7390698519997 | -122.40432484322201 | (37.7390698519997, -122.404324843222) | |||
170902 | 170902 | 210533 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2645 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5990808.42077 | 2095014.9868299998 | 37.731983379510496 | -122.474144946842 | (37.7319833795105, -122.474144946842) | |||
171896 | 171896 | 194066 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011686.01076 | 2097941.04754 | 37.741205039484 | -122.40217185994 | (37.741205039484, -122.40217185994) | |||
177007 | 177007 | 194040 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6011787.18264 | 2105219.37542 | 37.7611953893822 | -122.402333669585 | (37.7611953893822, -122.402333669585) | |||
177255 | 177255 | 210529 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 233 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5993351.020380001 | 2090459.95557 | 37.7196233401215 | -122.465024001983 | (37.7196233401215, -122.465024001983) | |||
178015 | 178015 | 210527 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 491 Bright St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5993759.26647 | 2090422.7728900001 | 37.7195447771444 | -122.463610156198 | (37.7195447771444, -122.463610156198) | |||
178554 | 178554 | 177808 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Melra Ct | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6008994.91617 | 2086485.2732900002 | 37.709599327506794 | -122.410667934296 | (37.7095993275068, -122.410667934296) | |||
181266 | 181266 | 194071 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2260 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | 6011443.9729 | 2097950.47892 | 37.7412174231363 | -122.403009408459 | (37.7412174231363, -122.403009408459) | ||||
183762 | 183762 | 232287 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Webster St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004240.14437 | 2109135.1756700003 | 37.7715230535659 | -122.42871480966801 | (37.7715230535659, -122.428714809668) |
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");