Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25560 | 25560 | 131008 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013685.844769999 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | |||
26160 | 26160 | 194311 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 7ft | 6015171.2298099995 | 2116694.38601 | 37.79289152546961 | -122.39143182424401 | (37.7928915254696, -122.391431824244) | |||
28694 | 28694 | 246559 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.42360165389299 | (37.7722588698898, -122.423601653893) | |||
28854 | 28854 | 246564 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | |||
30102 | 30102 | 246567 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | |||
31237 | 31237 | 124292 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 5993800.52883 | 2114192.89776 | 37.7848138297402 | -122.465193144089 | (37.7848138297402, -122.465193144089) | |||
31536 | 31536 | 135595 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6013640.01114 | 2117757.01067 | 37.7957241381178 | -122.39680448565001 | (37.7957241381178, -122.39680448565) | |||
32751 | 32751 | 246565 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.772520866678796 | -122.423667646169 | (37.7725208666788, -122.423667646169) | |||
32926 | 32926 | 195231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6017124.15925 | 2097442.52392 | 37.7401382376012 | -122.38333380241001 | (37.7401382376012, -122.38333380241) | |||
34522 | 34522 | 196562 | DPW Maintained 3 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1498x Tennessee St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6015638.13327 | 2101940.5200799997 | 37.7524065650316 | -122.388785850611 | (37.7524065650316, -122.388785850611) | |||
35824 | 35824 | 131007 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013687.07221 | 2117423.5151299997 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | |||
36823 | 36823 | 246562 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | |||
38029 | 38029 | 135591 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6013668.97989 | 2117535.62616 | 37.7951178808501 | -122.39668872043 | (37.7951178808501, -122.39668872043) | |||
38423 | 38423 | 135585 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013716.425530001 | 2117200.6985 | 37.7942008889087 | -122.396501061571 | (37.7942008889087, -122.396501061571) | |||
41025 | 41025 | 135586 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6013710.78377 | 2117230.4416 | 37.794282242493 | -122.39652266870701 | (37.794282242493, -122.396522668707) | |||
41054 | 41054 | 194324 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 6014719.872819999 | 2117222.0655900002 | 37.7943153492131 | -122.39303049145701 | (37.7943153492131, -122.393030491457) | |||
41368 | 41368 | 197881 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.75240923331361 | -122.38875758671101 | (37.7524092333136, -122.388757586711) | |||
41580 | 41580 | 197879 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015633.716580001 | 2101939.6096099997 | 37.752403820278396 | -122.388801060829 | (37.7524038202784, -122.388801060829) | |||
43842 | 43842 | 197877 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015625.5144 | 2101938.71923 | 37.7524009208729 | -122.388829363409 | (37.7524009208729, -122.388829363409) | |||
44028 | 44028 | 135590 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 7ft | 6013675.90495 | 2117467.1976 | 37.7949303775801 | -122.396659959189 | (37.7949303775801, -122.396659959189) | |||
49952 | 49952 | 135593 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013643.30781 | 2117724.86941 | 37.795636069300606 | -122.396790824061 | (37.7956360693006, -122.396790824061) | |||
50862 | 50862 | 221283 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005964.92172 | 2109129.81976 | 37.771605811889295 | -122.422748322291 | (37.7716058118893, -122.422748322291) | |||
52941 | 52941 | 197880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6015641.85781 | 2101940.61128 | 37.752407021878 | -122.388772976792 | (37.752407021878, -122.388772976792) | |||
53164 | 53164 | 221287 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005922.32152 | 2109128.4640099998 | 37.7715996856938 | -122.42289558268601 | (37.7715996856938, -122.422895582686) | |||
53516 | 53516 | 135600 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013623.6813 | 2117874.05106 | 37.7960445944406 | -122.39686919997 | (37.7960445944406, -122.39686919997) | |||
54511 | 54511 | 131009 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013684.354719999 | 2117443.2289299998 | 37.794865035532396 | -122.396629040522 | (37.7948650355324, -122.396629040522) | |||
58148 | 58148 | 246560 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | |||
58158 | 58158 | 221288 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005916.40156 | 2109112.96669 | 37.7715567997353 | -122.422914958583 | (37.7715567997353, -122.422914958583) | |||
58653 | 58653 | 197884 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6015678.84769 | 2101942.9496400002 | 37.7524154925876 | -122.388645221797 | (37.7524154925876, -122.388645221797) | |||
60619 | 60619 | 197886 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | |||
62755 | 62755 | 246558 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.772239401347605 | -122.423593061791 | (37.7722394013476, -122.423593061791) | |||
66652 | 66652 | 246571 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | |||
67913 | 67913 | 135584 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013720.96572 | 2117170.97741 | 37.7941195344513 | -122.39648326760201 | (37.7941195344513, -122.396483267602) | |||
69195 | 69195 | 246561 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.42361988494801 | (37.7722999149342, -122.423619884948) | |||
69580 | 69580 | 188649 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.734213959905205 | -122.393020304839 | (37.7342139599052, -122.393020304839) | |||
70019 | 70019 | 194312 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 7ft | 6015090.90053 | 2116737.38808 | 37.7930051404365 | -122.391712777831 | (37.7930051404365, -122.391712777831) | |||
72003 | 72003 | 194321 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.794035312034104 | -122.392743821769 | (37.7940353120341, -122.392743821769) | |||
129785 | 129785 | 135594 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013641.29963 | 2117738.5675 | 37.7956735692465 | -122.396798733574 | (37.7956735692465, -122.396798733574) | |||
130105 | 130105 | 246569 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005694.6084199995 | 2109539.50826 | 37.772715462883 | -122.42371248725401 | (37.772715462883, -122.423712487254) | |||
131405 | 131405 | 194320 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | |||
133391 | 133391 | 194310 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015149.43028 | 2116672.0498900004 | 37.7928289857212 | -122.39150569005301 | (37.7928289857212, -122.391505690053) | |||
133666 | 133666 | 135589 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013690.1191300005 | 2117409.79568 | 37.79477355652 | -122.396606749907 | (37.79477355652, -122.396606749907) | |||
136668 | 136668 | 194314 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015030.092180001 | 2116803.1524 | 37.793182338337296 | -122.39192778056601 | (37.7931823383373, -122.391927780566) | |||
146587 | 146587 | 135587 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6013707.40444 | 2117263.065 | 37.794371630605795 | -122.39653664955699 | (37.7943716306058, -122.396536649557) | |||
147917 | 147917 | 135592 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6013656.57361 | 2117641.2066 | 37.7954070893311 | -122.39673905365801 | (37.7954070893311, -122.396739053658) | |||
149997 | 149997 | 221282 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005974.66789 | 2109113.44306 | 37.7715613952811 | -122.42271344567301 | (37.7715613952811, -122.422713445673) | |||
150043 | 150043 | 135601 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013619.0965 | 2117904.14877 | 37.7961269804374 | -122.396887175602 | (37.7961269804374, -122.396887175602) | |||
150266 | 150266 | 135599 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013626.9255 | 2117849.56722 | 37.7959775481806 | -122.39685625692499 | (37.7959775481806, -122.396856256925) | |||
152011 | 152011 | 194318 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 7ft | 6014918.376630001 | 2116934.10067 | 37.7935356891802 | -122.392323489462 | (37.7935356891802, -122.392323489462) | |||
152965 | 152965 | 246568 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | |||
153591 | 153591 | 135582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013728.8853 | 2117108.6329200002 | 37.7939487918665 | -122.396451492763 | (37.7939487918665, -122.396451492763) | |||
159619 | 159619 | 246563 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005707.64026 | 2109451.4652299997 | 37.7724744535597 | -122.42366114764499 | (37.7724744535597, -122.423661147645) | |||
160227 | 160227 | 194315 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015053.743430001 | 2116822.79374 | 37.793237581902105 | -122.391847319118 | (37.7932375819021, -122.391847319118) | |||
162235 | 162235 | 194317 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014996.79198 | 2116890.75749 | 37.7934210328094 | -122.392049131461 | (37.7934210328094, -122.392049131461) | |||
164121 | 164121 | 246566 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.42367055365101 | (37.772540436826, -122.423670553651) | |||
166628 | 166628 | 221284 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005955.036180001 | 2109112.17277 | 37.7715567997324 | -122.42278126266001 | (37.7715567997324, -122.42278126266) | |||
168848 | 168848 | 135596 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013635.89834 | 2117779.6494400003 | 37.7957860699142 | -122.396820304724 | (37.7957860699142, -122.396820304724) | |||
171516 | 171516 | 194323 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 7ft | 6014746.37404 | 2117187.8708099998 | 37.7942229303951 | -122.39293639989201 | (37.7942229303951, -122.392936399892) | |||
171564 | 171564 | 135597 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6013633.10727 | 2117805.98643 | 37.7958582297137 | -122.39683180976299 | (37.7958582297137, -122.396831809763) | |||
171792 | 171792 | 246570 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005693.82305 | 2109545.39115 | 37.7727315715478 | -122.423715622299 | (37.7727315715478, -122.423715622299) | |||
173545 | 173545 | 197882 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.752409573246396 | -122.388743532098 | (37.7524095732464, -122.388743532098) | |||
174052 | 174052 | 194319 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.793601355862705 | -122.392257538577 | (37.7936013558627, -122.392257538577) | |||
174594 | 174594 | 197878 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | |||
177428 | 177428 | 135583 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013725.73224 | 2117134.30218 | 37.794019098152205 | -122.396464202864 | (37.7940190981522, -122.396464202864) | |||
177458 | 177458 | 221286 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005932.045 | 2109110.97186 | 37.77155220509079 | -122.42286070518 | (37.7715522050908, -122.42286070518) | |||
178229 | 178229 | 246557 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005728.07536 | 2109359.1735900003 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | |||
179167 | 179167 | 135588 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013703.14985 | 2117288.7562700002 | 37.794441936008894 | -122.39655317280899 | (37.7944419360089, -122.396553172809) | |||
180517 | 180517 | 135598 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013629.78784 | 2117826.7467900002 | 37.7959150479945 | -122.396844751899 | (37.7959150479945, -122.396844751899) | |||
181397 | 181397 | 197883 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.752414760540105 | -122.388669977447 | (37.7524147605401, -122.388669977447) | |||
182110 | 182110 | 194322 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014773.3420400005 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | |||
186747 | 186747 | 194316 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 7ft | 6014969.23068 | 2116866.2603700003 | 37.793352239169295 | -122.392142782374 | (37.7933522391693, -122.392142782374) | |||
186864 | 186864 | 197885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015684.0853699995 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | |||
187319 | 187319 | 221285 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005941.9303 | 2109128.61885 | 37.771601217256396 | -122.422827765695 | (37.7716012172564, -122.422827765695) | |||
187874 | 187874 | 194313 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) |
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");