Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4397 | 4397 | 251730 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 536 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:34:00 AM | 3 | 3x3 | 6002599.0 | 2087392.0 | 37.71172832759 | -122.432838043044 | (37.71172832759, -122.432838043044) | ||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 626 | 626 | 251342 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 164938 | 164938 | 250939 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987146.614630001 | 2114364.81328 | 37.7848999087463 | -122.488225846149 | (37.7848999087463, -122.488225846149) | |||
| 59834 | 59834 | 250019 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 9 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6005819.0053199995 | 2114422.18901 | 37.786129133596 | -122.42362939977501 | (37.786129133596, -122.423629399775) | |||
| 36083 | 36083 | 250018 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6005787.19276 | 2114383.50511 | 37.7860211214227 | -122.42373671138701 | (37.7860211214227, -122.423736711387) | |||
| 74661 | 74661 | 250017 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6005762.80005 | 2114349.91412 | 37.7859275118887 | -122.423818714288 | (37.7859275118887, -122.423818714288) | |||
| 43715 | 43715 | 250016 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Geary Blvd | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6005727.9579 | 2114178.12622 | 37.785453857856396 | -122.42392703849701 | (37.7854538578564, -122.423927038497) | |||
| 172706 | 172706 | 250015 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Geary Blvd | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6005749.017530001 | 2114177.6932200002 | 37.7854538578504 | -122.42385414754801 | (37.7854538578504, -122.423854147548) | |||
| 47095 | 47095 | 250014 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6005647.6336900005 | 2114206.58605 | 37.7855274664505 | -122.424206961487 | (37.7855274664505, -122.424206961487) | |||
| 156530 | 156530 | 250013 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005644.7352599995 | 2114200.81788 | 37.78551146482779 | -122.42421657883499 | (37.7855114648278, -122.424216578835) | |||
| 137380 | 137380 | 250012 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6005639.67048 | 2114203.54458 | 37.785518665693004 | -122.424234295496 | (37.785518665693, -122.424234295496) | |||
| 60363 | 60363 | 250011 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005651.53308 | 2114225.44639 | 37.7855794724472 | -122.424194812544 | (37.7855794724472, -122.424194812544) | |||
| 163792 | 163792 | 250010 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005626.073059999 | 2114211.10885 | 37.785538667527206 | -122.424281876805 | (37.7855386675272, -122.424281876805) | |||
| 184617 | 184617 | 248072 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 416 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010239.621669999 | 2098600.89305 | 37.7429359925163 | -122.40721948389 | (37.7429359925163, -122.40721948389) | |||
| 182306 | 182306 | 247982 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 499 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009787.12522 | 2099515.94475 | 37.745423189940404 | -122.408848643548 | (37.7454231899404, -122.408848643548) | ||||
| 181293 | 181293 | 247981 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 499 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009794.7729400005 | 2099497.71505 | 37.7453735635492 | -122.40882091295 | (37.7453735635492, -122.40882091295) | ||||
| 37532 | 37532 | 247980 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009795.98268 | 2099453.55621 | 37.745252380808296 | -122.408813614968 | (37.7452523808083, -122.408813614968) | ||||
| 132363 | 132363 | 247979 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009785.29961 | 2099426.45333 | 37.7451773638476 | -122.40884864356899 | (37.7451773638476, -122.408848643569) | ||||
| 3609 | 3609 | 246906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 491 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2010 12:00:00 AM | 3 | Width 5ft | Permit Number 53958 | 5997348.6484 | 2107404.24528 | 37.7663779224388 | -122.45242781498699 | (37.7663779224388, -122.452427814987) | |
| 46116 | 46116 | 246214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1373 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999530.9631 | 2107941.1564 | 37.767976932332104 | -122.44491821917102 | (37.7679769323321, -122.444918219171) | |||
| 133975 | 133975 | 244091 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 446 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997969.1784 | 2109020.1206 | 37.7708502353846 | -122.45039802329399 | (37.7708502353846, -122.450398023294) | |||
| 160142 | 160142 | 244090 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 446 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997971.242000001 | 2109006.5008 | 37.7708129570081 | -122.45038990331498 | (37.7708129570081, -122.450389903315) | |||
| 27307 | 27307 | 244089 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 426 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997974.5438 | 2108985.8648 | 37.7707564848077 | -122.450376994548 | (37.7707564848077, -122.450376994548) | |||
| 164997 | 164997 | 244088 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 426 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997977.0201 | 2108966.4669 | 37.77070336486629 | -122.45036703046999 | (37.7707033648663, -122.45036703047) | |||
| 130257 | 130257 | 233255 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 311 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004404.21894 | 2098371.94813 | 37.741979053604005 | -122.42738039561199 | (37.741979053604, -122.427380395612) | |||
| 25883 | 25883 | 233254 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 25 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004291.56909 | 2098141.11691 | 37.741338872095604 | -122.42775345958201 | (37.7413388720956, -122.427753459582) | |||
| 131298 | 131298 | 233253 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3975 22nd St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 8ft | 6002008.6874400005 | 2102930.09723 | 37.7543588771711 | -122.435989447265 | (37.7543588771711, -122.435989447265) | |||
| 166135 | 166135 | 233252 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3975 22nd St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 8ft | 6002009.58481 | 2102922.7662 | 37.7543387988987 | -122.43598581939501 | (37.7543387988987, -122.435985819395) | |||
| 58622 | 58622 | 233251 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 210 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004243.47514 | 2108758.37955 | 37.7704886515521 | -122.428676423893 | (37.7704886515521, -122.428676423893) | |||
| 160308 | 160308 | 233250 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 648 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002605.08046 | 2108877.80309 | 37.7707236983666 | -122.434352173914 | (37.7707236983666, -122.434352173914) | |||
| 171599 | 171599 | 233249 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 639 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002650.3098 | 2108837.6812299998 | 37.7706161007952 | -122.434192856313 | (37.7706161007952, -122.434192856313) | |||
| 41513 | 41513 | 233248 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 681 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002473.33732 | 2108808.74298 | 37.770526597547395 | -122.43480293573099 | (37.7705265975474, -122.434802935731) | |||
| 28231 | 28231 | 233247 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 691 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002444.44359 | 2108805.44805 | 37.7705159100121 | -122.43490264356701 | (37.7705159100121, -122.434902643567) | |||
| 60142 | 60142 | 233246 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 691 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002423.39369 | 2108803.45075 | 37.7705092307368 | -122.434975312366 | (37.7705092307368, -122.434975312366) | |||
| 157196 | 157196 | 233245 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 421 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000562.15444 | 2107317.42956 | 37.7663231312433 | -122.441306693372 | (37.7663231312433, -122.441306693372) | |||
| 169083 | 169083 | 233244 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 435 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000552.78126 | 2107310.61974 | 37.7663038992191 | -122.44133862468 | (37.7663038992191, -122.44133862468) | |||
| 52738 | 52738 | 233243 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 124 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001675.343669999 | 2108090.60737 | 37.768509437087395 | -122.43751176207701 | (37.7685094370874, -122.437511762077) | |||
| 152095 | 152095 | 233242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 124 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001672.4759599995 | 2108104.26162 | 37.7685467652396 | -122.437522659154 | (37.7685467652396, -122.437522659154) | |||
| 151540 | 151540 | 233241 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 683 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002429.11828 | 2104259.84707 | 37.7580339270302 | -122.43463056985901 | (37.7580339270302, -122.434630569859) | |||
| 67891 | 67891 | 233240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 695 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002435.0779 | 2104197.2400700003 | 37.757862361589 | -122.43460548237499 | (37.757862361589, -122.434605482375) | |||
| 158250 | 158250 | 233239 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 363 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002120.63411 | 2103748.41953 | 37.7566121528355 | -122.43566084938699 | (37.7566121528355, -122.435660849387) | |||
| 52343 | 52343 | 233238 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 363 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002122.54543 | 2103738.23701 | 37.756584302647 | -122.43565351090099 | (37.756584302647, -122.435653510901) | |||
| 184705 | 184705 | 233237 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4110 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6001733.83213 | 2103535.46825 | 37.7560054620974 | -122.43698330244601 | (37.7560054620974, -122.436983302446) | |||
| 75345 | 75345 | 233236 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4110 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001763.1484 | 2103536.0608200002 | 37.7560087554054 | -122.43688195965 | (37.7560087554054, -122.43688195965) | |||
| 170542 | 170542 | 233235 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 246 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999832.06243 | 2104784.26546 | 37.7593260747545 | -122.443649939917 | (37.7593260747545, -122.443649939917) | |||
| 186839 | 186839 | 232145 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 168 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000171.10762 | 2104896.8314799997 | 37.759654484693996 | -122.44248544197399 | (37.759654484694, -122.442485441974) | |||
| 187779 | 187779 | 232144 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 91 Clover Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000466.92396 | 2104962.588 | 37.759851893056705 | -122.44146708205 | (37.7598518930567, -122.44146708205) | |||
| 130039 | 130039 | 232143 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4500 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001046.64941 | 2104664.30606 | 37.7590658936826 | -122.43944071792801 | (37.7590658936826, -122.439440717928) | |||
| 176257 | 176257 | 232142 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001066.32619 | 2104666.54862 | 37.7590731710053 | -122.439372827193 | (37.7590731710053, -122.439372827193) | |||
| 163058 | 163058 | 232141 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4729 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000102.10141 | 2104608.6417 | 37.7588592528694 | -122.442703406152 | (37.7588592528694, -122.442703406152) | |||
| 166870 | 166870 | 232140 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001865.12223 | 2105249.31251 | 37.760718725320395 | -122.43665193014601 | (37.7607187253204, -122.436651930146) | |||
| 174811 | 174811 | 232139 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3942 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003383.19707 | 2104795.5514 | 37.75955895960371 | -122.431369200928 | (37.7595589596037, -122.431369200928) | |||
| 41639 | 41639 | 232138 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 580 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003623.80973 | 2104905.2272099997 | 37.7598737366978 | -122.430544868859 | (37.7598737366978, -122.430544868859) | |||
| 41324 | 41324 | 232137 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 369 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6003939.39037 | 2103322.72212 | 37.7555464256549 | -122.42934058040001 | (37.7555464256549, -122.4293405804) | |||
| 159362 | 159362 | 232136 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 220 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003683.73706 | 2101597.86103 | 37.7507958864336 | -122.43010166677 | (37.7507958864336, -122.43010166677) | |||
| 33969 | 33969 | 232135 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4185 25th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003143.3737699995 | 2101224.11027 | 37.749739035528606 | -122.43194360511299 | (37.7497390355286, -122.431943605113) | |||
| 172570 | 172570 | 232134 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4185 25th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003103.55435 | 2101223.0891 | 37.7497339741589 | -122.43208122926201 | (37.7497339741589, -122.432081229262) | |||
| 170954 | 170954 | 232133 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4185 25th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003074.48392 | 2101219.69545 | 37.7497230078067 | -122.432181513576 | (37.7497230078067, -122.432181513576) | |||
| 62681 | 62681 | 232132 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 437 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001838.47815 | 2103279.8051400003 | 37.7553094201035 | -122.436603103272 | (37.7553094201035, -122.436603103272) | |||
| 46178 | 46178 | 232131 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 433 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001839.10421 | 2103310.0547599997 | 37.7553925138627 | -122.43660310327299 | (37.7553925138627, -122.436603103273) | |||
| 165486 | 165486 | 232130 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 433 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001837.0462 | 2103325.0321299997 | 37.7554335211665 | -122.436611292486 | (37.7554335211665, -122.436611292486) | |||
| 67591 | 67591 | 232129 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 46 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004476.77417 | 2095599.7992099999 | 37.734371464458 | -122.426932133918 | (37.734371464458, -122.426932133918) | |||
| 172809 | 172809 | 232128 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3106 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008911.78439 | 2101594.32633 | 37.7510808941828 | -122.412022294387 | (37.7510808941828, -122.412022294387) | |||
| 68321 | 68321 | 232127 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3338 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007480.5711199995 | 2101511.30779 | 37.750772540020705 | -122.4169657085 | (37.7507725400207, -122.4169657085) | |||
| 48838 | 48838 | 232126 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3340 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007452.53589 | 2101509.5586599996 | 37.7507661602455 | -122.41706253313299 | (37.7507661602455, -122.417062533133) | |||
| 182781 | 182781 | 232125 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 221 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006181.07888 | 2101867.41037 | 37.751677132113706 | -122.421484762237 | (37.7516771321137, -122.421484762237) | |||
| 57321 | 57321 | 232124 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 334 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007777.01976 | 2105954.9327599998 | 37.7629903885117 | -122.416255249491 | (37.7629903885117, -122.416255249491) | |||
| 165724 | 165724 | 232123 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 115 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007153.85946 | 2100096.11498 | 37.74686835730729 | -122.417995196642 | (37.7468683573073, -122.417995196642) | |||
| 41115 | 41115 | 232122 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 310 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006779.43206 | 2096281.2177400002 | 37.736372421849 | -122.419019394955 | (37.736372421849, -122.419019394955) | |||
| 26047 | 26047 | 232121 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006748.24321 | 2096971.86371 | 37.738267026292206 | -122.419176203435 | (37.7382670262922, -122.419176203435) | |||
| 32583 | 32583 | 232120 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006744.342619999 | 2096963.28909 | 37.7382432626218 | -122.41918908171301 | (37.7382432626218, -122.419189081713) | |||
| 137600 | 137600 | 232119 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006250.41428 | 2096804.6563 | 37.737779863540396 | -122.420885585312 | (37.7377798635404, -122.420885585312) | |||
| 151422 | 151422 | 232118 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006307.91025 | 2096911.93963 | 37.7380776803421 | -122.420694407441 | (37.7380776803421, -122.420694407441) | |||
| 24302 | 24302 | 232117 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006376.96981 | 2097041.1204900001 | 37.7384362742185 | -122.420464800608 | (37.7384362742185, -122.420464800608) | |||
| 160589 | 160589 | 232116 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006433.5579699995 | 2097144.82447 | 37.738724211054 | -122.420276504174 | (37.738724211054, -122.420276504174) | |||
| 29052 | 29052 | 232115 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006996.58261 | 2097438.2156700003 | 37.7395615077658 | -122.41835062308901 | (37.7395615077658, -122.418350623089) | |||
| 174796 | 174796 | 232114 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 621 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008529.17733 | 2095946.1731200002 | 37.7355508380971 | -122.412946090592 | (37.7355508380971, -122.412946090592) | |||
| 66391 | 66391 | 232113 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008027.37409 | 2096368.3193700002 | 37.7366817787289 | -122.414710885994 | (37.7366817787289, -122.414710885994) | |||
| 177189 | 177189 | 232112 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 463 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008054.33617 | 2096704.1835 | 37.7376055029821 | -122.41464142687599 | (37.7376055029821, -122.414641426876) | |||
| 155055 | 155055 | 232111 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 245 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008091.47113 | 2097437.0729900002 | 37.7396199430135 | -122.414564880185 | (37.7396199430135, -122.414564880185) | |||
| 138038 | 138038 | 232110 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 986 Burnett Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5999352.49281 | 2100464.8672700003 | 37.7474387010349 | -122.444998003853 | (37.7474387010349, -122.444998003853) | |||
| 63439 | 63439 | 232109 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 263 Whitney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004388.1315 | 2096910.5821 | 37.7379655654675 | -122.42733194373301 | (37.7379655654675, -122.427331943733) | |||
| 134122 | 134122 | 232108 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 263 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004384.91702 | 2096898.5821099998 | 37.7379324344193 | -122.42734220319099 | (37.7379324344193, -122.427342203191) | |||
| 157281 | 157281 | 232107 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 252 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004356.65969 | 2096919.3563599999 | 37.737987877635796 | -122.42744138221201 | (37.7379878776358, -122.427441382212) | |||
| 56549 | 56549 | 232106 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 376 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003833.58419 | 2096631.88415 | 37.737168945997794 | -122.429229419698 | (37.7371689459978, -122.429229419698) | |||
| 76651 | 76651 | 232105 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 376 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003843.46691 | 2096640.55481 | 37.73719331312579 | -122.42919586870899 | (37.7371933131258, -122.429195868709) | |||
| 3881 | 3881 | 232104 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 308 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 12 | Width 3ft | Permit Number 38019 | 6004039.72435 | 2096794.4699099998 | 37.7376270372551 | -122.42852828485901 | (37.7376270372551, -122.428528284859) | |
| 63266 | 63266 | 232103 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 277 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004440.00092 | 2096743.42908 | 37.737509534524605 | -122.427140702876 | (37.7375095345246, -122.427140702876) | |||
| 42782 | 42782 | 232102 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3974 22nd St | 2 | : 4 | Tree 1 | Private 1 | 4 | 6002009.98359 | 2102946.50265 | 37.7544039961563 | -122.435986138674 | (37.7544039961563, -122.435986138674) | ||||
| 147424 | 147424 | 232101 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3974 22nd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6002008.600819999 | 2102955.96285 | 37.75442989304361 | -122.435991597528 | (37.7544298930436, -122.435991597528) | ||||
| 53334 | 53334 | 232100 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 855 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000870.3613 | 2102569.98573 | 37.753305364576896 | -122.43990024181002 | (37.7533053645769, -122.43990024181) | |||
| 62562 | 62562 | 232099 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003344.924819999 | 2099266.6530400002 | 37.7443757387478 | -122.431106937942 | (37.7443757387478, -122.431106937942) | |||
| 33567 | 33567 | 232098 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4430 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000426.80036 | 2101707.41736 | 37.750911701115996 | -122.441372274626 | (37.750911701116, -122.441372274626) | |||
| 178434 | 178434 | 232097 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000582.10335 | 2101964.75176 | 37.751627125314606 | -122.44085368146001 | (37.7516271253146, -122.44085368146) | |||
| 60554 | 60554 | 232096 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 478 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000648.788240001 | 2101235.5024599996 | 37.7496285799007 | -122.440570777222 | (37.7496285799007, -122.440570777222) | |||
| 131160 | 131160 | 232095 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 92 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000964.078369999 | 2101203.45021 | 37.749558520927295 | -122.439478198057 | (37.7495585209273, -122.439478198057) | |||
| 77004 | 77004 | 232094 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 590 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001372.37798 | 2100882.4537400003 | 37.748700369821 | -122.438043297379 | (37.748700369821, -122.438043297379) |
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");