25 rows where qSpecies_id = 299 sorted by DBH

View and edit SQL

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)
144532 98359 Permitted Site 7 Archontophoenix cunninghamiana :: King Palm 299 1250 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2012 12:00:00 AM   3x5 Permit Number 768652 6008140.4 2116796.9 37.7927802707336 -122.415766176937 (37.7927802707336, -122.415766176937) 5 1 10 28858 21
175556 92081 Permitted Site 7 Archontophoenix cunninghamiana :: King Palm 299 25 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2009 12:00:00 AM   3x3 Permit Number 52194 6007436.7 2099911.5 37.7463773607013 -122.41700407936 (37.7463773607013, -122.41700407936) 2 7 7 28859 2
76362 247215 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 800 Duboce Ave 10 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6001826.705 2108295.2361 37.7690799013478 -122.437002868995 (37.7690799013478, -122.437002868995) 15 5 5 29492 9
149875 188237 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1740 20th St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6012748.31397 2104746.48388 37.759950538805 -122.398976312419 (37.759950538805, -122.398976312419) 10 3 8 28856 29
29385 221180 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 337 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007817.66801 2105929.51758 37.7629228899011 -122.416112860719 (37.7629228899011, -122.416112860719) 8 4 7 28859 19
29444 221181 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 3390 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005792.21376 2103175.01124 37.7552455682348 -122.422922435533 (37.7552455682348, -122.422922435533) 2 4 5 28859 19
79346 188238 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1799 Revere Ave 5 Sidewalk: Curb side : Yard Tree Private 2     20     6014043.66547 2095150.32578 37.7336736103466 -122.393824573063 (37.7336736103466, -122.393824573063) 10 3 8 58 1
6420 26181 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 480 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2006 12:00:00 AM 3 2x2 Permit Number 772904 6002282 2105385 37.7611149721712 -122.435219844509 (37.7611149721712, -122.435219844509) 15 4 5 28862 3
10628 28714 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 495 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2004 12:00:00 AM 3 3x3 Permit Number 772904 6002370.93683 2105344.55131 37.7610089599056 -122.434909357897 (37.7610089599056, -122.434909357897) 15 4 5 28862 3
18727 245360 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 427 Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/23/2018 12:00:00 AM 3 6x5   6002354.10634 2105669.80304 37.7619010667053 -122.434990829274 (37.7619010667053, -122.434990829274) 15 4 5 28862 3
66006 53249 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 348 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1969 12:00:00 AM 3   Permit Number 6134 6013733.31387 2105486.4947 37.7620372852031 -122.39562149856 (37.7620372852031, -122.39562149856) 10 3 8 28856 29
34816 218218 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 399 Wawona St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5991827.81177 2097037.50439 37.73759570307 -122.470767994372 (37.73759570307, -122.470767994372) 1 8 4 59 40
112153 120846 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 295 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   5989915.56794 2113413.68819 37.7824495421017 -122.478576688059 (37.7824495421017, -122.478576688059) 11 6 2 55 26
113763 188236 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1108 Rhode Island St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6011896.7371 2103246.34422 37.755783996849 -122.401816071954 (37.755783996849, -122.401816071954) 10 3 8 28856 29
155212 188234 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1108 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6011896.09568 2103259.40011 37.7558198096579 -122.401819207896 (37.7558198096579, -122.401819207896) 10 3 8 28856 29
172145 188235 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1108 Rhode Island St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6011896.48245 2103252.68741 37.7558013996435 -122.40181739848 (37.7558013996435, -122.40181739848) 10 3 8 28856 29
193368 246750 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 178 Ripley St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009174.6087 2099095.18815 37.744233556835 -122.410936923308 (37.744233556835, -122.410936923308) 2 7 7 28859 2
24950 123160 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 475 10th Ave 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5992783.47528 2112204.70134 37.7792960831388 -122.468567076178 (37.7792960831388, -122.468567076178) 11 6 2 54 11
119565 205610 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 120 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5994595.146 2093153.51245 37.7270908589421 -122.460918655266 (37.7270908589421, -122.460918655266) 9 8 4 28861 40
178563 246275 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 338 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6002907.6704 2106201.8811 37.7633934402788 -122.433114288821 (37.7633934402788, -122.433114288821) 15 4 5 28862 3
71034 188233 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1301 Minnesota St 77 Front Yard : Yard Tree Private 2     6     6015365.73564 2102250.10516 37.7532415189935 -122.389749475967 (37.7532415189935, -122.389749475967) 10 3 8 28856 29
110226 221179 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1706 Dolores St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6005259.96974 2098394.13511 37.7420883355977 -122.424423058674 (37.7420883355977, -122.424423058674) 2 7 5 63 7
127609 39589 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 1108 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 8   Permit Number 41000 6011896.10584 2103264.60859 37.7558341115663 -122.40181953886 (37.7558341115663, -122.40181953886) 10 3 8 28856 29
30012 221183 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 3484 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003685.99525 2106582.50887 37.7644826722523 -122.430449475988 (37.7644826722523, -122.430449475988) 8 4 5 28862 3
32411 221182 DPW Maintained 1 Archontophoenix cunninghamiana :: King Palm 299 205 Montcalm St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6010035.74465 2099690.44727 37.7459162585454 -122.408001257372 (37.7459162585454, -122.408001257372) 2 7 7 28859 2

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