trees
1,345 rows where qLegalStatus_id = 1 and qSpecies_id = 95 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2120 | 262362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
3279 | 262361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
6235 | 261034 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2499X Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5984844 | 2098260 | 37.740545999365 | -122.495004110004 | (37.740545999365, -122.495004110004) | 1 | 8 | 3 | 29491 | 35 | ||||
39805 | 253151 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 203 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5997194 | 2107012 | 37.7652920558138 | -122.452934396642 | (37.7652920558138, -122.452934396642) | 15 | 5 | 11 | 29492 | 12 | ||||
43548 | 116682 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 21 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
69686 | 253094 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1360 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1992 12:00:00 AM | 3x3 | Permit Number 30561 | 5994899.98504 | 2106326.93315 | 37.7632793109173 | -122.460819144348 | (37.7632793109173, -122.460819144348) | 15 | 5 | 11 | 56 | 12 | ||
109060 | 254199 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 201 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5997173 | 2109816 | 37.7729899153653 | -122.453209472915 | (37.7729899153653, -122.453209472915) | 15 | 5 | 11 | 29492 | 16 | ||||
110142 | 251675 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 3x3 | Permit Number 48036 | 6001586 | 2113871 | 37.784375861656 | -122.438234943981 | (37.784375861656, -122.438234943981) | 15 | 6 | 11 | 29490 | 13 | ||
169370 | 255812 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1258 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | Permit Number 782103 | 5999099 | 2105411 | 37.7610050950906 | -122.446230300301 | (37.7610050950906, -122.446230300301) | 15 | 5 | 5 | 28862 | 3 | |||
173825 | 116683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 22 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
186383 | 251738 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | ||||
163493 | 233513 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 0 | 6005382.19397 | 2097506.55271 | 37.7396581363049 | -122.423937343859 | (37.7396581363049, -122.423937343859) | 2 | 7 | 5 | 28859 | 2 | ||||
8775 | 186544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 15 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | 1 | 8 | 3 | 56 | 35 | |||
20208 | 64478 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2463 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1988 12:00:00 AM | 1 | Permit Number 25351 | 5984544.9144 | 2098464.8556 | 37.7410909641146 | -122.496053326033 | (37.7410909641146, -122.496053326033) | 1 | 8 | 3 | 29491 | 35 | ||
25987 | 184067 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984923.6735 | 2103980.1419 | 37.7562566100874 | -122.495150341701 | (37.7562566100874, -122.495150341701) | 1 | 8 | 3 | 56 | 35 | |||
27641 | 181377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984927.8892 | 2104435.2861 | 37.7575065566558 | -122.495169324722 | (37.7575065566558, -122.495169324722) | 1 | 8 | 3 | 56 | 35 | |||
28285 | 185702 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2101 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.336 | 2100502.102 | 37.7467054432069 | -122.494978063261 | (37.7467054432069, -122.494978063261) | 1 | 8 | 3 | 29491 | 35 | |||
32019 | 233567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003041.12582 | 2099793.00501 | 37.7458037587468 | -122.432194992624 | (37.7458037587468, -122.432194992624) | 2 | 7 | 5 | 63 | 22 | |||
37072 | 185600 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5989679.3737 | 2101097.9705 | 37.7486202073052 | -122.478492924032 | (37.7486202073052, -122.478492924032) | 1 | 8 | 3 | 29491 | 35 | |||
45357 | 211399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 1 | Width 0ft | 5991315.94371 | 2093311.6752 | 37.7273358999139 | -122.472266228913 | (37.7273358999139, -122.472266228913) | 9 | 8 | 4 | 64 | 40 | |||
51215 | 139636 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 932 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000950.5576 | 2112049.201 | 37.7793375058125 | -122.440302654193 | (37.7793375058125, -122.440302654193) | 15 | 5 | 11 | 29490 | 41 | |||
58810 | 211398 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 1 | Width 0ft | 5991312.42459 | 2093316.55821 | 37.7273491037745 | -122.472278750188 | (37.7273491037745, -122.472278750188) | 9 | 8 | 4 | 64 | 40 | |||
61239 | 186542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | 1 | 8 | 3 | 56 | 35 | |||
62658 | 187285 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984971.2258 | 2098277.6369 | 37.7406018726595 | -122.49456551882 | (37.7406018726595, -122.49456551882) | 1 | 8 | 3 | 29491 | 35 | |||
63730 | 186777 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984843.8908 | 2106796.6459 | 37.7639852728391 | -122.495633989763 | (37.7639852728391, -122.495633989763) | 1 | 8 | 3 | 56 | 35 | |||
67313 | 211397 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 1 | Width 0ft | 5991314.17721 | 2093323.33427 | 37.7273678105764 | -122.47227318518 | (37.7273678105764, -122.47227318518) | 9 | 8 | 4 | 64 | 40 | |||
69363 | 184071 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984926.5971 | 2103990.3748 | 37.7562848779586 | -122.495140985597 | (37.7562848779586, -122.495140985597) | 1 | 8 | 3 | 56 | 35 | |||
70045 | 184790 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1301 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984691.969 | 2105851.7842 | 37.7613820501849 | -122.496089721203 | (37.7613820501849, -122.496089721203) | 1 | 8 | 3 | 56 | 35 | |||
70729 | 181480 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984875.577 | 2105321.3408 | 37.7599363534607 | -122.495415585101 | (37.7599363534607, -122.495415585101) | 1 | 8 | 3 | 56 | 35 | |||
72190 | 186532 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984706.503 | 2104907.5647 | 37.7587903384946 | -122.495969795836 | (37.7587903384946, -122.495969795836) | 1 | 8 | 3 | 56 | 35 | |||
72529 | 233569 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003042.82855 | 2099802.56387 | 37.7458301016873 | -122.432189787355 | (37.7458301016873, -122.432189787355) | 2 | 7 | 5 | 63 | 22 | |||
73113 | 184820 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1201 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984629.3153 | 2106942.3382 | 37.7643727351397 | -122.496386882515 | (37.7643727351397, -122.496386882515) | 1 | 8 | 3 | 56 | 35 | |||
74021 | 185547 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984897.749 | 2099920.0449 | 37.7451071798584 | -122.494940640653 | (37.7451071798584, -122.494940640653) | 1 | 8 | 3 | 29491 | 35 | |||
79139 | 186782 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984846.8015 | 2106847.3412 | 37.7641246383354 | -122.495627662164 | (37.7641246383354, -122.495627662164) | 1 | 8 | 3 | 56 | 35 | |||
81777 | 194562 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 889 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011315.22024 | 2104197.07336 | 37.7583620186233 | -122.40389405447 | (37.7583620186233, -122.40389405447) | 10 | 3 | 8 | 28856 | 29 | ||||
82747 | 186767 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984852.1379 | 2106748.1337 | 37.7638525549077 | -122.4956018875 | (37.7638525549077, -122.4956018875) | 1 | 8 | 3 | 56 | 35 | |||
83746 | 186138 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1700 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984950.8236 | 2103209.2432 | 37.7541415248308 | -122.494999607801 | (37.7541415248308, -122.494999607801) | 1 | 8 | 3 | 56 | 35 | |||
84089 | 211400 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 59 | : | Tree | Private 2 | 1 | Width 0ft | 5991311.81969 | 2093306.95297 | 37.7273226951736 | -122.472280141417 | (37.7273226951736, -122.472280141417) | 9 | 8 | 4 | 64 | 40 | |||
84966 | 185924 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985008.3753 | 2101455.4756 | 37.7493295295896 | -122.494671296707 | (37.7493295295896, -122.494671296707) | 1 | 8 | 3 | 29491 | 35 | |||
85727 | 187264 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.8959 | 2098392.3199 | 37.7409153957862 | -122.494654636162 | (37.7409153957862, -122.494654636162) | 1 | 8 | 3 | 29491 | 35 | |||
85738 | 184833 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1201 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984627.037 | 2106879.4946 | 37.7642000508442 | -122.496390124998 | (37.7642000508442, -122.496390124998) | 1 | 8 | 3 | 56 | 35 | |||
90172 | 184068 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984924.1607 | 2103985.0147 | 37.7562700179696 | -122.495149016136 | (37.7562700179696, -122.495149016136) | 1 | 8 | 3 | 56 | 35 | |||
90463 | 51043 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1559 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 1 | Permit Number 48663 | 5983718.7515 | 2104538.8044 | 37.7577199248109 | -122.49935859222 | (37.7577199248109, -122.49935859222) | 1 | 8 | 3 | 56 | 35 | |
90637 | 186705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1401 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984728.0673 | 2105089.5002 | 37.7592911456366 | -122.495908638929 | (37.7592911456366, -122.495908638929) | 1 | 8 | 3 | 56 | 35 | |||
91489 | 185111 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2801 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985053.4156 | 2095913.1692 | 37.7341144872923 | -122.494107116926 | (37.7341144872923, -122.494107116926) | 1 | 8 | 3 | 29491 | 35 | |||
100389 | 187020 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2501 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984970.2972 | 2097896.2634 | 37.7395546693135 | -122.494540621973 | (37.7395546693135, -122.494540621973) | 1 | 8 | 3 | 29491 | 35 | |||
101087 | 186173 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1700 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984958.7864 | 2103526.0224 | 37.7550117791931 | -122.49499542736 | (37.7550117791931, -122.49499542736) | 1 | 8 | 3 | 56 | 35 | |||
103335 | 50395 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 127 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 1 | Permit Number 47046 | 5987033.45591 | 2095011.41616 | 37.7317541720083 | -122.487195376871 | (37.7317541720083, -122.487195376871) | 1 | 8 | 4 | 64 | 35 | |
103873 | 184078 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 79 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984934.15 | 2104038.8591 | 37.7564184445961 | -122.495118440573 | (37.7564184445961, -122.495118440573) | 1 | 8 | 3 | 56 | 35 | |||
107873 | 185085 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2801 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985039.5977 | 2096044.6485 | 37.7344746858835 | -122.494164576498 | (37.7344746858835, -122.494164576498) | 1 | 8 | 3 | 29491 | 35 | |||
124106 | 233956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 1 | Width 2ft | 6002403.32332 | 2096434.71653 | 37.7365464964208 | -122.434160386288 | (37.7365464964208, -122.434160386288) | 2 | 7 | 5 | 63 | 7 | |||
124238 | 186695 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1401 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984710.8996 | 2105222.6543 | 37.7596557441561 | -122.495977835375 | (37.7596557441561, -122.495977835375) | 1 | 8 | 3 | 56 | 35 | |||
132593 | 194564 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 609 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6011831.61027 | 2105516.61152 | 37.7620140134443 | -122.402200910751 | (37.7620140134443, -122.402200910751) | 10 | 3 | 8 | 28856 | 29 | |||
134626 | 186589 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984756.3311 | 2104534.9006 | 37.7577700248795 | -122.495769980544 | (37.7577700248795, -122.495769980544) | 1 | 8 | 3 | 56 | 35 | |||
138729 | 186761 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984858.4445 | 2106717.0859 | 37.7637676756714 | -122.495577785051 | (37.7637676756714, -122.495577785051) | 1 | 8 | 3 | 56 | 35 | |||
141345 | 187284 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984975.1998 | 2098287.6552 | 37.7406296128031 | -122.49455251682 | (37.7406296128031, -122.49455251682) | 1 | 8 | 3 | 29491 | 35 | |||
143110 | 186567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 38 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984755.1796 | 2104685.1177 | 37.7581824118079 | -122.495785043438 | (37.7581824118079, -122.495785043438) | 1 | 8 | 3 | 56 | 35 | |||
148582 | 184016 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984928.9415 | 2103759.2795 | 37.7556504914972 | -122.495115837552 | (37.7556504914972, -122.495115837552) | 1 | 8 | 3 | 56 | 35 | |||
152381 | 184842 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1201 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984639.5677 | 2106862.4072 | 37.7641538677139 | -122.496345524658 | (37.7641538677139, -122.496345524658) | 1 | 8 | 3 | 56 | 35 | |||
154396 | 186765 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984853.1081 | 2106738.9164 | 37.7638273036042 | -122.495597852027 | (37.7638273036042, -122.495597852027) | 1 | 8 | 3 | 56 | 35 | |||
159374 | 186753 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984860.8701 | 2106690.8893 | 37.7636958892015 | -122.495567463463 | (37.7636958892015, -122.495567463463) | 1 | 8 | 3 | 56 | 35 | |||
164007 | 181450 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984867.7795 | 2105091.3167 | 37.7593043148371 | -122.495425587569 | (37.7593043148371, -122.495425587569) | 1 | 8 | 3 | 56 | 35 | |||
168626 | 184066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984917.8261 | 2103976.2436 | 37.7562455640963 | -122.49517027626 | (37.7562455640963, -122.49517027626) | 1 | 8 | 3 | 56 | 35 | |||
177690 | 185956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2001 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984863.0443 | 2101382.487 | 37.7491206153961 | -122.495168465288 | (37.7491206153961, -122.495168465288) | 1 | 8 | 3 | 29491 | 35 | |||
184458 | 184019 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984936.296 | 2103763.6921 | 37.7556630378367 | -122.495090729116 | (37.7556630378367, -122.495090729116) | 1 | 8 | 3 | 56 | 35 | |||
188118 | 186449 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1601 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984739.2681 | 2103899.1733 | 37.7560234949851 | -122.495782096963 | (37.7560234949851, -122.495782096963) | 1 | 8 | 3 | 56 | 35 | |||
189476 | 184065 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984936.83 | 2103975.2691 | 37.7562440009699 | -122.495104483371 | (37.7562440009699, -122.495104483371) | 1 | 8 | 3 | 56 | 35 | |||
189552 | 185345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985009.2403 | 2096974.0058 | 37.7370246764469 | -122.494338012308 | (37.7370246764469, -122.494338012308) | 1 | 8 | 3 | 29491 | 35 | |||
189698 | 181527 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1300 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984868.615 | 2105743.7944 | 37.7610958854432 | -122.495470820725 | (37.7610958854432, -122.495470820725) | 1 | 8 | 3 | 56 | 35 | |||
191869 | 181454 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.7669 | 2105104.6837 | 37.7593407233891 | -122.495443909168 | (37.7593407233891, -122.495443909168) | 1 | 8 | 3 | 56 | 35 | |||
10524 | 18541 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
12729 | 132219 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3000 Divisadero St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6000528.5903 | 2118632.53612 | 37.7973895998041 | -122.442235132763 | (37.7973895998041, -122.442235132763) | 13 | 9 | 1 | 57 | 17 | |||
21395 | 211346 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 302 San Fernando Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 5992080.36413 | 2094802.48118 | 37.7314734926994 | -122.469732140843 | (37.7314734926994, -122.469732140843) | 9 | 8 | 4 | 59 | 40 | |||
25480 | 250182 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501 Parker Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5997172.47236 | 2111145.47533 | 37.7766402787574 | -122.453307298016 | (37.7766402787574, -122.453307298016) | 15 | 6 | 2 | 54 | 16 | |||
25773 | 132289 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1215 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008278.61159 | 2117890.90403 | 37.7957919047152 | -122.41536544048 | (37.7957919047152, -122.41536544048) | 5 | 1 | 10 | 28858 | 21 | |||
27918 | 233578 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 878 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000785.56931 | 2102019.64805 | 37.7517894430431 | -122.440154008017 | (37.7517894430431, -122.440154008017) | 2 | 4 | 5 | 28862 | 22 | |||
30166 | 7981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005603.29363 | 2117103.29165 | 37.793478593006 | -122.424566490678 | (37.793478593006, -122.424566490678) | 13 | 9 | 1 | 28858 | 27 | |||
32973 | 251043 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5527 Geary Blvd | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 2ft | 5989811.4148 | 2112601.8948 | 37.7802145363711 | -122.478877614898 | (37.7802145363711, -122.478877614898) | 11 | 6 | 2 | 55 | 26 | |||
39328 | 250178 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501 Parker Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5997144.82593 | 2111356.18237 | 37.7772172406155 | -122.453418151121 | (37.7772172406155, -122.453418151121) | 15 | 6 | 2 | 54 | 16 | |||
39811 | 132331 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2504 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007490.25356 | 2121024.24346 | 37.8043509271294 | -122.418315581892 | (37.8043509271294, -122.418315581892) | 5 | 1 | 1 | 308 | 32 | |||
41339 | 132292 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1351 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6005902.17996 | 2119970.81093 | 37.8013689496769 | -122.423736302209 | (37.8013689496769, -122.423736302209) | 13 | 9 | 1 | 28858 | 32 | |||
42821 | 120051 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 162 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5987436.57094 | 2114873.9069 | 37.7863146463896 | -122.487260109939 | (37.7863146463896, -122.487260109939) | 11 | 6 | 1 | 55 | 33 | |||
52152 | 132336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 603 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007097.46754 | 2122233.18776 | 37.8076482617315 | -122.419760687214 | (37.8076482617315, -122.419760687214) | 5 | 1 | 1 | 308 | 32 | |||
53741 | 184845 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1201 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984684.3746 | 2106857.0912 | 37.7641418961702 | -122.496190160624 | (37.7641418961702, -122.496190160624) | 1 | 8 | 3 | 56 | 35 | |||
58614 | 250181 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501 Parker Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5997169.26644 | 2111180.16257 | 37.7767353371124 | -122.453320893039 | (37.7767353371124, -122.453320893039) | 15 | 6 | 2 | 54 | 16 | |||
62419 | 122938 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 398 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992815.34248 | 2112877.83335 | 37.7811461613239 | -122.468505823657 | (37.7811461613239, -122.468505823657) | 11 | 6 | 2 | 54 | 11 | |||
75349 | 211433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999107.76452 | 2093515.11915 | 37.7283423752978 | -122.445344638542 | (37.7283423752978, -122.445344638542) | 9 | 7 | 4 | 28861 | 40 | |||
79676 | 75385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
84632 | 77991 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
85105 | 250361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 45 Scenic Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5987641.56048 | 2115607.53253 | 37.788340923543 | -122.486604794775 | (37.788340923543, -122.486604794775) | 11 | 6 | 1 | 55 | 33 | ||||
87326 | 132341 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6010253.82078 | 2121967.79388 | 37.8070968568117 | -122.408818593599 | (37.8070968568117, -122.408818593599) | 3 | 1 | 10 | 308 | 23 | |||
97409 | 132267 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2740 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000663.69411 | 2117749.29227 | 37.794972143905 | -122.441704219792 | (37.794972143905, -122.441704219792) | 13 | 9 | 1 | 57 | 27 | |||
101378 | 178385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002858.54896 | 2092753.087 | 37.7264634037409 | -122.432323616338 | (37.7264634037409, -122.432323616338) | 9 | 7 | 6 | 28861 | 5 | |||
104176 | 246009 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1509 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998901.8356 | 2108659.6183 | 37.7699137214477 | -122.447146004959 | (37.7699137214477, -122.447146004959) | 15 | 5 | 11 | 29492 | 9 | |||
105175 | 194559 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2301 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6010925.71901 | 2105051.26279 | 37.7606856635422 | -122.405301281245 | (37.7606856635422, -122.405301281245) | 10 | 3 | 8 | 28856 | 29 | ||||
106168 | 97337 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 166 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 5988702.39254 | 2114219.96893 | 37.7845928511848 | -122.482832802565 | (37.7845928511848, -122.482832802565) | 11 | 6 | 2 | 55 | 26 | |||
107387 | 211428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 53 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999583.37084 | 2097473.06947 | 37.7392371150928 | -122.443984716141 | (37.7392371150928, -122.443984716141) | 9 | 7 | 4 | 59 | 40 | |||
114194 | 233587 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 245 Roosevelt Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000888.674 | 2107184.20862 | 37.7659759344589 | -122.440167772151 | (37.7659759344589, -122.440167772151) | 15 | 5 | 5 | 29492 | 3 | |||
115046 | 185731 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2101 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984880.3755 | 2100300.4017 | 37.7461505191435 | -122.49502875545 | (37.7461505191435, -122.49502875545) | 1 | 8 | 3 | 29491 | 35 | |||
117295 | 120052 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 162 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5987437.33643 | 2114893.11531 | 37.7863674318159 | -122.487258872951 | (37.7863674318159, -122.487258872951) | 11 | 6 | 1 | 55 | 33 |
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) );