trees

22 rows where qSpecies_id = 382

✎ View and edit SQL

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)
19357 256415 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 3 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
24901 256416 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 4 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
36068 91596 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 644 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6007464.720587 2105907.404981 37.7628423226144 -122.41733201971 (37.7628423226144, -122.41733201971) 8 4 7 28859 19
49164 17450 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 1967 Palou Ave 4 Sidewalk: Curb side : Cutout Landscaping DPW 1     42 3X3   6012966.10245 2096645.10936 37.7377180333685 -122.397654855789 (37.7377180333685, -122.397654855789) 10 3 8 58 1
51851 227519 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 375 Alabama St 1 : Landscaping Private 2     8 Width 3ft   6008967.54586 2106408.18704 37.7643017925286 -122.412169648322 (37.7643017925286, -122.412169648322) 8 4 7 28859 19
54444 187106 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 2600 Sunset Blvd 42 Median : Yard Tree Private 2     5 Width 0ft   5985139.9461 2097226.8463 37.7377265570772 -122.493904738 (37.7377265570772, -122.493904738) 1 8 3 29491 35
68667 256352 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 2900 Sunset Blvd 2 Median : Yard Tree Private 2       3x3   5985353 2095227 37.7322479741155 -122.493020846351 (37.7322479741155, -122.493020846351) 1 8 4 64 35
68803 256351 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 2900 Sunset Blvd 1 Median : Yard Tree Private 2       3x3   5985353 2095227 37.7322479741155 -122.493020846351 (37.7322479741155, -122.493020846351) 1 8 4 64 35
83031 256421 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 9 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
106500 256424 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 12 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
118246 256426 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 14 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
134265 256425 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 13 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
134781 227520 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 16 Tiffany Ave 1 : Landscaping Private 2     4 Width 2ft   6006374.41145 2099856.22866 37.7461657844399 -122.420673433456 (37.7461657844399, -122.420673433456) 2 7 5 28859 2
134842 256422 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 10 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
140191 117919 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 727 41st Ave 2 Sidewalk: Curb side : Cutout Landscaping Private 2     3 Width 3ft   5983193.78874 2110818.22502 37.774930606826 -122.501638652158 (37.774930606826, -122.501638652158) 11 6 2 55 26
144246 256434 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 22 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
148780 256423 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 11 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
154520 256417 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 5 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
155748 256420 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 8 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
171982 256428 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 16 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
181901 191507 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 725 18th St 3 Sidewalk: Property side : Yard Landscaping Private 2     6 Width 2ft   6015301.62259 2105759.06622 37.7628728201497 -122.390216323947 (37.7628728201497, -122.390216323947) 10 3 8 28856 29
188049 191506 DPW Maintained 1 Ligustrum ovalifolium :: California privet 382 725 18th St 1 Sidewalk: Property side : Yard Landscaping Private 2     12 Width 2ft   6015277.21856 2105757.38147 37.7628668405556 -122.390300611982 (37.7628668405556, -122.390300611982) 10 3 8 28856 29

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);