trees
221 rows where qSpecies_id = 153 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21432 | 68712 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32625 | 6003279.54613576 | 2105963.01747728 | 37.7627586660544 | -122.431811035931 | (37.7627586660544, -122.431811035931) | 15 | 4 | 5 | 28862 | 3 | ||
| 48900 | 222878 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003263.67356 | 2105959.60231 | 37.7627483890498 | -122.431865689655 | (37.7627483890498, -122.431865689655) | 15 | 4 | 5 | 28862 | 3 | |||
| 92683 | 222880 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003225.60952 | 2105960.03054 | 37.7627474070019 | -122.431997370179 | (37.7627474070019, -122.431997370179) | 15 | 4 | 5 | 28862 | 3 | |||
| 168666 | 222879 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | 15 | 4 | 5 | 28862 | 3 | |||
| 37804 | 188455 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011498.78949 | 2106422.93471 | 37.76448399066 | -122.403415778809 | (37.76448399066, -122.403415778809) | 8 | 3 | 8 | 28856 | 29 | |||
| 40010 | 188453 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011500.6075 | 2106371.58763 | 37.7643431046639 | -122.40340587818 | (37.7643431046639, -122.40340587818) | 8 | 3 | 8 | 28856 | 29 | |||
| 48148 | 188456 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011496.96392 | 2106445.77608 | 37.7645466059608 | -122.403423700042 | (37.7645466059608, -122.403423700042) | 8 | 3 | 8 | 28856 | 29 | |||
| 74126 | 188445 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011511.33671 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | 8 | 3 | 8 | 28856 | 29 | |||
| 82479 | 188443 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011515.17164 | 2106121.75692 | 37.7636579390857 | -122.403337928096 | (37.7636579390857, -122.403337928096) | 8 | 3 | 8 | 28856 | 29 | |||
| 86079 | 188451 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011503.70347 | 2106326.77104 | 37.7642202212997 | -122.403392016924 | (37.7642202212997, -122.403392016924) | 8 | 3 | 8 | 28856 | 29 | |||
| 88822 | 188444 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011513.49426 | 2106142.74637 | 37.7637154777208 | -122.403345206341 | (37.7637154777208, -122.403345206341) | 8 | 3 | 8 | 28856 | 29 | |||
| 105468 | 188446 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011512.27704 | 2106186.35742 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) | 8 | 3 | 8 | 28856 | 29 | |||
| 110268 | 188447 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386 | (37.7638765831644, -122.40336267386) | 8 | 3 | 8 | 28856 | 29 | |||
| 119756 | 188450 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | 8 | 3 | 8 | 28856 | 29 | |||
| 140364 | 188454 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011500.01929 | 2106398.96501 | 37.7644182439416 | -122.403409838819 | (37.7644182439416, -122.403409838819) | 8 | 3 | 8 | 28856 | 29 | |||
| 146826 | 188448 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.7639893248743 | -122.403368255061 | (37.7639893248743, -122.403368255061) | 8 | 3 | 8 | 28856 | 29 | |||
| 157286 | 188449 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011506.74728 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | 8 | 3 | 8 | 28856 | 29 | |||
| 161579 | 188452 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.403395977545 | (37.7642656181765, -122.403395977545) | 8 | 3 | 8 | 28856 | 29 | |||
| 179557 | 115853 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 401x KANSAS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011620 | 2106285 | 37.7641120222234 | -122.402986839965 | (37.7641120222234, -122.402986839965) | 8 | 3 | 8 | 28856 | 29 | |||||
| 22124 | 222872 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4250 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002245.78823 | 2100636.8852 | 37.7480757286172 | -122.435005495434 | (37.7480757286172, -122.435005495434) | 2 | 4 | 5 | 28862 | 22 | |||
| 192537 | 222873 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000914.51326 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | 2 | 4 | 5 | 28862 | 38 | |||
| 48281 | 52318 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 4354DOUGLASS 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48474 | 6000907.18250943 | 2103314.58552811 | 37.7553519514145 | -122.439826288335 | (37.7553519514145, -122.439826288335) | 2 | 4 | 5 | 28862 | 38 | ||
| 93744 | 42253 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 439 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | Permit Number 42498 | 6011074.38331 | 2112201.77293 | 37.7803276394387 | -122.405290671934 | (37.7803276394387, -122.405290671934) | 14 | 2 | 9 | 28853 | 34 | |
| 127193 | 205979 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.7437152253671 | -122.464891008423 | (37.7437152253671, -122.464891008423) | 1 | 8 | 4 | 29491 | 40 | |||
| 160240 | 188466 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 445 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011029.5684 | 2112160.37935 | 37.7802114767035 | -122.405442792276 | (37.7802114767035, -122.405442792276) | 14 | 2 | 9 | 28853 | 34 | |||
| 179881 | 42255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | 14 | 2 | 9 | 28853 | 34 | ||
| 35999 | 115859 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 36425 | 115854 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 68626 | 115858 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 73325 | 115865 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 83759 | 115862 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 99443 | 115866 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 132403 | 115855 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 146222 | 115860 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 147434 | 115861 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 162996 | 115863 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 173545 | 115867 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 176766 | 115856 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 179749 | 115864 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 37785 | 37556 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 4528 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1998 12:00:00 AM | Permit Number 39995 | 6000974.70295267 | 2104668.04462068 | 37.7590720640705 | -122.439689810342 | (37.7590720640705, -122.439689810342) | 2 | 4 | 5 | 28862 | 3 | ||
| 152486 | 222874 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 462 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001154.00187 | 2103552.82126 | 37.7560201354351 | -122.43898978707 | (37.7560201354351, -122.43898978707) | 2 | 4 | 5 | 28862 | 38 | |||
| 182616 | 52299 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | 2 | 4 | 5 | 28862 | 38 | ||
| 38578 | 40707 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 49 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 9 | Permit Number 41686 | 6002532.07349 | 2093390.42378 | 37.7281948693858 | -122.433497753227 | (37.7281948693858, -122.433497753227) | 9 | 7 | 6 | 28861 | 25 | |
| 177372 | 175828 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010182.47488 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | 10 | 7 | 8 | 309 | 39 | |||
| 8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
| 11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
| 13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
| 16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
| 16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
| 111421 | 51367 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.7324020570933 | -122.39336736943 | (37.7324020570933, -122.39336736943) | 10 | 3 | 8 | 58 | 1 |
| 26503 | 1546 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 501 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 5995568.83899 | 2112743.54668 | 37.7809361120605 | -122.458970433284 | (37.7809361120605, -122.458970433284) | 11 | 6 | 2 | 54 | 11 | |||
| 73613 | 1548 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 501 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995571.41042 | 2112712.2375 | 37.7808502932087 | -122.458959269915 | (37.7808502932087, -122.458959269915) | 11 | 6 | 2 | 54 | 11 | |||
| 182239 | 1547 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 501 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995572.64433 | 2112729.15384 | 37.7808968119003 | -122.458956226418 | (37.7808968119003, -122.458956226418) | 11 | 6 | 2 | 54 | 11 | |||
| 55650 | 222871 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | 2 | 7 | 7 | 28859 | 2 | |||
| 92772 | 244200 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 540 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003980.524 | 2109759.8502 | 37.7732235602878 | -122.429657410606 | (37.7732235602878, -122.429657410606) | 7 | 9 | 11 | 29492 | 10 | |||
| 57757 | 32659 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 55 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 14 | Permit Number 37092 | 6011762.82772 | 2110068.09254 | 37.7745075113438 | -122.402758910415 | (37.7745075113438, -122.402758910415) | 14 | 2 | 9 | 28853 | 34 | |
| 12726 | 78188 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 61 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | 9 | 3 | 7 | 309 | 28 | |||
| 95478 | 37963 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 655 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40194 | 6014150.19564 | 2104114.25281 | 37.7582925873621 | -122.39408358501 | (37.7582925873621, -122.39408358501) | 10 | 3 | 8 | 28856 | 29 | |
| 61416 | 123032 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 660 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5991952.29381 | 2110935.71162 | 37.7757637347805 | -122.47134996528 | (37.7757637347805, -122.47134996528) | 11 | 6 | 2 | 54 | 11 | |||
| 65058 | 42464 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 673 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42606 | 5996989.53231216 | 2095248.10603498 | 37.7329795980092 | -122.452792452541 | (37.7329795980092, -122.452792452541) | 9 | 7 | 4 | 59 | 40 | ||
| 7833 | 37175 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39748 | 6005894.17436162 | 2099270.44010947 | 37.7445302641925 | -122.422292422651 | (37.7445302641925, -122.422292422651) | 2 | 7 | 5 | 28859 | 2 | ||
| 69125 | 26664 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1997 12:00:00 AM | 12 | 3X3 | 6005893.2178962 | 2099270.732028 | 37.7445310117825 | -122.422295750657 | (37.7445310117825, -122.422295750657) | 2 | 7 | 5 | 28859 | 2 | ||
| 148343 | 41704 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
| 160314 | 222876 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6003060.85114 | 2095475.7145 | 37.7339505925395 | -122.431818580457 | (37.7339505925395, -122.431818580457) | 2 | 7 | 5 | 63 | 7 | |||
| 162799 | 222875 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.431827935223 | (37.7340120027534, -122.431827935223) | 2 | 7 | 5 | 63 | 7 | |||
| 182640 | 41705 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
| 44326 | 175834 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 5994720.17465 | 2086786.57384 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | 9 | 8 | 6 | 28861 | 25 | |||
| 71593 | 175832 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5994691.10568 | 2086786.70031 | 37.7096146303906 | -122.460125866041 | (37.7096146303906, -122.460125866041) | 9 | 8 | 6 | 28861 | 25 | |||
| 73379 | 175833 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 5994704.65642 | 2086785.934 | 37.709613305686 | -122.46007897717 | (37.709613305686, -122.46007897717) | 9 | 8 | 6 | 28861 | 25 | |||
| 104937 | 175831 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994675.09306 | 2086785.58839 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | 9 | 8 | 6 | 28861 | 25 | |||
| 107571 | 175829 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5994644.58104 | 2086786.22758 | 37.709610656267 | -122.460286627948 | (37.709610656267, -122.460286627948) | 9 | 8 | 6 | 28861 | 25 | |||
| 115792 | 175830 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | 9 | 8 | 6 | 28861 | 25 | |||
| 128123 | 175839 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009068.66668 | 2092869.3876 | 37.7271329121485 | -122.410863628551 | (37.7271329121485, -122.410863628551) | 9 | 3 | 7 | 309 | 28 | |||
| 8138 | 38246 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
| 43668 | 38245 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
| 77523 | 222862 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008204.35624 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | 8 | 4 | 7 | 28853 | 19 | |||
| 135942 | 222863 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008222.11657 | 2107958.04741 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | 8 | 4 | 7 | 28853 | 19 | |||
| 179419 | 38247 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | |
| 34969 | 32629 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37081 | 6011821.13713 | 2109777.45892 | 37.7737127534642 | -122.402536764383 | (37.7737127534642, -122.402536764383) | 14 | 2 | 9 | 28853 | 34 | |
| 36778 | 188465 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011787.2831 | 2109744.85419 | 37.7736213382813 | -122.402651578111 | (37.7736213382813, -122.402651578111) | 14 | 2 | 9 | 28853 | 34 | |||
| 151107 | 32628 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 7 | Permit Number 37081 | 6011809.7571 | 2109765.86877 | 37.7736802942351 | -122.402575314726 | (37.7736802942351, -122.402575314726) | 14 | 2 | 9 | 28853 | 34 | |
| 23578 | 188462 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | 14 | 2 | 9 | 28853 | 34 | |||
| 64231 | 188461 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011834.92433 | 2109696.16508 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | 14 | 2 | 9 | 28853 | 34 | |||
| 71955 | 188463 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011854.34986 | 2109717.34943 | 37.7735495606877 | -122.402417648277 | (37.7735495606877, -122.402417648277) | 14 | 2 | 9 | 28853 | 34 | |||
| 147607 | 188460 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011827.04267 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | 14 | 2 | 9 | 28853 | 34 | |||
| 175081 | 188464 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.402385258275 | (37.7735766257899, -122.402385258275) | 14 | 2 | 9 | 28853 | 34 | |||
| 3622 | 222861 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 77 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008184.4457 | 2107955.63736 | 37.7685067598049 | -122.414987714411 | (37.7685067598049, -122.414987714411) | 8 | 4 | 7 | 28853 | 19 | |||
| 48796 | 32635 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 64637 | 32631 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 67222 | 32634 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 70461 | 32632 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 114452 | 32633 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 116330 | 32630 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 121494 | 32636 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 182973 | 32637 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.7735333687871 | -122.402722477064 | (37.7735333687871, -122.402722477064) | 14 | 2 | 9 | 28853 | 34 | ||
| 141429 | 106234 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 785 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6011757.19214 | 2109625.51022 | 37.7732919669825 | -122.402747273178 | (37.7732919669825, -122.402747273178) | 14 | 2 | 9 | 28853 | 34 | ||||
| 189808 | 106235 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 785 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6011771.38268 | 2109636.80705 | 37.7733237777988 | -122.402698980481 | (37.7733237777988, -122.402698980481) | 14 | 2 | 9 | 28853 | 34 | ||||
| 28981 | 32639 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 787 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 11 | Permit Number 37084 | 6011743.68261 | 2109609.56566 | 37.7732474325671 | -122.402792883183 | (37.7732474325671, -122.402792883183) | 14 | 2 | 9 | 28853 | 34 | |
| 99399 | 32638 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 787 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 13 | Permit Number 37084 | 6011713.66731 | 2109582.88625 | 37.7731725010497 | -122.402894833955 | (37.7731725010497, -122.402894833955) | 14 | 2 | 9 | 28853 | 34 |
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) );