Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24745 | 24745 | 240970 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4210 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001417.4535300005 | 2103381.77195 | 37.755565461578605 | -122.43806643331499 | (37.7555654615786, -122.438066433315) | |||
28304 | 28304 | 240881 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2318 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6011232.67405 | 2103729.80119 | 37.7570743809943 | -122.404146651544 | (37.7570743809943, -122.404146651544) | |||
34423 | 34423 | 245286 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 717 Duncan St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6001933.71504 | 2099694.24845 | 37.7454697460286 | -122.436017189543 | (37.7454697460286, -122.436017189543) | |||
35163 | 35163 | 240968 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4210 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001453.14059 | 2103383.56857 | 37.7555724241372 | -122.43794314527399 | (37.7555724241372, -122.437943145274) | |||
35187 | 35187 | 245287 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 717 Duncan St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6001940.904019999 | 2099694.0997099997 | 37.7454697460299 | -122.435992320586 | (37.7454697460299, -122.435992320586) | |||
43307 | 43307 | 245250 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 206 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6005414.04692 | 2102441.47321 | 37.7532100975785 | -122.42417808426501 | (37.7532100975785, -122.424178084265) | |||
55455 | 55455 | 136557 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 837 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007687.79617 | 2114390.4545299998 | 37.786147307984294 | -122.41716161321501 | (37.7861473079843, -122.417161613215) | |||
58906 | 58906 | 136562 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1450 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6005964.76756 | 2119686.51908 | 37.8005918895689 | -122.423499498123 | (37.8005918895689, -122.423499498123) | |||
73969 | 73969 | 179609 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6004359.1035400005 | 2091527.3039 | 37.723182644542206 | -122.427048992729 | (37.7231826445422, -122.427048992729) | |||
75617 | 75617 | 246964 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 6002901.21345 | 2106817.19927 | 37.7650825884135 | -122.433180589307 | (37.7650825884135, -122.433180589307) | |||
133001 | 133001 | 197770 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6015491.654180001 | 2103907.18258 | 37.7577984836214 | -122.389429732797 | (37.7577984836214, -122.389429732797) | |||
134101 | 134101 | 179611 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004351.48931 | 2091531.74381 | 37.723194404989705 | -122.427075629732 | (37.7231944049897, -122.427075629732) | |||
134242 | 134242 | 240969 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4210 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6001435.73878 | 2103383.50647 | 37.755571264024795 | -122.43800332158999 | (37.7555712640248, -122.43800332159) | |||
150023 | 150023 | 245249 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 204 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005411.18534 | 2102480.95785 | 37.7533183516659 | -122.424190788097 | (37.7533183516659, -122.424190788097) | |||
156429 | 156429 | 179620 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 602 Somerset St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6010330.793980001 | 2091554.32638 | 37.723592718304296 | -122.40640782506 | (37.7235927183043, -122.40640782506) | |||
159043 | 159043 | 136563 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1450 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6005942.59611 | 2119683.0759 | 37.8005811840348 | -122.42357597555001 | (37.8005811840348, -122.42357597555) | |||
159106 | 159106 | 245325 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 399 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6006236.143569999 | 2100881.26604 | 37.7489725100818 | -122.42122432216001 | (37.7489725100818, -122.42122432216) | |||
161362 | 161362 | 179612 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004345.82316 | 2091535.07257 | 37.7232032246197 | -122.4270954535 | (37.7232032246197, -122.4270954535) | |||
171485 | 171485 | 245239 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 81 Aztec St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6007887.08019 | 2099610.10311 | 37.745575116901 | -122.41542537847602 | (37.745575116901, -122.415425378476) | |||
175006 | 175006 | 117660 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 5110 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5982774.78235 | 2111734.38287 | 37.7774214897517 | -122.503155904898 | (37.7774214897517, -122.503155904898) | |||
175591 | 175591 | 240971 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4220 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001400.39717 | 2103377.8991 | 37.7555538576506 | -122.438125141985 | (37.7555538576506, -122.438125141985) | |||
177037 | 177037 | 246965 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6002901.60437 | 2106802.37956 | 37.7650419192671 | -122.433178178236 | (37.7650419192671, -122.433178178236) | |||
177569 | 177569 | 245251 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 206 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005413.81717 | 2102430.30031 | 37.7531794064144 | -122.42417808424601 | (37.7531794064144, -122.424178084246) | |||
186455 | 186455 | 240972 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4220 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6001380.47631 | 2103379.15675 | 37.7555561778914 | -122.438194124461 | (37.7555561778914, -122.438194124461) | |||
187552 | 187552 | 179610 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6004355.20316 | 2091529.3474400002 | 37.723188035096 | -122.427062621069 | (37.723188035096, -122.427062621069) |
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");