trees
11,761 rows where qSpecies_id = 17 sorted by qCaretaker_id descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20461 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 30460 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 34585 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 48640 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 59683 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 67820 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 126993 | 104281 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 3 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 132116 | 104289 | Significant Tree 6 | Tree(s) :: 17 | 10X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 133125 | 104286 | Significant Tree 6 | Tree(s) :: 17 | 200X West Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 156652 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 174752 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 182512 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 3669 | 103667 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 6238 | 103666 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 15258 | 103665 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 16355 | 103663 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 18064 | 103664 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 18674 | 103662 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 30910 | 110537 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 100634 | 110538 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 108684 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 109449 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 91738 | 114025 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 96177 | 114027 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 97775 | 114024 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 101432 | 114028 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 130507 | 114026 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 135526 | 114019 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 147620 | 114029 | Undocumented 4 | Tree(s) :: 17 | 3151X CLAY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 54127 | 110312 | DPW Maintained 1 | Tree(s) :: 17 | 899x Stanyan St | 6 | Sidewalk: Property side : Pot | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
| 74511 | 110307 | DPW Maintained 1 | Tree(s) :: 17 | 899x Stanyan St | 2 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 4x11 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
| 140526 | 110309 | DPW Maintained 1 | Tree(s) :: 17 | 899x Stanyan St | 3 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3x3 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |||
| 129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
| 164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 4249 | 98418 | DPW Maintained 1 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
| 6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 20492 | 108957 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 30537 | 116151 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
| 31352 | 116135 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 32800 | 117172 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 39604 | 116148 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 39830 | 116130 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 41196 | 100784 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 50658 | 9541 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | 7 | 9 | 11 | 29490 | 41 | |
| 58107 | 108955 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 61521 | 9534 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.429229893302 | (37.779990692526, -122.429229893302) | 7 | 9 | 11 | 29490 | 41 | |
| 63264 | 117174 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 65918 | 117173 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 69576 | 116144 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 73464 | 116134 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 74846 | 116146 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 85049 | 116143 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 91190 | 108956 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 93467 | 116133 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 94765 | 108953 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 94864 | 116147 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 97138 | 116142 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 97996 | 116136 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 98593 | 116141 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 98804 | 9535 | Permitted Site 7 | Tree(s) :: 17 | 1100X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 12 | 3X3 | Permit Number 771276 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | |
| 107792 | 116145 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
| 129946 | 108954 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 131000 | 116131 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 136224 | 100785 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 140495 | 116149 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
| 140698 | 100787 | Permitted Site 7 | Tree(s) :: 17 | 2001 Washington St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | |||||
| 149701 | 109456 | DPW Maintained 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||
| 155883 | 116140 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
| 167918 | 100783 | Permitted Site 7 | Tree(s) :: 17 | 2101X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 168525 | 100786 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 173170 | 98431 | DPW Maintained 1 | Tree(s) :: 17 | 1401X Steiner St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | |||
| 184613 | 116137 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 193270 | 116150 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
| 167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 16134 | 106952 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | ||||
| 18970 | 97073 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 23622 | 99684 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
| 24349 | 97071 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 27100 | 92958 | Permitted Site 7 | Tree(s) :: 17 | 300 Seneca Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
| 37736 | 101041 | Significant Tree 6 | Tree(s) :: 17 | 3750 18th St | 1 | Front Yard : Yard | Tree | SFUSD 4 | 03/15/2012 12:00:00 AM | 30 | Permit Number 769376 | 6005230 | 2105481 | 37.7615455321967 | -122.425030802687 | (37.7615455321967, -122.425030802687) | 8 | 4 | 5 | 28859 | 19 | ||
| 37865 | 99674 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 47950 | 97078 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 49986 | 96493 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/24/2014 12:00:00 AM | 3 | 5x5 | Permit Number 774006 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 |
| 50714 | 97069 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 55011 | 99667 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 56802 | 99677 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 |
| 59231 | 97070 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 |
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) );