Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23646 | 23646 | 197780 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1809 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012306.168880001 | 2105129.4527 | 37.760977438687206 | -122.40053238956999 | (37.7609774386872, -122.40053238957) | |||
27640 | 27640 | 179601 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5998646.13957 | 2089569.69223 | 37.717482785492 | -122.446656735947 | (37.717482785492, -122.446656735947) | |||
30015 | 30015 | 179628 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6010332.78013 | 2091733.53575 | 37.7240849010885 | -122.40641358074801 | (37.7240849010885, -122.406413580748) | |||
32426 | 32426 | 240875 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3498 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6006590.994390001 | 2100878.65509 | 37.7489853398132 | -122.419997058715 | (37.7489853398132, -122.419997058715) | |||
33150 | 33150 | 247208 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 800 Duboce Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6001877.88305 | 2108298.3747 | 37.7690914279487 | -122.43682607218 | (37.7690914279487, -122.43682607218) | |||
33275 | 33275 | 240861 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6005275.96554 | 2098387.85198 | 37.7420719868226 | -122.424367303401 | (37.7420719868226, -122.424367303401) | |||
33691 | 33691 | 179622 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010361.21232 | 2091638.8627900002 | 37.7238265393343 | -122.406308627159 | (37.7238265393343, -122.406308627159) | |||
34719 | 34719 | 179602 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998651.59561 | 2089580.85001 | 37.7175137338593 | -122.446638679342 | (37.7175137338593, -122.446638679342) | |||
35690 | 35690 | 179621 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010365.10231 | 2091621.9745099999 | 37.7237803852281 | -122.406293990689 | (37.7237803852281, -122.406293990689) | |||
36771 | 36771 | 179599 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998631.90027 | 2089544.4113200002 | 37.717412556513295 | -122.44670413648399 | (37.7174125565133, -122.446704136484) | |||
38103 | 38103 | 179604 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.44658977421801 | (37.7175750361301, -122.446589774218) | |||
47901 | 47901 | 215157 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 494 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5993275.20314 | 2090415.1347 | 37.7194959008046 | -122.46528281875601 | (37.7194959008046, -122.465282818756) | |||
52020 | 52020 | 240876 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3498 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6006577.952740001 | 2100878.25126 | 37.7489834962083 | -122.420042128242 | (37.7489834962083, -122.420042128242) | |||
52494 | 52494 | 240866 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005278.92879 | 2098349.0004 | 37.741965476528705 | -122.42435429470801 | (37.7419654765287, -122.424354294708) | |||
53416 | 53416 | 179572 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 205 Seneca Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999817.08218 | 2090385.88306 | 37.7197906778859 | -122.44266790991699 | (37.7197906778859, -122.442667909917) | |||
53556 | 53556 | 179625 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010348.90515 | 2091680.5192099998 | 37.72394023074661 | -122.406354104951 | (37.7239402307466, -122.406354104951) | |||
56014 | 56014 | 197779 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1809 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012297.04253 | 2105129.1602 | 37.7609761265741 | -122.40056393327801 | (37.7609761265741, -122.400563933278) | |||
61268 | 61268 | 240877 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3498 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6006556.35262 | 2100876.90421 | 37.7489785805051 | -122.42011672612699 | (37.7489785805051, -122.420116726127) | |||
66673 | 66673 | 240865 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6005278.51805 | 2098353.61424 | 37.74197812189279 | -122.42435604300199 | (37.7419781218928, -122.424356043002) | |||
69826 | 69826 | 179627 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6010336.72583 | 2091718.34914 | 37.7240434225456 | -122.406398871428 | (37.7240434225456, -122.406398871428) | |||
72247 | 72247 | 179573 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 205 Seneca Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5999821.83375 | 2090347.3998900002 | 37.7196852827387 | -122.44264872377701 | (37.7196852827387, -122.442648723777) | |||
132068 | 132068 | 179623 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010356.36169 | 2091656.0500299998 | 37.723873460582794 | -122.40632660549299 | (37.7238734605828, -122.406326605493) | |||
146342 | 146342 | 179624 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010352.888119999 | 2091667.1741900002 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | |||
153411 | 153411 | 240862 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6005277.47916 | 2098381.07997 | 37.7420534778916 | -122.424361588223 | (37.7420534778916, -122.424361588223) | |||
158634 | 158634 | 179600 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5998640.25719 | 2089558.9766400002 | 37.71745302692 | -122.446676297989 | (37.71745302692, -122.446676297989) | |||
159419 | 159419 | 247213 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 800 Duboce Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6001852.54114 | 2108296.01305 | 37.769083503129295 | -122.436913559108 | (37.7690835031293, -122.436913559108) | |||
161717 | 161717 | 240869 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1720 Dolores St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6005279.8956 | 2098315.15915 | 37.7418726107263 | -122.424348545375 | (37.7418726107263, -122.424348545375) | |||
162940 | 162940 | 246751 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 178 Ripley St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6009186.7078599995 | 2099095.44284 | 37.7442349346055 | -122.410895104844 | (37.7442349346055, -122.410895104844) | |||
167939 | 167939 | 197781 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1950 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011867.97077 | 2105631.0205 | 37.7623301845026 | -122.40208319670401 | (37.7623301845026, -122.402083196704) | |||
168554 | 168554 | 179603 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998658.1578 | 2089592.8520799999 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | |||
169076 | 169076 | 179626 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6010345.77162 | 2091690.1629 | 37.7239665350232 | -122.406365616296 | (37.7239665350232, -122.406365616296) | |||
171825 | 171825 | 197782 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1950 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011843.38352 | 2105630.34808 | 37.7623269658286 | -122.40216818803499 | (37.7623269658286, -122.402168188035) | |||
175940 | 175940 | 245232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 51 Dearborn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6005861.26231 | 2105689.81649 | 37.76215453162229 | -122.422862363516 | (37.7621545316223, -122.422862363516) | |||
178621 | 178621 | 197778 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Wisconsin St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012724.983580001 | 2104673.0292 | 37.759747548338105 | -122.399051845593 | (37.7597475483381, -122.399051845593) | |||
183115 | 183115 | 215158 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 494 Victoria St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993274.39312 | 2090442.4694700001 | 37.7195709087624 | -122.465287603165 | (37.7195709087624, -122.465287603165) |
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");