Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17557 | 17557 | 15331 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006725.71304 | 2108437.22279 | 37.7697470004467 | -122.42006753591002 | (37.7697470004467, -122.42006753591) | |||
21011 | 21011 | 15332 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006723.99669 | 2108411.90123 | 37.7696773767498 | -122.42007167547101 | (37.7696773767498, -122.420071675471) | |||
21095 | 21095 | 15330 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006727.83912 | 2108452.72313 | 37.769789680489 | -122.420061282012 | (37.769789680489, -122.420061282012) | |||
21983 | 21983 | 15333 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006720.95157 | 2108390.0555 | 37.7696172219899 | -122.420080657908 | (37.7696172219899, -122.420080657908) | |||
25070 | 25070 | 245815 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 92 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004991.22077 | 2096914.7584400002 | 37.7380111224129 | -122.42524706251699 | (37.7380111224129, -122.425247062517) | ||||
36346 | 36346 | 245812 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 46 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005133.84129 | 2097128.34789 | 37.7386056471346 | -122.424769142989 | (37.7386056471346, -122.424769142989) | ||||
42717 | 42717 | 245818 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 95 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004977.00826 | 2096882.72633 | 37.7379223665264 | -122.42529392347001 | (37.7379223665264, -122.42529392347) | ||||
67350 | 67350 | 245811 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005130.64633 | 2097121.32587 | 37.7385861857983 | -122.42477969022801 | (37.7385861857983, -122.424779690228) | ||||
69233 | 69233 | 245809 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005116.45422 | 2097135.7932799999 | 37.7386251084509 | -122.424829788766 | (37.7386251084509, -122.424829788766) | ||||
80242 | 80242 | 24613 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1735 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6x7 | 6006758.7391800005 | 2108085.91697 | 37.768784258651706 | -122.419928366315 | (37.7687842586517, -122.419928366315) | |||
86377 | 86377 | 113392 | Permitted Site 1 | Corymbia citriodora :: Lemon Scented Gum 301 | 2741 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991774.5 | 2096885.7 | 37.7371758034866 | -122.47094126147199 | (37.7371758034866, -122.470941261472) | ||||
103149 | 103149 | 15329 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006717.7369932 | 2108570.5208478 | 37.7701125558687 | -122.42010458618601 | (37.7701125558687, -122.420104586186) | |||
111743 | 111743 | 112622 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 226x HESTER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012667.0 | 2087636.0 | 37.712964194877294 | -122.398057164184 | (37.7129641948773, -122.398057164184) | ||||
118001 | 118001 | 13409 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 364 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
118910 | 118910 | 102185 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1840X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.787979647228205 | -122.43158363287701 | (37.7879796472282, -122.431583632877) | |||
121316 | 121316 | 9296 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 135X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6011497.3933157995 | 2090592.5284866001 | 37.7210170109869 | -122.40230748066001 | (37.7210170109869, -122.40230748066) | |||
124657 | 124657 | 121200 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 423 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990242.0 | 2112483.0 | 37.7799130778564 | -122.477379347216 | (37.7799130778564, -122.477379347216) | ||||
130875 | 130875 | 245816 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 93 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004985.63853 | 2096904.07268 | 37.73798146635921 | -122.425265602924 | (37.7379814663592, -122.425265602924) | ||||
137152 | 137152 | 245822 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6009164.14819 | 2095772.28813 | 37.735109010158794 | -122.41073846992501 | (37.7351090101588, -122.410738469925) | ||||
149603 | 149603 | 245819 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 96 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6004972.44653 | 2096874.3096599998 | 37.737898998529296 | -122.42530909685499 | (37.7378989985293, -122.425309096855) | ||||
153695 | 153695 | 245823 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009152.02942 | 2095785.20865 | 37.7351438076288 | -122.41078128123999 | (37.7351438076288, -122.41078128124) | ||||
155151 | 155151 | 245807 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005192.84827 | 2097397.66927 | 37.7393484754449 | -122.42458427745001 | (37.7393484754449, -122.42458427745) | ||||
158903 | 158903 | 245820 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 97 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004968.56772 | 2096865.41877 | 37.737874367011706 | -122.425321875304 | (37.7378743670117, -122.425321875304) | ||||
163240 | 163240 | 126133 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 2600 Richardson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999007.61362 | 2119788.17204 | 37.8004758644149 | -122.447581314529 | (37.8004758644149, -122.447581314529) | ||||
167344 | 167344 | 245814 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005138.21189 | 2097118.38559 | 37.73857853975821 | -122.424753323004 | (37.7385785397582, -122.424753323004) | ||||
171669 | 171669 | 245813 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005140.34889 | 2097123.4045900002 | 37.7385924414978 | -122.424746291228 | (37.7385924414978, -122.424746291228) | ||||
176435 | 176435 | 245808 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005180.88138 | 2097324.81377 | 37.739147754852794 | -122.424620472474 | (37.7391477548528, -122.424620472474) | ||||
182535 | 182535 | 245821 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6009177.83151 | 2095781.65672 | 37.7351355014861 | -122.41069182297899 | (37.7351355014861, -122.410691822979) | ||||
186419 | 186419 | 245810 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005122.10608 | 2097126.3109900001 | 37.7385993914497 | -122.424809572906 | (37.7385993914497, -122.424809572906) | ||||
188089 | 188089 | 245817 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 94 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004980.52596 | 2096892.5237200002 | 37.737949466684206 | -122.425282458027 | (37.7379494666842, -122.425282458027) |
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");