trees
3,247 rows where qSpecies_id = 22 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64775 | 100211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 1 | Permit Number 769013 | 6011855.60136 | 2105068.89592 | 37.7607860251716 | -122.402086457638 | (37.7607860251716, -122.402086457638) | 10 | 3 | 8 | 28856 | 29 | ||
34760 | 100212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 769013 | 6011854.68115 | 2105077.88991 | 37.7608106693075 | -122.402090272569 | (37.7608106693075, -122.402090272569) | 10 | 3 | 8 | 28856 | 29 | |||
19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
137507 | 10090 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 2X2 | Permit Number 777732 | 6005659.80497 | 2104809.7574 | 37.7597267272239 | -122.423496559112 | (37.7597267272239, -122.423496559112) | 2 | 4 | 5 | 28859 | 19 | |
136011 | 100962 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013015.61085 | 2114021.62606 | 37.7854328757839 | -122.39870276924 | (37.7854328757839, -122.39870276924) | 6 | 2 | 9 | 28855 | 6 |
107544 | 101216 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 444 De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2012 12:00:00 AM | 3x3 | Permit Number 769365 | 6011994.2 | 2106304.5 | 37.7641864535036 | -122.401693953948 | (37.7641864535036, -122.401693953948) | 8 | 3 | 8 | 28856 | 29 | ||
37074 | 101250 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 737 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993514 | 2106614 | 37.7639876770853 | -122.465633627671 | (37.7639876770853, -122.465633627671) | 1 | 8 | 11 | 56 | 12 | ||||
110865 | 101472 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1X Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768853 | 6000100 | 2095441 | 37.7336869872758 | -122.442052627426 | (37.7336869872758, -122.442052627426) | 9 | 7 | 4 | 63 | 40 | |||
85573 | 101684 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 4054 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003246 | 2104197 | 37.7579077041777 | -122.431800959125 | (37.7579077041777, -122.431800959125) | 2 | 4 | 5 | 28862 | 3 | ||||
135402 | 101703 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2700 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | 8 | 4 | 8 | 28859 | 19 | ||||
118061 | 101704 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2700 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | 8 | 4 | 8 | 28859 | 19 | ||||
42367 | 101840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769499 | 6011223.03061 | 2105283.28605 | 37.7613393654344 | -122.404289339783 | (37.7613393654344, -122.404289339783) | 10 | 3 | 8 | 28856 | 29 | |
89821 | 102141 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
111982 | 102142 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 5 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
165276 | 102374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | 11 | 6 | 2 | 55 | 26 | ||||
156162 | 102375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983887.37527 | 2110050.49294 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | 11 | 6 | 2 | 55 | 26 | ||||
101404 | 102516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
38502 | 102649 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1845X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013718.9 | 2096447.3 | 37.7372167805961 | -122.395038202336 | (37.7372167805961, -122.395038202336) | 10 | 3 | 8 | 58 | 1 | |||
137426 | 102650 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1845X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013718.9 | 2096447.3 | 37.7372167805961 | -122.395038202336 | (37.7372167805961, -122.395038202336) | 10 | 3 | 8 | 58 | 1 | |||
102111 | 104096 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
145537 | 104098 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
38441 | 104099 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
143735 | 104100 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
178249 | 104101 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
82132 | 104102 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
39546 | 104103 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
156491 | 104104 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
147225 | 104105 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
37981 | 104106 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
9492 | 104107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
135523 | 104108 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
82502 | 104178 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 801 JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x9 | 6008973 | 2096925 | 37.7382633878874 | -122.411480752917 | (37.7382633878874, -122.411480752917) | 10 | 7 | 7 | 28859 | 2 | |||
125449 | 104377 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 868 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252.8 | 2101329.2 | 37.7499202272654 | -122.438488800094 | (37.7499202272654, -122.438488800094) | 2 | 4 | 5 | 28862 | 22 | ||||
66917 | 104418 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1125 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | Permit Number 770463 | 5992112 | 2110623.1 | 37.7749146251824 | -122.47077473048 | (37.7749146251824, -122.47077473048) | 11 | 6 | 2 | 54 | 11 | |||
124884 | 104764 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1855 08TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x4 | Permit Number 770861 | 5993717.5 | 2102872.4 | 37.7537259496496 | -122.464658073456 | (37.7537259496496, -122.464658073456) | 1 | 8 | 4 | 56 | 12 | |||
120996 | 105049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2835 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771766 | 6002046.08058 | 2117916.60345 | 37.7955102037842 | -122.436932952092 | (37.7955102037842, -122.436932952092) | 13 | 9 | 1 | 57 | 27 | |
157440 | 105159 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 740 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6003006.6 | 2103935 | 37.7571747411483 | -122.432610189818 | (37.7571747411483, -122.432610189818) | 2 | 4 | 5 | 28862 | 3 | |||
75603 | 105179 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1845X Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013865.39371 | 2096317.18633 | 37.7368676605158 | -122.394522594469 | (37.7368676605158, -122.394522594469) | 10 | 3 | 8 | 58 | 1 | |||
86837 | 105352 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2055 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2014 12:00:00 AM | 1 | 3x3 | Permit Number 768583 | 6003162.6 | 2118532.6 | 37.7972649672191 | -122.433113640832 | (37.7972649672191, -122.433113640832) | 13 | 9 | 1 | 57 | 17 | |
8230 | 105663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x2 | 5990541.50647 | 2113621.53342 | 37.783056548593 | -122.476426424914 | (37.783056548593, -122.476426424914) | 11 | 6 | 2 | 55 | 26 | |||
92121 | 10597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 385X 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6010728.50062 | 2110559.72736 | 37.7757996213793 | -122.406371513674 | (37.7757996213793, -122.406371513674) | 14 | 2 | 9 | 28853 | 34 | |||
156970 | 10598 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 385X 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6010728.50062 | 2110559.72736 | 37.7757996213793 | -122.406371513674 | (37.7757996213793, -122.406371513674) | 14 | 2 | 9 | 28853 | 34 | |||
158645 | 10601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2749 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | 3x3 | 6008971.05874 | 2102435.54315 | 37.7533940125469 | -122.411876754419 | (37.7533940125469, -122.411876754419) | 2 | 4 | 7 | 28859 | 19 | ||
145957 | 106020 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 181 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | ||||
100105 | 106021 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 181 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | ||||
8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
168435 | 106426 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2919 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770060 | 6003851.7386 | 2118879.76121 | 37.798257249522 | -122.430753834436 | (37.798257249522, -122.430753834436) | 13 | 9 | 1 | 57 | 17 | |
112092 | 106446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 771655 | 6002688 | 2109928 | 37.7736119859455 | -122.434140441388 | (37.7736119859455, -122.434140441388) | 15 | 5 | 11 | 29492 | 10 | |||
102868 | 106447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 771655 | 6002688 | 2109928 | 37.7736119859455 | -122.434140441388 | (37.7736119859455, -122.434140441388) | 15 | 5 | 11 | 29492 | 10 | |||
140420 | 106472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 101 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2014 12:00:00 AM | 3 | Permit Number 772868 | 6010429.7 | 2087279.3 | 37.7118599042892 | -122.405764940253 | (37.7118599042892, -122.405764940253) | 9 | 7 | 8 | 309 | 39 | ||
190638 | 106655 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 899X BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6000958 | 2111726 | 37.7784505017056 | -122.440253723857 | (37.7784505017056, -122.440253723857) | 15 | 5 | 11 | 29490 | 41 | |||
159312 | 106691 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 12 CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6004659.5 | 2103503.6 | 37.7560838161182 | -122.426863097691 | (37.7560838161182, -122.426863097691) | 2 | 4 | 5 | 28862 | 22 | |||
118562 | 10679 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1125 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002427.1981 | 2110540.5146 | 37.7752789934284 | -122.435086410323 | (37.7752789934284, -122.435086410323) | 15 | 5 | 11 | 29492 | 10 | |||
95455 | 10680 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1133 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002410.4328 | 2110539.1175 | 37.7752742053449 | -122.435144305311 | (37.7752742053449, -122.435144305311) | 15 | 5 | 11 | 29492 | 10 | |||
20077 | 10681 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1145 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002358.7398 | 2110530.7348 | 37.7752482530433 | -122.435322523233 | (37.7752482530433, -122.435322523233) | 15 | 5 | 11 | 29492 | 10 | |||
45370 | 10684 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1161 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6002309.8411 | 2110524.4478 | 37.7752282134437 | -122.435491224879 | (37.7752282134437, -122.435491224879) | 15 | 5 | 11 | 29492 | 10 | ||
80834 | 106842 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 230 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770882 | 5995254.51721 | 2113999.80828 | 37.7843673964023 | -122.460148860326 | (37.7843673964023, -122.460148860326) | 11 | 6 | 2 | 54 | 11 | |
156358 | 106963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 14 | 5999920.02374 | 2118149.14648 | 37.7960276377095 | -122.444306168018 | (37.7960276377095, -122.444306168018) | 13 | 9 | 1 | 57 | 17 | |||
118342 | 107002 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 320 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004300.3 | 2099890.4 | 37.7461424954619 | -122.427847885707 | (37.7461424954619, -122.427847885707) | 2 | 7 | 5 | 63 | 22 | |||
65318 | 107065 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1912 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5999488.74187 | 2115560.69721 | 37.7888958241408 | -122.445612251613 | (37.7888958241408, -122.445612251613) | 13 | 6 | 1 | 29490 | 27 | |||
154039 | 107119 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 41 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 773430 | 6007557.36556 | 2099188.16218 | 37.7443980238935 | -122.416535600799 | (37.7443980238935, -122.416535600799) | 2 | 7 | 7 | 28859 | 2 | |||
20089 | 10729 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.5110714 | 2095183.8764266 | 37.7339566260964 | -122.381913486724 | (37.7339566260964, -122.381913486724) | 10 | 3 | 8 | 58 | 1 | ||
154713 | 107475 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.7711617078198 | -122.445609151717 | (37.7711617078198, -122.445609151717) | 15 | 5 | 11 | 29492 | 9 | |||
153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
116754 | 107580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.7096038592127 | -122.468025367885 | (37.7096038592127, -122.468025367885) | 9 | 8 | 4 | 64 | 24 | ||
182443 | 107581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.94682 | 2086830.99569 | 37.7096038591978 | -122.468068397753 | (37.7096038591978, -122.468068397753) | 9 | 8 | 4 | 64 | 24 | ||
175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
96458 | 107778 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.09266 | 2119225.96368 | 37.7990395913723 | -122.441026839613 | (37.7990395913723, -122.441026839613) | 13 | 9 | 1 | 57 | 17 | |
192776 | 107779 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.7989981119436 | -122.441023758536 | (37.7989981119436, -122.441023758536) | 13 | 9 | 1 | 57 | 17 | |
45775 | 107780 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000893.56163 | 2119195.20013 | 37.7989553203824 | -122.441012627647 | (37.7989553203824, -122.441012627647) | 13 | 9 | 1 | 57 | 17 | |
56853 | 107781 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000894.3565 | 2119181.32338 | 37.7989172637699 | -122.441008881075 | (37.7989172637699, -122.441008881075) | 13 | 9 | 1 | 57 | 17 | |
163523 | 107883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
99627 | 107884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
122492 | 107885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
171481 | 107886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
174574 | 108031 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 330 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6004182.5 | 2099883.8 | 37.7461177086536 | -122.428254752902 | (37.7461177086536, -122.428254752902) | 2 | 7 | 5 | 63 | 22 | ||||
140790 | 108047 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | 3x3 | 6017036.14467 | 2097442.01922 | 37.7401319873023 | -122.383638088928 | (37.7401319873023, -122.383638088928) | 10 | 3 | 8 | 58 | 1 | ||
124381 | 108146 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003298.685 | 2119704.23273 | 37.800489685219 | -122.432726491033 | (37.800489685219, -122.432726491033) | 13 | 9 | 1 | 57 | 17 | ||||
168588 | 108147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.432733936524 | (37.800534134189, -122.432733936524) | 13 | 9 | 1 | 57 | 17 | ||
113138 | 108148 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003294.68219 | 2119741.92969 | 37.8005929642463 | -122.432743036759 | (37.8005929642463, -122.432743036759) | 13 | 9 | 1 | 57 | 17 | ||||
110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 | |
54607 | 108196 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 930 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
89927 | 108383 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 300X Franconia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 773427 | 6010115.02759 | 2099226.1979 | 37.7446459697666 | -122.4076943783 | (37.7446459697666, -122.4076943783) | 2 | 7 | 7 | 28859 | 2 | |||
192106 | 108516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695-699X 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993787.87218 | 2111075.28381 | 37.7762529739024 | -122.465010427519 | (37.7762529739024, -122.465010427519) | 11 | 6 | 2 | 54 | 11 |
125027 | 108519 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1241 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773665 | 5994833.54334 | 2107094.83383 | 37.7653839436153 | -122.461104605949 | (37.7653839436153, -122.461104605949) | 15 | 5 | 11 | 56 | 12 |
158956 | 108542 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773703 | 6001152.31796 | 2093187.75047 | 37.7275599956139 | -122.438253097429 | (37.7275599956139, -122.438253097429) | 9 | 7 | 6 | 28861 | 25 |
50660 | 108590 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900x Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6015291.6077 | 2096931.09034 | 37.7386324999809 | -122.38963436456 | (37.7386324999809, -122.38963436456) | 10 | 3 | 8 | 58 | 1 | |||
157808 | 108607 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1511 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774497 | 5999638.2 | 2107266.4 | 37.7661303401087 | -122.44449879944 | (37.7661303401087, -122.44449879944) | 15 | 5 | 5 | 29492 | 9 | |
80242 | 108622 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 772819 | 6002313.92049 | 2109316.75363 | 37.7719124170473 | -122.435390704283 | (37.7719124170473, -122.435390704283) | 15 | 5 | 11 | 29492 | 9 | |
42871 | 108698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) | 13 | 9 | 1 | 57 | 17 |
175927 | 108710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011387.70807 | 2106529.33414 | 37.7647699346052 | -122.40380746864 | (37.7647699346052, -122.40380746864) | 8 | 3 | 8 | 28853 | 20 |
8103 | 108711 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011373.53842 | 2106528.51703 | 37.7647668994048 | -122.40385642054 | (37.7647668994048, -122.40385642054) | 8 | 3 | 8 | 28853 | 20 |
189610 | 108712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011359.92903 | 2106527.96496 | 37.7647646232249 | -122.403903453285 | (37.7647646232249, -122.403903453285) | 8 | 3 | 8 | 28853 | 20 |
147336 | 108719 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 479 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773098 | 6014398.61086 | 2104906.56094 | 37.760481897829 | -122.393279892377 | (37.760481897829, -122.393279892377) | 10 | 3 | 8 | 28856 | 29 |
44679 | 108720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.25551 | 2106680.42507 | 37.7652059367253 | -122.40250878917 | (37.7652059367253, -122.40250878917) | 8 | 3 | 8 | 28853 | 20 |
90667 | 108721 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.2386 | 2106696.76782 | 37.7652508093012 | -122.402509996945 | (37.7652508093012, -122.402509996945) | 8 | 3 | 8 | 28853 | 20 |
29064 | 108722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011765.77732 | 2106711.15345 | 37.765290283257 | -122.402512604068 | (37.765290283257, -122.402512604068) | 8 | 3 | 8 | 28853 | 20 |
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) );