Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26761 | 26761 | 175842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004274.97667 | 2092050.6197400002 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | |||
| 28582 | 28582 | 222901 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010350.927680001 | 2105070.60578 | 37.760706622229705 | -122.407290598708 | (37.7607066222297, -122.407290598708) | |||
| 32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
| 33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
| 40687 | 40687 | 57316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | ||
| 59003 | 59003 | 225090 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002851.63466 | 2107200.7798599997 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | |||
| 59009 | 59009 | 206021 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | |||
| 64492 | 64492 | 222913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004271.62218 | 2109232.3150299997 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | |||
| 68238 | 68238 | 222920 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998076.5165 | 2106905.9783799998 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | |||
| 100325 | 100325 | 189958 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010386.6969099995 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | |||
| 119840 | 119840 | 188478 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6010892.5271 | 2106015.01328 | 37.76333004987679 | -122.40548395423401 | (37.7633300498768, -122.405483954234) | |||
| 130879 | 130879 | 225068 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.757304711760604 | -122.41148218316299 | (37.7573047117606, -122.411482183163) | |||
| 131148 | 131148 | 225096 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004357.77926 | 2109121.0465599997 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | |||
| 134756 | 134756 | 225092 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002638.752309999 | 2108633.09345 | 37.770053697148796 | -122.434218205527 | (37.7700536971488, -122.434218205527) | |||
| 169707 | 169707 | 57317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.44509387174801 | (37.7846624482509, -122.445093871748) | ||
| 174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
| 175928 | 175928 | 125977 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008401.628880001 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | |||
| 178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
| 179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) |
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");