trees
2,421 rows where qSpecies_id = 8 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
| 186659 | 54213 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.7640002940645 | -122.465517235123 | (37.7640002940645, -122.465517235123) | 1 | 8 | 11 | 56 | 12 | |||
| 131226 | 54136 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | 13 | 9 | 1 | 57 | 27 | ||
| 194475 | 207568 | Prune Opt Out 3 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 788015 | 5993375.17513 | 2105731.36286 | 37.7615561785078 | -122.466049635587 | (37.7615561785078, -122.466049635587) | 1 | 8 | 11 | 56 | 12 | ||
| 5373 | 224056 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4609 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787677 | 6000381.16624 | 2105168.69891 | 37.7604129369301 | -122.441778467817 | (37.7604129369301, -122.441778467817) | 2 | 4 | 5 | 28862 | 3 | |
| 4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
| 893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
| 3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
| 499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
| 133251 | 214105 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782625 | 5994448.04607 | 2088422.67439 | 37.7140926462444 | -122.461084417418 | (37.7140926462444, -122.461084417418) | 9 | 8 | 6 | 28861 | 24 |
| 48194 | 172714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005831.81614 | 2119622.88276 | 37.8004096554382 | -122.42395503709 | (37.8004096554382, -122.42395503709) | 13 | 9 | 1 | 28858 | 32 | |
| 93522 | 256142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
| 134359 | 172715 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
| 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 | |
| 95379 | 68962 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) | 11 | 6 | 2 | 55 | 26 |
| 12961 | 70529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1930 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | Permit Number 782472 | 5999916.9745 | 2111278.4432 | 37.7771623000193 | -122.443822848555 | (37.7771623000193, -122.443822848555) | 15 | 5 | 11 | 29490 | 16 | ||
| 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 | ||
| 77925 | 96954 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988405.5552 | 2110570.49163 | 37.7745551368609 | -122.4835920955 | (37.7745551368609, -122.4835920955) | 11 | 6 | 2 | 55 | 26 | ||
| 100181 | 96955 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988393.30434 | 2110570.14181 | 37.7745534632722 | -122.48363444745 | (37.7745534632722, -122.48363444745) | 11 | 6 | 2 | 55 | 26 | ||
| 182626 | 96953 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | 11 | 6 | 2 | 55 | 26 | ||
| 177723 | 37514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782092 | 6007700.5704 | 2114390.54622 | 37.7861482783715 | -122.417117424144 | (37.7861482783715, -122.417117424144) | 13 | 1 | 9 | 28858 | 36 |
| 109402 | 255703 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782078 | 6009781.99069 | 2112750.42942 | 37.7817617797421 | -122.409800416291 | (37.7817617797421, -122.409800416291) | 14 | 2 | 9 | 28853 | 34 | |
| 192290 | 255522 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 513 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782014 | 6004052.85891 | 2110487.65333 | 37.7752260248335 | -122.429459106998 | (37.7752260248335, -122.429459106998) | 7 | 9 | 11 | 29492 | 10 |
| 145397 | 255506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 Edna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 781977 | 5998590.12208 | 2094762.17227 | 37.7317369269488 | -122.447223858431 | (37.7317369269488, -122.447223858431) | 9 | 7 | 4 | 59 | 40 | ||
| 100118 | 219821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 544 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781970 | 6003112.54338 | 2096066.43499 | 37.7355755064901 | -122.43168202563 | (37.7355755064901, -122.43168202563) | 2 | 7 | 5 | 63 | 7 | |
| 77685 | 68223 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1330 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 9 | Permit Number 781803 | 5991325.89713 | 2113444.25067 | 37.7826152391743 | -122.473699843984 | (37.7826152391743, -122.473699843984) | 11 | 6 | 2 | 54 | 26 | |
| 190107 | 161124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781528 | 6003266.33968 | 2090358.66738 | 37.7199119739285 | -122.430743107307 | (37.7199119739285, -122.430743107307) | 9 | 7 | 6 | 28861 | 5 | |
| 44074 | 254618 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781521 | 6003337.103 | 2094600.11874 | 37.73156206108 | -122.430801029135 | (37.73156206108, -122.430801029135) | 9 | 7 | 5 | 28861 | 25 |
| 51455 | 138318 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1900 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781472 | 6001997.4008 | 2115093.6522 | 37.7877563420727 | -122.436899200775 | (37.7877563420727, -122.436899200775) | 13 | 6 | 1 | 29490 | 27 | |
| 64406 | 30963 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1900 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2018 12:00:00 AM | 3 | Permit Number 781472 | 6001995.095 | 2115110.3689 | 37.7878021107927 | -122.436908375591 | (37.7878021107927, -122.436908375591) | 13 | 6 | 1 | 29490 | 27 | |
| 154557 | 214493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781360 | 5991433.81997 | 2106159.32578 | 37.7626190602323 | -122.47279512831 | (37.7626190602323, -122.47279512831) | 1 | 8 | 11 | 56 | 12 |
| 39296 | 254275 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 708 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781292 | 6003166.11525 | 2109644.67448 | 37.7728611677821 | -122.432466329003 | (37.7728611677821, -122.432466329003) | 15 | 5 | 11 | 29492 | 9 |
| 61267 | 254214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2566 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781239 | 5992084.25539 | 2097978.52044 | 37.7401943216292 | -122.46994985094 | (37.7401943216292, -122.46994985094) | 1 | 8 | 4 | 59 | 40 |
| 131925 | 169674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781222 | 6002394.02072 | 2096615.67364 | 37.7370428349616 | -122.43420548191 | (37.7370428349616, -122.43420548191) | 2 | 7 | 5 | 63 | 7 |
| 103332 | 49838 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 630 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781214 | 6010947.62469 | 2105199.05587 | 37.7610926949039 | -122.405235926615 | (37.7610926949039, -122.405235926615) | 10 | 3 | 8 | 28856 | 29 |
| 5105 | 153628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780837 | 6004230.96494 | 2119993.8857 | 37.8013378259475 | -122.429521095049 | (37.8013378259475, -122.429521095049) | 13 | 9 | 1 | 57 | 17 | |
| 139174 | 189244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780809 | 6013923.09543 | 2103892.83973 | 37.7576720101792 | -122.394853496397 | (37.7576720101792, -122.394853496397) | 10 | 3 | 8 | 28856 | 29 | |
| 8760 | 28315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.99062 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | 2 | 7 | 7 | 28859 | 2 | |
| 45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
| 114847 | 253246 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173 | 2087586 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | 9 | 7 | 6 | 28861 | 5 | |
| 145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
| 18144 | 70989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008399.52743 | 2108738.25581 | 37.770667730873 | -122.414299143103 | (37.770667730873, -122.414299143103) | 8 | 2 | 9 | 28853 | 19 | ||
| 61671 | 191072 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 4 | : | Tree | Private 2 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.7703385556015 | -122.413547385421 | (37.7703385556015, -122.413547385421) | 8 | 2 | 9 | 28853 | 19 | ||
| 16058 | 111561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.38867 | 37.7508975116216 | -122.402317008737 | (37.7508975116216, -122.402317008737) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 136185 | 28906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.7795285306637 | -122.402635398413 | (37.7795285306637, -122.402635398413) | 14 | 2 | 9 | 28856 | 34 | |
| 68070 | 30930 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.456902112142 | (37.7218954350219, -122.456902112142) | 9 | 8 | 4 | 28861 | 24 |
| 149177 | 121570 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119 | 2100471 | 37.7480641462346 | -122.40776839944 | (37.7480641462346, -122.40776839944) | 2 | 7 | 7 | 28859 | 2 | |
| 101627 | 116814 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3660x 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779082 | 6005401 | 2102665 | 37.7538231135776 | -122.42423909942 | (37.7538231135776, -122.42423909942) | 2 | 4 | 5 | 28859 | 19 | |
| 173914 | 254375 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1238 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778703 | 5993632.74679 | 2107063.55913 | 37.7652288969897 | -122.465255577799 | (37.7652288969897, -122.465255577799) | 11 | 8 | 11 | 56 | 12 |
| 122530 | 67357 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778684 | 6009891.75487156 | 2104281.4240401 | 37.7585139979267 | -122.408822999045 | (37.7585139979267, -122.408822999045) | 2 | 4 | 7 | 28859 | 19 | |
| 180570 | 254755 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | ||
| 142189 | 117442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | 9 | 7 | 6 | 28861 | 5 | ||
| 31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 183033 | 117303 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299 | -122.410120841459 | (37.754753524299, -122.410120841459) | 2 | 4 | 7 | 28859 | 19 | ||
| 102665 | 117316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | |||
| 177260 | 117317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | ||
| 83048 | 59516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778498 | 5999918.58356785 | 2110586.79862923 | 37.7752633120846 | -122.443767580498 | (37.7752633120846, -122.443767580498) | 15 | 5 | 11 | 29492 | 16 | ||
| 100097 | 117321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778498 | 5999899 | 2110608.7 | 37.7753223306588 | -122.443836898167 | (37.7753223306588, -122.443836898167) | 15 | 5 | 11 | 29492 | 16 | |||
| 54968 | 117333 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 109443 | 117334 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 126151 | 117332 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
| 98336 | 203684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1494 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 778446 | 5991831.94405 | 2105275.25669 | 37.7602146795817 | -122.471353755176 | (37.7602146795817, -122.471353755176) | 1 | 8 | 4 | 56 | 12 | |
| 77340 | 254477 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778443 | 5993977.44675 | 2106077.77361 | 37.7625420596989 | -122.463991787904 | (37.7625420596989, -122.463991787904) | 1 | 5 | 11 | 56 | 12 | |
| 82445 | 254665 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778441 | 5989948 | 2103325 | 37.7547506343258 | -122.477726795598 | (37.7547506343258, -122.477726795598) | 1 | 8 | 3 | 56 | 35 | |
| 98178 | 47029 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.431845439306 | (37.7702201068925, -122.431845439306) | 15 | 9 | 5 | 29492 | 9 | |
| 73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
| 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 | |
| 153675 | 251589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778123 | 6007098.02705 | 2095773.46513 | 37.7349961804395 | -122.417881894445 | (37.7349961804395, -122.417881894445) | 2 | 7 | 7 | 28859 | 2 | |
| 86846 | 254804 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1159 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778103 | 6004469.23164 | 2102144.01452 | 37.7523399531709 | -122.427424258339 | (37.7523399531709, -122.427424258339) | 2 | 4 | 5 | 28862 | 22 |
| 72996 | 47143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2179 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2016 12:00:00 AM | 3 | Permit Number 777489 | 5991297.44493317 | 2100594.37185861 | 37.7473312629118 | -122.472860991281 | (37.7473312629118, -122.472860991281) | 1 | 8 | 4 | 29491 | 40 | |
| 38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
| 156548 | 94699 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 475 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777440 | 5992793.37157 | 2112229.57702 | 37.7793649566555 | -122.468534651493 | (37.7793649566555, -122.468534651493) | 11 | 6 | 2 | 54 | 11 |
| 77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 119910 | 115159 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 178149 | 115161 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 120511 | 114551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322 | -122.401957083855 | (37.759370822322, -122.401957083855) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | ||
| 92474 | 32710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776816 | 6008703.66491 | 2115446.6282 | 37.7891044021039 | -122.413721697414 | (37.7891044021039, -122.413721697414) | 5 | 1 | 10 | 28858 | 21 |
| 99100 | 111742 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776572 | 5990114.7617 | 2111254.66631 | 37.7765330298264 | -122.477729702528 | (37.7765330298264, -122.477729702528) | 11 | 6 | 2 | 55 | 26 | |
| 29004 | 254341 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 38 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776525 | 6007503.72696 | 2099881.72077 | 37.7462993638251 | -122.416770197945 | (37.7462993638251, -122.416770197945) | 2 | 7 | 7 | 28859 | 2 |
| 38599 | 48554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | 11 | 6 | 2 | 55 | 26 | |||
| 183774 | 115293 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644 | 37.7474306230823 | -122.475067792345 | (37.7474306230823, -122.475067792345) | 1 | 8 | 4 | 29491 | 40 | |||
| 30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
| 169314 | 113391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
| 188571 | 114248 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 2 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
| 47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
| 34097 | 115876 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123489 | -122.426020771756 | (37.793613123489, -122.426020771756) | 13 | 9 | 1 | 28858 | 27 | ||
| 36476 | 115877 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927544 | (37.7936051429156, -122.42615927544) | 13 | 9 | 1 | 28858 | 27 | ||
| 122980 | 107236 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3326 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2015 12:00:00 AM | Permit Number 775776 | 6006851 | 2102663.4 | 37.7539004875763 | -122.419224541208 | (37.7539004875763, -122.419224541208) | 2 | 4 | 7 | 28859 | 19 | |||
| 69628 | 114796 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | 11 | 6 | 2 | 55 | 26 | |||
| 95257 | 110438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007788.2 | 2109003.3 | 37.7713611206973 | -122.416432516069 | (37.7713611206973, -122.416432516069) | 8 | 2 | 9 | 28853 | 19 | |
| 122742 | 110457 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775373 | 5991635.3 | 2099042.5 | 37.7430897750827 | -122.471579655796 | (37.7430897750827, -122.471579655796) | 1 | 8 | 4 | 29491 | 40 | |||
| 141241 | 92271 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
| 21456 | 34943 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3968 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775333 | 6003347.35755113 | 2102457.99102165 | 37.7531385434777 | -122.43132628846 | (37.7531385434777, -122.43132628846) | 2 | 4 | 5 | 28862 | 22 | ||
| 43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 |
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) );