Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2771 | 2771 | 248515 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 14 | Width 0ft | Permit Number 17884 | 5998314.3472 | 2107764.7584 | 37.7674230792249 | -122.44911363069099 | (37.7674230792249, -122.449113630691) | |
24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
29873 | 29873 | 223638 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006702.0078300005 | 2102414.72297 | 37.753209285497704 | -122.41972214857799 | (37.7532092854977, -122.419722148578) | |||
30277 | 30277 | 207570 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1425 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993940.55788 | 2105777.49426 | 37.7617154448214 | -122.464097572554 | (37.7617154448214, -122.464097572554) | |||
31518 | 31518 | 223432 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | |||
31940 | 31940 | 224063 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 253 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999782.69544 | 2105496.73151 | 37.761279514647704 | -122.44387186291401 | (37.7612795146477, -122.443871862914) | |||
34552 | 34552 | 246582 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | |||
36417 | 36417 | 224061 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 181 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001736.66137 | 2107755.21025 | 37.7675920053907 | -122.437275651355 | (37.7675920053907, -122.437275651355) | |||
46094 | 46094 | 207625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.45899200797301 | (37.7657947273793, -122.458992007973) | |||
47414 | 47414 | 224062 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 67 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004498.44679 | 2107387.20492 | 37.7667381638479 | -122.427696765417 | (37.7667381638479, -122.427696765417) | |||
53895 | 53895 | 207569 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1421 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993941.19822 | 2105808.00041 | 37.7617992436728 | -122.464097572539 | (37.7617992436728, -122.464097572539) | |||
56902 | 56902 | 223440 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 374 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003528.78647 | 2098662.81871 | 37.7427281663791 | -122.43042810806999 | (37.7427281663791, -122.43042810807) | |||
60106 | 60106 | 207624 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | |||
61122 | 61122 | 207588 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.734809637542604 | -122.43639577894699 | (37.7348096375426, -122.436395778947) | |||
61283 | 61283 | 62959 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.796586051068296 | -122.416344986535 | (37.7965860510683, -122.416344986535) | |
67173 | 67173 | 223624 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 473 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006815.17868 | 2101055.50218 | 37.7494835498253 | -122.41923436977301 | (37.7494835498253, -122.419234369773) | |||
67369 | 67369 | 223387 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 79 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005279.4889400005 | 2104932.34735 | 37.7600418568744 | -122.42482060669701 | (37.7600418568744, -122.424820606697) | |||
74779 | 74779 | 126518 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001004.1141099995 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | |||
102796 | 102796 | 63387 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | 14 | Permit Number 23968 | 6006281.90561253 | 2095847.6388786 | 37.735153881321004 | -122.42070878449101 | (37.735153881321, -122.420708784491) | |
116921 | 116921 | 223461 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998343.32414 | 2106238.61167 | 37.7632343233256 | -122.448903459151 | (37.7632343233256, -122.448903459151) | |||
133813 | 133813 | 223636 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006708.59634 | 2102368.48305 | 37.7530826924205 | -122.419696083521 | (37.7530826924205, -122.419696083521) | |||
160453 | 160453 | 223460 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 428 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998537.9355 | 2106688.9685400003 | 37.7644820175447 | -122.448262797404 | (37.7644820175447, -122.448262797404) | |||
164595 | 164595 | 223639 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006697.50598 | 2102457.70308 | 37.7533270454234 | -122.41974076632401 | (37.7533270454234, -122.419740766324) | |||
167205 | 167205 | 223497 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 305 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007806.86285 | 2106132.8802900002 | 37.763480669211 | -122.416164635585 | (37.763480669211, -122.416164635585) | |||
170937 | 170937 | 224085 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 243 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004536.35935 | 2109097.2686900003 | 37.7714357303029 | -122.427687484405 | (37.7714357303029, -122.427687484405) | |||
177073 | 177073 | 207611 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5997222.96665 | 2089595.38167 | 37.717471924360794 | -122.45157781718599 | (37.7174719243608, -122.451577817186) | |||
181783 | 181783 | 124029 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991795.62331 | 2114277.55052 | 37.7849304438848 | -122.47213556804701 | (37.7849304438848, -122.472135568047) |
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");