trees
858 rows where qSpecies_id = 85 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
| 5526 | 71641 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | 3 | 1 | 10 | 308 | 23 | |||
| 16960 | 179590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010898.94901 | 2089680.08922 | 37.7184782153849 | -122.404311947847 | (37.7184782153849, -122.404311947847) | 10 | 7 | 8 | 309 | 39 | |||
| 19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20894 | 136529 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3601 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999666.6912 | 2120931.30198 | 37.8036522357126 | -122.445382888535 | (37.8036522357126, -122.445382888535) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 55489 | 215151 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 748 Lakeview Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994563.14295 | 2089947.14984 | 37.7182851165506 | -122.460797016589 | (37.7182851165506, -122.460797016589) | 9 | 8 | 6 | 28861 | 24 | |||
| 62198 | 142865 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006959.584 | 2114368.3394 | 37.7860455914687 | -122.419679470083 | (37.7860455914687, -122.419679470083) | 13 | 9 | 9 | 28858 | 36 | |||
| 62227 | 5732 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6 | 6005259.19448 | 2098408.80899 | 37.7421285829626 | -122.424426782768 | (37.7421285829626, -122.424426782768) | 2 | 7 | 5 | 63 | 7 | |||
| 71102 | 179603 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998658.1578 | 2089592.85208 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | 9 | 7 | 6 | 28861 | 25 | |||
| 78859 | 53588 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1409 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 9 | Permit Number 6517 | 6006718.9791 | 2115736.7746 | 37.7897894207569 | -122.420609076139 | (37.7897894207569, -122.420609076139) | 13 | 9 | 10 | 28858 | 21 | ||
| 80390 | 197795 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013476.07087 | 2095990.32103 | 37.735948504815 | -122.395845767893 | (37.735948504815, -122.395845767893) | 10 | 3 | 8 | 58 | 1 | |||
| 80668 | 142832 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1553 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006643.2439 | 2116275.8765 | 37.791265392276 | -122.420909404242 | (37.791265392276, -122.420909404242) | 13 | 9 | 10 | 28858 | 21 | ||
| 80860 | 33863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 281 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | 9 | Permit Number 37859 | 6011402.4962 | 2111360.89694 | 37.7780371282385 | -122.404096375858 | (37.7780371282385, -122.404096375858) | 14 | 2 | 9 | 28856 | 34 | ||
| 83857 | 136526 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001557.44496 | 2121595.35647 | 37.8055833040806 | -122.438887469389 | (37.8055833040806, -122.438887469389) | 13 | 9 | 1 | 57 | 17 | |||
| 91662 | 240985 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2423 Market St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 8ft | 6002070.76552 | 2105741.45932 | 37.7620817252178 | -122.435975919665 | (37.7620817252178, -122.435975919665) | 15 | 4 | 5 | 28862 | 3 | |||
| 93291 | 240987 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2423 Market St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 8ft | 6002096.23845 | 2105748.40592 | 37.7621022459512 | -122.435888315809 | (37.7621022459512, -122.435888315809) | 15 | 4 | 5 | 28862 | 3 | |||
| 93833 | 240975 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 273 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003860.27896 | 2104487.28445 | 37.7587395585027 | -122.42969722814 | (37.7587395585027, -122.42969722814) | 2 | 4 | 5 | 28862 | 3 | |||
| 95719 | 215152 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994637.17315 | 2089906.08202 | 37.7181766133493 | -122.460538153038 | (37.7181766133493, -122.460538153038) | 9 | 8 | 6 | 28861 | 24 | |||
| 106399 | 179602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998651.59561 | 2089580.85001 | 37.7175137338593 | -122.446638679342 | (37.7175137338593, -122.446638679342) | 9 | 7 | 6 | 28861 | 25 | |||
| 107382 | 215178 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Martha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000653.29214 | 2095587.48865 | 37.7341207262744 | -122.440150239859 | (37.7341207262744, -122.440150239859) | 9 | 7 | 5 | 63 | 40 | |||
| 111540 | 136568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007491.24914 | 2120995.37952 | 37.8042717301083 | -122.418310088837 | (37.8042717301083, -122.418310088837) | 5 | 1 | 1 | 308 | 32 | |||
| 112644 | 51825 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 9 | Permit Number 48062 | 6008869.29878 | 2109856.43438 | 37.7737643646643 | -122.412753255267 | (37.7737643646643, -122.412753255267) | 8 | 2 | 9 | 28853 | 34 | ||
| 114921 | 245262 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3835 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004938.45081 | 2100743.28359 | 37.7485203975099 | -122.425701933322 | (37.7485203975099, -122.425701933322) | 2 | 4 | 5 | 63 | 22 | |||
| 121866 | 93030 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
| 124615 | 142884 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 0ft | 6006908.0601 | 2114365.4705 | 37.7860348116628 | -122.419857525608 | (37.7860348116628, -122.419857525608) | 13 | 9 | 9 | 28858 | 36 | |||
| 126601 | 179599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998631.90027 | 2089544.41132 | 37.7174125565133 | -122.446704136484 | (37.7174125565133, -122.446704136484) | 9 | 7 | 6 | 28861 | 25 | |||
| 129927 | 199676 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1438 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015463.3731 | 2093112.0896 | 37.7281558172955 | -122.388773943405 | (37.7281558172955, -122.388773943405) | 10 | 3 | 8 | 58 | 1 | |||
| 130774 | 197755 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6009884.52157 | 2109578.01203 | 37.7730568113471 | -122.409221772263 | (37.7730568113471, -122.409221772263) | 14 | 2 | 9 | 28853 | 34 | |||
| 131354 | 179564 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998675.98821 | 2088335.16586 | 37.7140947632347 | -122.446464798107 | (37.7140947632347, -122.446464798107) | 9 | 7 | 6 | 28861 | 25 | |||
| 133940 | 142849 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1301 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006768.5938 | 2115374.6214 | 37.7887978336371 | -122.420411697508 | (37.7887978336371, -122.420411697508) | 13 | 9 | 10 | 28858 | 21 | ||
| 134210 | 197772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 370 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011991.34418 | 2106649.17126 | 37.7651326842421 | -122.401728059814 | (37.7651326842421, -122.401728059814) | 8 | 3 | 8 | 28853 | 20 | |||
| 142958 | 179584 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6010797.22777 | 2090997.12631 | 37.7220888441036 | -122.40475622822 | (37.7220888441036, -122.40475622822) | 10 | 3 | 7 | 309 | 28 | |||
| 143647 | 142833 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1549 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006645.4552 | 2116252.8795 | 37.7912023728705 | -122.420900119745 | (37.7912023728705, -122.420900119745) | 13 | 9 | 10 | 28858 | 21 | ||
| 147481 | 215182 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 463 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999010.27233 | 2094940.09474 | 37.732249458336 | -122.445784110252 | (37.732249458336, -122.445784110252) | 9 | 7 | 4 | 59 | 40 | |||
| 163572 | 215175 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998426.00188 | 2097089.19076 | 37.7381169869985 | -122.447958731229 | (37.7381169869985, -122.447958731229) | 9 | 7 | 4 | 59 | 40 | |||
| 180831 | 215156 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 218 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5994824.14627 | 2089663.55723 | 37.7175214527221 | -122.459874313044 | (37.7175214527221, -122.459874313044) | 9 | 8 | 6 | 28861 | 24 | |||
| 184913 | 142877 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1187 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 0ft | 6006832.261 | 2114920.1275 | 37.7875534929777 | -122.420159149048 | (37.7875534929777, -122.420159149048) | 13 | 9 | 10 | 28858 | 21 | |||
| 188944 | 136548 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1160 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6006881.24187 | 2114926.36789 | 37.7875733872447 | -122.419990127669 | (37.7875733872447, -122.419990127669) | 13 | 9 | 10 | 28858 | 21 | |||
| 191400 | 197770 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 6015491.65418 | 2103907.18258 | 37.7577984836214 | -122.389429732797 | (37.7577984836214, -122.389429732797) | 10 | 3 | 8 | 28856 | 29 | |||
| 193137 | 197771 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 398 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014310.79788 | 2105214.47052 | 37.7613224716698 | -122.393605150155 | (37.7613224716698, -122.393605150155) | 10 | 3 | 8 | 28856 | 29 | |||
| 194165 | 43208 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 9 | Permit Number 43000 | 6007763.04547 | 2093934.70612 | 37.7299847513771 | -122.415452547907 | (37.7299847513771, -122.415452547907) | 9 | 3 | 7 | 309 | 28 | |
| 284 | 142846 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.420346012985 | (37.7884989771715, -122.420346012985) | 13 | 9 | 10 | 28858 | 21 | |||
| 9268 | 245287 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 717 Duncan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6001940.90402 | 2099694.09971 | 37.7454697460299 | -122.435992320586 | (37.7454697460299, -122.435992320586) | 2 | 7 | 5 | 63 | 22 | |||
| 17588 | 245271 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
| 20367 | 52364 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.64598 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | 13 | 9 | 9 | 28858 | 36 | |
| 20782 | 40002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | 10 | 3 | 8 | 58 | 1 | |
| 24695 | 136564 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007032.14373 | 2121235.03543 | 37.8049039103473 | -122.419915879607 | (37.8049039103473, -122.419915879607) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 56629 | 136558 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 945 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007692.42532 | 2115699.65568 | 37.7897423145977 | -122.417238404529 | (37.7897423145977, -122.417238404529) | 13 | 1 | 10 | 28858 | 21 | |||
| 56933 | 245294 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 525 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6002498.65421 | 2098563.13018 | 37.7423960377374 | -122.433982882617 | (37.7423960377374, -122.433982882617) | 2 | 7 | 5 | 63 | 7 | |||
| 57296 | 179565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998669.51427 | 2088341.14104 | 37.7141107999422 | -122.446487604047 | (37.7141107999422, -122.446487604047) | 9 | 7 | 6 | 28861 | 25 | |||
| 58591 | 240869 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005279.8956 | 2098315.15915 | 37.7418726107263 | -122.424348545375 | (37.7418726107263, -122.424348545375) | 2 | 7 | 5 | 63 | 7 | |||
| 61453 | 142883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.419870362438 | (37.7861018038827, -122.419870362438) | 13 | 9 | 9 | 28858 | 36 | |||
| 64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
| 69879 | 136542 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6006831.91851 | 2115273.77419 | 37.7885245003562 | -122.4201854424 | (37.7885245003562, -122.4201854424) | 13 | 9 | 10 | 28858 | 21 | |||
| 75608 | 241001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 244 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004097.47892 | 2108736.71295 | 37.7704208966318 | -122.429179880544 | (37.7704208966318, -122.429179880544) | 7 | 9 | 11 | 29492 | 10 | |||
| 76791 | 240868 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6005263.31949 | 2098343.70068 | 37.7419500432577 | -122.424407889836 | (37.7419500432577, -122.424407889836) | 2 | 7 | 5 | 63 | 7 | |||
| 78070 | 215167 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 616 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996095.52716 | 2095987.52181 | 37.734958585052 | -122.455936678249 | (37.734958585052, -122.455936678249) | 9 | 7 | 4 | 59 | 40 | |||
| 83552 | 240966 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 35 Yukon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000257.57162 | 2104733.04694 | 37.7592097006798 | -122.442174649757 | (37.7592097006798, -122.442174649757) | 2 | 4 | 5 | 28862 | 3 | |||
| 100099 | 179596 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2101 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006079.30218 | 2086189.02233 | 37.7086219838753 | -122.420723802683 | (37.7086219838753, -122.420723802683) | 9 | 7 | 8 | 309 | 39 | |||
| 101934 | 215168 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 622 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996065.35511 | 2096007.84568 | 37.7350126576924 | -122.456042461904 | (37.7350126576924, -122.456042461904) | 9 | 7 | 4 | 59 | 40 | |||
| 102191 | 245306 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002154.22585 | 2096093.86351 | 37.735596451704 | -122.434997251342 | (37.735596451704, -122.434997251342) | 2 | 7 | 5 | 63 | 7 | |||
| 107604 | 136557 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 837 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6007687.79617 | 2114390.45453 | 37.7861473079843 | -122.417161613215 | (37.7861473079843, -122.417161613215) | 13 | 1 | 9 | 28858 | 36 | |||
| 109720 | 179566 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998660.62804 | 2088348.62653 | 37.7141308458255 | -122.446518856356 | (37.7141308458255, -122.446518856356) | 9 | 7 | 6 | 28861 | 25 | |||
| 113335 | 136535 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2040 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001921.86188 | 2115620.94722 | 37.7891998651308 | -122.43719831957 | (37.7891998651308, -122.43719831957) | 13 | 6 | 1 | 29490 | 27 | |||
| 114269 | 245227 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 98 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008059.54511 | 2107998.03591 | 37.7686161569496 | -122.415422738079 | (37.7686161569496, -122.415422738079) | 8 | 4 | 7 | 28853 | 19 | |||
| 114375 | 245317 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 27 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007465.76177 | 2099909.95218 | 37.7463747454909 | -122.416903477225 | (37.7463747454909, -122.416903477225) | 2 | 7 | 7 | 28859 | 2 | |||
| 119832 | 179616 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009268.03343 | 2094013.46046 | 37.7302854702824 | -122.410255158964 | (37.7302854702824, -122.410255158964) | 9 | 3 | 7 | 309 | 28 | |||
| 120263 | 245316 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 25 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007435.2237 | 2099895.51997 | 37.74633340008 | -122.417008052193 | (37.74633340008, -122.417008052193) | 2 | 7 | 7 | 28859 | 2 | |||
| 124296 | 240967 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 35 Yukon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000255.31136 | 2104748.51733 | 37.7592520497548 | -122.442183577333 | (37.7592520497548, -122.442183577333) | 2 | 4 | 5 | 28862 | 3 | |||
| 125078 | 197779 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012297.04253 | 2105129.1602 | 37.7609761265741 | -122.400563933278 | (37.7609761265741, -122.400563933278) | 10 | 3 | 8 | 28856 | 29 | |||
| 132411 | 142874 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1168 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006878.7832 | 2114929.3518 | 37.7875814418062 | -122.419998846029 | (37.7875814418062, -122.419998846029) | 13 | 9 | 10 | 28858 | 21 | |||
| 133051 | 143134 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2680 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999570.169 | 2119147.3407 | 37.7987484465527 | -122.445588545421 | (37.7987484465527, -122.445588545421) | 13 | 9 | 1 | 57 | 17 | |||
| 136249 | 215148 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.31225 | 2091770.42438 | 37.723304920868 | -122.46011615966 | (37.723304920868, -122.46011615966) | 9 | 8 | 4 | 28861 | 24 | |||
| 137514 | 215140 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993993.45625 | 2094092.45584 | 37.7296343278608 | -122.463066769619 | (37.7296343278608, -122.463066769619) | 9 | 8 | 4 | 59 | 40 | |||
| 139234 | 142892 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1107 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006862.6408 | 2114709.6747 | 37.7869773530396 | -122.420039100076 | (37.7869773530396, -122.420039100076) | 13 | 9 | 10 | 28858 | 21 | |||
| 140967 | 240874 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3398 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007232.87313 | 2100916.28761 | 37.7491248129683 | -122.417780100367 | (37.7491248129683, -122.417780100367) | 2 | 4 | 7 | 28859 | 19 | |||
| 142415 | 245240 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 812 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009884.83098 | 2104450.7237 | 37.7589784688124 | -122.408858889543 | (37.7589784688124, -122.408858889543) | 2 | 4 | 7 | 28859 | 19 | |||
| 143104 | 240864 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6005262.73764 | 2098352.29949 | 37.7419736207821 | -122.424410513158 | (37.7419736207821, -122.424410513158) | 2 | 7 | 5 | 63 | 7 | |||
| 147514 | 245244 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 782335 | 6009944.72353 | 2104090.22905 | 37.7579919862624 | -122.408626321254 | (37.7579919862624, -122.408626321254) | 2 | 4 | 7 | 28859 | 19 | ||
| 151259 | 142855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 POLK ST | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006830.2557 | 2115271.8515 | 37.7885191274317 | -122.420191058967 | (37.7885191274317, -122.420191058967) | 13 | 9 | 10 | 28858 | 21 | |||
| 151851 | 240873 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3380 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007261.21183 | 2100917.49709 | 37.7491297286549 | -122.417682190283 | (37.7491297286549, -122.417682190283) | 2 | 4 | 7 | 28859 | 19 | |||
| 154056 | 142828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006688.3534 | 2116294.0087 | 37.7913177213638 | -122.420754614076 | (37.7913177213638, -122.420754614076) | 13 | 9 | 10 | 28858 | 21 | |||
| 154589 | 59260 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1990 12:00:00 AM | 8 | Permit Number 28432 | 6006768.1927 | 2115720.7306 | 37.7897481413543 | -122.420437662151 | (37.7897481413543, -122.420437662151) | 13 | 9 | 10 | 28858 | 21 | ||
| 154629 | 215172 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 24 Arroyo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998696.48615 | 2097465.41857 | 37.7391654760043 | -122.447050603021 | (37.7391654760043, -122.447050603021) | 9 | 7 | 4 | 59 | 40 |
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) );