trees
47 rows where qSpecies_id = 273
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4073 | 114536 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 1485 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | 3x3 | Permit Number 776941 | 6009615.7 | 2100644.1 | 37.748511252235 | -122.409521014405 | (37.748511252235, -122.409521014405) | 2 | 4 | 7 | 28859 | 19 | ||
| 12574 | 58273 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 211 Brighton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 09/20/1978 12:00:00 AM | Permit Number 17285 | 5996205.3244984 | 2091294.13562794 | 37.7220779724875 | -122.455218010255 | (37.7220779724875, -122.455218010255) | 9 | 8 | 4 | 28861 | 24 | |||
| 20152 | 198428 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 1560 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 6013411.47886 | 2103834.62991 | 37.7574837182091 | -122.396618808037 | (37.7574837182091, -122.396618808037) | 10 | 3 | 8 | 28856 | 29 | ||||
| 22437 | 114716 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 27792 | 121374 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 34993 | 10 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 97 12th St | 4 | Median : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | 8 | 2 | 9 | 28853 | 19 | |||
| 37050 | 252828 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 7 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
| 44925 | 50001 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 1101X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014343 | 2105248 | 37.7614163256175 | -122.393496122336 | (37.7614163256175, -122.393496122336) | 10 | 3 | 8 | 28856 | 29 |
| 48127 | 122813 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 889 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009956.83094511 | 2104043.07852524 | 37.7578631996098 | -122.40858112242 | (37.7578631996098, -122.40858112242) | 2 | 4 | 7 | 28859 | 19 | ||||
| 58625 | 93973 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden gate Ave Roselyn Ter | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 1 on Golden gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
| 71677 | 50006 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 400 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2004 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014320.5085713 | 2105254.32227407 | 37.761432435497 | -122.393574353924 | (37.761432435497, -122.393574353924) | 10 | 3 | 8 | 28856 | 29 |
| 74390 | 254285 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 298 Ward St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011279 | 2089720 | 37.7186090323503 | -122.403001067047 | (37.7186090323503, -122.403001067047) | 10 | 7 | 8 | 309 | 28 | |||||
| 74976 | 114712 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 79705 | 233907 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6009190.66745 | 2106248.17582 | 37.7638749553765 | -122.411386625691 | (37.7638749553765, -122.411386625691) | 8 | 4 | 7 | 28859 | 19 | ||||
| 81377 | 233905 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6009177.10779 | 2106306.71252 | 37.7640349231894 | -122.411437660415 | (37.7640349231894, -122.411437660415) | 8 | 4 | 7 | 28859 | 19 | ||||
| 81849 | 39106 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 3380 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2009 12:00:00 AM | 3x3 | Permit Number 52869 | 6007272.11335441 | 2100921.86164387 | 37.749142326182 | -122.417644801895 | (37.749142326182, -122.417644801895) | 2 | 4 | 7 | 28859 | 19 | ||
| 84692 | 198429 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 1560 22nd St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6013408.61028 | 2103841.14201 | 37.7575014393701 | -122.3966291853 | (37.7575014393701, -122.3966291853) | 10 | 3 | 8 | 28856 | 29 | ||||
| 85316 | 114713 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 99539 | 4279 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 4262 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6002186.2336 | 2100363.93784 | 37.7473228978664 | -122.435191912932 | (37.7473228978664, -122.435191912932) | 2 | 4 | 5 | 63 | 22 | |||
| 105165 | 103698 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 1306 Montgomery St | 1 | Median : | Tree | DPW 1 | 24 | 6011461.60472 | 2119835.9957 | 37.8013110378213 | -122.404488622371 | (37.8013110378213, -122.404488622371) | 3 | 1 | 10 | 308 | 23 | ||||
| 106483 | 50000 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 1101X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014343 | 2105248 | 37.7614163256175 | -122.393496122336 | (37.7614163256175, -122.393496122336) | 10 | 3 | 8 | 28856 | 29 |
| 107285 | 121373 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 112667 | 114715 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 113017 | 59642 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 783 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19053 | 6002834.53649888 | 2109552.08345216 | 37.7725881276189 | -122.433606678937 | (37.7725881276189, -122.433606678937) | 15 | 5 | 11 | 29492 | 9 | |||
| 114361 | 50005 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 400 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014320.5085713 | 2105254.32227407 | 37.761432435497 | -122.393574353924 | (37.761432435497, -122.393574353924) | 10 | 3 | 8 | 28856 | 29 |
| 114654 | 114717 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 122303 | 114718 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 124117 | 121376 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 124982 | 240948 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009180.27377 | 2106318.53915 | 37.7640675739783 | -122.411427545759 | (37.7640675739783, -122.411427545759) | 8 | 4 | 7 | 28859 | 19 | ||||
| 126594 | 233910 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 20 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6009190.59946 | 2106060.78327 | 37.7633604145703 | -122.411373621517 | (37.7633604145703, -122.411373621517) | 8 | 4 | 7 | 28859 | 19 | |||
| 138913 | 93975 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden gate Ave Roselyn Ter | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 3 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
| 150034 | 4278 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 4258 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2X2 | 6002201.9710475 | 2100350.5784148 | 37.7472871096923 | -122.435136538682 | (37.7472871096923, -122.435136538682) | 2 | 4 | 5 | 63 | 22 | |||
| 151929 | 114719 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 155533 | 104332 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 1X Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 | ||||
| 155774 | 121375 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 158642 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 548 Page St | Front Yard : | Tree | Private 2 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937 | 2109751 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | 7 | 9 | 11 | 29492 | 10 | ||||
| 160103 | 11 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 97 12th St | 5 | Median : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | 8 | 2 | 9 | 28853 | 19 | |||
| 160511 | 16287 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 700X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 0 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
| 170494 | 233906 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6009180.25132 | 2106253.63038 | 37.7638893481264 | -122.411423037456 | (37.7638893481264, -122.411423037456) | 8 | 4 | 7 | 28859 | 19 | ||||
| 171262 | 233908 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009186.78686 | 2106242.26457 | 37.763858506786 | -122.411399629895 | (37.763858506786, -122.411399629895) | 8 | 4 | 7 | 28859 | 19 | ||||
| 173057 | 93974 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
| 174930 | 63802 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 77 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52071 | 6009185.15509201 | 2097023.23947975 | 37.7385450297946 | -122.410754158421 | (37.7385450297946, -122.410754158421) | 10 | 7 | 7 | 28859 | 2 | ||
| 176328 | 114714 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 601X Somerset St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.34804 | 2091657.36974 | 37.7238755730654 | -122.406420080685 | (37.7238755730654, -122.406420080685) | 10 | 3 | 7 | 309 | 28 | |||
| 176873 | 95078 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 1110 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013929.4 | 2106263.3 | 37.7641811276583 | -122.394997717565 | (37.7641811276583, -122.394997717565) | 14 | 3 | 8 | 28856 | 29 | ||||
| 187050 | 233909 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 450 Florida St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6009192.34018 | 2106238.03277 | 37.7638471987064 | -122.411380123589 | (37.7638471987064, -122.411380123589) | 8 | 4 | 7 | 28859 | 19 | ||||
| 189693 | 252829 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 8 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
| 194265 | 264982 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 106X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 4.5x5 | Permit Number 787721 | 6000803 | 2103641 | 37.7562422754387 | -122.440209988419 | (37.7562422754387, -122.440209988419) | 2 | 4 | 5 | 28862 | 38 |
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) );