trees
294 rows where qCaretaker_id = 2 and qSpecies_id = 63 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118486 | 100845 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1 Estero Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
66441 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009924 | 2099647 | 37.7457907048197 | -122.408384592716 | (37.7457907048197, -122.408384592716) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
36162 | 110396 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1x ARLETA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011055 | 2087587 | 37.7127397354919 | -122.403625353192 | (37.7127397354919, -122.403625353192) | 9 | 7 | 8 | 309 | 39 | ||||
120938 | 110397 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 2200 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011234 | 2087411 | 37.7122664722191 | -122.40299429709 | (37.7122664722191, -122.40299429709) | 9 | 7 | 8 | 309 | 39 | ||||
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 | ||
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 | |
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 | ||||
29057 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 6006172 | 2100967 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||||
87762 | 117289 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 26X GLADEVIEW WAY | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997876 | 2101605 | 37.7504848455829 | -122.450185761312 | (37.7504848455829, -122.450185761312) | 1 | 5 | 4 | 63 | 38 | ||||
36915 | 117645 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2901 21ST AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989904 | 2095901 | 37.734363711699 | -122.477336418651 | (37.734363711699, -122.477336418651) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||
162461 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
156900 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
109715 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
136239 | 120933 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
145282 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162123 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
140522 | 121695 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
8023 | 121696 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
179258 | 121697 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
3910 | 173844 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2X Crestline Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5999319 | 2101169 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | 2 | 5 | 5 | 63 | 38 | |||||
154451 | 178178 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 769 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6001369.37887 | 2092541.7115 | 37.725798463024 | -122.43745647446 | (37.725798463024, -122.43745647446) | 9 | 7 | 6 | 28861 | 25 | |||
188305 | 178179 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 201 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6007200.07685 | 2092715.80897 | 37.7266062646522 | -122.417312460112 | (37.7266062646522, -122.417312460112) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
41307 | 184977 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2701 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984998.3534 | 2096742.4516 | 37.7363882534207 | -122.494358589298 | (37.7363882534207, -122.494358589298) | 1 | 8 | 3 | 29491 | 35 | |||
193239 | 184993 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2701 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5985021.3833 | 2096558.6319 | 37.7358848813643 | -122.494265421421 | (37.7358848813643, -122.494265421421) | 1 | 8 | 3 | 29491 | 35 | |||
39844 | 185075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2801 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985040.8539 | 2096108.9226 | 37.7346512389504 | -122.494164969235 | (37.7346512389504, -122.494164969235) | 1 | 8 | 3 | 29491 | 35 | |||
184638 | 185176 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2500 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5985156.5992 | 2097794.2406 | 37.7392854441206 | -122.493888963204 | (37.7392854441206, -122.493888963204) | 1 | 8 | 3 | 29491 | 35 | |||
63898 | 185202 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2500 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5985155.2712 | 2097966.8909 | 37.7397594177965 | -122.493906274966 | (37.7397594177965, -122.493906274966) | 1 | 8 | 3 | 29491 | 35 | |||
116998 | 185204 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2500 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985139.3342 | 2097991.4603 | 37.7398259462999 | -122.493963187792 | (37.7398259462999, -122.493963187792) | 1 | 8 | 3 | 29491 | 35 | |||
45510 | 185230 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2509 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 0ft | 5982693.8052 | 2098008.2989 | 37.7397287878455 | -122.50241990404 | (37.7397287878455, -122.50241990404) | 1 | 8 | 3 | 29491 | 35 | |||
109871 | 185295 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.8666 | 2097355.3585 | 37.7380690548117 | -122.494526449097 | (37.7380690548117, -122.494526449097) | 1 | 8 | 3 | 29491 | 35 | |||
43488 | 185314 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985007.4607 | 2097237.2784 | 37.7377474483668 | -122.494363565845 | (37.7377474483668, -122.494363565845) | 1 | 8 | 3 | 29491 | 35 | |||
143060 | 185340 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984975.3236 | 2097003.7352 | 37.7371043205037 | -122.494457466722 | (37.7371043205037, -122.494457466722) | 1 | 8 | 3 | 29491 | 35 | |||
78578 | 185360 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 85 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985022.2207 | 2096895.7045 | 37.7368104416486 | -122.494287364038 | (37.7368104416486, -122.494287364038) | 1 | 8 | 3 | 29491 | 35 | |||
156225 | 185362 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 87 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984999.1909 | 2096870.1623 | 37.7367389618664 | -122.494365104774 | (37.7367389618664, -122.494365104774) | 1 | 8 | 3 | 29491 | 35 | |||
128546 | 185363 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 88 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 0ft | 5984980.3483 | 2096870.9998 | 37.7367401586853 | -122.494430312609 | (37.7367401586853, -122.494430312609) | 1 | 8 | 3 | 29491 | 35 | |||
188950 | 185409 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2300 Sunset Blvd | 24 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985081.6412 | 2099150.9001 | 37.7430060796886 | -122.494248101225 | (37.7430060796886, -122.494248101225) | 1 | 8 | 3 | 29491 | 35 | |||
189399 | 185410 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2300 Sunset Blvd | 25 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985099.6362 | 2099155.3989 | 37.7430194852088 | -122.494186211855 | (37.7430194852088, -122.494186211855) | 1 | 8 | 3 | 29491 | 35 | |||
75335 | 185550 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2201 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984877.5845 | 2099886.0836 | 37.7450127509214 | -122.495007861214 | (37.7450127509214, -122.495007861214) | 1 | 8 | 3 | 29491 | 35 | |||
172030 | 185637 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985047.0682 | 2100399.1831 | 37.7464315030837 | -122.494459642192 | (37.7464315030837, -122.494459642192) | 1 | 8 | 3 | 29491 | 35 | |||
56295 | 185638 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985050.0993 | 2100407.4104 | 37.7464542704067 | -122.494449767525 | (37.7464542704067, -122.494449767525) | 1 | 8 | 3 | 29491 | 35 | |||
190239 | 185656 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985042.305 | 2100549.4408 | 37.746843791076 | -122.494487187243 | (37.746843791076, -122.494487187243) | 1 | 8 | 3 | 29491 | 35 | |||
95767 | 185659 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985060.0587 | 2100566.7616 | 37.7468923883135 | -122.494427074117 | (37.7468923883135, -122.494427074117) | 1 | 8 | 3 | 29491 | 35 | |||
101713 | 185705 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2101 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984891.1634 | 2100474.9689 | 37.7466304646766 | -122.495004322509 | (37.7466304646766, -122.495004322509) | 1 | 8 | 3 | 29491 | 35 | |||
21400 | 186097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984866.2826 | 2101735.8043 | 37.7500909175156 | -122.495183318527 | (37.7500909175156, -122.495183318527) | 1 | 8 | 3 | 29491 | 35 | |||
42969 | 186098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984859.9858 | 2101721.9514 | 37.7500525125937 | -122.495204071455 | (37.7500525125937, -122.495204071455) | 1 | 8 | 3 | 29491 | 35 | |||
192105 | 186099 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984856.2078 | 2101707.4688 | 37.7500125261534 | -122.495216067916 | (37.7500125261534, -122.495216067916) | 1 | 8 | 3 | 29491 | 35 | |||
16186 | 186101 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984808.9821 | 2101715.6546 | 37.7500322370685 | -122.495379978089 | (37.7500322370685, -122.495379978089) | 1 | 8 | 3 | 29491 | 35 | |||
86298 | 186102 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984817.1679 | 2101703.0611 | 37.7499981380626 | -122.495350742926 | (37.7499981380626, -122.495350742926) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
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 | |||
106470 | 186343 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1801 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984811.8118 | 2102790.6052 | 37.7529839215525 | -122.495449463877 | (37.7529839215525, -122.495449463877) | 1 | 8 | 3 | 56 | 35 | |||
121598 | 186348 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1801 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984789.3132 | 2102727.1271 | 37.7528083107787 | -122.495522585708 | (37.7528083107787, -122.495522585708) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
61393 | 186897 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2700 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 0ft | 5985183.7588 | 2096592.6965 | 37.7359879144627 | -122.493706542591 | (37.7359879144627, -122.493706542591) | 1 | 8 | 3 | 29491 | 35 | |||
102199 | 186902 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2700 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5985182.8419 | 2096662.3766 | 37.7361791837873 | -122.493714845671 | (37.7361791837873, -122.493714845671) | 1 | 8 | 3 | 29491 | 35 | |||
85521 | 187012 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2501 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984974.837 | 2098002.6963 | 37.7398471711362 | -122.494532769595 | (37.7398471711362, -122.494532769595) | 1 | 8 | 3 | 29491 | 35 | |||
183575 | 187017 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2501 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984955.1646 | 2097931.5729 | 37.7396507340198 | -122.494595545547 | (37.7396507340198, -122.494595545547) | 1 | 8 | 3 | 29491 | 35 | |||
157519 | 187090 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5985165.338 | 2097125.749 | 37.7374504565555 | -122.493809499319 | (37.7374504565555, -122.493809499319) | 1 | 8 | 3 | 29491 | 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) );