trees
191 rows where Fire Prevention Districts = 2 and qSpecies_id = 160 sorted by qLegalStatus_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2957 | 25027 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
| 4408 | 234354 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6004979.81363 | 2104508.34972 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | 2 | 4 | 5 | 28862 | 3 | ||||
| 5116 | 25071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005127.37654 | 2101840.69033 | 37.7515442968352 | -122.42512670443 | (37.7515442968352, -122.42512670443) | 2 | 4 | 5 | 28862 | 22 | |||
| 6713 | 25016 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 7075 | 25030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
| 8561 | 25119 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959639 | (37.7448725899054, -122.42449959639) | 2 | 7 | 5 | 63 | 22 | |||
| 9423 | 25058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594342 | -122.425291287561 | (37.753237594342, -122.425291287561) | 2 | 4 | 5 | 28862 | 22 | |||
| 9943 | 25035 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 14183 | 234399 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 319 Virginia Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 6006918.01461 | 2098154.19018 | 37.7415229912067 | -122.418673038125 | (37.7415229912067, -122.418673038125) | 2 | 7 | 7 | 28859 | 2 | |||
| 15633 | 25139 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.7417043484808 | -122.424181770586 | (37.7417043484808, -122.424181770586) | 2 | 7 | 5 | 63 | 7 | |||
| 16574 | 25108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005223.67149 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | 2 | 7 | 5 | 63 | 22 | |||
| 18928 | 25136 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.7419479631307 | -122.424208394127 | (37.7419479631307, -122.424208394127) | 2 | 7 | 5 | 63 | 7 | |||
| 18950 | 25113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | 2 | 7 | 5 | 63 | 22 | |||
| 19829 | 23674 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 319 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 21370 | 25043 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 21739 | 25033 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004995.41159 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | 2 | 4 | 5 | 28862 | 3 | |||
| 22076 | 234356 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 22 | 6004985.93046 | 2104422.99085 | 37.7586266989802 | -122.425799629353 | (37.7586266989802, -122.425799629353) | 2 | 4 | 5 | 28862 | 3 | ||||
| 22504 | 96822 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 23966 | 25090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | 2 | 4 | 5 | 28859 | 22 | |||
| 25582 | 25084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.424951961675 | (37.7497200220711, -122.424951961675) | 2 | 4 | 5 | 28859 | 22 | |||
| 26765 | 234393 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561 | (37.7442097715744, -122.42885628561) | 2 | 7 | 5 | 63 | 22 | |||
| 27682 | 27481 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | 2 | 4 | 5 | 28862 | 22 | ||
| 28540 | 25054 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.425381222462 | (37.7542196827988, -122.425381222462) | 2 | 4 | 5 | 28862 | 22 | |||
| 28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
| 28783 | 234372 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.7487174209867 | -122.424406263843 | (37.7487174209867, -122.424406263843) | 2 | 4 | 5 | 28859 | 19 | |||
| 29806 | 234362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | 2 | 4 | 5 | 28862 | 22 | ||||
| 30456 | 96824 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 32583 | 25100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6005208.52852 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | 2 | 7 | 5 | 63 | 22 | |||
| 33204 | 234387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005043.99676 | 2102621.60144 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | 2 | 4 | 5 | 28862 | 22 | |||
| 33867 | 25096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005188.03023 | 2100718.94336 | 37.7484676648463 | -122.42483715961 | (37.7484676648463, -122.42483715961) | 2 | 4 | 5 | 28859 | 19 | |||
| 35617 | 5707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005241.86416 | 2098983.9941 | 37.7437069318227 | -122.424527610259 | (37.7437069318227, -122.424527610259) | 2 | 7 | 5 | 63 | 22 | |||
| 36361 | 25026 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.425675315185 | (37.7572811108424, -122.425675315185) | 2 | 4 | 5 | 28862 | 3 | |||
| 36493 | 25099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.424800585099 | (37.7480997459068, -122.424800585099) | 2 | 4 | 5 | 28859 | 19 | |||
| 38943 | 25129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | 2 | 7 | 5 | 63 | 22 | |||
| 39095 | 25102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | 2 | 7 | 5 | 63 | 22 | |||
| 39261 | 234359 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x Dolores St | 13 | Median : Yard | Tree | DPW 1 | 31 | 6005116.63925 | 2102018.48994 | 37.7520318867687 | -122.425176485533 | (37.7520318867687, -122.425176485533) | 2 | 4 | 5 | 28862 | 22 | ||||
| 40190 | 25085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005165.44363 | 2101134.84646 | 37.7496083631354 | -122.424944849843 | (37.7496083631354, -122.424944849843) | 2 | 4 | 5 | 28859 | 22 | |||
| 41862 | 234342 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 Dolores St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 6ft | 6004943.91683 | 2104413.64545 | 37.7585986644128 | -122.425944266413 | (37.7585986644128, -122.425944266413) | 2 | 4 | 5 | 28862 | 3 | |||
| 42605 | 25098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005207.85517 | 2100363.53531 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | 2 | 7 | 5 | 63 | 22 | |||
| 42792 | 25073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.425104353592 | (37.7513282140435, -122.425104353592) | 2 | 4 | 5 | 28862 | 22 | |||
| 43098 | 25024 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005003.84878 | 2104046.64903 | 37.7575943654175 | -122.425710873457 | (37.7575943654175, -122.425710873457) | 2 | 4 | 5 | 28862 | 3 | |||
| 46127 | 25143 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 48677 | 25052 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | 2 | 4 | 5 | 28862 | 22 | |||
| 49036 | 25075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1198 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | 2 | 4 | 5 | 28862 | 22 | |||
| 49188 | 234397 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | 2 | 4 | 5 | 28862 | 22 | |||
| 49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
| 52333 | 234371 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | 2 | 7 | 5 | 63 | 7 | ||||
| 52419 | 234367 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | 2 | 7 | 5 | 63 | 22 | ||||
| 52598 | 25009 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004942.00867 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | 2 | 4 | 5 | 28862 | 3 | |||
| 54599 | 25021 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005015.54343 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | 2 | 4 | 5 | 28862 | 3 | |||
| 55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
| 55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
| 56033 | 25025 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 58771 | 25047 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.7548322263474 | -122.425437427413 | (37.7548322263474, -122.425437427413) | 2 | 4 | 5 | 28862 | 22 | |||
| 61170 | 25079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1162 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.425310656505 | (37.7507559707678, -122.425310656505) | 2 | 4 | 5 | 28862 | 22 | |||
| 65475 | 96830 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 66930 | 25109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1496 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | 2 | 7 | 5 | 63 | 22 | |||
| 68276 | 25044 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 69224 | 25031 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 25 | 20 | 6005006.55303 | 2104135.22937 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | 2 | 4 | 5 | 28862 | 3 | |||
| 70644 | 25017 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 71132 | 25121 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.7451873697001 | -122.424530218294 | (37.7451873697001, -122.424530218294) | 2 | 7 | 5 | 63 | 22 | |||
| 71640 | 25070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005125.72632 | 2101888.99536 | 37.7516768380284 | -122.425135847862 | (37.7516768380284, -122.425135847862) | 2 | 4 | 5 | 28862 | 22 | |||
| 72293 | 25123 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.7441461706217 | -122.424424956245 | (37.7441461706217, -122.424424956245) | 2 | 7 | 5 | 63 | 22 | |||
| 73565 | 234366 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 9 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006381.59933 | 2099941.08815 | 37.7463991944772 | -122.420654601644 | (37.7463991944772, -122.420654601644) | 2 | 7 | 5 | 28859 | 2 | |||
| 73621 | 25019 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 77129 | 25028 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 06/23/1997 12:00:00 AM | 70 | 20 | 6005001.93677 | 2104182.12883 | 37.75796625306 | -122.425727128704 | (37.75796625306, -122.425727128704) | 2 | 4 | 5 | 28862 | 3 | ||
| 77778 | 25141 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005346.32958 | 2097965.45382 | 37.7409161502536 | -122.424093974258 | (37.7409161502536, -122.424093974258) | 2 | 7 | 5 | 63 | 7 | |||
| 82400 | 25038 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005033.4036 | 2103578.19486 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | 2 | 4 | 5 | 28862 | 22 | |||
| 82561 | 5679 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.17219 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | 2 | 7 | 5 | 63 | 22 | ||
| 83051 | 234345 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 34 | 6005211.50018 | 2100294.54181 | 37.7473036813364 | -122.424725813644 | (37.7473036813364, -122.424725813644) | 2 | 7 | 5 | 63 | 22 | ||||
| 83784 | 234360 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | 2 | 4 | 5 | 28862 | 22 | ||||
| 84183 | 25020 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 84522 | 234381 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Eugenia Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.419926400796 | (37.74136892295, -122.419926400796) | 2 | 7 | 7 | 28859 | 2 | ||||
| 86137 | 25116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.424514907343 | (37.7451117016422, -122.424514907343) | 2 | 7 | 5 | 63 | 22 | |||
| 86306 | 25127 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005306.72383 | 2098611.50649 | 37.7426878281697 | -122.424276854096 | (37.7426878281697, -122.424276854096) | 2 | 7 | 5 | 63 | 22 | |||
| 86509 | 25040 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005037.47438 | 2103495.56554 | 37.7560831194465 | -122.425555362685 | (37.7560831194465, -122.425555362685) | 2 | 4 | 5 | 28862 | 22 | |||
| 86521 | 25013 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004948.90557 | 2104970.06821 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | 2 | 4 | 5 | 28862 | 3 | |||
| 86563 | 25122 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005275.20405 | 2099188.47337 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | 2 | 7 | 5 | 63 | 22 | |||
| 87181 | 106114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1752X DOLORES ST | 1 | Median : Yard | Tree | DPW 1 | 6005197 | 2098194.1 | 37.7415355284645 | -122.424626562024 | (37.7415355284645, -122.424626562024) | 2 | 7 | 5 | 63 | 7 | |||||
| 88609 | 25076 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1184 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005073.9 | 2101453.9 | 37.7504792390956 | -122.425284111983 | (37.7504792390956, -122.425284111983) | 2 | 4 | 5 | 28862 | 22 | |||
| 89061 | 234369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.424122818219 | (37.7411720001789, -122.424122818219) | 2 | 7 | 5 | 63 | 7 | ||||
| 89066 | 234374 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 9ft | 6004996.87402 | 2105008.54576 | 37.7602351130699 | -122.425803460464 | (37.7602351130699, -122.425803460464) | 2 | 4 | 5 | 28859 | 19 | |||
| 89748 | 96821 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 90790 | 25077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1178 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005072.5 | 2101478.6 | 37.7505469804869 | -122.42529071074 | (37.7505469804869, -122.42529071074) | 2 | 4 | 5 | 28862 | 22 | |||
| 92493 | 25140 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005337.96039 | 2097982.38921 | 37.7409621784698 | -122.424124115947 | (37.7409621784698, -122.424124115947) | 2 | 7 | 5 | 63 | 7 | |||
| 92711 | 25014 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
| 92746 | 25041 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005036.07937 | 2103453.27666 | 37.7559669252599 | -122.425557177529 | (37.7559669252599, -122.425557177529) | 2 | 4 | 5 | 28862 | 22 | |||
| 94559 | 25135 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005318.69069 | 2098391.09531 | 37.7420833048092 | -122.424219803815 | (37.7420833048092, -122.424219803815) | 2 | 7 | 5 | 63 | 7 | |||
| 95609 | 25080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1156 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | 2 | 4 | 5 | 28862 | 22 | |||
| 95942 | 25088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005178.85274 | 2100929.77786 | 37.7490460494561 | -122.424883892899 | (37.7490460494561, -122.424883892899) | 2 | 4 | 5 | 28859 | 22 | |||
| 98351 | 25032 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005021.65336 | 2103769.84125 | 37.7568353223126 | -122.42562959723 | (37.7568353223126, -122.42562959723) | 2 | 4 | 5 | 28862 | 3 | |||
| 98562 | 234368 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | 2 | 7 | 5 | 63 | 7 | ||||
| 98735 | 234386 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004984.24145 | 2103652.12046 | 37.7565099745835 | -122.425750602809 | (37.7565099745835, -122.425750602809) | 2 | 4 | 5 | 28862 | 22 | |||
| 99214 | 25146 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 100652 | 234346 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350x Dolores St | 7 | Median : Yard | Tree | DPW 1 | 33 | 6005214.83803 | 2100265.33674 | 37.7472236794354 | -122.424712194312 | (37.7472236794354, -122.424712194312) | 2 | 7 | 5 | 63 | 22 | ||||
| 101755 | 25039 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005035.06937 | 2103531.66337 | 37.756182099743 | -122.425566249008 | (37.756182099743, -122.425566249008) | 2 | 4 | 5 | 28862 | 22 | |||
| 103103 | 234347 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | 2 | 4 | 5 | 28862 | 3 | ||||
| 103251 | 25091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.424758890703 | (37.7476698420965, -122.424758890703) | 2 | 7 | 5 | 63 | 22 | |||
| 103607 | 234348 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6004955.10734 | 2105017.76202 | 37.7602580583932 | -122.425948567888 | (37.7602580583932, -122.425948567888) | 2 | 4 | 5 | 28862 | 3 | ||||
| 104212 | 234352 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 45 | 6004969.77736 | 2104678.02917 | 37.7593260612613 | -122.425873648056 | (37.7593260612613, -122.425873648056) | 2 | 4 | 5 | 28862 | 3 |
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) );