trees
438 rows where qSpecies_id = 63 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6278 | 132178 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2449 Mason St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6008741.74811 | 2122071.63658 | 37.807297172691 | -122.414058809171 | (37.807297172691, -122.414058809171) | 3 | 1 | 10 | 308 | 23 | ||||
187217 | 132182 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 601 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 5ft | 6007241.65576 | 2121894.78138 | 37.8067272057567 | -122.419237667598 | (37.8067272057567, -122.419237667598) | 5 | 1 | 1 | 28858 | 32 | |||
117514 | 132181 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6007227.55341 | 2121889.28804 | 37.8067113282286 | -122.419286081687 | (37.8067113282286, -122.419286081687) | 5 | 1 | 1 | 28858 | 32 | ||||
146172 | 132180 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6007242.78631 | 2121872.67886 | 37.8066665815484 | -122.419232186229 | (37.8066665815484, -122.419232186229) | 5 | 1 | 1 | 28858 | 32 | ||||
193997 | 132179 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6007259.69894 | 2121860.76679 | 37.8066348265036 | -122.419172811197 | (37.8066348265036, -122.419172811197) | 5 | 1 | 1 | 28858 | 32 | ||||
80305 | 111179 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 400 NORTH POINT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 9x6 | 6008572 | 2121805 | 37.806555520543 | -122.414627380808 | (37.806555520543, -122.414627380808) | 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 | |||
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 | |||
103192 | 132176 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2745 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6006527.83964 | 2120663.1294 | 37.8033051783476 | -122.421620437537 | (37.8033051783476, -122.421620437537) | 5 | 9 | 1 | 28858 | 32 | ||||
103781 | 108605 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1140x CHESTNUT ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6006369.1 | 2120452.7 | 37.8027184407042 | -122.422154803739 | (37.8027184407042, -122.422154803739) | 5 | 9 | 1 | 28858 | 32 | |||||
17203 | 107449 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1130x CHESTNUT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 60 | 6006351.9 | 2120450.9 | 37.8027125282147 | -122.422214196597 | (37.8027125282147, -122.422214196597) | 5 | 9 | 1 | 28858 | 32 | ||||
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 | ||||
85334 | 256616 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1541X Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011315 | 2120446 | 37.8029777664724 | -122.405038917948 | (37.8029777664724, -122.405038917948) | 3 | 1 | 10 | 308 | 23 | ||||
22744 | 132175 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 49 | 6006452.3729 | 2120433.08861 | 37.8026692893229 | -122.421865242911 | (37.8026692893229, -122.421865242911) | 5 | 9 | 1 | 28858 | 32 | ||||
185949 | 107450 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1140x Chestnut St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 60 | 6006380.05181 | 2120425.48408 | 37.8026443304364 | -122.422114970234 | (37.8026443304364, -122.422114970234) | 5 | 9 | 1 | 28858 | 32 | ||||
71037 | 132174 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1111 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 52 | 6006441.86345 | 2120416.15353 | 37.8026221972261 | -122.42190040729 | (37.8026221972261, -122.42190040729) | 5 | 9 | 1 | 28858 | 32 | ||||
17691 | 107448 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1111x Chestnut St | 8 | Unaccepted Street : Yard | Tree | Private 2 | 50 | 6006408.68895 | 2120404.86262 | 37.8025893243113 | -122.422014405358 | (37.8025893243113, -122.422014405358) | 5 | 9 | 1 | 28858 | 32 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
50112 | 109625 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 312x FILBERT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 6011362.9 | 2120079.8 | 37.801974948341 | -122.40484736081 | (37.801974948341, -122.40484736081) | 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 | |||
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 | |||
90211 | 96976 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 390X Filbert St | 1 | Median : Yard | Tree | Rec/Park 5 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | 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 | |||
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 | ||||
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 | |||
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 | |||
108098 | 132177 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1048 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007888.26555 | 2119276.18895 | 37.7995736051877 | -122.416814304957 | (37.7995736051877, -122.416814304957) | 5 | 1 | 1 | 308 | 32 | |||
97489 | 38524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3031 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 4 | Permit Number 40508 | 6001948.5977 | 2118592.4425 | 37.7973603403586 | -122.437318675826 | (37.7973603403586, -122.437318675826) | 13 | 9 | 1 | 57 | 17 | ||
163885 | 115556 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 3897 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996199 | 2115222 | 37.7877774871206 | -122.456969730492 | (37.7877774871206, -122.456969730492) | 11 | 6 | 1 | 54 | 31 | ||||
60584 | 115235 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 4x6 | Permit Number 777338 | 5989295.30249 | 2114868.10873 | 37.7864069399285 | -122.480829025898 | (37.7864069399285, -122.480829025898) | 11 | 6 | 1 | 55 | 33 | |
192071 | 132173 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 91 Mayfair Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 5997717.35609 | 2114490.42899 | 37.7858558611085 | -122.45166373929 | (37.7858558611085, -122.45166373929) | 15 | 6 | 1 | 54 | 31 | |||
95203 | 141265 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 52 JORDAN AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5996227.2891 | 2114192.1724 | 37.7849514808139 | -122.456797345759 | (37.7849514808139, -122.456797345759) | 11 | 6 | 1 | 54 | 31 | |||
19898 | 98265 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 755 O'Farrell St | Back Yard : Yard | Tree | Private 2 | Backyard tree; not significant | 6007700 | 2113968.3 | 37.7849888609023 | -122.417089467607 | (37.7849888609023, -122.417089467607) | 7 | 10 | 9 | 28858 | 36 | |||||
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 | ||||
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 | |||
157105 | 54486 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 535 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 8 | Permit Number 10278 | 5983764.83173 | 2112189.27219 | 37.7787286289905 | -122.499764682948 | (37.7787286289905, -122.499764682948) | 11 | 6 | 2 | 55 | 26 | ||
25732 | 116996 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 606x FULTON ST | Front Yard : Yard | Tree | Private 2 | 09/29/2016 12:00:00 AM | 3 | 6004628 | 2111737 | 37.7786889706302 | -122.427558590519 | (37.7786889706302, -122.427558590519) | 7 | 9 | 11 | 28852 | 41 | ||||
181774 | 118274 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 801 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 5984451.13428 | 2110349.39905 | 37.7737171157491 | -122.497254676861 | (37.7737171157491, -122.497254676861) | 11 | 6 | 2 | 55 | 26 | |||
77265 | 20512 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1211X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
111313 | 20511 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1211X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
2394 | 184349 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1251 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5984659.3559 | 2106454.1603 | 37.7630340956965 | -122.496246960605 | (37.7630340956965, -122.496246960605) | 1 | 8 | 3 | 56 | 35 | |||
162189 | 184737 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984694.2473 | 2106265.1087 | 37.7625170568543 | -122.496112336517 | (37.7625170568543, -122.496112336517) | 1 | 8 | 3 | 56 | 35 | |||
125583 | 184742 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984665.3886 | 2106227.5165 | 37.7624121488276 | -122.496209373012 | (37.7624121488276, -122.496209373012) | 1 | 8 | 3 | 56 | 35 | |||
34962 | 184744 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984688.1718 | 2106200.1767 | 37.7623384159342 | -122.496128558374 | (37.7623384159342, -122.496128558374) | 1 | 8 | 3 | 56 | 35 | |||
63026 | 186711 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984852.6024 | 2106104.2938 | 37.762084778312 | -122.495552790494 | (37.762084778312, -122.495552790494) | 1 | 8 | 3 | 56 | 35 | |||
96185 | 234523 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 5997132.36622 | 2105999.93621 | 37.7625096541183 | -122.45307450849 | (37.7625096541183, -122.45307450849) | 15 | 5 | 11 | 29492 | 12 | |||
92020 | 110148 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 90 WOODLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 4x9 | 5997155.9 | 2105983.7 | 37.7624664223167 | -122.452991942132 | (37.7624664223167, -122.452991942132) | 15 | 5 | 11 | 29492 | 12 | |||
193846 | 110147 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 90 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 46 | 4x15 | 5997155.9 | 2105983.7 | 37.7624664223167 | -122.452991942132 | (37.7624664223167, -122.452991942132) | 15 | 5 | 11 | 29492 | 12 | |||
110265 | 234522 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 5ft | 5997143.66994 | 2105974.54542 | 37.7624405852729 | -122.453033580335 | (37.7624405852729, -122.453033580335) | 15 | 5 | 11 | 29492 | 12 | |||
69152 | 184781 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984718.1696 | 2105899.6288 | 37.7615149526664 | -122.496002635394 | (37.7615149526664, -122.496002635394) | 1 | 8 | 3 | 56 | 35 | |||
52616 | 184782 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984677.5396 | 2105882.9212 | 37.7614666984861 | -122.496141923024 | (37.7614666984861, -122.496141923024) | 1 | 8 | 3 | 56 | 35 | |||
68325 | 184784 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984713.613 | 2105863.1758 | 37.7614145960538 | -122.496015705201 | (37.7614145960538, -122.496015705201) | 1 | 8 | 3 | 56 | 35 | |||
100087 | 194438 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1051 18th St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 6014405.25344 | 2105708.40792 | 37.7626839643245 | -122.39331303148 | (37.7626839643245, -122.39331303148) | 10 | 3 | 8 | 28856 | 29 | ||||
178211 | 186688 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1401 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984691.4289 | 2105282.7412 | 37.7598195855983 | -122.496049606755 | (37.7598195855983, -122.496049606755) | 1 | 8 | 3 | 56 | 35 | |||
120848 | 194447 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 680 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012074.20817 | 2105270.47212 | 37.761351707727 | -122.401344555627 | (37.761351707727, -122.401344555627) | 10 | 3 | 8 | 28856 | 29 | ||||
33872 | 186702 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1401 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 0ft | 5984718.4366 | 2105146.0279 | 37.7594457908807 | -122.495946116181 | (37.7594457908807, -122.495946116181) | 1 | 8 | 3 | 56 | 35 | |||
165845 | 234524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 671 Church St | 22 | Front Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6004318.84944 | 2105025.54229 | 37.7602434426069 | -122.4281496397 | (37.7602434426069, -122.4281496397) | 2 | 4 | 5 | 28862 | 3 | |||
170849 | 186531 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 2 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 5984751.3064 | 2104919.289 | 37.7588251541556 | -122.495815712177 | (37.7588251541556, -122.495815712177) | 1 | 8 | 3 | 56 | 35 | |||
78908 | 194452 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6011998.43391 | 2104639.55141 | 37.7596151114626 | -122.401562284167 | (37.7596151114626, -122.401562284167) | 10 | 3 | 8 | 28856 | 29 | |||
74337 | 211057 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 447 Lawton St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 5992810.26786 | 2104540.37946 | 37.7582534434534 | -122.467916772063 | (37.7582534434534, -122.467916772063) | 1 | 8 | 4 | 56 | 12 | |||
179563 | 211058 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 447 Lawton St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5992805.57319 | 2104540.3462 | 37.7582530810297 | -122.467933005722 | (37.7582530810297, -122.467933005722) | 1 | 8 | 4 | 56 | 12 | |||
132701 | 186592 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984742.0945 | 2104511.4521 | 37.757704808066 | -122.495817486185 | (37.757704808066, -122.495817486185) | 1 | 8 | 3 | 56 | 35 | |||
93032 | 186593 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984773.0801 | 2104494.2844 | 37.7576594849516 | -122.495709060541 | (37.7576594849516, -122.495709060541) | 1 | 8 | 3 | 56 | 35 | |||
103634 | 186594 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984719.4834 | 2104488.841 | 37.7576414000341 | -122.495894015518 | (37.7576414000341, -122.495894015518) | 1 | 8 | 3 | 56 | 35 | |||
11326 | 186595 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984740.8383 | 2104479.6291 | 37.7576173573885 | -122.49581948315 | (37.7576173573885, -122.49581948315) | 1 | 8 | 3 | 56 | 35 | |||
118830 | 211056 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1600 17th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5990908.64637 | 2104472.93122 | 37.7579582535812 | -122.474488420401 | (37.7579582535812, -122.474488420401) | 1 | 8 | 4 | 56 | 12 | ||||
173494 | 181382 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1500 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984896.9779 | 2104470.096 | 37.7576003251998 | -122.49527879388 | (37.7576003251998, -122.49527879388) | 1 | 8 | 3 | 56 | 35 | |||
54785 | 186417 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1601 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984727.1251 | 2104191.8612 | 37.7568264235859 | -122.495845680799 | (37.7568264235859, -122.495845680799) | 1 | 8 | 3 | 56 | 35 | |||
164309 | 233330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 4053 20th St | 9 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6003355.15759 | 2104159.05112 | 37.7578096927712 | -122.431420737491 | (37.7578096927712, -122.431420737491) | 2 | 4 | 5 | 28862 | 3 | |||
120346 | 98601 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 301 Twin Peaks Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 5998661.2 | 2104103.7 | 37.757390562446 | -122.447650343479 | (37.757390562446, -122.447650343479) | 15 | 5 | 5 | 63 | 3 | |||
167835 | 184087 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1600 Sunset Blvd | 88 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984947.9817 | 2104096.3091 | 37.7565769961358 | -122.495074842554 | (37.7565769961358, -122.495074842554) | 1 | 8 | 3 | 56 | 35 | |||
173903 | 184079 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1600 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984934.15 | 2104045.1938 | 37.7564358379272 | -122.49511890768 | (37.7564358379272, -122.49511890768) | 1 | 8 | 3 | 56 | 35 | |||
45383 | 186433 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1601 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984738.4307 | 2104031.9087 | 37.7563879005336 | -122.495794783817 | (37.7563879005336, -122.495794783817) | 1 | 8 | 3 | 56 | 35 | |||
37367 | 194451 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 930 Kansas St | 1 | Front Yard : Yard | Tree | Private 2 | 29 | 6011573.12502 | 2104017.28324 | 37.7578827599862 | -122.402989455212 | (37.7578827599862, -122.402989455212) | 10 | 3 | 8 | 28856 | 29 | ||||
81035 | 194456 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 22nd St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6013384.43791 | 2103815.09856 | 37.7574285843868 | -122.396710957944 | (37.7574285843868, -122.396710957944) | 10 | 3 | 8 | 28856 | 29 | ||||
128353 | 194455 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 22nd St | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 6013406.26386 | 2103790.51305 | 37.757362292666 | -122.396633751156 | (37.757362292666, -122.396633751156) | 10 | 3 | 8 | 28856 | 29 | ||||
133127 | 194437 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1021 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6015301.57899 | 2103740.56291 | 37.7573304413508 | -122.390075457711 | (37.7573304413508, -122.390075457711) | 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 | |||
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 | |||
186214 | 234513 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 998 York St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6009942.57021 | 2103461.5506 | 37.7562656557487 | -122.408589420289 | (37.7562656557487, -122.408589420289) | 2 | 4 | 7 | 28859 | 19 | |||
145433 | 234514 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 998 York St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009944.54234 | 2103430.26244 | 37.7561798559202 | -122.408580392894 | (37.7561798559202, -122.408580392894) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
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 | ||||
152112 | 186248 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1701 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984775.1177 | 2103139.467 | 37.7539396511246 | -122.495602086568 | (37.7539396511246, -122.495602086568) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
126322 | 186253 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1701 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984779.1353 | 2103090.988 | 37.7538067764424 | -122.495584617514 | (37.7538067764424, -122.495584617514) | 1 | 8 | 3 | 56 | 35 | |||
170803 | 186254 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1701 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984796.5449 | 2103072.2391 | 37.7537563165951 | -122.495523029283 | (37.7537563165951, -122.495523029283) | 1 | 8 | 3 | 56 | 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) );