trees
403 rows where qLegalStatus_id = 7 and qSpecies_id = 95 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
194210 | 67740 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1412 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31359 | 5993990.22084457 | 2105880.95703345 | 37.7620023888233 | -122.463933320103 | (37.7620023888233, -122.463933320103) | 1 | 5 | 11 | 56 | 12 | ||
193819 | 62622 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 183 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1986 12:00:00 AM | Permit Number 22936 | 5997384.53937268 | 2107058.88452992 | 37.7654317060994 | -122.452278752633 | (37.7654317060994, -122.452278752633) | 15 | 5 | 11 | 29492 | 9 | ||
192612 | 50116 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46841 | 5990949.33787022 | 2098364.95753208 | 37.7411897083484 | -122.473902084012 | (37.7411897083484, -122.473902084012) | 1 | 8 | 4 | 29491 | 40 | ||
189945 | 62263 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 388 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | Permit Number 22389 | 6003417.83204435 | 2108645.36368336 | 37.7701315759363 | -122.431524257341 | (37.7701315759363, -122.431524257341) | 15 | 9 | 11 | 29492 | 10 | ||
189618 | 33530 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 173 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2005 12:00:00 AM | Permit Number 48005 | 6007338.9559133 | 2098056.09080214 | 37.7412773227891 | -122.417210613498 | (37.7412773227891, -122.417210613498) | 2 | 7 | 7 | 28859 | 2 | ||
189339 | 64316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 68 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25133 | 6004266.78630985 | 2097807.98626151 | 37.740422769496 | -122.427815418773 | (37.740422769496, -122.427815418773) | 2 | 7 | 5 | 63 | 7 | ||
189289 | 63163 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1546 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23700 | 5992783.12624963 | 2104937.37647653 | 37.759341926142 | -122.468039515949 | (37.759341926142, -122.468039515949) | 1 | 8 | 4 | 56 | 12 | ||
188286 | 61116 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 822 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20963 | 6007930.02908725 | 2103130.19672131 | 37.7552429145151 | -122.415526041698 | (37.7552429145151, -122.415526041698) | 2 | 4 | 7 | 28859 | 19 | ||
187874 | 53561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20055 | 5996986.48234272 | 2089260.31315795 | 37.7165383585573 | -122.452371064987 | (37.7165383585573, -122.452371064987) | 9 | 8 | 6 | 28861 | 24 | ||
187125 | 97314 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 939 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990332.7 | 2099029.1 | 37.7429775357045 | -122.47608267022 | (37.7429775357045, -122.47608267022) | 1 | 8 | 3 | 29491 | 35 | ||||
186777 | 67811 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 463 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31464 | 6002153.43837175 | 2101463.35632849 | 37.7503397784586 | -122.435383948576 | (37.7503397784586, -122.435383948576) | 2 | 4 | 5 | 28862 | 22 | ||
186651 | 66444 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 273 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29590 | 6006205.33193134 | 2096117.4303664 | 37.7358903527924 | -122.420992677212 | (37.7358903527924, -122.420992677212) | 2 | 7 | 7 | 28859 | 2 | ||
186398 | 65692 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3511 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1990 12:00:00 AM | Permit Number 28619 | 6006132.70987406 | 2102560.60291656 | 37.7535777519299 | -122.42170125957 | (37.7535777519299, -122.42170125957) | 2 | 4 | 5 | 28859 | 19 | ||
186096 | 65343 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 184 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28175 | 6001750.39660253 | 2095029.30684218 | 37.7326504865842 | -122.436317277562 | (37.7326504865842, -122.436317277562) | 9 | 7 | 5 | 63 | 40 | ||
186053 | 58261 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 284 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29595 | 6006300.27949858 | 2096057.24015103 | 37.7357304355186 | -122.420660133777 | (37.7357304355186, -122.420660133777) | 2 | 7 | 7 | 28859 | 2 | ||
185926 | 54350 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1382 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30523 | 5994910.33164599 | 2106200.68051144 | 37.7629332491802 | -122.460774208888 | (37.7629332491802, -122.460774208888) | 15 | 5 | 11 | 56 | 12 | ||
185379 | 9032 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5401 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | 12 | 3X3 | 5990239.95827 | 2112557.38019 | 37.7801171867577 | -122.477391848024 | (37.7801171867577, -122.477391848024) | 11 | 6 | 2 | 55 | 26 | ||
184927 | 60429 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 435 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1991 12:00:00 AM | Permit Number 29958 | 6003754.61017147 | 2098919.66624389 | 37.743446200008 | -122.429665589175 | (37.743446200008, -122.429665589175) | 2 | 7 | 5 | 63 | 22 | ||
184533 | 67508 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31038 | 5997945.14259478 | 2094073.25690369 | 37.7298084538174 | -122.449404054305 | (37.7298084538174, -122.449404054305) | 9 | 7 | 4 | 28861 | 40 | ||
184444 | 50896 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1647 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47405 | 5990863.99399476 | 2104190.85036451 | 37.7571811470474 | -122.474622258806 | (37.7571811470474, -122.474622258806) | 1 | 8 | 4 | 56 | 12 | ||
184330 | 63064 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 137 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23538 | 6007971.16916269 | 2097987.37436048 | 37.741124189816 | -122.415019774239 | (37.741124189816, -122.415019774239) | 2 | 7 | 7 | 28859 | 2 | ||
184207 | 67721 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31339 | 5994171.17810275 | 2106011.82451063 | 37.7623721436591 | -122.463316960916 | (37.7623721436591, -122.463316960916) | 1 | 5 | 11 | 56 | 12 | ||
182456 | 55778 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 690 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30413 | 6004270.54633332 | 2104877.95135901 | 37.7598354599097 | -122.428306178244 | (37.7598354599097, -122.428306178244) | 2 | 4 | 5 | 28862 | 3 | ||
180832 | 61118 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 814 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20966 | 6007927.54790196 | 2103174.97795415 | 37.7553657341162 | -122.415537792727 | (37.7553657341162, -122.415537792727) | 2 | 4 | 7 | 28859 | 19 | ||
180759 | 64001 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 474 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24748 | 6002109.57147902 | 2100928.27320982 | 37.7488680757283 | -122.435497369218 | (37.7488680757283, -122.435497369218) | 2 | 4 | 5 | 28862 | 22 | ||
180526 | 67545 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1015 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 3x3 | Permit Number 31091 | 6012211.61416229 | 2103662.25645514 | 37.7569435678624 | -122.400756337014 | (37.7569435678624, -122.400756337014) | 10 | 3 | 8 | 28856 | 29 | |
180393 | 63584 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1992 12:00:00 AM | Permit Number 24210 | 6006688.3941557 | 2119426.77030347 | 37.7999195019292 | -122.420976997553 | (37.7999195019292, -122.420976997553) | 5 | 9 | 1 | 28858 | 32 | ||
180278 | 65361 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 7 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28196 | 6002832.7941803 | 2095807.19286717 | 37.7348478258508 | -122.432630712358 | (37.7348478258508, -122.432630712358) | 2 | 7 | 5 | 63 | 7 | ||
179896 | 63641 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 701 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31106 | 6001035.54169923 | 2111072.80974441 | 37.7766614211292 | -122.43993863172 | (37.7766614211292, -122.43993863172) | 15 | 5 | 11 | 29492 | 41 | ||
179550 | 63050 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 614 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1986 12:00:00 AM | Permit Number 23521 | 5993003.74636017 | 2105291.91602449 | 37.7603281373616 | -122.467302290195 | (37.7603281373616, -122.467302290195) | 1 | 8 | 4 | 56 | 12 | ||
178700 | 61907 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 410 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1985 12:00:00 AM | Permit Number 21954 | 6006015.61965589 | 2107886.23746349 | 37.7681940923018 | -122.422484575665 | (37.7681940923018, -122.422484575665) | 8 | 4 | 5 | 28853 | 19 | ||
178593 | 49057 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 634 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46225 | 5995429.55733009 | 2093557.30564002 | 37.7282475554757 | -122.458063335473 | (37.7282475554757, -122.458063335473) | 9 | 7 | 4 | 28861 | 40 | ||
178328 | 57563 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 350 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23113 | 5993229.79890114 | 2104618.42349 | 37.7584919494469 | -122.466471535006 | (37.7584919494469, -122.466471535006) | 1 | 8 | 4 | 56 | 12 | ||
177076 | 42697 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2502 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42714 | 6007504.11437077 | 2120942.44037002 | 37.8041270967963 | -122.41826181189 | (37.8041270967963, -122.41826181189) | 5 | 1 | 1 | 308 | 32 | ||
175969 | 63141 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 62 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1986 12:00:00 AM | Permit Number 23663 | 6007664.9477406 | 2099130.85526884 | 37.7442467216038 | -122.416159545157 | (37.7442467216038, -122.416159545157) | 2 | 7 | 7 | 28859 | 2 | ||
175140 | 49058 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46225 | 5995429.55733009 | 2093557.30564002 | 37.7282475554757 | -122.458063335473 | (37.7282475554757, -122.458063335473) | 9 | 7 | 4 | 28861 | 40 | ||
174834 | 65309 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 57 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28128 | 6006032.10149289 | 2105174.27390914 | 37.7607486106903 | -122.422234865835 | (37.7607486106903, -122.422234865835) | 2 | 4 | 5 | 28859 | 19 | ||
174428 | 62764 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 445 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23118 | 5992939.7007125 | 2104556.5051909 | 37.7583051939109 | -122.467470313222 | (37.7583051939109, -122.467470313222) | 1 | 8 | 4 | 56 | 12 | ||
174388 | 63732 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 529 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24401 | 6004035.25561517 | 2109719.19558167 | 37.7731150315991 | -122.429465186856 | (37.7731150315991, -122.429465186856) | 7 | 9 | 11 | 29492 | 10 | ||
174374 | 62623 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 300 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 22937 | 5996744.75965336 | 2107022.23361266 | 37.7652944000367 | -122.454488943604 | (37.7652944000367, -122.454488943604) | 15 | 5 | 11 | 29492 | 12 | ||
174116 | 60904 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1427 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20694 | 5994561.02104765 | 2105809.15842746 | 37.7618381267347 | -122.461953952005 | (37.7618381267347, -122.461953952005) | 1 | 5 | 11 | 56 | 12 | ||
173702 | 62707 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1111 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23047 | 6007709.6882052 | 2118843.89920781 | 37.7983765997638 | -122.417401596179 | (37.7983765997638, -122.417401596179) | 5 | 1 | 10 | 28858 | 32 | ||
173258 | 60174 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 58 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19706 | 6005980.54267334 | 2105164.87188329 | 37.7607198865759 | -122.422412516922 | (37.7607198865759, -122.422412516922) | 2 | 4 | 5 | 28859 | 19 | ||
172794 | 62840 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3 Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1986 12:00:00 AM | Permit Number 23207 | 6001668.62546357 | 2111862.95878807 | 37.7788669893558 | -122.437805219223 | (37.7788669893558, -122.437805219223) | 15 | 5 | 11 | 29490 | 41 | ||
170784 | 61120 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 852 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | 3x3 | Permit Number 20968 | 6007939.33353128 | 2102962.26711257 | 37.7547823410171 | -122.415481975691 | (37.7547823410171, -122.415481975691) | 2 | 4 | 7 | 28859 | 19 | |
170639 | 63052 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 740 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1986 12:00:00 AM | Permit Number 23523 | 5992616.86380837 | 2105278.68425229 | 37.7602694647792 | -122.468639361712 | (37.7602694647792, -122.468639361712) | 1 | 8 | 4 | 56 | 12 | ||
170039 | 66650 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 987 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1991 12:00:00 AM | Permit Number 29864 | 6009988.37334471 | 2103470.11092484 | 37.756291725608 | -122.408431620376 | (37.756291725608, -122.408431620376) | 2 | 4 | 7 | 28859 | 19 | ||
169603 | 61117 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 858 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20965 | 6007941.19441974 | 2102928.68119709 | 37.7546902263284 | -122.415473162557 | (37.7546902263284, -122.415473162557) | 2 | 4 | 7 | 28859 | 19 | ||
168877 | 63763 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 326 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | 4x4 | Permit Number 24441 | 6003279.4994369 | 2109390.21547957 | 37.7721689148553 | -122.432055945851 | (37.7721689148553, -122.432055945851) | 15 | 9 | 11 | 29492 | 10 | |
168535 | 67507 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 427 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31037 | 5997919.84331621 | 2094073.6426889 | 37.7298080658571 | -122.449491544159 | (37.7298080658571, -122.449491544159) | 9 | 7 | 4 | 28861 | 40 | ||
168334 | 22790 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1002X BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6000899 | 2112257 | 37.7799051333688 | -122.440495920848 | (37.7799051333688, -122.440495920848) | 15 | 5 | 1 | 29490 | 41 | |||
168259 | 63060 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23533 | 6007921.44237277 | 2098016.86260638 | 37.7412023635315 | -122.415193798943 | (37.7412023635315, -122.415193798943) | 2 | 7 | 7 | 28859 | 2 | ||
168145 | 48651 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 436 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45944 | 5992984.82174841 | 2103929.91361967 | 37.756587341409 | -122.467268706379 | (37.756587341409, -122.467268706379) | 1 | 8 | 4 | 56 | 12 | ||
168128 | 63755 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 832 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24429 | 6002579.84478406 | 2109569.92728925 | 37.7726226680298 | -122.434488959034 | (37.7726226680298, -122.434488959034) | 15 | 5 | 11 | 29492 | 9 | ||
167957 | 63065 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 142 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23539 | 6007917.25386663 | 2097966.50690412 | 37.7410638625071 | -122.415204717661 | (37.7410638625071, -122.415204717661) | 2 | 7 | 7 | 28859 | 2 | ||
167823 | 62961 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Glover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1991 12:00:00 AM | Permit Number 29804 | 6008099.43910832 | 2118378.4690573 | 37.7971205654778 | -122.416019957286 | (37.7971205654778, -122.416019957286) | 5 | 1 | 10 | 28858 | 21 | ||
167584 | 60395 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1498 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19975 | 6015454.39806509 | 2094856.49905074 | 37.7329451185448 | -122.388926707993 | (37.7329451185448, -122.388926707993) | 10 | 3 | 8 | 58 | 1 | ||
167246 | 56610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 117 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 30987 | 5996756.33540734 | 2098503.70250218 | 37.7419053104165 | -122.453833690323 | (37.7419053104165, -122.453833690323) | 9 | 7 | 4 | 59 | 40 | ||
167021 | 60960 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1988 12:00:00 AM | Permit Number 25349 | 5994476.34646497 | 2090599.97936006 | 37.7200726359376 | -122.461144327567 | (37.7200726359376, -122.461144327567) | 9 | 8 | 6 | 28861 | 24 | ||
166941 | 66373 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 430 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29497 | 6003708.35294884 | 2109810.61822809 | 37.7733475417865 | -122.430602509574 | (37.7733475417865, -122.430602509574) | 7 | 9 | 11 | 29492 | 10 | ||
166868 | 10321 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 759 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6002536.32245 | 2109085.56364 | 37.7712902545388 | -122.434604866834 | (37.7712902545388, -122.434604866834) | 15 | 5 | 11 | 29492 | 9 | |||
166566 | 62573 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 801 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1986 12:00:00 AM | Permit Number 22776 | 6011595.8787413 | 2104633.73265 | 37.7595766638959 | -122.402954119848 | (37.7595766638959, -122.402954119848) | 10 | 3 | 8 | 28856 | 29 | ||
166556 | 60669 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 274 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20303 | 6004309.8735522 | 2096796.94934371 | 37.7376491294631 | -122.427594426597 | (37.7376491294631, -122.427594426597) | 2 | 7 | 5 | 63 | 7 | ||
166307 | 60430 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 444 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20014 | 6003690.1283836 | 2098968.15386996 | 37.743575684401 | -122.429892008764 | (37.743575684401, -122.429892008764) | 2 | 7 | 5 | 63 | 22 | ||
165245 | 60510 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 422 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20111 | 6003825.62361314 | 2098975.70390357 | 37.7436040873115 | -122.429424038012 | (37.7436040873115, -122.429424038012) | 2 | 7 | 5 | 63 | 22 | ||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
164257 | 63147 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 20 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23671 | 6007775.53451275 | 2099335.86321351 | 37.7448158451585 | -122.415791672307 | (37.7448158451585, -122.415791672307) | 2 | 7 | 7 | 28859 | 2 | ||
163763 | 63895 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4072 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24604 | 6003387.44157701 | 2101291.75530451 | 37.7499386063134 | -122.431104436753 | (37.7499386063134, -122.431104436753) | 2 | 4 | 5 | 28862 | 22 | ||
163553 | 51787 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 2x2 | Permit Number 48036 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||
163143 | 60903 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1425 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20693 | 5994560.57108256 | 2105822.18766278 | 37.7618738757344 | -122.461956453095 | (37.7618738757344, -122.461956453095) | 1 | 5 | 11 | 56 | 12 | ||
161771 | 63435 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 377 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1992 12:00:00 AM | Permit Number 24021 | 6007192.36078339 | 2096034.20688354 | 37.7357174284993 | -122.41757422253 | (37.7357174284993, -122.41757422253) | 2 | 7 | 7 | 28859 | 2 | ||
160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
160645 | 60171 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19703 | 6006022.18480698 | 2105353.25306047 | 37.7612394861061 | -122.422281879808 | (37.7612394861061, -122.422281879808) | 2 | 4 | 5 | 28859 | 19 | ||
160118 | 63660 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 423 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24308 | 6003762.6367623 | 2100089.82328361 | 37.7466596348506 | -122.429721277679 | (37.7466596348506, -122.429721277679) | 2 | 7 | 5 | 63 | 22 | ||
159391 | 63139 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 75 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23660 | 6007418.4427162 | 2098943.4214592 | 37.74371820671 | -122.416998630994 | (37.74371820671, -122.416998630994) | 2 | 7 | 7 | 28859 | 2 | ||
159191 | 67468 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30989 | 5996784.33302359 | 2098587.30616541 | 37.7421364707665 | -122.453742919924 | (37.7421364707665, -122.453742919924) | 9 | 7 | 4 | 59 | 40 | ||
158705 | 66004 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 180 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1991 12:00:00 AM | Permit Number 29893 | 6005395.81468194 | 2102664.85986255 | 37.7538224360036 | -122.424257021497 | (37.7538224360036, -122.424257021497) | 2 | 4 | 5 | 28859 | 19 | ||
157627 | 63327 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 67 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23900 | 6009588.27522653 | 2099896.70340901 | 37.7464575292866 | -122.409563106368 | (37.7464575292866, -122.409563106368) | 2 | 7 | 7 | 28859 | 2 | ||
157594 | 63187 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2043 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23726 | 6001104.49990341 | 2112782.16109976 | 37.7813587913625 | -122.439822670066 | (37.7813587913625, -122.439822670066) | 15 | 5 | 11 | 29490 | 41 | ||
156689 | 62526 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4239 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22708 | 6000961.55320183 | 2102860.47332895 | 37.7541081639689 | -122.439605705302 | (37.7541081639689, -122.439605705302) | 2 | 4 | 5 | 28862 | 22 | ||
156501 | 63178 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 720 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23716 | 5992676.38910758 | 2105280.72009122 | 37.7602784930998 | -122.468433641583 | (37.7602784930998, -122.468433641583) | 1 | 8 | 4 | 56 | 12 | ||
156480 | 63434 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 386 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/1987 12:00:00 AM | Permit Number 24020 | 6007282.26446985 | 2095974.44193855 | 37.7355583855051 | -122.417259156011 | (37.7355583855051, -122.417259156011) | 2 | 7 | 7 | 28859 | 2 | ||
155970 | 62264 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 372 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | Permit Number 22390 | 6003490.95554643 | 2108655.49209319 | 37.7701635303226 | -122.431272047126 | (37.7701635303226, -122.431272047126) | 15 | 9 | 11 | 29492 | 10 | ||
155735 | 66750 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1142 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30002 | 5998925.54623856 | 2105975.96738823 | 37.7625464469733 | -122.446870853669 | (37.7625464469733, -122.446870853669) | 15 | 5 | 5 | 29492 | 9 | ||
155228 | 59897 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 935 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19364 | 6009972.36860378 | 2103760.42694535 | 37.7570879720238 | -122.408507448602 | (37.7570879720238, -122.408507448602) | 2 | 4 | 7 | 28859 | 19 | ||
154901 | 83220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4431 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51278 | 5981138.26503887 | 2104833.82596272 | 37.7583782380396 | -122.508304716049 | (37.7583782380396, -122.508304716049) | 1 | 8 | 3 | 56 | 35 | ||
154008 | 63045 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 103 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1986 12:00:00 AM | Permit Number 23516 | 6007983.03659741 | 2098130.04885807 | 37.7415166093433 | -122.414988836764 | (37.7415166093433, -122.414988836764) | 2 | 7 | 7 | 28859 | 2 | ||
153897 | 62673 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 51 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | 8 | Permit Number 23005 | 6002835.80598881 | 2108710.40434304 | 37.7702771561462 | -122.433542126154 | (37.7702771561462, -122.433542126154) | 15 | 5 | 5 | 29492 | 9 | |
153567 | 68793 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2646 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32732 | 5991785.3639189 | 2097418.62404016 | 37.7386397061499 | -122.470942510825 | (37.7386397061499, -122.470942510825) | 1 | 8 | 4 | 29491 | 40 | ||
153041 | 50115 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1644 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46840 | 5990947.45576914 | 2098416.9234603 | 37.7413322844264 | -122.473912381937 | (37.7413322844264, -122.473912381937) | 1 | 8 | 4 | 29491 | 40 | ||
152723 | 63146 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 28 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23669 | 6007754.47036406 | 2099296.81407821 | 37.7447074407563 | -122.415861743766 | (37.7447074407563, -122.415861743766) | 2 | 7 | 7 | 28859 | 2 | ||
152485 | 56760 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 601 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23012 | 6002834.07750169 | 2108857.67931185 | 37.7706814389316 | -122.433558631653 | (37.7706814389316, -122.433558631653) | 15 | 5 | 5 | 29492 | 9 | ||
151706 | 60433 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 451 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20017 | 6003656.06819054 | 2098914.17531059 | 37.7434255428329 | -122.430005930771 | (37.7434255428329, -122.430005930771) | 2 | 7 | 5 | 63 | 22 | ||
151497 | 63643 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 615 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1987 12:00:00 AM | Permit Number 24290 | 6001076.3999006 | 2110778.3153622 | 37.7758551396753 | -122.439776172675 | (37.7758551396753, -122.439776172675) | 15 | 5 | 11 | 29492 | 10 | ||
150267 | 67037 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 620 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30412 | 6004248.3695844 | 2105283.39712956 | 37.7609474626645 | -122.428411775349 | (37.7609474626645, -122.428411775349) | 2 | 4 | 5 | 28862 | 3 | ||
150190 | 95609 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
149939 | 60369 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1435 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19947 | 6015750.16258389 | 2094570.92480778 | 37.7321773784731 | -122.387884244628 | (37.7321773784731, -122.387884244628) | 10 | 3 | 8 | 58 | 1 | ||
149896 | 67108 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1285 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30525 | 5995458.01605947 | 2106809.73569122 | 37.7646370541731 | -122.458924070061 | (37.7646370541731, -122.458924070061) | 15 | 5 | 11 | 56 | 12 | ||
149531 | 62763 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 438 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23117 | 5992955.71018019 | 2104609.08107701 | 37.7584504778466 | -122.467418769042 | (37.7584504778466, -122.467418769042) | 1 | 8 | 4 | 56 | 12 |
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) );