Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28541 | 28541 | 220690 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003721.786040001 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | |||
33112 | 33112 | 220001 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | |||
34582 | 34582 | 174966 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009006.884330001 | 2093841.0199900002 | 37.729797343475596 | -122.411145814235 | (37.7297973434756, -122.411145814235) | |||
34587 | 34587 | 78000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2000 12:00:00 AM | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | ||
38287 | 38287 | 220026 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | |||
38437 | 38437 | 142346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 505 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999691.4094 | 2110243.208 | 37.7743069396367 | -122.44452872557699 | (37.7743069396367, -122.444528725577) | |||
41593 | 41593 | 220031 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 541 Grand View Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6000040.44223 | 2101732.89415 | 37.7509596367958 | -122.44271016275101 | (37.7509596367958, -122.442710162751) | |||
42359 | 42359 | 138339 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | |||
43321 | 43321 | 220677 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006108.91147 | 2104316.6789599997 | 37.758398187543996 | -122.42190829343399 | (37.758398187544, -122.421908293434) | |||
45153 | 45153 | 140717 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002162.097 | 2110427.6982 | 37.774954171002 | -122.43599537996201 | (37.774954171002, -122.435995379962) | |||
47075 | 47075 | 220067 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.756189841101296 | -122.431964909158 | (37.7561898411013, -122.431964909158) | |||
54226 | 54226 | 137665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000382.7272 | 2111637.7254 | 37.778175352566 | -122.44223746490101 | (37.778175352566, -122.442237464901) | |||
55440 | 55440 | 138357 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | |||
58566 | 58566 | 220089 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000884.7117 | 2105729.84303 | 37.7619823797984 | -122.44007717983101 | (37.7619823797984, -122.440077179831) | |||
60547 | 60547 | 184904 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983548.4855 | 2101753.1406 | 37.7500612779998 | -122.499741544392 | (37.7500612779998, -122.499741544392) | |||
62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
68717 | 68717 | 203626 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997325.36011 | 2099393.7124400004 | 37.7443816679834 | -122.451930391889 | (37.7443816679834, -122.451930391889) | |||
69010 | 69010 | 188521 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013271.447919999 | 2104826.1277799997 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | |||
70529 | 70529 | 138351 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.786384743909295 | -122.437924862001 | (37.7863847439093, -122.437924862001) | |||
108628 | 108628 | 120548 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
153239 | 153239 | 220071 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | |||
154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
157995 | 157995 | 140719 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002157.9056 | 2110466.8172 | 37.775061343901896 | -122.436012678697 | (37.7750613439019, -122.436012678697) | |||
166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
167885 | 167885 | 220009 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006820.56616 | 2101433.2332200003 | 37.750521016743896 | -122.419242531131 | (37.7505210167439, -122.419242531131) | |||
171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
174458 | 174458 | 203224 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Northgate Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994449.32754 | 2093942.03458 | 37.7292475573046 | -122.461479885289 | (37.7292475573046, -122.461479885289) | |||
175294 | 175294 | 141632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999054.1432 | 2110418.5587 | 37.7747520248793 | -122.446745757486 | (37.7747520248793, -122.446745757486) | |||
175791 | 175791 | 220665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 215 Webster St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004174.507619999 | 2109590.46036 | 37.7727694393 | -122.42897431622801 | (37.7727694393, -122.428974316228) | |||
178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
180907 | 180907 | 137667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | |||
187109 | 187109 | 142298 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.44159730622299 | (37.775410978082, -122.441597306223) | |||
187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) |
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");