trees
39,840 rows where qLegalStatus_id = 7 sorted by Longitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134919 | 46283 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44562 | 5980721.66048407 | 2110916.40891105 | 37.7750546792032 | -122.510197410494 | (37.7750546792032, -122.510197410494) | 11 | 6 | 2 | 55 | 26 | |||
22675 | 59691 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 185 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | 38 | 4x3 | Permit Number 19118 | 5980952.62035506 | 2112920.61231564 | 37.7805712485973 | -122.509547375915 | (37.7805712485973, -122.509547375915) | 11 | 6 | 2 | 55 | 26 | |
144628 | 58178 | Permitted Site 7 | Tree(s) :: 17 | 1225 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1978 12:00:00 AM | Permit Number 17165 | 5980845.45874958 | 2106718.95428183 | 37.7635369974083 | -122.509457359298 | (37.7635369974083, -122.509457359298) | 1 | 8 | 3 | 56 | 35 | |||
9102 | 83833 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
115361 | 83929 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
43795 | 31943 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1300 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767126 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807627 | (37.761983899941, -122.50916807627) | 1 | 8 | 3 | 56 | 35 | |
77823 | 31942 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807627 | (37.761983899941, -122.50916807627) | 1 | 8 | 3 | 56 | 35 | ||
122211 | 40219 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 165 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | Permit Number 41398 | 5981062.91201163 | 2112924.76539407 | 37.7805891547083 | -122.509166139987 | (37.7805891547083, -122.509166139987) | 11 | 6 | 2 | 55 | 26 | ||
3158 | 44124 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | 11 | 6 | 2 | 55 | 26 | |||
28150 | 89203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
126209 | 89204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
183167 | 89202 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
76858 | 47887 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1396 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.509057703423 | (37.7603777089466, -122.509057703423) | 1 | 8 | 3 | 56 | 35 | ||
188388 | 47888 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1396 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.509057703423 | (37.7603777089466, -122.509057703423) | 1 | 8 | 3 | 56 | 35 | ||
178293 | 66721 | Permitted Site 7 | Tree(s) :: 17 | 1444 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | Permit Number 29963 | 5980948.12244708 | 2105220.40445494 | 37.7594284644995 | -122.508991005813 | (37.7594284644995, -122.508991005813) | 1 | 8 | 3 | 56 | 35 | |||
11759 | 66722 | Permitted Site 7 | Tree(s) :: 17 | 1448 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | Permit Number 29964 | 5980949.03538883 | 2105193.86750643 | 37.7593556554787 | -122.508985878013 | (37.7593556554787, -122.508985878013) | 1 | 8 | 3 | 56 | 35 | |||
53430 | 83316 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.508983405944 | (37.7580789214423, -122.508983405944) | 1 | 8 | 3 | 56 | 35 | ||
83994 | 83930 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1516 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.508983405944 | (37.7580789214423, -122.508983405944) | 1 | 8 | 3 | 56 | 35 | ||
67140 | 37133 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1496 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095357 | -122.508965208548 | (37.758434095357, -122.508965208548) | 1 | 8 | 3 | 56 | 35 | ||
99205 | 37134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1496 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095357 | -122.508965208548 | (37.758434095357, -122.508965208548) | 1 | 8 | 3 | 56 | 35 | ||
46529 | 38359 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
62563 | 38357 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
88505 | 38358 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
127152 | 38356 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
127386 | 38355 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | 1 | 8 | 3 | 56 | 35 | ||
192874 | 83520 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1488 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50200 | 5980958.16481146 | 2104928.49787253 | 37.7586275647998 | -122.508934600528 | (37.7586275647998, -122.508934600528) | 1 | 8 | 3 | 56 | 35 | ||
95133 | 83966 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.7585547558345 | -122.508929472843 | (37.7585547558345, -122.508929472843) | 1 | 8 | 3 | 56 | 35 | ||
121200 | 83967 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50201 | 5980959.07775236 | 2104901.96094882 | 37.7585547558345 | -122.508929472843 | (37.7585547558345, -122.508929472843) | 1 | 8 | 3 | 56 | 35 | ||
128536 | 31944 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 4739X Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767126 | 5980987.9788 | 2106187.281 | 37.7620855787641 | -122.508924957063 | (37.7620855787641, -122.508924957063) | 1 | 8 | 3 | 56 | 35 |
168628 | 30893 | Permitted Site 7 | Tree(s) :: 17 | 762 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34720 | 5981083.10854015 | 2110529.64234403 | 37.7740140460133 | -122.508918381294 | (37.7740140460133, -122.508918381294) | 11 | 6 | 2 | 55 | 26 | ||||
4178 | 31221 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.7739423822297 | -122.508913237037 | (37.7739423822297, -122.508913237037) | 11 | 6 | 2 | 55 | 26 | |||
117570 | 96626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
71464 | 33758 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 842 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | Permit Number 37811 | 5981102.7142707 | 2109980.14676383 | 37.7725064482728 | -122.508809756644 | (37.7725064482728, -122.508809756644) | 11 | 6 | 2 | 55 | 26 | |||
167616 | 54783 | Permitted Site 7 | Tree(s) :: 17 | 854 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | Permit Number 10632 | 5981105.51814859 | 2109901.96843925 | 37.7722919587991 | -122.508794252455 | (37.7722919587991, -122.508794252455) | 11 | 6 | 2 | 55 | 26 | |||
81575 | 38360 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1610 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41156 | 5980983.59087853 | 2104088.99570474 | 37.7563240309044 | -122.508784338324 | (37.7563240309044, -122.508784338324) | 1 | 8 | 3 | 56 | 35 | ||
64074 | 65145 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1991 12:00:00 AM | Permit Number 30097 | 5981171.08035557 | 2112695.84581661 | 37.7799669861685 | -122.50877493976 | (37.7799669861685, -122.50877493976) | 11 | 6 | 2 | 55 | 26 | ||
129854 | 38361 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40425 | 5980991.46797396 | 2103984.91123867 | 37.756038708992 | -122.5087493697 | (37.756038708992, -122.5087493697) | 1 | 8 | 3 | 56 | 35 | ||
60317 | 38362 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1642 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2001 12:00:00 AM | Permit Number 40426 | 5980999.10411901 | 2103880.73539886 | 37.7557531219667 | -122.508715227831 | (37.7557531219667, -122.508715227831) | 1 | 8 | 3 | 56 | 35 | ||
85106 | 65140 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27115 | 5981196.67226771 | 2112697.46270488 | 37.7799729341387 | -122.508686527544 | (37.7799729341387, -122.508686527544) | 11 | 6 | 2 | 55 | 26 | ||
47286 | 40218 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 139 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | Permit Number 41397 | 5981206.29115693 | 2112930.16439571 | 37.7806124308083 | -122.508670533035 | (37.7806124308083, -122.508670533035) | 11 | 6 | 2 | 55 | 26 | ||
87243 | 109278 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.7560264628403 | -122.508644093874 | (37.7560264628403, -122.508644093874) | 1 | 8 | 3 | 56 | 35 |
138561 | 36089 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.7545362217712 | -122.508568229446 | (37.7545362217712, -122.508568229446) | 1 | 8 | 3 | 56 | 35 | ||
166558 | 59770 | Permitted Site 7 | Tree(s) :: 17 | 133 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1981 12:00:00 AM | Permit Number 19213 | 5981239.37864566 | 2112931.41031893 | 37.7806178019191 | -122.508556162178 | (37.7806178019191, -122.508556162178) | 11 | 6 | 2 | 55 | 26 | |||
68782 | 59690 | Permitted Site 7 | Tree(s) :: 17 | 128 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19117 | 5981244.342209 | 2112983.63407711 | 37.7807614853819 | -122.508542869186 | (37.7807614853819, -122.508542869186) | 11 | 6 | 2 | 55 | 15 | |||
180905 | 95287 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245@Lower Great Highway Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2011 12:00:00 AM | 3x5 | 5981056 | 2104104.5 | 37.7563708691811 | -122.508535077894 | (37.7563708691811, -122.508535077894) | 1 | 8 | 3 | 56 | 35 | |||
159304 | 36090 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1726 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2008 12:00:00 AM | 3x3 | Permit Number 50757 | 5981042.98067926 | 2103306.534633 | 37.7541791163278 | -122.508520867013 | (37.7541791163278, -122.508520867013) | 1 | 8 | 3 | 56 | 35 | ||
104001 | 24757 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5981247.69836 | 2112733.69414 | 37.7800754223594 | -122.508512699012 | (37.7800754223594, -122.508512699012) | 11 | 6 | 2 | 55 | 26 | |||
48471 | 38363 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1730 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2004 12:00:00 AM | Permit Number 44741 | 5981045.1604602 | 2103280.47601246 | 37.7541076952376 | -122.508511394581 | (37.7541076952376, -122.508511394581) | 1 | 8 | 3 | 56 | 35 | ||
40834 | 68577 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 139 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32471 | 5981217.74443457 | 2111271.39856875 | 37.7760586259822 | -122.508507736704 | (37.7760586259822, -122.508507736704) | 11 | 6 | 2 | 55 | 26 | ||
147854 | 64462 | Permitted Site 7 | Tree(s) :: 17 | 1738 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1988 12:00:00 AM | Permit Number 25329 | 5981049.52002107 | 2103228.35878357 | 37.7539648530856 | -122.508492449778 | (37.7539648530856, -122.508492449778) | 1 | 8 | 3 | 56 | 35 | |||
176738 | 37132 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 4447 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39714 | 5981086.08651436 | 2104832.07084282 | 37.7583703439041 | -122.508485038953 | (37.7583703439041, -122.508485038953) | 1 | 8 | 3 | 56 | 35 | ||
151418 | 50438 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/1989 12:00:00 AM | Permit Number 47089 | 5981256.38673996 | 2112701.23544484 | 37.7799868124804 | -122.508480232282 | (37.7799868124804, -122.508480232282) | 11 | 6 | 2 | 55 | 26 | ||
69644 | 59689 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | 22 | 4x6 | Permit Number 19116 | 5981272.46613438 | 2112932.65624215 | 37.780623172919 | -122.508441791304 | (37.780623172919, -122.508441791304) | 11 | 6 | 2 | 55 | 26 | |
16152 | 63923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561579 | (37.7535363264903, -122.50843561579) | 1 | 8 | 3 | 56 | 35 | |
64588 | 85357 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
112081 | 85358 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
150410 | 85355 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||||
152136 | 85356 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49635 | 5981133.2 | 2106271.2 | 37.7623245557762 | -122.508428931586 | (37.7623245557762, -122.508428931586) | 1 | 8 | 3 | 56 | 35 | |||
154772 | 85386 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | 1 | 8 | 3 | 56 | 35 | ||||
110237 | 34726 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 124 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38380 | 5981257.35364784 | 2111324.85465996 | 37.7762077350133 | -122.508374689338 | (37.7762077350133, -122.508374689338) | 11 | 6 | 2 | 55 | 26 | ||
19267 | 88109 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1305 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51113 | 5981150.4 | 2106141.9 | 37.7619705488895 | -122.508359845943 | (37.7619705488895, -122.508359845943) | 1 | 8 | 3 | 56 | 35 | |||
100967 | 59688 | Permitted Site 7 | Tree(s) :: 17 | 121 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19115 | 5981305.55363342 | 2112933.90216575 | 37.7806285438096 | -122.508327420378 | (37.7806285438096, -122.508327420378) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
166768 | 83830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 4429 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50197 | 5981144.78735824 | 2104834.04535283 | 37.7583792247877 | -122.50828217567 | (37.7583792247877, -122.50828217567) | 1 | 8 | 3 | 56 | 35 | ||
148527 | 119142 | Permitted Site 7 | Tristania conferta :: 61 | 583 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781376 | 5981295.16505 | 2111765.56723 | 37.7774200299425 | -122.508276611938 | (37.7774200299425, -122.508276611938) | 11 | 6 | 2 | 55 | 26 |
157305 | 34725 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | 11 | 6 | 2 | 55 | 26 | ||
101255 | 96912 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 4300@48th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981169 | 2105631 | 37.7605688605658 | -122.508257593382 | (37.7605688605658, -122.508257593382) | 1 | 8 | 3 | 56 | 35 | ||
191315 | 96911 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 4300 JUDAH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981169 | 2105631 | 37.7605688605658 | -122.508257593382 | (37.7605688605658, -122.508257593382) | 1 | 8 | 3 | 56 | 35 | ||
162007 | 56081 | Permitted Site 7 | Tree(s) :: 17 | 436 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12179 | 5981319.11647903 | 2112553.81490181 | 37.7795857362334 | -122.508252280354 | (37.7795857362334, -122.508252280354) | 11 | 6 | 2 | 55 | 26 | |||
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
118790 | 67686 | Permitted Site 7 | Tree(s) :: 17 | 1339 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31291 | 5981181.94376706 | 2105952.49861044 | 37.7614523660953 | -122.508236691393 | (37.7614523660953, -122.508236691393) | 1 | 8 | 3 | 56 | 35 | |||
191599 | 47836 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 506 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | Permit Number 45598 | 5981328.87768988 | 2112285.52839896 | 37.7788496761933 | -122.508198593969 | (37.7788496761933, -122.508198593969) | 11 | 6 | 2 | 55 | 26 | ||
30463 | 99864 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768887 | 5981306.2 | 2111092.9 | 37.7755737343962 | -122.508188499048 | (37.7755737343962, -122.508188499048) | 11 | 6 | 2 | 55 | 26 | ||||
146301 | 68572 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 685 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32463 | 5981320.71250249 | 2111079.78815826 | 37.7755385883149 | -122.508137324272 | (37.7755385883149, -122.508137324272) | 11 | 6 | 2 | 55 | 26 | ||
124631 | 67263 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.7780020106611 | -122.508136768544 | (37.7780020106611, -122.508136768544) | 11 | 6 | 2 | 55 | 26 | ||
36794 | 96909 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 1399X 48TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210 | 2105881 | 37.7612577047615 | -122.508134351337 | (37.7612577047615, -122.508134351337) | 1 | 8 | 3 | 56 | 35 | ||
82007 | 96910 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1399X 48TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210 | 2105881 | 37.7612577047615 | -122.508134351337 | (37.7612577047615, -122.508134351337) | 1 | 8 | 3 | 56 | 35 | ||
4351 | 65141 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.7800120543584 | -122.508105008848 | (37.7800120543584, -122.508105008848) | 11 | 6 | 2 | 55 | 26 | ||
163985 | 24756 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5981368.21814 | 2112741.41558 | 37.7801037254846 | -122.508096347212 | (37.7801037254846, -122.508096347212) | 11 | 6 | 2 | 55 | 26 | |||
165381 | 31940 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1322 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767124 | 5981230.33279016 | 2106058.35423449 | 37.7617458665939 | -122.508077193589 | (37.7617458665939, -122.508077193589) | 1 | 8 | 3 | 56 | 35 | |
161800 | 56083 | Permitted Site 7 | Tree(s) :: 17 | 741 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1992 12:00:00 AM | Permit Number 30425 | 5981335.16255903 | 2110682.62925034 | 37.7744489582315 | -122.508057855787 | (37.7744489582315, -122.508057855787) | 11 | 6 | 2 | 55 | 26 | |||
188923 | 34718 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | 11 | 6 | 2 | 55 | 26 | ||
86192 | 37106 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1495 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | 1 | 8 | 3 | 56 | 35 | ||
171637 | 37105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1495 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | 1 | 8 | 3 | 56 | 35 | ||
62894 | 56090 | Permitted Site 7 | Tree(s) :: 17 | 761 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12188 | 5981339.91382434 | 2110552.04113046 | 37.7740906815722 | -122.508031726591 | (37.7740906815722, -122.508031726591) | 11 | 6 | 2 | 55 | 26 | |||
34599 | 68571 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 680 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32462 | 5981371.58179768 | 2111111.81123309 | 37.7756295116497 | -122.507963735355 | (37.7756295116497, -122.507963735355) | 11 | 6 | 2 | 55 | 26 | ||
137714 | 67688 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1551 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2007 12:00:00 AM | Permit Number 49593 | 5981231.37137157 | 2104515.76346185 | 37.7575104157548 | -122.507959114088 | (37.7575104157548, -122.507959114088) | 1 | 8 | 3 | 56 | 35 | |||
12571 | 261236 | Permitted Site 7 | Tree(s) :: 17 | 1966 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784901 | 5981171.78192 | 2101687.9139 | 37.7497424323589 | -122.507955330593 | (37.7497424323589, -122.507955330593) | 1 | 8 | 3 | 29491 | 35 | |
151049 | 56078 | Permitted Site 7 | Tree(s) :: 17 | 706 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | Permit Number 12175 | 5981379.05102496 | 2110906.51972934 | 37.7750662816644 | -122.50792265909 | (37.7750662816644, -122.50792265909) | 11 | 6 | 2 | 55 | 26 | |||
163486 | 258504 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1474 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783288 | 5981259.3327 | 2105040.90267 | 37.7589539453375 | -122.507901385569 | (37.7589539453375, -122.507901385569) | 1 | 8 | 3 | 56 | 35 | |
128324 | 258505 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1478 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784309 | 5981260.22939 | 2105014.83778 | 37.7588824314433 | -122.507896350106 | (37.7588824314433, -122.507896350106) | 1 | 8 | 3 | 56 | 35 | |
115305 | 69000 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32995 | 5981187.48777379 | 2101571.41580392 | 37.7494234868175 | -122.507892375543 | (37.7494234868175, -122.507892375543) | 1 | 8 | 3 | 29491 | 35 | ||
146053 | 61900 | Permitted Site 7 | Tree(s) :: 17 | 867 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | Permit Number 21943 | 5981366.38514908 | 2109833.22098099 | 37.7721185718465 | -122.507886803182 | (37.7721185718465, -122.507886803182) | 11 | 6 | 2 | 55 | 26 | |||
191277 | 68288 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1994 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1993 12:00:00 AM | Permit Number 32097 | 5981192.89165036 | 2101506.41861494 | 37.7492453412397 | -122.507868866206 | (37.7492453412397, -122.507868866206) | 1 | 8 | 3 | 29491 | 35 | ||
9440 | 56089 | Permitted Site 7 | Tree(s) :: 17 | 756 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12187 | 5981390.92918714 | 2110580.04946016 | 37.7741705900693 | -122.507857337664 | (37.7741705900693, -122.507857337664) | 11 | 6 | 2 | 55 | 26 | |||
159291 | 54067 | Permitted Site 7 | Tree(s) :: 17 | 1637 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9790 | 5981251.61714201 | 2103927.27155082 | 37.7558957776852 | -122.507845425767 | (37.7558957776852, -122.507845425767) | 1 | 8 | 3 | 56 | 35 | |||
97119 | 54068 | Permitted Site 7 | Tree(s) :: 17 | 1643 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9791 | 5981252.96111373 | 2103888.20574043 | 37.7557885932785 | -122.507837878985 | (37.7557885932785, -122.507837878985) | 1 | 8 | 3 | 56 | 35 | |||
42982 | 56092 | Permitted Site 7 | Tree(s) :: 17 | 772 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12191 | 5981394.73019993 | 2110475.57894961 | 37.7738839686542 | -122.507836435135 | (37.7738839686542, -122.507836435135) | 11 | 6 | 2 | 55 | 26 |
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) );