trees
130 rows where qCaretaker_id = 1 and qSpecies_id = 63 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 8532 | 19778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100 STAIRWAY18 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 9886 | 20336 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 16263 | 20326 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 140100 | 132186 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 34 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6011427.66353 | 2120140.51179 | 37.8021452678603 | -122.404627523539 | (37.8021452678603, -122.404627523539) | 3 | 1 | 10 | 308 | 23 | |||
| 140332 | 16374 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 7 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
| 142225 | 23579 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3100X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 42 | 3x3 | 6005511.92719 | 2121098.11811 | 37.8044422083102 | -122.425167011149 | (37.8044422083102, -122.425167011149) | 5 | 1 | 1 | 28858 | 32 | |||
| 144960 | 16370 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
| 146463 | 107487 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 12 | Median : Cutout | Tree | DPW 1 | 23 | 6011454.1798 | 2119912.99001 | 37.801522030487 | -122.40451973891 | (37.801522030487, -122.40451973891) | 3 | 1 | 10 | 308 | 23 | ||||
| 164190 | 16364 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300X Montgomery St | 17 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011500.9168661 | 2119743.0722499 | 37.8010580895294 | -122.404346040012 | (37.8010580895294, -122.404346040012) | 3 | 1 | 10 | 308 | 23 | |||
| 190898 | 132183 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 23 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6011446.11989 | 2119998.19994 | 37.8017555457373 | -122.404553631656 | (37.8017555457373, -122.404553631656) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 138520 | 22454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 6155X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40M | 6013523.9988031 | 2091160.9249677 | 37.722690633869 | -122.395341851189 | (37.722690633869, -122.395341851189) | 10 | 3 | 8 | 58 | 1 | |||
| 170052 | 194441 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 39 | Median : Yard | Tree | DPW 1 | 18 | 6012501.46554 | 2103105.94469 | 37.7554322198433 | -122.399714855461 | (37.7554322198433, -122.399714855461) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | ||||
| 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 | |||
| 137630 | 101035 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1010X Portola Dr | 9 | Front Yard : Yard | Tree | DPW 1 | 09/03/2014 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
| 145613 | 211069 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 29 | 5995377.19569 | 2093059.06381 | 37.7268764947539 | -122.458208304568 | (37.7268764947539, -122.458208304568) | 9 | 7 | 4 | 28861 | 40 | ||||
| 146926 | 18112 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1102X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 5995262.3028257 | 2098061.6496673 | 37.7406057719366 | -122.458967536918 | (37.7406057719366, -122.458967536918) | 1 | 7 | 4 | 59 | 40 | |||
| 148503 | 111281 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 19 | Front Yard : Yard | Tree | DPW 1 | 48 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 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) );