trees
730 rows where qCareAssistant = "" and qSpecies_id = 97 sorted by SiteOrder
This data as json, CSV (advanced)
These facets timed out: qCareAssistant
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36324 | 102902 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012556 | 2118523 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | 3 | 1 | 10 | 28860 | 6 | ||||
| 42094 | 107775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | 15 | 5 | 11 | 29492 | 12 | |||||
| 43388 | 102901 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 712 BATTERY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012523 | 2118543 | 37.7978200413762 | -122.400724815577 | (37.7978200413762, -122.400724815577) | 3 | 1 | 10 | 28860 | 6 | ||||
| 374 | 5332 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6x7 | 6004849.91389 | 2107615.96816 | 37.7673861676625 | -122.426497389946 | (37.7673861676625, -122.426497389946) | 8 | 4 | 5 | 28862 | 19 | |||
| 443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 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 | |||
| 3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
| 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 | |||
| 5103 | 55566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.28081 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | 10 | 7 | 8 | 309 | 39 | |
| 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 | |||
| 5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 5816 | 130501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.8044333562689 | -122.444923170372 | (37.8044333562689, -122.444923170372) | 13 | 9 | 1 | 57 | 17 | |||
| 6344 | 33663 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.8782552 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 7021 | 5742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | 2 | 7 | 5 | 28859 | 7 | |||
| 7426 | 218839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | 2 | Width 3ft | Permit Number 54033 | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.475233923312 | (37.7431586880264, -122.475233923312) | 1 | 8 | 4 | 29491 | 40 | |
| 7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 9284 | 259046 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 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 | |||
| 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 | |||
| 10260 | 261386 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 31 Abbey St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6004642 | 2106187 | 37.7634508076606 | -122.427114742536 | (37.7634508076606, -122.427114742536) | 8 | 4 | 5 | 28862 | 3 | ||||
| 10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
| 11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
| 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 | |||
| 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 | |||
| 12949 | 59480 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | 13 | 6 | 1 | 54 | 31 | ||
| 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 | |||
| 15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
| 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 | |||
| 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 | |||
| 17586 | 224621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1321 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999027.25079 | 2105080.82131 | 37.7600944087555 | -122.446454694245 | (37.7600944087555, -122.446454694245) | 15 | 5 | 5 | 28862 | 12 | |||
| 18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
| 18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
| 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 | ||||
| 19765 | 224602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3344 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006035.96544 | 2103769.71631 | 37.756892241295 | -122.422121716065 | (37.756892241295, -122.422121716065) | 2 | 4 | 5 | 28859 | 19 | |||
| 19928 | 176429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 246 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009787.6259 | 2087905.19547 | 37.7135425579218 | -122.4080282487 | (37.7135425579218, -122.4080282487) | 9 | 7 | 8 | 309 | 39 | |||
| 20155 | 98985 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
| 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 | |||
| 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 | |||
| 24214 | 64582 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3646 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1988 12:00:00 AM | 18 | 7x12 | Permit Number 25481 | 6005989.81318517 | 2104358.59934784 | 37.758506573723 | -122.422323167129 | (37.758506573723, -122.422323167129) | 2 | 4 | 5 | 28859 | 19 | |
| 24672 | 218819 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.7198223438984 | -122.471738457278 | (37.7198223438984, -122.471738457278) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 26145 | 258009 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 380 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005531 | 2111189 | 37.7772353303506 | -122.424395772149 | (37.7772353303506, -122.424395772149) | 7 | 9 | 11 | 28852 | 10 | ||||
| 26889 | 54520 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | 11 | 8 | 11 | 56 | 12 | |||
| 27637 | 224594 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.22226 | 37.7647909508601 | -122.42263236011 | (37.7647909508601, -122.42263236011) | 8 | 4 | 5 | 28859 | 19 | |
| 28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 28762 | 218828 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.7467243191683 | -122.475517447198 | (37.7467243191683, -122.475517447198) | 1 | 8 | 4 | 29491 | 40 | |||
| 28862 | 224598 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005862.87598 | 2103720.88852 | 37.7567484073338 | -122.422716854995 | (37.7567484073338, -122.422716854995) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
| 30056 | 250762 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 231 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985862.1127 | 2114339.73432 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | 11 | 6 | 1 | 55 | 33 | |||
| 30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
| 30487 | 99178 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008617 | 2122137 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | 3 | 1 | 10 | 308 | 23 | ||||
| 30525 | 109918 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6010269.5 | 2121152.3 | 37.8048585915517 | -122.408706764133 | (37.8048585915517, -122.408706764133) | 3 | 1 | 10 | 308 | 23 | ||||
| 32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
| 33097 | 176407 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
| 35509 | 224601 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3328 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006122.42737 | 2103775.96782 | 37.756914282788 | -122.421823142019 | (37.756914282788, -122.421823142019) | 2 | 4 | 5 | 28859 | 19 | |||
| 36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
| 36191 | 251014 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.7895752475348 | -122.457847777179 | (37.7895752475348, -122.457847777179) | 11 | 6 | 1 | 54 | 31 | |||
| 36246 | 32868 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601705 | -122.430300092251 | (37.736503601705, -122.430300092251) | 2 | 7 | 5 | 63 | 7 | |||
| 36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | |||
| 36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
| 36758 | 61440 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.37503 | 37.7971315285518 | -122.443200241996 | (37.7971315285518, -122.443200241996) | 13 | 9 | 1 | 57 | 17 | ||
| 37053 | 176425 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011982.06755 | 2090001.33634 | 37.7194207606357 | -122.400590586484 | (37.7194207606357, -122.400590586484) | 10 | 7 | 8 | 309 | 28 | |||
| 37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
| 37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 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 | |||
| 39650 | 224603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3360 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6005941.90978 | 2103767.20067 | 37.7568800285 | -122.42244681736 | (37.7568800285, -122.42244681736) | 2 | 4 | 5 | 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 | |||
| 40283 | 30534 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
| 40903 | 224617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999693.04498 | 2101841.13049 | 37.7512370173901 | -122.443919267953 | (37.7512370173901, -122.443919267953) | 2 | 5 | 5 | 63 | 38 | |||
| 41504 | 33816 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
| 41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 42763 | 224607 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3540 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6005920.82892 | 2102594.51157 | 37.753658906948 | -122.42243640053 | (37.753658906948, -122.42243640053) | 2 | 4 | 5 | 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) );