Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25051 | 25051 | 204106 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 15 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991380.91771 | 2094122.22642 | 37.7295652311304 | -122.47210067183399 | (37.7295652311304, -122.472100671834) | |||
25562 | 25562 | 204156 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 106 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.12525 | 2090380.53407 | 37.719277536403496 | -122.472660407165 | (37.7192775364035, -122.472660407165) | |||
26935 | 26935 | 204142 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 126 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991215.491640001 | 2091740.4912900003 | 37.7230160055721 | -122.47249899053001 | (37.7230160055721, -122.47249899053) | |||
29593 | 29593 | 204122 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 72 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991266.86488 | 2092279.49348 | 37.7244989453441 | -122.472360679302 | (37.7244989453441, -122.472360679302) | |||
31270 | 31270 | 204114 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 61 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991316.326090001 | 2093291.62937 | 37.727280881195604 | -122.472263446404 | (37.7272808811956, -122.472263446404) | |||
32909 | 32909 | 204147 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 143 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991215.11855 | 2091556.56269 | 37.7225109615814 | -122.47248687756 | (37.7225109615814, -122.47248687756) | |||
34026 | 34026 | 204127 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 91 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991259.14537 | 2092125.38495 | 37.7240753547864 | -122.472376135061 | (37.7240753547864, -122.472376135061) | |||
38682 | 38682 | 204129 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 96 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991250.64251 | 2092078.2102299999 | 37.723945332582105 | -122.472402090391 | (37.7239453325821, -122.472402090391) | |||
41191 | 41191 | 204126 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 82 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991258.86268 | 2092183.21278 | 37.7242341192967 | -122.472381325945 | (37.7242341192967, -122.472381325945) | |||
41648 | 41648 | 204157 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 109 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991141.76494 | 2090345.5990099998 | 37.7191817082419 | -122.47265219366899 | (37.7191817082419, -122.472652193669) | |||
41931 | 41931 | 204135 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 114 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991224.97526 | 2091857.93043 | 37.72333901327 | -122.47247476549299 | (37.72333901327, -122.472474765493) | |||
42574 | 42574 | 204112 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 50 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991337.23651 | 2093405.4040700002 | 37.727594488284 | -122.472199449765 | (37.727594488284, -122.472199449765) | |||
44167 | 44167 | 204151 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 161 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991207.7087199995 | 2091371.2859599998 | 37.722001808625706 | -122.47249899053499 | (37.7220018086257, -122.472498990535) | |||
44251 | 44251 | 204144 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 131 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991226.84892 | 2091709.3466 | 37.7229311473308 | -122.47245746165599 | (37.7229311473308, -122.472457461656) | |||
44766 | 44766 | 204146 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 136 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991223.21581 | 2091608.2334599998 | 37.7226533053988 | -122.472462652551 | (37.7226533053988, -122.472462652551) | |||
45020 | 45020 | 204113 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 60 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991329.44333 | 2093302.97472 | 37.7273127918355 | -122.472218927258 | (37.7273127918355, -122.472218927258) | |||
50819 | 50819 | 204109 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 24 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991367.8639400005 | 2093922.92982 | 37.7290172571279 | -122.472131278448 | (37.7290172571279, -122.472131278448) | |||
54034 | 54034 | 204119 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991263.55519 | 2092524.5586400002 | 37.725171641833 | -122.47238997742599 | (37.725171641833, -122.472389977426) | |||
57729 | 57729 | 204130 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 105 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991232.43649 | 2091974.41455 | 37.7236592816427 | -122.47245746163901 | (37.7236592816427, -122.472457461639) | |||
61374 | 61374 | 204137 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 117 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991221.343090001 | 2091828.09873 | 37.7232568925832 | -122.472485147293 | (37.7232568925832, -122.472485147293) | |||
63674 | 63674 | 204145 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 135 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991223.03412 | 2091647.11797 | 37.722760062121104 | -122.472466114031 | (37.7227600621211, -122.472466114031) | |||
66487 | 66487 | 204111 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 30 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991347.410519999 | 2093620.7950099998 | 37.728186486813 | -122.47217997225 | (37.728186486813, -122.47217997225) | |||
67179 | 67179 | 204154 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 96 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991156.52869 | 2090538.7202700002 | 37.7197128262716 | -122.47261523421001 | (37.7197128262716, -122.47261523421) | |||
68593 | 68593 | 204115 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 71 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991313.39141 | 2093228.77227 | 37.7271081214352 | -122.472269011404 | (37.7271081214352, -122.472269011404) | |||
68648 | 68648 | 204125 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 81 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991261.30507 | 2092204.0965 | 37.724291602167895 | -122.472374404752 | (37.7242916021679, -122.472374404752) | |||
70012 | 70012 | 204132 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 110 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991228.632230001 | 2091912.6848400002 | 37.7234895669738 | -122.47246611402001 | (37.7234895669738, -122.47246611402) | |||
73592 | 73592 | 204117 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 40 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991283.0301 | 2092546.08035 | 37.7252318622439 | -122.472324223488 | (37.7252318622439, -122.472324223488) | |||
128099 | 128099 | 204108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991375.05495 | 2094034.9872599998 | 37.7293253549616 | -122.47211458342501 | (37.7293253549616, -122.472114583425) | |||
129874 | 129874 | 204123 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 73 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991264.39886 | 2092255.8714400001 | 37.7244339423611 | -122.47236748268101 | (37.7244339423611, -122.472367482681) | |||
130626 | 130626 | 204118 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 42 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991251.557569999 | 2092525.31005 | 37.72517301061529 | -122.47243150632 | (37.7251730106153, -122.47243150632) | |||
130653 | 130653 | 204150 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 158 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991209.7349 | 2091396.16713 | 37.722070243443206 | -122.47249379964799 | (37.7220702434432, -122.472493799648) | |||
134146 | 134146 | 204110 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 24 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991353.72908 | 2093672.3585599998 | 37.728328433101794 | -122.472161885976 | (37.7283284331018, -122.472161885976) | |||
134489 | 134489 | 204131 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 107 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991246.04706 | 2091955.1858 | 37.723607272029604 | -122.472409011575 | (37.7236072720296, -122.472409011575) | |||
150795 | 150795 | 204124 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 77 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991262.393519999 | 2092231.98748 | 37.7243682468726 | -122.47237267447201 | (37.7243682468726, -122.472372674472) | |||
150832 | 150832 | 204103 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Junipero Serra Blvd | 14 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991407.75535 | 2094527.8682 | 37.7306805748458 | -122.472037446768 | (37.7306805748458, -122.472037446768) | |||
152085 | 152085 | 204148 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 148 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991212.9902099995 | 2091479.34405 | 37.7222988151126 | -122.472488607883 | (37.7222988151126, -122.472488607883) | |||
152667 | 152667 | 204138 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 118 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991222.04967 | 2091814.1267099997 | 37.723218569775796 | -122.47248168668001 | (37.7232185697758, -122.47248168668) | |||
161329 | 161329 | 204155 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991146.25454 | 2090417.6717700001 | 37.7193798621823 | -122.47264192698 | (37.7193798621823, -122.47264192698) | |||
161668 | 161668 | 204120 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 60 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991274.407240001 | 2092398.22017 | 37.724825375875604 | -122.472343257638 | (37.7248253758756, -122.472343257638) | |||
162792 | 162792 | 204133 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 111 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991241.7215 | 2091892.4700799999 | 37.723434819851704 | -122.47241939423401 | (37.7234348198517, -122.472419394234) | |||
167367 | 167367 | 204104 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Junipero Serra Blvd | 18 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991407.12299 | 2094497.8635 | 37.73059815287271 | -122.472037446779 | (37.7305981528727, -122.472037446779) | |||
167615 | 167615 | 204139 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 120 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991219.21165 | 2091798.23539 | 37.7231747718824 | -122.47249033908501 | (37.7231747718824, -122.472490339085) | |||
167766 | 167766 | 204134 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 112 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991228.00205 | 2091882.78985 | 37.7234074462669 | -122.472466114014 | (37.7234074462669, -122.472466114014) | |||
167990 | 167990 | 204143 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 127 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991229.50143 | 2091740.19596 | 37.7230160055595 | -122.47245054047801 | (37.7230160055595, -122.472450540478) | |||
170045 | 170045 | 204116 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 72 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991324.66318 | 2093228.93526 | 37.727109221303294 | -122.472230057288 | (37.7271092213033, -122.472230057288) | |||
171798 | 171798 | 204141 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 122 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991228.41386 | 2091783.5857799998 | 37.723135080309 | -122.472457461666 | (37.723135080309, -122.472457461666) | |||
172096 | 172096 | 204121 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 65 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991270.79215 | 2092345.4595299999 | 37.7246802990344 | -122.472351910019 | (37.7246802990344, -122.472351910019) | |||
175436 | 175436 | 204152 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991169.92245 | 2090751.38969 | 37.7202975393725 | -122.472584434247 | (37.7202975393725, -122.472584434247) | |||
177342 | 177342 | 204149 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 154 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991212.71454 | 2091446.3716400003 | 37.722208265075004 | -122.47248715816299 | (37.722208265075, -122.472487158163) | |||
182072 | 182072 | 204153 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 52 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991161.67549 | 2090655.1387900002 | 37.720032780762104 | -122.47260592714198 | (37.7200327807621, -122.472605927142) | |||
183959 | 183959 | 204136 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 115 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991237.83729 | 2091850.68057 | 37.7233198514003 | -122.472429776026 | (37.7233198514003, -122.472429776026) | |||
185902 | 185902 | 204107 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 19 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991377.14521 | 2094057.78597 | 37.7293880754752 | -122.472109018414 | (37.7293880754752, -122.472109018414) | |||
186048 | 186048 | 204140 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 121 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991218.48026 | 2091787.2847 | 37.7231446616675 | -122.472492069365 | (37.7231446616675, -122.472492069365) | |||
187020 | 187020 | 204105 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Junipero Serra Blvd | 40 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991399.0300199995 | 2094388.9297200001 | 37.7302985797068 | -122.47205748816499 | (37.7302985797068, -122.472057488165) | |||
188245 | 188245 | 204128 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 93 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991254.18034 | 2092103.55707 | 37.72401513347929 | -122.472391707724 | (37.7240151334793, -122.472391707724) |
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");