Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102961 | 102961 | 39036 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009448.598999999 | 2105916.703 | 37.762979270155505 | -122.410471107096 | (37.7629792701555, -122.410471107096) | ||
| 110004 | 110004 | 39034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009405.63 | 2105912.797 | 37.7629661362051 | -122.410619446859 | (37.7629661362051, -122.410619446859) | ||
| 119962 | 119962 | 39033 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009388.268999999 | 2105911.495 | 37.7629615878496 | -122.410679400873 | (37.7629615878496, -122.410679400873) | ||
| 140786 | 140786 | 39032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009362.227000001 | 2105911.495 | 37.7629601277229 | -122.410769471544 | (37.7629601277229, -122.410769471544) | ||
| 69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
| 142018 | 142018 | 39020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009326.637 | 2105908.456 | 37.7629497877468 | -122.410892350936 | (37.7629497877468, -122.410892350936) | ||
| 124880 | 124880 | 39029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009306.238 | 2105908.456 | 37.762948643891 | -122.410962904321 | (37.762948643891, -122.410962904321) | ||
| 128920 | 128920 | 31250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990801.243009999 | 2098168.10201 | 37.7406406146101 | -122.474399775861 | (37.7406406146101, -122.474399775861) | ||
| 115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) | ||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
| 88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
| 144691 | 144691 | 39043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009263.703 | 2105753.075 | 37.7625196179381 | -122.411099042798 | (37.7625196179381, -122.411099042798) | ||
| 81527 | 81527 | 39026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009266.307 | 2105730.9390000002 | 37.762458983569495 | -122.411088472825 | (37.7624589835695, -122.411088472825) | ||
| 85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
| 95229 | 95229 | 31251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098048.9410099997 | 37.740313663161395 | -122.47437711373101 | (37.7403136631614, -122.474377113731) | ||
| 125544 | 125544 | 39030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009267.609 | 2105685.366 | 37.7623339235365 | -122.411080750478 | (37.7623339235365, -122.411080750478) | ||
| 102756 | 102756 | 31260 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990807.30201 | 2098024.7050099997 | 37.740247234298 | -122.47436836476001 | (37.740247234298, -122.47436836476) | ||
| 126513 | 126513 | 39025 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009268.043 | 2105665.835 | 37.7622803202093 | -122.4110778698 | (37.7622803202093, -122.4110778698) | ||
| 90496 | 90496 | 39024 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105649.776 | 37.76223634755271 | -122.411069230189 | (37.7622363475527, -122.411069230189) | ||
| 106855 | 106855 | 40577 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 140936 | 140936 | 31266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097974.21301 | 37.740108654737206 | -122.47436118898099 | (37.7401086547372, -122.474361188981) | ||
| 96307 | 96307 | 39023 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105633.7169999997 | 37.7621922532056 | -122.411068095823 | (37.7621922532056, -122.411068095823) | ||
| 125811 | 125811 | 40580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 144186 | 144186 | 31265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097955.0260099997 | 37.740055972157705 | -122.474359789198 | (37.7400559721577, -122.474359789198) | ||
| 94184 | 94184 | 39022 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009272.384 | 2105615.922 | 37.762143513944004 | -122.411059330144 | (37.762143513944, -122.411059330144) | ||
| 115267 | 115267 | 31264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990809.32201 | 2097939.87901 | 37.740014440896104 | -122.47435519202601 | (37.7400144408961, -122.474355192026) | ||
| 144875 | 144875 | 40597 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 78228 | 78228 | 40596 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 109096 | 109096 | 31262 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097920.69201 | 37.7399618168302 | -122.474350300123 | (37.7399618168302, -122.474350300123) | ||
| 139332 | 139332 | 39021 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009273.252 | 2105594.654 | 37.7620851655468 | -122.41105482574801 | (37.7620851655468, -122.411054825748) | ||
| 81050 | 81050 | 40589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 90977 | 90977 | 36211 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 112100 | 112100 | 31261 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097905.54401 | 37.7399202243074 | -122.474349195013 | (37.7399202243074, -122.474349195013) | ||
| 144228 | 144228 | 39028 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009274.554 | 2105576.425 | 37.7620351858869 | -122.41104903498001 | (37.7620351858869, -122.41104903498) | ||
| 79293 | 79293 | 36208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 93590 | 93590 | 31252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097887.3670099997 | 37.7398703149271 | -122.47434786892599 | (37.7398703149271, -122.474347868926) | ||
| 113099 | 113099 | 40587 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 128037 | 128037 | 39045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009275.856000001 | 2105555.5919999997 | 37.7619780562366 | -122.41104306028299 | (37.7619780562366, -122.411043060283) | ||
| 87278 | 87278 | 36215 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 95096 | 95096 | 41399 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 95327 | 95327 | 31259 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990811.34201 | 2097863.1310099997 | 37.7398038276004 | -122.474342608694 | (37.7398038276004, -122.474342608694) | ||
| 95950 | 95950 | 39051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009278.893999999 | 2105538.231 | 37.7619305572552 | -122.41103132667601 | (37.7619305572552, -122.411031326676) | ||
| 110371 | 110371 | 40595 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 80286 | 80286 | 42489 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092938.9930099999 | 37.7266456600516 | -122.45224358332099 | (37.7266456600516, -122.452243583321) | ||
| 95150 | 95150 | 40591 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 98419 | 98419 | 31258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990812.351009999 | 2097840.9150099996 | 37.739742886616796 | -122.474337499296 | (37.7397428866168, -122.474337499296) | ||
| 109862 | 109862 | 39052 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009313.616 | 2105488.318 | 37.7617954545913 | -122.410907711009 | (37.7617954545913, -122.410907711009) | ||
| 111470 | 111470 | 36207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 86742 | 86742 | 42490 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092919.46201 | 37.726592156863205 | -122.452234673085 | (37.7265921568632, -122.452234673085) | ||
| 92475 | 92475 | 31267 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990813.36101 | 2097821.7280099997 | 37.739690262547796 | -122.47433260742399 | (37.7396902625478, -122.474332607424) | ||
| 96883 | 96883 | 40592 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 99947 | 99947 | 39057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009402.158 | 2105494.394 | 37.7618171023683 | -122.410601907375 | (37.7618171023683, -122.410601907375) | ||
| 111491 | 111491 | 41396 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 124252 | 124252 | 36209 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 143276 | 143276 | 31317 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 177853 | 177853 | 74266 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 10 | 5990415.76389 | 2110639.6115 | 37.774861722089604 | -122.47664351536501 | (37.7748617220896, -122.476643515365) | ||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 31327 | 31327 | 74456 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 1 | 5990434.64458 | 2110641.0438200003 | 37.774866749948394 | -122.47657830845199 | (37.7748667499484, -122.476578308452) | ||
| 83339 | 83339 | 31245 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097800.52101 | 37.739632092076 | -122.47432756819299 | (37.739632092076, -122.474327568193) | ||
| 85323 | 85323 | 47655 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.40201396952699 | (37.7682956086843, -122.402013969527) | ||
| 92804 | 92804 | 40594 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 95366 | 95366 | 41392 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 97210 | 97210 | 36206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 100749 | 100749 | 42491 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997099.03001 | 2092901.0150099997 | 37.7265413193022 | -122.452244594961 | (37.7265413193022, -122.452244594961) | ||
| 102673 | 102673 | 37386 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
| 83388 | 83388 | 35531 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 90 Bartlett St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38922 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 97723 | 97723 | 40574 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 97777 | 97777 | 47656 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.40201396952699 | (37.7682956086843, -122.402013969527) | ||
| 107035 | 107035 | 41391 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 111807 | 111807 | 37385 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 112194 | 112194 | 36205 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 128704 | 128704 | 39055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009436.88 | 2105495.262 | 37.7618214323112 | -122.410481878589 | (37.7618214323112, -122.410481878589) | ||
| 135293 | 135293 | 74586 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600 Cabrillo St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 9 | 5990452.1273300005 | 2110641.5902299997 | 37.7748692642271 | -122.47651787251499 | (37.7748692642271, -122.476517872515) | ||
| 145130 | 145130 | 42487 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092882.5690099997 | 37.7264908574219 | -122.452232012211 | (37.7264908574219, -122.452232012211) | ||
| 60912 | 60912 | 42493 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.9530099998 | 37.726434250767205 | -122.45223052530301 | (37.7264342507672, -122.452230525303) | ||
| 95400 | 95400 | 41060 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 220 10th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | ||
| 96380 | 96380 | 39016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009463.356000001 | 2105496.13 | 37.761825299878204 | -122.410390369545 | (37.7618252998782, -122.410390369545) | ||
| 97696 | 97696 | 77104 | Permitted Site 1 | Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 450 | 790 Pennsylvania Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2013 12:00:00 AM | Permit Number 767208 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | ||
| 109275 | 109275 | 31256 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990815.38101 | 2097761.1370099997 | 37.739524012219796 | -122.474321202908 | (37.7395240122198, -122.474321202908) | ||
| 109826 | 109826 | 37384 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 110282 | 110282 | 40593 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 114040 | 114040 | 36200 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 120731 | 120731 | 44424 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 140539 | 140539 | 47657 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.40201396952699 | (37.7682956086843, -122.402013969527) | ||
| 143317 | 143317 | 35523 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 145483 | 145483 | 41390 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 172241 | 172241 | 74613 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 11 | 5990470.39839 | 2110643.18829 | 37.7748747117366 | -122.476454786513 | (37.7748747117366, -122.476454786513) | ||
| 49625 | 49625 | 39053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009484.188999999 | 2105497.432 | 37.7618300427155 | -122.410318408111 | (37.7618300427155, -122.410318408111) | ||
| 76396 | 76396 | 38314 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 77517 | 77517 | 35524 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 80802 | 80802 | 40582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 87191 | 87191 | 47658 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.40201396952699 | (37.7682956086843, -122.402013969527) | ||
| 92091 | 92091 | 42492 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997101.20001 | 2092826.1460099998 | 37.7263358710664 | -122.45223169353999 | (37.7263358710664, -122.45223169354) | ||
| 95605 | 95605 | 44435 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 103975 | 103975 | 108778 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 104323 | 104323 | 38084 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.784959103725704 | -122.441572302214 | (37.7849591037257, -122.441572302214) | ||
| 104347 | 104347 | 31255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097788.40301 | 37.739614026809996 | -122.473418880884 | (37.73961402681, -122.473418880884) |
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");