trees
858 rows where qSpecies_id = 85 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 46969 | 43209 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 15 | Permit Number 43000 | 6007755.9781 | 2093953.95749 | 37.7300372142398 | -122.415478343147 | (37.7300372142398, -122.415478343147) | 9 | 3 | 7 | 309 | 28 | |
| 47084 | 240999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4216 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000932.6284 | 2105832.90843 | 37.7622680998129 | -122.439918845188 | (37.7622680998129, -122.439918845188) | 15 | 5 | 5 | 28862 | 3 | |||
| 47199 | 42979 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 308 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 10 | Permit Number 42863 | 6006597.58462 | 2092494.33475 | 37.7259642287513 | -122.419379553644 | (37.7259642287513, -122.419379553644) | 9 | 7 | 7 | 309 | 5 | |
| 47315 | 179611 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004351.48931 | 2091531.74381 | 37.7231944049897 | -122.427075629732 | (37.7231944049897, -122.427075629732) | 9 | 7 | 6 | 28861 | 5 | |||
| 47536 | 179594 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2115 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006118.53039 | 2086176.01149 | 37.7085884697411 | -122.420587301759 | (37.7085884697411, -122.420587301759) | 9 | 7 | 8 | 309 | 39 | |||
| 47899 | 215180 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999778.0534 | 2095525.26911 | 37.7339000182695 | -122.443171738004 | (37.7339000182695, -122.443171738004) | 9 | 7 | 4 | 63 | 40 | ||||
| 48039 | 215185 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 217 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5998634.76225 | 2093779.70268 | 37.7290418472936 | -122.446998854224 | (37.7290418472936, -122.446998854224) | 9 | 7 | 4 | 28861 | 40 | |||
| 48314 | 136554 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 900 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006026.16604 | 2113167.48716 | 37.7826957225725 | -122.422823475034 | (37.7826957225725, -122.422823475034) | 7 | 9 | 11 | 28858 | 41 | |||
| 48581 | 121492 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6012288.86366 | 2105128.25072 | 37.760973173204 | -122.400592156703 | (37.760973173204, -122.400592156703) | 10 | 3 | 8 | 28856 | 29 | ||||
| 49411 | 51824 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.31137 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) | 8 | 2 | 9 | 28853 | 34 | ||
| 49666 | 246454 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 405 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6003816.34015 | 2099803.317 | 37.7458759958985 | -122.429515147817 | (37.7458759958985, -122.429515147817) | 2 | 7 | 5 | 63 | 22 | |||
| 49958 | 179598 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 25 Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000939.98945 | 2092924.83634 | 37.7268260149038 | -122.438968283387 | (37.7268260149038, -122.438968283387) | 9 | 7 | 6 | 28861 | 25 | |||
| 49993 | 197756 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6009912.73431 | 2109600.17323 | 37.7731192414011 | -122.409125744471 | (37.7731192414011, -122.409125744471) | 14 | 2 | 9 | 28853 | 34 | |||
| 50468 | 245354 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Pond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003160.05712 | 2106264.33162 | 37.7635792277315 | -122.432245825899 | (37.7635792277315, -122.432245825899) | 15 | 4 | 5 | 28862 | 3 | |||
| 50492 | 184002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1600 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984962.772 | 2103675.8065 | 37.755423278248 | -122.494992688075 | (37.755423278248, -122.494992688075) | 1 | 8 | 3 | 56 | 35 | |||
| 50843 | 179585 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6010784.99943 | 2090994.75272 | 37.7220816432233 | -122.404798331783 | (37.7220816432233, -122.404798331783) | 10 | 3 | 7 | 309 | 28 | |||
| 51122 | 245251 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 206 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005413.81717 | 2102430.30031 | 37.7531794064144 | -122.424178084246 | (37.7531794064144, -122.424178084246) | 2 | 4 | 5 | 28859 | 19 | |||
| 51938 | 245308 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 621 Anderson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007813.44677 | 2096012.18951 | 37.7356919021641 | -122.415425322744 | (37.7356919021641, -122.415425322744) | 2 | 7 | 7 | 28859 | 2 | |||
| 52108 | 197809 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008647.67456 | 2110087.31944 | 37.77438587894 | -122.413536223923 | (37.77438587894, -122.413536223923) | 8 | 2 | 9 | 28853 | 34 | |||
| 52207 | 197781 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011867.97077 | 2105631.0205 | 37.7623301845026 | -122.402083196704 | (37.7623301845026, -122.402083196704) | 8 | 3 | 8 | 28856 | 29 | |||
| 52289 | 103821 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1032 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006936.4893 | 2114526.0013 | 37.7864771914113 | -122.419770562808 | (37.7864771914113, -122.419770562808) | 13 | 9 | 9 | 28858 | 36 | ||
| 52431 | 142854 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006834.6673 | 2115255.4083 | 37.7884742270331 | -122.42017462803 | (37.7884742270331, -122.42017462803) | 13 | 9 | 10 | 28858 | 21 | |||
| 52724 | 250213 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 300 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011356.8747 | 2120078.79875 | 37.8019718623651 | -122.404868140773 | (37.8019718623651, -122.404868140773) | 3 | 1 | 10 | 308 | 23 | |||
| 52850 | 197768 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 15 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | 10 | 3 | 8 | 28856 | 29 |
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) );