trees
2,421 rows where qSpecies_id = 8 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
18581 | 207557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 438 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993090.30731 | 2105981.36839 | 37.7622261896015 | -122.467053045158 | (37.7622261896015, -122.467053045158) | 1 | 8 | 11 | 56 | 12 | |||
18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
18784 | 255213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
18943 | 166174 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3356 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006632.30883 | 2102638.63296 | 37.7538201643798 | -122.419979070489 | (37.7538201643798, -122.419979070489) | 2 | 4 | 7 | 28859 | 19 | |||
19092 | 150813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013747.19893 | 2104113.81693 | 37.758268983752 | -122.395477303948 | (37.758268983752, -122.395477303948) | 10 | 3 | 8 | 28856 | 29 | |||
19307 | 191107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2021 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012536.97765 | 2101462.04256 | 37.7509204011789 | -122.399476636765 | (37.7509204011789, -122.399476636765) | 10 | 3 | 8 | 28856 | 1 | |||
19415 | 207567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993332.90632 | 2105478.86698 | 37.7608604521776 | -122.466177475135 | (37.7608604521776, -122.466177475135) | 1 | 8 | 4 | 56 | 12 | |||
19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
19777 | 117430 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.22692 | 2091583.55482 | 37.7233270936563 | -122.427664426683 | (37.7233270936563, -122.427664426683) | 9 | 7 | 6 | 28861 | 5 | ||
19885 | 191110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6011791.4986 | 2102301.92631 | 37.7531849588319 | -122.40211362974 | (37.7531849588319, -122.40211362974) | 10 | 3 | 8 | 28856 | 29 | |||
19933 | 223498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006745.96401 | 2102320.90162 | 37.7529541496195 | -122.41956348298 | (37.7529541496195, -122.41956348298) | 2 | 4 | 7 | 28859 | 19 | |||
20072 | 52428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) | 13 | 9 | 11 | 28858 | 27 |
20143 | 207679 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990677.2269 | 2100653.21825 | 37.7474569149997 | -122.475009933665 | (37.7474569149997, -122.475009933665) | 1 | 8 | 4 | 29491 | 40 | |||
20316 | 200101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015012.674 | 2092395.4762 | 37.7261631500088 | -122.39028199338 | (37.7261631500088, -122.39028199338) | 10 | 3 | 8 | 58 | 1 | |||
20325 | 223546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000939.02096 | 2096709.07098 | 37.7372165929608 | -122.439242751069 | (37.7372165929608, -122.439242751069) | 2 | 7 | 5 | 63 | 7 | |||
20459 | 223560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 675 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008145.89505 | 2095713.05268 | 37.7348892176551 | -122.414254758854 | (37.7348892176551, -122.414254758854) | 2 | 7 | 7 | 28859 | 2 | |||
20515 | 216642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.47656 | 37.7191402755735 | -122.45402201442 | (37.7191402755735, -122.45402201442) | 9 | 8 | 6 | 28861 | 24 | ||
20570 | 207594 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 234 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995665.54592 | 2091502.05532 | 37.7226178864794 | -122.457098912592 | (37.7226178864794, -122.457098912592) | 9 | 8 | 4 | 28861 | 24 | |||
20602 | 126531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005210.197 | 2117169.09516 | 37.7936370652524 | -122.425931322478 | (37.7936370652524, -122.425931322478) | 13 | 9 | 1 | 28858 | 27 | |||
20672 | 176230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001498.44538 | 2089067.7688 | 37.7162671349894 | -122.436761734667 | (37.7162671349894, -122.436761734667) | 9 | 7 | 6 | 28861 | 5 | |||
20721 | 120492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | 11 | 6 | 2 | 55 | 26 | |||
20827 | 248510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861 | -122.449287603561 | (37.767563696861, -122.449287603561) | 15 | 5 | 11 | 29492 | 9 | |||
20834 | 251731 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542 | 2087174 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | 9 | 7 | 6 | 28861 | 5 | ||
20990 | 4475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.91057 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | 2 | 7 | 5 | 63 | 22 | ||
20998 | 245940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997158.2972 | 2107852.8817 | 37.7675988557806 | -122.453118590527 | (37.7675988557806, -122.453118590527) | 15 | 5 | 11 | 29492 | 9 | |||
21036 | 26579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011098.44545 | 2099048.11598 | 37.7442119973787 | -122.40428136282 | (37.7442119973787, -122.40428136282) | 10 | 3 | 8 | 58 | 1 | ||
21102 | 223642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006690.61182 | 2102567.74424 | 37.753628804832 | -122.419772415291 | (37.753628804832, -122.419772415291) | 2 | 4 | 7 | 28859 | 19 | |||
21414 | 124354 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1100 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992180.38847 | 2111384.61555 | 37.7770094950384 | -122.470593638633 | (37.7770094950384, -122.470593638633) | 11 | 6 | 2 | 54 | 11 | |||
21637 | 41577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.7748938752615 | -122.50808495995 | (37.7748938752615, -122.50808495995) | 11 | 6 | 2 | 55 | 26 | ||
21897 | 223405 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005449.32896 | 2102471.93612 | 37.7532957337303 | -122.424058237901 | (37.7532957337303, -122.424058237901) | 2 | 4 | 5 | 28859 | 19 | |||
22090 | 224049 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002051.64145 | 2104349.66378 | 37.7582591055966 | -122.435942470278 | (37.7582591055966, -122.435942470278) | 2 | 4 | 5 | 28862 | 3 | |||
22344 | 189270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 59 Robblee Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | 10 | 3 | 8 | 58 | 1 | |||
22379 | 122307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.476307253497 | (37.7766000733292, -122.476307253497) | 11 | 6 | 2 | 55 | 26 | |||
22636 | 126510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000996.04097 | 2120002.97644 | 37.8011790965073 | -122.440715988969 | (37.8011790965073, -122.440715988969) | 13 | 9 | 1 | 57 | 17 | |||
22702 | 207672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.466805971728 | (37.76035943445, -122.466805971728) | 1 | 8 | 4 | 56 | 12 | |||
23051 | 223487 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.418818066419 | (37.7364875458659, -122.418818066419) | 2 | 7 | 7 | 28859 | 2 | |||
23082 | 96956 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988378.9117 | 2110569.83713 | 37.7745517889402 | -122.483684211452 | (37.7745517889402, -122.483684211452) | 11 | 6 | 2 | 55 | 26 | ||
23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
23398 | 122165 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991266.55577 | 2111104.42075 | 37.776187272392 | -122.473734392293 | (37.776187272392, -122.473734392293) | 11 | 6 | 2 | 54 | 26 | |||
23459 | 223514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3349 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006548.63349 | 2106093.81796 | 37.763302585471 | -122.420513683285 | (37.763302585471, -122.420513683285) | 8 | 4 | 7 | 28859 | 19 | |||
23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
23844 | 58977 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 9x9 | Permit Number 779525 | 5995325.65714 | 2112056.92494 | 37.779036849804 | -122.45976196403 | (37.779036849804, -122.45976196403) | 11 | 6 | 2 | 54 | 11 | |
23880 | 96952 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | 11 | 6 | 2 | 55 | 26 | |
23958 | 31714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.88312 | 2105983.06318 | 37.7625196419841 | -122.449671682498 | (37.7625196419841, -122.449671682498) | 15 | 5 | 11 | 29492 | 9 | |
23976 | 207635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994307.66331 | 2105637.8573 | 37.7613531889164 | -122.462817781532 | (37.7613531889164, -122.462817781532) | 1 | 5 | 11 | 56 | 12 | |||
24039 | 189257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | 10 | 3 | 8 | 58 | 1 | |||
24051 | 223567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007671.39008 | 2095684.74944 | 37.7347848378312 | -122.415893289437 | (37.7347848378312, -122.415893289437) | 2 | 7 | 7 | 28859 | 2 | |||
24237 | 223512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007094.15413 | 2105540.45939 | 37.7618139197035 | -122.418587660093 | (37.7618139197035, -122.418587660093) | 2 | 4 | 7 | 28859 | 19 | |||
24312 | 126513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.8041193022167 | -122.438461940777 | (37.8041193022167, -122.438461940777) | 13 | 9 | 1 | 57 | 17 | |||
24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
24529 | 27530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6013528.91672 | 2096649.27619 | 37.7377607988237 | -122.395709213912 | (37.7377607988237, -122.395709213912) | 10 | 3 | 8 | 58 | 1 | |||
24617 | 207548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | 1 | 5 | 11 | 56 | 12 | |||
24820 | 207648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992116.65286 | 2104730.33527 | 37.7587349341825 | -122.470329406704 | (37.7587349341825, -122.470329406704) | 1 | 8 | 4 | 56 | 12 | |||
24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
24919 | 207665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5996615.28225 | 2106600.56008 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | 15 | 5 | 11 | 29492 | 12 | |||
25043 | 253081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
25072 | 223529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002046.64832 | 2102339.03335 | 37.7527381135931 | -122.435815881724 | (37.7527381135931, -122.435815881724) | 2 | 4 | 5 | 28862 | 22 | |||
25131 | 185158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.493801554637 | (37.7388527871834, -122.493801554637) | 1 | 8 | 3 | 29491 | 35 | |||
25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
25347 | 98970 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
25666 | 84783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Charter Oak Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | 7 | Permit No. 49320 | 6010967.59518 | 2095106.34893 | 37.7333814341037 | -122.404456411357 | (37.7333814341037, -122.404456411357) | 10 | 3 | 8 | 58 | 1 | ||
25721 | 207622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | 15 | 5 | 11 | 56 | 12 | |||
25863 | 248419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 726 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999075.0539 | 2108056.9885 | 37.7682689481267 | -122.446503486875 | (37.7682689481267, -122.446503486875) | 15 | 5 | 11 | 29492 | 9 | |||
26008 | 54985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 610 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10863 | 5990982.11543 | 2111201.05221 | 37.7764361179599 | -122.474725393074 | (37.7764361179599, -122.474725393074) | 11 | 6 | 2 | 54 | 26 | ||
26247 | 207604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996244.76197 | 2090857.98578 | 37.7208826706709 | -122.45505018502 | (37.7208826706709, -122.45505018502) | 9 | 8 | 6 | 28861 | 24 | |||
26406 | 33945 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.76429 | 37.7998015374823 | -122.427531938546 | (37.7998015374823, -122.427531938546) | 13 | 9 | 1 | 57 | 17 | |
26446 | 223420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009036.51349 | 2099774.38399 | 37.7460907342145 | -122.411462403466 | (37.7460907342145, -122.411462403466) | 2 | 7 | 7 | 28859 | 2 | |||
26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
26608 | 90340 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990615.55567 | 2111280.455278 | 37.7766328895552 | -122.475999214233 | (37.7766328895552, -122.475999214233) | 11 | 6 | 2 | 55 | 26 | ||
26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
26966 | 207618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993529.31712 | 2090633.69129 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | 9 | 8 | 6 | 64 | 24 | |||
27050 | 44420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.7106843218039 | -122.433736745364 | (37.7106843218039, -122.433736745364) | 9 | 7 | 6 | 28861 | 5 | |
27076 | 69940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1295 30th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | 1 | 8 | 3 | 56 | 35 | |
27617 | 26468 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
27761 | 126498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.7991247544637 | -122.426523212175 | (37.7991247544637, -122.426523212175) | 13 | 9 | 1 | 57 | 17 | |||
27764 | 223429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008933.85702 | 2100227.23414 | 37.7473284018833 | -122.411849371861 | (37.7473284018833, -122.411849371861) | 2 | 7 | 7 | 28859 | 2 | |||
27943 | 31680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 55 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35186 | 5998329.53554 | 2107192.57672 | 37.7658528820189 | -122.44901987369 | (37.7658528820189, -122.44901987369) | 15 | 5 | 11 | 29492 | 9 | |
27975 | 126544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | 5 | 1 | 1 | 308 | 32 | |||
27976 | 67374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 6 | Permit Number 30868 | 5992412.40492 | 2111393.18626 | 37.7770464413981 | -122.469791653286 | (37.7770464413981, -122.469791653286) | 11 | 6 | 2 | 54 | 11 | |
28197 | 91005 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.4848519135 | (37.776201586759, -122.4848519135) | 11 | 6 | 2 | 55 | 26 | ||
28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
28306 | 223532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.7447864204556 | -122.434163917953 | (37.7447864204556, -122.434163917953) | 2 | 7 | 5 | 63 | 22 | |||
28331 | 94753 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010359.28963 | 2097585.56035 | 37.7401548048867 | -122.406734163873 | (37.7401548048867, -122.406734163873) | 10 | 3 | 8 | 58 | 1 | ||
28349 | 90183 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | 11 | 6 | 2 | 55 | 26 | ||
28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
28930 | 90335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
29054 | 223592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | 2 | 4 | 7 | 28859 | 19 | |||
29099 | 33334 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788582 | (37.8033246198945, -122.42991788582) | 13 | 9 | 1 | 28858 | 17 |
29160 | 223644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008388.34903 | 2104490.30808 | 37.759003221729 | -122.414037245221 | (37.759003221729, -122.414037245221) | 2 | 4 | 7 | 28859 | 19 | |||
29275 | 257895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3644 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | ||||
29432 | 223456 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | 15 | 5 | 11 | 29492 | 9 | |||
29467 | 191681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017111.18893 | 2093915.90803 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | 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) );