trees
1,977 rows where qSpecies_id = 41 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191057 | 100769 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 3701 21st St | Front Yard : Yard | Tree | Private 2 | 55 | Street tree w/in RoW | 6003717 | 2103606 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | 2 | 4 | 5 | 28862 | 22 | ||||
| 112172 | 101037 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1010X Portola Dr | 11 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
| 160937 | 102060 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 115 Kensington Way | 1 | Back Yard : Yard | Tree | Private 2 | 5994908.3 | 2098325.8 | 37.7413107073974 | -122.460210667073 | (37.7413107073974, -122.460210667073) | 1 | 8 | 4 | 59 | 40 | |||||
| 7781 | 102468 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998217.7 | 2104179.8 | 37.7575741573713 | -122.449189617767 | (37.7575741573713, -122.449189617767) | 15 | 5 | 4 | 28862 | 38 | |||||
| 85648 | 102573 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Park St | 1 | Median : Yard | Tree | DPW 1 | 24 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | ||||
| 177432 | 102706 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1342 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | 1 | 8 | 11 | 56 | 12 | |||||
| 44661 | 102745 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Moncada Way | 1 | Front Yard : Yard | Tree | Private 2 | 5992354 | 2093377.4 | 37.7275763858966 | -122.468682482409 | (37.7275763858966, -122.468682482409) | 9 | 8 | 4 | 59 | 40 | |||||
| 153798 | 103351 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 15X Highland Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 18 | 6004989.3 | 2096795.8 | 37.7376843808497 | -122.42524524109 | (37.7376843808497, -122.42524524109) | 2 | 7 | 5 | 28859 | 7 | ||||
| 164851 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1365 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | ||||
| 46823 | 103516 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 1 | Back Yard : Yard | Tree | Private 2 | 6008298 | 2118971 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | 5 | 1 | 10 | 308 | 32 | |||||
| 22976 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Hermann St | 1 | Front Yard : Yard | Tree | Private 2 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | |||||
| 156459 | 103648 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 500X Oak Park Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 3x10 | 5994983.3 | 2103652.8 | 37.7559416221353 | -122.460337221652 | (37.7559416221353, -122.460337221652) | 1 | 5 | 4 | 63 | 12 | |||
| 171255 | 104398 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3525X Ulloa St | 1 | Median : Yard | Tree | DPW 1 | 48 | 5985120.16683 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | 1 | 8 | 3 | 29491 | 35 | ||||
| 137861 | 104399 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2440X 37th Ave | 1 | Median : Yard | Tree | DPW 1 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.494914605615 | (37.7412666886784, -122.494914605615) | 1 | 8 | 3 | 29491 | 35 | |||||
| 147435 | 104466 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 1 | Median : Yard | Tree | DPW 1 | 50 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | ||||
| 83696 | 104500 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 22 SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 45 | 6000539 | 2106092 | 37.7629570862814 | -122.441298844913 | (37.7629570862814, -122.441298844913) | 15 | 5 | 5 | 28862 | 3 | ||||
| 188942 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 146 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 32908 | 104998 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 286X CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4x18 | 5993881 | 2100258 | 37.746556897942 | -122.463902900317 | (37.746556897942, -122.463902900317) | 1 | 8 | 4 | 29491 | 40 | |||
| 116904 | 105236 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 235X STATES ST | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | ||||
| 106429 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | 2 | 4 | 5 | 28862 | 3 | ||||
| 98635 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | 1 | 8 | 4 | 64 | 14 | |||||
| 164086 | 105764 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X GONZALEZ DR | 1 | Front Yard : Yard | Tree | Private 2 | 5990111.8 | 2090190.8 | 37.7186969947407 | -122.476201051717 | (37.7186969947407, -122.476201051717) | 1 | 8 | 4 | 64 | 14 | |||||
| 193891 | 105837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100X SLOAT BLVD | 4 | Median : Yard | Tree | DPW 1 | 7 | 5984309 | 2095832 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | 1 | 8 | 3 | 64 | 35 | ||||
| 156684 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | 1 | 8 | 4 | 29491 | 40 | |||
| 125129 | 105889 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 2150X 09TH AVE | 11 | Median : Cutout | Tree | Private 2 | 03/21/2014 12:00:00 AM | 40 | 5993666 | 2101247 | 37.7492600480712 | -122.464718147401 | (37.7492600480712, -122.464718147401) | 1 | 8 | 4 | 29491 | 40 | |||
| 10140 | 106278 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 2 | Median : Cutout | Tree | DPW 1 | 60 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | ||||
| 120316 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 URBANO DR | 1 | Front Yard : Yard | Tree | Private 2 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | 9 | 8 | 4 | 59 | 40 | ||||
| 16989 | 106642 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5999139 | 2105833 | 37.7621660862312 | -122.446122313424 | (37.7621660862312, -122.446122313424) | 15 | 5 | 5 | 29492 | 3 | ||||
| 191814 | 106757 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 36 | 6013321.20233 | 2089752.82506 | 37.7188129925151 | -122.395944254446 | (37.7188129925151, -122.395944254446) | 10 | 3 | 8 | 58 | 1 | |||
| 163267 | 106929 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 340 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 10x8 | 6007766.2 | 2105923.3 | 37.7629029238803 | -122.41629043085 | (37.7629029238803, -122.41629043085) | 8 | 4 | 7 | 28859 | 19 | |||
| 112679 | 106961 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 325 DWIGHT ST | Sidewalk: Curb side : Yard | Tree | Private 2 | 6010604 | 2091349 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | 10 | 3 | 7 | 309 | 28 | ||||||
| 137083 | 106962 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 218 SADOWA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 5994814 | 2087793.9 | 37.7123872323548 | -122.459774032106 | (37.7123872323548, -122.459774032106) | 9 | 8 | 6 | 28861 | 24 | ||||
| 167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
| 72298 | 108074 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 BUENA VISTA AVE EAST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001336 | 2108482 | 37.7695648051764 | -122.438713569331 | (37.7695648051764, -122.438713569331) | 15 | 5 | 5 | 29492 | 9 | ||||
| 172319 | 108359 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 5290 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | |||
| 165028 | 108360 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 5290 DIAMOND HEIGHTS BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | |||
| 174313 | 108958 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1400 22ND AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5989329.4 | 2105769.6 | 37.7614269305246 | -122.480044953075 | (37.7614269305246, -122.480044953075) | 1 | 8 | 3 | 56 | 35 | ||||
| 180052 | 109251 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 53X DEDMAN CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6016647 | 2096311 | 37.7370049195852 | -122.384904830601 | (37.7370049195852, -122.384904830601) | 10 | 3 | 8 | 58 | 1 | ||||
| 82162 | 109453 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 951 GILMAN AVE | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||
| 120937 | 109516 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 105 MIDCREST WAY | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.7488762246558 | -122.4490904711 | (37.7488762246558, -122.4490904711) | 1 | 5 | 4 | 63 | 38 | ||||
| 107479 | 109648 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 1 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 123780 | 109649 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 2 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 142400 | 109650 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 21 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 174778 | 109652 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 23 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 100770 | 109653 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 6 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 84888 | 109654 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 25 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 85555 | 109655 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 26 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 95002 | 109656 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 8 | Median : Cutout | Tree | DPW 1 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||
| 141356 | 109657 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 28 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 55368 | 109658 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 29 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 134843 | 109659 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 30 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 177803 | 109674 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 3 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 131599 | 109675 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 4 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 49941 | 109676 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 5 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 182163 | 109677 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 6 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 42627 | 109678 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 7 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
| 181999 | 109893 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1408x SUNSET BLVD | 3 | Median : Cutout | Tree | DPW 1 | 40 | 3x3 | 5984818 | 2105324 | 37.7599402834086 | -122.49561490918 | (37.7599402834086, -122.49561490918) | 1 | 8 | 3 | 56 | 35 | |||
| 165411 | 110120 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 507X JOOST AVE | 2 | Back Yard : Cutout | Tree | Private 2 | 45 | 3x3 | 5998608 | 2094933 | 37.7322070010706 | -122.447174340818 | (37.7322070010706, -122.447174340818) | 9 | 7 | 4 | 59 | 40 | |||
| 119943 | 110264 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 220x CASHMERE ST | 1 | Median : Cutout | Tree | DPW 1 | 5x40 | 6015982.5 | 2095938 | 37.7359439605228 | -122.387176315997 | (37.7359439605228, -122.387176315997) | 10 | 3 | 8 | 58 | 1 | ||||
| 119116 | 110277 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 50 HILIRITAS AVE | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6001414 | 2096889 | 37.7377376534528 | -122.437613416201 | (37.7377376534528, -122.437613416201) | 2 | 7 | 5 | 63 | 7 | ||||
| 56224 | 110865 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 838 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 6x9 | 5985433.60853 | 2110167.44818 | 37.7732750611072 | -122.493842782867 | (37.7732750611072, -122.493842782867) | 11 | 6 | 2 | 55 | 26 | |||
| 23219 | 110906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2891 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999784.05969 | 2117390.40958 | 37.7939365889551 | -122.444722064898 | (37.7939365889551, -122.444722064898) | 13 | 9 | 1 | 57 | 27 | |
| 171327 | 111287 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 450 ROLPH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002226 | 2087613 | 37.7123139824471 | -122.434143019741 | (37.7123139824471, -122.434143019741) | 9 | 7 | 6 | 28861 | 5 | |||
| 28931 | 111586 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | ||||
| 175257 | 111587 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | ||||
| 88826 | 111588 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
| 72776 | 111589 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | Permit Number 774260 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
| 27160 | 111763 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | 13 | 9 | 1 | 57 | 27 | |||||
| 181265 | 11185 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.7441047056077 | -122.45685222203 | (37.7441047056077, -122.45685222203) | 1 | 8 | 4 | 59 | 40 | |||
| 29915 | 11191 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 148 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | 1 | 8 | 4 | 59 | 40 | |||
| 21695 | 112187 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 301x CORBETT AVE | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | ||||
| 47216 | 112606 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Monument Way | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5999003 | 2105766 | 37.7619743535119 | -122.446587863076 | (37.7619743535119, -122.446587863076) | 15 | 5 | 5 | 29492 | 9 | ||||
| 42938 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
| 32139 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
| 30966 | 112739 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 444 Franconia St | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||||
| 129825 | 113062 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 3 | : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 161019 | 113063 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 4 | : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 162401 | 113064 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 3666 | 113065 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 98930 | 113091 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 398X ARBOR ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000747 | 2096921 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | 2 | 7 | 5 | 63 | 7 | ||||
| 118088 | 113092 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 598x ARBOR ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000747 | 2096921 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | 2 | 7 | 5 | 63 | 7 | ||||
| 6686 | 113093 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 598x ARBOR ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000747 | 2096921 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | 2 | 7 | 5 | 63 | 7 | ||||
| 135134 | 113440 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 BEACON ST | Back Yard : Yard | Tree | Private 2 | 32 | 3x3 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | ||||
| 2644 | 113698 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80 LINARES AVE | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 5994154.8 | 2102090.7 | 37.7516048020548 | -122.463089089164 | (37.7516048020548, -122.463089089164) | 1 | 8 | 4 | 29491 | 40 | |||||
| 24527 | 114055 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 50 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 115648 | 114056 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 2 | Median : Cutout | Tree | Private 2 | 61 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 190973 | 114057 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 3 | Median : Cutout | Tree | Private 2 | 46 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 156082 | 114058 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 4 | Median : Cutout | Tree | Private 2 | 58 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 185113 | 114059 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 5 | Median : Cutout | Tree | Private 2 | 38 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 110149 | 114060 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 6 | Median : Cutout | Tree | Private 2 | 60 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 42366 | 114061 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 7 | Median : Cutout | Tree | Private 2 | 52 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 103755 | 114066 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 600x LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 36 | 5987697 | 2093816 | 37.7285105386339 | -122.484813735407 | (37.7285105386339, -122.484813735407) | 1 | 8 | 4 | 64 | 14 | ||||
| 53564 | 114125 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 139497 | 114126 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 105357 | 114127 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 30007 | 114128 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 158608 | 114129 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 |
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) );