trees

25 rows where qCareAssistant = "FUF" and qLegalStatus_id = 9 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

qCareAssistant ✖

  • FUF · 19 ✖
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)
88394 39627 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 199X Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
96093 39626 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 1550 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
126097 39629 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 199X Carmel St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
166399 39628 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 199X Carmel St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 5   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
8224 254835 Private 9 Ulmus parvifolia :: Chinese Elm 31 250 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2019 12:00:00 AM 3 4x3 Permit Number 784635 5989365 2113673 37.7831295589045 -122.480500378386 (37.7831295589045, -122.480500378386) 11 6 2 55 26
23696 108446 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 672 05th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773773 5994431.81479 2110948.53978 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163) 11 6 2 54 11
65512 108459 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
99316 108440 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
171901 82180 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 105 Lake St 1 Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
187934 108441 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
190320 72375 Private 9 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
14848 260375 Private 9 Tree(s) :: 17 67 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2019 12:00:00 AM 3 3x3 Permit Number 784562 5999904.1409 2088281.96487 37.714018757491 -122.442216028541 (37.714018757491, -122.442216028541) 9 7 6 28861 5
3361 261454 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
8479 204048 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
8858 261455 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
11157 261456 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
15121 261452 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
15415 261457 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
16566 261453 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24

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