Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26296 | 26296 | 193431 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 568 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.39624530967801 | (37.7591720865425, -122.396245309678) | |||
35864 | 35864 | 202028 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.723217781063205 | -122.395055126189 | (37.7232177810632, -122.395055126189) | |||
36283 | 36283 | 193430 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 560 Missouri St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013531.28257 | 2104470.6669900003 | 37.7592368044652 | -122.396249052661 | (37.7592368044652, -122.396249052661) | |||
40746 | 40746 | 193433 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 588 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013536.39974 | 2104342.74788 | 37.758885851209 | -122.396222389564 | (37.758885851209, -122.396222389564) | |||
50998 | 50998 | 202024 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | |||
54038 | 54038 | 202020 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.39418691350599 | (37.7227235352339, -122.394186913506) | |||
58037 | 58037 | 193432 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 572 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013532.897999999 | 2104416.8953299997 | 37.759089249099105 | -122.39623969701401 | (37.7590892490991, -122.396239697014) | |||
58655 | 58655 | 202021 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013834.37055 | 2091185.2446599999 | 37.722774667999 | -122.39427065747101 | (37.722774667999, -122.394270657471) | |||
69513 | 69513 | 202022 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013717.54523 | 2091271.8320400002 | 37.723005925068605 | -122.39468056126199 | (37.7230059250686, -122.394680561262) | |||
70771 | 70771 | 193438 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 170 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012250.26105 | 2094642.5839099998 | 37.7321796295918 | -122.39998929257601 | (37.7321796295918, -122.399989292576) | |||
135447 | 135447 | 193437 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 420 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010286.5563 | 2097785.62722 | 37.7407000755616 | -122.40699974536501 | (37.7407000755616, -122.406999745365) | |||
138541 | 138541 | 230402 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | |||
154620 | 154620 | 202023 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.723036312264796 | -122.394738025239 | (37.7230363122648, -122.394738025239) | |||
161322 | 161322 | 202025 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013662.901769999 | 2091312.2744599998 | 37.723113933631204 | -122.394872285044 | (37.7231139336312, -122.394872285044) | |||
163256 | 163256 | 193435 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013537.44197 | 2104295.86136 | 37.7587571690323 | -122.39621549896299 | (37.7587571690323, -122.396215498963) | |||
167491 | 167491 | 230403 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010508.06667 | 2104211.71419 | 37.758357092123106 | -122.406686593337 | (37.7583570921231, -122.406686593337) | |||
170064 | 170064 | 202026 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.723148804870206 | -122.394932503635 | (37.7231488048702, -122.394932503635) | |||
175470 | 175470 | 202027 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013629.1875599995 | 2091337.20695 | 37.72318051856 | -122.39499057468001 | (37.72318051856, -122.39499057468) | |||
183298 | 183298 | 193436 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 608 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.38062 | 2104266.7592 | 37.758677424352896 | -122.39620329606899 | (37.7586774243529, -122.396203296069) | |||
184780 | 184780 | 202019 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1350 Fitzgerald Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013890.086209999 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | |||
186395 | 186395 | 193434 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 598 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013537.98707 | 2104307.6187400003 | 37.758789482567295 | -122.396214437761 | (37.7587894825673, -122.396214437761) |
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");