trees
42 rows where qSpecies_id = 250
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3056 | 102196 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 195 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769771 | 6001469.4 | 2104733.4 | 37.7592796588141 | -122.437983597898 | (37.7592796588141, -122.437983597898) | 2 | 4 | 5 | 28862 | 3 |
| 22915 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 3794 16th St | 1 | Front Yard : Yard | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901 | 2106436 | 37.7639791186972 | -122.436612788339 | (37.7639791186972, -122.436612788339) | 15 | 5 | 5 | 28862 | 3 | |||
| 37516 | 19213 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 710X Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/1997 12:00:00 AM | 3 | 3X3 | 6002366.0960506 | 2108316.0051988 | 37.7691675719148 | -122.435138635645 | (37.7691675719148, -122.435138635645) | 15 | 5 | 5 | 29492 | 9 | ||
| 38328 | 117337 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 715 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778487 | 5999567.1 | 2110966.9 | 37.7762869193631 | -122.445010769125 | (37.7762869193631, -122.445010769125) | 15 | 5 | 11 | 29492 | 16 | ||
| 39435 | 26643 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 39686 | 14493 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 331 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2015 12:00:00 AM | 3 | 3X3 | 5998922.83591 | 2111648.48667 | 37.7781215891061 | -122.447288514652 | (37.7781215891061, -122.447288514652) | 15 | 6 | 2 | 54 | 16 | ||
| 40429 | 100253 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1456 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | 4x4 | Permit Number 769196 | 5993711.5 | 2105567.7 | 37.7611262002583 | -122.464874548889 | (37.7611262002583, -122.464874548889) | 1 | 8 | 11 | 56 | 12 | ||
| 46453 | 26644 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 50097 | 6475 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017506.49201 | 2097214.01001 | 37.7395319063462 | -122.381995946234 | (37.7395319063462, -122.381995946234) | 10 | 3 | 8 | 58 | 1 | ||
| 51285 | 26645 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 56280 | 6637 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1499 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | 10 | 3 | 8 | 58 | 1 | ||
| 57240 | 24925 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/09/1996 12:00:00 AM | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 60403 | 6464 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2004 12:00:00 AM | 3 | 3X3 | 6017745.05001 | 2097036.28401 | 37.739057077864 | -122.381158753908 | (37.739057077864, -122.381158753908) | 10 | 3 | 8 | 58 | 1 | ||
| 66631 | 102198 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 195 Eureka St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769771 | 6001469.4 | 2104733.4 | 37.7592796588141 | -122.437983597898 | (37.7592796588141, -122.437983597898) | 2 | 4 | 5 | 28862 | 3 |
| 70350 | 59742 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 678 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769762 | 6002373.84394228 | 2104261.94389375 | 37.7580365463466 | -122.434821881783 | (37.7580365463466, -122.434821881783) | 2 | 4 | 5 | 28862 | 3 |
| 77022 | 26751 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 81355 | 26750 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 83095 | 6442 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1997 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 84411 | 74997 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 465 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013543.86536349 | 2104925.00004946 | 37.7604850039816 | -122.396237377585 | (37.7604850039816, -122.396237377585) | 10 | 3 | 8 | 28856 | 29 | ||
| 85956 | 111018 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 90x DOWNEY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 90477 | 109091 | Property Tree 8 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876 | (37.7525900037408, -122.43731782876) | 2 | 4 | 5 | 28862 | 22 |
| 108335 | 6474 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017537.50401 | 2097191.34701 | 37.7394713908932 | -122.381887143186 | (37.7394713908932, -122.381887143186) | 10 | 3 | 8 | 58 | 1 | ||
| 112999 | 6446 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1997 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 113007 | 6438 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1100X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1998 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 119301 | 102197 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 195 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769771 | 6001469.4 | 2104733.4 | 37.7592796588141 | -122.437983597898 | (37.7592796588141, -122.437983597898) | 2 | 4 | 5 | 28862 | 3 |
| 120231 | 1393 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 30 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017322.6446401 | 2095453.2669697 | 37.7346871027897 | -122.382509138453 | (37.7346871027897, -122.382509138453) | 10 | 3 | 8 | 58 | 1 | ||
| 124649 | 24923 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/22/1996 12:00:00 AM | 6 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 131097 | 28709 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017521.99801 | 2097204.46801 | 37.7395065622406 | -122.381941669129 | (37.7395065622406, -122.381941669129) | 10 | 3 | 8 | 58 | 1 | |||
| 140435 | 5167 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 300 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | 6 | 3X3 | 6001869.08625 | 2109505.82986 | 37.7724063003864 | -122.436942953857 | (37.7724063003864, -122.436942953857) | 15 | 5 | 11 | 29492 | 9 | ||
| 142409 | 16582 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 810X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 6 | 3X3 | 5992991.92524 | 2114858.80829 | 37.7865955752076 | -122.468039078982 | (37.7865955752076, -122.468039078982) | 11 | 6 | 1 | 54 | 11 | ||
| 144595 | 6472 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2004 12:00:00 AM | 3 | 3X3 | 6017584.02301 | 2097148.40701 | 37.7393560550275 | -122.381723313495 | (37.7393560550275, -122.381723313495) | 10 | 3 | 8 | 58 | 1 | ||
| 154928 | 1406 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 70 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017447.2721522 | 2095316.9187052 | 37.7343196011902 | -122.382068772736 | (37.7343196011902, -122.382068772736) | 10 | 3 | 8 | 58 | 1 | ||
| 170621 | 12699 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1400 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2002 12:00:00 AM | 12 | 3X3 | 5991084.01432 | 2114808.42096 | 37.7863468599999 | -122.47463623978 | (37.7863468599999, -122.47463623978) | 11 | 6 | 1 | 54 | 33 | ||
| 171405 | 66405 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 443 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52584 | 6008076.49630227 | 2096789.35262597 | 37.7378406037529 | -122.414570833668 | (37.7378406037529, -122.414570833668) | 2 | 7 | 7 | 28859 | 2 | |
| 172601 | 26647 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 175131 | 24926 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
| 177664 | 24922 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 182870 | 108661 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 263 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773001 | 5990542.4091 | 2113638.39962 | 37.783102910833 | -122.476424534684 | (37.783102910833, -122.476424534684) | 11 | 6 | 2 | 55 | 26 | |
| 186498 | 6461 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1200X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1997 12:00:00 AM | 6 | 3X3 | 6017793.95401 | 2096998.11501 | 37.7389549728339 | -122.38098701155 | (37.7389549728339, -122.38098701155) | 10 | 3 | 8 | 58 | 1 | ||
| 187728 | 23694 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 444 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2004 12:00:00 AM | 6 | 3X3 | 6012360.1719452 | 2117827.4460445 | 37.795846218583 | -122.401237940514 | (37.795846218583, -122.401237940514) | 3 | 1 | 10 | 28860 | 4 | ||
| 190832 | 102199 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 195 Eureka St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769771 | 6001469.4 | 2104733.4 | 37.7592796588141 | -122.437983597898 | (37.7592796588141, -122.437983597898) | 2 | 4 | 5 | 28862 | 3 |
| 194011 | 19212 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 710X Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1998 12:00:00 AM | 3 | 3X3 | 6002366.0960506 | 2108316.0051988 | 37.7691675719148 | -122.435138635645 | (37.7691675719148, -122.435138635645) | 15 | 5 | 5 | 29492 | 9 |
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) );