Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25551 | 25551 | 138242 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999647.1063 | 2114070.9654 | 37.7848144491807 | -122.444957199215 | (37.7848144491807, -122.444957199215) | |||
25691 | 25691 | 140580 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.778294566327205 | -122.43178620552 | (37.7782945663272, -122.43178620552) | |||
33594 | 33594 | 244469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003415.8306 | 2109638.0930000003 | 37.7728572538387 | -122.43160206502701 | (37.7728572538387, -122.431602065027) | |||
37989 | 37989 | 199692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
39112 | 39112 | 140022 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 775 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005467.685 | 2112000.1843 | 37.7794590687234 | -122.424672518677 | (37.7794590687234, -122.424672518677) | |||
39562 | 39562 | 199697 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | |||
46091 | 46091 | 244452 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | |||
47133 | 47133 | 138241 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.784847050450104 | -122.444961483404 | (37.7848470504501, -122.444961483404) | |||
53354 | 53354 | 139055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.784564120210796 | -122.444654378813 | (37.7845641202108, -122.444654378813) | |||
53751 | 53751 | 138243 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999648.5931 | 2114056.0979 | 37.7847737117432 | -122.44495098624701 | (37.7847737117432, -122.444950986247) | |||
56567 | 56567 | 139360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000048.0331 | 2114373.2711 | 37.7856673759403 | -122.443591852007 | (37.7856673759403, -122.443591852007) | |||
61818 | 61818 | 142100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002972.7027 | 2110318.8393 | 37.7747012881718 | -122.43318354410201 | (37.7747012881718, -122.433183544102) | |||
62337 | 62337 | 199691 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841001 | (37.7276897308085, -122.38666058841) | |||
63520 | 63520 | 200192 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | |||
63634 | 63634 | 182440 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356193998 | (37.7585434265078, -122.49174356194) | |||
65381 | 65381 | 138240 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999643.6372 | 2114098.2225 | 37.7848890921049 | -122.444971161243 | (37.7848890921049, -122.444971161243) | |||
65703 | 65703 | 138239 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | |||
68963 | 68963 | 199693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016099.1110000005 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | |||
134055 | 134055 | 139006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | |||
135516 | 135516 | 247504 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.44514278745399 | (37.7703040400286, -122.445142787454) | |||
148086 | 148086 | 182304 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2531 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986925.2797 | 2105029.7497 | 37.759255527351606 | -122.488305322992 | (37.7592555273516, -122.488305322992) | |||
152156 | 152156 | 140023 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.42461301693301 | (37.7794631941198, -122.424613016933) | |||
155584 | 155584 | 138737 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.44577276106199 | (37.7853686673978, -122.445772761062) | |||
161217 | 161217 | 140579 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.43180072975201 | (37.7783626547096, -122.431800729752) | |||
174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
175276 | 175276 | 139007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.78481835543629 | -122.444802925313 | (37.7848183554363, -122.444802925313) | |||
175525 | 175525 | 139056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999748.2433 | 2113980.0087 | 37.7845704772917 | -122.44460075979201 | (37.7845704772917, -122.444600759792) | |||
184467 | 184467 | 140578 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.778435854356104 | -122.431812198827 | (37.7784358543561, -122.431812198827) | |||
60183 | 60183 | 218315 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.46642509806401 | (37.7455947140337, -122.466425098064) | |||
187567 | 187567 | 218314 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) |
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");