trees

16 rows where Neighborhoods (old) = 40 and qSpecies_id = 119

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
12159 207734 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 301 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 10ft   6000042.84201 2094939.48464 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597) 9 7 4 63 40
34061 207716 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 115 Judson Ave 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   5999335.92351 2093459.52729 37.7282027546376 -122.444551891566 (37.7282027546376, -122.444551891566) 9 7 4 28861 40
38804 207730 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 740 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     16 Width 3ft   5998158.00142 2095945.96511 37.7349626400957 -122.44880301654 (37.7349626400957, -122.44880301654) 9 7 4 59 40
50569 109626 Undocumented 4 Eriobotrya japonica :: Edible Loquat 119 117 JUDSON AVE   Sidewalk: Property side : Cutout Tree Private 2       3x12   5999286.5 2093444.4 37.7281583983457 -122.444721663071 (37.7281583983457, -122.444721663071) 9 7 4 28861 40
59884 207731 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 32 Malta Dr 19 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5999573.25493 2096045.34694 37.7353163497697 -122.443917140176 (37.7353163497697, -122.443917140176) 9 7 4 63 40
83068 207712 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 579 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     7     5997579.44084 2094367.86788 37.7305964594534 -122.450689553205 (37.7305964594534, -122.450689553205) 9 7 4 28861 40
97479 207714 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 298 Staples Ave 11 Sidewalk: Property side : Yard Tree Private 2     12     5998133.74364 2093826.5868 37.7291419427263 -122.448734282271 (37.7291419427263, -122.448734282271) 9 7 4 28861 40
109998 207732 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 400 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     19 Width 10ft   6000124.6238 2095012.30469 37.7325112932663 -122.441936736802 (37.7325112932663, -122.441936736802) 9 7 5 63 40
112712 207715 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 117 Judson Ave 2 Sidewalk: Property side : Yard Tree Private 2     2     5999294.96193 2093458.56634 37.7281977787 -122.444693427785 (37.7281977787, -122.444693427785) 9 7 4 28861 40
129645 207729 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 10 Mendosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993528.03028 2101159.37914 37.749011508282 -122.465188881878 (37.749011508282, -122.465188881878) 1 8 4 29491 40
138085 207713 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 171 Flood Ave 3 Sidewalk: Property side : Yard Tree Private 2     11     5999625.57301 2094046.65577 37.7298313962868 -122.443592725033 (37.7298313962868, -122.443592725033) 9 7 4 63 40
153448 207728 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 3802 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.474661051582 (37.7196901687566, -122.474661051582) 9 8 4 64 40
167227 207733 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 500 Joost Ave 3 Sidewalk: Property side : Yard Tree Private 2     4     5998757.70005 2094996.74516 37.7323905826432 -122.446661380942 (37.7323905826432, -122.446661380942) 9 7 4 59 40
167876 207711 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 200x Terrace Dr 31 Median : Yard Tree DPW 1     12     5993844.07189 2096487.62875 37.7362022754996 -122.463756979508 (37.7362022754996, -122.463756979508) 1 8 4 59 40
180433 109627 Undocumented 4 Eriobotrya japonica :: Edible Loquat 119 500 CIRCULAR AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5999334 2093430 37.728121569817 -122.444556419888 (37.728121569817, -122.444556419888) 9 7 4 28861 40
184069 218344 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 385 Castenada Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993369.33927 2100022.3312 37.745880311731 -122.465655034675 (37.745880311731, -122.465655034675) 1 8 4 29491 40

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