trees
6,714 rows where qSpecies_id = 7 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1236 | 78452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989337.22841 | 2094863.71499 | 37.7314826909771 | -122.479220054956 | (37.7314826909771, -122.479220054956) | 1 | 8 | 4 | 64 | 35 | |||
1844 | 212645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992447.95571 | 2090426.49221 | 37.7194793442858 | -122.468143110712 | (37.7194793442858, -122.468143110712) | 9 | 8 | 6 | 64 | 24 | |||
1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
3173 | 78509 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.480673162464 | (37.7312164799499, -122.480673162464) | 1 | 8 | 4 | 64 | 35 | |||
3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
7676 | 78416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5990231.30854 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | 1 | 8 | 4 | 64 | 35 | |||
9472 | 78510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988931.24396 | 2094774.45392 | 37.7312140158088 | -122.480617072624 | (37.7312140158088, -122.480617072624) | 1 | 8 | 4 | 64 | 35 | |||
10148 | 78474 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2959 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5990228.52939 | 2095585.09331 | 37.7335151372166 | -122.476191360437 | (37.7335151372166, -122.476191360437) | 1 | 8 | 4 | 64 | 35 | |||
11911 | 78475 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989336.6982 | 2094888.29675 | 37.7315501554115 | -122.479223685537 | (37.7315501554115, -122.479223685537) | 1 | 8 | 4 | 64 | 35 | |||
12142 | 47373 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
13253 | 260510 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 177 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990921 | 2091320 | 37.7218443909369 | -122.473486322075 | (37.7218443909369, -122.473486322075) | 9 | 8 | 4 | 64 | 40 | ||||
13301 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 361x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
16531 | 78412 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3035 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989072.12667 | 2095062.74941 | 37.732013788304 | -122.480151113209 | (37.732013788304, -122.480151113209) | 1 | 8 | 4 | 64 | 35 | |||
16715 | 212653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.7168133912952 | -122.467970312297 | (37.7168133912952, -122.467970312297) | 9 | 8 | 6 | 64 | 24 | |||
17400 | 212661 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 542 Head St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5993519.05172 | 2089481.79849 | 37.7169472436938 | -122.464372202114 | (37.7169472436938, -122.464372202114) | 9 | 8 | 6 | 64 | 24 | |||
20160 | 212660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 229 Victoria St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993215.92884 | 2088803.07717 | 37.7150661605497 | -122.465370667224 | (37.7150661605497, -122.465370667224) | 9 | 8 | 6 | 64 | 24 | |||
20851 | 212631 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5992215.36031 | 2088948.17723 | 37.7154068147365 | -122.468839581692 | (37.7154068147365, -122.468839581692) | 9 | 8 | 6 | 64 | 24 | |||
20920 | 212632 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Ralston St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992190.56348 | 2089982.35509 | 37.7182449834113 | -122.469000508175 | (37.7182449834113, -122.469000508175) | 9 | 8 | 6 | 64 | 24 | |||
21864 | 47336 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 142 Garfield St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.7198387158131 | -122.463971702484 | (37.7198387158131, -122.463971702484) | 9 | 8 | 6 | 64 | 24 | |||
22497 | 45321 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 772 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44158 | 5993546.47195842 | 2091002.85847364 | 37.7211252885031 | -122.464387798146 | (37.7211252885031, -122.464387798146) | 9 | 8 | 6 | 64 | 24 | ||
23985 | 114387 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 417x ARBALLO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5988152 | 2090574 | 37.7196353223366 | -122.483003277928 | (37.7196353223366, -122.483003277928) | 1 | 8 | 4 | 64 | 14 | ||||
24476 | 212671 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 615 Garfield St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992392.42852 | 2090471.1623 | 37.7195987904413 | -122.468338294185 | (37.7195987904413, -122.468338294185) | 9 | 8 | 6 | 64 | 24 | |||
24572 | 45317 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 630 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44154 | 5993535.31460225 | 2090042.0802024 | 37.718486580043 | -122.464356645134 | (37.718486580043, -122.464356645134) | 9 | 8 | 6 | 64 | 24 | ||
24979 | 45314 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 608 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44151 | 5992448.25522328 | 2090519.99225245 | 37.7197360899317 | -122.468148873343 | (37.7197360899317, -122.468148873343) | 9 | 8 | 6 | 64 | 24 | ||
25547 | 212641 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 451 Vernon St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992462.51142 | 2090828.2308 | 37.7205832611878 | -122.468122005451 | (37.7205832611878, -122.468122005451) | 9 | 8 | 6 | 64 | 24 | |||
28273 | 45498 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2963 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 2 | Permit Number 44272 | 5989312.49527 | 2095540.70737 | 37.7333401021585 | -122.479355070181 | (37.7333401021585, -122.479355070181) | 1 | 8 | 4 | 64 | 35 | |
29667 | 45503 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3071 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 4 | Permit Number 44274 | 5989333.16365 | 2094919.73772 | 37.7316362789941 | -122.479238204195 | (37.7316362789941, -122.479238204195) | 1 | 8 | 4 | 64 | 35 | |
29862 | 48581 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45895 | 5992994.26817447 | 2088334.73866608 | 37.7137674293264 | -122.466102801731 | (37.7137674293264, -122.466102801731) | 9 | 8 | 6 | 64 | 24 | ||
30848 | 47332 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 131 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45263 | 5993704.23092481 | 2090493.94065656 | 37.7197370153769 | -122.463805555403 | (37.7197370153769, -122.463805555403) | 9 | 8 | 6 | 64 | 24 | ||
32769 | 212683 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5990865.46988 | 2095638.11605 | 37.7336976393282 | -122.473993164651 | (37.7336976393282, -122.473993164651) | 1 | 8 | 4 | 64 | 40 | |||
33115 | 212656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993265.19823 | 2090019.96829 | 37.7184102922832 | -122.465288712912 | (37.7184102922832, -122.465288712912) | 9 | 8 | 6 | 64 | 24 | |||
34115 | 45322 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 772 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44158 | 5993546.47195842 | 2091002.85847364 | 37.7211252885031 | -122.464387798146 | (37.7211252885031, -122.464387798146) | 9 | 8 | 6 | 64 | 24 | ||
35475 | 212652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 313 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992443.32484 | 2089879.75405 | 37.717977866774 | -122.468119367735 | (37.717977866774, -122.468119367735) | 9 | 8 | 6 | 64 | 24 | |||
35870 | 212672 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 609 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.7196008363947 | -122.468263292533 | (37.7196008363947, -122.468263292533) | 9 | 8 | 6 | 64 | 24 | |||
36440 | 47341 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 615 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45268 | 5992432.680184 | 2090468.17220354 | 37.7195929051759 | -122.468198942558 | (37.7195929051759, -122.468198942558) | 9 | 8 | 6 | 64 | 24 | ||
38922 | 212628 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5991678.72226 | 2091078.63283 | 37.7212255066273 | -122.47084952239 | (37.7212255066273, -122.47084952239) | 9 | 8 | 6 | 64 | 24 | |||
40191 | 47339 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | 9 | 8 | 6 | 64 | 24 | ||
40286 | 47338 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | 9 | 8 | 6 | 64 | 24 | ||
40427 | 47357 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | 9 | 8 | 6 | 64 | 24 | |||
41179 | 212620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5991404.09674 | 2089992.64963 | 37.7182277775561 | -122.471719713595 | (37.7182277775561, -122.471719713595) | 9 | 8 | 6 | 64 | 24 | |||
42577 | 212685 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 57 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990825.48012 | 2095506.36854 | 37.7333335775765 | -122.474121809996 | (37.7333335775765, -122.474121809996) | 1 | 8 | 4 | 64 | 40 | |||
42805 | 45310 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.469744896664 | (37.71762835398, -122.469744896664) | 9 | 8 | 6 | 64 | 24 | ||
43050 | 212619 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 123 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824676 | -122.471721416918 | (37.718293824676, -122.471721416918) | 9 | 8 | 6 | 64 | 24 | |||
43196 | 45545 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44298 | 5987075.11092 | 2094929.45879 | 37.7315315673308 | -122.48704535198 | (37.7315315673308, -122.48704535198) | 1 | 8 | 4 | 64 | 35 | |
46561 | 44740 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 5 | Permit Number 43858 | 5992059.17709 | 2086878.10482 | 37.7097138705641 | -122.469228836168 | (37.7097138705641, -122.469228836168) | 9 | 8 | 4 | 64 | 24 | |
46869 | 47344 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.468388624259 | (37.7195915118568, -122.468388624259) | 9 | 8 | 6 | 64 | 24 | ||
46967 | 212633 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 338 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992228.53387 | 2090118.36082 | 37.7186206158303 | -122.468879153643 | (37.7186206158303, -122.468879153643) | 9 | 8 | 6 | 64 | 24 | |||
53592 | 212669 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 131 Garfield St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993624.74466 | 2090472.09024 | 37.7196724386082 | -122.464078723674 | (37.7196724386082, -122.464078723674) | 9 | 8 | 6 | 64 | 24 | |||
54450 | 212650 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Vernon St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992450.00346 | 2089979.5572 | 37.7182522876938 | -122.46810353875 | (37.7182522876938, -122.46810353875) | 9 | 8 | 6 | 64 | 24 | |||
58252 | 212678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 29 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990819.11641 | 2095735.96999 | 37.7339636363128 | -122.47416055818 | (37.7339636363128, -122.47416055818) | 1 | 8 | 4 | 64 | 40 | |||
60772 | 212639 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 466 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992234.36824 | 2090921.5704 | 37.7208263704132 | -122.468917406335 | (37.7208263704132, -122.468917406335) | 9 | 8 | 6 | 64 | 24 | |||
65315 | 45328 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1385 Holloway Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | ||
65680 | 212621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Beverly St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.7181520321783 | -122.471700124589 | (37.7181520321783, -122.471700124589) | 9 | 8 | 6 | 64 | 24 | |||
66392 | 212676 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 124 Sargent St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | 9 | 8 | 6 | 64 | 24 | |||
67513 | 212637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5992197.26293 | 2090572.74875 | 37.7198664475464 | -122.469020294145 | (37.7198664475464, -122.469020294145) | 9 | 8 | 6 | 64 | 24 | |||
68186 | 178758 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3092 25th Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5988865.41335 | 2094809.64231 | 37.7313068078649 | -122.480847233437 | (37.7313068078649, -122.480847233437) | 1 | 8 | 4 | 64 | 35 | |||
69130 | 212679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5990820.47866 | 2095690.23896 | 37.7338381494169 | -122.474152512843 | (37.7338381494169, -122.474152512843) | 1 | 8 | 4 | 64 | 40 | |||
69817 | 212640 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 466 Ralston St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 5992234.12475 | 2090946.27568 | 37.7208941910027 | -122.468920044935 | (37.7208941910027, -122.468920044935) | 9 | 8 | 6 | 64 | 24 | |||
70366 | 68002 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 319 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31727 | 5992442.5315274 | 2089981.57315011 | 37.7182573914808 | -122.468129512391 | (37.7182573914808, -122.468129512391) | 9 | 8 | 6 | 64 | 24 | ||
71266 | 212625 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 239 Monticello St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991672.93632 | 2090117.56736 | 37.7185863219837 | -122.470799552451 | (37.7185863219837, -122.470799552451) | 9 | 8 | 6 | 64 | 24 | |||
75185 | 212677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 916 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991577.34612 | 2089232.98657 | 37.7161519507271 | -122.471065557542 | (37.7161519507271, -122.471065557542) | 9 | 8 | 6 | 64 | 24 | |||
75957 | 46750 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 229 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47629 | 5993206.8260224 | 2088718.30816088 | 37.7148328801951 | -122.465395976044 | (37.7148328801951, -122.465395976044) | 9 | 8 | 6 | 64 | 24 | ||
76446 | 178757 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 475 Country Club Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984730.24902 | 2094611.59389 | 37.7305217923373 | -122.495128441421 | (37.7305217923373, -122.495128441421) | 1 | 8 | 4 | 64 | 35 | |||
77978 | 45515 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2955 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 5 | Permit Number 44279 | 5988542.18849 | 2095555.93706 | 37.733337147873 | -122.482019318058 | (37.733337147873, -122.482019318058) | 1 | 8 | 4 | 64 | 35 | |
81304 | 212618 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 158 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991450.23786 | 2090240.56685 | 37.7189111669923 | -122.471578280835 | (37.7189111669923, -122.471578280835) | 9 | 8 | 6 | 64 | 24 | |||
82596 | 212680 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 30 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5990862.6136 | 2095693.98036 | 37.7338508631143 | -122.474007114039 | (37.7338508631143, -122.474007114039) | 1 | 8 | 4 | 64 | 40 | |||
84482 | 47340 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 399X Vernon St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | 9 | 8 | 6 | 64 | 24 | ||
85773 | 62994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 121 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1986 12:00:00 AM | 1 | Permit Number 23395 | 5991750.67961 | 2088373.72786 | 37.7138026589318 | -122.470403898426 | (37.7138026589318, -122.470403898426) | 9 | 8 | 6 | 64 | 24 | ||
87138 | 48580 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 170 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45894 | 5992735.0311487 | 2088323.3092015 | 37.7137210870883 | -122.466997982048 | (37.7137210870883, -122.466997982048) | 9 | 8 | 6 | 64 | 24 | ||
87642 | 212612 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 590 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993797.92241 | 2091040.72929 | 37.7212437637811 | -122.463521360718 | (37.7212437637811, -122.463521360718) | 9 | 8 | 6 | 64 | 24 | |||
88313 | 68003 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 327 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31728 | 5992443.22144719 | 2090030.89079527 | 37.718392845598 | -122.468130713203 | (37.718392845598, -122.468130713203) | 9 | 8 | 6 | 64 | 24 | ||
92075 | 68004 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 359 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1994 12:00:00 AM | Permit Number 31729 | 5992445.98112632 | 2090228.1613759 | 37.7189346620375 | -122.468135516498 | (37.7189346620375, -122.468135516498) | 9 | 8 | 6 | 64 | 24 | ||
94642 | 212623 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 222 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991708.59487 | 2090008.32571 | 37.7182884332397 | -122.470668344073 | (37.7182884332397, -122.470668344073) | 9 | 8 | 6 | 64 | 24 | |||
96222 | 45348 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 451 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44176 | 5992454.00470918 | 2090863.26035828 | 37.7206789525205 | -122.468153957077 | (37.7206789525205, -122.468153957077) | 9 | 8 | 6 | 64 | 24 | ||
96796 | 45346 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 374 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44174 | 5992499.3558781 | 2090326.06927027 | 37.7192065757155 | -122.4679581402 | (37.7192065757155, -122.4679581402) | 9 | 8 | 6 | 64 | 24 | ||
97321 | 212658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993218.69942 | 2089441.88827 | 37.7168203421713 | -122.465407468378 | (37.7168203421713, -122.465407468378) | 9 | 8 | 6 | 64 | 24 | ||||
99135 | 212654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 234 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.54875 | 2089420.35259 | 37.7167184381913 | -122.467967674587 | (37.7167184381913, -122.467967674587) | 9 | 8 | 6 | 64 | 24 | |||
101293 | 212629 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.7176319964934 | -122.469770335036 | (37.7176319964934, -122.469770335036) | 9 | 8 | 6 | 64 | 24 | |||
101970 | 45511 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3060 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988860.89889 | 2094966.83884 | 37.731738166776 | -122.480874345273 | (37.731738166776, -122.480874345273) | 1 | 8 | 4 | 64 | 35 | |
103749 | 212626 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 315 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5991670.94588 | 2090561.38472 | 37.719804820616 | -122.470838744014 | (37.719804820616, -122.470838744014) | 9 | 8 | 6 | 64 | 24 | |||
105098 | 212668 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992987.49956 | 2088299.56272 | 37.7136704541029 | -122.466123641711 | (37.7136704541029, -122.466123641711) | 9 | 8 | 6 | 64 | 24 | |||
106448 | 44743 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 306 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 5 | Permit Number 43861 | 5992021.82053 | 2086414.86847 | 37.7084397758389 | -122.469324250627 | (37.7084397758389, -122.469324250627) | 9 | 8 | 4 | 64 | 24 | |
108414 | 212673 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 632 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992300.25819 | 2090517.80546 | 37.7197215370933 | -122.468660282939 | (37.7197215370933, -122.468660282939) | 9 | 8 | 6 | 64 | 24 | |||
110938 | 212667 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | 9 | 8 | 6 | 64 | 24 | |||
111743 | 212664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 752 Head St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993542.32801 | 2090823.31232 | 37.7206320593021 | -122.464389093183 | (37.7206320593021, -122.464389093183) | 9 | 8 | 6 | 64 | 24 | |||
111788 | 45311 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.469744896664 | (37.71762835398, -122.469744896664) | 9 | 8 | 6 | 64 | 24 | ||
112493 | 212635 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 343 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992191.77345 | 2090130.53473 | 37.7186519185263 | -122.469007103793 | (37.7186519185263, -122.469007103793) | 9 | 8 | 6 | 64 | 24 | |||
115264 | 212663 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 718 Head St | 7 | : | Tree | Private 2 | 4 | Width 3ft | 5993531.69255 | 2090595.02777 | 37.7200046319988 | -122.464409290166 | (37.7200046319988, -122.464409290166) | 9 | 8 | 6 | 64 | 24 | |||
118315 | 45512 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3060 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988861.088 | 2094953.97294 | 37.7317028513108 | -122.480872749871 | (37.7317028513108, -122.480872749871) | 1 | 8 | 4 | 64 | 35 | |
118627 | 212659 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 335 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993217.88171 | 2089418.24393 | 37.7167553733424 | -122.465408578168 | (37.7167553733424, -122.465408578168) | 9 | 8 | 6 | 64 | 24 | ||||
118885 | 212666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 772 Head St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5993533.34433 | 2090952.03603 | 37.72098498564 | -122.464429488032 | (37.72098498564, -122.464429488032) | 9 | 8 | 6 | 64 | 24 | |||
121643 | 45504 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3071 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44274 | 5989334.51674 | 2094909.25358 | 37.7316075708123 | -122.47923275968 | (37.7316075708123, -122.47923275968) | 1 | 8 | 4 | 64 | 35 | |
123308 | 212636 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992198.09204 | 2090594.0117 | 37.7199248783202 | -122.469018974843 | (37.7199248783202, -122.469018974843) | 9 | 8 | 6 | 64 | 24 | |||
123679 | 212638 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 5992196.84729 | 2090552.99719 | 37.7198121905699 | -122.469020294172 | (37.7198121905699, -122.469020294172) | 9 | 8 | 6 | 64 | 24 | |||
123713 | 45356 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 426 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44181 | 5993274.56615099 | 2090020.51787313 | 37.7184123415446 | -122.465256372075 | (37.7184123415446, -122.465256372075) | 9 | 8 | 6 | 64 | 24 | ||
124258 | 212648 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 359 Vernon St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992453.38509 | 2090231.05356 | 37.7189430308699 | -122.468110134397 | (37.7189430308699, -122.468110134397) | 9 | 8 | 6 | 64 | 24 | |||
126109 | 45345 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 600 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607821 | 37.7179713877014 | -122.468064348637 | (37.7179713877014, -122.468064348637) | 9 | 8 | 6 | 64 | 24 | ||
126167 | 178760 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3077 25th Ave | 1 | : | Tree | Private 2 | 4 | Width 2ft | 5988826.82741 | 2094817.34949 | 37.7313257268874 | -122.480981194626 | (37.7313257268874, -122.480981194626) | 1 | 8 | 4 | 64 | 35 | |||
126868 | 178759 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3092 25th Ave | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5988865.63691 | 2094820.20281 | 37.7313358172827 | -122.480847233436 | (37.7313358172827, -122.480847233436) | 1 | 8 | 4 | 64 | 35 |
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) );