Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10069 | 10069 | 7948 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1701 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2014 12:00:00 AM | 6 | 3X3 | 6005705.32484 | 2116013.7592599997 | 37.790492771869005 | -122.42413593393499 | (37.790492771869, -122.424135933935) | ||
13712 | 13712 | 6809 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.9784699995 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | ||
14629 | 14629 | 14993 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6016309.01096 | 2097636.9306 | 37.740626956171496 | -122.38616582959 | (37.7406269561715, -122.38616582959) | ||
15010 | 15010 | 6841 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.0043599997 | 37.7408861578704 | -122.38663127193199 | (37.7408861578704, -122.386631271932) | ||
15227 | 15227 | 6810 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016518.03729 | 2097563.6173900003 | 37.74043721991 | -122.38543798216999 | (37.74043721991, -122.38543798217) | ||
15782 | 15782 | 6842 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 07:14:00 AM | 3 | 3X3 | 6016194.23735 | 2097718.16262 | 37.740843649614206 | -122.38656833917901 | (37.7408436496142, -122.386568339179) | ||
16973 | 16973 | 10247 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | ||
18351 | 18351 | 10343 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 940 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001599.8151 | 2109085.1313 | 37.7712358586189 | -122.437844249148 | (37.7712358586189, -122.437844249148) | |||
18938 | 18938 | 10354 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.771092330601604 | -122.439069286514 | (37.7710923306016, -122.439069286514) | ||
18989 | 18989 | 10323 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 774 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2009 12:00:00 AM | 3 | 3X3 | 6002445.3097 | 2109202.4042 | 37.771605902741705 | -122.43492804083999 | (37.7716059027417, -122.43492804084) | ||
19165 | 19165 | 10233 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | |||
19533 | 19533 | 25491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069334998 | (37.7717244144917, -122.43292069335) | ||
21724 | 21724 | 10299 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.43139282162599 | (37.7719205287291, -122.431392821626) | |||
21845 | 21845 | 10257 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.145880001 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | ||
23042 | 23042 | 10300 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303002 | (37.772060883831, -122.43134154303) | |||
23175 | 23175 | 25492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.43286102333299 | (37.7717331028377, -122.432861023333) | ||
81436 | 81436 | 6830 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
82897 | 82897 | 15297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1625 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1995 12:00:00 AM | 0 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | ||
83488 | 83488 | 6826 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
85140 | 85140 | 10309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 629 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2011 12:00:00 AM | 3 | 3X3 | 6003124.536169999 | 2109214.79731 | 37.7716784730152 | -122.43257944422399 | (37.7716784730152, -122.432579444224) | ||
86179 | 86179 | 6837 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1475 FAIRFAX AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 6 | 3X3 | 6016157.0 | 2097767.0 | 37.740975685587394 | -122.386700497992 | (37.7409756855874, -122.386700497992) | ||
91795 | 91795 | 6840 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1469 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016172.0 | 2097718.0 | 37.740841972016504 | -122.386645216998 | (37.7408419720165, -122.386645216998) | ||
104221 | 104221 | 6822 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
104856 | 104856 | 10264 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
105727 | 105727 | 15296 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1625 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | ||
107229 | 107229 | 6843 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2007 12:00:00 AM | 6 | 3X3 | 6016186.0 | 2097583.0 | 37.7404720645711 | -122.38658739858299 | (37.7404720645711, -122.386587398583) | ||
113110 | 113110 | 27335 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 12 | 3X3 | 6004279.72317 | 2109472.24988 | 37.7724508171595 | -122.428601935914 | (37.7724508171595, -122.428601935914) | ||
115984 | 115984 | 10311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 657 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1999 12:00:00 AM | 8 | 3X3 | 6003004.4895 | 2109163.37188 | 37.7715304629462 | -122.43299101798401 | (37.7715304629462, -122.432991017984) | ||
118460 | 118460 | 14967 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 395 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 6016770.717680001 | 2097736.2935200003 | 37.7409253302671 | -122.384576328932 | (37.7409253302671, -122.384576328932) | ||
120939 | 120939 | 10320 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 758 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1992 12:00:00 AM | 25 | 3X3 | 6002531.73322 | 2109228.96362 | 37.771683734938996 | -122.43463099668699 | (37.771683734939, -122.434630996687) | ||
121627 | 121627 | 10266 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
124744 | 124744 | 6820 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
126615 | 126615 | 4556 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1340X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 6004655.03099 | 2113461.96066 | 37.7834268147862 | -122.427588006915 | (37.7834268147862, -122.427588006915) | ||
127073 | 127073 | 6827 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
128886 | 128886 | 6821 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
139543 | 139543 | 10297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 540 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003554.89128 | 2109371.3672 | 37.7721327712956 | -122.43110199714701 | (37.7721327712956, -122.431101997147) | ||
140820 | 140820 | 10265 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) |
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");