Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173730 | 173730 | 186617 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1501 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984770.9865 | 2104379.1354 | 37.757343195198004 | -122.495707807467 | (37.757343195198, -122.495707807467) | |||
| 171874 | 171874 | 185357 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 82 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.8956 | 2096938.833 | 37.736928958988706 | -122.494284751295 | (37.7369289589887, -122.494284751295) | |||
| 50110 | 50110 | 181518 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984884.7668 | 2105589.5167 | 37.7606732277268 | -122.495403580994 | (37.7606732277268, -122.495403580994) | |||
| 166583 | 166583 | 185350 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984986.2105 | 2096968.1437 | 37.737007232921705 | -122.494417203499 | (37.7370072329217, -122.494417203499) | |||
| 38450 | 38450 | 181510 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.096 | 2105522.4031 | 37.7604875665076 | -122.495480496405 | (37.7604875665076, -122.495480496405) | |||
| 72632 | 72632 | 185344 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985013.8462 | 2096976.5182 | 37.7370318443686 | -122.494322273015 | (37.7370318443686, -122.494322273015) | |||
| 28979 | 28979 | 181504 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984912.3363 | 2105486.7577 | 37.76039269442371 | -122.49530065358499 | (37.7603926944237, -122.495300653585) | |||
| 60069 | 60069 | 186693 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984710.8996 | 2105238.1471 | 37.7596982830602 | -122.49597897832399 | (37.7596982830602, -122.495978978324) | |||
| 69316 | 69316 | 186690 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984746.4911 | 2105269.5514 | 37.759786595015704 | -122.495858203478 | (37.7597865950157, -122.495858203478) | |||
| 159211 | 159211 | 185655 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985067.4201 | 2100539.4813 | 37.7468179148505 | -122.494399608839 | (37.7468179148505, -122.494399608839) | |||
| 148795 | 148795 | 187099 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2600 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985139.4759 | 2097198.6331 | 37.7376490636696 | -122.49390428509199 | (37.7376490636696, -122.493904285092) | |||
| 186487 | 186487 | 187098 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2600 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985154.9931 | 2097192.9905 | 37.737634478481205 | -122.49385021979401 | (37.7376344784812, -122.493850219794) | |||
| 154619 | 154619 | 187097 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2600 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985176.6232 | 2097190.6394 | 37.7376292884841 | -122.493775262101 | (37.7376292884841, -122.493775262101) | |||
| 171989 | 171989 | 184772 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984713.9927 | 2106010.1272 | 37.7618181056778 | -122.49602523353201 | (37.7618181056778, -122.496025233532) | |||
| 49722 | 49722 | 185649 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985036.6757 | 2100513.5002 | 37.746744778509495 | -122.494504003519 | (37.7467447785095, -122.494504003519) | |||
| 169930 | 169930 | 184767 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984672.982999999 | 2106076.3882 | 37.7619976377511 | -122.496171956525 | (37.7619976377511, -122.496171956525) | |||
| 43734 | 43734 | 184345 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1251 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984653.0421 | 2106395.6187 | 37.7628729870585 | -122.496264477961 | (37.7628729870585, -122.496264477961) | |||
| 84095 | 84095 | 185636 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985071.7503 | 2100410.0086 | 37.7464626714536 | -122.49437509338999 | (37.7464626714536, -122.49437509339) | |||
| 185531 | 185531 | 186659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984689.126 | 2105565.0657 | 37.7605946348949 | -122.49607840021002 | (37.7605946348949, -122.49607840021) | |||
| 147634 | 147634 | 186865 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985213.5562 | 2096353.4006 | 37.735332614889 | -122.493585895767 | (37.735332614889, -122.493585895767) | |||
| 171830 | 171830 | 195952 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013787.58166 | 2092619.66724 | 37.7267107029201 | -122.39453279185801 | (37.7267107029201, -122.394532791858) | |||
| 13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 58154 | 58154 | 195951 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6013796.32813 | 2092612.6576200002 | 37.7266919421623 | -122.39450206474 | (37.7266919421623, -122.39450206474) | |||
| 160567 | 160567 | 139412 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1500 GEARY BLVD | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004126.3357 | 2114029.8613 | 37.784956209303395 | -122.429457598073 | (37.7849562093034, -122.429457598073) | |||
| 13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 69360 | 69360 | 186861 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985166.3388 | 2096333.6885 | 37.735275728405 | -122.49374768930299 | (37.735275728405, -122.493747689303) | |||
| 31080 | 31080 | 185629 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985036.4592 | 2100328.3844 | 37.746236488209796 | -122.49449110816799 | (37.7462364882098, -122.494491108168) | |||
| 181414 | 181414 | 234853 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6009779.5176 | 2105520.26331 | 37.7619092828952 | -122.40929859056101 | (37.7619092828952, -122.409298590561) | |||
| 183634 | 183634 | 195950 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013817.51149 | 2092596.07971 | 37.726647600184 | -122.394427673718 | (37.726647600184, -122.394427673718) | |||
| 46924 | 46924 | 212844 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5994040.98422 | 2088821.4693599998 | 37.7151642091297 | -122.462520277695 | (37.7151642091297, -122.462520277695) | |||
| 66894 | 66894 | 186651 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984693.4179 | 2105580.4538 | 37.7606371377004 | -122.49606469199 | (37.7606371377004, -122.49606469199) | |||
| 148292 | 148292 | 186859 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985212.8685 | 2096324.2909 | 37.7352526471755 | -122.493586129136 | (37.7352526471755, -122.493586129136) | |||
| 40541 | 40541 | 234849 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005763.2044 | 2103470.66995 | 37.756055741406996 | -122.423043772075 | (37.756055741407, -122.423043772075) | |||
| 60963 | 60963 | 212843 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5994040.90601 | 2088817.74043 | 37.7151539658718 | -122.46252027770001 | (37.7151539658718, -122.4625202777) | |||
| 118975 | 118975 | 18268 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003251.63015 | 2114115.07604 | 37.7851406249551 | -122.43248988562401 | (37.7851406249551, -122.432489885624) | |||
| 137028 | 137028 | 184981 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985000.4471 | 2096704.3477 | 37.7362837528235 | -122.494348542747 | (37.7362837528235, -122.494348542747) | |||
| 148572 | 148572 | 135659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5997134.75197 | 2115094.07357 | 37.7874799260983 | -122.453722981751 | (37.7874799260983, -122.453722981751) | |||
| 152493 | 152493 | 185282 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984972.4973 | 2097422.3543 | 37.73825357096229 | -122.494498088839 | (37.7382535709623, -122.494498088839) | |||
| 154226 | 154226 | 195949 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6013845.649730001 | 2092576.4103400002 | 37.72659515624 | -122.394329023477 | (37.72659515624, -122.394329023477) | |||
| 175065 | 175065 | 244282 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 563 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004300.7385 | 2110098.3052 | 37.7741710014741 | -122.42857387592699 | (37.7741710014741, -122.428573875927) | |||
| 41538 | 41538 | 184980 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984983.2794 | 2096716.9095 | 37.736317239467 | -122.494408823427 | (37.736317239467, -122.494408823427) | |||
| 53631 | 53631 | 244281 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 565 Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004280.5399 | 2110094.8567 | 37.7741603896423 | -122.42864350060499 | (37.7741603896423, -122.428643500605) | |||
| 56065 | 56065 | 139135 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003465.1068 | 2114153.0556 | 37.785257010462 | -122.43175403601299 | (37.785257010462, -122.431754036013) | |||
| 64254 | 64254 | 212842 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994041.05729 | 2088814.44589 | 37.715144928561294 | -122.462519515984 | (37.7151449285613, -122.462519515984) | |||
| 83387 | 83387 | 23889 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1750X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.43264662292299 | (37.7845200030062, -122.432646622923) | |||
| 92742 | 92742 | 18267 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003219.29534 | 2114110.16008 | 37.785125293322295 | -122.432601402633 | (37.7851252933223, -122.432601402633) | |||
| 135191 | 135191 | 135658 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5997134.258640001 | 2115099.71452 | 37.7874953863614 | -122.453725096057 | (37.7874953863614, -122.453725096057) | |||
| 188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) | |||
| 34940 | 34940 | 244280 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 575 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004261.3266 | 2110092.3934 | 37.77415253865129 | -122.42870978718099 | (37.7741525386513, -122.428709787181) | |||
| 35036 | 35036 | 212841 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994040.99289 | 2088811.375 | 37.7151364929198 | -122.46251951595801 | (37.7151364929198, -122.462519515958) | |||
| 35353 | 35353 | 234848 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005792.82845 | 2103474.22766 | 37.7560671816819 | -122.42294157491999 | (37.7560671816819, -122.42294157492) | |||
| 93139 | 93139 | 18222 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1643X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6004309.242075901 | 2114268.2781924 | 37.7856211964399 | -122.428841803498 | (37.7856211964399, -122.428841803498) | ||
| 98507 | 98507 | 18266 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003196.88425 | 2114105.80464 | 37.7851120634301 | -122.43267862671301 | (37.7851120634301, -122.432678626713) | |||
| 127916 | 127916 | 23888 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1750X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.43264662292299 | (37.7845200030062, -122.432646622923) | |||
| 156075 | 156075 | 135657 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5997133.32261 | 2115106.1258900003 | 37.7875129366126 | -122.453728797662 | (37.7875129366126, -122.453728797662) | |||
| 174475 | 174475 | 250944 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987098.95404 | 2114369.2776099998 | 37.784909385797796 | -122.48839106242501 | (37.7849093857978, -122.488391062425) | |||
| 174573 | 174573 | 139154 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003238.0594 | 2114116.0648 | 37.7851425702811 | -122.432536906804 | (37.7851425702811, -122.432536906804) | |||
| 22581 | 22581 | 16398 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006124.74935 | 2114015.2727900003 | 37.7850290954547 | -122.422542679726 | (37.7850290954547, -122.422542679726) | ||
| 35616 | 35616 | 185394 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985078.642000001 | 2098945.9568 | 37.7424431852403 | -122.494243368761 | (37.7424431852403, -122.494243368761) | |||
| 37473 | 37473 | 184978 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985013.0088 | 2096731.1461 | 37.7363580691948 | -122.494307087101 | (37.7363580691948, -122.494307087101) | |||
| 49412 | 49412 | 139153 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003212.5485 | 2114113.5137 | 37.785134118902 | -122.432624984211 | (37.785134118902, -122.432624984211) | |||
| 71138 | 71138 | 30700 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34612 | 6005310.6159 | 2110107.7982 | 37.7742541659126 | -122.425081203232 | (37.7742541659126, -122.425081203232) | |
| 90439 | 90439 | 8411 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1570 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | |||
| 114048 | 114048 | 18265 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003117.8494065 | 2114102.4449837 | 37.785098356117004 | -122.432951822199 | (37.785098356117, -122.432951822199) | |||
| 125568 | 125568 | 250943 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987098.9521 | 2114387.30266 | 37.784958877305 | -122.488392394293 | (37.784958877305, -122.488392394293) | |||
| 132650 | 132650 | 212840 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5994040.889169999 | 2088808.5139 | 37.7151286310473 | -122.462519667047 | (37.7151286310473, -122.462519667047) | |||
| 167550 | 167550 | 135661 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3130 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5999056.0318599995 | 2119564.3251400003 | 37.7998640079851 | -122.447397647785 | (37.7998640079851, -122.447397647785) | |||
| 2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
| 10492 | 10492 | 93427 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2150 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986487.6789 | 2098952.531 | 37.7425435906318 | -122.48937188989099 | (37.7425435906318, -122.489371889891) | ||
| 22771 | 22771 | 16397 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006110.1202 | 2114012.78935 | 37.785021451230705 | -122.422593115487 | (37.7850214512307, -122.422593115487) | ||
| 26992 | 26992 | 212838 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 200 Thrift St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5994980.89281 | 2089655.7396 | 37.717509000710294 | -122.45933194993299 | (37.7175090007103, -122.459331949933) | |||
| 29398 | 29398 | 212839 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5994040.72446 | 2088804.9905 | 37.7151189471444 | -122.46251998093 | (37.7151189471444, -122.46251998093) | |||
| 30095 | 30095 | 139152 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003164.7154 | 2114107.1359 | 37.7851138943196 | -122.432790015912 | (37.7851138943196, -122.432790015912) | |||
| 43887 | 43887 | 72500 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2311 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1996 12:00:00 AM | 1 | 5986050.4379 | 2098869.9561 | 37.7422913280707 | -122.49087764471001 | (37.7422913280707, -122.49087764471) | ||
| 62788 | 62788 | 186734 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.1357 | 2106411.4914 | 37.7629296348625 | -122.495494057173 | (37.7629296348625, -122.495494057173) | |||
| 69116 | 69116 | 250942 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987099.1476 | 2114396.50261 | 37.7849841491372 | -122.48839239429199 | (37.7849841491372, -122.488392394292) | |||
| 71601 | 71601 | 30699 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 3 | Permit Number 34612 | 6005328.8488 | 2110110.837 | 37.7742635396666 | -122.425018348522 | (37.7742635396666, -122.425018348522) | |
| 73670 | 73670 | 135656 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1920 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001020.2424800005 | 2121027.2609 | 37.8039928872331 | -122.440705754666 | (37.8039928872331, -122.440705754666) | |||
| 115725 | 115725 | 18264 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003157.167280001 | 2114102.73742 | 37.785101389107496 | -122.432815815695 | (37.7851013891075, -122.432815815695) | |||
| 123303 | 123303 | 234847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 98 Hill St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005800.09169 | 2103473.84487 | 37.756066540467295 | -122.422916428967 | (37.7560665404673, -122.422916428967) | |||
| 148492 | 148492 | 139132 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003396.2273 | 2114143.489 | 37.7852268383201 | -122.431991654473 | (37.7852268383201, -122.431991654473) | |||
| 188608 | 188608 | 139128 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1601 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004473.6733 | 2114291.0091 | 37.7856929151772 | -122.428274539531 | (37.7856929151772, -122.428274539531) | |||
| 6315 | 6315 | 18251 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003359.8742 | 2114137.1113 | 37.7852072657709 | -122.432116969328 | (37.7852072657709, -122.432116969328) | |||
| 11156 | 11156 | 93446 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2343 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985872.427999999 | 2098863.1876 | 37.7422623426363 | -122.491492641715 | (37.7422623426363, -122.491492641715) | ||
| 11200 | 11200 | 93423 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2048 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2015 12:49:00 PM | 3 | 3x3 | 5986826.7775 | 2098962.0068 | 37.7425893979873 | -122.488200098519 | (37.7425893979873, -122.488200098519) | ||
| 12217 | 12217 | 93451 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2239 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986220.3256 | 2098876.0477 | 37.742317977353395 | -122.490290681149 | (37.7423179773534, -122.490290681149) | ||
| 12639 | 12639 | 93455 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2109 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986657.5666 | 2098892.2919 | 37.7423881059963 | -122.488780049158 | (37.7423881059963, -122.488780049158) | ||
| 22586 | 22586 | 16396 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006093.31996 | 2114011.54372 | 37.7850170832184 | -122.422651150523 | (37.7850170832184, -122.422651150523) | ||
| 24985 | 24985 | 30698 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34612 | 6005345.2585 | 2110114.4836 | 37.7742744792738 | -122.42496184383499 | (37.7742744792738, -122.424961843835) | |
| 27987 | 27987 | 139151 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003144.9445 | 2114104.5849 | 37.7851057685851 | -122.43285823467801 | (37.7851057685851, -122.432858234678) | |||
| 29058 | 29058 | 181956 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2453 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985572.3325 | 2098853.6272 | 37.7422185507809 | -122.492529560952 | (37.7422185507809, -122.492529560952) | |||
| 42841 | 42841 | 178684 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009805.30528 | 2088917.07553 | 37.716321963062 | -122.40803845872401 | (37.716321963062, -122.408038458724) | |||
| 53633 | 53633 | 250941 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987099.00691 | 2114408.0109900003 | 37.785015739640606 | -122.48839372709699 | (37.7850157396406, -122.488393727097) | |||
| 57195 | 57195 | 117697 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 4049 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5982884.20475 | 2113074.25287 | 37.781106811569295 | -122.50287659442301 | (37.7811068115693, -122.502876594423) | |||
| 60903 | 60903 | 135662 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1430 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004430.55292 | 2120513.3454 | 37.802775426403606 | -122.42886748667101 | (37.8027754264036, -122.428867486671) | |||
| 62609 | 62609 | 181327 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2150 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986507.3073 | 2098951.8542 | 37.7425428781244 | -122.48930397183099 | (37.7425428781244, -122.489303971831) | |||
| 63346 | 63346 | 234845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 452 Oak St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004779.43654 | 2110228.96496 | 37.7745568400539 | -122.426927281183 | (37.7745568400539, -122.426927281183) | |||
| 65840 | 65840 | 97111 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1345 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Permit Number 18860 | 5989755.1906 | 2103082.2788 | 37.754072995002204 | -122.47837582871401 | (37.7540729950022, -122.478375828714) | |||
| 72379 | 72379 | 250724 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987063.6250599995 | 2114433.2112 | 37.7850828677123 | -122.488517988217 | (37.7850828677123, -122.488517988217) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");