trees
52 rows where Zip Codes = 59 and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13164 | 55911 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 116 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30988 | 5996731.08358072 | 2098564.41624229 | 37.7420705676821 | -122.453925386093 | (37.7420705676821, -122.453925386093) | 9 | 7 | 4 | 59 | 40 | ||
| 13819 | 211359 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 410 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5998661.30994 | 2094409.45773 | 37.730772523328 | -122.446952376361 | (37.730772523328, -122.446952376361) | 9 | 7 | 4 | 59 | 40 | |||
| 15182 | 211413 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 443 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996006.80545 | 2096409.86845 | 37.7361131535818 | -122.456273946489 | (37.7361131535818, -122.456273946489) | 9 | 7 | 4 | 59 | 40 | |||
| 17605 | 210355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 135 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992434.93704 | 2098226.83597 | 37.7408963984514 | -122.468755410554 | (37.7408963984514, -122.468755410554) | 1 | 8 | 4 | 59 | 40 | |||
| 19188 | 50842 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 82 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | Permit Number 47359 | 5993044.92804396 | 2098532.41947398 | 37.7417706745335 | -122.466668512936 | (37.7417706745335, -122.466668512936) | 1 | 8 | 4 | 59 | 40 | ||
| 19960 | 211414 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 475 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996355.36413 | 2096409.09185 | 37.7361310240131 | -122.455068788392 | (37.7361310240131, -122.455068788392) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 23124 | 211419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 890 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998718.20092 | 2096172.32368 | 37.7356161864214 | -122.446882499938 | (37.7356161864214, -122.446882499938) | 9 | 7 | 4 | 59 | 40 | |||
| 32546 | 211416 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 713 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997922.47356 | 2095601.27988 | 37.7340027451309 | -122.44959248642 | (37.7340027451309, -122.44959248642) | 9 | 7 | 4 | 59 | 40 | |||
| 32993 | 211410 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100x Casitas Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995192.27525 | 2097020.79069 | 37.7377438043392 | -122.45913431311 | (37.7377438043392, -122.45913431311) | 9 | 7 | 4 | 59 | 40 | |||
| 34771 | 211425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 534 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997366.12153 | 2097807.3995 | 37.7400283736974 | -122.451675041993 | (37.7400283736974, -122.451675041993) | 9 | 7 | 4 | 59 | 40 | |||
| 42991 | 211420 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 884 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998694.26303 | 2096188.53472 | 37.7356593305005 | -122.446966428261 | (37.7356593305005, -122.446966428261) | 9 | 7 | 4 | 59 | 40 | |||
| 50474 | 211356 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5999471.52853 | 2097511.88906 | 37.7393373238643 | -122.444374204418 | (37.7393373238643, -122.444374204418) | 9 | 7 | 4 | 59 | 40 | |||
| 54054 | 211422 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Cresta Vista Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996890.55038 | 2096184.33707 | 37.7355445905077 | -122.453202221208 | (37.7355445905077, -122.453202221208) | 9 | 7 | 4 | 59 | 40 | |||
| 54480 | 47970 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 576 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45700 | 5998868.81071555 | 2097070.39431327 | 37.7380906778158 | -122.446426373957 | (37.7380906778158, -122.446426373957) | 9 | 7 | 4 | 59 | 40 | ||
| 56038 | 211354 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 23 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999278.01006 | 2097568.54324 | 37.7394818395234 | -122.445047374833 | (37.7394818395234, -122.445047374833) | 9 | 7 | 4 | 59 | 40 | |||
| 56419 | 211350 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 510 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5997469.92168 | 2097669.96714 | 37.7396569618039 | -122.451306236295 | (37.7396569618039, -122.451306236295) | 9 | 7 | 4 | 59 | 40 | |||
| 61811 | 211351 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 514 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5997454.74316 | 2097696.67484 | 37.7397294255599 | -122.451360642595 | (37.7397294255599, -122.451360642595) | 9 | 7 | 4 | 59 | 40 | |||
| 68979 | 211408 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 172 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5994309.04754 | 2099264.29006 | 37.7438530788559 | -122.462350707838 | (37.7438530788559, -122.462350707838) | 1 | 8 | 4 | 59 | 40 | |||
| 82541 | 211427 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 65 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999709.39376 | 2097376.92843 | 37.7389803226746 | -122.443542082395 | (37.7389803226746, -122.443542082395) | 9 | 7 | 4 | 59 | 40 | |||
| 85042 | 211348 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 442 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996116.46802 | 2096375.41927 | 37.7360248590668 | -122.455892311101 | (37.7360248590668, -122.455892311101) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 181046 | 211357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 42 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999475.8897 | 2097510.54989 | 37.7393338956504 | -122.444359029265 | (37.7393338956504, -122.444359029265) | 9 | 7 | 4 | 59 | 40 | |||
| 188822 | 211355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 30 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999309.78108 | 2097559.20163 | 37.7394580029801 | -122.444936853564 | (37.7394580029801, -122.444936853564) | 9 | 7 | 4 | 59 | 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) );