trees
6,714 rows where qSpecies_id = 7 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
| 4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
| 7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
| 7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
| 9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
| 9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
| 18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
| 389 | 121965 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991180.37033 | 2114963.80683 | 37.7867790889821 | -122.474314218886 | (37.7867790889821, -122.474314218886) | 11 | 6 | 1 | 54 | 33 | ||||
| 518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
| 560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
| 996 | 70145 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991181.63526 | 2114912.21638 | 37.7866375092707 | -122.474306076539 | (37.7866375092707, -122.474306076539) | 11 | 6 | 1 | 54 | 33 | |||
| 1789 | 39904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2807 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2001 12:00:00 AM | 6 | Permit Number 44042 | 6001235.05057 | 2115912.0484 | 37.7899600881353 | -122.439595474174 | (37.7899600881353, -122.439595474174) | 13 | 6 | 1 | 29490 | 27 | |
| 1801 | 73988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.448374611919 | (37.7880688417562, -122.448374611919) | 13 | 6 | 1 | 54 | 31 | |||
| 2922 | 72315 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.451149975496 | (37.7895248738152, -122.451149975496) | 11 | 6 | 1 | 54 | 31 | |||
| 4963 | 72437 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.4547616987 | (37.7872588007918, -122.4547616987) | 11 | 6 | 1 | 54 | 31 | |||
| 5057 | 72416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996845.41624 | 2115021.64069 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | 11 | 6 | 1 | 54 | 31 | |||
| 5648 | 59701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3169 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1981 12:00:00 AM | 9 | Permit Number 19131 | 5999559.99552 | 2116003.4997 | 37.7901157113065 | -122.44539757625 | (37.7901157113065, -122.44539757625) | 13 | 6 | 1 | 29490 | 27 | |
| 6584 | 59702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3161 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1981 12:00:00 AM | 10 | Permit Number 19132 | 5999572.17341 | 2116007.41636 | 37.7901271605955 | -122.445355723605 | (37.7901271605955, -122.445355723605) | 13 | 6 | 1 | 29490 | 27 | |
| 6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 7329 | 83337 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2815 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000055.78832 | 2117427.57453 | 37.7940541366405 | -122.443784531525 | (37.7940541366405, -122.443784531525) | 13 | 9 | 1 | 57 | 27 | |||
| 7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
| 9410 | 79837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006109.45612 | 2120466.37489 | 37.8027413403128 | -122.423054277046 | (37.8027413403128, -122.423054277046) | 5 | 9 | 1 | 28858 | 32 | |||
| 10540 | 61077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2609 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 11 | Permit Number 20914 | 5999561.8165 | 2113604.0485 | 37.7835275485561 | -122.445218691697 | (37.7835275485561, -122.445218691697) | 15 | 6 | 1 | 29490 | 31 | |
| 11827 | 135735 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1900 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999505.71531 | 2115426.21656 | 37.7885275445481 | -122.445543851863 | (37.7885275445481, -122.445543851863) | 13 | 6 | 1 | 29490 | 27 | |||
| 12545 | 260484 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 12621 | 72415 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3732 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996986.39697 | 2115040.92964 | 37.7873255008134 | -122.4542324171 | (37.7873255008134, -122.4542324171) | 11 | 6 | 1 | 54 | 31 | |||
| 12951 | 44312 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2574 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | 5 | Permit Number 43710 | 6001338.87734 | 2117308.19748 | 37.7937994594324 | -122.439336359686 | (37.7937994594324, -122.439336359686) | 13 | 9 | 1 | 57 | 27 | ||
| 13078 | 135703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998890.10615 | 2113926.10029 | 37.7843734546089 | -122.447565730187 | (37.7843734546089, -122.447565730187) | 15 | 6 | 1 | 54 | 31 | |||
| 13599 | 80235 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1820 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004189.43733 | 2119092.90581 | 37.7988616164221 | -122.429600505158 | (37.7988616164221, -122.429600505158) | 13 | 9 | 1 | 57 | 17 | |||
| 13768 | 106948 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2710 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999606.41459 | 2118186.75395 | 37.7961130004661 | -122.445394018543 | (37.7961130004661, -122.445394018543) | 13 | 9 | 1 | 57 | 17 | ||
| 14766 | 135726 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1910 Baker St | 4 | Sidewalk: Property side : Pot | Tree | Private 2 | 8 | Width 4ft | 5999972.00363 | 2115592.60206 | 37.7890110048021 | -122.443942530717 | (37.7890110048021, -122.443942530717) | 13 | 6 | 1 | 29490 | 27 | |||
| 14823 | 260479 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 15393 | 260480 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 16021 | 260481 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 16759 | 55973 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2221 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | Permit Number 783032 | 6003231.299 | 2116343.71442 | 37.7912587469411 | -122.432719482638 | (37.7912587469411, -122.432719482638) | 13 | 9 | 1 | 29490 | 27 | ||
| 16775 | 70037 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997501.9549 | 2113240.3611 | 37.7824111665106 | -122.452318727664 | (37.7824111665106, -122.452318727664) | 15 | 6 | 1 | 54 | 31 | |||
| 17369 | 260483 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 18172 | 50227 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2116@ JACKSON Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2006 12:00:00 AM | 4 | Permit Number 48724 | 5999868.84405 | 2116333.1432 | 37.7910384517219 | -122.444352688146 | (37.7910384517219, -122.444352688146) | 13 | 6 | 1 | 29490 | 27 | ||
| 18237 | 70985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3744 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996925.91149 | 2115035.19353 | 37.787306282296 | -122.454441268476 | (37.787306282296, -122.454441268476) | 11 | 6 | 1 | 54 | 31 | |||
| 18365 | 68230 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 26 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 5 | Permit Number 32024 | 5991181.57712 | 2114921.85315 | 37.7866639657866 | -122.474306981157 | (37.7866639657866, -122.474306981157) | 11 | 6 | 1 | 54 | 33 | |
| 18910 | 71939 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3380 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998663.45134 | 2115273.98643 | 37.788061440327 | -122.448446975846 | (37.788061440327, -122.448446975846) | 13 | 6 | 1 | 54 | 31 | |||
| 19266 | 135725 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1910 Baker St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 5999979.44045 | 2115594.83954 | 37.7890175725496 | -122.443916961204 | (37.7890175725496, -122.443916961204) | 13 | 6 | 1 | 29490 | 27 | |||
| 19740 | 114789 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 30 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5998464.24696 | 2116358.615 | 37.7910281517879 | -122.449214356564 | (37.7910281517879, -122.449214356564) | 13 | 6 | 1 | 54 | 31 | |||
| 21402 | 135678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2607 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005300.04249 | 2118927.30269 | 37.7984697341355 | -122.425745651145 | (37.7984697341355, -122.425745651145) | 13 | 9 | 1 | 57 | 17 | |||
| 21678 | 140783 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 68 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5996232.7039 | 2114068.31 | 37.7846116986517 | -122.45676965114 | (37.7846116986517, -122.45676965114) | 11 | 6 | 1 | 54 | 31 | |||
| 21854 | 135719 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2614 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001560.1117 | 2116659.97857 | 37.7920322061746 | -122.438524404093 | (37.7920322061746, -122.438524404093) | 13 | 6 | 1 | 29490 | 27 | |||
| 22024 | 45166 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 233 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | 7 | Permit Number 44016 | 5987719.77169 | 2114381.25489 | 37.7849784750486 | -122.486244140511 | (37.7849784750486, -122.486244140511) | 11 | 6 | 1 | 55 | 26 | ||
| 22181 | 124359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 47 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995852.3379 | 2114154.65702 | 37.7848269369125 | -122.458091832413 | (37.7848269369125, -122.458091832413) | 11 | 6 | 1 | 54 | 31 | |||
| 22462 | 36182 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 98 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 6 | Permit Number 39251 | 5996240.3184 | 2113866.2722 | 37.7840573939643 | -122.456728690929 | (37.7840573939643, -122.456728690929) | 11 | 6 | 1 | 54 | 31 | |
| 23837 | 52657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 4 | Permit Number 48738 | 5996482.1208 | 2114462.9099 | 37.7857094828252 | -122.455935294079 | (37.7857094828252, -122.455935294079) | 11 | 6 | 1 | 54 | 31 | ||
| 24596 | 140964 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 72 COOK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997535.2894 | 2113264.8967 | 37.7824804444348 | -122.452205176423 | (37.7824804444348, -122.452205176423) | 15 | 6 | 1 | 54 | 31 | |||
| 26443 | 135717 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2812 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001174.31151 | 2115953.49291 | 37.7900704268675 | -122.439808598198 | (37.7900704268675, -122.439808598198) | 13 | 6 | 1 | 29490 | 27 | |||
| 27379 | 63426 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3511 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1987 12:00:00 AM | 11 | Permit Number 24010 | 5997342.80811 | 2116025.28768 | 37.7900487172308 | -122.45307040039 | (37.7900487172308, -122.45307040039) | 11 | 6 | 1 | 54 | 31 | ||
| 27567 | 124301 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 187 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5996218.11326 | 2113072.44391 | 37.7818764777425 | -122.456748081227 | (37.7818764777425, -122.456748081227) | 11 | 6 | 1 | 54 | 31 | |||
| 27603 | 135742 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1902 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999494.72855 | 2115502.06438 | 37.7887351755486 | -122.44558732061 | (37.7887351755486, -122.44558732061) | 13 | 6 | 1 | 29490 | 27 | |||
| 27713 | 34950 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1928 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38548 | 6001980.6841 | 2115210.0928 | 37.7880751079735 | -122.436965376655 | (37.7880751079735, -122.436965376655) | 13 | 6 | 1 | 29490 | 27 | |
| 28063 | 141266 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 56 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996229.9965 | 2114143.7781 | 37.7848187584488 | -122.456784477797 | (37.7848187584488, -122.456784477797) | 11 | 6 | 1 | 54 | 31 | |||
| 28537 | 135720 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2618 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001545.10542 | 2116659.27148 | 37.7920294110678 | -122.438576275168 | (37.7920294110678, -122.438576275168) | 13 | 6 | 1 | 29490 | 27 | |||
| 29181 | 55217 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2341 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1972 12:00:00 AM | 3 | Permit Number 11131 | 6002352.66684 | 2117748.91519 | 37.7950671959414 | -122.435860108554 | (37.7950671959414, -122.435860108554) | 13 | 9 | 1 | 29490 | 27 | ||
| 29394 | 48776 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2423 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52958 | 6001866.8355 | 2117312.40288 | 37.793841036895 | -122.437509880678 | (37.793841036895, -122.437509880678) | 13 | 9 | 1 | 29490 | 27 | ||
| 29620 | 66201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2206 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1990 12:00:00 AM | 6 | Permit Number 29285 | 6002370.58115 | 2115902.05733 | 37.7899972184366 | -122.435665927851 | (37.7899972184366, -122.435665927851) | 13 | 9 | 1 | 29490 | 27 | ||
| 29931 | 124300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 187 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5996217.69868 | 2113070.62367 | 37.7818714560424 | -122.456749383788 | (37.7818714560424, -122.456749383788) | 11 | 6 | 1 | 54 | 31 | |||
| 30108 | 135842 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6007263.48219 | 2119827.6474 | 37.8010526095424 | -122.419015420851 | (37.8010526095424, -122.419015420851) | 5 | 1 | 1 | 28858 | 32 | ||||
| 31632 | 138632 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1706 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000073.9102 | 2114831.3574 | 37.7869266377662 | -122.443535243017 | (37.7869266377662, -122.443535243017) | 13 | 6 | 1 | 29490 | 27 | |||
| 31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
| 33749 | 12766 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1816 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5989782.53842 | 2114745.39141 | 37.7860983011374 | -122.479134351427 | (37.7860983011374, -122.479134351427) | 11 | 6 | 1 | 55 | 33 | |||
| 33906 | 2581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.424667932377 | (37.7880618747142, -122.424667932377) | 13 | 9 | 1 | 28858 | 41 | ||
| 33920 | 68139 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2529 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31891 | 6000069.23378689 | 2113679.57893593 | 37.7837638859304 | -122.443468656966 | (37.7837638859304, -122.443468656966) | 15 | 6 | 1 | 29490 | 31 | ||
| 34084 | 102045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999896.35932 | 2117404.6933 | 37.7939822160532 | -122.444334525426 | (37.7939822160532, -122.444334525426) | 13 | 9 | 1 | 57 | 27 | ||
| 34594 | 42626 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2630 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42684 | 6004057.62131117 | 2117766.00182931 | 37.7952108143764 | -122.42996192942 | (37.7952108143764, -122.42996192942) | 13 | 9 | 1 | 28858 | 27 | ||
| 35032 | 62099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2423 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1985 12:00:00 AM | 8 | Permit Number 22192 | 6003671.00405 | 2116729.08453 | 37.7923418022811 | -122.431225634948 | (37.7923418022811, -122.431225634948) | 13 | 9 | 1 | 29490 | 27 | ||
| 35102 | 38880 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | 11 | 6 | 1 | 54 | 31 | ||
| 36329 | 51940 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2630 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 6 | Permit Number 48165 | 5999253.26706 | 2119447.90516 | 37.7995556187462 | -122.446706761626 | (37.7995556187462, -122.446706761626) | 13 | 9 | 1 | 57 | 17 | ||
| 37148 | 135762 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2487 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001732.40168 | 2117306.51799 | 37.793817234538 | -122.437974611659 | (37.793817234538, -122.437974611659) | 13 | 9 | 1 | 29490 | 27 | |||
| 38670 | 135700 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 250 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5998566.03557 | 2115652.40971 | 37.7890949205473 | -122.448811284011 | (37.7890949205473, -122.448811284011) | 13 | 6 | 1 | 54 | 31 | |||
| 38736 | 103621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.80986 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | 11 | 6 | 1 | 54 | 31 | |
| 38862 | 135728 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3170 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999585.1938 | 2115401.01383 | 37.7884628815155 | -122.445267056746 | (37.7884628815155, -122.445267056746) | 13 | 6 | 1 | 29490 | 27 | |||
| 39504 | 55103 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3044 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 10 | Permit Number 11001 | 5999074.18378 | 2119269.48917 | 37.7990555048549 | -122.447313603458 | (37.7990555048549, -122.447313603458) | 13 | 9 | 1 | 57 | 17 | ||
| 39924 | 41234 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3743 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41939 | 6002518.8447 | 2121486.57255 | 37.8053392631726 | -122.435552627664 | (37.8053392631726, -122.435552627664) | 13 | 9 | 1 | 57 | 17 | |
| 39936 | 63906 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 39 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1987 12:00:00 AM | 4 | Permit Number 24620 | 5989560.31198 | 2114943.36597 | 37.7866289751206 | -122.479917679662 | (37.7866289751206, -122.479917679662) | 11 | 6 | 1 | 55 | 33 | ||
| 40050 | 135752 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999630.51606 | 2117664.2662 | 37.794679763523 | -122.445273038144 | (37.794679763523, -122.445273038144) | 13 | 9 | 1 | 57 | 27 | |||
| 40543 | 135760 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2515 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001189.70767 | 2117081.47486 | 37.7931684483229 | -122.439836236157 | (37.7931684483229, -122.439836236157) | 13 | 6 | 1 | 29490 | 27 | |||
| 41566 | 141245 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 26 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996219.8439 | 2114337.017 | 37.7853487578742 | -122.456833583241 | (37.7853487578742, -122.456833583241) | 11 | 6 | 1 | 54 | 31 | |||
| 42347 | 135851 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 787 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007518.53532 | 2120901.3436 | 37.8040150672041 | -122.418208991563 | (37.8040150672041, -122.418208991563) | 5 | 1 | 1 | 308 | 32 | |||
| 42447 | 68974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.8033586457513 | -122.445326751025 | (37.8033586457513, -122.445326751025) | 13 | 9 | 1 | 57 | 17 | |
| 42758 | 41637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2129 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 10 | Permit Number 42115 | 6002696.74237 | 2119185.54816 | 37.7990313562755 | -122.434772340797 | (37.7990313562755, -122.434772340797) | 13 | 9 | 1 | 57 | 17 | ||
| 44131 | 55104 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3050 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 11 | Permit Number 11002 | 5999072.14016 | 2119290.80376 | 37.7991139122229 | -122.447322209969 | (37.7991139122229, -122.447322209969) | 13 | 9 | 1 | 57 | 17 | ||
| 45184 | 135746 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3245 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999232.01364 | 2115636.13565 | 37.7890882979288 | -122.446505922306 | (37.7890882979288, -122.446505922306) | 13 | 6 | 1 | 29490 | 31 | |||
| 45316 | 139101 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2533 POST ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 6000038.1797 | 2113670.6976 | 37.7837377290557 | -122.443575453886 | (37.7837377290557, -122.443575453886) | 15 | 6 | 1 | 29490 | 31 | |||
| 46421 | 112639 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2470 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001807.148 | 2117372.77339 | 37.7940034049855 | -122.437720730351 | (37.7940034049855, -122.437720730351) | 13 | 9 | 1 | 57 | 27 | |||
| 46504 | 68297 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 4 | Permit Number 32106 | 5991182.12298 | 2114898.14321 | 37.7865988965237 | -122.474303361845 | (37.7865988965237, -122.474303361845) | 11 | 6 | 1 | 54 | 33 |
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) );