trees
25 rows where qSpecies_id = 299 sorted by DBH
This data as json, CSV (advanced)
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
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) );