trees
858 rows where qSpecies_id = 85
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26092 | 114847 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002442.62774 | 2118155.32308 | 37.7961881963905 | -122.435577919296 | (37.7961881963905, -122.435577919296) | 13 | 9 | 1 | 57 | 17 | |||
| 26447 | 42664 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | 6 | Permit Number 768090 | 6007065.06318 | 2121240.35517 | 37.8049203715397 | -122.419802335728 | (37.8049203715397, -122.419802335728) | 5 | 1 | 1 | 28858 | 32 | ||
| 26945 | 142848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1305 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006765.7864 | 2115397.4815 | 37.7888604436235 | -122.420423033997 | (37.7888604436235, -122.420423033997) | 13 | 9 | 10 | 28858 | 21 | ||
| 26992 | 179620 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 602 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6010330.79398 | 2091554.32638 | 37.7235927183043 | -122.40640782506 | (37.7235927183043, -122.40640782506) | 10 | 3 | 7 | 309 | 28 | |||
| 27265 | 45778 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | 14 | Permit Number 44419 | 6006891.87332 | 2114501.10639 | 37.7864063226311 | -122.41992315605 | (37.7864063226311, -122.41992315605) | 13 | 9 | 10 | 28858 | 36 | ||
| 27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
| 27271 | 50760 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
| 27692 | 245291 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1543 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002046.84387 | 2099517.48848 | 37.7449908309659 | -122.435613365186 | (37.7449908309659, -122.435613365186) | 2 | 7 | 5 | 63 | 22 | |||
| 27810 | 179583 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 299 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012138.53838 | 2086862.1031 | 37.7108097799129 | -122.399829404828 | (37.7108097799129, -122.399829404828) | 10 | 3 | 8 | 309 | 1 | |||
| 27864 | 142847 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006787.7441 | 2115244.9809 | 37.7884429519581 | -122.420336234883 | (37.7884429519581, -122.420336234883) | 13 | 9 | 10 | 28858 | 21 | |||
| 27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 19 | ||||
| 28052 | 103841 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1545 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006617.6 | 2116265.9 | 37.7912365537909 | -122.420997422968 | (37.7912365537909, -122.420997422968) | 13 | 9 | 10 | 28858 | 21 | ||
| 28114 | 240990 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 5 Beaver St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6002802.39539 | 2106779.35324 | 37.7649730662735 | -122.433519671517 | (37.7649730662735, -122.433519671517) | 15 | 5 | 5 | 28862 | 3 | |||
| 28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
| 28855 | 240986 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2423 Market St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 6002082.38212 | 2105743.71018 | 37.7620885654527 | -122.435935903446 | (37.7620885654527, -122.435935903446) | 15 | 4 | 5 | 28862 | 3 | |||
| 29214 | 142860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1034 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006934.3072 | 2114548.914 | 37.7865399811377 | -122.419779738746 | (37.7865399811377, -122.419779738746) | 13 | 9 | 9 | 28858 | 36 | |||
| 30055 | 197791 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | 10 | 3 | 8 | 28856 | 29 | |||
| 30083 | 201521 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 869 Innes Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6019420.24762 | 2094273.01088 | 37.7315619976776 | -122.375175152832 | (37.7315619976776, -122.375175152832) | 10 | 3 | 8 | 58 | 1 | |||
| 30492 | 215162 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 50 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994831.77603 | 2100788.44228 | 37.7480681050619 | -122.460653675452 | (37.7480681050619, -122.460653675452) | 1 | 8 | 4 | 29491 | 40 | |||
| 30690 | 245342 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 970 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003109.09048 | 2102570.15873 | 37.753433023323 | -122.432158272384 | (37.753433023323, -122.432158272384) | 2 | 4 | 5 | 28862 | 22 | |||
| 30893 | 179612 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004345.82316 | 2091535.07257 | 37.7232032246197 | -122.4270954535 | (37.7232032246197, -122.4270954535) | 9 | 7 | 6 | 28861 | 5 | |||
| 31094 | 240991 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 5 Beaver St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6002817.2549 | 2106779.86765 | 37.7649753217902 | -122.433468313011 | (37.7649753217902, -122.433468313011) | 15 | 5 | 5 | 28862 | 3 | |||
| 31156 | 26197 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 519 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | Permit Number 772904 | 6002381.63954 | 2105165.88105 | 37.7605189822794 | -122.434859564238 | (37.7605189822794, -122.434859564238) | 2 | 4 | 5 | 28862 | 3 | ||
| 31445 | 197792 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 228 Connecticut St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6013148.35308 | 2105968.0458 | 37.7633269624894 | -122.397678442332 | (37.7633269624894, -122.397678442332) | 14 | 3 | 8 | 28856 | 29 | |||
| 31597 | 240876 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3498 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6006577.95274 | 2100878.25126 | 37.7489834962083 | -122.420042128242 | (37.7489834962083, -122.420042128242) | 2 | 4 | 7 | 28859 | 19 | |||
| 31721 | 245299 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4308 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001090.90021 | 2103332.76548 | 37.75541232504 | -122.439192241532 | (37.75541232504, -122.439192241532) | 2 | 4 | 5 | 28862 | 38 | |||
| 32439 | 136549 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1160 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6006876.35083 | 2114950.02533 | 37.7876380691922 | -122.420008729221 | (37.7876380691922, -122.420008729221) | 13 | 9 | 10 | 28858 | 21 | |||
| 32683 | 245229 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 267 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005011.87346 | 2108197.61767 | 37.7689923919147 | -122.425978603426 | (37.7689923919147, -122.425978603426) | 8 | 4 | 5 | 28853 | 19 | |||
| 32900 | 108848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 285 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772784 | 6000194.12477 | 2087314.03499 | 37.7113775614841 | -122.441144334244 | (37.7113775614841, -122.441144334244) | 9 | 7 | 6 | 28861 | 5 |
| 33462 | 245260 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 178 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6004796.85539 | 2098734.84829 | 37.7429976931945 | -122.426048612058 | (37.7429976931945, -122.426048612058) | 2 | 7 | 5 | 63 | 22 | |||
| 33485 | 215143 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997162.83414 | 2099722.45046 | 37.7452749915648 | -122.452516088848 | (37.7452749915648, -122.452516088848) | 1 | 7 | 4 | 59 | 40 | |||
| 33501 | 197788 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2056 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011954.13771 | 2104694.98029 | 37.7597648350875 | -122.401719379549 | (37.7597648350875, -122.401719379549) | 10 | 3 | 8 | 28856 | 29 | |||
| 33656 | 179619 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | 10 | 3 | 7 | 309 | 28 | ||||
| 33700 | 245246 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 68 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005362.43009 | 2103338.82468 | 37.755671101354 | -122.424420407495 | (37.755671101354, -122.424420407495) | 2 | 4 | 5 | 28859 | 19 | |||
| 33843 | 51717 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.85826 | 37.7743943397653 | -122.399857674991 | (37.7743943397653, -122.399857674991) | 14 | 2 | 9 | 28856 | 20 | ||
| 34040 | 215141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997116.2143 | 2099688.39867 | 37.7451788225419 | -122.452674834471 | (37.7451788225419, -122.452674834471) | 1 | 7 | 4 | 59 | 40 | |||
| 34629 | 197801 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011521.16357 | 2109490.57736 | 37.7729082910133 | -122.403554237551 | (37.7729082910133, -122.403554237551) | 14 | 2 | 9 | 28853 | 34 | |||
| 34667 | 197775 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012572.98246 | 2106081.16458 | 37.7636055050056 | -122.399676416648 | (37.7636055050056, -122.399676416648) | 14 | 3 | 8 | 28856 | 29 | |||
| 34870 | 136541 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6006833.25641 | 2115260.36214 | 37.7884877495592 | -122.420179861217 | (37.7884877495592, -122.420179861217) | 13 | 9 | 10 | 28858 | 21 | |||
| 35207 | 245324 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1139 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009488.18332 | 2102546.37168 | 37.7537273210842 | -122.410096245168 | (37.7537273210842, -122.410096245168) | 2 | 4 | 7 | 28859 | 19 | |||
| 35261 | 197796 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6013463.04553 | 2095982.9565 | 37.7359275587079 | -122.395890286113 | (37.7359275587079, -122.395890286113) | 10 | 3 | 8 | 58 | 1 | |||
| 35734 | 225141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005929.72911 | 2106381.16026 | 37.7640566615994 | -122.422674693899 | (37.7640566615994, -122.422674693899) | 8 | 4 | 5 | 28859 | 19 | |||
| 35774 | 136578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008572.42572 | 2122428.93464 | 37.808268711206 | -122.414670090059 | (37.808268711206, -122.414670090059) | 3 | 1 | 10 | 308 | 23 | |||
| 35836 | 179593 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 78 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010613.233 | 2088708.1848 | 37.7157935942767 | -122.40523115211 | (37.7157935942767, -122.40523115211) | 9 | 7 | 8 | 309 | 39 | |||
| 36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
| 36408 | 83343 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50763 | 6011023.37395305 | 2119422.18641329 | 37.8001503184077 | -122.405975934235 | (37.8001503184077, -122.405975934235) | 3 | 1 | 10 | 308 | 23 | ||
| 36539 | 215138 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993949.3025 | 2094130.56753 | 37.7297364296862 | -122.46322217696 | (37.7297364296862, -122.46322217696) | 9 | 8 | 4 | 59 | 40 | |||
| 36658 | 66354 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 334 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1990 12:00:00 AM | 13 | Permit Number 29475 | 6003787.88189 | 2089236.55246 | 37.7168604267574 | -122.428860361341 | (37.7168604267574, -122.428860361341) | 9 | 7 | 6 | 28861 | 5 | ||
| 37196 | 245249 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 204 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005411.18534 | 2102480.95785 | 37.7533183516659 | -122.424190788097 | (37.7533183516659, -122.424190788097) | 2 | 4 | 5 | 28859 | 19 | |||
| 37524 | 246483 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 338 Duncan St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6004093.31065 | 2099866.86007 | 37.7460661485508 | -122.428561950981 | (37.7460661485508, -122.428561950981) | 2 | 7 | 5 | 63 | 22 | |||
| 37580 | 245253 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010233.17575 | 2102878.70236 | 37.7546815557325 | -122.40754330998 | (37.7546815557325, -122.40754330998) | 2 | 4 | 7 | 28859 | 19 | |||
| 37599 | 51826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008951.49863 | 2109770.91917 | 37.7735341733012 | -122.412462865995 | (37.7735341733012, -122.412462865995) | 8 | 2 | 9 | 28853 | 34 | ||
| 37943 | 15688 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003628.48127 | 2094078.57512 | 37.7301465241442 | -122.429756492581 | (37.7301465241442, -122.429756492581) | 9 | 7 | 6 | 28861 | 5 | ||
| 38043 | 245343 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 998 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003112.4322 | 2102492.99553 | 37.7532213409162 | -122.432141205965 | (37.7532213409162, -122.432141205965) | 2 | 4 | 5 | 28862 | 22 | |||
| 38102 | 136540 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2960 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999430.14581 | 2117046.26527 | 37.7929714572124 | -122.445921873796 | (37.7929714572124, -122.445921873796) | 13 | 9 | 1 | 57 | 27 | |||
| 38177 | 36048 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
| 38214 | 245363 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 511 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002381.78952 | 2105193.34277 | 37.7605943940349 | -122.434861009453 | (37.7605943940349, -122.434861009453) | 2 | 4 | 5 | 28862 | 3 | |||
| 38249 | 103855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1489 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.68698 | 2115849.48669 | 37.7900993346467 | -122.420590411881 | (37.7900993346467, -122.420590411881) | 13 | 9 | 10 | 28858 | 21 | ||
| 38527 | 245248 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3434 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005494.2746 | 2103157.83673 | 37.7551815949762 | -122.423951577411 | (37.7551815949762, -122.423951577411) | 2 | 4 | 5 | 28859 | 19 | |||
| 38602 | 28716 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 588 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002337.13955 | 2104792.27663 | 37.7594906282039 | -122.434986749035 | (37.7594906282039, -122.434986749035) | 2 | 4 | 5 | 28862 | 3 | |
| 38658 | 179604 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.446589774218 | (37.7175750361301, -122.446589774218) | 9 | 7 | 6 | 28861 | 25 | |||
| 39190 | 41631 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.399940414441 | (37.7743312765925, -122.399940414441) | 14 | 2 | 9 | 28856 | 20 | ||
| 39234 | 51943 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3724 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48168 | 6004898.66350081 | 2102543.97492913 | 37.7534624298516 | -122.425967681323 | (37.7534624298516, -122.425967681323) | 2 | 4 | 5 | 28862 | 22 | |||
| 39646 | 93672 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 80 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53291 | 6013405 | 2106710 | 37.7653784929972 | -122.396842798823 | (37.7653784929972, -122.396842798823) | 14 | 3 | 8 | 28856 | 20 | |||
| 39651 | 142885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006912.0707 | 2114700.1497 | 37.7869539845455 | -122.419867407304 | (37.7869539845455, -122.419867407304) | 13 | 9 | 10 | 28858 | 21 | |||
| 39777 | 136538 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2960 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999433.58681 | 2117034.92752 | 37.7929405232314 | -122.445909151991 | (37.7929405232314, -122.445909151991) | 13 | 9 | 1 | 57 | 27 | |||
| 39933 | 179569 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5998642.93627 | 2088367.48919 | 37.7141816278426 | -122.446581361956 | (37.7141816278426, -122.446581361956) | 9 | 7 | 6 | 28861 | 25 | |||
| 40135 | 245257 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 941 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004404.53207 | 2103435.24181 | 37.7558817009973 | -122.427739992226 | (37.7558817009973, -122.427739992226) | 2 | 4 | 5 | 28862 | 22 | |||
| 40405 | 48612 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Ulloa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
| 40951 | 256130 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3166 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008577.74529 | 2101575.59595 | 37.7510107173881 | -122.413176115581 | (37.7510107173881, -122.413176115581) | 2 | 4 | 7 | 28859 | 19 | ||||
| 41124 | 50008 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014311.55635 | 2105196.94353 | 37.7612743885122 | -122.393601300174 | (37.7612743885122, -122.393601300174) | 10 | 3 | 8 | 28856 | 29 |
| 41360 | 197804 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011235.3992 | 2109217.88632 | 37.7721435776893 | -122.404523536758 | (37.7721435776893, -122.404523536758) | 14 | 2 | 9 | 28853 | 34 | |||
| 41439 | 50825 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 260 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47345 | 5992354.32900617 | 2095121.08916568 | 37.7323641420519 | -122.468808176404 | (37.7323641420519, -122.468808176404) | 9 | 8 | 4 | 59 | 40 | |||
| 41579 | 87854 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 330 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50765 | 6006363.5 | 2097928.1 | 37.7408709626282 | -122.42057431814 | (37.7408709626282, -122.42057431814) | 2 | 7 | 7 | 28859 | 2 | ||
| 41666 | 240875 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3498 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6006590.99439 | 2100878.65509 | 37.7489853398132 | -122.419997058715 | (37.7489853398132, -122.419997058715) | 2 | 4 | 7 | 28859 | 19 | |||
| 41912 | 136569 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008276.62811 | 2122005.04702 | 37.8070881999362 | -122.415663746486 | (37.8070881999362, -122.415663746486) | 5 | 1 | 10 | 308 | 23 | |||
| 42424 | 197761 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6010003.68567 | 2109694.36237 | 37.773382957679 | -122.408817777045 | (37.773382957679, -122.408817777045) | 14 | 2 | 9 | 28853 | 34 | |||
| 42604 | 215186 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 217 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998652.24527 | 2093777.94068 | 37.7290380080928 | -122.446938287569 | (37.7290380080928, -122.446938287569) | 9 | 7 | 4 | 28861 | 40 | |||
| 42732 | 103772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
| 42937 | 136556 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006852.77873 | 2114483.71843 | 37.7863563769807 | -122.420057179305 | (37.7863563769807, -122.420057179305) | 13 | 9 | 10 | 28858 | 36 | |||
| 43126 | 240859 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005815.33313 | 2106780.63921 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | 8 | 4 | 5 | 28853 | 19 | |||
| 43359 | 240995 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 44 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004448.94888 | 2107518.77636 | 37.7670966273258 | -122.427877346558 | (37.7670966273258, -122.427877346558) | 8 | 4 | 5 | 28862 | 3 | |||
| 43365 | 245279 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3257 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006552.94667 | 2103757.73548 | 37.7568884902353 | -122.420332948315 | (37.7568884902353, -122.420332948315) | 2 | 4 | 7 | 28859 | 19 | |||
| 43497 | 197813 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015877.12645 | 2095949.17922 | 37.7359688205142 | -122.387541417306 | (37.7359688205142, -122.387541417306) | 10 | 3 | 8 | 58 | 1 | |||
| 43628 | 136547 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1127 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006861.97682 | 2114694.93906 | 37.7869368551843 | -122.42004035118 | (37.7869368551843, -122.42004035118) | 13 | 9 | 10 | 28858 | 21 | |||
| 44241 | 245344 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.7528650960514 | -122.431914479684 | (37.7528650960514, -122.431914479684) | 2 | 4 | 5 | 28862 | 22 | |
| 44332 | 197798 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 444 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013857.66162 | 2111727.99067 | 37.7791819571277 | -122.395628745281 | (37.7791819571277, -122.395628745281) | 6 | 2 | 9 | 28856 | 34 | |||
| 44587 | 179600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5998640.25719 | 2089558.97664 | 37.71745302692 | -122.446676297989 | (37.71745302692, -122.446676297989) | 9 | 7 | 6 | 28861 | 25 | |||
| 44614 | 136571 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008282.41711 | 2121963.57618 | 37.8069746569262 | -122.415640774196 | (37.8069746569262, -122.415640774196) | 5 | 1 | 10 | 308 | 23 | |||
| 45093 | 136531 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Beach St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999585.07501 | 2120878.20565 | 37.8035017881435 | -122.445661503881 | (37.8035017881435, -122.445661503881) | 13 | 9 | 1 | 57 | 17 | |||
| 45555 | 47535 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1242 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51815 | 6004449.94033609 | 2101659.83008367 | 37.7510094045374 | -122.427456480608 | (37.7510094045374, -122.427456480608) | 2 | 4 | 5 | 28862 | 22 | ||
| 45626 | 147329 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 565 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5988421.62251 | 2112156.47459 | 37.7789107377833 | -122.483652819623 | (37.7789107377833, -122.483652819623) | 11 | 6 | 2 | 55 | 26 | |||
| 45632 | 240989 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2423 Market St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6002119.69058 | 2105763.49027 | 37.7621449961121 | -122.435808283336 | (37.7621449961121, -122.435808283336) | 15 | 4 | 5 | 28862 | 3 | |||
| 45740 | 36047 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
| 46103 | 39999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.7317008637943 | -122.375429242788 | (37.7317008637943, -122.375429242788) | 10 | 3 | 8 | 58 | 1 | |
| 46176 | 179568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5998649.6038 | 2088359.07643 | 37.7141589091721 | -122.446557711588 | (37.7141589091721, -122.446557711588) | 9 | 7 | 6 | 28861 | 25 | |||
| 46661 | 83577 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 124 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52313 | 6003965.91077 | 2093279.80757 | 37.7279723888056 | -122.42853304139 | (37.7279723888056, -122.42853304139) | 9 | 7 | 6 | 28861 | 5 | |
| 46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
| 46815 | 245242 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 882 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009904.77367 | 2104105.11232 | 37.7580306148353 | -122.408765535424 | (37.7580306148353, -122.408765535424) | 2 | 4 | 7 | 28859 | 19 | |||
| 46902 | 95103 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200@Broderick Beach St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 12 | 5999638.34857 | 2120885.83168 | 37.8035257685578 | -122.445477697742 | (37.8035257685578, -122.445477697742) | 13 | 9 | 1 | 57 | 17 |
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) );