trees
309 rows where Supervisor Districts = 7 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
3598 | 224504 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 995x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.7404258641556 | -122.41539707591 | (37.7404258641556, -122.41539707591) | 2 | 7 | 7 | 28859 | 2 | |||
3882 | 224548 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007664.7835 | 2104406.99539 | 37.7587337983464 | -122.416533781209 | (37.7587337983464, -122.416533781209) | 2 | 4 | 7 | 28859 | 19 | |||
3917 | 224706 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007512.60917 | 2102684.32552 | 37.753995182337 | -122.416938018377 | (37.753995182337, -122.416938018377) | 2 | 4 | 7 | 28859 | 19 | |||
3962 | 224532 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.414869623533 | (37.7523850181574, -122.414869623533) | 2 | 4 | 7 | 28859 | 19 | |||
4293 | 641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | 2 | 4 | 7 | 28859 | 19 | |||
4358 | 224705 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | 2 | 4 | 7 | 28859 | 19 | |||
4606 | 224510 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007627.97792 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | 2 | 4 | 7 | 28859 | 19 | |||
5380 | 640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.416681830316 | (37.7523944952223, -122.416681830316) | 2 | 4 | 7 | 28859 | 19 | |||
5652 | 657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.7523426205157 | -122.417681586846 | (37.7523426205157, -122.417681586846) | 2 | 4 | 7 | 28859 | 19 | |||
5744 | 26220 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | 2 | 7 | 7 | 28859 | 2 | |||
5761 | 224699 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6007526.74961 | 2102095.67359 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | 2 | 4 | 7 | 28859 | 19 | |||
5854 | 224657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007803.71411 | 2097712.06394 | 37.7403588367925 | -122.415579287554 | (37.7403588367925, -122.415579287554) | 2 | 7 | 7 | 28859 | 2 | |||
6491 | 224533 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | 2 | 4 | 7 | 28859 | 19 | |||
6718 | 226469 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
6967 | 224529 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3035 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6008772.64154 | 2102127.57906 | 37.7525372787939 | -122.412541157349 | (37.7525372787939, -122.412541157349) | 2 | 4 | 7 | 28859 | 19 | |||
7593 | 224702 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6007468.55757 | 2102099.56491 | 37.7523870848126 | -122.417048929078 | (37.7523870848126, -122.417048929078) | 2 | 4 | 7 | 28859 | 19 | |||
8296 | 94021 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432 | 2099002 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | 2 | 7 | 7 | 28859 | 2 | ||
8924 | 224586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.7652964112246 | -122.414261518161 | (37.7652964112246, -122.414261518161) | 8 | 4 | 7 | 28859 | 19 | |||
9437 | 224500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 39 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007142.18582 | 2099226.02061 | 37.7444786166914 | -122.417973892579 | (37.7444786166914, -122.417973892579) | 2 | 7 | 7 | 28859 | 2 | |||
9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
9655 | 587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3045 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.412706471622 | (37.7525282406021, -122.412706471622) | 2 | 4 | 7 | 28859 | 19 | |||
10092 | 224526 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | 2 | 4 | 7 | 28859 | 19 | |||
10134 | 224679 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007366.73942 | 2101988.35955 | 37.7520760119996 | -122.417393153575 | (37.7520760119996, -122.417393153575) | 2 | 4 | 7 | 28859 | 19 | |||
11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 2 | 4 | 7 | 28859 | 19 | ||
11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
11588 | 224634 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | 2 | 7 | 7 | 28859 | 2 | |||
11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 | |
11707 | 224712 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006570.05679 | 2104384.71114 | 37.7586109842303 | -122.420318274095 | (37.7586109842303, -122.420318274095) | 2 | 4 | 7 | 28859 | 19 | |||
13271 | 551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009445.64374 | 2102206.22318 | 37.7527909649347 | -122.41021934346 | (37.7527909649347, -122.41021934346) | 2 | 4 | 7 | 28859 | 19 | |||
13405 | 245415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010145.3814 | 2102202.4336 | 37.752819757444 | -122.407799244655 | (37.752819757444, -122.407799244655) | 2 | 4 | 7 | 28859 | 19 | |
13648 | 224656 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 998X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007860.71313 | 2097707.80133 | 37.7403503364023 | -122.415381905247 | (37.7403503364023, -122.415381905247) | 2 | 7 | 7 | 28859 | 2 | |||
13764 | 224696 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.7524624264182 | -122.415583660969 | (37.7524624264182, -122.415583660969) | 2 | 4 | 7 | 28859 | 19 | |||
15856 | 224535 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.415820179079 | (37.7523342649139, -122.415820179079) | 2 | 4 | 7 | 28859 | 19 | |||
15993 | 226468 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
16341 | 224695 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3034 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6008772.76102 | 2102170.48787 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | 2 | 4 | 7 | 28859 | 19 | |||
16426 | 224652 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6007400.92537 | 2098998.39155 | 37.7438681568958 | -122.417063096086 | (37.7438681568958, -122.417063096086) | 2 | 7 | 7 | 28859 | 2 | |||
16785 | 224704 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007185.41243 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | 2 | 4 | 7 | 28859 | 19 | |||
17320 | 226492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | 2 | 4 | 7 | 28859 | 19 | |||
18694 | 255585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 141 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2105290 | 37.7611036239675 | -122.419957321446 | (37.7611036239675, -122.419957321446) | 2 | 4 | 7 | 28859 | 19 | ||||
19051 | 224694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008827.83828 | 2102168.91217 | 37.7526538678042 | -122.412353198162 | (37.7526538678042, -122.412353198162) | 2 | 4 | 7 | 28859 | 19 | |||
22276 | 224570 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007990.36824 | 2105589.83292 | 37.7619999031047 | -122.415491498431 | (37.7619999031047, -122.415491498431) | 2 | 4 | 7 | 28859 | 19 | |||
22962 | 224637 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006160.37028 | 2098038.58649 | 37.741162883772 | -122.421284510199 | (37.741162883772, -122.421284510199) | 2 | 7 | 7 | 28859 | 2 | |||
23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
23294 | 224483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007282.93524 | 2107366.34912 | 37.7668380128917 | -122.418064187227 | (37.7668380128917, -122.418064187227) | 8 | 4 | 7 | 28853 | 19 | |||
23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 | |||
24474 | 62335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 88 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22477 | 6005278.45102522 | 2096412.38253023 | 37.7366479337699 | -122.424218245392 | (37.7366479337699, -122.424218245392) | 2 | 7 | 7 | 28859 | 2 | ||
24922 | 224531 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008520.36157 | 2102113.23947 | 37.752483743936 | -122.413412573453 | (37.752483743936, -122.413412573453) | 2 | 4 | 7 | 28859 | 19 | |||
25118 | 224700 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | 2 | 4 | 7 | 28859 | 19 | |||
25421 | 226491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008819.81577 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | 2 | 4 | 7 | 28859 | 19 | |||
25611 | 224697 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.7524315481913 | -122.415947634593 | (37.7524315481913, -122.415947634593) | 2 | 4 | 7 | 28859 | 19 | |||
26012 | 642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | 2 | 4 | 7 | 28859 | 19 | |||
26097 | 53744 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
26673 | 48040 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
27007 | 224588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008276.68417 | 2106776.83741 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | 8 | 4 | 7 | 28859 | 19 | |||
28050 | 224521 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007845.31387 | 2105404.79187 | 37.7614836688504 | -122.415980082123 | (37.7614836688504, -122.415980082123) | 2 | 4 | 7 | 28859 | 19 | |||
28430 | 224645 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006421.94544 | 2098375.74609 | 37.742103392067 | -122.420404001067 | (37.742103392067, -122.420404001067) | 2 | 7 | 7 | 28859 | 2 | |||
28999 | 224659 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009169.14858 | 2102873.09479 | 37.7546065423583 | -122.41122262175 | (37.7546065423583, -122.41122262175) | 2 | 4 | 7 | 28859 | 19 | |||
29906 | 224646 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006447.48473 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | 2 | 7 | 7 | 28859 | 2 | |||
31709 | 224519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007848.49243 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | 2 | 4 | 7 | 28859 | 19 | |||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
33181 | 224693 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | 2 | 4 | 7 | 28859 | 19 | |||
33250 | 224563 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3121 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008575.93906 | 2105040.68247 | 37.7605249582808 | -122.413427391562 | (37.7605249582808, -122.413427391562) | 2 | 4 | 7 | 28859 | 19 | |||
36047 | 69485 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33606 | 6008946.01217425 | 2105621.19939594 | 37.7621396967865 | -122.412188502645 | (37.7621396967865, -122.412188502645) | 8 | 4 | 7 | 28859 | 19 | ||
36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
36309 | 577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.7526513982496 | -122.412443801263 | (37.7526513982496, -122.412443801263) | 2 | 4 | 7 | 28859 | 19 | |||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
38685 | 224661 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.412091302998 | (37.7611019507102, -122.412091302998) | 2 | 4 | 7 | 28859 | 19 | |||
39589 | 224649 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | 2 | 7 | 7 | 28859 | 2 | |||
39671 | 97123 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3305 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 24053 | 6008171 | 2104436 | 37.7588418942892 | -122.414785099498 | (37.7588418942892, -122.414785099498) | 2 | 4 | 7 | 28859 | 19 | ||
39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
42243 | 226471 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008696.07449 | 2105092.67763 | 37.760674469666 | -122.413015573106 | (37.760674469666, -122.413015573106) | 2 | 4 | 7 | 28859 | 19 | |||
42368 | 255609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 355X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006938 | 2104061 | 37.7577428748963 | -122.419022796788 | (37.7577428748963, -122.419022796788) | 2 | 4 | 7 | 28859 | 19 | ||||
42609 | 67152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | 10 | 7 | 7 | 28859 | 2 | ||
42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
45268 | 59350 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23892 | 6007961.12301785 | 2099994.21526918 | 37.7466339645312 | -122.415196534166 | (37.7466339645312, -122.415196534166) | 2 | 7 | 7 | 28859 | 2 | ||
45475 | 224673 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 610 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007868.35883 | 2104304.97763 | 37.7584651276847 | -122.415822498411 | (37.7584651276847, -122.415822498411) | 2 | 4 | 7 | 28859 | 19 | |||
46673 | 63412 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.416318652779 | (37.7342557904854, -122.416318652779) | 2 | 7 | 7 | 28859 | 2 | ||
46703 | 633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | 2 | 4 | 7 | 28859 | 19 | |||
47723 | 224642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | 2 | 7 | 7 | 28859 | 2 | |||
47963 | 226470 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008736.33721 | 2105092.98384 | 37.76067757053 | -122.412876343665 | (37.76067757053, -122.412876343665) | 2 | 4 | 7 | 28859 | 19 | |||
50729 | 67095 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.408212089588 | (37.7428561528472, -122.408212089588) | 10 | 7 | 7 | 28859 | 2 | ||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 2 | 4 | 7 | 28859 | 19 | |||
50896 | 226475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008399.69622 | 2105072.76604 | 37.7606031552393 | -122.414039206643 | (37.7606031552393, -122.414039206643) | 2 | 4 | 7 | 28859 | 19 | |||
51797 | 224520 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007846.93969 | 2105383.76914 | 37.7614260366957 | -122.41597297028 | (37.7614260366957, -122.41597297028) | 2 | 4 | 7 | 28859 | 19 | |||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
54673 | 224671 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533 | -122.410721013192 | (37.758881337533, -122.410721013192) | 2 | 4 | 7 | 28859 | 19 | |||
54721 | 224580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | Permit Number 781047 | 6008616.55983 | 2106802.76672 | 37.7653655169234 | -122.413411521233 | (37.7653655169234, -122.413411521233) | 8 | 4 | 7 | 28859 | 19 | ||
55089 | 600 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.413621638824 | (37.7525711157729, -122.413621638824) | 2 | 4 | 7 | 28859 | 19 | |||
55334 | 224658 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.7469678609981 | -122.41772795229 | (37.7469678609981, -122.41772795229) | 2 | 7 | 7 | 28859 | 2 | |||
56103 | 224554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3363 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007798.32865 | 2104414.86293 | 37.7587629102964 | -122.416072476661 | (37.7587629102964, -122.416072476661) | 2 | 4 | 7 | 28859 | 19 | |||
56378 | 34142 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.413688890617 | (37.7637880127631, -122.413688890617) | 8 | 4 | 7 | 28859 | 19 | ||
57015 | 224709 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006609.60192 | 2103216.71936 | 37.7554061772577 | -122.420098619173 | (37.7554061772577, -122.420098619173) | 2 | 4 | 7 | 28859 | 19 | |||
57933 | 224547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | 2 | 4 | 7 | 28859 | 19 | |||
58923 | 226481 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007993.23947 | 2105048.90017 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | 2 | 4 | 7 | 28859 | 19 |
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) );