Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1881 | 1881 | 199699 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2098 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015522.8982 | 2092787.4061 | 37.727267599979704 | -122.388545507017 | (37.7272675999797, -122.388545507017) | |||
4580 | 4580 | 142832 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1553 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006643.2439 | 2116275.8765 | 37.791265392276 | -122.420909404242 | (37.791265392276, -122.420909404242) | ||
4604 | 4604 | 142833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1549 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006645.4552 | 2116252.8795 | 37.7912023728705 | -122.42090011974501 | (37.7912023728705, -122.420900119745) | ||
23799 | 23799 | 142837 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1409 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006720.9693 | 2115724.3916 | 37.7897555322672 | -122.420601310832 | (37.7897555322672, -122.420601310832) | |||
26088 | 26088 | 184889 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.763715182625106 | -122.49619577469801 | (37.7637151826251, -122.496195774698) | |||
26971 | 26971 | 142866 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1010 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006958.8566 | 2114380.7051 | 37.7860795036749 | -122.419682864396 | (37.7860795036749, -122.419682864396) | |||
27439 | 27439 | 199676 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1438 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015463.3731 | 2093112.0896 | 37.7281558172955 | -122.388773943405 | (37.7281558172955, -122.388773943405) | |||
34817 | 34817 | 246279 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 344 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002908.8621 | 2106176.8563 | 37.7633247958374 | -122.433108379022 | (37.7633247958374, -122.433108379022) | |||
35834 | 35834 | 142982 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2331 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008422.9305 | 2120909.8092 | 37.804089176079295 | -122.415079860656 | (37.8040891760793, -122.415079860656) | |||
38414 | 38414 | 142770 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 999 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006930.1247 | 2114212.3142 | 37.785615524997894 | -122.419770316589 | (37.7856155249979, -122.419770316589) | |||
38766 | 38766 | 142892 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1107 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006862.6408 | 2114709.6747 | 37.7869773530396 | -122.42003910007601 | (37.7869773530396, -122.420039100076) | |||
39482 | 39482 | 142860 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1034 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006934.3072 | 2114548.914 | 37.78653998113771 | -122.419779738746 | (37.7865399811377, -122.419779738746) | |||
40961 | 40961 | 142877 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1187 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006832.261 | 2114920.1275 | 37.78755349297771 | -122.420159149048 | (37.7875534929777, -122.420159149048) | |||
42547 | 42547 | 184002 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1600 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984962.772000001 | 2103675.8065 | 37.755423278248 | -122.494992688075 | (37.755423278248, -122.494992688075) | |||
45964 | 45964 | 140925 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 156 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5996931.7141 | 2113348.6561 | 37.7826758313104 | -122.454299324454 | (37.7826758313104, -122.454299324454) | |||
48456 | 48456 | 187424 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011445.1418 | 2092205.1836 | 37.725442113938996 | -122.40260144602199 | (37.725442113939, -122.402601446022) | |||
48671 | 48671 | 187423 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2591 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6011041.4081 | 2093531.5119 | 37.7290613868014 | -122.40409042482901 | (37.7290613868014, -122.404090424829) | |||
52476 | 52476 | 142864 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6006888.1179 | 2114511.0898 | 37.7864335230518 | -122.41993685758601 | (37.7864335230518, -122.419936857586) | |||
55824 | 55824 | 142981 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2331 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008417.8476 | 2120947.5679 | 37.804192566337 | -122.415100124758 | (37.804192566337, -122.415100124758) | |||
56086 | 56086 | 142849 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1301 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006768.5938 | 2115374.6214 | 37.7887978336371 | -122.42041169750799 | (37.7887978336371, -122.420411697508) | |||
58263 | 58263 | 142863 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1203 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006816.2189 | 2115040.4436 | 37.787882947459 | -122.420223194063 | (37.787882947459, -122.420223194063) | |||
61379 | 61379 | 142862 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1203 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006813.0104 | 2115061.2984 | 37.7879400288134 | -122.420235775611 | (37.7879400288134, -122.420235775611) | |||
61586 | 61586 | 142848 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1305 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006765.7864 | 2115397.4815 | 37.7888604436235 | -122.420423033997 | (37.7888604436235, -122.420423033997) | |||
63248 | 63248 | 142983 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2331 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008427.2872 | 2120882.2163 | 37.80401365773879 | -122.415062829674 | (37.8040136577388, -122.415062829674) | |||
64475 | 64475 | 142886 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1116 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006907.1209 | 2114732.1255 | 37.787041503382 | -122.41988680238701 | (37.787041503382, -122.419886802387) | |||
66560 | 66560 | 142884 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006908.0601 | 2114365.4705 | 37.786034811662795 | -122.41985752560801 | (37.7860348116628, -122.419857525608) | |||
67281 | 67281 | 142874 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1168 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006878.7832 | 2114929.3518 | 37.7875814418062 | -122.41999884602899 | (37.7875814418062, -122.419998846029) | |||
70366 | 70366 | 142839 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1446 POLK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006735.1058 | 2115962.5659 | 37.7904102966028 | -122.42056931372801 | (37.7904102966028, -122.420569313728) | |||
72761 | 72761 | 143134 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2680 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999570.169 | 2119147.3407 | 37.7987484465527 | -122.445588545421 | (37.7987484465527, -122.445588545421) | |||
91838 | 91838 | 142875 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1178 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 6006878.3822 | 2114950.2065 | 37.787638681088296 | -122.420001713925 | (37.7876386810883, -122.420001713925) | |||
129077 | 129077 | 142893 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006863.4429 | 2114692.0283 | 37.7869289455534 | -122.420035072225 | (37.7869289455534, -122.420035072225) | |||
132728 | 132728 | 246280 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 350 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002911.2454 | 2106157.7898 | 37.763272579037206 | -122.43309877362302 | (37.7632725790372, -122.433098773623) | |||
134829 | 134829 | 186518 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1400 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.758823173681606 | -122.50912828496901 | (37.7588231736816, -122.509128284969) | |||
135107 | 135107 | 142865 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006959.584 | 2114368.3394 | 37.7860455914687 | -122.41967947008301 | (37.7860455914687, -122.419679470083) | |||
135693 | 135693 | 187427 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3199 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6011854.6582 | 2090886.7407 | 37.721844794431895 | -122.40109317658 | (37.7218447944319, -122.40109317658) | |||
136847 | 136847 | 246289 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 362 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002913.6287 | 2106100.5904 | 37.7631156585229 | -122.43308644356199 | (37.7631156585229, -122.433086443562) | |||
150233 | 150233 | 250213 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 300 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011356.8747 | 2120078.79875 | 37.8019718623651 | -122.40486814077299 | (37.8019718623651, -122.404868140773) | |||
153432 | 153432 | 142885 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006912.0707 | 2114700.1497 | 37.7869539845455 | -122.419867407304 | (37.7869539845455, -122.419867407304) | |||
156999 | 156999 | 142883 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.41987036243799 | (37.7861018038827, -122.419870362438) | |||
161805 | 161805 | 141710 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 449 PARKER AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997093.6346 | 2111819.5126 | 37.7784864897369 | -122.453628701289 | (37.7784864897369, -122.453628701289) | |||
163696 | 163696 | 246281 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 350 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002912.4371 | 2106137.5317 | 37.7632170227978 | -122.43309320443998 | (37.7632170227978, -122.43309320444) | |||
164213 | 164213 | 142828 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1548 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006688.3534 | 2116294.0087 | 37.7913177213638 | -122.420754614076 | (37.7913177213638, -122.420754614076) | |||
166893 | 166893 | 185247 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2563 33rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5986114.9152 | 2097795.4761 | 37.739344859427206 | -122.490575670571 | (37.7393448594272, -122.490575670571) | |||
167116 | 167116 | 142855 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 POLK ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006830.2557 | 2115271.8515 | 37.788519127431705 | -122.42019105896699 | (37.7885191274317, -122.420191058967) | |||
168975 | 168975 | 142876 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1197 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 6006828.381 | 2114947.7967 | 37.787629247171395 | -122.420174537563 | (37.7876292471714, -122.420174537563) | |||
173297 | 173297 | 187410 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6011579.9826 | 2091598.2688 | 37.723783177982995 | -122.40209266232901 | (37.723783177983, -122.402092662329) | |||
174497 | 174497 | 142854 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006834.6673 | 2115255.4083 | 37.7884742270331 | -122.42017462803001 | (37.7884742270331, -122.42017462803) | |||
174725 | 174725 | 142846 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.42034601298501 | (37.7884989771715, -122.420346012985) | |||
176996 | 176996 | 140926 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 156 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5996927.3146 | 2113363.8851 | 37.7827173938201 | -122.454315645143 | (37.7827173938201, -122.454315645143) | |||
182559 | 182559 | 142847 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1247 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006787.7441 | 2115244.9809 | 37.7884429519581 | -122.42033623488301 | (37.7884429519581, -122.420336234883) |
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");