trees
294 rows where qCaretaker_id = 2 and qSpecies_id = 63 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63112 | 201741 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015551.73985 | 2087509.47398 | 37.7127770280164 | -122.388077638997 | (37.7127770280164, -122.388077638997) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 166606 | 201762 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6015664.25655 | 2087408.13431 | 37.712505001973 | -122.387681675578 | (37.712505001973, -122.387681675578) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 156029 | 201763 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015661.0546 | 2087420.2073 | 37.7125379747236 | -122.387693584416 | (37.7125379747236, -122.387693584416) | 10 | 3 | 8 | 58 | 1 | |||
| 168552 | 201742 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015557.23057 | 2087482.77303 | 37.7127040165438 | -122.388056798998 | (37.7127040165438, -122.388056798998) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 122823 | 201764 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015653.28128 | 2087440.52101 | 37.7125933216851 | -122.387721868094 | (37.7125933216851, -122.387721868094) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | ||||
| 172168 | 201743 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015564.44995 | 2087435.02252 | 37.7125733027894 | -122.388028516211 | (37.7125733027894, -122.388028516211) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 57881 | 201744 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015567.574 | 2087419.0912 | 37.7125297315236 | -122.388016607392 | (37.7125297315236, -122.388016607392) | 10 | 3 | 8 | 58 | 1 | |||
| 119760 | 247143 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500 27th St | 13 | Front Yard : Yard | Tree | Private 2 | 26 | 6003160.52798 | 2100099.92491 | 37.7466532583536 | -122.431804027655 | (37.7466532583536, -122.431804027655) | 2 | 7 | 5 | 63 | 22 | ||||
| 171241 | 201765 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015652.50021 | 2087465.84041 | 37.7126628006338 | -122.387726333216 | (37.7126628006338, -122.387726333216) | 10 | 3 | 8 | 58 | 1 | |||
| 32167 | 201766 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015647.69731 | 2087483.94989 | 37.7127122597387 | -122.387744196458 | (37.7127122597387, -122.387744196458) | 10 | 3 | 8 | 58 | 1 | |||
| 92200 | 247144 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500 27th St | 14 | Front Yard : Yard | Tree | Private 2 | 23 | 6003151.94767 | 2100099.93337 | 37.7466527951889 | -122.431833698065 | (37.7466527951889, -122.431833698065) | 2 | 7 | 5 | 63 | 22 | ||||
| 185304 | 194444 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 25th St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6014137.98688 | 2101954.90704 | 37.7523628094083 | -122.393974650128 | (37.7523628094083, -122.393974650128) | 10 | 3 | 8 | 28856 | 1 | ||||
| 187791 | 201745 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015574.32176 | 2087390.64932 | 37.7124520094198 | -122.387991301359 | (37.7124520094198, -122.387991301359) | 10 | 3 | 8 | 58 | 1 | |||
| 106214 | 201767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015642.29299 | 2087514.93769 | 37.7127970469199 | -122.387765036445 | (37.7127970469199, -122.387765036445) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | |||
| 126912 | 194445 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 25th St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6014148.42594 | 2101954.90209 | 37.7523633759809 | -122.393938549541 | (37.7523633759809, -122.393938549541) | 10 | 3 | 8 | 28856 | 1 | ||||
| 160907 | 201746 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015580.41623 | 2087372.51377 | 37.7124025503214 | -122.387968972099 | (37.7124025503214, -122.387968972099) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 96403 | 201768 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015641.02933 | 2087537.69345 | 37.7128594598683 | -122.387770990859 | (37.7128594598683, -122.387770990859) | 10 | 3 | 8 | 58 | 1 | |||
| 119044 | 201747 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015587.35405 | 2087353.50341 | 37.7123507358797 | -122.387943666966 | (37.7123507358797, -122.387943666966) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 140344 | 194446 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 25th St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014162.91853 | 2101954.38506 | 37.7523627617528 | -122.393888395238 | (37.7523627617528, -122.393888395238) | 10 | 3 | 8 | 28856 | 1 | ||||
| 107661 | 201748 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015601.73852 | 2087319.33199 | 37.7122577046069 | -122.387891566548 | (37.7122577046069, -122.387891566548) | 10 | 3 | 8 | 58 | 1 | |||
| 114462 | 201769 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015636.77799 | 2087561.79601 | 37.7129254053659 | -122.387787365691 | (37.7129254053659, -122.387787365691) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | |||
| 20635 | 201770 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015634.53236 | 2087578.56705 | 37.712971331023 | -122.387796296857 | (37.712971331023, -122.387796296857) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 191991 | 202090 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Gould St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012861.1738 | 2091181.83519 | 37.7227111623612 | -122.397634574298 | (37.7227111623612, -122.397634574298) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 191105 | 201771 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015632.38361 | 2087621.49757 | 37.7130890909533 | -122.387806717322 | (37.7130890909533, -122.387806717322) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 5675 | 261201 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 699x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007339 | 2095419 | 37.7340364554683 | -122.417023656077 | (37.7340364554683, -122.417023656077) | 2 | 7 | 7 | 28859 | 2 | ||||
| 7002 | 262493 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5995372 | 2097783 | 37.7398469739468 | -122.458568082407 | (37.7398469739468, -122.458568082407) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | ||||
| 18973 | 233322 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 51 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008884.18383 | 2098343.89419 | 37.7421543791283 | -122.411888074199 | (37.7421543791283, -122.411888074199) | 10 | 7 | 7 | 28859 | 2 | |||
| 21065 | 201733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015510.4184 | 2087766.77172 | 37.7134812286504 | -122.388238406274 | (37.7134812286504, -122.388238406274) | 10 | 3 | 8 | 58 | 1 | |||
| 49979 | 99473 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 600X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
| 65583 | 194443 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1900 23rd St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6012732.21441 | 2102858.09004 | 37.7547645253758 | -122.398899455441 | (37.7547645253758, -122.398899455441) | 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 | |||
| 82734 | 201750 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 8ft | 6015853.10494 | 2087012.76113 | 37.7114298417752 | -122.3870013933 | (37.7114298417752, -122.3870013933) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 106418 | 201754 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015794.33118 | 2087216.37677 | 37.7119856767735 | -122.387218726159 | (37.7119856767735, -122.387218726159) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 149206 | 234518 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1481 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6003337.48877 | 2099628.14838 | 37.7453678996008 | -122.431158447529 | (37.7453678996008, -122.431158447529) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 176495 | 234508 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 201 Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 28 | Width 5ft | 6007691.39954 | 2099521.32268 | 37.745320345265 | -122.416095727735 | (37.745320345265, -122.416095727735) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 2154 | 234510 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 15 | 6004874.94559 | 2096454.63294 | 37.7367411519672 | -122.425616344829 | (37.7367411519672, -122.425616344829) | 2 | 7 | 5 | 28859 | 2 | ||||
| 11808 | 247102 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2301 Castro St | 20 | Front Yard : Yard | Tree | Private 2 | 35 | 6002745.76405 | 2098754.96889 | 37.7429368028052 | -122.43314215589 | (37.7429368028052, -122.43314215589) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | |||
| 188380 | 201772 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015630.59439 | 2087639.54626 | 37.7131385500726 | -122.387814160092 | (37.7131385500726, -122.387814160092) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 48450 | 201773 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015629.12317 | 2087652.01307 | 37.7131727000372 | -122.387820114508 | (37.7131727000372, -122.387820114508) | 10 | 3 | 8 | 58 | 1 | |||
| 88434 | 247104 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2301 Castro St | 22 | Front Yard : Yard | Tree | Private 2 | 31 | 6002734.00484 | 2098778.85198 | 37.743001713153 | -122.433184522069 | (37.743001713153, -122.433184522069) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | |||
| 182292 | 201774 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.7132009621398 | -122.38783202245 | (37.7132009621398, -122.38783202245) | 10 | 3 | 8 | 58 | 1 | |||
| 183877 | 201775 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015614.36786 | 2087706.44647 | 37.7133213462866 | -122.387874910195 | (37.7133213462866, -122.387874910195) | 10 | 3 | 8 | 58 | 1 | |||
| 67122 | 201776 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015607.24672 | 2087763.10237 | 37.7134765179931 | -122.387903474463 | (37.7134765179931, -122.387903474463) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 99536 | 201777 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015601.56547 | 2087780.3718 | 37.7135236217889 | -122.387924315354 | (37.7135236217889, -122.387924315354) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 60884 | 247108 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2301 Castro St | 26 | Front Yard : Yard | Tree | Private 2 | 48 | 6002704.67605 | 2098786.321 | 37.7430205575564 | -122.433286466502 | (37.7430205575564, -122.433286466502) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | |||
| 164947 | 201778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015594.19044 | 2087820.40535 | 37.7136331376383 | -122.387952598145 | (37.7136331376383, -122.387952598145) | 10 | 3 | 8 | 58 | 1 | |||
| 101832 | 247109 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2301 Castro St | 27 | Front Yard : Yard | Tree | Private 2 | 55 | 6002712.35608 | 2098750.32101 | 37.7429221456486 | -122.433257339272 | (37.7429221456486, -122.433257339272) | 2 | 7 | 5 | 63 | 22 | ||||
| 187046 | 201779 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015589.3271 | 2087835.51364 | 37.7136743526627 | -122.387970461377 | (37.7136743526627, -122.387970461377) | 10 | 3 | 8 | 58 | 1 | |||
| 132708 | 201780 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015582.72471 | 2087849.79956 | 37.7137132132682 | -122.387994278123 | (37.7137132132682, -122.387994278123) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 96989 | 201781 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015573.4977 | 2087883.43723 | 37.713805064638 | -122.388028516222 | (37.713805064638, -122.388028516222) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 27135 | 194470 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Whitney Young Cir | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016764.11928 | 2095038.85548 | 37.7335183423928 | -122.384411315236 | (37.7335183423928, -122.384411315236) | 10 | 3 | 8 | 58 | 1 | ||||
| 38128 | 201734 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015517.44938 | 2087731.03371 | 37.71338348853 | -122.388211611887 | (37.71338348853, -122.388211611887) | 10 | 3 | 8 | 58 | 1 | |||
| 38402 | 194467 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Quint St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012416.6749 | 2095223.97206 | 37.7337852773717 | -122.399454760738 | (37.7337852773717, -122.399454760738) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||||
| 142542 | 201755 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015777.13838 | 2087239.45412 | 37.7120480906272 | -122.38727975865 | (37.7120480906272, -122.38727975865) | 10 | 3 | 8 | 58 | 1 | |||
| 142912 | 99486 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 700X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
| 144133 | 201751 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6015871.64119 | 2086992.23012 | 37.7113744939227 | -122.386935895675 | (37.7113744939227, -122.386935895675) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | |||
| 163675 | 194461 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012563.25713 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | 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 | ||||
| 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 |
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) );