33 rows where qSpecies_id = 173

View and edit SQL

Suggested facets: PermitNotes, Fire Prevention Districts, Police Districts, 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)
1137 24844 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 200X Alemany Blvd 22 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
19904 107842 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
20892 98486 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 11 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
50644 82681 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1 Ignacio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
52187 202057 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 1249 Jamestown Ave 7 Sidewalk: Property side : Yard Tree Private 2     8     6012780.62954 2090484.81642 37.7207928041369 -122.397864130747 (37.7207928041369, -122.397864130747) 10 3 8 58 1
60895 36135 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1708 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39228 5990464.01756752 2106564.28679839 37.7636747855938 -122.47617887015 (37.7636747855938, -122.47617887015) 11 8 3 56 12
64573 107843 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
66051 82678 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1 Ignacio Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
71967 82680 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1 Ignacio Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
72412 98474 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6x6   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
73564 202058 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 1249 Jamestown Ave 8 Sidewalk: Property side : Yard Tree Private 2     13     6012815.62965 2090457.48814 37.7207197153194 -122.397741229389 (37.7207197153194, -122.397741229389) 10 3 8 58 1
98108 82682 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1 Ignacio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
102541 36134 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1708 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39228 5990464.01756752 2106564.28679839 37.7636747855938 -122.47617887015 (37.7636747855938, -122.47617887015) 11 8 3 56 12
109610 49956 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 541@ ALVARADO Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2003 12:00:00 AM     Permit Number 46710 6001870.95362569 2102681.92847846 37.7536696397315 -122.43644800428 (37.7536696397315, -122.43644800428) 2 4 5 28862 22
110766 107841 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6009830.23681 2109237.43291 37.7721186188114 -122.40938551093 (37.7721186188114, -122.40938551093) 14 2 9 28853 34
113087 112151 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 299x SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     10 3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
114676 98482 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
118106 82679 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 1 Ignacio Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
124653 107845 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
131874 82706 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 728 Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52492 6015281.34869038 2088403.74887582 37.7152175495908 -122.389074606621 (37.7152175495908, -122.389074606621) 10 3 8 58 1
148605 107846 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09th St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009780.079 2109294.20341 37.7722716870121 -122.409563019144 (37.7722716870121, -122.409563019144) 14 2 9 28853 34
152434 24828 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 200X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
159959 98480 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
160396 82709 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 9 Ignacio Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52491 6015428.30253867 2088370.80983531 37.7151352504121 -122.388564367914 (37.7151352504121, -122.388564367914) 10 3 8 58 1
173628 107840 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009841.61073 2109223.26408 37.7720803517525 -122.409345167358 (37.7720803517525, -122.409345167358) 14 2 9 28853 34
178220 107844 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
179653 97035 Property Tree 8 Casurina stricta :: Beefwood: Drooping She-Oak 173 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
183148 112154 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 299x SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
183621 98476 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
184860 112153 Undocumented 4 Casurina stricta :: Beefwood: Drooping She-Oak 173 299x SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
185188 98484 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
186752 24839 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 200X Alemany Blvd 17 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 30 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
194057 107847 DPW Maintained 1 Casurina stricta :: Beefwood: Drooping She-Oak 173 407 09th St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6009772.46475 2109302.10129 37.7722929460963 -122.409589915155 (37.7722929460963, -122.409589915155) 14 2 9 28853 34

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