trees
227 rows where qSpecies_id = 137 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14110 | 195949 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1700 Bancroft Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6013845.64973 | 2092576.41034 | 37.72659515624 | -122.394329023477 | (37.72659515624, -122.394329023477) | 10 | 3 | 8 | 58 | 1 | |||
| 62367 | 195950 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1700 Bancroft Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6013817.51149 | 2092596.07971 | 37.726647600184 | -122.394427673718 | (37.726647600184, -122.394427673718) | 10 | 3 | 8 | 58 | 1 | |||
| 81354 | 38212 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 108 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40335 | 6011170.86801 | 2092548.53605 | 37.7263695720899 | -122.403573737557 | (37.7263695720899, -122.403573737557) | 10 | 3 | 7 | 309 | 28 |
| 83597 | 195951 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1700 Bancroft Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6013796.32813 | 2092612.65762 | 37.7266919421623 | -122.39450206474 | (37.7266919421623, -122.39450206474) | 10 | 3 | 8 | 58 | 1 | |||
| 163062 | 195952 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1700 Bancroft Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6013787.58166 | 2092619.66724 | 37.7267107029201 | -122.394532791858 | (37.7267107029201, -122.394532791858) | 10 | 3 | 8 | 58 | 1 | |||
| 60799 | 234847 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 98 Hill St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005800.09169 | 2103473.84487 | 37.7560665404673 | -122.422916428967 | (37.7560665404673, -122.422916428967) | 2 | 4 | 5 | 28859 | 19 | |||
| 63708 | 234852 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 590 York St | 6 | : | Tree | Private 2 | 6 | Width 2ft | 6009778.46002 | 2105547.19964 | 37.7619831846864 | -122.409304149278 | (37.7619831846864, -122.409304149278) | 8 | 4 | 8 | 28859 | 19 | |||
| 86901 | 122722 | Undocumented 4 | Podocarpus macrophyllus :: Yew Pine 137 | 1385 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007219 | 2107431 | 37.7670119303162 | -122.418289913576 | (37.7670119303162, -122.418289913576) | 8 | 4 | 7 | 28853 | 19 | |||
| 98567 | 234849 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 98 Hill St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005763.2044 | 2103470.66995 | 37.756055741407 | -122.423043772075 | (37.756055741407, -122.423043772075) | 2 | 4 | 5 | 28859 | 19 | |||
| 139951 | 234853 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 590 York St | 9 | : | Tree | Private 2 | 8 | Width 2ft | 6009779.5176 | 2105520.26331 | 37.7619092828952 | -122.409298590561 | (37.7619092828952, -122.409298590561) | 8 | 4 | 8 | 28859 | 19 | |||
| 146711 | 234859 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 160 Carnelian Way | 1 | : Yard | Tree | Private 2 | 8 | 6000570.21064 | 2100519.3738 | 37.7476577875765 | -122.440791137208 | (37.7476577875765, -122.440791137208) | 2 | 4 | 5 | 63 | 22 | ||||
| 150368 | 109113 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 3301x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778467 | 6007480 | 2104949 | 37.760211624256 | -122.417211256042 | (37.760211624256, -122.417211256042) | 2 | 4 | 7 | 28859 | 19 | |
| 154539 | 234846 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 98 Hill St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005812.3026 | 2103474.52838 | 37.7560691062312 | -122.422874248071 | (37.7560691062312, -122.422874248071) | 2 | 4 | 5 | 28859 | 19 | |||
| 159230 | 234848 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 98 Hill St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005792.82845 | 2103474.22766 | 37.7560671816819 | -122.42294157492 | (37.7560671816819, -122.42294157492) | 2 | 4 | 5 | 28859 | 19 | |||
| 161870 | 234860 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 160 Carnelian Way | 2 | : Yard | Tree | Private 2 | 6 | 6000574.359 | 2100517.55086 | 37.7476530184698 | -122.440776661708 | (37.7476530184698, -122.440776661708) | 2 | 4 | 5 | 63 | 22 | ||||
| 162605 | 234851 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 590 York St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6009775.07981 | 2105635.7822 | 37.7622262228849 | -122.409322091662 | (37.7622262228849, -122.409322091662) | 8 | 4 | 8 | 28859 | 19 | |||
| 163633 | 234850 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2700 18th St | 1 | : | Tree | Private 2 | 15 | Width 2ft | 6009776.57488 | 2105514.32334 | 37.7618928082166 | -122.40930834912 | (37.7618928082166, -122.40930834912) | 8 | 4 | 8 | 28859 | 19 | |||
| 17388 | 17125 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1967 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5997619.3207 | 2109172.1957 | 37.7712477652106 | -122.451619154414 | (37.7712477652106, -122.451619154414) | 15 | 5 | 11 | 29492 | 9 | |||
| 22898 | 17028 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1140 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001519.83997 | 2109777.50719 | 37.7731324020756 | -122.438170492981 | (37.7731324020756, -122.438170492981) | 15 | 5 | 11 | 29492 | 10 | |||
| 23784 | 246079 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 663 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998980.117 | 2108420.232 | 37.769260899787 | -122.446858004242 | (37.769260899787, -122.446858004242) | 15 | 5 | 11 | 29492 | 9 | |||
| 30020 | 247388 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002209.9073 | 2109723.8575 | 37.7730243156057 | -122.435779625251 | (37.7730243156057, -122.435779625251) | 15 | 5 | 11 | 29492 | 9 | |||
| 39460 | 187613 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 10 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
| 41230 | 17137 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2045 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997217.7067 | 2109114.9444 | 37.7710675601361 | -122.453004213188 | (37.7710675601361, -122.453004213188) | 15 | 5 | 11 | 29492 | 9 | |||
| 80717 | 244545 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1921 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997768.4306 | 2109193.5582 | 37.7713149592303 | -122.4511049204 | (37.7713149592303, -122.4511049204) | 15 | 5 | 11 | 29492 | 9 | |||
| 85184 | 17136 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2041 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997241.2054 | 2109118.3624 | 37.7710782917307 | -122.452923177593 | (37.7710782917307, -122.452923177593) | 15 | 5 | 11 | 29492 | 9 | |||
| 97100 | 234866 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 3781 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001808.66537 | 2106354.74749 | 37.7637507715923 | -122.436926328595 | (37.7637507715923, -122.436926328595) | 15 | 5 | 5 | 28862 | 3 | |||
| 97307 | 17119 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1931 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997738.0959 | 2109188.8584 | 37.7713003179936 | -122.451209509969 | (37.7713003179936, -122.451209509969) | 15 | 5 | 11 | 29492 | 9 | |||
| 102753 | 234865 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 152 Beaver St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6001951.81755 | 2106805.77476 | 37.7649973174046 | -122.436463493413 | (37.7649973174046, -122.436463493413) | 15 | 5 | 5 | 28862 | 3 | |||
| 109807 | 17030 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1159 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001449.2469 | 2109707.3473 | 37.7729357454464 | -122.438409655481 | (37.7729357454464, -122.438409655481) | 15 | 5 | 11 | 29492 | 9 | |||
| 115228 | 234864 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 161 Beaver St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001880.22394 | 2106835.60829 | 37.7650751645184 | -122.43671325314 | (37.7650751645184, -122.43671325314) | 15 | 5 | 5 | 28862 | 3 | |||
| 129519 | 17095 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1661 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999030.0966 | 2109360.6125 | 37.7718458009941 | -122.446752800648 | (37.7718458009941, -122.446752800648) | 15 | 5 | 11 | 29492 | 9 | |||
| 130728 | 187615 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
| 140485 | 17103 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1745 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5998656.2538 | 2109314.8969 | 37.7716989147196 | -122.448042651228 | (37.7716989147196, -122.448042651228) | 15 | 5 | 11 | 29492 | 9 | |||
| 164933 | 187614 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 11 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
| 166059 | 17101 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1711 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 5998684.4523 | 2109317.8876 | 37.7717087382881 | -122.447945326623 | (37.7717087382881, -122.447945326623) | 15 | 5 | 11 | 29492 | 9 | |||
| 167452 | 187612 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 100 Castro St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6002192 | 2107639 | 37.767298794762 | -122.435692380838 | (37.767298794762, -122.435692380838) | 15 | 5 | 5 | 28862 | 3 | ||||
| 171224 | 212847 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1269 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995455.86214 | 2106863.98273 | 37.7647858787024 | -122.458935447807 | (37.7647858787024, -122.458935447807) | 15 | 5 | 11 | 56 | 12 | |||
| 177400 | 17000 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 940 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002487.5182 | 2109913.8953 | 37.7735618775422 | -122.434832928564 | (37.7735618775422, -122.434832928564) | 15 | 5 | 11 | 29492 | 10 | |||
| 178610 | 17029 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1153 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001512.0667 | 2109715.9891 | 37.7729630466804 | -122.438192973878 | (37.7729630466804, -122.438192973878) | 15 | 5 | 11 | 29492 | 9 | |||
| 20634 | 250943 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 237 28th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987098.9521 | 2114387.30266 | 37.784958877305 | -122.488392394293 | (37.784958877305, -122.488392394293) | 11 | 6 | 1 | 55 | 33 | |||
| 21819 | 135658 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 341 Spruce St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 1ft | 5997134.25864 | 2115099.71452 | 37.7874953863614 | -122.453725096057 | (37.7874953863614, -122.453725096057) | 11 | 6 | 1 | 54 | 31 | |||
| 25753 | 250724 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2701 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5987063.62506 | 2114433.2112 | 37.7850828677123 | -122.488517988217 | (37.7850828677123, -122.488517988217) | 11 | 6 | 1 | 55 | 33 | |||
| 30635 | 3 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2X 12th Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992095.57585 | 2114853.19204 | 37.7865283500331 | -122.471139790973 | (37.7865283500331, -122.471139790973) | 11 | 6 | 1 | 54 | 11 | |||
| 33727 | 117697 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 4049 Clement St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 5982884.20475 | 2113074.25287 | 37.7811068115693 | -122.502876594423 | (37.7811068115693, -122.502876594423) | 11 | 6 | 2 | 55 | 26 | |||
| 36176 | 250723 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2701 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987051.3666 | 2114432.86184 | 37.7850811931768 | -122.488560372385 | (37.7850811931768, -122.488560372385) | 11 | 6 | 1 | 55 | 33 | |||
| 48939 | 121888 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 10 17th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5990543.39906 | 2115002.75523 | 37.7868491077404 | -122.476520812684 | (37.7868491077404, -122.476520812684) | 11 | 6 | 1 | 61 | 30 | |||
| 66038 | 250944 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 237 28th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987098.95404 | 2114369.27761 | 37.7849093857978 | -122.488391062425 | (37.7849093857978, -122.488391062425) | 11 | 6 | 1 | 55 | 33 | |||
| 75878 | 135657 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 341 Spruce St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5997133.32261 | 2115106.12589 | 37.7875129366126 | -122.453728797662 | (37.7875129366126, -122.453728797662) | 11 | 6 | 1 | 54 | 31 | |||
| 87059 | 250941 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 237 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987099.00691 | 2114408.01099 | 37.7850157396406 | -122.488393727097 | (37.7850157396406, -122.488393727097) | 11 | 6 | 1 | 55 | 33 | |||
| 93169 | 250938 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 239 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5987099.7017 | 2114350.08641 | 37.7848567358866 | -122.488387064911 | (37.7848567358866, -122.488387064911) | 11 | 6 | 1 | 55 | 33 | |||
| 94911 | 135659 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 341 Spruce St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5997134.75197 | 2115094.07357 | 37.7874799260983 | -122.453722981751 | (37.7874799260983, -122.453722981751) | 11 | 6 | 1 | 54 | 31 | |||
| 119343 | 55827 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 154 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1973 12:00:00 AM | 10 | 3x3 | Permit Number 11876 | 5992447.89997 | 2114435.52315 | 37.7854019187036 | -122.469890426632 | (37.7854019187036, -122.469890426632) | 11 | 6 | 2 | 54 | 11 | |
| 142596 | 250942 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 237 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987099.1476 | 2114396.50261 | 37.7849841491372 | -122.488392394292 | (37.7849841491372, -122.488392394292) | 11 | 6 | 1 | 55 | 33 | |||
| 142599 | 92072 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 3001 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/18/2009 12:00:00 AM | Permit Number 52188 | 5999733.7 | 2116663.4 | 37.7919375385156 | -122.444844029888 | (37.7919375385156, -122.444844029888) | 13 | 6 | 1 | 29490 | 27 | ||||
| 154391 | 91140 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 342 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52025 | 5989366.26045 | 2113048.7976 | 37.7814157473958 | -122.48045031235 | (37.7814157473958, -122.48045031235) | 11 | 6 | 2 | 55 | 26 | |
| 157253 | 250940 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5987097.72783 | 2114420.31031 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | 11 | 6 | 1 | 55 | 33 | |||
| 158843 | 55830 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 170 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1973 12:00:00 AM | 7 | Permit Number 11879 | 5992452.28521 | 2114337.35562 | 37.7851326311765 | -122.469868105299 | (37.7851326311765, -122.469868105299) | 11 | 6 | 2 | 54 | 11 | ||
| 165182 | 121932 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 344 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990915.4532 | 2113093.93697 | 37.7816295951245 | -122.475094208069 | (37.7816295951245, -122.475094208069) | 11 | 6 | 2 | 54 | 26 | |||
| 194144 | 135660 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 525 Spruce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5997107.47515 | 2114429.48514 | 37.7856535792972 | -122.453769343597 | (37.7856535792972, -122.453769343597) | 11 | 6 | 1 | 54 | 31 | |||
| 25088 | 234862 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007596.66098 | 2097957.46338 | 37.741021008521 | -122.41631257406 | (37.741021008521, -122.41631257406) | 2 | 7 | 7 | 28859 | 2 | |||
| 46760 | 234861 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 60 Zircon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6002321.72608 | 2098705.61757 | 37.7427772324719 | -122.434604832164 | (37.7427772324719, -122.434604832164) | 2 | 7 | 5 | 63 | 7 | |||
| 48748 | 234857 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 125 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007057.29918 | 2098677.05689 | 37.7429665074013 | -122.418228500567 | (37.7429665074013, -122.418228500567) | 2 | 7 | 7 | 28859 | 2 | |||
| 91275 | 122540 | Undocumented 4 | Podocarpus macrophyllus :: Yew Pine 137 | 188 Winfield St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 3x3 | 6006859 | 2098426 | 37.7422659974245 | -122.418896364118 | (37.7422659974245, -122.418896364118) | 2 | 7 | 7 | 28859 | 2 | |||
| 104614 | 234863 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 116 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007043.4928 | 2098718.44059 | 37.7430793606347 | -122.418279172852 | (37.7430793606347, -122.418279172852) | 2 | 7 | 7 | 28859 | 2 | |||
| 127871 | 39956 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 370 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 7 | Permit Number 41218 | 6009202.76969 | 2088674.77745 | 37.7156229083553 | -122.410104026979 | (37.7156229083553, -122.410104026979) | 9 | 7 | 8 | 309 | 39 | |
| 133726 | 52753 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 59@ ROLPH Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | 7 | Permit Number 48796 | 6000913.35841 | 2088160.63266 | 37.713743072553 | -122.438719109114 | (37.713743072553, -122.438719109114) | 9 | 7 | 6 | 28861 | 5 | |
| 141374 | 234858 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 115 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007085.58214 | 2098738.00871 | 37.743135459435 | -122.41813502591 | (37.743135459435, -122.41813502591) | 2 | 7 | 7 | 28859 | 2 | |||
| 145698 | 178682 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 583 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002865.41308 | 2090226.61058 | 37.7195266522017 | -122.432119544876 | (37.7195266522017, -122.432119544876) | 9 | 7 | 6 | 28861 | 5 | |||
| 146399 | 35843 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 425 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 13 | Permit Number 39070 | 6002175 | 2091114 | 37.7219240572442 | -122.434569465024 | (37.7219240572442, -122.434569465024) | 9 | 7 | 6 | 28861 | 5 | |
| 146792 | 212835 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 401 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997377.55804 | 2097039.27629 | 37.7379199482423 | -122.451580107737 | (37.7379199482423, -122.451580107737) | 9 | 7 | 4 | 59 | 40 | |||
| 170260 | 234855 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007577.52022 | 2098081.02135 | 37.7413591949664 | -122.416387505603 | (37.7413591949664, -122.416387505603) | 2 | 7 | 7 | 28859 | 2 | |||
| 175967 | 234854 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007573.33331 | 2098019.62336 | 37.7411903742509 | -122.416397634648 | (37.7411903742509, -122.416397634648) | 2 | 7 | 7 | 28859 | 2 | |||
| 176542 | 234856 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008485.30896 | 2095795.27692 | 37.7351340472973 | -122.413087094406 | (37.7351340472973, -122.413087094406) | 10 | 7 | 7 | 28859 | 2 | |||
| 749 | 72500 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2311 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5986050.4379 | 2098869.9561 | 37.7422913280707 | -122.49087764471 | (37.7422913280707, -122.49087764471) | 1 | 8 | 3 | 29491 | 35 | |||
| 3412 | 93449 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2301x Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986031 | 2098812.3 | 37.7421318842811 | -122.490940612353 | (37.7421318842811, -122.490940612353) | 1 | 8 | 3 | 29491 | 35 | ||
| 3627 | 93419 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1904 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 03:04:00 PM | 3 | 3x3 | 5987281.1088 | 2098978.4203 | 37.7426609609829 | -122.486630378914 | (37.7426609609829, -122.486630378914) | 1 | 8 | 3 | 29491 | 35 | ||
| 4950 | 47883 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1422 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 5 | Permit Number 45630 | 5982178.8025 | 2105387.2339 | 37.7599590039895 | -122.504747143589 | (37.7599590039895, -122.504747143589) | 1 | 8 | 3 | 56 | 35 | |
| 10008 | 93436 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2404 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985728.5988 | 2098924.1036 | 37.7424211954642 | -122.491994435754 | (37.7424211954642, -122.491994435754) | 1 | 8 | 3 | 29491 | 35 | ||
| 11686 | 186732 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1250 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984876.9467 | 2106397.7058 | 37.7628918309583 | -122.495490235447 | (37.7628918309583, -122.495490235447) | 1 | 8 | 3 | 56 | 35 | |||
| 16173 | 185357 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2601 Sunset Blvd | 82 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985023.8956 | 2096938.833 | 37.7369289589887 | -122.494284751295 | (37.7369289589887, -122.494284751295) | 1 | 8 | 3 | 29491 | 35 | |||
| 18181 | 212841 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 310 Orizaba Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994040.99289 | 2088811.375 | 37.7151364929198 | -122.462519515958 | (37.7151364929198, -122.462519515958) | 9 | 8 | 6 | 28861 | 24 | |||
| 18406 | 181504 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1400 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984912.3363 | 2105486.7577 | 37.7603926944237 | -122.495300653585 | (37.7603926944237, -122.495300653585) | 1 | 8 | 3 | 56 | 35 | |||
| 21649 | 185394 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2300 Sunset Blvd | 4 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985078.642 | 2098945.9568 | 37.7424431852403 | -122.494243368761 | (37.7424431852403, -122.494243368761) | 1 | 8 | 3 | 29491 | 35 | |||
| 23403 | 186859 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2700 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985212.8685 | 2096324.2909 | 37.7352526471755 | -122.493586129136 | (37.7352526471755, -122.493586129136) | 1 | 8 | 3 | 29491 | 35 | |||
| 26460 | 93440 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2545 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985345 | 2098863 | 37.7422309915573 | -122.493316285385 | (37.7422309915573, -122.493316285385) | 1 | 8 | 3 | 29491 | 35 | ||
| 27964 | 186690 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1401 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984746.4911 | 2105269.5514 | 37.7597865950157 | -122.495858203478 | (37.7597865950157, -122.495858203478) | 1 | 8 | 3 | 56 | 35 | |||
| 29105 | 181330 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2343 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985852.7996 | 2098862.8492 | 37.7422602664155 | -122.491560484829 | (37.7422602664155, -122.491560484829) | 1 | 8 | 3 | 29491 | 35 | |||
| 29171 | 212837 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 200 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995022.27605 | 2089654.87309 | 37.71750900071 | -122.459188845314 | (37.71750900071, -122.459188845314) | 9 | 8 | 6 | 28861 | 24 | |||
| 29737 | 186734 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1250 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984876.1357 | 2106411.4914 | 37.7629296348625 | -122.495494057173 | (37.7629296348625, -122.495494057173) | 1 | 8 | 3 | 56 | 35 | |||
| 32848 | 186865 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2700 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985213.5562 | 2096353.4006 | 37.735332614889 | -122.493585895767 | (37.735332614889, -122.493585895767) | 1 | 8 | 3 | 29491 | 35 | |||
| 33098 | 93427 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2150 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986487.6789 | 2098952.531 | 37.7425435906318 | -122.489371889891 | (37.7425435906318, -122.489371889891) | 1 | 8 | 3 | 29491 | 35 | ||
| 35160 | 93426 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2150 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986519.4905 | 2098952.531 | 37.7425454476092 | -122.489261896232 | (37.7425454476092, -122.489261896232) | 1 | 8 | 3 | 29491 | 35 | ||
| 37933 | 93437 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2408 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985715.4003 | 2098924.442 | 37.7424213531218 | -122.492040096469 | (37.7424213531218, -122.492040096469) | 1 | 8 | 3 | 29491 | 35 | ||
| 38657 | 187098 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2600 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985154.9931 | 2097192.9905 | 37.7376344784812 | -122.493850219794 | (37.7376344784812, -122.493850219794) | 1 | 8 | 3 | 29491 | 35 | |||
| 40134 | 185629 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2100 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985036.4592 | 2100328.3844 | 37.7462364882098 | -122.494491108168 | (37.7462364882098, -122.494491108168) | 1 | 8 | 3 | 29491 | 35 | |||
| 40147 | 93431 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2240 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986207.6348 | 2098941.1939 | 37.7424961102023 | -122.490339352788 | (37.7424961102023, -122.490339352788) | 1 | 8 | 3 | 29491 | 35 | ||
| 43017 | 212842 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 310 Orizaba Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994041.05729 | 2088814.44589 | 37.7151449285613 | -122.462519515984 | (37.7151449285613, -122.462519515984) | 9 | 8 | 6 | 28861 | 24 | |||
| 43090 | 187097 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2600 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985176.6232 | 2097190.6394 | 37.7376292884841 | -122.493775262101 | (37.7376292884841, -122.493775262101) | 1 | 8 | 3 | 29491 | 35 | |||
| 44819 | 93456 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2039 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 01:33:00 PM | 3 | 3x3 | 5986815.2712 | 2098896.6914 | 37.7424093879903 | -122.488235084702 | (37.7424093879903, -122.488235084702) | 1 | 8 | 3 | 29491 | 35 | ||
| 44907 | 93408 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1440 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 03:17:00 PM | 3 | 3x3 | 5988695.7955 | 2099025.5303 | 37.7428726808967 | -122.481742308779 | (37.7428726808967, -122.481742308779) | 1 | 8 | 3 | 29491 | 35 |
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) );