trees
969 rows where qSpecies_id = 97 sorted by PlantDate descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162342 | 60432 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 447 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | 2 | 7 | 5 | 63 | 22 | ||
| 104186 | 83711 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | 15 | 4 | 5 | 28862 | 3 | ||
| 1390 | 33763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 3 | 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 | |||
| 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 | |||
| 78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | 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 | |||
| 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 | |
| 72854 | 61763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 390 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1984 12:00:00 AM | Permit Number 21777 | 6005479.130443 | 2106713.50276565 | 37.7649437627207 | -122.424256822517 | (37.7649437627207, -122.424256822517) | 8 | 4 | 5 | 28853 | 19 | ||
| 73528 | 59961 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 444 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19440 | 6005671.77527769 | 2111387.84010103 | 37.7777892453109 | -122.4239229277 | (37.7777892453109, -122.4239229277) | 7 | 9 | 11 | 28852 | 10 | ||
| 83608 | 59954 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 559 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19431 | 6005185.88290556 | 2110921.14903305 | 37.7764803824816 | -122.42557057591 | (37.7764803824816, -122.42557057591) | 7 | 9 | 11 | 28852 | 10 | ||
| 135538 | 34978 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.7603911107583 | -122.433757281047 | (37.7603911107583, -122.433757281047) | 2 | 4 | 5 | 28862 | 3 | |||
| 94509 | 63203 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.7807046794697 | -122.496631747831 | (37.7807046794697, -122.496631747831) | 11 | 6 | 2 | 55 | 26 | ||
| 7424 | 61750 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) | 8 | 4 | 5 | 28859 | 19 | ||
| 131070 | 61754 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3208 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21766 | 6005459.89972761 | 2106676.78980679 | 37.7648418717739 | -122.424320725398 | (37.7648418717739, -122.424320725398) | 8 | 4 | 5 | 28853 | 19 | ||
| 171142 | 61751 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1839 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21762 | 6005280.05550322 | 2107208.06692616 | 37.7662904752312 | -122.424980563467 | (37.7662904752312, -122.424980563467) | 8 | 4 | 5 | 28853 | 19 | ||
| 60273 | 60549 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | 11 | 6 | 2 | 55 | 26 | ||
| 64863 | 60554 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.495269425078 | (37.7783990952425, -122.495269425078) | 11 | 6 | 2 | 55 | 26 | ||
| 176171 | 60542 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | 11 | 6 | 2 | 55 | 26 | ||
| 97223 | 67815 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.429766523917 | (37.7536681560563, -122.429766523917) | 2 | 4 | 5 | 28862 | 22 | ||
| 54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
| 84852 | 65486 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | 5 | 1 | 10 | 28857 | 21 | ||
| 17311 | 61740 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.429865402911 | (37.7490603587459, -122.429865402911) | 2 | 4 | 5 | 28862 | 22 | ||
| 90119 | 61733 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.427284356874 | (37.7492349189645, -122.427284356874) | 2 | 4 | 5 | 28862 | 22 | ||
| 110682 | 61727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 106 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21732 | 6004453.38447501 | 2101057.16682643 | 37.7493548261549 | -122.427401642555 | (37.7493548261549, -122.427401642555) | 2 | 4 | 5 | 28862 | 22 | ||
| 122779 | 61739 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 232 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21744 | 6003650.07025761 | 2101012.01224764 | 37.7491853759856 | -122.430176299432 | (37.7491853759856, -122.430176299432) | 2 | 4 | 5 | 28862 | 22 | ||
| 127691 | 61741 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 175 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21746 | 6004036.62237664 | 2100981.15253515 | 37.7491225287463 | -122.428837396831 | (37.7491225287463, -122.428837396831) | 2 | 4 | 5 | 28862 | 22 | ||
| 144984 | 61731 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1250 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21736 | 6003842.20340405 | 2100987.35465575 | 37.7491285523468 | -122.42951014206 | (37.7491285523468, -122.42951014206) | 2 | 4 | 5 | 28862 | 22 | ||
| 146150 | 61734 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 264 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21739 | 6003453.08659842 | 2101001.58454059 | 37.7491455850179 | -122.430856727417 | (37.7491455850179, -122.430856727417) | 2 | 4 | 5 | 28862 | 22 | ||
| 171625 | 61732 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | 2 | 4 | 5 | 28862 | 22 | ||
| 182814 | 61735 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 246 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21740 | 6003563.88991247 | 2101007.45012611 | 37.7491679679218 | -122.430473986745 | (37.7491679679218, -122.430473986745) | 2 | 4 | 5 | 28862 | 22 | ||
| 193369 | 61728 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 121 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21733 | 6004369.94753879 | 2101000.29060373 | 37.7491939379116 | -122.427686117612 | (37.7491939379116, -122.427686117612) | 2 | 4 | 5 | 28862 | 22 | ||
| 83298 | 65478 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28359 | 6010541.36110634 | 2116214.27782437 | 37.7913152098094 | -122.407417612453 | (37.7913152098094, -122.407417612453) | 5 | 1 | 10 | 28857 | 21 | ||
| 153527 | 65474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.7233540853263 | -122.459298943633 | (37.7233540853263, -122.459298943633) | 9 | 8 | 4 | 28861 | 24 | ||
| 91862 | 58807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 40 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23661 | 6007506.51736783 | 2099215.13200372 | 37.744469217231 | -122.416713333977 | (37.744469217231, -122.416713333977) | 2 | 7 | 7 | 28859 | 2 | ||
| 128200 | 66311 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.437799727546 | (37.7336304648573, -122.437799727546) | 9 | 7 | 5 | 63 | 40 | ||
| 78380 | 62435 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.7607174991734 | -122.444198303008 | (37.7607174991734, -122.444198303008) | 15 | 5 | 5 | 28862 | 3 | ||
| 128171 | 62436 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.2266718 | 2105562.60505464 | 37.7614698277306 | -122.443304093705 | (37.7614698277306, -122.443304093705) | 15 | 5 | 5 | 28862 | 3 |
| 161649 | 62442 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | 15 | 5 | 5 | 28862 | 3 | ||
| 40421 | 61705 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 57 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21704 | 6005150.34156307 | 2107947.67774505 | 37.7683139415326 | -122.42548186082 | (37.7683139415326, -122.42548186082) | 8 | 4 | 5 | 28853 | 19 | ||
| 56192 | 61710 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | 8 | 4 | 5 | 28862 | 19 | ||
| 62313 | 61708 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 580 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | 8 | 4 | 5 | 28853 | 19 | ||
| 150822 | 61707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1984 12:00:00 AM | 16 | 3x11 | Permit Number 21706 | 6005093.88211876 | 2108026.7239243 | 37.7685277931807 | -122.42568277558 | (37.7685277931807, -122.42568277558) | 8 | 4 | 5 | 28853 | 19 | |
| 188830 | 61704 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21703 | 6005065.62335195 | 2107833.77826085 | 37.7679964138535 | -122.42576678516 | (37.7679964138535, -122.42576678516) | 8 | 4 | 5 | 28853 | 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 | |
| 78944 | 55568 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.402935191909 | (37.7179885201224, -122.402935191909) | 10 | 7 | 8 | 309 | 39 | |
| 12747 | 65465 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.7219083154277 | -122.459411273619 | (37.7219083154277, -122.459411273619) | 9 | 8 | 4 | 28861 | 24 | ||
| 149996 | 64775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 517 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 25767 | 6010461.649147 | 2119569.81510368 | 37.8005242381712 | -122.407930145171 | (37.8005242381712, -122.407930145171) | 3 | 1 | 10 | 308 | 23 | ||
| 152169 | 65423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.407521909343 | (37.7921784739149, -122.407521909343) | 5 | 1 | 10 | 28857 | 21 | ||
| 170465 | 64776 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.406545412053 | (37.7933995175775, -122.406545412053) | 3 | 1 | 10 | 28857 | 4 | ||
| 39537 | 61715 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21715 | 6004926.94134289 | 2108179.4823523 | 37.7689377963385 | -122.42627108706 | (37.7689377963385, -122.42627108706) | 8 | 4 | 5 | 28853 | 19 | ||
| 50241 | 61716 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21716 | 6004986.55656035 | 2108182.89626107 | 37.7689505396343 | -122.426065124893 | (37.7689505396343, -122.426065124893) | 8 | 4 | 5 | 28853 | 19 | ||
| 111937 | 61712 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 239 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21712 | 6005177.32533199 | 2108193.82077345 | 37.768991315779 | -122.425406045223 | (37.768991315779, -122.425406045223) | 8 | 4 | 5 | 28853 | 19 | ||
| 128740 | 61713 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 269 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21713 | 6004998.47961276 | 2108183.57904333 | 37.7689530882522 | -122.42602393242 | (37.7689530882522, -122.42602393242) | 8 | 4 | 5 | 28853 | 19 | ||
| 135237 | 61717 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21717 | 6005390.65318574 | 2108294.55770451 | 37.7692799656993 | -122.424675324148 | (37.7692799656993, -122.424675324148) | 8 | 4 | 5 | 28853 | 19 | ||
| 135891 | 61714 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 236 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21714 | 6005186.275415 | 2108246.41850013 | 37.7691362421663 | -122.425378830956 | (37.7691362421663, -122.425378830956) | 8 | 4 | 5 | 28853 | 19 | ||
| 6180 | 33653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
| 118167 | 33695 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | 7 | 9 | 11 | 28852 | 10 | |||
| 132088 | 33651 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 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 | |||
| 40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
| 123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
| 143659 | 33610 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 2 | 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 | |||
| 148185 | 33613 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.427225555933 | (37.7740225856392, -122.427225555933) | 7 | 9 | 11 | 28852 | 10 | |||
| 184502 | 33607 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.7741681701238 | -122.426080852286 | (37.7741681701238, -122.426080852286) | 7 | 9 | 11 | 28852 | 10 | |||
| 185167 | 33614 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
| 186946 | 33612 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 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 | |||
| 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 | |||
| 115554 | 33588 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | 2 | 7 | 7 | 28859 | 2 | |||
| 165400 | 33589 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 2 | 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 | |||
| 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 | |||
| 126873 | 33585 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.7405430288873 | -122.418608458082 | (37.7405430288873, -122.418608458082) | 2 | 7 | 7 | 28859 | 2 | |||
| 129041 | 33581 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | 2 | 7 | 7 | 28859 | 2 | |||
| 143559 | 33576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336117 | (37.7412413768938, -122.41810336117) | 2 | 7 | 7 | 28859 | 2 | |
| 92219 | 33508 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | 2 | 7 | 7 | 28859 | 2 | |||
| 76352 | 61525 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.473716580773 | (37.7861960776153, -122.473716580773) | 11 | 6 | 2 | 54 | 26 | ||
| 107326 | 66869 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 640 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30178 | 6009507.57601331 | 2115392.34348399 | 37.789000460867 | -122.410936420318 | (37.789000460867, -122.410936420318) | 5 | 1 | 10 | 28857 | 21 | ||
| 124253 | 66867 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 15 | 3x3 | Permit Number 30174 | 6008155.2662548 | 2115151.32890411 | 37.788262771233 | -122.415598176589 | (37.788262771233, -122.415598176589) | 13 | 1 | 10 | 28858 | 21 | |
| 137705 | 66878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30189 | 6001145.91509222 | 2104727.87963003 | 37.7592460999874 | -122.439101967223 | (37.7592460999874, -122.439101967223) | 2 | 4 | 5 | 28862 | 3 | ||
| 28593 | 66848 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 919 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30152 | 6008182.6560056 | 2115155.17049763 | 37.7882748588768 | -122.415503684404 | (37.7882748588768, -122.415503684404) | 13 | 1 | 10 | 28858 | 21 | ||
| 67426 | 63397 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.7592266666695 | -122.437077536949 | (37.7592266666695, -122.437077536949) | 2 | 4 | 5 | 28862 | 3 | ||
| 76403 | 66852 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 805 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30158 | 6008246.52380896 | 2115214.16051417 | 37.7884404207738 | -122.415286889274 | (37.7884404207738, -122.415286889274) | 13 | 1 | 10 | 28858 | 21 | ||
| 74931 | 64702 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.408426051637 | (37.7845809377612, -122.408426051637) | 14 | 10 | 10 | 28852 | 36 | ||
| 98731 | 64717 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 35 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25671 | 6010371.58706878 | 2113906.86566108 | 37.7849701038252 | -122.407842251054 | (37.7849701038252, -122.407842251054) | 14 | 10 | 10 | 28852 | 36 | ||
| 111103 | 64725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.7854060800363 | -122.409096504402 | (37.7854060800363, -122.409096504402) | 14 | 10 | 9 | 28852 | 36 | ||
| 144563 | 64727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.7842816815144 | -122.410412412425 | (37.7842816815144, -122.410412412425) | 14 | 10 | 9 | 28852 | 36 | ||
| 186261 | 64726 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25681 | 6010217.12887008 | 2114048.91615067 | 37.7853514923776 | -122.40838665256 | (37.7853514923776, -122.40838665256) | 14 | 10 | 10 | 28852 | 36 | ||
| 15629 | 66830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.438953746382 | (37.7575293253254, -122.438953746382) | 2 | 4 | 5 | 28862 | 3 | ||
| 122852 | 58069 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30131 | 6000914.77254872 | 2105195.89592401 | 37.7605180033322 | -122.439934925187 | (37.7605180033322, -122.439934925187) | 2 | 4 | 5 | 28862 | 3 | ||
| 164254 | 59572 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 893 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 24583 | 6003136.10237421 | 2103049.36160406 | 37.7547503322276 | -122.432099077639 | (37.7547503322276, -122.432099077639) | 2 | 4 | 5 | 28862 | 22 | ||
| 58481 | 65402 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 |
| 140818 | 65399 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | 7 | 10 | 9 | 28852 | 36 | ||
| 183193 | 65401 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | 13 | 1 | 9 | 28858 | 36 | ||
| 77928 | 55379 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.466300659155 | (37.7651839347095, -122.466300659155) | 11 | 8 | 11 | 56 | 12 | |||
| 37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 50226 | 48785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 181146 | 48788 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 |
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) );