trees

26 rows where qSpecies_id = 223

✎ 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)
2348 224457 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 1201 San Jose Ave 48 Front Yard : Yard Tree Private 2     11     6004475.25628 2096098.33584 37.7357402479118 -122.42697287682 (37.7357402479118, -122.42697287682) 2 7 5 28861 2
6674 199411 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 1130 Connecticut St 1 Sidewalk: Property side : Yard Tree Private 2     22 Width 8ft   6013384.0629 2101740.31793 37.7517316642935 -122.396566819103 (37.7517316642935, -122.396566819103) 10 3 8 28856 29
30745 224455 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 1201 San Jose Ave 46 Front Yard : Yard Tree Private 2     20     6004472.96299 2096086.53305 37.7357077104384 -122.426979965259 (37.7357077104384, -122.426979965259) 2 7 5 28861 2
32062 201642 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6018952.65843 2095598.17526 37.7351749007894 -122.376883612016 (37.7351749007894, -122.376883612016) 10 3 8 58 1
35897 201652 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 14 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6018946.92095 2095551.1859 37.7350455611942 -122.376900190105 (37.7350455611942, -122.376900190105) 10 3 8 58 1
39668 201651 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6018949.0123 2095555.40146 37.7350572514812 -122.376893251826 (37.7350572514812, -122.376893251826) 10 3 8 58 1
40900 201644 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 7 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   6018951.31321 2095591.04744 37.7351552551001 -122.376887768675 (37.7351552551001, -122.376887768675) 10 3 8 58 1
41144 201650 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 12 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6018947.62701 2095560.29465 37.7350706109287 -122.376898380661 (37.7350706109287, -122.376898380661) 10 3 8 58 1
53389 201649 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 8 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6018951.64564 2095587.01417 37.7351441988378 -122.376886339628 (37.7351441988378, -122.376886339628) 10 3 8 58 1
58909 201638 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 17 Sidewalk: Property side : Yard Tree Private 2     20 Width 4ft   6018923.17152 2095473.93319 37.7348321322962 -122.376976943644 (37.7348321322962, -122.376976943644) 10 3 8 58 1
63018 201643 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 6 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6018953.75008 2095594.20439 37.7351640576797 -122.376879562369 (37.7351640576797, -122.376879562369) 10 3 8 58 1
66470 224458 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 1201 San Jose Ave 51 Front Yard : Yard Tree Private 2     9     6004518.02214 2096105.01586 37.735761007849 -122.426825494118 (37.735761007849, -122.426825494118) 2 7 5 28861 2
79168 201637 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 16 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6018946.91984 2095539.74446 37.7350141451746 -122.376899400488 (37.7350141451746, -122.376899400488) 10 3 8 58 1
85459 201645 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 8 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6018982.72037 2095633.61521 37.7352738675975 -122.376782133393 (37.7352738675975, -122.376782133393) 10 3 8 58 1
87341 23601 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 200X Vasquez Ave 13 Median : Cutout Tree DPW 1     24 60   5994426.954874 2098963.765109 37.7430347013579 -122.461921227095 (37.7430347013579, -122.461921227095) 1 8 4 59 40
90676 23600 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 200X Vasquez Ave 12 Median : Cutout Tree DPW 1     24 60   5994426.954874 2098963.765109 37.7430347013579 -122.461921227095 (37.7430347013579, -122.461921227095) 1 8 4 59 40
98255 201640 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   6018953.49192 2095604.52041 37.7351923692359 -122.376881170334 (37.7351923692359, -122.376881170334) 10 3 8 58 1
99491 224456 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 1201 San Jose Ave 47 Front Yard : Yard Tree Private 2     36     6004484.39806 2096094.7868 37.7357310199675 -122.42694101743 (37.7357310199675, -122.42694101743) 2 7 5 28861 2
99795 201653 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 15 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6018946.13424 2095546.77058 37.7350333942595 -122.376902603873 (37.7350333942595, -122.376902603873) 10 3 8 58 1
115366 199412 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 450 Amador St 5 Sidewalk: Curb side : Yard Tree Private 2     16     6017962.7763 2099598.99041 37.7461057708787 -122.380584028138 (37.7461057708787, -122.380584028138) 10 3 8 58 1
115637 201646 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 9 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6018949.93188 2095582.23588 37.7351309842009 -122.376891933413 (37.7351309842009, -122.376891933413) 10 3 8 58 1
123097 201647 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 10 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6018952.70623 2095578.53847 37.7351209846347 -122.376882084965 (37.7351209846347, -122.376882084965) 10 3 8 58 1
136032 201636 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6018955.1601 2095613.40679 37.735216861374 -122.376876019021 (37.735216861374, -122.376876019021) 10 3 8 58 1
139143 201648 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 11 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6018950.3933 2095564.6244 37.7350826519317 -122.376889116762 (37.7350826519317, -122.376889116762) 10 3 8 58 1
157209 201639 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 2 Sidewalk: Property side : Yard Tree Private 2     14 Width 4ft   6018953.99087 2095608.77642 37.7352040828873 -122.376879740411 (37.7352040828873, -122.376879740411) 10 3 8 58 1
177208 201641 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 4 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6018954.75158 2095601.04105 37.7351828849697 -122.376876573893 (37.7351828849697, -122.376876573893) 10 3 8 58 1

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