trees
2,306 rows where qSpecies_id = 15 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
| 533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
| 6758 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 180 Yukon St | Back Yard : Cutout | Tree | Private 2 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.442406920559 | (37.7570738455347, -122.442406920559) | 2 | 4 | 5 | 28862 | 3 | ||||
| 13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 | |||||
| 15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
| 16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
| 23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
| 23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
| 26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 33684 | 97290 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 55 Hiliritas Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | 2 | 7 | 5 | 63 | 7 | |||||
| 34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
| 35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
| 38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
| 40432 | 110929 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 445 BEACON ST | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002243 | 2098437 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | 2 | 7 | 5 | 63 | 7 | |||||
| 47675 | 92871 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 3600 Jackson St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53088 | 5997031 | 2116025 | 37.7900300525901 | -122.454149203806 | (37.7900300525901, -122.454149203806) | 11 | 6 | 1 | 54 | 31 | ||||
| 48591 | 114380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 437X SERRANO DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 48 | 5988907 | 2090368 | 37.7191136019865 | -122.480378474397 | (37.7191136019865, -122.480378474397) | 1 | 8 | 4 | 64 | 14 | |||||
| 51148 | 105904 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.472357697274 | (37.7129229890255, -122.472357697274) | 1 | 8 | 4 | 64 | 14 | |||||
| 76023 | 107819 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 75X RALSTON ST | Back Yard : Yard | Tree | Private 2 | 45 | Permit Number 775492 | 5992193 | 2088303 | 37.7136340221674 | -122.468869945866 | (37.7136340221674, -122.468869945866) | 9 | 8 | 6 | 64 | 24 | ||||
| 77157 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||||
| 80435 | 112123 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 771 WALLER ST | Back Yard : Yard | Tree | Private 2 | 24 | 3x3 | 6002060 | 2108730 | 37.7702869131062 | -122.436227034456 | (37.7702869131062, -122.436227034456) | 15 | 5 | 5 | 29492 | 9 | ||||
| 84518 | 112016 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | ||||
| 113165 | 113482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2839 Pierce St | Back Yard : Yard | Tree | Private 2 | 6001345 | 2118077 | 37.7959107386074 | -122.439370308548 | (37.7959107386074, -122.439370308548) | 13 | 9 | 1 | 57 | 17 | ||||||
| 116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 117185 | 98714 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500X Brotherhood Way | Front Yard : Yard | Tree | DPW 1 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||||
| 127263 | 98715 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 26 Vernon St | Back Yard : Yard | Tree | Private 2 | 5992459 | 2088068 | 37.713004133171 | -122.467933479353 | (37.713004133171, -122.467933479353) | 9 | 8 | 6 | 64 | 24 | ||||||
| 127808 | 113438 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 180x LOWER TER | Median : Yard | Tree | Private 2 | 22 | 3x3 | 6000120 | 2106246 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | 15 | 5 | 5 | 28862 | 3 | ||||
| 137033 | 114410 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 10 GARDENSIDE DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999306 | 2102458 | 37.7529087049134 | -122.445302055175 | (37.7529087049134, -122.445302055175) | 2 | 5 | 5 | 63 | 38 | ||||||
| 142853 | 107503 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4140 19th Ave | Back Yard : Yard | Tree | Private 2 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | 9 | 8 | 6 | 64 | 24 | ||||||
| 143770 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 342 HILL ST | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 778799 | 6004048 | 2103384 | 37.7557208285242 | -122.428969343229 | (37.7557208285242, -122.428969343229) | 2 | 4 | 5 | 28862 | 22 | |||
| 151938 | 104939 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 152091 | 86746 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 41 Nevada St | Front Yard : Yard | Tree | Private 2 | Permit Number 49711 | 6009063 | 2098235 | 37.7418654099413 | -122.411262090685 | (37.7418654099413, -122.411262090685) | 10 | 7 | 7 | 28859 | 2 | |||||
| 157045 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||||
| 163139 | 112668 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 129 Henry St | Back Yard : Yard | Tree | Private 2 | 6002668 | 2107340.8 | 37.7665070360696 | -122.434024647923 | (37.7665070360696, -122.434024647923) | 15 | 5 | 5 | 28862 | 3 | ||||||
| 164886 | 100169 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 180X Manchester St | Back Yard : Yard | Tree | DPW 1 | Adjacent to rear of property - DPW parcel | 6008242 | 2099158 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | 2 | 7 | 7 | 28859 | 2 | |||||
| 167578 | 100472 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 70 Stanford Heights Ave | Back Yard : Yard | Tree | Private 2 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.449794826729 | (37.735113616296, -122.449794826729) | 9 | 7 | 4 | 59 | 40 | ||||||
| 168147 | 107817 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X BROTHERHOOD WAY | unknown : Yard | Tree | DPW 1 | 5991892 | 2087849 | 37.7123700531512 | -122.469877266524 | (37.7123700531512, -122.469877266524) | 9 | 8 | 4 | 64 | 24 | ||||||
| 170969 | 104893 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 233 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
| 172539 | 104894 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 235 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
| 176195 | 102381 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 258 Molimo Dr | Back Yard : Yard | Tree | Private 2 | 5997615 | 2096604 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | 9 | 7 | 4 | 59 | 40 | ||||||
| 177029 | 98721 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700X Brotherhood Way | Front Yard : Yard | Tree | DPW 1 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.472357697274 | (37.7129229890255, -122.472357697274) | 1 | 8 | 4 | 64 | 14 | ||||||
| 180499 | 110077 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4099x ALEMANY BLVD | Median : Cutout | Tree | Private 2 | 48 | 5991599 | 2086829 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | 9 | 8 | 4 | 64 | 24 | |||||
| 183946 | 112252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5301x DIAMOND HEIGHTS BLVD | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 22 | ||||
| 191821 | 104940 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 111X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 187732 | 218285 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Junipero Serra Frontage West | 0 | Median : Yard | Tree | DPW 1 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | 1 | 8 | 4 | 64 | 40 | ||||
| 22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
| 34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
| 63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
| 256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
| 430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
| 483 | 173928 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51 Vulcan Stwy | 1 | Front Yard : Cutout | Tree | Private 2 | 6000543 | 2106304 | 37.7635394137592 | -122.441300222472 | (37.7635394137592, -122.441300222472) | 15 | 5 | 5 | 28862 | 3 | |||||
| 628 | 256542 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 133 Olympia Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996852 | 2101844 | 37.7510824274474 | -122.453744067192 | (37.7510824274474, -122.453744067192) | 1 | 5 | 4 | 63 | 38 | ||||
| 689 | 119914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | 100x100 | ||||||||||||||
| 724 | 178311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 10x10 | 5989003 | 2090507 | 37.7195008394357 | -122.480056810171 | (37.7195008394357, -122.480056810171) | 1 | 8 | 4 | 64 | 14 | |||
| 1176 | 119263 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Lakeshore Dr | 1 | Median : Yard | Tree | DPW 1 | 10x30 | ||||||||||||||
| 1428 | 194473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 8ft | 6014996.92919 | 2104399.34696 | 37.7591224196901 | -122.391175112734 | (37.7591224196901, -122.391175112734) | 10 | 3 | 8 | 28856 | 29 | |||
| 1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
| 2059 | 264900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 35X Parkridge Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5999060 | 2101975 | 37.7515684597407 | -122.446118026985 | (37.7515684597407, -122.446118026985) | 2 | 5 | 5 | 63 | 38 | ||||
| 2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
| 2578 | 139478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 416 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2020 12:00:00 AM | 3 | Width 0ft | 5999096.683 | 2111385.8942 | 37.7774105099956 | -122.446668218684 | (37.7774105099956, -122.446668218684) | 15 | 5 | 11 | 29492 | 16 | ||
| 2688 | 253070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 134 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 780451 | 5995517 | 2087474 | 37.7115492645372 | -122.45732113821 | (37.7115492645372, -122.45732113821) | 9 | 8 | 6 | 28861 | 24 | |||
| 2713 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 2812 | 19775 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
| 2894 | 11190 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 140 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995683.1150394 | 2099368.7198886 | 37.7442188444672 | -122.457607088025 | (37.7442188444672, -122.457607088025) | 1 | 8 | 4 | 59 | 40 | |||
| 3000 | 20052 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
| 3326 | 104499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 44X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 18 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
| 3462 | 233333 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 188 States St | 1 | Back Yard : Yard | Tree | Private 2 | 14 | Width 3ft | Permit Number 784841 | 6001049.9199 | 2106366.66768 | 37.763740347549 | -122.43955144426 | (37.763740347549, -122.43955144426) | 15 | 5 | 5 | 28862 | 3 | ||
| 4239 | 258982 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 239 Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997275 | 2101153 | 37.7492093542443 | -122.452231443092 | (37.7492093542443, -122.452231443092) | 1 | 5 | 4 | 63 | 38 | ||||
| 4854 | 117978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5984094.13719 | 2112920.10602 | 37.7807546046446 | -122.498679507303 | (37.7807546046446, -122.498679507303) | 11 | 6 | 2 | 55 | 26 | |||
| 4884 | 260462 | Private 9 | Pinus radiata :: Monterey Pine 15 | 119 Moffitt St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002736 | 2096650 | 37.7371564911538 | -122.433025558613 | (37.7371564911538, -122.433025558613) | 2 | 7 | 5 | 63 | 7 | ||||
| 4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
| 4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
| 5134 | 13416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 442 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999568.3476194 | 2097073.0677048 | 37.7381379481581 | -122.444007926391 | (37.7381379481581, -122.444007926391) | 9 | 7 | 4 | 59 | 40 | |||
| 5216 | 20045 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY52 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 5279 | 258778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 701X Ortega Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5991876 | 2102480 | 37.7525421857889 | -122.470997752755 | (37.7525421857889, -122.470997752755) | 1 | 8 | 4 | 29491 | 12 | ||||
| 5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
| 6239 | 261665 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 401X Greenwich St | 1 | Unaccepted Street : Cutout | Tree | DPW 1 | |||||||||||||||
| 6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
| 6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
| 6585 | 260539 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997905 | 2100119 | 37.7464063138276 | -122.449978390477 | (37.7464063138276, -122.449978390477) | 2 | 5 | 4 | 63 | 38 | ||||
| 6606 | 178232 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | Width 10ft | 6007195.0497 | 2087434.83618 | 37.712105551909 | -122.41695583486 | (37.712105551909, -122.41695583486) | 9 | 7 | 8 | 309 | 39 | |||
| 6919 | 178219 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 49 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | Width 6ft | 6006726.5178 | 2087416.33462 | 37.7120283837799 | -122.418573909455 | (37.7120283837799, -122.418573909455) | 9 | 7 | 8 | 309 | 39 | |||
| 6943 | 262154 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 519 22nd Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989039 | 2111772 | 37.7778909946523 | -122.481488924787 | (37.7778909946523, -122.481488924787) | 11 | 6 | 2 | 55 | 26 | ||||
| 7026 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150 Raccoon Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 36 | 3x3 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | |||
| 7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
| 7196 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 60R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999394 | 2100048 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | 2 | 7 | 5 | 63 | 22 | |||||
| 8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
| 8237 | 260684 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
| 8370 | 264916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 744 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991301 | 2092678 | 37.7255951208098 | -122.472271716 | (37.7255951208098, -122.472271716) | 9 | 8 | 4 | 64 | 40 | ||||
| 8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
| 8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 9602 | 98360 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | 5 | 1 | 1 | 28858 | 32 | ||||
| 10108 | 94859 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53932 | ||||||||||||||
| 10407 | 260077 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 167X Burlwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5997137 | 2096182 | 37.7355522955825 | -122.452349987086 | (37.7355522955825, -122.452349987086) | 9 | 7 | 4 | 59 | 40 | ||||
| 11046 | 262155 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013141 | 2101984 | 37.752387232625 | -122.397424456513 | (37.752387232625, -122.397424456513) | 10 | 3 | 8 | 28856 | 29 | ||||
| 11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
| 11775 | 173632 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3300X Market St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
| 11825 | 264757 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 176 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 |
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) );