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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53954 | 53954 | 47883 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1422 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 5 | Permit Number 45630 | 5982178.8025 | 2105387.2339 | 37.7599590039895 | -122.504747143589 | (37.7599590039895, -122.504747143589) | |
| 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) | |||
| 96576 | 96576 | 115405 | Planning Code 138.1 required 4 | Podocarpus macrophyllus :: Yew Pine 168 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969.0 | 2101168.0 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | ||
| 161191 | 161191 | 184192 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1426 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5984302.3594 | 2105559.8646 | 37.7605576926871 | -122.497415645594 | (37.7605576926871, -122.497415645594) | |||
| 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) | |||
| 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) | |||
| 28162 | 28162 | 186644 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984678.2391 | 2105602.2274 | 37.76069603285129 | -122.496118794235 | (37.7606960328513, -122.496118794235) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 33293 | 33293 | 186732 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.9467 | 2106397.7058 | 37.762891830958296 | -122.49549023544701 | (37.7628918309583, -122.495490235447) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 152791 | 152791 | 185391 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985125.1292 | 2098935.9595 | 37.7424184556167 | -122.49408189561899 | (37.7424184556167, -122.494081895619) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 11253 | 11253 | 93439 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2545 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985279.5976 | 2098843.1362 | 37.7421726252091 | -122.49354096012199 | (37.7421726252091, -122.493540960122) | ||
| 25018 | 25018 | 181957 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2535 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985299.9029 | 2098842.7977 | 37.7421728835811 | -122.493470726805 | (37.7421728835811, -122.493470726805) | |||
| 127772 | 127772 | 93440 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2545 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985345.0 | 2098863.0 | 37.7422309915573 | -122.49331628538499 | (37.7422309915573, -122.493316285385) | ||
| 11939 | 11939 | 93441 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2453 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985552.0272 | 2098851.9351 | 37.7422127174882 | -122.492599644801 | (37.7422127174882, -122.492599644801) | ||
| 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) | |||
| 122182 | 122182 | 93442 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2441 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:39:00 PM | 3 | 3x3 | 5985592.0 | 2098836.3 | 37.742172124856204 | -122.49246028206998 | (37.7421721248562, -122.49246028207) | ||
| 11517 | 11517 | 93438 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2414 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985694.7566 | 2098925.7957 | 37.7424238632874 | -122.492111574827 | (37.7424238632874, -122.492111574827) | ||
| 10719 | 10719 | 93437 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2408 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985715.4003 | 2098924.442 | 37.7424213531218 | -122.492040096469 | (37.7424213531218, -122.492040096469) | ||
| 12982 | 12982 | 93443 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2409 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985719.2076 | 2098858.0267 | 37.742239217096795 | -122.492022043353 | (37.7422392170968, -122.492022043353) | ||
| 10303 | 10303 | 93436 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2404 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5985728.5988 | 2098924.1036 | 37.7424211954642 | -122.491994435754 | (37.7424211954642, -122.491994435754) | ||
| 12625 | 12625 | 93444 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2401 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985736.1286 | 2098858.7036 | 37.74224206476121 | -122.491963586408 | (37.7422420647612, -122.491963586408) | ||
| 28292 | 28292 | 181330 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2343 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985852.7996 | 2098862.8492 | 37.7422602664155 | -122.49156048482901 | (37.7422602664155, -122.491560484829) | |||
| 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) | ||
| 12449 | 12449 | 93447 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2337 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985896.456 | 2098863.5261 | 37.742264676187 | -122.491409586353 | (37.742264676187, -122.491409586353) | ||
| 66471 | 66471 | 181329 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2319 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985969.5551 | 2098866.9103 | 37.742278239613796 | -122.491157084664 | (37.7422782396138, -122.491157084664) | |||
| 101570 | 101570 | 93445 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2343 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5985970.8 | 2098880.2 | 37.7423148023054 | -122.49115375806299 | (37.7423148023054, -122.491153758063) | ||
| 13132 | 13132 | 93433 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2306 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986025.3947 | 2098937.9789 | 37.7424766373979 | -122.490969239699 | (37.7424766373979, -122.490969239699) | ||
| 70845 | 70845 | 93449 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2301x Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986031.0 | 2098812.3 | 37.7421318842811 | -122.490940612353 | (37.7421318842811, -122.490940612353) | ||
| 11158 | 11158 | 93435 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2302 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986039.9468 | 2098937.3019999997 | 37.742475628974205 | -122.490918873767 | (37.7424756289742, -122.490918873767) | ||
| 143362 | 143362 | 93448 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2319X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986046.0 | 2098887.0 | 37.7423378667916 | -122.490894243278 | (37.7423378667916, -122.490894243278) | ||
| 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) | ||
| 10945 | 10945 | 93434 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986059.5753 | 2098939.671 | 37.742483280315 | -122.490851179477 | (37.742483280315, -122.490851179477) | ||
| 11014 | 11014 | 93432 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2244 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986188.6832 | 2098942.886 | 37.7424996493843 | -122.49040500535 | (37.7424996493843, -122.49040500535) | ||
| 12231 | 12231 | 93450 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2239 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986205.0967 | 2098876.0477 | 37.7423170879313 | -122.49034333731599 | (37.7423170879313, -122.490343337316) | ||
| 11010 | 11010 | 93431 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2240 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986207.6348 | 2098941.1939 | 37.742496110202296 | -122.49033935278798 | (37.7424961102023, -122.490339352788) | ||
| 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) | ||
| 11256 | 11256 | 93430 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2226 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986248.2454 | 2098943.2244 | 37.742504057158996 | -122.490199084637 | (37.742504057159, -122.490199084637) | ||
| 10956 | 10956 | 93428 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2222 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:36:00 PM | 3 | 3x3 | 5986281.7492 | 2098944.9165 | 37.7425106597816 | -122.490083364444 | (37.7425106597816, -122.490083364444) | ||
| 89147 | 89147 | 93429 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2222 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986343.0 | 2098927.0 | 37.742465042516706 | -122.489870262796 | (37.7424650425167, -122.489870262796) | ||
| 12150 | 12150 | 93452 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2149 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2015 01:35:00 PM | 3 | 3x3 | 5986481.2489 | 2098884.5082 | 37.742356442825105 | -122.489389122116 | (37.7423564428251, -122.489389122116) | ||
| 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) | ||
| 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) | |||
| 10611 | 10611 | 93426 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2150 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986519.4905 | 2098952.531 | 37.7425454476092 | -122.489261896232 | (37.7425454476092, -122.489261896232) | ||
| 12074 | 12074 | 93453 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2139 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986521.8595 | 2098886.5388 | 37.7423643889255 | -122.489248854134 | (37.7423643889255, -122.489248854134) | ||
| 12101 | 12101 | 93425 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2122 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986588.0209 | 2098955.4076 | 37.7425573460454 | -122.489025152899 | (37.7425573460454, -122.489025152899) | ||
| 12949 | 12949 | 93454 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5986642.3376 | 2098891.6151 | 37.742385358930996 | -122.488832656 | (37.742385358931, -122.488832656) | ||
| 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) | ||
| 11519 | 11519 | 93424 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2100 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986662.1353 | 2098956.0844 | 37.7425635298153 | -122.488768940253 | (37.7425635298153, -122.488768940253) | ||
| 136460 | 136460 | 250723 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987051.3666 | 2114432.8618400004 | 37.7850811931768 | -122.48856037238501 | (37.7850811931768, -122.488560372385) | |||
| 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) | |||
| 25462 | 25462 | 250940 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987097.72783 | 2114420.3103099996 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 166626 | 166626 | 250938 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 239 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987099.7017 | 2114350.08641 | 37.7848567358866 | -122.48838706491101 | (37.7848567358866, -122.488387064911) | |||
| 10782 | 10782 | 93456 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2039 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:33:00 PM | 3 | 3x3 | 5986815.2712 | 2098896.6914 | 37.7424093879903 | -122.488235084702 | (37.7424093879903, -122.488235084702) | ||
| 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) | ||
| 120388 | 120388 | 93418 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1850 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:30:00 PM | 3 | 3x3 | 5987496.0 | 2098972.0 | 37.742655857366294 | -122.485886885578 | (37.7426558573663, -122.485886885578) | ||
| 11729 | 11729 | 93414 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1722 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:10:00 PM | 3 | 3x3 | 5987827.66 | 2098999.0640000002 | 37.7427494893985 | -122.484742100445 | (37.7427494893985, -122.484742100445) | ||
| 11867 | 11867 | 93415 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1716 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 06:26:00 PM | 3 | 3x3 | 5987861.1638 | 2098998.3872 | 37.7427495822889 | -122.48462620565901 | (37.7427495822889, -122.484626205659) | ||
| 10804 | 10804 | 93408 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1440 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:17:00 PM | 3 | 3x3 | 5988695.7955 | 2099025.5303 | 37.7428726808967 | -122.48174230877899 | (37.7428726808967, -122.481742308779) | ||
| 13160 | 13160 | 91380 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1421 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:27:00 PM | 3 | 3x3 | Permit Number 52077 | 5988771.9062 | 2098963.627 | 37.742707136361105 | -122.48147460973699 | (37.7427071363611, -122.481474609737) | |
| 29077 | 29077 | 91140 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 342 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52025 | 5989366.26045 | 2113048.7976 | 37.7814157473958 | -122.48045031235 | (37.7814157473958, -122.48045031235) | |
| 57339 | 57339 | 183425 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2419 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989496.7834 | 2098879.0494 | 37.7425170290149 | -122.4789620354 | (37.7425170290149, -122.4789620354) | |||
| 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) | |||
| 26085 | 26085 | 121888 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 10 17th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5990543.39906 | 2115002.75523 | 37.786849107740395 | -122.476520812684 | (37.7868491077404, -122.476520812684) | |||
| 63869 | 63869 | 121932 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 344 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990915.4532 | 2113093.93697 | 37.7816295951245 | -122.475094208069 | (37.7816295951245, -122.475094208069) | |||
| 72613 | 72613 | 212834 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2622 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991449.17538 | 2097558.9485400002 | 37.7390055522499 | -122.472115105035 | (37.7390055522499, -122.472115105035) | |||
| 124086 | 124086 | 3 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2X 12th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.57585 | 2114853.19204 | 37.7865283500331 | -122.471139790973 | (37.7865283500331, -122.471139790973) | |||
| 96882 | 96882 | 55827 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 154 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 10 | 3x3 | Permit Number 11876 | 5992447.89997 | 2114435.52315 | 37.785401918703606 | -122.469890426632 | (37.7854019187036, -122.469890426632) | |
| 39854 | 39854 | 55830 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 170 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 7 | Permit Number 11879 | 5992452.285209999 | 2114337.35562 | 37.7851326311765 | -122.469868105299 | (37.7851326311765, -122.469868105299) | ||
| 47982 | 47982 | 212845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 459 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993232.298140001 | 2090226.8914 | 37.7189765558014 | -122.465417457153 | (37.7189765558014, -122.465417457153) |
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");