trees
390 rows where qSpecies_id = 126 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4125 | 217527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | 9 | 8 | 6 | 28861 | 24 | |||
| 6788 | 89559 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5227 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982413.61439 | 2111658.5087 | 37.7771919254702 | -122.504399660112 | (37.7771919254702, -122.504399660112) | 11 | 6 | 2 | 55 | 26 | ||
| 21874 | 91012 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4301X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982213.29166 | 2110288.86252 | 37.7734194931658 | -122.504991105508 | (37.7734194931658, -122.504991105508) | 11 | 6 | 2 | 55 | 26 | ||
| 22048 | 217531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 38 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996362.99834 | 2088995.98421 | 37.7157768335986 | -122.454507038583 | (37.7157768335986, -122.454507038583) | 9 | 8 | 6 | 28861 | 24 | |||
| 26204 | 84910 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | 11 | 6 | 2 | 55 | 26 | ||
| 28259 | 90722 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4650X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981131.94143 | 2110306.49344 | 37.7734042232339 | -122.508732892327 | (37.7734042232339, -122.508732892327) | 11 | 6 | 2 | 55 | 26 | ||
| 34780 | 90721 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4650X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981150.16516 | 2110306.92668 | 37.7734064869384 | -122.508669887159 | (37.7734064869384, -122.508669887159) | 11 | 6 | 2 | 55 | 26 | ||
| 51997 | 89512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4700X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984063.36258 | 2111770.60585 | 37.7775966059221 | -122.498701028226 | (37.7775966059221, -122.498701028226) | 11 | 6 | 2 | 55 | 26 | ||
| 53732 | 199599 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1510x 22nd St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 6013497.50922 | 2103827.38808 | 37.7574686213053 | -122.396320770893 | (37.7574686213053, -122.396320770893) | 10 | 3 | 8 | 28856 | 29 | |||
| 54833 | 90695 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982874.37736 | 2110367.17949 | 37.7736734008467 | -122.50271015187 | (37.7736734008467, -122.50271015187) | 11 | 6 | 2 | 55 | 26 | ||
| 58467 | 90738 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4451X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981732.83736 | 2110270.97597 | 37.7733421032725 | -122.506651709597 | (37.7733421032725, -122.506651709597) | 11 | 6 | 2 | 55 | 26 | ||
| 59782 | 89524 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4840X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983565.28879 | 2111753.60264 | 37.7775206958325 | -122.500422748292 | (37.7775206958325, -122.500422748292) | 11 | 6 | 2 | 55 | 26 | ||
| 59861 | 199522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6015555.37035 | 2103675.62885 | 37.7571662188511 | -122.389193205711 | (37.7571662188511, -122.389193205711) | 10 | 3 | 8 | 28856 | 29 | |||
| 74346 | 90730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4575X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981423.24219 | 2110260.00092 | 37.773293734399 | -122.507721808797 | (37.773293734399, -122.507721808797) | 11 | 6 | 2 | 55 | 26 | ||
| 77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
| 82713 | 26914 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.450354374056 | (37.7175236335794, -122.450354374056) | 9 | 8 | 6 | 28861 | 24 | |||
| 83700 | 91015 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4001X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5983165.84214 | 2110322.79584 | 37.7735686603483 | -122.501698662328 | (37.7735686603483, -122.501698662328) | 11 | 6 | 2 | 55 | 26 | ||
| 86416 | 199615 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 56 | Median : Yard | Tree | DPW 1 | 20 | 6014226.56708 | 2095397.27479 | 37.7343618444247 | -122.393209497917 | (37.7343618444247, -122.393209497917) | 10 | 3 | 8 | 58 | 1 | ||||
| 86485 | 108262 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6012679.64923 | 2090646.14976 | 37.7212301687063 | -122.398224504378 | (37.7212301687063, -122.398224504378) | 10 | 3 | 8 | 58 | 1 | ||||
| 88119 | 90745 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4345 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982053.54954 | 2110284.79915 | 37.7733989368092 | -122.505543365519 | (37.7733989368092, -122.505543365519) | 11 | 6 | 2 | 55 | 26 | ||
| 88169 | 90729 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4601X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981296.19925 | 2110254.1964 | 37.7732703114755 | -122.508160828969 | (37.7732703114755, -122.508160828969) | 11 | 6 | 2 | 55 | 26 | ||
| 96330 | 90693 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4046 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982986.41354 | 2110371.00337 | 37.7736904834902 | -122.50232289085 | (37.7736904834902, -122.50232289085) | 11 | 6 | 2 | 55 | 26 | ||
| 100487 | 199576 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6012291.12869 | 2102166.26661 | 37.7528403413075 | -122.40037626996 | (37.7528403413075, -122.40037626996) | 10 | 3 | 8 | 28856 | 29 | |||
| 107054 | 90702 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982693.08278 | 2110362.14824 | 37.7736489307149 | -122.503336894741 | (37.7736489307149, -122.503336894741) | 11 | 6 | 2 | 55 | 26 | ||
| 107922 | 217528 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 23 | Median : Cutout | Tree | DPW 1 | 21 | Width 0ft | 5996239.67179 | 2089002.51742 | 37.7157876983267 | -122.454933781265 | (37.7157876983267, -122.454933781265) | 9 | 8 | 6 | 28861 | 24 | |||
| 108225 | 199577 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 3 | Median : Yard | Tree | DPW 1 | 15 | 6012278.40127 | 2102219.77174 | 37.7529865450046 | -122.400424041944 | (37.7529865450046, -122.400424041944) | 10 | 3 | 8 | 28856 | 29 | ||||
| 114250 | 91013 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4243 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982353.14616 | 2110293.57319 | 37.773440654471 | -122.504507686123 | (37.773440654471, -122.504507686123) | 11 | 6 | 2 | 55 | 26 | ||
| 114317 | 217530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 28 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996285.62534 | 2089001.27472 | 37.7157869222129 | -122.454774855787 | (37.7157869222129, -122.454774855787) | 9 | 8 | 6 | 28861 | 24 | |||
| 117235 | 90718 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4606 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981306.68716 | 2110312.4984 | 37.7734310096789 | -122.508128878588 | (37.7734310096789, -122.508128878588) | 11 | 6 | 2 | 55 | 26 | ||
| 121007 | 250140 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2550x Lyon St | 8 | Median : Yard | Tree | DPW 1 | 15 | 5999207.82154 | 2117620.05733 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | 13 | 1 | 57 | 30 | |||||
| 128836 | 90737 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4501X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981620.20205 | 2110267.22621 | 37.773325174636 | -122.507041045742 | (37.773325174636, -122.507041045742) | 11 | 6 | 2 | 55 | 26 | ||
| 132160 | 90703 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982542.19786 | 2110357.81222 | 37.7736281543023 | -122.503858498829 | (37.7736281543023, -122.503858498829) | 11 | 6 | 2 | 55 | 26 | ||
| 134587 | 8465 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1900 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6002373.3675 | 2113709.4137 | 37.7839769368091 | -122.435499366282 | (37.7839769368091, -122.435499366282) | 13 | 5 | 11 | 29490 | 41 | |||
| 140704 | 29538 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015154.8066584 | 2091194.1931941 | 37.7228725479476 | -122.389706778167 | (37.7228725479476, -122.389706778167) | 10 | 3 | 8 | 58 | 1 | |||
| 142592 | 199574 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 33 | Median : Yard | Tree | DPW 1 | 35 | 6012273.26957 | 2101981.44078 | 37.7523318538423 | -122.400425049202 | (37.7523318538423, -122.400425049202) | 10 | 3 | 8 | 28856 | 29 | ||||
| 143113 | 90744 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4401 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981925.61643 | 2110279.1737 | 37.7733759612739 | -122.505985479448 | (37.7733759612739, -122.505985479448) | 11 | 6 | 2 | 55 | 26 | ||
| 148793 | 90739 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4451X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981746.10841 | 2110271.13179 | 37.7733433125324 | -122.50660581555 | (37.7733433125324, -122.50660581555) | 11 | 6 | 2 | 55 | 26 | ||
| 156190 | 90736 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4501X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981602.49176 | 2110266.28486 | 37.77332154692 | -122.507102237161 | (37.77332154692, -122.507102237161) | 11 | 6 | 2 | 55 | 26 | ||
| 163229 | 91014 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4139 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982669.85077 | 2110306.16826 | 37.7734938602238 | -122.503413110518 | (37.7734938602238, -122.503413110518) | 11 | 6 | 2 | 55 | 26 | ||
| 174323 | 199523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | 10 | 3 | 8 | 28856 | 29 | |||
| 174734 | 90710 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981744.51954 | 2110327.15127 | 37.773497032089 | -122.50661546708 | (37.773497032089, -122.50661546708) | 11 | 6 | 2 | 55 | 26 | ||
| 175215 | 217529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 24 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 5996247.03619 | 2089001.79824 | 37.7157861460877 | -122.454908274716 | (37.7157861460877, -122.454908274716) | 9 | 8 | 6 | 28861 | 24 | |||
| 181486 | 90686 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4000X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983182.62546 | 2110378.74421 | 37.7737232641716 | -122.501644747223 | (37.7737232641716, -122.501644747223) | 11 | 6 | 2 | 55 | 26 | ||
| 185320 | 90711 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4500 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981635.19797 | 2110323.94692 | 37.773481796264 | -122.506993382003 | (37.773481796264, -122.506993382003) | 11 | 6 | 2 | 55 | 26 | ||
| 186393 | 90712 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4508 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981619.82432 | 2110323.60403 | 37.7734799493833 | -122.507046535321 | (37.7734799493833, -122.507046535321) | 11 | 6 | 2 | 55 | 26 | ||
| 188312 | 90717 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981323.93536 | 2110313.64162 | 37.7734351649753 | -122.508069300521 | (37.7734351649753, -122.508069300521) | 11 | 6 | 2 | 55 | 26 | ||
| 193806 | 199575 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 25 | Median : Yard | Tree | DPW 1 | 27 | 6012270.74731 | 2102100.89416 | 37.7526597061983 | -122.400442161487 | (37.7526597061983, -122.400442161487) | 10 | 3 | 8 | 28856 | 29 | ||||
| 638 | 217502 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 426 Hearst Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 5998544.81231 | 2094412.25403 | 37.7307735449502 | -122.447355326608 | (37.7307735449502, -122.447355326608) | 9 | 7 | 4 | 59 | 40 | |||
| 1584 | 79997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981344.9471 | 2112403.21249 | 37.7791737487824 | -122.508151741605 | (37.7791737487824, -122.508151741605) | 11 | 6 | 2 | 55 | 26 | |||
| 3048 | 199537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 16 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.98726 | 2106464.8847 | 37.7647565688948 | -122.393647053167 | (37.7647565688948, -122.393647053167) | 14 | 3 | 8 | 310 | 29 | ||||
| 3638 | 72610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.394048777632 | (37.7523970151345, -122.394048777632) | 10 | 3 | 8 | 28856 | 1 | |||
| 3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
| 5110 | 79998 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.508139904514 | (37.7791033052806, -122.508139904514) | 11 | 6 | 2 | 55 | 26 | |||
| 5902 | 98813 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6011920.40954 | 2099763.49202 | 37.7462221629395 | -122.401489439087 | (37.7462221629395, -122.401489439087) | 10 | 3 | 8 | 58 | 1 | |||
| 6509 | 217512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998882.8177 | 2093813.39274 | 37.7291485212785 | -122.446143732968 | (37.7291485212785, -122.446143732968) | 9 | 7 | 4 | 28861 | 40 | ||||
| 6916 | 217513 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998878.5265 | 2093813.54586 | 37.7291486966488 | -122.446158578953 | (37.7291486966488, -122.446158578953) | 9 | 7 | 4 | 28861 | 40 | ||||
| 6982 | 72625 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014103.8148 | 2101960.56144 | 37.7523764359486 | -122.394093219441 | (37.7523764359486, -122.394093219441) | 10 | 3 | 8 | 28856 | 1 | |||
| 7251 | 78261 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 50 | 6009735.35322 | 2092462.55281 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | 10 | 3 | 7 | 309 | 28 | |||
| 7873 | 74275 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010944.70013 | 2088154.7138 | 37.714292400951 | -122.404046514754 | (37.714292400951, -122.404046514754) | 9 | 7 | 8 | 309 | 39 | |||
| 8279 | 199563 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012717.44536 | 2104654.08234 | 37.7596951043532 | -122.399076586828 | (37.7596951043532, -122.399076586828) | 10 | 3 | 8 | 28856 | 29 | |||
| 8435 | 199530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1091 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.392989678445 | (37.7614686151109, -122.392989678445) | 10 | 3 | 8 | 28856 | 29 | ||||
| 8542 | 73713 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 27 | 6012277.51673 | 2102506.08306 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | 10 | 3 | 8 | 28856 | 29 | |||
| 9401 | 244003 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Douglass St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 4ft | 6001394.33325 | 2099880.52449 | 37.7459505586756 | -122.437895622392 | (37.7459505586756, -122.437895622392) | 2 | 4 | 5 | 63 | 22 | |||
| 9749 | 73730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6014041.4845 | 2095157.58141 | 37.7336934116182 | -122.393832621075 | (37.7336934116182, -122.393832621075) | 10 | 3 | 8 | 58 | 1 | |||
| 9874 | 199550 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 6 | : Yard | Tree | Private 2 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | 14 | 3 | 8 | 28856 | 29 | ||||
| 10920 | 32743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.19889 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) | 9 | 8 | 6 | 28861 | 24 |
| 10986 | 199613 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1650 Davidson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6014432.23191 | 2099824.22542 | 37.7465287570926 | -122.392808046859 | (37.7465287570926, -122.392808046859) | 10 | 3 | 8 | 58 | 1 | |||
| 12016 | 38374 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3805 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40433 | 5982188.1991 | 2102815.1083 | 37.7528972278417 | -122.504524079724 | (37.7528972278417, -122.504524079724) | 1 | 8 | 3 | 56 | 35 | |
| 12929 | 79999 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | 11 | 6 | 2 | 55 | 26 | |||
| 13716 | 243963 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3450 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | 2 | 4 | 7 | 28859 | 19 | |||
| 13934 | 199608 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6016247.68812 | 2100671.01808 | 37.7489545425207 | -122.386589376117 | (37.7489545425207, -122.386589376117) | 10 | 3 | 8 | 58 | 1 | |||
| 16924 | 199525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Minnesota St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015396.88376 | 2102219.87285 | 37.7531602346611 | -122.389639647178 | (37.7531602346611, -122.389639647178) | 10 | 3 | 8 | 28856 | 29 | ||||
| 17148 | 181306 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 469 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010294.74093 | 2089615.03342 | 37.7182658036088 | -122.406395873996 | (37.7182658036088, -122.406395873996) | 10 | 7 | 8 | 309 | 39 | |||
| 17458 | 199543 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 38 | Front Yard : Yard | Tree | Private 2 | 5 | 6014244.47574 | 2106692.17431 | 37.7653762377352 | -122.393937976682 | (37.7653762377352, -122.393937976682) | 14 | 3 | 8 | 28856 | 20 | ||||
| 17619 | 61510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.400465342406 | (37.754033879279, -122.400465342406) | 10 | 3 | 8 | 28856 | 29 | |
| 17695 | 61786 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1453 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 5 | Permit Number 21808 | 6012048.53726 | 2101599.7362 | 37.7512712410927 | -122.401175394927 | (37.7512712410927, -122.401175394927) | 10 | 3 | 8 | 28856 | 29 | |
| 17741 | 74618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | 11 | 6 | 2 | 54 | 11 | |||
| 17920 | 217539 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994385.93266 | 2101818.26452 | 37.7508700750964 | -122.462270052135 | (37.7508700750964, -122.462270052135) | 1 | 8 | 4 | 29491 | 40 | |||
| 18510 | 217540 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994380.23294 | 2101825.97168 | 37.7508909088044 | -122.462290321068 | (37.7508909088044, -122.462290321068) | 1 | 8 | 4 | 29491 | 40 | |||
| 18569 | 74063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010946.7362 | 2088147.19919 | 37.7142718811123 | -122.404038948741 | (37.7142718811123, -122.404038948741) | 9 | 7 | 8 | 309 | 39 | |||
| 19542 | 185509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2211 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983864.8947 | 2100088.8725 | 37.7455102176181 | -122.498524482427 | (37.7455102176181, -122.498524482427) | 1 | 8 | 3 | 29491 | 35 | |||
| 19956 | 117834 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 822 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5983882.02948 | 2110196.57614 | 37.7732641381745 | -122.499211973818 | (37.7732641381745, -122.499211973818) | 11 | 6 | 2 | 55 | 26 | |||
| 19978 | 181294 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 286 Foote Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5998287.94469 | 2088745.65468 | 37.7151996999876 | -122.447835553775 | (37.7151996999876, -122.447835553775) | 9 | 7 | 6 | 28861 | 25 | |||
| 20757 | 119005 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 43rd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5982538.33316 | 2111759.97199 | 37.7774778486886 | -122.503975742455 | (37.7774778486886, -122.503975742455) | 11 | 6 | 2 | 55 | 26 | |||
| 22624 | 120087 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 401 26th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5987764.76806 | 2113165.69787 | 37.7816435236065 | -122.485999212153 | (37.7816435236065, -122.485999212153) | 11 | 6 | 2 | 55 | 26 | |||
| 22872 | 199568 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 680 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012064.94705 | 2105270.66031 | 37.7613517077453 | -122.401376599377 | (37.7613517077453, -122.401376599377) | 10 | 3 | 8 | 28856 | 29 | ||||
| 22901 | 119970 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 542 28th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 20 | Width 3ft | 5987221.67588 | 2112220.77085 | 37.7790173579212 | -122.487808583512 | (37.7790173579212, -122.487808583512) | 11 | 6 | 2 | 55 | 26 | |||
| 22966 | 217506 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 427 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 5997927.13531 | 2094070.23257 | 37.7297991196196 | -122.449466089413 | (37.7297991196196, -122.449466089413) | 9 | 7 | 4 | 28861 | 40 | ||||
| 23566 | 243983 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 23 Juri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 1ft | 6005990.8298 | 2101226.6861 | 37.749907121539 | -122.422097155577 | (37.749907121539, -122.422097155577) | 2 | 4 | 5 | 28859 | 19 | |||
| 24332 | 45455 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.7808170441833 | -122.453879118533 | (37.7808170441833, -122.453879118533) | 11 | 6 | 2 | 54 | 16 | |||
| 24377 | 217507 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 419 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5997977.15972 | 2094069.19041 | 37.7297991196211 | -122.449293075119 | (37.7297991196211, -122.449293075119) | 9 | 7 | 4 | 28861 | 40 | |||
| 24638 | 199569 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1236 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012213.10584 | 2102625.8594 | 37.7540979317002 | -122.400678372936 | (37.7540979317002, -122.400678372936) | 10 | 3 | 8 | 28856 | 29 | |||
| 24752 | 199526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014906.74898 | 2105806.13827 | 37.7629801596351 | -122.391585356499 | (37.7629801596351, -122.391585356499) | 14 | 3 | 8 | 28856 | 29 | |||
| 25333 | 199595 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012041.40362 | 2101659.26991 | 37.7514343097479 | -122.401204246987 | (37.7514343097479, -122.401204246987) | 10 | 3 | 8 | 28856 | 29 | ||||
| 25390 | 246783 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 175 Brewster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010050.00115 | 2098693.85293 | 37.7431806261 | -122.407881696082 | (37.7431806261, -122.407881696082) | 10 | 7 | 7 | 28859 | 2 | ||||
| 25689 | 117694 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 400 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5982857.55848 | 2113059.74766 | 37.7810654184436 | -122.502967701532 | (37.7810654184436, -122.502967701532) | 11 | 6 | 2 | 55 | 26 | |||
| 25867 | 217494 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1834 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993466.4471 | 2102963.36193 | 37.7539612311319 | -122.465532871667 | (37.7539612311319, -122.465532871667) | 1 | 8 | 4 | 56 | 12 | |||
| 25876 | 217510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 212 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998646.23648 | 2093807.30599 | 37.7291182950515 | -122.446961172636 | (37.7291182950515, -122.446961172636) | 9 | 7 | 4 | 28861 | 40 | |||
| 26871 | 199533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6014329.6983 | 2106362.34828 | 37.7644753436933 | -122.393620122984 | (37.7644753436933, -122.393620122984) | 14 | 3 | 8 | 310 | 29 | ||||
| 27493 | 98814 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | 10 | 3 | 8 | 58 | 1 |
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) );