trees

27 rows where Neighborhoods (old) = 11 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

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)
5657 41933 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42292 5994729.71498 2111330.05881 37.7770067806052 -122.461770835952 (37.7770067806052, -122.461770835952) 11 6 2 54 11
23653 90897 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992033.67177 2110642.90774 37.7749644818454 -122.471047125233 (37.7749644818454, -122.471047125233) 11 6 2 54 11
27091 90555 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992035.9437 2110699.81053 37.7751208528883 -122.471043412514 (37.7751208528883, -122.471043412514) 11 6 2 54 11
34046 31982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 232 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12 3x3 Permit Number 35382 5994946.26899 2113981.48738 37.7842993574965 -122.461213955921 (37.7842993574965, -122.461213955921) 11 6 2 54 11
38813 90554 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992007.5751 2110699.64473 37.7751187568292 -122.471141532792 (37.7751187568292, -122.471141532792) 11 6 2 54 11
39857 8913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4455X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5993194.92162 2112721.50101 37.7807388335807 -122.467181309852 (37.7807388335807, -122.467181309852) 11 6 2 54 11
44084 41912 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 642 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42274 5992258.1025 2111064.36491 37.7761346671426 -122.470301476833 (37.7761346671426, -122.470301476833) 11 6 2 54 11
61838 90896 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992053.33041 2110644.47867 37.7749699321879 -122.47097923688 (37.7749699321879, -122.47097923688) 11 6 2 54 11
64123 123208 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5993131.19371 2112699.04699 37.7806735020779 -122.467400140372 (37.7806735020779, -122.467400140372) 11 6 2 54 11
74281 34259 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 164 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 12   Permit Number 39598 5993996.78061 2114472.4725 37.7855927810379 -122.464534489449 (37.7855927810379, -122.464534489449) 11 6 1 54 11
76553 123210 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993133.98431 2112655.94122 37.7805553064396 -122.467387351051 (37.7805553064396, -122.467387351051) 11 6 2 54 11
87429 41913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 642 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42274 5992259.32657 2111046.49076 37.7760856603427 -122.470295940533 (37.7760856603427, -122.470295940533) 11 6 2 54 11
100139 67314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 666 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1992 12:00:00 AM 7   Permit Number 30795 5992883.6827 2110925.23066 37.77578879069 -122.468127322089 (37.77578879069, -122.468127322089) 11 6 2 54 11
101968 41934 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 615 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 5   Permit Number 42293 5994683.51563 2111320.01316 37.7769765383201 -122.461929924013 (37.7769765383201, -122.461929924013) 11 6 2 54 11
103672 36967 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 9   Permit Number 39594 5994314.22367 2112999.17695 37.7815658043957 -122.463329288102 (37.7815658043957, -122.463329288102) 11 6 2 54 11
113993 36966 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 7   Permit Number 39594 5994314.52093 2112981.13075 37.7815162715185 -122.463326949801 (37.7815162715185, -122.463326949801) 11 6 2 54 11
116652 123211 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993134.492 2112639.50466 37.7805102054167 -122.467384399185 (37.7805102054167, -122.467384399185) 11 6 2 54 11
116896 124090 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 601 Funston Ave 5 Sidewalk: Property side : Yard Tree Private 2     12     5991893.39709 2111137.10441 37.7763132974782 -122.471568380763 (37.7763132974782, -122.471568380763) 11 6 2 54 11
123918 34257 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 160 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 9   Permit Number 39597 5993997.84726 2114498.92628 37.7856654774057 -122.464532720679 (37.7856654774057, -122.464532720679) 11 6 1 54 11
130878 123179 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 771 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992862.96444 2110216.56004 37.7738417753505 -122.468147428182 (37.7738417753505, -122.468147428182) 11 6 2 54 11
132385 44257 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 122 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2001 12:00:00 AM 9   Permit Number 43690 5993988.26127 2114691.75826 37.7861943888941 -122.464579892109 (37.7861943888941, -122.464579892109) 11 6 1 54 11
142722 111741 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 498x 11th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5992530.71883 2112167.74428 37.7791800053719 -122.469438767189 (37.7791800053719, -122.469438767189) 11 6 2 54 11
143264 31983 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 252 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 7 3x3 Permit Number 35383 5994950.72464 2113855.38064 37.7839533587811 -122.461189396885 (37.7839533587811, -122.461189396885) 11 6 2 54 11
144340 43686 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 162 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 4   Permit Number 43330 5993378.79836 2114426.59889 37.785431180637 -122.46666917492 (37.785431180637, -122.46666917492) 11 6 2 54 11
150853 34256 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 156 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 4   Permit Number 39596 5993995.61311 2114522.39441 37.78572978571 -122.46454215478 (37.78572978571, -122.46454215478) 11 6 1 54 11
157957 88525 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 626x Funston Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51466 5991969.3 2111151 37.7763558419216 -122.471306826694 (37.7763558419216, -122.471306826694) 11 6 2 54 11
191980 123105 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 498 11th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992529.16869 2112181.64232 37.7792180760249 -122.469445141648 (37.7792180760249, -122.469445141648) 11 6 2 54 11

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