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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4142 | 4142 | 216723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.9874099998 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | ||
4276 | 4276 | 180842 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.45115578601299 | (37.710473721248, -122.451155786013) | ||
4375 | 4375 | 176488 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.7164199995 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | ||
4432 | 4432 | 172375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574.0 | 2086750.0 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | ||
25776 | 25776 | 227129 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001319.20971 | 2096463.3667400002 | 37.7365635736601 | -122.43791067344401 | (37.7365635736601, -122.437910673444) | |||
26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
29298 | 29298 | 191239 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014110.40607 | 2095343.3649799998 | 37.7342073651799 | -122.39360733551399 | (37.7342073651799, -122.393607335514) | |||
35687 | 35687 | 191236 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014135.07988 | 2095376.9884099998 | 37.734301059229104 | -122.39352438203998 | (37.7343010592291, -122.39352438204) | |||
37096 | 37096 | 207011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.731209264673296 | -122.437660309391 | (37.7312092646733, -122.437660309391) | |||
37552 | 37552 | 227586 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003707.3650400005 | 2095900.15245 | 37.735152630897495 | -122.42961364516898 | (37.7351526308975, -122.429613645169) | |||
37870 | 37870 | 247053 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 507 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002585.442419999 | 2099146.1836099997 | 37.744001891474 | -122.43372445791599 | (37.744001891474, -122.433724457916) | |||
41022 | 41022 | 191235 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | |||
41920 | 41920 | 227112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | |||
42609 | 42609 | 227117 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003535.84775 | 2095026.7825099998 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | |||
44702 | 44702 | 227100 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004326.55063 | 2108840.26945 | 37.770718202624295 | -122.428394902803 | (37.7707182026243, -122.428394902803) | |||
45759 | 45759 | 206989 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | |||
46936 | 46936 | 207047 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997739.24902 | 2095008.6617599998 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | |||
47841 | 47841 | 207013 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000221.87075 | 2094376.8430299999 | 37.7307720044131 | -122.44155494671101 | (37.7307720044131, -122.441554946711) | |||
50864 | 50864 | 191241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014082.94285 | 2095307.88657 | 37.7341084226719 | -122.39369980292601 | (37.7341084226719, -122.393699802926) | |||
52837 | 52837 | 207008 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | |||
53235 | 53235 | 191238 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.734244107869294 | -122.393581327137 | (37.7342441078693, -122.393581327137) | |||
58507 | 58507 | 191240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014102.75792 | 2095335.27393 | 37.734184723832996 | -122.393633211698 | (37.734184723833, -122.393633211698) | |||
59266 | 59266 | 207018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | |||
60843 | 60843 | 227110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008268.06848 | 2099378.0671099997 | 37.7449594041621 | -122.41409156248001 | (37.7449594041621, -122.41409156248) | |||
63861 | 63861 | 207046 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | |||
72347 | 72347 | 191244 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014050.660540001 | 2095263.98772 | 37.733986091481206 | -122.39380834209801 | (37.7339860914812, -122.393808342098) | |||
72880 | 72880 | 248155 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010048.23979 | 2099492.4434599997 | 37.7453732829604 | -122.40794409015 | (37.7453732829604, -122.40794409015) | |||
73895 | 73895 | 176887 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002286.64114 | 2092541.4001799999 | 37.725849714484404 | -122.434285547657 | (37.7258497144844, -122.434285547657) | |||
76086 | 76086 | 207010 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999351.3193 | 2094355.62728 | 37.7306641145479 | -122.444563045861 | (37.7306641145479, -122.444563045861) | |||
76631 | 76631 | 207009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.44712329519699 | (37.7306499124634, -122.447123295197) | |||
82242 | 82242 | 176908 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007885.162769999 | 2093698.9537400003 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | |||
134827 | 134827 | 206996 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993365.5475 | 2104527.17443 | 37.758249235518605 | -122.465995428957 | (37.7582492355186, -122.465995428957) | |||
135130 | 135130 | 207012 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001339.26796 | 2094505.8060299999 | 37.731189705325 | -122.43770116826799 | (37.731189705325, -122.437701168268) | |||
138092 | 138092 | 176895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.724429133675706 | -122.42394810962 | (37.7244291336757, -122.42394810962) | |||
147287 | 147287 | 207017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997128.211759999 | 2093837.95674 | 37.7291156105912 | -122.452211290622 | (37.7291156105912, -122.452211290622) | |||
150344 | 150344 | 207049 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997703.569180001 | 2095007.7992 | 37.7323606631136 | -122.450306536421 | (37.7323606631136, -122.450306536421) | |||
152707 | 152707 | 191242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014072.32553 | 2095292.84785 | 37.734066539429996 | -122.39373545834299 | (37.73406653943, -122.393735458343) | |||
153555 | 153555 | 207048 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997718.79866 | 2095007.66028 | 37.7323611532403 | -122.450253874818 | (37.7323611532403, -122.450253874818) | |||
155776 | 155776 | 176897 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 338 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006634.64196 | 2092369.41813 | 37.7256233218417 | -122.419242591383 | (37.7256233218417, -122.419242591383) | |||
159032 | 159032 | 191243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014061.56884 | 2095278.41625 | 37.734026315459104 | -122.39377163804899 | (37.7340263154591, -122.393771638049) | |||
161455 | 161455 | 227116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | |||
172334 | 172334 | 227113 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007896.8692 | 2096132.1903 | 37.736026086627 | -122.415145389863 | (37.736026086627, -122.415145389863) | |||
183878 | 183878 | 176896 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005242.33299 | 2091887.7351799998 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | |||
188573 | 188573 | 206988 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.70798 | 2106532.5962799997 | 37.76371854889079 | -122.468361066814 | (37.7637185488908, -122.468361066814) |
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");