trees
430 rows where PlantDate = "" and qSpecies_id = 63 sorted by qCaretaker_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133 | 211075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | 9 | 7 | 4 | 28861 | 40 | ||||
954 | 20324 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2047 | 20346 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
3008 | 251503 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 15 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
3556 | 20340 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
5800 | 98837 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5956 | 98839 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
7308 | 20330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
7702 | 262097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
7987 | 20066 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100 STAIRWAY54 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
8061 | 20397 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 262X Sunset Blvd | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
8123 | 16369 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
8532 | 19778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100 STAIRWAY18 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
9224 | 132190 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 44 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6011409.46246 | 2120250.86119 | 37.802447243101 | -122.40469828132 | (37.802447243101, -122.40469828132) | 3 | 1 | 10 | 308 | 23 | |||
9305 | 251160 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
9886 | 20336 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
10043 | 264733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1367 De Haro St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012260 | 2102130 | 37.7527390251575 | -122.400481372119 | (37.7527390251575, -122.400481372119) | 10 | 3 | 8 | 28856 | 29 | |||||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10520 | 20335 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
12407 | 115154 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 3 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
12450 | 261565 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1801 26th St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013146 | 2101521 | 37.7511162126671 | -122.39737469907 | (37.7511162126671, -122.39737469907) | 10 | 3 | 8 | 28856 | 1 | ||||
12567 | 211070 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 7 | Median : Yard | Tree | DPW 1 | 24 | 5995378.92982 | 2093188.43217 | 37.7272318087773 | -122.458211668947 | (37.7272318087773, -122.458211668947) | 9 | 7 | 4 | 28861 | 40 | ||||
12952 | 20300 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 50X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13465 | 20460 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 495X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
14475 | 20345 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 40 | |||||||||||||
15519 | 262098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
15787 | 12969 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
16263 | 20326 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
17195 | 194439 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 32 | Median : Yard | Tree | DPW 1 | 12 | 6012481.17054 | 2103301.60211 | 37.7559683209947 | -122.3997987802 | (37.7559683209947, -122.3997987802) | 10 | 3 | 8 | 28856 | 29 | ||||
17261 | 261487 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
20964 | 217820 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1x Junipero Serra Blvd | 7 | Median : Yard | Tree | DPW 1 | 3 | 5991627.31768 | 2095659.97546 | 37.7338017601455 | -122.471360849935 | (37.7338017601455, -122.471360849935) | 1 | 8 | 4 | 59 | 40 | ||||
22210 | 111263 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 1 | Front Yard : Yard | Tree | DPW 1 | 36 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
22573 | 105838 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 39X Bonview St | 1 | Front Yard : Yard | Tree | DPW 1 | 15 | 6007716.90579 | 2099172.41141 | 37.7443637468546 | -122.415982827151 | (37.7443637468546, -122.415982827151) | 2 | 7 | 7 | 28859 | 2 | ||||
22712 | 101030 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1010X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 40 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | ||||
22926 | 251501 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 13 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
26810 | 16373 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
28620 | 211073 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 26 | 5995385.83715 | 2093544.41078 | 37.7282096371561 | -122.458213544022 | (37.7282096371561, -122.458213544022) | 9 | 7 | 4 | 28861 | 40 | ||||
28896 | 101032 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1010X Portola Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
30931 | 211072 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 35 | 5995382.34021 | 2093429.07469 | 37.7278927511259 | -122.458217288807 | (37.7278927511259, -122.458217288807) | 9 | 7 | 4 | 28861 | 40 | ||||
31868 | 13401 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 344 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 70 | 5 | 5999579.163416 | 2097433.156503 | 37.7391272835542 | -122.443996396446 | (37.7391272835542, -122.443996396446) | 9 | 7 | 4 | 59 | 40 | |||
32960 | 121406 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10X Dorchester Way | 2 | Median : Cutout | Tree | DPW 1 | 8x30 | 5994075 | 2098171 | 37.7408376984389 | -122.463080674317 | (37.7408376984389, -122.463080674317) | 1 | 8 | 4 | 59 | 40 | ||||
33573 | 107492 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 21 | Median : Cutout | Tree | DPW 1 | 26 | 6011443.89272 | 2119983.46704 | 37.8017149683182 | -122.404560301033 | (37.8017149683182, -122.404560301033) | 3 | 1 | 10 | 308 | 23 | ||||
34697 | 194442 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 51 | Median : Yard | Tree | DPW 1 | 24 | 6012500.2858 | 2102979.92319 | 37.7550861265451 | -122.399710087265 | (37.7550861265451, -122.399710087265) | 10 | 3 | 8 | 28856 | 29 | ||||
35868 | 24283 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300X Winding Way | 21 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
37115 | 194449 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 23 | Median : Yard | Tree | DPW 1 | 23 | 6012259.688 | 2102130.23115 | 37.7527396424455 | -122.400482467314 | (37.7527396424455, -122.400482467314) | 10 | 3 | 8 | 28856 | 29 | ||||
38246 | 111524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
38282 | 21135 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
40232 | 194448 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 32 | Median : Yard | Tree | DPW 1 | 27 | 6012284.461 | 2102001.80848 | 37.7523884032163 | -122.400387777686 | (37.7523884032163, -122.400387777686) | 10 | 3 | 8 | 28856 | 29 | ||||
41594 | 20767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1692X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
41784 | 16362 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306X Montgomery St | 14 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011452.97865 | 2119928.00722 | 37.8015631969572 | -122.404524953159 | (37.8015631969572, -122.404524953159) | 3 | 1 | 10 | 308 | 23 | |||
42925 | 256615 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1541x Montgomery St | 1 | Front Yard : Yard | Tree | DPW 1 | DPW for City Agency | 6011315 | 2120446 | 37.8029777664724 | -122.405038917948 | (37.8029777664724, -122.405038917948) | 3 | 1 | 10 | 308 | 23 | ||||
43298 | 23673 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 319 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
47375 | 132184 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 25 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6011444.3716 | 2120015.20461 | 37.8018021387065 | -122.404560879294 | (37.8018021387065, -122.404560879294) | 3 | 1 | 10 | 308 | 23 | |||
49296 | 121082 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 24X KEMPTON AVE | 6 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
50718 | 211068 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | 9 | 7 | 4 | 28861 | 40 | ||||
50762 | 2044 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X Bosworth St | 1 | Front Yard : Cutout | Tree | DPW 1 | 36 | Permit Number 772999 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
51624 | 16371 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 4 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
55393 | 16363 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300X Montgomery St | 16 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011500.9168661 | 2119743.0722499 | 37.8010580895294 | -122.404346040012 | (37.8010580895294, -122.404346040012) | 3 | 1 | 10 | 308 | 23 | |||
55697 | 111280 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 18 | Front Yard : Cutout | Tree | DPW 1 | 48 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
58718 | 234516 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90x Peralta Ave | 2 | Median : Yard | Tree | DPW 1 | 15 | Width 10ft | 6010366.95066 | 2100295.32111 | 37.7475956480377 | -122.406898611185 | (37.7475956480377, -122.406898611185) | 2 | 7 | 7 | 28859 | 2 | |||
60529 | 211074 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 30 | 5995392.34643 | 2093881.33119 | 37.7291351132945 | -122.458215416413 | (37.7291351132945, -122.458215416413) | 9 | 7 | 4 | 28861 | 40 | ||||
60691 | 111521 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 16 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
61019 | 132188 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 42 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6011420.08981 | 2120201.09522 | 37.8023111918729 | -122.404657999787 | (37.8023111918729, -122.404657999787) | 3 | 1 | 10 | 308 | 23 | |||
62980 | 211065 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 400x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 25 | 5995367.47216 | 2092431.62053 | 37.7251531275117 | -122.458196526171 | (37.7251531275117, -122.458196526171) | 9 | 7 | 4 | 28861 | 40 | ||||
63289 | 111517 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 12 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
67798 | 211064 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 35 | 5995363.79151 | 2092232.49572 | 37.7246061670234 | -122.458194844436 | (37.7246061670234, -122.458194844436) | 9 | 7 | 4 | 28861 | 40 | ||||
68470 | 251502 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 14 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
68881 | 16368 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 1 | Median : Cutout | Tree | DPW 1 | 26 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
69354 | 111518 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 13 | Front Yard : Yard | Tree | DPW 1 | 27 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
70483 | 132187 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 40 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6011421.2833 | 2120182.68985 | 37.8022607219264 | -122.404652573264 | (37.8022607219264, -122.404652573264) | 3 | 1 | 10 | 308 | 23 | |||
70780 | 211076 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 74 | 5995394.80602 | 2094076.5012 | 37.7296711442905 | -122.458221033586 | (37.7296711442905, -122.458221033586) | 9 | 7 | 4 | 28861 | 40 | ||||
73714 | 132189 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 43 | Median : Yard | Tree | DPW 1 | 12 | Width 8ft | 6011411.36798 | 2120233.14388 | 37.8023987021982 | -122.404690439238 | (37.8023987021982, -122.404690439238) | 3 | 1 | 10 | 308 | 23 | |||
74160 | 98835 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Front Yard : Yard | Tree | DPW 1 | 5995262 | 2098056.7 | 37.7405921639667 | -122.458968225676 | (37.7405921639667, -122.458968225676) | 1 | 7 | 4 | 59 | 40 | |||||
74662 | 21131 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 0 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
77810 | 1321 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 4050X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | |||
82478 | 98836 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||||
85285 | 20978 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
86352 | 234521 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 5300x Diamond Heights Blvd | 4 | Median : Yard | Tree | DPW 1 | 30 | 6001544.41953 | 2098938.98574 | 37.7433738490244 | -122.437309239227 | (37.7433738490244, -122.437309239227) | 2 | 7 | 5 | 63 | 7 | ||||
87097 | 211066 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 36 | 5995372.70371 | 2092704.86629 | 37.7259036953978 | -122.458198208802 | (37.7259036953978, -122.458198208802) | 9 | 7 | 4 | 28861 | 40 | ||||
90813 | 111522 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 20 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
93601 | 115152 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 1 | Median : Yard | Tree | DPW 1 | 30 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | |||
95523 | 194440 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 33 | Median : Yard | Tree | DPW 1 | 6 | 6012485.2688 | 2103286.14111 | 37.7559260969364 | -122.399783521388 | (37.7559260969364, -122.399783521388) | 10 | 3 | 8 | 28856 | 29 | ||||
97194 | 24742 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 50X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 12x12 | 5982568.63637 | 2112600.93828 | 37.7797886774071 | -122.503933218017 | (37.7797886774071, -122.503933218017) | 11 | 6 | 2 | 55 | 26 | |||
97461 | 115155 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 4 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
99546 | 211067 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 39 | 5995372.66361 | 2092795.985 | 37.7261538831809 | -122.458204939322 | (37.7261538831809, -122.458204939322) | 9 | 7 | 4 | 28861 | 40 | ||||
99612 | 258091 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1500x Steiner St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 15x50 | 6002808 | 2113496 | 37.7834156319858 | -122.433980438269 | (37.7834156319858, -122.433980438269) | 13 | 9 | 11 | 29490 | 41 | ||||
105080 | 173727 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 958 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6012430 | 2103470 | 37.7564278519739 | -122.399987571177 | (37.7564278519739, -122.399987571177) | 10 | 3 | 8 | 28856 | 29 | |||
105224 | 211077 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100x Idora Ave | 9 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995433.61803 | 2099390.76131 | 37.7442650295015 | -122.458471384168 | (37.7442650295015, -122.458471384168) | 1 | 8 | 4 | 59 | 40 | |||
105484 | 115153 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 2 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
109147 | 194450 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 21 | Median : Yard | Tree | DPW 1 | 27 | 6012266.91736 | 2102141.9772 | 37.7527722977062 | -122.40045829173 | (37.7527722977062, -122.40045829173) | 10 | 3 | 8 | 28856 | 29 | ||||
110008 | 111523 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x BOSWORTH ST | 1 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
113826 | 16372 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
114548 | 132185 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 32 | Median : Yard | Tree | DPW 1 | 31 | Width 8ft | 6011428.32338 | 2120121.70557 | 37.8020936674502 | -122.404623915473 | (37.8020936674502, -122.404623915473) | 3 | 1 | 10 | 308 | 23 | |||
115262 | 251499 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 11 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
115540 | 23580 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3100X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005507.77084 | 2121129.71298 | 37.8045287248816 | -122.425183644115 | (37.8045287248816, -122.425183644115) | 5 | 1 | 1 | 28858 | 32 | |||
116365 | 2273 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 35 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
121594 | 12970 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 5X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
126197 | 115156 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 5 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
134014 | 2272 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 6 | Median : Cutout | Tree | DPW 1 | 20 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
134644 | 12968 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 |
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) );