trees
366 rows where qLegalStatus_id = 1 and qSpecies_id = 63 sorted by YCoord
This data as json, CSV (advanced)
These facets timed out: qLegalStatus_id
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 67798 | 211064 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 35 | 5995363.79151 | 2092232.49572 | 37.7246061670234 | -122.458194844436 | (37.7246061670234, -122.458194844436) | 9 | 7 | 4 | 28861 | 40 | ||||
| 62980 | 211065 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 400x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 25 | 5995367.47216 | 2092431.62053 | 37.7251531275117 | -122.458196526171 | (37.7251531275117, -122.458196526171) | 9 | 7 | 4 | 28861 | 40 | ||||
| 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 | |||
| 87097 | 211066 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 36 | 5995372.70371 | 2092704.86629 | 37.7259036953978 | -122.458198208802 | (37.7259036953978, -122.458198208802) | 9 | 7 | 4 | 28861 | 40 | ||||
| 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 | |||
| 99546 | 211067 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 39 | 5995372.66361 | 2092795.985 | 37.7261538831809 | -122.458204939322 | (37.7261538831809, -122.458204939322) | 9 | 7 | 4 | 28861 | 40 | ||||
| 50718 | 211068 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | 9 | 7 | 4 | 28861 | 40 | ||||
| 145613 | 211069 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 29 | 5995377.19569 | 2093059.06381 | 37.7268764947539 | -122.458208304568 | (37.7268764947539, -122.458208304568) | 9 | 7 | 4 | 28861 | 40 | ||||
| 12567 | 211070 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 7 | Median : Yard | Tree | DPW 1 | 24 | 5995378.92982 | 2093188.43217 | 37.7272318087773 | -122.458211668947 | (37.7272318087773, -122.458211668947) | 9 | 7 | 4 | 28861 | 40 | ||||
| 161389 | 211071 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 8 | Median : Yard | Tree | DPW 1 | 25 | 5995380.09454 | 2093218.25605 | 37.727313764897 | -122.458209800169 | (37.727313764897, -122.458209800169) | 9 | 7 | 4 | 28861 | 40 | ||||
| 30931 | 211072 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 35 | 5995382.34021 | 2093429.07469 | 37.7278927511259 | -122.458217288807 | (37.7278927511259, -122.458217288807) | 9 | 7 | 4 | 28861 | 40 | ||||
| 28620 | 211073 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 26 | 5995385.83715 | 2093544.41078 | 37.7282096371561 | -122.458213544022 | (37.7282096371561, -122.458213544022) | 9 | 7 | 4 | 28861 | 40 | ||||
| 60529 | 211074 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 30 | 5995392.34643 | 2093881.33119 | 37.7291351132945 | -122.458215416413 | (37.7291351132945, -122.458215416413) | 9 | 7 | 4 | 28861 | 40 | ||||
| 133 | 211075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | 9 | 7 | 4 | 28861 | 40 | ||||
| 70780 | 211076 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 74 | 5995394.80602 | 2094076.5012 | 37.7296711442905 | -122.458221033586 | (37.7296711442905, -122.458221033586) | 9 | 7 | 4 | 28861 | 40 | ||||
| 160036 | 253982 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 438X Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5999326 | 2094622 | 37.7313940668699 | -122.444669716777 | (37.7313940668699, -122.444669716777) | 9 | 7 | 4 | 59 | 40 | ||||
| 16552 | 261549 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3101 Sunset Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5984952 | 2094961 | 37.7314941488449 | -122.494387573147 | (37.7314941488449, -122.494387573147) | 1 | 8 | 4 | 64 | 35 | ||||
| 152878 | 234517 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Benton Ave | 1 | Median : Yard | Tree | DPW 1 | 29 | 6004828.72428 | 2095028.54608 | 37.7328228256069 | -122.425674682059 | (37.7328228256069, -122.425674682059) | 2 | 7 | 7 | 28861 | 2 | ||||
| 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 | ||||
| 163834 | 194471 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Whitney Young Cir | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6016756.75905 | 2095047.76274 | 37.7335423929578 | -122.38443738208 | (37.7335423929578, -122.38443738208) | 10 | 3 | 8 | 58 | 1 | ||||
| 14391 | 194472 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Whitney Young Cir | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016745.33826 | 2095063.00852 | 37.7335836232886 | -122.384477928938 | (37.7335836232886, -122.384477928938) | 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 | |||
| 137520 | 194468 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Quint St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6012422.70585 | 2095229.76642 | 37.7338015236278 | -122.399434316464 | (37.7338015236278, -122.399434316464) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 22210 | 111263 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 1 | Front Yard : Yard | Tree | DPW 1 | 36 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 55697 | 111280 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 18 | Front Yard : Cutout | Tree | DPW 1 | 48 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 148503 | 111281 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X BOSWORTH ST | 19 | Front Yard : Yard | Tree | DPW 1 | 48 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 50762 | 2044 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X Bosworth St | 1 | Front Yard : Cutout | Tree | DPW 1 | 36 | Permit Number 772999 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
| 161041 | 234512 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 12 | Width 6ft | 6003219.80457 | 2095456.80721 | 37.7339076867834 | -122.431267680974 | (37.7339076867834, -122.431267680974) | 2 | 7 | 5 | 63 | 7 | |||
| 62583 | 234511 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 5 | Width 10ft | 6003237.34595 | 2095470.24367 | 37.7339455743229 | -122.431207993878 | (37.7339455743229, -122.431207993878) | 2 | 7 | 5 | 63 | 7 | |||
| 3008 | 251503 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 15 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 22926 | 251501 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 13 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 60691 | 111521 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 16 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 63289 | 111517 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 12 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 68470 | 251502 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 14 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 69354 | 111518 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 13 | Front Yard : Yard | Tree | DPW 1 | 27 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 90813 | 111522 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 20 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 115262 | 251499 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 11 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 150055 | 111519 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 14 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 177928 | 251498 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 10 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 183860 | 111506 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800x BOSWORTH ST | 1 | Front Yard : Yard | Tree | DPW 1 | 48 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 184944 | 251500 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 12 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 136927 | 211081 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Melrose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999513.42858 | 2095531.79881 | 37.7339028547188 | -122.444087092249 | (37.7339028547188, -122.444087092249) | 9 | 7 | 4 | 63 | 40 | |||
| 186578 | 211080 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Melrose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999525.10685 | 2095532.7271 | 37.7339060697915 | -122.444046783738 | (37.7339060697915, -122.444046783738) | 9 | 7 | 4 | 63 | 40 | |||
| 38246 | 111524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 110008 | 111523 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x BOSWORTH ST | 1 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 163088 | 12974 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001901.0890899 | 2095580.5218873 | 37.7341725574726 | -122.435835722721 | (37.7341725574726, -122.435835722721) | 2 | 7 | 5 | 63 | 7 | |||
| 15787 | 12969 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
| 121594 | 12970 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 5X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
| 134644 | 12968 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
| 186052 | 12967 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
| 170298 | 211082 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 843 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999417.62854 | 2095618.00896 | 37.7341341018996 | -122.444424494503 | (37.7341341018996, -122.444424494503) | 9 | 7 | 4 | 59 | 40 | |||
| 20964 | 217820 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1x Junipero Serra Blvd | 7 | Median : Yard | Tree | DPW 1 | 3 | 5991627.31768 | 2095659.97546 | 37.7338017601455 | -122.471360849935 | (37.7338017601455, -122.471360849935) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 73422 | 234509 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 25 | 6004750.38207 | 2096347.45133 | 37.7364398161369 | -122.426039387727 | (37.7364398161369, -122.426039387727) | 2 | 7 | 5 | 28859 | 2 | ||||
| 105788 | 218299 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Ardenwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991311.90242 | 2096390.21304 | 37.7357885567818 | -122.472504543874 | (37.7357885567818, -122.472504543874) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 12407 | 115154 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 3 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
| 93601 | 115152 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 1 | Median : Yard | Tree | DPW 1 | 30 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | |||
| 97461 | 115155 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 4 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
| 105484 | 115153 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 2 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
| 126197 | 115156 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 5 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | |||
| 187165 | 234507 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 9ft | 6004787.92016 | 2096687.497 | 37.7373756263678 | -122.425933801003 | (37.7373756263678, -122.425933801003) | 2 | 7 | 5 | 63 | 7 | |||
| 148660 | 234506 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 24 | 6004826.97139 | 2096714.28402 | 37.737451384369 | -122.425800688759 | (37.737451384369, -122.425800688759) | 2 | 7 | 5 | 63 | 7 | ||||
| 119227 | 234505 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 16 | 6004841.55243 | 2096717.56088 | 37.7374612058616 | -122.425750508406 | (37.7374612058616, -122.425750508406) | 2 | 7 | 5 | 63 | 7 | ||||
| 105900 | 234504 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 16 | 6004845.11812 | 2096728.13188 | 37.7374904329363 | -122.425738932323 | (37.7374904329363, -122.425738932323) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 120570 | 187096 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985160.1655 | 2097173.7115 | 37.7375818461267 | -122.493830916284 | (37.7375818461267, -122.493830916284) | 1 | 8 | 3 | 29491 | 35 | |||
| 42716 | 187095 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985178.0339 | 2097175.5923 | 37.7375880557056 | -122.493769276198 | (37.7375880557056, -122.493769276198) | 1 | 8 | 3 | 29491 | 35 | |||
| 19749 | 234503 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1000 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 2 | 6005117.95051 | 2097175.77056 | 37.7387349615553 | -122.424827458621 | (37.7387349615553, -122.424827458621) | 2 | 7 | 5 | 63 | 7 | ||||
| 66936 | 187102 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985165.8082 | 2097224.4952 | 37.7377216147142 | -122.493815148362 | (37.7377216147142, -122.493815148362) | 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 | |||
| 49420 | 187123 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 0ft | 5985149.3505 | 2097343.9312 | 37.7380485911062 | -122.493880849001 | (37.7380485911062, -122.493880849001) | 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 | |||
| 31868 | 13401 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 344 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 70 | 5 | 5999579.163416 | 2097433.156503 | 37.7391272835542 | -122.443996396446 | (37.7391272835542, -122.443996396446) | 9 | 7 | 4 | 59 | 40 | |||
| 6140 | 243478 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1499X Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008755.36846 | 2097659.39973 | 37.7402676797185 | -122.412285110476 | (37.7402676797185, -122.412285110476) | 10 | 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 | ||||
| 10438 | 262492 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5995372 | 2097783 | 37.7398469739468 | -122.458568082407 | (37.7398469739468, -122.458568082407) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||
| 164258 | 253422 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2X Miraloma Dr | 1 | Side Yard : Cutout | Tree | DPW 1 | 10x10 | 5994995 | 2097925 | 37.7402151966004 | -122.459881864698 | (37.7402151966004, -122.459881864698) | 9 | 8 | 4 | 59 | 40 | ||||
| 184680 | 256643 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2X Miraloma Dr | 2 | Side Yard : Cutout | Tree | DPW 1 | 10x10 | 5994995 | 2097925 | 37.7402151966004 | -122.459881864698 | (37.7402151966004, -122.459881864698) | 9 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 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 | |||
| 82478 | 98836 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 148910 | 110143 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1130X PORTOLA DR | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 3x3 | 5994964 | 2098019 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | 1 | 8 | 4 | 59 | 40 | ||||
| 153642 | 107347 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1126X PORTOLA DR | 1 | Median : Cutout | Tree | DPW 1 | 68 | 5994964 | 2098019 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | 1 | 8 | 4 | 59 | 40 | ||||
| 9305 | 251160 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
| 17261 | 261487 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 |
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) );