trees

56 rows where qLegalStatus_id = 4 and qSpecies_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 56 ✖
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)
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
2450 251744 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
6331 261440 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 374x Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007239 2095686 37.7347639531109 -122.417388303298 (37.7347639531109, -122.417388303298) 2 7 7 28859 2
8807 224036 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/16/2016 07:10:00 AM 2 Width 3ft   6002606.66337 2101060.9954 37.7492607194187 -122.433787912303 (37.7492607194187, -122.433787912303) 2 4 5 28862 22
9259 112872 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 599x CENTRAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5999621 2110473 37.7749338721416 -122.444788804756 (37.7749338721416, -122.444788804756) 15 5 11 29492 16
10631 106353 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 3520X 26TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6006283 2100840 37.7488618444312 -122.421059362487 (37.7488618444312, -122.421059362487) 2 4 5 28859 19
14883 242086 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4185 25th St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/16/2016 05:57:00 AM 2 Width 3ft   6002948.22198 2101215.85126 37.7497052929799 -122.432617857444 (37.7497052929799, -122.432617857444) 2 4 5 28862 22
21310 254733 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 398 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM   3x3   6008656 2108503 37.7700361768699 -122.413395357755 (37.7700361768699, -122.413395357755) 8 2 9 28853 19
22315 113814 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:05:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
27608 251772 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
29910 172261 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 230 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6001860 2086600 37.7095117275676 -122.435335608043 (37.7095117275676, -122.435335608043) 9 7 6 28861 5
39029 103456 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 410 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003658 2091068 37.721881827041 -122.429439831937 (37.721881827041, -122.429439831937) 9 7 6 28861 5
41732 114444 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
42029 254843 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1814 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   5993025 2112122 37.7790829564028 -122.467725532477 (37.7790829564028, -122.467725532477) 11 6 2 54 11
42971 103367 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 290X Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006718.6 2102097 37.7523378256517 -122.419642228322 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
45628 251771 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
48117 254837 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 130 11th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   5992465 2114587 37.7858188208387 -122.469842298582 (37.7858188208387, -122.469842298582) 11 6 2 54 11
49306 112862 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1732 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5990594 2098423 37.7413284897401 -122.475134938873 (37.7413284897401, -122.475134938873) 1 8 4 29491 40
50209 97899 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
51660 122788 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1655 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007172 2109097 37.7715837270561 -122.418570631079 (37.7715837270561, -122.418570631079) 8 2 9 28853 19
53756 251780 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1219 Naples St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001110 2087312 37.7114241006266 -122.437978695611 (37.7114241006266, -122.437978695611) 9 7 6 28861 5
55160 108690 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 61 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005327.5 2105108.8 37.7605290659119 -122.424667111807 (37.7605290659119, -122.424667111807) 2 4 5 28859 19
56396 103366 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 290X Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 769396 6006718.6 2102097 37.7523378256517 -122.419642228322 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
63011 102695 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 384 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000881 2096712 37.7372213335044 -122.439443565515 (37.7372213335044, -122.439443565515) 2 7 5 63 7
64253 114443 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
69384 115938 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 718 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 773052 5991032 2110485 37.7744729248175 -122.474500561298 (37.7744729248175, -122.474500561298) 11 6 2 54 26
76386 180625 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 18 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 6ft   6002816.84046 2087215.85653 37.7112570289525 -122.432072557104 (37.7112570289525, -122.432072557104) 9 7 6 28861 5
81015 97898 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
87336 113817 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:00:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
88456 113809 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 06/15/2016 07:36:00 AM 3 5x5   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
90434 113818 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 05:57:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
91138 114442 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
91912 107688 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 300X ALEMANY BLVD 2 Sidewalk: Property side : Cutout Tree Private 2     16     6008820.4 2095497.5 37.7343352217744 -122.411907523711 (37.7343352217744, -122.411907523711) 10 7 7 28859 2
99511 114445 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
102701 223409 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010169.99414 2104057.76493 37.7579154611487 -122.407844947098 (37.7579154611487, -122.407844947098) 2 4 7 28859 19
109418 181738 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 2803 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5986967.0668 2107072.067 37.7648656060734 -122.488310893002 (37.7648656060734, -122.488310893002) 1 8 3 56 35
109710 97896 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
118346 105752 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 67 LANDERS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6004519.3 2107402.1 37.7667802417179 -122.427625698984 (37.7667802417179, -122.427625698984) 8 4 5 28862 3
122742 110457 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 501 TARAVAL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775373 5991635.3 2099042.5 37.7430897750827 -122.471579655796 (37.7430897750827, -122.471579655796) 1 8 4 29491 40
122980 107236 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 3326 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2015 12:00:00 AM     Permit Number 775776 6006851 2102663.4 37.7539004875763 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
126964 97897 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
134922 106798 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 39 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009957 2113442 37.783670474647 -122.409243780474 (37.783670474647, -122.409243780474) 14 10 9 28852 36
136341 113703 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 14 LUNDYS LN 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6007138 2099599 37.7455024988094 -122.418014802057 (37.7455024988094, -122.418014802057) 2 7 7 28859 2
148937 114446 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 367 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010572 2098095 37.7415655155901 -122.406034574078 (37.7415655155901, -122.406034574078) 10 3 8 58 1
155183 113826 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1599x CASTRO ST 4 Sidewalk: Curb side : Cutout Tree Private 2   02/16/2016 07:10:00 AM 3 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
156242 254734 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 398 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM   3x3   6008656 2108503 37.7700361768699 -122.413395357755 (37.7700361768699, -122.413395357755) 8 2 9 28853 19
158252 251761 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 236 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001827 2086593 37.7094906329517 -122.435449161052 (37.7094906329517, -122.435449161052) 9 7 6 28861 5
161023 116584 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 33 GOUGH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006450 2109317 37.7721471206774 -122.421083698286 (37.7721471206774, -122.421083698286) 8 2 9 28853 19
166045 113827 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/16/2016 05:50:00 AM 3 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
168353 180626 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 18 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 6ft   6002802.39914 2087193.02957 37.7111935323316 -122.432120840807 (37.7111935323316, -122.432120840807) 9 7 6 28861 5
172911 114448 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 367 BAY SHORE BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010572 2098095 37.7415655155901 -122.406034574078 (37.7415655155901, -122.406034574078) 10 3 8 58 1
173521 99792 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4120-4124 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6002399 2101817 37.7513247429435 -122.434560064215 (37.7513247429435, -122.434560064215) 2 4 5 28862 22
188515 111022 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1254 07TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993942 2106950 37.7649349225469 -122.464177708405 (37.7649349225469, -122.464177708405) 11 5 11 56 12
189482 97895 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
194407 265071 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 430 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000887 2092304 37.7251183251209 -122.439106989741 (37.7251183251209, -122.439106989741) 9 7 6 28861 25

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