Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4327 | 4327 | 103839 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1552 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.2576 | 2116316.1212 | 37.791378262309706 | -122.420766896 | (37.7913782623097, -122.420766896) | ||
25173 | 25173 | 140670 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 40 COLE ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5997774.3514 | 2110415.6204 | 37.7746707659902 | -122.451172585534 | (37.7746707659902, -122.451172585534) | |||
33890 | 33890 | 231844 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 96 Museum Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000872.22935 | 2106652.07973 | 37.764513903924104 | -122.44018648793501 | (37.7645139039241, -122.440186487935) | |||
39973 | 39973 | 131171 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1028 Chestnut St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006900.3516 | 2120517.59651 | 37.802926579956704 | -122.420321008927 | (37.8029265799567, -122.420321008927) | |||
46561 | 46561 | 131183 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 504 Commercial St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6012392.07307 | 2117339.05892 | 37.7945070037376 | -122.401093222084 | (37.7945070037376, -122.401093222084) | |||
51159 | 51159 | 231682 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 141 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007132.37905 | 2098439.10695 | 37.7423173758515 | -122.417952030056 | (37.7423173758515, -122.417952030056) | |||
59455 | 59455 | 131090 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1651 North Point St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6002849.6651 | 2120943.5541 | 37.8038670612875 | -122.434368934585 | (37.8038670612875, -122.434368934585) | |||
59844 | 59844 | 250237 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6012474.90226 | 2117332.79898 | 37.7944944357317 | -122.400806180977 | (37.7944944357317, -122.400806180977) | |||
62892 | 62892 | 131172 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1028 Chestnut St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006879.14909 | 2120515.3465299997 | 37.8029192073136 | -122.42039422091999 | (37.8029192073136, -122.42039422092) | |||
72701 | 72701 | 131185 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 504 Commercial St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6012367.16594 | 2117335.57564 | 37.7944960499984 | -122.401179159505 | (37.7944960499984, -122.401179159505) | |||
73011 | 73011 | 244935 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 290 Page St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6005183.8966 | 2109935.4965 | 37.7737739081682 | -122.42550728374701 | (37.7737739081682, -122.425507283747) | |||
73537 | 73537 | 250236 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6012472.9903 | 2117349.79933 | 37.794541008002895 | -122.400813991574 | (37.7945410080029, -122.400813991574) | |||
75268 | 75268 | 231771 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2123 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002709.35623 | 2099334.27137 | 37.744525367058394 | -122.43330942979901 | (37.7445253670584, -122.433309429799) | |||
75798 | 75798 | 209607 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 488 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.831730001 | 2090447.2277099998 | 37.719554228122504 | -122.46707004236099 | (37.7195542281225, -122.467070042361) | |||
75844 | 75844 | 250239 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6012493.23475 | 2117334.36425 | 37.7944997561019 | -122.400742857909 | (37.7944997561019, -122.400742857909) | |||
131519 | 131519 | 131182 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 504 Commercial St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 5ft | 6012408.13843 | 2117341.1258 | 37.7945135750949 | -122.401037778889 | (37.7945135750949, -122.401037778889) | |||
136763 | 136763 | 231925 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 125 Moffitt St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6002717.16903 | 2096703.03689 | 37.737301050095205 | -122.433094454065 | (37.7373010500952, -122.433094454065) | |||
137641 | 137641 | 250240 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6012509.92284 | 2117337.5567099997 | 37.794509452601105 | -122.40068533906201 | (37.7945094526011, -122.400685339062) | |||
150348 | 150348 | 131178 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6012368.62422 | 2117315.33506 | 37.7944405555417 | -122.401172690686 | (37.7944405555417, -122.401172690686) | |||
155461 | 155461 | 131181 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6012409.58027 | 2117320.08736 | 37.7944558889799 | -122.401031310972 | (37.7944558889799, -122.401031310972) | |||
155709 | 155709 | 131184 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 504 Commercial St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6012380.30044 | 2117337.96833 | 37.794503352491 | -122.40113388043301 | (37.794503352491, -122.401133880433) | |||
156877 | 156877 | 250238 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6012482.15733 | 2117334.58927 | 37.7944997561041 | -122.400781203214 | (37.7944997561041, -122.400781203214) | |||
156945 | 156945 | 250242 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6012536.17343 | 2117342.3206700003 | 37.7945239973486 | -122.400594842992 | (37.7945239973486, -122.400594842992) | |||
158973 | 158973 | 131177 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 5ft | 6012356.862380001 | 2117314.77617 | 37.794438364791205 | -122.401213349039 | (37.7944383647912, -122.401213349039) | |||
159208 | 159208 | 131180 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6012394.326669999 | 2117318.5359 | 37.794450778130205 | -122.401083981553 | (37.7944507781302, -122.401083981553) | |||
159643 | 159643 | 250241 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 523 Commercial St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6012522.17079 | 2117340.39818 | 37.7945179377025 | -122.400643159068 | (37.7945179377025, -122.400643159068) | |||
161819 | 161819 | 209556 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996028.8528 | 2098497.23395 | 37.741845813638 | -122.456348606399 | (37.741845813638, -122.456348606399) | |||
165068 | 165068 | 250233 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6012521.31946 | 2117354.65914 | 37.794557047424796 | -122.400647107095 | (37.7945570474248, -122.400647107095) | |||
169217 | 169217 | 250232 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6012525.89293 | 2117355.21508 | 37.794558828975 | -122.400631321282 | (37.794558828975, -122.400631321282) | |||
169447 | 169447 | 231770 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2127 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002711.64432 | 2099292.5474900003 | 37.7444109328282 | -122.433298537219 | (37.7444109328282, -122.433298537219) | |||
169486 | 169486 | 231937 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 289 Randall St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003768.435219999 | 2097853.76766 | 37.740520270493796 | -122.429541784839 | (37.7405202704938, -122.429541784839) | |||
169948 | 169948 | 182141 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1414 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5988378.9203 | 2105649.8128 | 37.761042756843 | -122.48332344606001 | (37.761042756843, -122.48332344606) | |||
170813 | 170813 | 231934 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 125 Randall St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6004720.88088 | 2097540.11743 | 37.739712940109705 | -122.42622627133801 | (37.7397129401097, -122.426226271338) | |||
175764 | 175764 | 250230 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 6012537.64619 | 2117356.2743599997 | 37.7945623929982 | -122.400590727701 | (37.7945623929982, -122.400590727701) | |||
175818 | 175818 | 182134 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1434 25th Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 5988383.0453 | 2105547.1446 | 37.7607610979396 | -122.483301653477 | (37.7607610979396, -122.483301653477) | |||
180902 | 180902 | 250231 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 6012532.440909999 | 2117356.70467 | 37.7945632842246 | -122.400608768988 | (37.7945632842246, -122.400608768988) | |||
184358 | 184358 | 131179 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6012381.19757 | 2117316.40905 | 37.7944442058913 | -122.40112926060101 | (37.7944442058913, -122.401129260601) | |||
186459 | 186459 | 250234 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6012500.45193 | 2117354.10926 | 37.79455437373571 | -122.400719273201 | (37.7945543737357, -122.400719273201) | |||
188464 | 188464 | 250235 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 0ft | 6012481.472999999 | 2117350.27619 | 37.7945427904834 | -122.40078467369601 | (37.7945427904834, -122.400784673696) |
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");