21 rows where Neighborhoods (old) = 36 and qCaretaker_id = 7

View and edit SQL

These facets timed out: 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)
33650 251244 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 Grove St 5 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.7784411543423 -122.418166265193 (37.7784411543423, -122.418166265193) 7 9 9 28852 36
38544 14628 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 460 McAllister St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
40645 134568 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 Grove St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.7785206946058 -122.417028485685 (37.7785206946058, -122.417028485685) 7 9 9 28852 36
43608 112287 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 50 Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     5     6007006.5 2110627.3 37.7757762467653 -122.419251679167 (37.7757762467653, -122.419251679167) 7 9 9 28852 36
55672 23150 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 50 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     3 3X3   6007031.8302252 2110521.0652082 37.7754859780082 -122.419156518057 (37.7754859780082, -122.419156518057) 7 9 9 28852 36
56609 9951 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 95X Grove St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
65065 23151 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 50 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   08/24/1993 12:00:00 AM 8 3X3   6007030.5326516 2110530.1061031 37.7755107290659 -122.419161648128 (37.7755107290659, -122.419161648128) 7 9 9 28852 36
90491 134567 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 Grove St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.7784661768053 -122.417399738421 (37.7784661768053, -122.417399738421) 7 9 9 28852 36
94893 9952 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 95X Grove St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   07/06/2011 12:00:00 AM 3 3x3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
102440 14627 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 410X McAllister St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     35 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
110566 14098 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1480X Market St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6007076.6773563 2110527.4337913 37.7755059900951 -122.419001832587 (37.7755059900951, -122.419001832587) 7 2 9 28852 36
122483 14626 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 410X McAllister St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/05/2001 12:00:00 AM 20 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
125734 26896 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 460 McAllister St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
127129 23174 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 240 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     5 3x3   6006908.21847 2111432.04348 37.7779803432508 -122.419648771078 (37.7779803432508, -122.419648771078) 7 9 9 28852 36
128940 23156 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 50 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   08/24/1993 12:00:00 AM 18 3X3   6007006.484382 2110627.274272 37.7757761752428 -122.419251731369 (37.7757761752428, -122.419251731369) 7 9 9 28852 36
133044 9953 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 95X Grove St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   12/17/2009 12:00:00 AM 12 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
146362 134566 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 Grove St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     14 Width 4ft   6007493.55732 2111589.97349 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622) 7 9 9 28852 36
155906 134565 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 Grove St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.417850109903 (37.7784260904314, -122.417850109903) 7 9 9 28852 36
165205 9950 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 95X Grove St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
166064 14099 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1484 Market St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4X4   6007056.5524178 2110508.208095 37.7754520676647 -122.419070085744 (37.7754520676647, -122.419070085744) 7 2 9 28852 36
190500 23152 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 50 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   10/03/2000 12:00:00 AM 12     6007026.70172 2110556.798269 37.7755838036152 -122.419176794071 (37.7755838036152, -122.419176794071) 7 9 9 28852 36

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