Converted from elderly Microsoft Access database.
This dataset has the following 73 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| trees_id | trees_id | number | 3 4 5 6 7 view top 100 |
| trees_id2 | trees_id2 | text | NULL 37a0973f108 37a09740344 37a0973f10e 37a0973f111 view top 100 |
| Tr_rec | tr_rec | number | 2 1001 4 5 6 view top 100 |
| Locarea | locarea | text | SUNSET BL /W MULHOLLAND DR SHERMAN WY VENTURA BL WILSHIRE BL view top 100 |
| Locunit | locunit | number | 100 401 600 200 201 view top 100 |
| Locsubunit | locsubunit | text | F S R P M view top 100 |
| Locsite | locsite | number | 1 2 3 4 5 view top 100 |
| Spp | spp | number | 4 165 579 171 282 view top 100 |
| Common | common | text | VACANT - OK TO PLANT CRAPE MYRTLE MEXICAN FAN PALM AMERICAN SWEETGUM SOUTHERN MAGNOLIA view top 100 |
| Botanical | botanical | text | Vacant - OK to plant Washingtonia robusta Lagerstroemia indica Liquidambar styraciflua Magnolia grandiflora view top 100 |
| On_strt | on_strt | text | NULL SUNSET BL MULHOLLAND DR SHERMAN WY VENICE BL view top 100 |
| From_strt | from_strt | text | NULL DEADEND SUNSET BL MAIN ST /S CITY LIMIT view top 100 |
| To_strt | to_strt | text | NULL DEADEND VENICE BL CITY LIMIT PICO BL /W view top 100 |
| Gisno | gisno | number | 2 3 4 5 6 view top 100 |
| Ext | ext | text | NULL X view top 100 |
| Area | area | text | NULL view top 100 |
| Treeloc | treeloc | text | S NULL view top 100 |
| Dbh | dbh | text | NULL 3-12 12-24 0-3 12 - 18" view top 100 |
| Inv_date | inv_date | calendar_date | 1997-06-30T00:00:00.000 1991-03-14T00:00:00.000 1991-03-08T00:00:00.000 1997-05-15T00:00:00.000 1991-02-26T00:00:00.000 view top 100 |
| Drgmapname | drgmapname | text | NULL view top 100 |
| Drglayer | drglayer | text | NULL view top 100 |
| Drgxcoord | drgxcoord | number | 0 6464580 6470700 6475980 6481280 view top 100 |
| Drgycoord | drgycoord | number | 0 1808960 1808970 1858230 1826140 view top 100 |
| X_original | x_original | number | 0 118510000 118519000 118511000 118515000 view top 100 |
| Y_original | y_original | number | 0 34201100 34200900 34186500 34249900 view top 100 |
| DIR | dir | text | NULL E O view top 100 |
| DES_SPP1 | des_spp1 | number | 0 3 5 20 21 view top 100 |
| TRUNKS | trunks | text | NULL 2 3 4 5 view top 100 |
| HT | ht | text | NULL 0-20 20-50 50 + view top 100 |
| COND | cond | text | NULL Good HEALTHY Fair FAIR view top 100 |
| MT | mt | text | NULL Routine 0 ROUTINE ROUTINE PRUNE view top 100 |
| PEST | pest | text | NULL YES view top 100 |
| VEG | veg | text | NULL YES N view top 100 |
| WELLSTAT | wellstat | text | NULL PLANTED NT PLNT ASPHALT CEMENT view top 100 |
| WELLCOV | wellcov | text | NULL AGRIPERM CINDERBL OTHER MET GRAT view top 100 |
| GUARD | guard | text | NULL YES view top 100 |
| UT | ut | text | NULL None PSO P-O Other (O) view top 100 |
| UTOB | utob | text | NULL NO YES --O PSO view top 100 |
| CD | cd | number | 5 12 3 11 6 view top 100 |
| DIST | dist | text | WV Bay EV South MT view top 100 |
| TG_PG | tg_pg | number | 7 34 8 12 14 view top 100 |
| TG_COORD | tg_coord | text | NULL A3 B3 A2 C3 view top 100 |
| CMAP | cmap | text | NULL 3 2 c view top 100 |
| HD | hd | text | NULL SW+C CURB SW view top 100 |
| GROW | grow | number | 99 84 72 60 48 view top 100 |
| HIST_ID | hist_id | text | NULL 41 49 343 24 view top 100 |
| EXP_ID | exp_id | text | NULL view top 100 |
| UP_DATE | up_date | text | NULL 1993-03-17 00:00:00 1992-08-26 00:00:00 1992-12-17 00:00:00 1980-02-29 00:00:00 view top 100 |
| STAFF | staff | text | DRG JL CS NULL TS view top 100 |
| UN | un | number | 37 2 17 35 19 view top 100 |
| BLSD | blsd | number | 1 2 17 3 149 view top 100 |
| DOWNLOAD | download | text | NULL YES view top 100 |
| NOTES | notes | text | NULL DLH - CHANGE AREA BACK TO MT view top 100 |
| CITY_NAME | city_name | text | NULL LOS ANGELES view top 100 |
| BLSDVAL | blsdval | number | 1 2 17 3 46 view top 100 |
| MDIST | mdist | text | NULL 24 21 22 23 view top 100 |
| GROWMATL | growmatl | text | NULL Organic (soil, turf) ORGANIC (SOIL, TURF) Agriperm well cover AGRIPERM WELL COVER view top 100 |
| GROWSIZE | growsize | text | NULL 4 6 9.5 9 view top 100 |
| GROWTYPE | growtype | text | NULL Parkway IMPROVED PARKWAY PARKWAY Well 4 X 4 view top 100 |
| TYPE | type | text | bayarea original NULL view top 100 |
| X | x | number | 0 -118.436 -118.435 -118.438 -118.428 view top 100 |
| Y | y | number | 0 34.0827 34.1631 34.1576 34.1504 view top 100 |
| utdescription | utdescription | text | NULL METER POWER POLE/WIRES STREET LIGHT OTHER view top 100 |
| utdescription_other | utdescription_other | text | NULL METER WATER ST.LIGHT STREET LIGHT view top 100 |
| curb | curb | text | NULL ON GRADE OFF GRADE view top 100 |
| stock_size | stock_size | text | NULL 15 GALLON 24" BOX NO REPLANT 15 GALLON OR LARGER EVERGREEN PEAR TREE view top 100 |
| sidewalk | sidewalk | text | NULL ON GRADE OFF GRADE TEMP PATCH OFF SET view top 100 |
| trees_street_id | trees_street_id | number | 350142 331976 337559 264212 353723 view top 100 |
| date_root_prune_curb | date_root_prune_curb | text | NULL 01/18/03 01/09/03 01/16/03 11/13/03 view top 100 |
| date_root_prune_driveway | date_root_prune_driveway | text | NULL 05/19/06 08/30/04 12/10/06 06/17/06 view top 100 |
| date_root_prune_sidewalk | date_root_prune_sidewalk | text | NULL 01/24/03 06/09/04 06/25/03 01/28/04 view top 100 |
| note_id | note_id | text | NULL view top 100 |
| Location 1 | location_1 | location | view top 100 |