trees
7,322 rows where qSpecies_id = 1 sorted by TreeID
This data as json, CSV (advanced)
| rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63372 | 107270 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 163715 | 107271 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 144221 | 107272 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 16174 | 107381 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 25244 | 107382 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 145533 | 107422 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2014 02:32:00 PM | 3 | 3x3 | 6004888 | 2111612 | 37.7783604539947 | -122.426650245545 | (37.7783604539947, -122.426650245545) | 7 | 9 | 11 | 28852 | 41 | ||
| 12230 | 107510 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2141 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001605.27547 | 2119726.96625 | 37.8004559210497 | -122.438587988867 | (37.8004559210497, -122.438587988867) | 13 | 9 | 1 | 57 | 17 | ||
| 125112 | 107511 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.438517544046 | (37.8004637136911, -122.438517544046) | 13 | 9 | 1 | 57 | 17 | ||
| 55589 | 107512 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1528X ALEMANY BLVD | 1 | Median : Cutout | Tree | DPW 1 | 6001955 | 2093277.9 | 37.727853146555 | -122.435484669091 | (37.727853146555, -122.435484669091) | 9 | 7 | 6 | 28861 | 25 | |||||
| 152298 | 107610 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 130 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773863 | 5993062.86174 | 2099209.06962 | 37.7436296195879 | -122.466655678001 | (37.7436296195879, -122.466655678001) | 1 | 8 | 4 | 29491 | 40 | ||
| 141648 | 107633 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 633 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009218.01318 | 2115223.86517 | 37.78852161892 | -122.411926362828 | (37.78852161892, -122.411926362828) | 5 | 1 | 10 | 28852 | 21 | ||||
| 91024 | 107690 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
| 128196 | 107691 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
| 93999 | 107692 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
| 138462 | 107693 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
| 154079 | 107694 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
| 60295 | 107695 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2440X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003685.72045 | 2116767.65354 | 37.7924485368973 | -122.43117747007 | (37.7924485368973, -122.43117747007) | 13 | 9 | 1 | 29490 | 27 | ||||
| 135373 | 10773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1120X Hudson Ave | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
| 81925 | 10776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
| 46477 | 10787 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017289.30037 | 2095275.75897 | 37.7341978590464 | -122.382612074644 | (37.7341978590464, -122.382612074644) | 10 | 3 | 8 | 58 | 1 | ||
| 159879 | 107922 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 42134 | 107923 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 123429 | 107925 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 173021 | 107926 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 93473 | 107927 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 25230 | 107929 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | ||
| 140386 | 10816 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1139X Hudson Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/2016 12:00:00 AM | 3 | 3X4 | 6017660.05601 | 2094705.99201 | 37.7326538662851 | -122.381290636609 | (37.7326538662851, -122.381290636609) | 10 | 3 | 8 | 58 | 1 | ||
| 124014 | 108228 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492 | 2106262 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | 8 | 4 | 7 | 28859 | 19 | |
| 156719 | 108322 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011232.7 | 2087548.1 | 37.7126428486885 | -122.403008427372 | (37.7126428486885, -122.403008427372) | 9 | 7 | 8 | 309 | 39 | |
| 23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
| 76474 | 108500 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 133 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773778 | 5993020.3424 | 2114605.60013 | 37.7859019761698 | -122.467922339348 | (37.7859019761698, -122.467922339348) | 11 | 6 | 2 | 54 | 11 | |
| 128087 | 108514 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1630 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773662 | 5991178.20693 | 2104273.2686 | 37.7574256471732 | -122.473541611476 | (37.7574256471732, -122.473541611476) | 1 | 8 | 4 | 56 | 12 |
| 52576 | 108528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2330 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001003.4593 | 2113864.9253 | 37.7843260328139 | -122.440249891789 | (37.7843260328139, -122.440249891789) | 15 | 6 | 11 | 29490 | 13 | |||
| 85875 | 108546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.87706 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) | 9 | 7 | 5 | 28861 | 25 |
| 154042 | 108549 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 48937 | 108550 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 33569 | 108551 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 86981 | 108552 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61-79X Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 104831 | 108619 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-198X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
| 99317 | 10868 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/2011 12:00:00 AM | 3 | 3x3 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 125500 | 10869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/2011 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 60837 | 10870 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/2011 12:00:00 AM | 3 | 3x4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 65303 | 108794 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 501-599 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |
| 49763 | 108796 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 501-599 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |
| 116819 | 108809 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301-399 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |
| 88937 | 108883 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1301x JESSIE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006447 | 2109024 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | 8 | 2 | 9 | 28853 | 19 | ||||
| 90429 | 108907 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770992 | 6006770.9 | 2099127.5 | 37.7441871979107 | -122.419250738388 | (37.7441871979107, -122.419250738388) | 2 | 7 | 7 | 28859 | 2 |
| 20086 | 108952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2912 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769302 | 5990002.93775 | 2095864.20098 | 37.7342684111434 | -122.476991674334 | (37.7342684111434, -122.476991674334) | 1 | 8 | 4 | 64 | 35 |
| 1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
| 14437 | 109053 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011732.03343 | 2111973.77322 | 37.7797383514815 | -122.402999500648 | (37.7797383514815, -122.402999500648) | 14 | 2 | 9 | 28856 | 34 | |||
| 1041 | 109054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011721.75389 | 2111961.27607 | 37.7797034631784 | -122.403034183007 | (37.7797034631784, -122.403034183007) | 14 | 2 | 9 | 28856 | 34 | |||
| 63010 | 10913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1351X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016987.51869 | 2096153.00243 | 37.7365899183909 | -122.383716496323 | (37.7365899183909, -122.383716496323) | 10 | 3 | 8 | 58 | 1 | |||
| 164134 | 10919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1351X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1993 12:00:00 AM | 4 | 3X4 | 6017015.77395 | 2096001.89725 | 37.7361765755813 | -122.383608288117 | (37.7361765755813, -122.383608288117) | 10 | 3 | 8 | 58 | 1 | ||
| 184799 | 109195 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993662.38748 | 2110089.48079 | 37.7735389861421 | -122.465372883509 | (37.7735389861421, -122.465372883509) | 11 | 6 | 2 | 54 | 11 | |||
| 39158 | 109206 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2322 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774968 | 5991447.56759 | 2112037.47435 | 37.7787596643252 | -122.473176292359 | (37.7787596643252, -122.473176292359) | 11 | 6 | 2 | 54 | 26 | |
| 96575 | 10923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345X Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | ||
| 107375 | 10935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1367 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016859.3335 | 2096507.77674 | 37.7375569710748 | -122.384184391096 | (37.7375569710748, -122.384184391096) | 10 | 3 | 8 | 58 | 1 | ||
| 153690 | 10936 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1373 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016845.99905 | 2096526.32287 | 37.7376071577553 | -122.384231786279 | (37.7376071577553, -122.384231786279) | 10 | 3 | 8 | 58 | 1 | ||
| 119196 | 10938 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1385 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6016811.47124 | 2096565.42425 | 37.7377126131446 | -122.384353889019 | (37.7377126131446, -122.384353889019) | 10 | 3 | 8 | 58 | 1 | ||
| 120442 | 10939 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1389 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/1992 12:00:00 AM | 6 | 3X4 | 6016794.60487 | 2096579.57931 | 37.7377505474584 | -122.384413190341 | (37.7377505474584, -122.384413190341) | 10 | 3 | 8 | 58 | 1 | ||
| 61809 | 10947 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2004 12:00:00 AM | 3 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | ||
| 88543 | 109569 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003067.9512 | 2091505.38171 | 37.7230493551309 | -122.431510687674 | (37.7230493551309, -122.431510687674) | 9 | 7 | 6 | 28861 | 5 |
| 93810 | 109570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003082.69526 | 2091494.46608 | 37.7230202188994 | -122.431458941588 | (37.7230202188994, -122.431458941588) | 9 | 7 | 6 | 28861 | 5 |
| 25195 | 109572 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003097.99881 | 2091486.06514 | 37.7229980191333 | -122.431405440927 | (37.7229980191333, -122.431405440927) | 9 | 7 | 6 | 28861 | 5 |
| 124627 | 10958 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1425X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2002 12:00:00 AM | 6 | 3X4 | 6016592.1339091 | 2096738.5714059 | 37.7381759097054 | -122.385124311518 | (37.7381759097054, -122.385124311518) | 10 | 3 | 8 | 58 | 1 | ||
| 118374 | 10961 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2016 12:00:00 AM | 3 | 3X4 | 6016582.94261 | 2096736.89065 | 37.7381707862468 | -122.385155973681 | (37.7381707862468, -122.385155973681) | 10 | 3 | 8 | 58 | 1 | ||
| 125719 | 10963 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | 10 | 3 | 8 | 58 | 1 | ||
| 183942 | 109712 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2016 08:12:00 AM | 3 | 3x3 | 6007405.7 | 2097308.5 | 37.7392283588276 | -122.416926880619 | (37.7392283588276, -122.416926880619) | 2 | 7 | 7 | 28859 | 2 | ||
| 63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
| 1358 | 109891 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013218 | 2106201 | 37.7639704813344 | -122.397453893083 | (37.7639704813344, -122.397453893083) | 14 | 3 | 8 | 28856 | 29 | ||||
| 194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
| 166789 | 110082 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3028 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773127 | 6003845.53754 | 2119275.91303 | 37.7993446288048 | -122.430803577743 | (37.7993446288048, -122.430803577743) | 13 | 9 | 1 | 57 | 17 | |
| 124536 | 110121 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008282.6 | 2116630.5 | 37.7923313700749 | -122.41526237244 | (37.7923313700749, -122.41526237244) | 5 | 1 | 10 | 28858 | 21 | ||||
| 134891 | 110222 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 183316 | 110223 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 81639 | 110224 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 31856 | 110225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 48286 | 110226 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 119807 | 110227 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
| 175443 | 110229 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
| 178589 | 110230 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
| 146850 | 110356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5988236.4947 | 2106489.4695 | 37.7633399351688 | -122.483877597947 | (37.7633399351688, -122.483877597947) | 1 | 8 | 3 | 56 | 35 | |||
| 164655 | 110358 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990014.2377 | 2106553.7919 | 37.7636198770855 | -122.477733734661 | (37.7636198770855, -122.477733734661) | 1 | 8 | 3 | 56 | 35 | |||
| 185598 | 110399 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 166 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005484 | 2099956 | 37.7463895097475 | -122.423759460429 | (37.7463895097475, -122.423759460429) | 2 | 7 | 5 | 28859 | 22 | ||||
| 134447 | 110437 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007787.18057 | 2109026.8304 | 37.771425672295 | -122.416437709336 | (37.771425672295, -122.416437709336) | 8 | 2 | 9 | 28853 | 19 | |
| 51184 | 1106 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2355 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 10 | 3x3 | 5999402.47852 | 2089142.52516 | 37.7163530571306 | -122.444011753357 | (37.7163530571306, -122.444011753357) | 9 | 7 | 6 | 28861 | 25 | ||
| 87557 | 110604 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1193 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 4x4 | Permit Number 777025 | 6007369 | 2118756 | 37.7981160762917 | -122.418574247636 | (37.7981160762917, -122.418574247636) | 5 | 1 | 10 | 28858 | 32 | ||
| 118981 | 110862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1606 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013190.35013 | 2104762.80291 | 37.7600199691689 | -122.397448657449 | (37.7600199691689, -122.397448657449) | 10 | 3 | 8 | 28856 | 29 | |||
| 19029 | 110863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1608 20TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013178 | 2104809 | 37.7601461286042 | -122.397494610871 | (37.7601461286042, -122.397494610871) | 10 | 3 | 8 | 28856 | 29 | ||||
| 155239 | 111140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011033.05255 | 2111885.99055 | 37.7794582639328 | -122.405411409512 | (37.7794582639328, -122.405411409512) | 14 | 2 | 9 | 28853 | 34 | |||
| 136786 | 111174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 598X Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009750.97069 | 2111825.91747 | 37.7792215501113 | -122.40984245099 | (37.7792215501113, -122.40984245099) | 14 | 2 | 9 | 28853 | 34 | ||||
| 114243 | 111175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 598X Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009750.97069 | 2111825.91747 | 37.7792215501113 | -122.40984245099 | (37.7792215501113, -122.40984245099) | 14 | 2 | 9 | 28853 | 34 | ||||
| 51764 | 111198 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801x CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | |||
| 180506 | 111199 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801x CAYUGA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
| 28933 | 1112 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2385 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 10 | 3x3 | 5999333.8364 | 2089049.0837 | 37.7160925721821 | -122.444242302293 | (37.7160925721821, -122.444242302293) | 9 | 7 | 6 | 28861 | 25 | ||
| 27830 | 111201 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | |||
| 50713 | 111202 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 51376 | 111203 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 42687 | 111231 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 398X VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991792 | 2097792 | 37.7396652854914 | -122.470946758559 | (37.7396652854914, -122.470946758559) | 1 | 8 | 4 | 59 | 40 | ||||
| 174253 | 111451 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399x EUGENIA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008618 | 2097694 | 37.7403549752059 | -122.412762522808 | (37.7403549752059, -122.412762522808) | 10 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );