Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27143 | 27143 | 197825 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011965.06287 | 2091392.40975 | 37.7232394169387 | -122.40074704065701 | (37.7232394169387, -122.400747040657) | |||
30563 | 30563 | 197865 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012061.31156 | 2091075.0392200002 | 37.7223733500335 | -122.400392044067 | (37.7223733500335, -122.400392044067) | |||
32085 | 32085 | 197864 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012060.1959 | 2091081.01697 | 37.7223897015024 | -122.400396320338 | (37.7223897015024, -122.400396320338) | |||
32658 | 32658 | 197832 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011977.7440599995 | 2091356.8323099997 | 37.7231424358482 | -122.400700705798 | (37.7231424358482, -122.400700705798) | |||
33327 | 33327 | 197866 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6012063.85801 | 2091068.416 | 37.7223553060236 | -122.40038277654499 | (37.7223553060236, -122.400382776545) | |||
34615 | 34615 | 197842 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012001.83454 | 2091273.05649 | 37.7229137481456 | -122.400611547001 | (37.7229137481456, -122.400611547001) | |||
34785 | 34785 | 197862 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6012051.726319999 | 2091110.75942 | 37.7224708958979 | -122.400427686008 | (37.7224708958979, -122.400427686008) | |||
36152 | 36152 | 197853 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012031.29161 | 2091170.72572 | 37.7226344115455 | -122.400502534772 | (37.7226344115455, -122.400502534772) | |||
36868 | 36868 | 197828 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011973.2449 | 2091368.8338900001 | 37.7231751387972 | -122.40071710133002 | (37.7231751387972, -122.40071710133) | |||
40386 | 40386 | 197821 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6011948.3491 | 2091445.19124 | 37.7233834118888 | -122.40080852368799 | (37.7233834118888, -122.400808523688) | |||
45615 | 45615 | 197863 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6012058.46574 | 2091087.21256 | 37.7224066168474 | -122.400402736103 | (37.7224066168474, -122.400402736103) | |||
47089 | 47089 | 197845 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012007.9467400005 | 2091249.84858 | 37.7228503648454 | -122.400588788767 | (37.7228503648454, -122.400588788767) | |||
48301 | 48301 | 197854 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6012033.02176 | 2091164.53012 | 37.7226174961786 | -122.400496118999 | (37.7226174961786, -122.400496118999) | |||
56679 | 56679 | 197819 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011944.173880001 | 2091457.7319099999 | 37.72341761312129 | -122.400823837369 | (37.7234176131213, -122.400823837369) | |||
57257 | 57257 | 197860 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012046.4319 | 2091124.21465 | 37.722507545966 | -122.400446932379 | (37.722507545966, -122.400446932379) | |||
58546 | 58546 | 197855 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6012034.51067 | 2091159.2407799999 | 37.722603055763 | -122.400490600775 | (37.722603055763, -122.400490600775) | |||
60277 | 60277 | 197857 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6012039.29397 | 2091145.5342400002 | 37.7225656871526 | -122.400473103552 | (37.7225656871526, -122.400473103552) | |||
68409 | 68409 | 197818 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6011942.23236 | 2091464.77748 | 37.7234368505223 | -122.400831043644 | (37.7234368505223, -122.400831043644) | |||
68740 | 68740 | 197839 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6011996.37526 | 2091289.30529 | 37.7229580595596 | -122.40063155961701 | (37.7229580595596, -122.400631559617) | |||
71389 | 71389 | 197840 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011997.53285 | 2091285.37995 | 37.722947345938394 | -122.40062728242701 | (37.7229473459384, -122.400627282427) | |||
72034 | 72034 | 197843 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011998.75435 | 2091272.95857 | 37.722913307489 | -122.40062218776899 | (37.722913307489, -122.400622187769) | |||
77231 | 77231 | 197858 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6012040.59295 | 2091139.6421700001 | 37.7225495811701 | -122.40046819956999 | (37.7225495811701, -122.40046819957) | |||
130496 | 130496 | 197827 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011971.4942 | 2091374.0034400001 | 37.7231892356806 | -122.40072351619101 | (37.7231892356806, -122.400723516191) | |||
131642 | 131642 | 197861 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 6ft | 6012050.3961 | 2091116.33081 | 37.7224861196182 | -122.40043267545299 | (37.7224861196182, -122.400432675453) | |||
131830 | 131830 | 197841 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011999.88138 | 2091279.17179 | 37.7229304305803 | -122.400618728092 | (37.7229304305803, -122.400618728092) | |||
131860 | 131860 | 197831 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6011976.53228 | 2091358.0890799998 | 37.7231458190956 | -122.40070498295601 | (37.7231458190956, -122.400704982956) | |||
134275 | 134275 | 197826 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011969.15818 | 2091380.8270900003 | 37.7232078417381 | -122.40073207055401 | (37.7232078417381, -122.400732070554) | |||
136021 | 136021 | 197846 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6012009.495680001 | 2091244.88882 | 37.7228368327421 | -122.400583086137 | (37.7228368327421, -122.400583086137) | |||
136043 | 136043 | 197844 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012002.51285 | 2091266.59207 | 37.7228960359976 | -122.400608748319 | (37.7228960359976, -122.400608748319) | |||
137585 | 137585 | 197824 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6011961.73381 | 2091401.10214 | 37.723263098784706 | -122.40075915902399 | (37.7232630987847, -122.400759159024) | |||
149177 | 149177 | 197856 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6012037.62299 | 2091152.5684099998 | 37.722584908363 | -122.40047937365101 | (37.722584908363, -122.400479373651) | |||
150558 | 150558 | 197829 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011975.02506 | 2091365.10159 | 37.7231649899516 | -122.400710685553 | (37.7231649899516, -122.400710685553) | |||
156745 | 156745 | 197851 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012026.99861 | 2091182.7231 | 37.7226671144898 | -122.400518217155 | (37.7226671144898, -122.400518217155) | |||
156996 | 156996 | 197834 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011984.73293 | 2091325.2723299998 | 37.723056168383295 | -122.400674330476 | (37.7230561683833, -122.400674330476) | |||
158390 | 158390 | 197867 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012066.20658 | 2091062.20785 | 37.7223383906757 | -122.400374222197 | (37.7223383906757, -122.400374222197) | |||
160157 | 160157 | 197849 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6012013.93234 | 2091229.80813 | 37.722795671678796 | -122.400566690598 | (37.7227956716788, -122.400566690598) | |||
167198 | 167198 | 197830 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011976.224330001 | 2091363.229 | 37.723159915090704 | -122.40070640839701 | (37.7231599150907, -122.400706408397) | |||
169839 | 169839 | 197820 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6011946.65761 | 2091451.71293 | 37.7234012247695 | -122.40081482885599 | (37.7234012247695, -122.400814828856) | |||
170715 | 170715 | 197838 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011994.83884 | 2091294.88087 | 37.722973283274605 | -122.40063726222701 | (37.7229732832746, -122.400637262227) | |||
170741 | 170741 | 197847 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012011.01959 | 2091238.6974099998 | 37.7228199173828 | -122.40057738355499 | (37.7228199173828, -122.400577383555) | |||
171775 | 171775 | 197817 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6011940.31193 | 2091472.8608799998 | 37.723458938768104 | -122.400838249897 | (37.7234589387681, -122.400838249897) | |||
172263 | 172263 | 197868 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6012067.53263 | 2091056.4311900001 | 37.722322603090504 | -122.40036923277701 | (37.7223226030905, -122.400369232777) | |||
174764 | 174764 | 197837 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011988.7407 | 2091309.3789099997 | 37.723012751823 | -122.40065936036699 | (37.723012751823, -122.400659360367) | |||
176686 | 176686 | 197835 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011986.88775 | 2091319.6841900002 | 37.7230409446734 | -122.400666489273 | (37.7230409446734, -122.400666489273) | |||
177376 | 177376 | 197859 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012044.049980001 | 2091128.7806099998 | 37.7225199503291 | -122.400455486754 | (37.7225199503291, -122.400455486754) | |||
178115 | 178115 | 197833 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6011978.85578 | 2091350.64928 | 37.7231255205156 | -122.40069642862301 | (37.7231255205156, -122.400696428623) | |||
182350 | 182350 | 197823 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011949.3976 | 2091439.17555 | 37.723366952515995 | -122.400804476766 | (37.723366952516, -122.400804476766) | |||
185140 | 185140 | 197852 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6012028.934719999 | 2091176.5233200002 | 37.7226501991326 | -122.40051108911999 | (37.7226501991326, -122.40051108912) | |||
188059 | 188059 | 197850 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 6012015.45208 | 2091223.4114400002 | 37.722778192429104 | -122.40056098802499 | (37.7227781924291, -122.400560988025) | |||
188159 | 188159 | 197822 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011948.87446 | 2091441.14937 | 37.723372343042996 | -122.40080642377899 | (37.723372343043, -122.400806423779) | |||
188673 | 188673 | 197836 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011988.43693 | 2091314.7241 | 37.7230274116816 | -122.40066078576099 | (37.7230274116816, -122.400660785761) | |||
189036 | 189036 | 197848 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6012012.98096 | 2091233.72895 | 37.722806384392 | -122.400570254626 | (37.722806384392, -122.400570254626) |
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");