trees
1,794 rows where qSpecies_id = 95 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86944 | 211415 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 472 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996435.70468 | 2096396.29496 | 37.7361004956255 | -122.454790095701 | (37.7361004956255, -122.454790095701) | 9 | 7 | 4 | 59 | 40 | |||
| 87867 | 11879 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 17 | 20 | 5991400.98667 | 2094604.94103 | 37.7308918058105 | -122.472066462495 | (37.7308918058105, -122.472066462495) | 9 | 8 | 4 | 64 | 40 | |||
| 89238 | 211347 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 418 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995860.90205 | 2096382.83838 | 37.7360305589637 | -122.456776436402 | (37.7360305589637, -122.456776436402) | 9 | 7 | 4 | 59 | 40 | |||
| 90674 | 211349 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 502 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5997483.66108 | 2097633.80545 | 37.7395584572538 | -122.451256124293 | (37.7395584572538, -122.451256124293) | 9 | 7 | 4 | 59 | 40 | |||
| 92641 | 44418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002034.50312 | 2086862.32419 | 37.7102419210068 | -122.434751242692 | (37.7102419210068, -122.434751242692) | 9 | 7 | 6 | 28861 | 5 | |
| 92808 | 211364 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 31 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994142.05471 | 2090125.81832 | 37.7187514599864 | -122.462265480884 | (37.7187514599864, -122.462265480884) | 9 | 8 | 6 | 28861 | 24 | |||
| 93540 | 178382 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1726 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998057.07815 | 2088654.06944 | 37.7149350294989 | -122.448626932893 | (37.7149350294989, -122.448626932893) | 9 | 7 | 6 | 28861 | 25 | |||
| 93767 | 178365 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 77 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997093.61409 | 2086913.28171 | 37.7101000889142 | -122.451831546493 | (37.7101000889142, -122.451831546493) | 9 | 7 | 6 | 28861 | 25 | |||
| 93824 | 211411 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100x Casitas Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995419.81631 | 2096989.18107 | 37.7376700905057 | -122.45834531179 | (37.7376700905057, -122.45834531179) | 9 | 7 | 4 | 59 | 40 | |||
| 93970 | 211423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Cresta Vista Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5996878.86399 | 2096181.59262 | 37.7355363851018 | -122.453242427213 | (37.7355363851018, -122.453242427213) | 9 | 7 | 4 | 59 | 40 | |||
| 94956 | 11661 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 700X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991304.37203 | 2093039.68801 | 37.7265884212004 | -122.472286413287 | (37.7265884212004, -122.472286413287) | 9 | 8 | 4 | 64 | 40 | ||
| 95152 | 211430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 192 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000196.52602 | 2095258.93091 | 37.7331925683786 | -122.441705847568 | (37.7331925683786, -122.441705847568) | 9 | 7 | 5 | 63 | 40 | ||||
| 95626 | 211373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 584 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994051.44269 | 2090532.11227 | 37.7198618277532 | -122.462608144149 | (37.7198618277532, -122.462608144149) | 9 | 8 | 6 | 28861 | 24 | |||
| 96099 | 159380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 321 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:55:00 AM | 3 | Width 0ft | 5998873.83978 | 2087899.28592 | 37.7129092346593 | -122.445749622169 | (37.7129092346593, -122.445749622169) | 9 | 7 | 6 | 28861 | 25 | ||
| 96911 | 178363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 108 Foote Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998929.00366 | 2088057.1044 | 37.7133457179055 | -122.445570300043 | (37.7133457179055, -122.445570300043) | 9 | 7 | 6 | 28861 | 25 | |||
| 97985 | 13414 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999540.96545 | 2097034.36116 | 37.7380301071099 | -122.444099819458 | (37.7380301071099, -122.444099819458) | 9 | 7 | 4 | 59 | 40 | |||
| 99035 | 29957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991400.4743 | 2094594.98501 | 37.7308644394281 | -122.472067508419 | (37.7308644394281, -122.472067508419) | 9 | 8 | 4 | 64 | 40 | |||
| 99271 | 211368 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 581 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994015.82193 | 2090388.05 | 37.7194642158701 | -122.46272082651 | (37.7194642158701, -122.46272082651) | 9 | 8 | 6 | 64 | 24 | |||
| 101078 | 47926 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 59 Arroyo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45662 | 5998719.5492526 | 2097291.29425363 | 37.7386886899437 | -122.44695833479 | (37.7386886899437, -122.44695833479) | 9 | 7 | 4 | 59 | 40 | ||
| 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 | |||
| 101738 | 65671 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 759 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28591 | 5999036.51165566 | 2095907.91255274 | 37.7349083558011 | -122.445762972308 | (37.7349083558011, -122.445762972308) | 9 | 7 | 4 | 59 | 40 | ||
| 102295 | 211417 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 892 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998740.9762 | 2096158.55469 | 37.735579681155 | -122.446802766944 | (37.735579681155, -122.446802766944) | 9 | 7 | 4 | 59 | 40 | |||
| 104272 | 211418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 892 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998733.74685 | 2096161.12228 | 37.7355863181538 | -122.446827946161 | (37.7355863181538, -122.446827946161) | 9 | 7 | 4 | 59 | 40 | |||
| 105425 | 211344 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 302 San Fernando Way | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992079.24363 | 2094788.21551 | 37.7314342579681 | -122.4697349764 | (37.7314342579681, -122.4697349764) | 9 | 8 | 4 | 59 | 40 | |||
| 106463 | 975 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X5 | 6001957.29298 | 2093112.49768 | 37.7273991195728 | -122.43546491497 | (37.7273991195728, -122.43546491497) | 9 | 7 | 6 | 28861 | 25 | |||
| 106772 | 211392 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 11 | : | Tree | Private 2 | 24 | Width 0ft | 5991388.85233 | 2094538.65756 | 37.7307091058353 | -122.472103582919 | (37.7307091058353, -122.472103582919) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 108910 | 49653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 5 | Permit Number 46506 | 6010094.54091 | 2089412.62479 | 37.71769882961 | -122.407073624648 | (37.71769882961, -122.407073624648) | 9 | 7 | 8 | 309 | 39 | |
| 109006 | 178362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 108 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998943.86052 | 2088042.92429 | 37.7133076307222 | -122.445517930731 | (37.7133076307222, -122.445517930731) | 9 | 7 | 6 | 28861 | 25 | |||
| 112479 | 178388 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 327 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003406.21695 | 2093529.35449 | 37.7286258991527 | -122.430485715962 | (37.7286258991527, -122.430485715962) | 9 | 7 | 6 | 28861 | 5 | |||
| 114509 | 65331 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 141 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28154 | 6002111.55813884 | 2095203.52869324 | 37.7331493741938 | -122.435081111485 | (37.7331493741938, -122.435081111485) | 9 | 7 | 5 | 63 | 40 | ||
| 115888 | 30053 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991402.00396 | 2094617.05729 | 37.7309251328883 | -122.472063828393 | (37.7309251328883, -122.472063828393) | 9 | 8 | 4 | 64 | 40 | |||
| 116315 | 417 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 5990888.82465 | 2090075.47964 | 37.7184253822074 | -122.473506810731 | (37.7184253822074, -122.473506810731) | 9 | 8 | 4 | 64 | 40 | |||
| 116711 | 211401 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 62 | : | Tree | Private 2 | 12 | Width 0ft | 5991312.10074 | 2093282.10012 | 37.7272544717134 | -122.472277358928 | (37.7272544717134, -122.472277358928) | 9 | 8 | 4 | 64 | 40 | |||
| 116879 | 65462 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 901 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28340 | 5995002.55717105 | 2089937.23341469 | 37.7182831614911 | -122.459277439941 | (37.7182831614911, -122.459277439941) | 9 | 8 | 6 | 28861 | 24 | ||
| 119057 | 178391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Gaven St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6008930.41728 | 2094862.45857 | 37.7325977064018 | -122.411482306357 | (37.7325977064018, -122.411482306357) | 9 | 3 | 7 | 309 | 28 | |||
| 119342 | 211421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Cresta Vista Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996893.94836 | 2096185.38663 | 37.7355476670996 | -122.453190548909 | (37.7355476670996, -122.453190548909) | 9 | 7 | 4 | 59 | 40 | |||
| 121400 | 49047 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46219 | 5996108.27017141 | 2093728.07837669 | 37.7287554301635 | -122.455729350835 | (37.7287554301635, -122.455729350835) | 9 | 7 | 4 | 28861 | 40 | ||
| 121881 | 44429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002292.23602 | 2086990.00901 | 37.7106071446722 | -122.433869586918 | (37.7106071446722, -122.433869586918) | 9 | 7 | 6 | 28861 | 5 | |
| 122160 | 13413 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999541.98598 | 2097031.37514 | 37.7380219664255 | -122.444096076493 | (37.7380219664255, -122.444096076493) | 9 | 7 | 4 | 59 | 40 | |||
| 122243 | 57951 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 20 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 8 | Permit Number 16910 | 5999175.28724 | 2086654.44563 | 37.7095083907733 | -122.444618308297 | (37.7095083907733, -122.444618308297) | 9 | 7 | 6 | 28861 | 5 | ||
| 122591 | 178369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Moneta Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5997905.97472 | 2088046.7198 | 37.7132587453721 | -122.449105480147 | (37.7132587453721, -122.449105480147) | 9 | 7 | 6 | 28861 | 25 | ||||
| 122921 | 57953 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 24 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 15 | Permit Number 16912 | 5999096.91395 | 2086625.15148 | 37.7094234830895 | -122.444887074305 | (37.7094234830895, -122.444887074305) | 9 | 7 | 6 | 28861 | 5 | ||
| 123128 | 43311 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.25214 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) | 9 | 7 | 6 | 28861 | 5 |
| 124337 | 67013 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1345 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30368 | 5995769.70652962 | 2091972.54890953 | 37.7239157311453 | -122.456772865671 | (37.7239157311453, -122.456772865671) | 9 | 8 | 4 | 28861 | 24 | ||
| 127092 | 211374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 446 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993509.98372 | 2088840.25773 | 37.7151852037961 | -122.464356993699 | (37.7151852037961, -122.464356993699) | 9 | 8 | 6 | 64 | 24 | |||
| 128952 | 1211 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3151 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 5995828.36788 | 2086934.23822 | 37.7100850828375 | -122.45620597395 | (37.7100850828375, -122.45620597395) | 9 | 7 | 6 | 28861 | 25 | |||
| 129975 | 211363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 71 Ashton Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994120.6243 | 2090241.51187 | 37.7190678927482 | -122.462347943305 | (37.7190678927482, -122.462347943305) | 9 | 8 | 6 | 28861 | 24 | |||
| 130824 | 1153 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2691 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2x2 | 5998057.05642 | 2088283.39512 | 37.7139172415497 | -122.44860032736 | (37.7139172415497, -122.44860032736) | 9 | 7 | 6 | 28861 | 25 | |||
| 133754 | 211353 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 9 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999190.61493 | 2097593.0278 | 37.7395440797867 | -122.445351307915 | (37.7395440797867, -122.445351307915) | 9 | 7 | 4 | 59 | 40 | |||
| 137150 | 211393 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 20 | Width 0ft | 5991388.09058 | 2094530.01431 | 37.7306853295574 | -122.472105586615 | (37.7306853295574, -122.472105586615) | 9 | 8 | 4 | 64 | 40 | |||
| 138603 | 178364 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 257 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5998001.93472 | 2088198.67948 | 37.7136814798024 | -122.448784749527 | (37.7136814798024, -122.448784749527) | 9 | 7 | 6 | 28861 | 25 | |||
| 140060 | 50026 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
| 140380 | 211402 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 77 | : | Tree | Private 2 | 10 | Width 0ft | 5991311.70332 | 2093205.96444 | 37.7270453991248 | -122.472273185163 | (37.7270453991248, -122.472273185163) | 9 | 8 | 4 | 64 | 40 | |||
| 140464 | 178361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 763 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5998412.66799 | 2087061.2511 | 37.7105818395473 | -122.447283298096 | (37.7105818395473, -122.447283298096) | 9 | 7 | 6 | 28861 | 5 | |||
| 140703 | 57948 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 14 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16907 | 5999317.87409 | 2086697.21796 | 37.709633969409 | -122.444128577089 | (37.709633969409, -122.444128577089) | 9 | 7 | 6 | 28861 | 5 | ||
| 140744 | 211352 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Molimo Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997388.71891 | 2097767.32799 | 37.7399196411707 | -122.451594020245 | (37.7399196411707, -122.451594020245) | 9 | 7 | 4 | 59 | 40 | ||||
| 140833 | 416 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5990882.28531 | 2090084.77659 | 37.7184505306428 | -122.473530092056 | (37.7184505306428, -122.473530092056) | 9 | 8 | 4 | 64 | 40 | ||||
| 141150 | 211426 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400x Marietta Dr | 8 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999504.16591 | 2097034.85619 | 37.7380293669502 | -122.444227088834 | (37.7380293669502, -122.444227088834) | 9 | 7 | 4 | 59 | 40 | |||
| 141432 | 66260 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31088 | 5996714.47770615 | 2098535.27666339 | 37.7419896054085 | -122.453980699646 | (37.7419896054085, -122.453980699646) | 9 | 7 | 4 | 59 | 40 | ||
| 141835 | 159342 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:41:00 AM | 3 | Width 0ft | 5998239.66156 | 2087300.46869 | 37.7112287893569 | -122.447898455055 | (37.7112287893569, -122.447898455055) | 9 | 7 | 6 | 28861 | 25 | ||
| 142073 | 211358 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 43 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999479.63051 | 2097509.53542 | 37.739331323589 | -122.444346022364 | (37.739331323589, -122.444346022364) | 9 | 7 | 4 | 59 | 40 | |||
| 142311 | 1120 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2445 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999090.26548 | 2088844.34196 | 37.7155164987647 | -122.445069485575 | (37.7155164987647, -122.445069485575) | 9 | 7 | 6 | 28861 | 25 | |||
| 144843 | 44434 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002147.41851 | 2086908.48033 | 37.7103750656342 | -122.434364282404 | (37.7103750656342, -122.434364282404) | 9 | 7 | 6 | 28861 | 5 | |
| 145032 | 47967 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 370 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45697 | 5997970.64208959 | 2098199.91881065 | 37.7411407391747 | -122.449613145498 | (37.7411407391747, -122.449613145498) | 9 | 7 | 4 | 59 | 40 | ||
| 145939 | 178381 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1726 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998080.07659 | 2088674.29793 | 37.7149918873302 | -122.448548896919 | (37.7149918873302, -122.448548896919) | 9 | 7 | 6 | 28861 | 25 | |||
| 147011 | 211424 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5996875.09082 | 2096180.55057 | 37.7355333076209 | -122.453255397218 | (37.7355333076209, -122.453255397218) | 9 | 7 | 4 | 59 | 40 | |||
| 147040 | 15079 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 70 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996133.8718103 | 2089044.0011234 | 37.7158955330145 | -122.45530246888 | (37.7158955330145, -122.45530246888) | 9 | 8 | 6 | 28861 | 24 | |||
| 147884 | 211345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 302 San Fernando Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992079.79113 | 2094794.73629 | 37.7314521940467 | -122.469733558158 | (37.7314521940467, -122.469733558158) | 9 | 8 | 4 | 59 | 40 | |||
| 149214 | 13412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 424 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999639.6116279 | 2097094.1286968 | 37.7381998416451 | -122.443763044504 | (37.7381998416451, -122.443763044504) | 9 | 7 | 4 | 59 | 40 | |||
| 149448 | 43312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.431640671199 | (37.7261742132654, -122.431640671199) | 9 | 7 | 6 | 28861 | 5 |
| 149496 | 47969 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 571 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45699 | 5998926.83407874 | 2097073.47260049 | 37.7381024439433 | -122.446225980415 | (37.7381024439433, -122.446225980415) | 9 | 7 | 4 | 59 | 40 | ||
| 150367 | 44421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002090.25454 | 2086883.74706 | 37.7103039085691 | -122.434560085477 | (37.7103039085691, -122.434560085477) | 9 | 7 | 6 | 28861 | 5 | |
| 151428 | 211432 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 965 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998407.05988 | 2095671.52023 | 37.7342233191399 | -122.447922184575 | (37.7342233191399, -122.447922184575) | 9 | 7 | 4 | 59 | 40 | |||
| 153384 | 43310 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) | 9 | 7 | 6 | 28861 | 5 |
| 153763 | 211391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 7 | : | Tree | Private 2 | 16 | Width 0ft | 5991391.10159 | 2094562.85542 | 37.7307756772501 | -122.472097570057 | (37.7307756772501, -122.472097570057) | 9 | 8 | 4 | 64 | 40 | |||
| 154768 | 11640 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 5991362.1134613 | 2093824.2614448 | 37.7287460056648 | -122.472143968924 | (37.7287460056648, -122.472143968924) | 9 | 8 | 4 | 64 | 40 | |||
| 155077 | 211431 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 278 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5999570.66466 | 2095256.06899 | 37.7331490303839 | -122.443869406865 | (37.7331490303839, -122.443869406865) | 9 | 7 | 4 | 63 | 40 | |||
| 155256 | 178383 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002791.95484 | 2092644.53526 | 37.7261615687975 | -122.43254607895 | (37.7261615687975, -122.43254607895) | 9 | 7 | 6 | 28861 | 5 | |||
| 155416 | 211412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100x Casitas Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 5995479.92696 | 2096985.75384 | 37.7376641342833 | -122.458137233872 | (37.7376641342833, -122.458137233872) | 9 | 7 | 4 | 59 | 40 | |||
| 155794 | 52524 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48624 | 6000729.49329 | 2092545.62188 | 37.7257727999708 | -122.439668786882 | (37.7257727999708, -122.439668786882) | 9 | 7 | 6 | 28861 | 25 | |
| 155941 | 50022 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 736 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46756 | 6009379.93201 | 2091040.43268 | 37.7221284349621 | -122.409658546911 | (37.7221284349621, -122.409658546911) | 9 | 3 | 7 | 309 | 28 | |
| 156806 | 211366 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1x Minerva St | 35 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996338.39327 | 2089000.17241 | 37.7157869222084 | -122.454592386944 | (37.7157869222084, -122.454592386944) | 9 | 8 | 6 | 28861 | 24 | |||
| 159191 | 67468 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30989 | 5996784.33302359 | 2098587.30616541 | 37.7421364707665 | -122.453742919924 | (37.7421364707665, -122.453742919924) | 9 | 7 | 4 | 59 | 40 | ||
| 159783 | 178387 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002886.68942 | 2092797.68104 | 37.7265874445442 | -122.432229519385 | (37.7265874445442, -122.432229519385) | 9 | 7 | 6 | 28861 | 5 | |||
| 160185 | 178370 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5 Moneta Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5997947.63723 | 2088047.57972 | 37.7132634893028 | -122.448961542747 | (37.7132634893028, -122.448961542747) | 9 | 7 | 6 | 28861 | 25 | |||
| 160764 | 15082 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 84 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996031.3031413 | 2089045.3531152 | 37.7158933597021 | -122.455657089572 | (37.7158933597021, -122.455657089572) | 9 | 8 | 6 | 28861 | 24 | |||
| 160792 | 178371 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Moneta Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5997975.94218 | 2088092.10775 | 37.713387371813 | -122.448866916977 | (37.713387371813, -122.448866916977) | 9 | 7 | 6 | 28861 | 25 | |||
| 160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
| 161820 | 211429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 52 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999576.15591 | 2097477.53164 | 37.739248955579 | -122.44400998258 | (37.739248955579, -122.44400998258) | 9 | 7 | 4 | 59 | 40 | |||
| 162707 | 37343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 517 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 4 | Permit Number 39851 | 5999456.75939 | 2086965.30426 | 37.7103779965068 | -122.443667813037 | (37.7103779965068, -122.443667813037) | 9 | 7 | 6 | 28861 | 5 | |
| 162753 | 178373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3153 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5995808.82145 | 2086930.91891 | 37.7100748467381 | -122.456273289988 | (37.7100748467381, -122.456273289988) | 9 | 7 | 6 | 28861 | 25 | |||
| 164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
| 166495 | 29973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991350.6997 | 2093700.47523 | 37.7284054591375 | -122.472174407226 | (37.7284054591375, -122.472174407226) | 9 | 8 | 4 | 64 | 40 | ||
| 166573 | 211377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 438 Shields St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992783.55943 | 2089868.41176 | 37.71796636713 | -122.466942511301 | (37.71796636713, -122.466942511301) | 9 | 8 | 6 | 64 | 24 | |||
| 167021 | 60960 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1988 12:00:00 AM | Permit Number 25349 | 5994476.34646497 | 2090599.97936006 | 37.7200726359376 | -122.461144327567 | (37.7200726359376, -122.461144327567) | 9 | 8 | 6 | 28861 | 24 | ||
| 167246 | 56610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 117 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 30987 | 5996756.33540734 | 2098503.70250218 | 37.7419053104165 | -122.453833690323 | (37.7419053104165, -122.453833690323) | 9 | 7 | 4 | 59 | 40 | ||
| 168535 | 67507 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 427 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31037 | 5997919.84331621 | 2094073.6426889 | 37.7298080658571 | -122.449491544159 | (37.7298080658571, -122.449491544159) | 9 | 7 | 4 | 28861 | 40 | ||
| 170884 | 178386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002873.11956 | 2092775.20615 | 37.7265249641326 | -122.432274825446 | (37.7265249641326, -122.432274825446) | 9 | 7 | 6 | 28861 | 5 | |||
| 175140 | 49058 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46225 | 5995429.55733009 | 2093557.30564002 | 37.7282475554757 | -122.458063335473 | (37.7282475554757, -122.458063335473) | 9 | 7 | 4 | 28861 | 40 |
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) );