Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
3943 | 3943 | 216737 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.5093900003 | 37.7184704425356 | -122.45416736555799 | (37.7184704425356, -122.454167365558) | ||
3959 | 3959 | 216642 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.4765599999 | 37.7191402755735 | -122.45402201441999 | (37.7191402755735, -122.45402201442) | ||
4071 | 4071 | 251734 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 856 Prague St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | ||
4144 | 4144 | 216652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:15:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.7094700001 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | ||
4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
4293 | 4293 | 216862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | ||
4315 | 4315 | 216902 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 Bright St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.46344200363899 | (37.7138937098892, -122.463442003639) | ||
11147 | 11147 | 83378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 586 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.718790012118795 | -122.430676716663 | (37.7187900121188, -122.430676716663) | |
27081 | 27081 | 176269 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6000993.66237 | 2087160.73145 | 37.711002134104795 | -122.43836995721901 | (37.7110021341048, -122.438369957219) | |||
32041 | 32041 | 223379 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2730 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 7ft | 6009758.65341 | 2103393.8455 | 37.756069450652795 | -122.4092206931 | (37.7560694506528, -122.4092206931) | |||
33242 | 33242 | 182485 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985266.5327 | 2104584.1284 | 37.7579350567147 | -122.494009145875 | (37.7579350567147, -122.494009145875) | |||
33533 | 33533 | 223540 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003385.2005900005 | 2098555.09449 | 37.7424242458904 | -122.43091690040701 | (37.7424242458904, -122.430916900407) | |||
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) | |||
35931 | 35931 | 246581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077680995 | -122.425391663601 | (37.772514077681, -122.425391663601) | |||
45395 | 45395 | 223368 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3450 26th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006716.9370800005 | 2100883.67936 | 37.7490062301666 | -122.419561903754 | (37.7490062301666, -122.419561903754) | |||
46450 | 46450 | 246577 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | |||
52755 | 52755 | 207695 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.724471365845105 | -122.456366191771 | (37.7244713658451, -122.456366191771) | |||
56816 | 56816 | 207586 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1917 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993746.75792 | 2102455.0649099997 | 37.7525817412531 | -122.464526593251 | (37.7525817412531, -122.464526593251) | |||
56834 | 56834 | 223564 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.41135018155899 | (37.7408301058168, -122.411350181559) | |||
57080 | 57080 | 223538 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003388.52326 | 2098515.37807 | 37.742315382040005 | -122.430902577793 | (37.74231538204, -122.430902577793) | |||
58552 | 58552 | 123028 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991970.4168 | 2110394.80661 | 37.7742796046287 | -122.47124785557699 | (37.7742796046287, -122.471247855577) | |||
61749 | 61749 | 223367 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3450 26th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6006755.66784 | 2100887.58392 | 37.7490191327351 | -122.41942824923099 | (37.7490191327351, -122.419428249231) | |||
65496 | 65496 | 224055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3810 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004350.69854 | 2104285.65184 | 37.7582136808258 | -122.427986763479 | (37.7582136808258, -122.427986763479) | |||
68683 | 68683 | 176235 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6001042.78255 | 2087493.5862099999 | 37.711918873330205 | -122.43822401612499 | (37.7119188733302, -122.438224016125) | |||
70429 | 70429 | 246160 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 654 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5997594.3711 | 2108214.0054 | 37.7686153917025 | -122.451636326624 | (37.7686153917025, -122.451636326624) | |||
129925 | 129925 | 176236 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 19 Brunswick St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6001058.00654 | 2087498.50838 | 37.711933254377 | -122.438171750223 | (37.711933254377, -122.438171750223) | |||
130791 | 130791 | 246163 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5997583.9235 | 2108279.5679 | 37.7687948112177 | -122.451677193811 | (37.7687948112177, -122.451677193811) | |||
132105 | 132105 | 223588 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 730 Jarboe Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6009063.074440001 | 2096876.2654900001 | 37.738134625423704 | -122.411165877211 | (37.7381346254237, -122.411165877211) | |||
135934 | 135934 | 223566 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 144 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6009026.08799 | 2097793.63743 | 37.7406514546128 | -122.41135854797301 | (37.7406514546128, -122.411358547973) | |||
149170 | 149170 | 223565 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6009029.93492 | 2097846.57394 | 37.7407970224666 | -122.411348985471 | (37.7407970224666, -122.411348985471) | |||
151480 | 151480 | 124028 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991796.1991 | 2114253.0901 | 37.7848633156564 | -122.47213179245199 | (37.7848633156564, -122.472131792452) | |||
153130 | 153130 | 246578 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6005224.61763 | 2109380.5183200003 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | |||
153551 | 153551 | 223587 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 730 Jarboe Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | |||
163964 | 163964 | 246580 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 182 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6005210.93182 | 2109452.28431 | 37.7724486520281 | -122.425379370776 | (37.7724486520281, -122.425379370776) | |||
171876 | 171876 | 176267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6000986.70381 | 2087103.4067099998 | 37.710844337262294 | -122.43838990328899 | (37.7108443372623, -122.438389903289) | |||
178758 | 178758 | 223370 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.42223162849899 | (37.7602393183104, -122.422231628499) | |||
179729 | 179729 | 218237 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 345 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5992002.51219 | 2097168.37657 | 37.737965146364104 | -122.47017350471701 | (37.7379651463641, -122.470173504717) | |||
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) | |||
182751 | 182751 | 223539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6003387.19904 | 2098534.7214900004 | 37.742368419572294 | -122.43090853672301 | (37.7423684195723, -122.430908536723) | |||
186597 | 186597 | 176268 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6000987.65781 | 2087139.8501 | 37.7109444570035 | -122.43838921531 | (37.7109444570035, -122.43838921531) |
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");