trees
191 rows where Fire Prevention Districts = 2 and qSpecies_id = 160 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192759 | 5446 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 14 | Median : Cutout | Tree | DPW 1 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | ||
| 191216 | 234383 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3483 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005156.87556 | 2103096.10876 | 37.7549930502992 | -122.425114011399 | (37.7549930502992, -122.425114011399) | 2 | 4 | 5 | 28859 | 19 | |||
| 190651 | 234375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.7602382499206 | -122.425809806971 | (37.7602382499206, -122.425809806971) | 2 | 4 | 5 | 28859 | 19 | |||
| 190485 | 25067 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | 2 | 4 | 5 | 28862 | 22 | |||
| 188360 | 18535 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6006489 | 2098160 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | 2 | 7 | 7 | 28859 | 2 | |||
| 187923 | 96827 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 186891 | 25083 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005162.35719 | 2101213.31575 | 37.7498236473552 | -122.424961105075 | (37.7498236473552, -122.424961105075) | 2 | 4 | 5 | 28859 | 22 | |||
| 186642 | 234353 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004972.99997 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | 2 | 4 | 5 | 28862 | 3 | ||||
| 185850 | 25106 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005241.17775 | 2099713.87888 | 37.7457109900772 | -122.424581892451 | (37.7457109900772, -122.424581892451) | 2 | 7 | 5 | 63 | 22 | |||
| 184514 | 116529 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 745X SANCHEZ ST | 6 | Median : Yard | Tree | DPW 1 | 18 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
| 183865 | 26537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 06/23/1997 12:00:00 AM | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 183434 | 25064 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005102.42257 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | 2 | 4 | 5 | 28862 | 22 | |||
| 180593 | 25037 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | 2 | 4 | 5 | 28862 | 22 | |||
| 179404 | 25118 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005257.61936 | 2099436.85892 | 37.7449512850908 | -122.42450533857 | (37.7449512850908, -122.42450533857) | 2 | 7 | 5 | 63 | 22 | |||
| 179105 | 234351 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 30 | 6004966.99113 | 2104720.19059 | 37.7594416691168 | -122.425886285347 | (37.7594416691168, -122.425886285347) | 2 | 4 | 5 | 28862 | 3 | ||||
| 177506 | 25072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005130.36391 | 2101800.25652 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | 2 | 4 | 5 | 28862 | 22 | |||
| 176945 | 234357 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 24 | 6004986.09692 | 2104380.36291 | 37.7585096621012 | -122.425796019476 | (37.7585096621012, -122.425796019476) | 2 | 4 | 5 | 28862 | 3 | ||||
| 176871 | 234401 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3899 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 3ft | 6003740.05582 | 2104771.47672 | 37.75951307439 | -122.430133288745 | (37.75951307439, -122.430133288745) | 2 | 4 | 5 | 28862 | 3 | |||
| 176702 | 234343 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 7ft | 6005056.06627 | 2103868.04272 | 37.7571069049763 | -122.425517573176 | (37.7571069049763, -122.425517573176) | 2 | 4 | 5 | 28859 | 19 | |||
| 175022 | 234373 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 9ft | 6004999.25531 | 2105001.64416 | 37.7602162974746 | -122.425794733444 | (37.7602162974746, -122.425794733444) | 2 | 4 | 5 | 28859 | 19 | |||
| 174797 | 234396 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1351 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 6ft | 6001401.68154 | 2099734.75899 | 37.7455507389883 | -122.437859774517 | (37.7455507389883, -122.437859774517) | 2 | 4 | 5 | 63 | 22 | |||
| 172032 | 25111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005242.59316 | 2099769.24096 | 37.7458630816199 | -122.424580935573 | (37.7458630816199, -122.424580935573) | 2 | 7 | 5 | 63 | 22 | |||
| 170914 | 96825 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 170515 | 234327 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 29 | 6005045.03345 | 2103276.50664 | 37.7554820620736 | -122.425513631455 | (37.7554820620736, -122.425513631455) | 2 | 4 | 5 | 28862 | 22 | ||||
| 168577 | 247039 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 574 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 6ft | 6002246.42802 | 2099186.76685 | 37.7440940809725 | -122.43489959305 | (37.7440940809725, -122.43489959305) | 2 | 7 | 5 | 63 | 22 | |||
| 168440 | 96829 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 168371 | 234390 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6005245.61722 | 2098983.50062 | 37.7437057887861 | -122.424514597972 | (37.7437057887861, -122.424514597972) | 2 | 7 | 5 | 63 | 22 | |||
| 168094 | 25126 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005303.10253 | 2098649.37036 | 37.7427915892743 | -122.424292067924 | (37.7427915892743, -122.424292067924) | 2 | 7 | 5 | 63 | 22 | |||
| 167549 | 25120 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | 2 | 7 | 5 | 63 | 22 | |||
| 167494 | 25036 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005017.04415 | 2103831.36773 | 37.7570039991458 | -122.425649916508 | (37.7570039991458, -122.425649916508) | 2 | 4 | 5 | 28862 | 3 | |||
| 166992 | 234350 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 25 | 6004963.57632 | 2104757.16703 | 37.759543004714 | -122.425900727537 | (37.759543004714, -122.425900727537) | 2 | 4 | 5 | 28862 | 3 | ||||
| 166202 | 96828 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 164910 | 25093 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005193.32199 | 2100633.40551 | 37.7482330964805 | -122.424812776293 | (37.7482330964805, -122.424812776293) | 2 | 4 | 5 | 28859 | 19 | |||
| 164534 | 25145 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 160992 | 26536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 06/23/1997 12:00:00 AM | 50 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | ||
| 160936 | 234379 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 246 Bemis St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6003018.34772 | 2096316.7253 | 37.7362574066637 | -122.432025563025 | (37.7362574066637, -122.432025563025) | 2 | 7 | 5 | 63 | 7 | ||||
| 160711 | 25138 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005319.27803 | 2098285.92952 | 37.7417945765605 | -122.424210295287 | (37.7417945765605, -122.424210295287) | 2 | 7 | 5 | 63 | 7 | |||
| 159873 | 234344 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 751 Dolores St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6005051.924 | 2103931.9938 | 37.757282265587 | -122.425536449963 | (37.757282265587, -122.425536449963) | 2 | 4 | 5 | 28859 | 19 | |||
| 159468 | 5457 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 8 | 6004998.45452 | 2104996.17843 | 37.7602012446183 | -122.425797113951 | (37.7602012446183, -122.425797113951) | 2 | 4 | 5 | 28859 | 19 | |||
| 158030 | 27482 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 990X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | ||
| 156457 | 96823 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 156186 | 234328 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | 2 | 4 | 5 | 28862 | 22 | ||||
| 154348 | 25078 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1166 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005069.8 | 2101528.7 | 37.7506843909536 | -122.425303612289 | (37.7506843909536, -122.425303612289) | 2 | 4 | 5 | 28862 | 22 | |||
| 154171 | 25107 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005229.62403 | 2099972.88313 | 37.7464215039571 | -122.424640264758 | (37.7464215039571, -122.424640264758) | 2 | 7 | 5 | 63 | 22 | |||
| 154072 | 25022 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004995.79572 | 2104126.38242 | 37.7578128395023 | -122.425744399279 | (37.7578128395023, -122.425744399279) | 2 | 4 | 5 | 28862 | 3 | |||
| 153555 | 25097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1388X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005167.2006822 | 2100254.8047856 | 37.747192070496 | -122.424876171578 | (37.747192070496, -122.424876171578) | 2 | 7 | 5 | 63 | 22 | |||
| 151205 | 25144 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 149614 | 25048 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005066.31799 | 2102985.06573 | 37.7546830360144 | -122.425419283594 | (37.7546830360144, -122.425419283594) | 2 | 4 | 5 | 28862 | 22 | |||
| 149334 | 234388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1069 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6005149.23502 | 2102137.71701 | 37.7523610979942 | -122.425072246905 | (37.7523610979942, -122.425072246905) | 2 | 4 | 5 | 28859 | 19 | |||
| 149084 | 234355 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6004978.4588 | 2104465.76881 | 37.7587437349524 | -122.425828514675 | (37.7587437349524, -122.425828514675) | 2 | 4 | 5 | 28862 | 3 | ||||
| 148760 | 9369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | 2 | 7 | 5 | 63 | 7 | |||
| 147792 | 234326 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6005043.60607 | 2103360.12702 | 37.7557115834283 | -122.425524518639 | (37.7557115834283, -122.425524518639) | 2 | 4 | 5 | 28862 | 22 | ||||
| 146552 | 234365 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 7 | Median : Yard | Tree | DPW 1 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | 2 | 4 | 5 | 28859 | 22 | ||||
| 145284 | 234392 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1379 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 7ft | 6005257.78896 | 2100266.47383 | 37.7472292273428 | -122.424563754022 | (37.7472292273428, -122.424563754022) | 2 | 7 | 5 | 28859 | 22 | |||
| 144902 | 25092 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005189.02223 | 2100681.47449 | 37.7483648399821 | -122.424831064022 | (37.7483648399821, -122.424831064022) | 2 | 4 | 5 | 63 | 19 | |||
| 142522 | 25012 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
| 142397 | 234389 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1488 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 6ft | 6005200.95707 | 2099699.7446 | 37.7456699090375 | -122.424719964457 | (37.7456699090375, -122.424719964457) | 2 | 7 | 5 | 63 | 22 | |||
| 140046 | 234361 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 27 | 6005142.97819 | 2101556.59196 | 37.7507651098283 | -122.425052540047 | (37.7507651098283, -122.425052540047) | 2 | 4 | 5 | 28862 | 22 | ||||
| 139491 | 234329 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900x Dolores St | 14 | Median : Yard | Tree | DPW 1 | 27 | 6005081.6594 | 2102660.65252 | 37.7537931397475 | -122.425343144298 | (37.7537931397475, -122.425343144298) | 2 | 4 | 5 | 28862 | 22 | ||||
| 138865 | 25082 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005158.72228 | 2101250.83835 | 37.7499264704292 | -122.424976344106 | (37.7499264704292, -122.424976344106) | 2 | 4 | 5 | 28862 | 22 | |||
| 137557 | 25095 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005196.77931 | 2100544.39428 | 37.7479888873864 | -122.424794489489 | (37.7479888873864, -122.424794489489) | 2 | 4 | 5 | 63 | 19 | |||
| 136779 | 96826 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 136289 | 25074 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005132.37065 | 2101712.15677 | 37.751191655576 | -122.425100289545 | (37.751191655576, -122.425100289545) | 2 | 4 | 5 | 28862 | 22 | |||
| 135911 | 25046 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 135164 | 25089 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005180.26353 | 2100884.10883 | 37.748920732509 | -122.424875765702 | (37.748920732509, -122.424875765702) | 2 | 4 | 5 | 28859 | 22 | |||
| 134624 | 25087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005179.03552 | 2100967.22192 | 37.7491488725392 | -122.424885924444 | (37.7491488725392, -122.424885924444) | 2 | 4 | 5 | 28859 | 22 | |||
| 134480 | 25110 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005236.31225 | 2099800.23492 | 37.7459478292265 | -122.424604858453 | (37.7459478292265, -122.424604858453) | 2 | 7 | 5 | 63 | 22 | |||
| 134215 | 25112 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005235.50671 | 2099747.61613 | 37.7458033045753 | -122.424603901547 | (37.7458033045753, -122.424603901547) | 2 | 7 | 5 | 63 | 22 | |||
| 133715 | 234349 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 29 | 6004962.28051 | 2104795.65924 | 37.7596486220069 | -122.425907949096 | (37.7596486220069, -122.425907949096) | 2 | 4 | 5 | 28862 | 3 | ||||
| 132648 | 25034 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 130411 | 234370 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 35 | 6005335.59273 | 2098044.06455 | 37.7411313913144 | -122.42413668757 | (37.7411313913144, -122.42413668757) | 2 | 7 | 5 | 63 | 7 | ||||
| 129996 | 25094 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1348 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005177.2486108 | 2100480.3758406 | 37.7478120043347 | -122.424857472056 | (37.7478120043347, -122.424857472056) | 2 | 4 | 5 | 63 | 22 | |||
| 129311 | 25137 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005325.64048 | 2098301.13362 | 37.7418366828201 | -122.424189377061 | (37.7418366828201, -122.424189377061) | 2 | 7 | 5 | 63 | 7 | |||
| 128783 | 234363 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | 2 | 4 | 5 | 28862 | 22 | ||||
| 128175 | 234400 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4 Corwin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 3ft | 6001132.88166 | 2103964.26051 | 37.7571486461001 | -122.439092314277 | (37.7571486461001, -122.439092314277) | 2 | 4 | 5 | 28862 | 38 | |||
| 125694 | 234330 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900x Dolores St | 15 | Median : Yard | Tree | DPW 1 | 23 | 6005083.06258 | 2102603.58555 | 37.7536365264144 | -122.425334231087 | (37.7536365264144, -122.425334231087) | 2 | 4 | 5 | 28862 | 22 | ||||
| 123929 | 25115 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005272.16967 | 2099229.32207 | 37.7443822579348 | -122.424440267208 | (37.7443822579348, -122.424440267208) | 2 | 7 | 5 | 63 | 22 | |||
| 123032 | 234391 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6005241.74432 | 2098978.16752 | 37.7436909265933 | -122.424527610268 | (37.7436909265933, -122.424527610268) | 2 | 7 | 5 | 63 | 22 | |||
| 119946 | 234398 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3980 22nd St | 8 | : | Tree | Private 2 | 32 | 6001905.07347 | 2102956.38941 | 37.7544251823875 | -122.436349651817 | (37.7544251823875, -122.436349651817) | 2 | 4 | 5 | 28862 | 22 | ||||
| 115608 | 5557 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 977 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2006 12:00:00 AM | 32 | 3x3 | 6005125.10547 | 2102657.90315 | 37.753788045101 | -122.425192702095 | (37.753788045101, -122.425192702095) | 2 | 4 | 5 | 28859 | 19 | ||
| 114567 | 25117 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1548X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005242.6409807 | 2099315.8732107 | 37.7446182400704 | -122.424548526732 | (37.7446182400704, -122.424548526732) | 2 | 7 | 5 | 63 | 22 | |||
| 113629 | 25147 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 13 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 111962 | 25018 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005012.95019 | 2103889.37314 | 37.757163037054 | -122.42566820334 | (37.757163037054, -122.42566820334) | 2 | 4 | 5 | 28862 | 3 | |||
| 111683 | 234358 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | 2 | 4 | 5 | 28862 | 3 | ||||
| 109708 | 703 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | 2 | 7 | 5 | 28859 | 22 | |||
| 107961 | 234394 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350 Noe St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6003187.2989 | 2100371.49041 | 37.7474004312881 | -122.431730842629 | (37.7474004312881, -122.431730842629) | 2 | 4 | 5 | 63 | 22 | ||||
| 106466 | 234364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 23 | 6005148.13697 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | 2 | 4 | 5 | 28862 | 22 | ||||
| 106305 | 5683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.63053 | 37.7457272812867 | -122.424719964463 | (37.7457272812867, -122.424719964463) | 2 | 7 | 5 | 63 | 22 | ||
| 105070 | 234380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | 2 | 7 | 5 | 28859 | 2 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 102242 | 5485 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 |
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) );