Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26766 | 26766 | 226445 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3176 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008495.22679 | 2101571.86166 | 37.7509958309158 | -122.41346120966001 | (37.7509958309158, -122.41346120966) | |||
29032 | 29032 | 229738 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1498 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009552.901980001 | 2100679.56843 | 37.748605121741 | -122.409740673009 | (37.748605121741, -122.409740673009) | |||
29106 | 29106 | 229884 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 6009563.00843 | 2097787.4840700002 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | |||
35377 | 35377 | 226460 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007913.34927 | 2105633.2143 | 37.7621146889646 | -122.41576094971799 | (37.7621146889646, -122.415760949718) | |||
41798 | 41798 | 229805 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3526 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6006031.82091 | 2105526.37435 | 37.7617153800751 | -122.42226085285499 | (37.7617153800751, -122.422260852855) | |||
45444 | 45444 | 228545 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1449 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009584.1188 | 2100794.69775 | 37.7489229907161 | -122.409640850052 | (37.7489229907161, -122.409640850052) | |||
52736 | 52736 | 46565 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) | ||
54584 | 54584 | 226418 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008030.04777 | 2101411.71526 | 37.7505299748764 | -122.41505851533199 | (37.7505299748764, -122.415058515332) | |||
58419 | 58419 | 229789 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007559.601009999 | 2107340.5709599997 | 37.766782799923206 | -122.41710541639401 | (37.7667827999232, -122.417105416394) | |||
59781 | 59781 | 226763 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.42370957704901 | (37.7463491139326, -122.423709577049) | |||
65005 | 65005 | 190693 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6015286.012680001 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | |||
65211 | 65211 | 226786 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003740.86919 | 2104813.8958400004 | 37.75962959324121 | -122.43013350186399 | (37.7596295932412, -122.430133501864) | |||
67736 | 67736 | 226415 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009167.57752 | 2102926.6389599997 | 37.754753474499005 | -122.411231837073 | (37.754753474499, -122.411231837073) | |||
72049 | 72049 | 229806 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006429.32331 | 2105675.27923 | 37.7621466517725 | -122.42089662180099 | (37.7621466517725, -122.420896621801) | |||
73964 | 73964 | 226321 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008080.72157 | 2101209.59973 | 37.749977858609796 | -122.414868977829 | (37.7499778586098, -122.414868977829) | |||
75612 | 75612 | 229880 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 482 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003343.61389 | 2100112.58509 | 37.7466983971062 | -122.43117183930201 | (37.7466983971062, -122.431171839302) | |||
107413 | 107413 | 34770 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1112 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.41508178857401 | (37.7505995211504, -122.415081788574) | |
108045 | 108045 | 34772 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1112 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.41508178857401 | (37.7505995211504, -122.415081788574) | |
128810 | 128810 | 34771 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1112 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.41508178857401 | (37.7505995211504, -122.415081788574) | |
136494 | 136494 | 138815 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 456 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005166.9007 | 2111130.9467 | 37.7770553630765 | -122.425651176317 | (37.7770553630765, -122.425651176317) | |||
147726 | 147726 | 226417 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.41506006306801 | (37.7504761135956, -122.415060063068) | |||
152834 | 152834 | 58816 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1939 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 11 | Permit Number 31012 | 6012209.883830001 | 2104659.20803 | 37.7596808806999 | -122.40083236114401 | (37.7596808806999, -122.400832361144) | |
155399 | 155399 | 226369 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | |||
156159 | 156159 | 190710 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012743.458769999 | 2104190.05175 | 37.7584224278606 | -122.39895404970699 | (37.7584224278606, -122.398954049707) | |||
158910 | 158910 | 32965 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 550 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 11 | 7x6 | Permit Number 37280 | 6014071.41137 | 2104533.66356 | 37.7594398192185 | -122.394385423553 | (37.7594398192185, -122.394385423553) |
159634 | 159634 | 229829 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1472 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6010097.10021 | 2100699.13339 | 37.7486893243481 | -122.407860213076 | (37.7486893243481, -122.407860213076) | |||
159724 | 159724 | 190709 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | |||
162081 | 162081 | 226437 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006735.95617 | 2102521.24604 | 37.7535036857516 | -122.419612305359 | (37.7535036857516, -122.419612305359) | |||
162761 | 162761 | 100088 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6003201.40964 | 2118956.6592900003 | 37.7984315255609 | -122.43300966237301 | (37.7984315255609, -122.433009662373) |
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");