trees
655 rows where Zip Codes = 28859 and qSpecies_id = 50 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
| 543 | 100400 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x3 | 6008223 | 2099495 | 37.7452779444232 | -122.414255673266 | (37.7452779444232, -122.414255673266) | 2 | 7 | 7 | 28859 | 2 | |||
| 81761 | 10083 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | 2 | 4 | 5 | 28859 | 19 | ||
| 28580 | 10084 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | 2 | 4 | 5 | 28859 | 19 | ||
| 156800 | 10139 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.71608 | 37.7566603214356 | -122.42320418504 | (37.7566603214356, -122.42320418504) | 2 | 4 | 5 | 28859 | 19 | ||
| 26703 | 101946 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.7564675147494 | -122.41647145397 | (37.7564675147494, -122.41647145397) | 2 | 4 | 7 | 28859 | 19 | |||
| 74807 | 10220 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |||
| 121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
| 188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
| 42902 | 104963 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3z3 | Permit Number 770948 | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
| 50360 | 108394 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 737 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773728 | 6007947.99445 | 2103637.44207 | 37.7566367043842 | -122.41549982216 | (37.7566367043842, -122.41549982216) | 2 | 4 | 7 | 28859 | 19 |
| 99000 | 108469 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2560 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772730 | 6009727.83086 | 2102431.72737 | 37.7534259626799 | -122.409259396677 | (37.7534259626799, -122.409259396677) | 2 | 4 | 7 | 28859 | 19 |
| 51672 | 111057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 51327 | 111062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 172125 | 111063 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 73107 | 115506 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
| 112368 | 115507 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
| 79540 | 115508 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
| 106092 | 117199 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 383 LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006585 | 2103883 | 37.7572342437784 | -122.42023098587 | (37.7572342437784, -122.42023098587) | 2 | 4 | 7 | 28859 | 19 | |||
| 154193 | 117396 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
| 95305 | 117397 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
| 187560 | 117555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007674.4763735 | 2101992.27281083 | 37.7521040666078 | -122.416329227522 | (37.7521040666078, -122.416329227522) | 2 | 4 | 7 | 28859 | 19 | |||
| 77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 138812 | 121727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 152066 | 121728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 90226 | 121729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 31864 | 121730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 34391 | 121731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 104984 | 121733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 189598 | 121735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 142727 | 121739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 34062 | 121740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 138150 | 121741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 167786 | 121742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 110905 | 121743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 116126 | 121744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 157158 | 121746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 9 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 76026 | 121748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 174657 | 121750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 13 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 159876 | 121752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 15 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 157398 | 121753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 16 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 151786 | 121754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 17 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 74982 | 121755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 18 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 89672 | 121756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 19 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 193199 | 121757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 20 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
| 129591 | 152667 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008576.51497 | 2103684.24515 | 37.7568005230537 | -122.413329473377 | (37.7568005230537, -122.413329473377) | 2 | 4 | 7 | 28859 | 19 | |
| 13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 28859 | 19 | |
| 18756 | 166228 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3180 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007809.26595 | 2102700.74025 | 37.7540569360932 | -122.41591326789 | (37.7540569360932, -122.41591326789) | 2 | 4 | 7 | 28859 | 19 | |||
| 78698 | 173775 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1057 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779347 | 6009462.91602 | 2103024.17334 | 37.7550378411013 | -122.410217357343 | (37.7550378411013, -122.410217357343) | 2 | 4 | 7 | 28859 | 19 | |
| 50377 | 18386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | 10 | 4 | 7 | 28859 | 19 | ||
| 29685 | 190682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010644.58891 | 2105668.45784 | 37.7623646204591 | -122.406317076288 | (37.7623646204591, -122.406317076288) | 8 | 4 | 8 | 28859 | 19 | |||
| 55488 | 220057 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.415273710521 | (37.752790875909, -122.415273710521) | 2 | 4 | 7 | 28859 | 19 | |||
| 18066 | 220829 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 147 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2019 12:00:00 AM | 3 | 4x4 | Permit Number 784791 | 6008911.9321 | 2099119.05037 | 37.7442843442566 | -122.411846891528 | (37.7442843442566, -122.411846891528) | 2 | 7 | 7 | 28859 | 2 | |
| 15185 | 223092 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2719 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782363 | 6010376.57029 | 2102801.69474 | 37.7544781353795 | -122.407041982913 | (37.7544781353795, -122.407041982913) | 10 | 4 | 7 | 28859 | 19 | |
| 118897 | 224296 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 5 Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 6x15 | Permit Number 780759 | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | 2 | 7 | 7 | 28859 | 2 | |
| 8056 | 224581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008597.08192 | 2106800.15076 | 37.7653572404576 | -122.413478706001 | (37.7653572404576, -122.413478706001) | 8 | 4 | 7 | 28859 | 19 | |
| 19464 | 224582 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008579.87348 | 2106797.48808 | 37.7653489631036 | -122.413538037855 | (37.7653489631036, -122.413538037855) | 8 | 4 | 7 | 28859 | 19 | |
| 2489 | 224583 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008562.45401 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | 8 | 4 | 7 | 28859 | 19 | |
| 14632 | 224584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.413665425938 | (37.76534068665, -122.413665425938) | 8 | 4 | 7 | 28859 | 19 | |
| 125641 | 225915 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1115 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779648 | 6010030.36922 | 2102582.89023 | 37.7538579673932 | -122.408223810779 | (37.7538579673932, -122.408223810779) | 2 | 4 | 7 | 28859 | 19 | |
| 148309 | 226304 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008016.14912 | 2099877.20359 | 37.7463157688762 | -122.414997978399 | (37.7463157688762, -122.414997978399) | 2 | 7 | 7 | 28859 | 2 | |||
| 33380 | 226305 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006137.34667 | 2097561.46022 | 37.7398515040311 | -122.421330243406 | (37.7398515040311, -122.421330243406) | 2 | 7 | 7 | 28859 | 2 | |||
| 171578 | 226306 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | 2 | 7 | 7 | 28859 | 2 | |||
| 174953 | 226307 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007092.99842 | 2096727.14909 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | 2 | 7 | 7 | 28859 | 2 | |||
| 74771 | 226308 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007401.10475 | 2096768.52961 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | 2 | 7 | 7 | 28859 | 2 | |||
| 130952 | 226309 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007378.4424 | 2096771.82308 | 37.737753229234 | -122.416983110403 | (37.737753229234, -122.416983110403) | 2 | 7 | 7 | 28859 | 2 | |||
| 21276 | 226310 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | 2 | 7 | 7 | 28859 | 2 | |||
| 76930 | 226311 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.7644764615472 | -122.415336042545 | (37.7644764615472, -122.415336042545) | 8 | 4 | 7 | 28859 | 19 | |||
| 52561 | 226312 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.7625458374421 | -122.4151575397 | (37.7625458374421, -122.4151575397) | 8 | 4 | 7 | 28859 | 19 | |||
| 47184 | 226313 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2479 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008246.47754 | 2104016.96539 | 37.7576955616045 | -122.414494411095 | (37.7576955616045, -122.414494411095) | 2 | 4 | 7 | 28859 | 19 | |||
| 94378 | 226314 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1357 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007744.38877 | 2101777.28879 | 37.7515177002814 | -122.416072235664 | (37.7515177002814, -122.416072235664) | 2 | 4 | 7 | 28859 | 19 | |||
| 170166 | 226315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | 2 | 4 | 7 | 28859 | 19 | |||
| 108141 | 226316 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007669.0206 | 2101973.58327 | 37.7520524425716 | -122.416346770813 | (37.7520524425716, -122.416346770813) | 2 | 4 | 7 | 28859 | 19 | |||
| 177741 | 226317 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | 2 | 4 | 7 | 28859 | 19 | |||
| 20414 | 226318 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1453 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009324.95877 | 2100785.02024 | 37.7488818925933 | -122.410536346369 | (37.7488818925933, -122.410536346369) | 2 | 4 | 7 | 28859 | 19 | |||
| 167891 | 226319 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009300.51192 | 2101248.84299 | 37.7501540762619 | -122.410653634171 | (37.7501540762619, -122.410653634171) | 2 | 4 | 7 | 28859 | 19 | |||
| 38719 | 226320 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009255.59412 | 2102037.09938 | 37.7523159340399 | -122.410864628624 | (37.7523159340399, -122.410864628624) | 2 | 4 | 7 | 28859 | 19 | |||
| 117450 | 226321 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008080.72157 | 2101209.59973 | 37.7499778586098 | -122.414868977829 | (37.7499778586098, -122.414868977829) | 2 | 4 | 7 | 28859 | 19 | |||
| 83390 | 226322 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008078.2472 | 2101222.93823 | 37.7500143440966 | -122.414878478273 | (37.7500143440966, -122.414878478273) | 2 | 4 | 7 | 28859 | 19 | |||
| 181150 | 226323 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | 2 | 4 | 7 | 28859 | 19 | |||
| 178217 | 226324 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | 2 | 4 | 7 | 28859 | 19 | |||
| 28612 | 226325 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 825 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007984.60499 | 2102879.52609 | 37.7545576974837 | -122.415319557045 | (37.7545576974837, -122.415319557045) | 2 | 4 | 7 | 28859 | 19 | |||
| 83587 | 226326 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 739 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007955.30705 | 2103442.08166 | 37.7561007003072 | -122.415460702047 | (37.7561007003072, -122.415460702047) | 2 | 4 | 7 | 28859 | 19 | |||
| 77562 | 226327 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.416080374504 | (37.7625986546389, -122.416080374504) | 8 | 4 | 7 | 28859 | 19 | |||
| 186236 | 226328 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007822.68734 | 2105830.62056 | 37.7626516238081 | -122.416088496301 | (37.7626516238081, -122.416088496301) | 8 | 4 | 7 | 28859 | 19 | |||
| 28802 | 226329 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007821.99816 | 2105868.63243 | 37.7627559568505 | -122.416093572069 | (37.7627559568505, -122.416093572069) | 8 | 4 | 7 | 28859 | 19 | |||
| 33145 | 226330 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007820.88393 | 2105900.22293 | 37.7628426343977 | -122.416099663169 | (37.7628426343977, -122.416099663169) | 8 | 4 | 7 | 28859 | 19 | |||
| 175750 | 226331 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 155 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006477.52748 | 2105222.5882 | 37.7609063850338 | -122.420697763712 | (37.7609063850338, -122.420697763712) | 2 | 4 | 7 | 28859 | 19 | |||
| 100542 | 226332 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006554.33185 | 2103938.10379 | 37.757383817915 | -122.420340959477 | (37.757383817915, -122.420340959477) | 2 | 4 | 7 | 28859 | 19 | |||
| 40085 | 226333 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 383 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006558.03164 | 2103902.48298 | 37.7572862199038 | -122.42032563593 | (37.7572862199038, -122.42032563593) | 2 | 4 | 7 | 28859 | 19 |
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) );