trees
25 rows where qSpecies_id = 221 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2191 | 258156 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 13158 | 154045 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1667 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014820.42755 | 2097008.60163 | 37.7388191920383 | -122.391268911152 | (37.7388191920383, -122.391268911152) | 10 | 3 | 8 | 58 | 1 | |||
| 15137 | 258158 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 18084 | 258157 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 48929 | 161173 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 456 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 780460 | 6002228.93412 | 2090817.56022 | 37.7211131615129 | -122.434361845234 | (37.7211131615129, -122.434361845234) | 9 | 7 | 6 | 28861 | 5 | |
| 51935 | 2786 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3X3 | 5994220.38396 | 2110725.03348 | 37.7753162093806 | -122.463488837884 | (37.7753162093806, -122.463488837884) | 11 | 6 | 2 | 54 | 11 | ||
| 73928 | 68960 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 2115 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 32949 | 5988984.02499 | 2111212.07904 | 37.7763504110658 | -122.481638080092 | (37.7763504110658, -122.481638080092) | 11 | 6 | 2 | 55 | 26 | ||
| 85119 | 108487 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009617.99137 | 2111001.7892 | 37.7769512346475 | -122.410244280743 | (37.7769512346475, -122.410244280743) | 8 | 2 | 9 | 28853 | 34 | |
| 92171 | 111725 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1925 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775873 | 6004311.3 | 2115471.7 | 37.7889256068274 | -122.428920511272 | (37.7889256068274, -122.428920511272) | 13 | 9 | 11 | 29490 | 27 | |
| 143185 | 108486 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009630.79613 | 2110990.10713 | 37.7769198761764 | -122.410199159984 | (37.7769198761764, -122.410199159984) | 8 | 2 | 9 | 28853 | 34 | |
| 155696 | 108488 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009599.94268 | 2111020.96873 | 37.7770028854131 | -122.410308071481 | (37.7770028854131, -122.410308071481) | 8 | 2 | 9 | 28853 | 34 | |
| 173800 | 145780 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 668 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 5x5 | 5995361.33362 | 2111001.0466 | 37.7761397394883 | -122.459562051364 | (37.7761397394883, -122.459562051364) | 11 | 6 | 2 | 54 | 11 | |||
| 177255 | 7143 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 401X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2018 12:00:00 AM | 3 | 3X3 | 5994369 | 2110706 | 37.7752725100687 | -122.462973363335 | (37.7752725100687, -122.462973363335) | 11 | 6 | 2 | 54 | 11 | ||
| 177975 | 253128 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 129 Lisbon St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003441.61568 | 2092643.94308 | 37.7261967628488 | -122.430300196616 | (37.7261967628488, -122.430300196616) | 9 | 7 | 6 | 28861 | 5 | ||||
| 13240 | 157603 | Planning Code 138.1 required 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 16 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784681 | 6000322.25182 | 2101567.57465 | 37.7505217703771 | -122.441723777343 | (37.7505217703771, -122.441723777343) | 2 | 4 | 5 | 28862 | 22 | |
| 24328 | 82998 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1415 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52366 | 6016219.38097734 | 2093871.77074269 | 37.730283623423 | -122.386213312299 | (37.730283623423, -122.386213312299) | 10 | 3 | 8 | 58 | 1 | ||
| 46111 | 82590 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 3481 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2009 12:00:00 AM | 3x3 | Permit Number 52079 | 6006379.65364424 | 2104914.33986979 | 37.760054490361 | -122.421014380061 | (37.760054490361, -122.421014380061) | 2 | 4 | 7 | 28859 | 19 | ||
| 49687 | 254364 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 21 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781336 | 6010523.35323 | 2089998.97755 | 37.7193328216897 | -122.405632681809 | (37.7193328216897, -122.405632681809) | 10 | 7 | 8 | 309 | 39 |
| 103476 | 83298 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 98 Latona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52352 | 6014308.04996447 | 2094096.41838416 | 37.7307944841818 | -122.392836804394 | (37.7307944841818, -122.392836804394) | 10 | 3 | 8 | 58 | 1 | ||
| 107036 | 95131 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1500X North Point St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | Permit Number 54065 | 6003452.6 | 2121222.8 | 37.8046680023994 | -122.432302398634 | (37.8046680023994, -122.432302398634) | 13 | 9 | 1 | 57 | 17 | |||
| 116423 | 254365 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 21 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010523.35323 | 2089998.97755 | 37.7193328216897 | -122.405632681809 | (37.7193328216897, -122.405632681809) | 10 | 7 | 8 | 309 | 39 | |||
| 120447 | 75236 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1525 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774142 | 6007937 | 2109467 | 37.7726426982062 | -122.415950650711 | (37.7726426982062, -122.415950650711) | 8 | 2 | 9 | 28853 | 19 | |
| 130852 | 91381 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 3471 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769109 | 6006433 | 2104926 | 37.7600895133537 | -122.420830708097 | (37.7600895133537, -122.420830708097) | 2 | 4 | 7 | 28859 | 19 | |
| 137111 | 83304 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 98 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52352 | 6014308.04996447 | 2094096.41838416 | 37.7307944841818 | -122.392836804394 | (37.7307944841818, -122.392836804394) | 10 | 3 | 8 | 58 | 1 | ||
| 144209 | 177369 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 148 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781339 | 6004352.11158 | 2094019.24461 | 37.730024566162 | -122.427250583874 | (37.730024566162, -122.427250583874) | 9 | 7 | 6 | 28861 | 5 |
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) );