trees
227 rows where qSpecies_id = 137 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 54536 | 186651 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1401 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984693.4179 | 2105580.4538 | 37.7606371377004 | -122.49606469199 | (37.7606371377004, -122.49606469199) | 1 | 8 | 3 | 56 | 35 | |||
| 55279 | 185636 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2100 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985071.7503 | 2100410.0086 | 37.7464626714536 | -122.49437509339 | (37.7464626714536, -122.49437509339) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 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 | |||
| 67349 | 181510 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1400 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.096 | 2105522.4031 | 37.7604875665076 | -122.495480496405 | (37.7604875665076, -122.495480496405) | 1 | 8 | 3 | 56 | 35 | |||
| 68316 | 212838 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 200 Thrift St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994980.89281 | 2089655.7396 | 37.7175090007103 | -122.459331949933 | (37.7175090007103, -122.459331949933) | 9 | 8 | 6 | 28861 | 24 | |||
| 68473 | 184981 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2701 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985000.4471 | 2096704.3477 | 37.7362837528235 | -122.494348542747 | (37.7362837528235, -122.494348542747) | 1 | 8 | 3 | 29491 | 35 | |||
| 69782 | 185391 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2300 Sunset Blvd | 2 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985125.1292 | 2098935.9595 | 37.7424184556167 | -122.494081895619 | (37.7424184556167, -122.494081895619) | 1 | 8 | 3 | 29491 | 35 | |||
| 77079 | 184345 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1251 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984653.0421 | 2106395.6187 | 37.7628729870585 | -122.496264477961 | (37.7628729870585, -122.496264477961) | 1 | 8 | 3 | 56 | 35 | |||
| 78721 | 186644 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1401 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984678.2391 | 2105602.2274 | 37.7606960328513 | -122.496118794235 | (37.7606960328513, -122.496118794235) | 1 | 8 | 3 | 56 | 35 | |||
| 89572 | 184767 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1301 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984672.983 | 2106076.3882 | 37.7619976377511 | -122.496171956525 | (37.7619976377511, -122.496171956525) | 1 | 8 | 3 | 56 | 35 | |||
| 94155 | 185649 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2100 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985036.6757 | 2100513.5002 | 37.7467447785095 | -122.494504003519 | (37.7467447785095, -122.494504003519) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 98700 | 185344 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2601 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985013.8462 | 2096976.5182 | 37.7370318443686 | -122.494322273015 | (37.7370318443686, -122.494322273015) | 1 | 8 | 3 | 29491 | 35 | |||
| 101210 | 186659 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1401 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984689.126 | 2105565.0657 | 37.7605946348949 | -122.49607840021 | (37.7605946348949, -122.49607840021) | 1 | 8 | 3 | 56 | 35 | |||
| 105673 | 186861 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2700 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985166.3388 | 2096333.6885 | 37.735275728405 | -122.493747689303 | (37.735275728405, -122.493747689303) | 1 | 8 | 3 | 29491 | 35 | |||
| 112938 | 181329 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2319 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985969.5551 | 2098866.9103 | 37.7422782396138 | -122.491157084664 | (37.7422782396138, -122.491157084664) | 1 | 8 | 3 | 29491 | 35 | |||
| 115058 | 97111 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1345 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 18860 | 5989755.1906 | 2103082.2788 | 37.7540729950022 | -122.478375828714 | (37.7540729950022, -122.478375828714) | 1 | 8 | 3 | 56 | 35 | |||
| 120673 | 181957 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2535 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985299.9029 | 2098842.7977 | 37.7421728835811 | -122.493470726805 | (37.7421728835811, -122.493470726805) | 1 | 8 | 3 | 29491 | 35 | |||
| 125681 | 187099 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2600 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985139.4759 | 2097198.6331 | 37.7376490636696 | -122.493904285092 | (37.7376490636696, -122.493904285092) | 1 | 8 | 3 | 29491 | 35 | |||
| 137804 | 212845 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 459 Victoria St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993232.29814 | 2090226.8914 | 37.7189765558014 | -122.465417457153 | (37.7189765558014, -122.465417457153) | 9 | 8 | 6 | 64 | 24 | |||
| 138195 | 185350 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2601 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984986.2105 | 2096968.1437 | 37.7370072329217 | -122.494417203499 | (37.7370072329217, -122.494417203499) | 1 | 8 | 3 | 29491 | 35 | |||
| 142846 | 185655 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2100 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985067.4201 | 2100539.4813 | 37.7468179148505 | -122.494399608839 | (37.7468179148505, -122.494399608839) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 149952 | 184772 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1301 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984713.9927 | 2106010.1272 | 37.7618181056778 | -122.496025233532 | (37.7618181056778, -122.496025233532) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |
| 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 | |||
| 159306 | 181956 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2453 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 01:39:00 PM | 1 | 3x3 | 5985572.3325 | 2098853.6272 | 37.7422185507809 | -122.492529560952 | (37.7422185507809, -122.492529560952) | 1 | 8 | 3 | 29491 | 35 | ||
| 161293 | 184980 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2701 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984983.2794 | 2096716.9095 | 37.736317239467 | -122.494408823427 | (37.736317239467, -122.494408823427) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 164250 | 181518 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1400 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984884.7668 | 2105589.5167 | 37.7606732277268 | -122.495403580994 | (37.7606732277268, -122.495403580994) | 1 | 8 | 3 | 56 | 35 | |||
| 169710 | 181327 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2150 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986507.3073 | 2098951.8542 | 37.7425428781244 | -122.489303971831 | (37.7425428781244, -122.489303971831) | 1 | 8 | 3 | 29491 | 35 | |||
| 170102 | 185282 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2601 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984972.4973 | 2097422.3543 | 37.7382535709623 | -122.494498088839 | (37.7382535709623, -122.494498088839) | 1 | 8 | 3 | 29491 | 35 | |||
| 180217 | 184978 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2701 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985013.0088 | 2096731.1461 | 37.7363580691948 | -122.494307087101 | (37.7363580691948, -122.494307087101) | 1 | 8 | 3 | 29491 | 35 | |||
| 187216 | 186617 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1501 Sunset Blvd | 88 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984770.9865 | 2104379.1354 | 37.757343195198 | -122.495707807467 | (37.757343195198, -122.495707807467) | 1 | 8 | 3 | 56 | 35 | |||
| 194019 | 186693 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1401 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984710.8996 | 2105238.1471 | 37.7596982830602 | -122.495978978324 | (37.7596982830602, -122.495978978324) | 1 | 8 | 3 | 56 | 35 | |||
| 54308 | 139153 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1881 POST ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003212.5485 | 2114113.5137 | 37.785134118902 | -122.432624984211 | (37.785134118902, -122.432624984211) | 13 | 9 | 11 | 29490 | 13 | |||
| 59503 | 139139 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1730 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003434.4937 | 2113953.4325 | 37.7847071603703 | -122.43184568934 | (37.7847071603703, -122.43184568934) | 13 | 9 | 11 | 29490 | 13 | |||
| 78529 | 106982 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1737-1795 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 6003656.2329 | 2114175.7467 | 37.7853301466286 | -122.431094418652 | (37.7853301466286, -122.431094418652) | 13 | 9 | 11 | 29490 | 13 | ||||
| 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 | |||
| 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 | |
| 186257 | 212839 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 310 Orizaba Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994040.72446 | 2088804.9905 | 37.7151189471444 | -122.46251998093 | (37.7151189471444, -122.46251998093) | 9 | 8 | 6 | 28861 | 24 | |||
| 87110 | 8436 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.7846989264368 | -122.431920527552 | (37.7846989264368, -122.431920527552) | 13 | 9 | 11 | 29490 | 13 | ||
| 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 | |||
| 16884 | 16968 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 767 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003330.7652 | 2109962.2092 | 37.7737423751934 | -122.431919463762 | (37.7737423751934, -122.431919463762) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 38699 | 8434 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1730 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 12 | 3X3 | 6003465.1068 | 2113959.1725 | 37.7847246563017 | -122.4317401882 | (37.7847246563017, -122.4317401882) | 13 | 9 | 11 | 29490 | 13 | ||
| 58766 | 18262 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003118.20929 | 2114097.17273 | 37.785083900253 | -122.432950200318 | (37.785083900253, -122.432950200318) | 13 | 9 | 11 | 29490 | 13 | |||
| 84967 | 18263 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003138.05675 | 2114098.29377 | 37.7850881040741 | -122.432881614516 | (37.7850881040741, -122.432881614516) | 13 | 9 | 11 | 29490 | 13 | |||
| 89607 | 18267 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003219.29534 | 2114110.16008 | 37.7851252933223 | -122.432601402633 | (37.7851252933223, -122.432601402633) | 13 | 9 | 11 | 29490 | 13 | |||
| 91657 | 18250 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1825 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003354.45468 | 2114131.31985 | 37.7851910566456 | -122.432135305453 | (37.7851910566456, -122.432135305453) | 13 | 9 | 11 | 29490 | 13 | |||
| 108122 | 18224 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1675 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004164.0306229 | 2114246.6470389 | 37.7855535827521 | -122.429342650039 | (37.7855535827521, -122.429342650039) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 113921 | 18266 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003196.88425 | 2114105.80464 | 37.7851120634301 | -122.432678626713 | (37.7851120634301, -122.432678626713) | 13 | 9 | 11 | 29490 | 13 | |||
| 134366 | 18264 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003157.16728 | 2114102.73742 | 37.7851013891075 | -122.432815815695 | (37.7851013891075, -122.432815815695) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 143950 | 18265 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003117.8494065 | 2114102.4449837 | 37.785098356117 | -122.432951822199 | (37.785098356117, -122.432951822199) | 13 | 9 | 11 | 29490 | 13 | |||
| 154406 | 18251 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1825 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003359.8742 | 2114137.1113 | 37.7852072657709 | -122.432116969328 | (37.7852072657709, -122.432116969328) | 13 | 9 | 11 | 29490 | 13 | |||
| 158207 | 16924 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 508 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2005 12:00:00 AM | 12 | 3X4 | 6004451.24438 | 2110184.3203 | 37.774415694158 | -122.428059380134 | (37.774415694158, -122.428059380134) | 7 | 9 | 11 | 28852 | 10 | ||
| 165468 | 18268 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1895X Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003251.63015 | 2114115.07604 | 37.7851406249551 | -122.432489885624 | (37.7851406249551, -122.432489885624) | 13 | 9 | 11 | 29490 | 13 | |||
| 169690 | 18258 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1855 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003321.44909 | 2114132.20192 | 37.7851916072432 | -122.432249557525 | (37.7851916072432, -122.432249557525) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 31124 | 23888 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1750X Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.432646622923 | (37.7845200030062, -122.432646622923) | 13 | 9 | 11 | 29490 | 13 | |||
| 49223 | 23889 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1750X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.432646622923 | (37.7845200030062, -122.432646622923) | 13 | 9 | 11 | 29490 | 13 | |||
| 58399 | 8412 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1590X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004120.4992681 | 2114020.0804587 | 37.7849290231168 | -122.429477092496 | (37.7849290231168, -122.429477092496) | 13 | 9 | 11 | 29490 | 13 | |||
| 59941 | 8411 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1570 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711 | (37.7849669496355, -122.42916474711) | 13 | 9 | 11 | 29490 | 13 | |||
| 72229 | 139131 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1825 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003318.4189 | 2114130.7336 | 37.7851874037963 | -122.432259936138 | (37.7851874037963, -122.432259936138) | 13 | 9 | 11 | 29490 | 13 | |||
| 88633 | 18257 | Permitted Site 7 | Podocarpus macrophyllus :: Yew Pine 137 | 1855 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6003300.73239 | 2114129.45265 | 37.7851828837938 | -122.432321034429 | (37.7851828837938, -122.432321034429) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 191708 | 8413 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 1590X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004120.4992681 | 2114020.0804587 | 37.7849290231168 | -122.429477092496 | (37.7849290231168, -122.429477092496) | 13 | 9 | 11 | 29490 | 13 | |||
| 191755 | 16926 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 514 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004391.58115 | 2110176.00513 | 37.774389487009 | -122.428265173812 | (37.774389487009, -122.428265173812) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 105380 | 183425 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2419 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5989496.7834 | 2098879.0494 | 37.7425170290149 | -122.4789620354 | (37.7425170290149, -122.4789620354) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 |
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) );