trees
3,587 rows where qSpecies_id = 28 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
498 | 260403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 1 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
2050 | 50805 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | 15 | 5 | 11 | 29492 | 41 | |||
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3631 | 260410 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Brotherhood Way | 10 | Side Yard : Yard | Tree | Private 2 | 30x30 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
3865 | 105892 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999444.5 | 2109060.1 | 37.7710443339737 | -122.445297745357 | (37.7710443339737, -122.445297745357) | 15 | 5 | 11 | 29492 | 9 | |||||
4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
5059 | 255129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5129 | 255126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5246 | 262331 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 2140 Wawona St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5986390 | 2097232 | 37.7378137677629 | -122.489583137449 | (37.7378137677629, -122.489583137449) | 1 | 8 | 3 | 29491 | 35 | ||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
5631 | 50066 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | 15 | 4 | 5 | 28862 | 3 | ||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
6611 | 262204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001442 | 2095927 | 37.735097816857 | -122.437447738546 | (37.735097816857, -122.437447738546) | 2 | 7 | 5 | 63 | 7 | ||||
7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
7848 | 54566 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | 15 | 5 | 11 | 29492 | 9 | ||
7881 | 260404 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 2 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
8604 | 48746 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8612 | 255133 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
8893 | 50823 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
9226 | 99970 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10121 | 110450 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 56 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003933 | 2105145 | 37.7605496062864 | -122.429492630385 | (37.7605496062864, -122.429492630385) | 2 | 4 | 5 | 28862 | 3 | ||||
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10391 | 261268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | ||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10872 | 33492 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | 2 | 7 | 7 | 28859 | 2 | ||
10989 | 254569 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6004613 | 2113717 | 37.7841247118733 | -122.427751595484 | (37.7841247118733, -122.427751595484) | 13 | 9 | 11 | 28858 | 41 | |||
11020 | 261566 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 26th St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
12565 | 104957 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13040 | 261562 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1801 25th St | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
13061 | 111232 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
14179 | 257990 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1299x Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004575 | 2113275 | 37.7829089401984 | -122.427851556708 | (37.7829089401984, -122.427851556708) | 7 | 9 | 11 | 29490 | 41 | ||||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
17229 | 262360 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001078 | 2098361 | 37.7417603103416 | -122.438880584073 | (37.7417603103416, -122.438880584073) | 2 | 7 | 5 | 63 | 7 | ||||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
17899 | 110754 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 COLE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | ||||
17905 | 260412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Brotherhood Way | 1 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 2 | 7 | 7 | 28859 | 2 | ||
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
18576 | 261447 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 317 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006993 | 2095799 | 37.7350603822594 | -122.418246820854 | (37.7350603822594, -122.418246820854) | 2 | 7 | 7 | 28859 | 2 | ||||
18977 | 97306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997949.8 | 2111441.7 | 37.7774981585608 | -122.450639669067 | (37.7774981585608, -122.450639669067) | 15 | 6 | 2 | 54 | 16 | |||||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
19587 | 260401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3900 Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | ||||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
20259 | 26515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6008938.68629 | 2101687.00134 | 37.7513368683627 | -122.411935812817 | (37.7513368683627, -122.411935812817) | 2 | 4 | 7 | 28859 | 19 | ||||
20402 | 257888 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Magellan Ave | 1 | Front Yard : Yard | Tree | MTA 3 | 10x10 | 5995070 | 2100842 | 37.7482288640106 | -122.459833790503 | (37.7482288640106, -122.459833790503) | 1 | 8 | 4 | 29491 | 40 | ||||
20491 | 118331 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007461 | 2099574 | 37.7454520282724 | -122.416896144845 | (37.7454520282724, -122.416896144845) | 2 | 7 | 7 | 28859 | 2 | ||||
20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
22417 | 58653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.452769014505 | (37.7650453439116, -122.452769014505) | 15 | 5 | 11 | 29492 | 12 | ||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
24635 | 251248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001839 | 2095802 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | 2 | 7 | 5 | 63 | 7 | ||||
24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
24768 | 50314 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
24948 | 100206 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006736.3 | 2098711.7 | 37.7430435558186 | -122.4193408869 | (37.7430435558186, -122.4193408869) | 2 | 7 | 7 | 28859 | 2 | ||||
25404 | 113493 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2850 LAKE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986565 | 2114493 | 37.7852179229774 | -122.490247450243 | (37.7852179229774, -122.490247450243) | 11 | 6 | 1 | 55 | 33 | ||||
25604 | 99496 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 3 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
25986 | 119612 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281.95614032 | 2106749.56867224 | 37.7645765263283 | -122.452611237527 | (37.7645765263283, -122.452611237527) | 15 | 5 | 11 | 29492 | 12 | ||||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
26881 | 97635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
27213 | 87671 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244 | 2115292 | 37.7874513785554 | -122.487957078163 | (37.7874513785554, -122.487957078163) | 11 | 6 | 1 | 55 | 33 | ||
28235 | 122331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
28699 | 40132 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 697 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | Permit Number 41337 | 6008515.22056385 | 2095655.65791493 | 37.7347523629036 | -122.412973810281 | (37.7347523629036, -122.412973810281) | 10 | 7 | 7 | 28859 | 2 | |||
29014 | 115937 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X LAKE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993877 | 2114929 | 37.786839375345 | -122.464982060228 | (37.786839375345, -122.464982060228) | 11 | 6 | 1 | 54 | 11 | ||||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
29446 | 50634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
29507 | 115701 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2840 LAKE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986626 | 2114487 | 37.785205010982 | -122.490035970437 | (37.785205010982, -122.490035970437) | 11 | 6 | 1 | 55 | 33 | ||||
29672 | 49691 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | tx5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |
29836 | 115998 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 143 ASHBURY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998718 | 2110172 | 37.7740558300516 | -122.447890785953 | (37.7740558300516, -122.447890785953) | 15 | 5 | 11 | 29492 | 16 | |||||
29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
30430 | 102606 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
30511 | 103595 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31425 | 103598 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31664 | 115699 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2840 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986626 | 2114487 | 37.785205010982 | -122.490035970437 | (37.785205010982, -122.490035970437) | 11 | 6 | 1 | 55 | 33 | ||||
32983 | 38841 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1817 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40670 | 6005665.65244341 | 2115853.93139831 | 37.7900516844756 | -122.42426182602 | (37.7900516844756, -122.42426182602) | 13 | 9 | 1 | 28858 | 41 | ||||
32986 | 251533 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002292 | 2112799 | 37.7814725496882 | -122.435715710029 | (37.7814725496882, -122.435715710029) | 15 | 5 | 11 | 29490 | 41 | ||||
33171 | 33502 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.7432705917121 | -122.419902509091 | (37.7432705917121, -122.419902509091) | 2 | 7 | 7 | 28859 | 2 | ||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
34555 | 33952 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
34612 | 115897 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X CHURCH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x11 | 6004447 | 2103700 | 37.7566110668577 | -122.427611986325 | (37.7566110668577, -122.427611986325) | 2 | 4 | 5 | 28862 | 3 | ||||
34737 | 111082 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5991393 | 2095322 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | 1 | 8 | 4 | 64 | 40 |
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) );