Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
35112 | 35112 | 250107 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005911.45005 | 2115583.3816299997 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | |||
37030 | 37030 | 250127 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798 Pine St | 4 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6005361.6989 | 2115505.86135 | 37.789078803778295 | -122.425288702018 | (37.7890788037783, -122.425288702018) | |||
40055 | 40055 | 250106 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005930.7358800005 | 2115585.60481 | 37.7893298908963 | -122.42332557552601 | (37.7893298908963, -122.423325575526) | |||
62028 | 62028 | 199374 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 11 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6018483.1950199995 | 2096774.5509900001 | 37.7383791294845 | -122.378588389364 | (37.7383791294845, -122.378588389364) | |||
63679 | 63679 | 250102 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6006004.13239 | 2115596.49895 | 37.7893639455439 | -122.42307240646099 | (37.7893639455439, -122.423072406461) | |||
64197 | 64197 | 224004 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6006363.216469999 | 2109170.7903299998 | 37.77174077135479 | -122.42137350531 | (37.7717407713548, -122.42137350531) | |||
70049 | 70049 | 199377 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 14 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6018447.1001699995 | 2096720.1802 | 37.738227848245295 | -122.378709414716 | (37.7382278482453, -122.378709414716) | |||
70542 | 70542 | 199381 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 19 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6018357.90647 | 2096608.12533 | 37.7379152501943 | -122.37901002570801 | (37.7379152501943, -122.379010025708) | |||
72310 | 72310 | 199375 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 12 | : 4 | Tree 1 | Private 1 | 24 | Width 3ft | 6018470.06307 | 2096753.17007 | 37.738319697796 | -122.37863230954599 | (37.738319697796, -122.378632309546) | |||
74208 | 74208 | 199359 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1450 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 22 | Width 6ft | 6011987.04436 | 2101599.75481 | 37.751267861428104 | -122.401388046827 | (37.7512678614281, -122.401388046827) | |||
130217 | 130217 | 250108 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005895.20899 | 2115581.5118400003 | 37.7893166475034 | -122.423448203486 | (37.7893166475034, -122.423448203486) | |||
132825 | 132825 | 199368 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1500 Michigan St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016513.5001 | 2101084.14011 | 37.7501036018027 | -122.38569897801901 | (37.7501036018027, -122.385698978019) | |||
133083 | 133083 | 250094 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 8 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005324.767440001 | 2115623.21527 | 37.789398941767004 | -122.425424835102 | (37.789398941767, -122.425424835102) | |||
136016 | 136016 | 199382 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 20 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6018339.04048 | 2096582.3620200001 | 37.7378434689969 | -122.37907346658501 | (37.7378434689969, -122.379073466585) | |||
136355 | 136355 | 199367 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1500 Michigan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6016510.76764 | 2101132.40556 | 37.7502359775117 | -122.385711790678 | (37.7502359775117, -122.385711790678) | |||
137315 | 137315 | 199380 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 18 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6018370.09073 | 2096624.46593 | 37.7379607900541 | -122.37896903279301 | (37.7379607900541, -122.378969032793) | |||
146659 | 146659 | 201400 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 12 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6018104.40497 | 2094706.8923400003 | 37.732680858616796 | -122.379754459312 | (37.7326808586168, -122.379754459312) | |||
148887 | 148887 | 199373 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6018659.73844 | 2097012.77983 | 37.739042989241 | -122.37799451303002 | (37.739042989241, -122.37799451303) | |||
150368 | 150368 | 199376 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 13 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6018454.3293699995 | 2096728.7492099998 | 37.7382517755872 | -122.378685014295 | (37.7382517755872, -122.378685014295) | |||
150414 | 150414 | 199358 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1144 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011907.7918 | 2103052.2048299997 | 37.755251549640704 | -122.401764195454 | (37.7552515496407, -122.401764195454) | |||
152830 | 152830 | 199362 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 936 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6012742.61969 | 2103151.37524 | 37.7555704024715 | -122.39888405366699 | (37.7555704024715, -122.398884053667) | |||
158273 | 158273 | 250109 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 5 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005867.157869999 | 2115579.68143 | 37.7893100383746 | -122.42354512700899 | (37.7893100383746, -122.423545127009) | |||
159517 | 159517 | 250101 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6005978.51572 | 2115593.66659 | 37.78935472300171 | -122.42316083590299 | (37.7893547230017, -122.423160835903) | |||
160411 | 160411 | 199378 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 16 | : 4 | Tree 1 | Private 1 | 21 | Width 4ft | 6018401.90254 | 2096662.3376799999 | 37.7380665323305 | -122.37886167173401 | (37.7380665323305, -122.378861671734) | |||
169546 | 169546 | 250104 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006039.94152 | 2115602.86884 | 37.789383456327705 | -122.422948963731 | (37.7893834563277, -122.422948963731) | |||
183607 | 183607 | 250103 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006023.8446 | 2115600.71368 | 37.7893766304877 | -122.423004504073 | (37.7893766304877, -122.423004504073) | |||
185210 | 185210 | 199369 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1500 Michigan St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016517.96989 | 2101024.03295 | 37.74993880734289 | -122.38567933235201 | (37.7499388073429, -122.385679332352) | |||
187755 | 187755 | 199379 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 17 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6018388.0029 | 2096644.9074400002 | 37.738017905995896 | -122.378908520106 | (37.7380179059959, -122.378908520106) | |||
188187 | 188187 | 250125 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Pine St | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005649.1110000005 | 2115549.12657 | 37.7892138324921 | -122.424297370338 | (37.7892138324921, -122.424297370338) |
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");