trees

19 rows where Supervisor Districts = 7 and qSpecies_id = 34

✎ 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)
151 233915 DPW Maintained 1 Persea americana :: Avocado 34 998 York St 9 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009943.01185 2103432.65253 37.7561863328563 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
26444 13357 DPW Maintained 1 Persea americana :: Avocado 34 638 Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010007.9165631 2090278.8375457 37.7200724231428 -122.407434081538 (37.7200724231428, -122.407434081538) 10 3 7 309 28
61056 248086 DPW Maintained 1 Persea americana :: Avocado 34 64 Peralta Ave 1 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6010586.08965 2100411.89734 37.7479280005978 -122.406149049637 (37.7479280005978, -122.406149049637) 2 7 7 28859 2
66575 255607 Undocumented 4 Persea americana :: Avocado 34 347 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006753 2104097 37.7578313031701 -122.419665158689 (37.7578313031701, -122.419665158689) 2 4 7 28859 19
66903 233917 Significant Tree 6 Persea americana :: Avocado 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree Private 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
101123 256285 Significant Tree 6 Persea americana :: Avocado 34 155x Caledonia St 1 Back Yard : Yard Tree Private 2       3x3   6006400 2106945 37.765631353558 -122.421088199968 (37.765631353558, -122.421088199968) 8 4 7 28853 19
131275 233913 DPW Maintained 1 Persea americana :: Avocado 34 2801 Mariposa St 4 : Tree Private 2     4 Width 3ft   6009155.31558 2105892.63028 37.7628967259343 -122.411483776778 (37.7628967259343, -122.411483776778) 8 4 7 28859 19
132278 233918 DPW Maintained 1 Persea americana :: Avocado 34 60 Murray St 3 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6004967.71802 2095266.36658 37.7334836807325 -122.425211061736 (37.7334836807325, -122.425211061736) 2 7 7 28861 2
139362 255610 DPW Maintained 1 Persea americana :: Avocado 34 355X San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006938 2104061 37.7577428748963 -122.419022796788 (37.7577428748963, -122.419022796788) 2 4 7 28859 19
159885 178080 DPW Maintained 1 Persea americana :: Avocado 34 202 University St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008024.94769 2092933.54254 37.7272504886183 -122.41447630234 (37.7272504886183, -122.41447630234) 9 3 7 309 28
167482 178081 DPW Maintained 1 Persea americana :: Avocado 34 913 Silliman St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008142.94596 2093501.21518 37.728815824271 -122.414108525499 (37.728815824271, -122.414108525499) 9 3 7 309 28
169065 108625 Property Tree 8 Persea americana :: Avocado 34 100 GENEBERN WAY 1 Front Yard : Yard Tree Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
172650 255483 Significant Tree 6 Persea americana :: Avocado 34 1295 Hampshire St 1 Front Yard : Yard Tree Private 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
179943 233916 DPW Maintained 1 Persea americana :: Avocado 34 3178 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008600.98611 2100616.94315 37.7483797759052 -122.413027970288 (37.7483797759052, -122.413027970288) 2 4 7 28859 19
185497 246695 DPW Maintained 1 Persea americana :: Avocado 34 1 Bonview St 1 Sidewalk: Curb side : Yard Tree Private 2     1     6007634.96405 2098994.37065 37.7438702793061 -122.416253557858 (37.7438702793061, -122.416253557858) 2 7 7 28859 2
185503 246696 DPW Maintained 1 Persea americana :: Avocado 34 1 Bonview St 2 Sidewalk: Curb side : Yard Tree Private 2     1     6007645.436 2099008.47184 37.7439095868695 -122.4162183467 (37.7439095868695, -122.4162183467) 2 7 7 28859 2
186058 248211 DPW Maintained 1 Persea americana :: Avocado 34 67 Fair Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6007036.37972 2099436.77793 37.7450513535288 -122.418354689821 (37.7450513535288, -122.418354689821) 2 7 7 28859 2
192056 233919 DPW Maintained 1 Persea americana :: Avocado 34 60 Murray St 4 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6004972.94282 2095265.21393 37.7334808109789 -122.425192916113 (37.7334808109789, -122.425192916113) 2 7 7 28861 2
193450 233912 DPW Maintained 1 Persea americana :: Avocado 34 2801 Mariposa St 2 : Tree Private 2     3 Width 3ft   6009119.38716 2105891.31096 37.7628910880777 -122.411607947957 (37.7628910880777, -122.411607947957) 8 4 7 28859 19

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