trees
140 rows where qSpecies_id = 125
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145459 | 49191 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 146414 | 91202 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2009 12:00:00 AM | 3 | 6003384.38178 | 2109395.59156 | 37.772189621885 | -122.431693533096 | (37.772189621885, -122.431693533096) | 15 | 9 | 11 | 29492 | 10 | |||
| 146656 | 49197 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 149983 | 6785 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1360 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 6x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
| 153476 | 35763 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3321 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558787 | (37.7633323895219, -122.41994558787) | 8 | 4 | 7 | 28859 | 19 | ||
| 153670 | 10320 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 758 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1992 12:00:00 AM | 25 | 3X3 | 6002531.73322 | 2109228.96362 | 37.771683734939 | -122.434630996687 | (37.771683734939, -122.434630996687) | 15 | 5 | 11 | 29492 | 9 | ||
| 153802 | 91221 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 597 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003327.2605 | 2109254.11842 | 37.7717979333979 | -122.431881016883 | (37.7717979333979, -122.431881016883) | 15 | 9 | 11 | 29492 | 10 | ||
| 156172 | 93230 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 160 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092 | 2108018 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | 7 | 9 | 5 | 28862 | 3 | ||
| 157255 | 48637 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | 1 | 5 | 4 | 56 | 12 | ||
| 158192 | 10266 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 212 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005102.22381 | 2109572.21051 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | 7 | 9 | 11 | 28852 | 10 | |||
| 158443 | 91210 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 333 Haight St | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 6004540.59043 | 2109422.99046 | 37.7723303224715 | -122.427696060061 | (37.7723303224715, -122.427696060061) | 7 | 9 | 11 | 28852 | 10 | |||
| 159504 | 60428 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 427 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30410 | 6003803.88116194 | 2098922.41171053 | 37.7434565282269 | -122.429495418306 | (37.7434565282269, -122.429495418306) | 2 | 7 | 5 | 63 | 22 | ||
| 159619 | 61667 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 235 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2016 12:00:00 AM | 3 | Permit Number 777577 | 6004178.04494694 | 2107496.55994699 | 37.7670202972864 | -122.428812778191 | (37.7670202972864, -122.428812778191) | 8 | 4 | 5 | 28862 | 3 | |
| 161273 | 14967 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 395 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 6016770.71768 | 2097736.29352 | 37.7409253302671 | -122.384576328932 | (37.7409253302671, -122.384576328932) | 10 | 3 | 8 | 58 | 1 | ||
| 162316 | 44082 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 184 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.7656631551561 | -122.44681260549 | (37.7656631551561, -122.44681260549) | 15 | 5 | 11 | 29492 | 9 | |||
| 165587 | 51667 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 60 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2016 12:00:00 AM | 3 | Permit Number 775035 | 6006687.11060944 | 2109504.63064776 | 37.7726756731813 | -122.420276830729 | (37.7726756731813, -122.420276830729) | 8 | 2 | 9 | 28853 | 19 | |
| 168716 | 67115 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1000 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30534 | 5998132.38450691 | 2106832.35950645 | 37.7648525393869 | -122.449675814605 | (37.7648525393869, -122.449675814605) | 15 | 5 | 11 | 29492 | 9 | ||
| 169360 | 87378 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 950 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3x3 | Permit Number 50360 | 5999753.9 | 2102061.4 | 37.7518452950477 | -122.443724648053 | (37.7518452950477, -122.443724648053) | 2 | 5 | 5 | 63 | 38 | ||
| 172276 | 10297 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 540 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003554.89128 | 2109371.3672 | 37.7721327712956 | -122.431101997147 | (37.7721327712956, -122.431101997147) | 15 | 9 | 11 | 29492 | 10 | ||
| 173088 | 39301 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) | 8 | 4 | 7 | 28859 | 19 |
| 175386 | 93304 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 505 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236 | 2105969 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | 8 | 4 | 5 | 28862 | 3 | ||
| 176797 | 93306 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 465 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004251 | 2106168 | 37.7633765197798 | -122.428465731621 | (37.7633765197798, -122.428465731621) | 8 | 4 | 5 | 28862 | 3 | ||
| 177014 | 91116 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3838 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2009 12:00:00 AM | 3 | 4x4 | Permit Number 52006 | 6004047 | 2104828 | 37.7596856536801 | -122.429075753932 | (37.7596856536801, -122.429075753932) | 2 | 4 | 5 | 28862 | 3 |
| 177435 | 27324 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 320 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 09:31:00 AM | 3 | 4x4 | 6004588.93351 | 2109631.91786 | 37.7729067207461 | -122.427543724178 | (37.7729067207461, -122.427543724178) | 7 | 9 | 11 | 28852 | 10 | ||
| 179400 | 91216 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 451 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6003988.48556 | 2109346.14809 | 37.7720880862632 | -122.429600359958 | (37.7720880862632, -122.429600359958) | 7 | 9 | 11 | 29492 | 10 | ||
| 180367 | 244496 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 478 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 4 | Width 0ft | 6003878.5797 | 2109399.3843 | 37.7722280361906 | -122.429984331292 | (37.7722280361906, -122.429984331292) | 7 | 9 | 11 | 29492 | 10 | ||
| 180418 | 93235 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 512 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004170.4 | 2105921.7 | 37.7626956775589 | -122.428726941839 | (37.7626956775589, -122.428726941839) | 8 | 4 | 5 | 28862 | 3 | ||
| 180525 | 32828 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.437246939262 | (37.7511683628484, -122.437246939262) | 2 | 4 | 5 | 28862 | 22 | ||
| 181586 | 93234 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 306 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | 8 | 4 | 5 | 28862 | 3 | ||
| 181634 | 10265 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 212 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005102.22381 | 2109572.21051 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | 7 | 9 | 11 | 28852 | 10 | |||
| 183390 | 48636 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | 1 | 5 | 4 | 56 | 12 |
| 183458 | 93307 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 445 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 07:00:00 AM | 3 | 3x3 | 6004245 | 2106273 | 37.7636644851039 | -122.428493968337 | (37.7636644851039, -122.428493968337) | 8 | 4 | 5 | 28862 | 3 | ||
| 183479 | 36113 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.7647227313074 | -122.471822291529 | (37.7647227313074, -122.471822291529) | 11 | 8 | 11 | 56 | 12 | ||
| 184615 | 30691 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52599 | 6006108.61199537 | 2109713.28983155 | 37.7732159867663 | -122.422292750625 | (37.7732159867663, -122.422292750625) | 7 | 9 | 11 | 28852 | 10 | ||
| 186870 | 49200 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | 3x3 | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |
| 187273 | 93309 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 309 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6004203 | 2107120 | 37.7659877668224 | -122.428699616217 | (37.7659877668224, -122.428699616217) | 8 | 4 | 5 | 28862 | 3 | ||
| 188035 | 91207 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004300.94327 | 2109389.6362 | 37.7722251810056 | -122.428522643794 | (37.7722251810056, -122.428522643794) | 7 | 9 | 11 | 28852 | 10 | ||
| 190839 | 93231 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 160 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092 | 2108018 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | 7 | 9 | 5 | 28862 | 3 | ||
| 191744 | 122810 | Undocumented 4 | Hymenosporum flavum :: Sweet Shade 125 | 1801 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005422 | 2107198 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | 8 | 4 | 5 | 28853 | 19 | ||||
| 192357 | 91218 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 421 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6004113.63754 | 2109346.83608 | 37.7720970608608 | -122.429167498253 | (37.7720970608608, -122.429167498253) | 7 | 9 | 11 | 29492 | 10 |
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) );