trees
163,064 rows where qCaretaker_id = 2 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83914 | 99756 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837 | 2100870 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | 2 | 4 | 5 | 28862 | 22 | |||
| 8683 | 99744 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 431 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time as tree no. 1 w/same permit. CB | 6002387 | 2100900 | 37.7488061968535 | -122.43453600134 | (37.7488061968535, -122.43453600134) | 2 | 4 | 5 | 28862 | 22 | |||
| 34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
| 70430 | 142788 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | 7 | 9 | 9 | 28858 | 36 | ||
| 78904 | 98227 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Planted without permit; 2' away from sewer line. | 6007132 | 2097003 | 37.7383741239705 | -122.417851565085 | (37.7383741239705, -122.417851565085) | 2 | 7 | 7 | 28859 | 2 | |||
| 168861 | 95412 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
| 105406 | 95411 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
| 41375 | 96477 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3x3 | Permit number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
| 178575 | 96914 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | 2 | 4 | 5 | 28862 | 22 | |
| 140857 | 54249 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1274 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | 20 | Permit Number 9991 | 5988659.40013717 | 2106655.34316867 | 37.7638199891792 | -122.482427078169 | (37.7638199891792, -122.482427078169) | 1 | 8 | 3 | 56 | 35 | ||
| 145534 | 54248 | Permitted Site 7 | Tree(s) :: 17 | 1270 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | Permit Number 9990 | 5988658.49378017 | 2106681.68861971 | 37.7638922738793 | -122.482432143443 | (37.7638922738793, -122.482432143443) | 1 | 8 | 3 | 56 | 35 | |||
| 124166 | 54246 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | 12 | Permit Number 9988 | 5988645.1955 | 2106901.8925 | 37.764496120049 | -122.482494273902 | (37.764496120049, -122.482494273902) | 1 | 8 | 3 | 56 | 35 | ||
| 38184 | 54244 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.429998956827 | (37.7658818771202, -122.429998956827) | 8 | 4 | 5 | 28862 | 3 | ||
| 169326 | 240582 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.7657334691548 | -122.429968344076 | (37.7657334691548, -122.429968344076) | 8 | 4 | 5 | 28862 | 3 | |
| 44329 | 54243 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.7776027359423 | -122.450610999735 | (37.7776027359423, -122.450610999735) | 15 | 6 | 2 | 54 | 16 | ||
| 80051 | 54242 | Permitted Site 7 | Tree(s) :: 17 | 1201 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9982 | 5998165.20998344 | 2106218.14593623 | 37.7631679419226 | -122.449518019404 | (37.7631679419226, -122.449518019404) | 15 | 5 | 11 | 29492 | 9 | |||
| 76590 | 54241 | Permitted Site 7 | Tree(s) :: 17 | 1289 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9981 | 5995148.59563824 | 2106773.34474969 | 37.7645193430248 | -122.459991629084 | (37.7645193430248, -122.459991629084) | 15 | 5 | 11 | 56 | 12 | |||
| 69136 | 54239 | Permitted Site 7 | Tree(s) :: 17 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9979 | 5995147.26905248 | 2106811.90515359 | 37.7646251436038 | -122.459999010975 | (37.7646251436038, -122.459999010975) | 15 | 5 | 11 | 56 | 12 | |||
| 158320 | 54236 | Permitted Site 7 | Tree(s) :: 17 | 1278 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9976 | 5995197.96939939 | 2106850.57690326 | 37.7647342420492 | -122.459826454653 | (37.7647342420492, -122.459826454653) | 15 | 5 | 11 | 56 | 12 | |||
| 41941 | 54235 | Permitted Site 7 | Tree(s) :: 17 | 1275 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9975 | 5995145.50027148 | 2106863.31902546 | 37.7647662110387 | -122.460008853529 | (37.7647662110387, -122.460008853529) | 15 | 5 | 11 | 56 | 12 | |||
| 151285 | 54234 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1270 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2010 12:00:00 AM | Permit Number 9974 | 5995196.04681137 | 2106906.46154553 | 37.7648875762272 | -122.459837152742 | (37.7648875762272, -122.459837152742) | 15 | 5 | 11 | 56 | 12 | ||
| 186189 | 54233 | Permitted Site 7 | Tree(s) :: 17 | 1269 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9973 | 5995144.17368572 | 2106901.87942936 | 37.7648720116121 | -122.460016235469 | (37.7648720116121, -122.460016235469) | 15 | 5 | 11 | 56 | 12 | |||
| 26232 | 54232 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.7649425453263 | -122.460021156774 | (37.7649425453263, -122.460021156774) | 15 | 5 | 11 | 56 | 12 | ||
| 89573 | 54230 | Permitted Site 7 | Tree(s) :: 17 | 1263 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9970 | 5995142.84709997 | 2106940.43983326 | 37.764977812183 | -122.46002361743 | (37.764977812183, -122.46002361743) | 15 | 5 | 11 | 56 | 12 | |||
| 139392 | 54228 | Permitted Site 7 | Tree(s) :: 17 | 1236 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9967 | 5995188.02638703 | 2107139.59434987 | 37.7655272371859 | -122.45988178223 | (37.7655272371859, -122.45988178223) | 15 | 5 | 11 | 56 | 12 | |||
| 53753 | 54227 | Permitted Site 7 | Tree(s) :: 17 | 1218 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9966 | 5995184.16942835 | 2107251.70599926 | 37.7658348448517 | -122.459903244465 | (37.7658348448517, -122.459903244465) | 15 | 5 | 11 | 56 | 12 | |||
| 27611 | 54226 | Permitted Site 7 | Tree(s) :: 17 | 1214 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9964 | 5995183.31232643 | 2107276.61969912 | 37.765903202108 | -122.459908013875 | (37.765903202108, -122.459908013875) | 15 | 5 | 11 | 56 | 12 | |||
| 63278 | 54225 | Permitted Site 7 | Tree(s) :: 17 | 1200 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9963 | 5995180.31246968 | 2107363.81764864 | 37.7661424524971 | -122.459924706879 | (37.7661424524971, -122.459924706879) | 15 | 5 | 11 | 29492 | 12 | |||
| 90778 | 54224 | Permitted Site 7 | Tree(s) :: 17 | 1275 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9962 | 5995455.80388001 | 2106874.03814043 | 37.76481348491 | -122.458936377414 | (37.76481348491, -122.458936377414) | 15 | 5 | 11 | 56 | 12 | |||
| 146108 | 54223 | Permitted Site 7 | Tree(s) :: 17 | 1272 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9961 | 5995507.09104626 | 2106895.652617 | 37.7648757806637 | -122.458760554457 | (37.7648757806637, -122.458760554457) | 15 | 5 | 11 | 56 | 12 | |||
| 103828 | 54222 | Permitted Site 7 | Tree(s) :: 17 | 1265 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9960 | 5995453.59170055 | 2106938.34058964 | 37.7649899156402 | -122.458948684825 | (37.7649899156402, -122.458948684825) | 15 | 5 | 11 | 56 | 12 | |||
| 33977 | 54221 | Permitted Site 7 | Tree(s) :: 17 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9959 | 5995452.70682877 | 2106964.06156933 | 37.7650604879304 | -122.458953607806 | (37.7650604879304, -122.458953607806) | 15 | 5 | 11 | 56 | 12 | |||
| 111187 | 54220 | Permitted Site 7 | Tree(s) :: 17 | 1257 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9958 | 5995451.82195698 | 2106989.78254901 | 37.7651310602195 | -122.458958530796 | (37.7651310602195, -122.458958530796) | 15 | 5 | 11 | 56 | 12 | |||
| 123425 | 54218 | Permitted Site 7 | Tree(s) :: 17 | 1219 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9956 | 5995442.51666838 | 2107260.2641065 | 37.7658731976209 | -122.459010301428 | (37.7658731976209, -122.459010301428) | 15 | 5 | 11 | 56 | 12 | |||
| 29763 | 54216 | Permitted Site 7 | Tree(s) :: 17 | 650 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/1972 12:00:00 AM | Permit Number 9954 | 5995030.20332455 | 2106164.63187071 | 37.7628411652133 | -122.460357005 | (37.7628411652133, -122.460357005) | 15 | 5 | 11 | 56 | 12 | |||
| 174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
| 186659 | 54213 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.7640002940645 | -122.465517235123 | (37.7640002940645, -122.465517235123) | 1 | 8 | 11 | 56 | 12 | |||
| 33758 | 101245 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
| 51381 | 101246 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1301X 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
| 142314 | 54212 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | 1 | 8 | 11 | 56 | 12 | |||
| 155295 | 54211 | Permitted Site 7 | Tree(s) :: 17 | 700 Lincoln St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9949 | 5993605.60395035 | 2107361.64964194 | 37.7660458098349 | -122.465371113084 | (37.7660458098349, -122.465371113084) | 11 | 8 | 11 | 29492 | 8 | |||
| 29205 | 54207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 525 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9945 | 5994167.427381 | 2106639.11364061 | 37.7640943000648 | -122.463375455955 | (37.7640943000648, -122.463375455955) | 1 | 5 | 11 | 56 | 12 | |||
| 164223 | 54206 | Permitted Site 7 | Tree(s) :: 17 | 526 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9944 | 5994147.95293559 | 2107032.11537111 | 37.7651722581206 | -122.463471334315 | (37.7651722581206, -122.463471334315) | 11 | 5 | 11 | 56 | 12 | |||
| 133105 | 54205 | Permitted Site 7 | Tree(s) :: 17 | 139 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9943 | 5995354.17926051 | 2107022.12845835 | 37.7652142604002 | -122.45929859343 | (37.7652142604002, -122.45929859343) | 15 | 5 | 11 | 56 | 12 | |||
| 50457 | 54204 | Permitted Site 7 | Tree(s) :: 17 | 131 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | Permit Number 9942 | 5995377.99005235 | 2107022.95842059 | 37.7652179081932 | -122.459216298261 | (37.7652179081932, -122.459216298261) | 15 | 5 | 11 | 56 | 12 | |||
| 30071 | 54203 | Permitted Site 7 | Tree(s) :: 17 | 129 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9941 | 5995383.94275448 | 2107023.1659113 | 37.7652188201332 | -122.459195724453 | (37.7652188201332, -122.459195724453) | 15 | 5 | 11 | 56 | 12 | |||
| 18590 | 210743 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 14 | Width 4ft | Permit Number 9938 | 5995615.49185 | 2107032.26685 | 37.7652571180555 | -122.458395515563 | (37.7652571180555, -122.458395515563) | 15 | 5 | 11 | 56 | 12 | |
| 126916 | 54200 | Permitted Site 7 | Tree(s) :: 17 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9938 | 5995654.85488521 | 2107032.60892369 | 37.7652603192898 | -122.458259393816 | (37.7652603192898, -122.458259393816) | 15 | 5 | 11 | 56 | 12 | |||
| 15190 | 210598 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 16 | Width 4ft | Permit Number 9937 | 5995535.69173 | 2107072.5304 | 37.7653630851686 | -122.458674438482 | (37.7653630851686, -122.458674438482) | 15 | 5 | 11 | 56 | 12 | |
| 155542 | 54199 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||
| 149250 | 54198 | Permitted Site 7 | Tree(s) :: 17 | 30 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9936 | 5995701.15076447 | 2107086.25420453 | 37.7654102755527 | -122.458103151162 | (37.7654102755527, -122.458103151162) | 15 | 5 | 11 | 56 | 12 | |||
| 144722 | 54197 | Permitted Site 7 | Tree(s) :: 17 | 7 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9935 | 5995773.43287988 | 2107036.74210984 | 37.7652784810606 | -122.457849562414 | (37.7652784810606, -122.457849562414) | 15 | 5 | 11 | 56 | 12 | |||
| 118856 | 54196 | Permitted Site 7 | Tree(s) :: 17 | 2400 Washington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9933 | 6003211.73035165 | 2116564.51715591 | 37.7918639049586 | -122.432802970044 | (37.7918639049586, -122.432802970044) | 13 | 9 | 1 | 29490 | 27 | |||
| 19193 | 54195 | Permitted Site 7 | Tree(s) :: 17 | 863 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | Permit Number 9932 | 5983223.98924122 | 2109926.2761241 | 37.7724833470275 | -122.501468187751 | (37.7724833470275, -122.501468187751) | 11 | 6 | 2 | 55 | 26 | |||
| 56272 | 54194 | Permitted Site 7 | Tree(s) :: 17 | 4507 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9931 | 6001090.41996526 | 2104621.18240143 | 37.7589499775483 | -122.439286247947 | (37.7589499775483, -122.439286247947) | 2 | 4 | 5 | 28862 | 38 | |||
| 54223 | 54193 | Permitted Site 7 | Tree(s) :: 17 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9929 | 6004425.95705553 | 2099300.95070846 | 37.7445311111316 | -122.427371396194 | (37.7445311111316, -122.427371396194) | 2 | 7 | 5 | 63 | 22 | |||
| 60718 | 54192 | Permitted Site 7 | Tree(s) :: 17 | 1800 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9928 | 6003970.0714174 | 2114620.22643789 | 37.7865683551319 | -122.430040351032 | (37.7865683551319, -122.430040351032) | 13 | 9 | 11 | 29490 | 27 | |||
| 151934 | 54191 | Permitted Site 7 | Tree(s) :: 17 | 177 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9927 | 6005446.49280939 | 2102690.15694653 | 37.7538947573464 | -122.424083563557 | (37.7538947573464, -122.424083563557) | 2 | 4 | 5 | 28859 | 19 | |||
| 129517 | 54190 | Permitted Site 7 | Tree(s) :: 17 | 81 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9926 | 6005661.0124984 | 2108583.32813962 | 37.7700881256225 | -122.423760699167 | (37.7700881256225, -122.423760699167) | 8 | 2 | 5 | 28853 | 19 | |||
| 43009 | 54186 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1536 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 20 | 3x3 | Permit Number 9921 | 6015571.57326 | 2096517.43556 | 37.7375122082315 | -122.388637501128 | (37.7375122082315, -122.388637501128) | 10 | 3 | 8 | 58 | 1 | |
| 177677 | 54185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) | 10 | 3 | 8 | 58 | 1 | |
| 30586 | 54184 | Permitted Site 7 | Tree(s) :: 17 | 1523 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9919 | 6015575.83102515 | 2096446.47115556 | 37.7373175903777 | -122.388617827683 | (37.7373175903777, -122.388617827683) | 10 | 3 | 8 | 58 | 1 | |||
| 23464 | 54183 | Permitted Site 7 | Tree(s) :: 17 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9918 | 5992252.86810384 | 2102050.91586578 | 37.7513858215434 | -122.469663255825 | (37.7513858215434, -122.469663255825) | 1 | 8 | 4 | 29491 | 12 | |||
| 122576 | 54182 | Permitted Site 7 | Tree(s) :: 17 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9917 | 5992242.56777336 | 2102077.94043422 | 37.7514594286723 | -122.469700842466 | (37.7514594286723, -122.469700842466) | 1 | 8 | 4 | 29491 | 12 | |||
| 173980 | 54181 | Permitted Site 7 | Tree(s) :: 17 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9916 | 5992280.85765043 | 2102123.48503857 | 37.7515866953923 | -122.469571747805 | (37.7515866953923, -122.469571747805) | 1 | 8 | 4 | 29491 | 12 | |||
| 45025 | 54180 | Permitted Site 7 | Tree(s) :: 17 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9915 | 5992281.85082546 | 2102137.9648812 | 37.7516265106914 | -122.469569367285 | (37.7516265106914, -122.469569367285) | 1 | 8 | 4 | 29491 | 12 | |||
| 162281 | 54179 | Permitted Site 7 | Tree(s) :: 17 | 1946 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9914 | 5992286.60814003 | 2102166.49194956 | 37.7517051135809 | -122.469554992473 | (37.7517051135809, -122.469554992473) | 1 | 8 | 4 | 29491 | 12 | |||
| 148993 | 54178 | Permitted Site 7 | Tree(s) :: 17 | 1940 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9913 | 5992293.74410745 | 2102209.28252543 | 37.7518230178364 | -122.469533430211 | (37.7518230178364, -122.469533430211) | 1 | 8 | 4 | 29491 | 12 | |||
| 45978 | 54177 | Permitted Site 7 | Tree(s) :: 17 | 1926 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9912 | 5992278.63670938 | 2102318.40263055 | 37.7521217602474 | -122.469593616061 | (37.7521217602474, -122.469593616061) | 1 | 8 | 4 | 29491 | 12 | |||
| 64226 | 54175 | Permitted Site 7 | Tree(s) :: 17 | 1906 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9910 | 5992259.24604597 | 2102456.89958784 | 37.7525009162667 | -122.469670752945 | (37.7525009162667, -122.469670752945) | 1 | 8 | 4 | 29491 | 12 | |||
| 178257 | 54173 | Permitted Site 7 | Tree(s) :: 17 | 881 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9908 | 6009258.20888465 | 2090119.45963122 | 37.7195928134325 | -122.410014331585 | (37.7195928134325, -122.410014331585) | 9 | 3 | 7 | 309 | 28 | |||
| 80809 | 54172 | Permitted Site 7 | Tree(s) :: 17 | 875 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9907 | 6009250.66071403 | 2090144.34753997 | 37.7196607273878 | -122.410042179052 | (37.7196607273878, -122.410042179052) | 9 | 3 | 7 | 309 | 28 | |||
| 58130 | 54171 | Permitted Site 7 | Tree(s) :: 17 | 863 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9906 | 6009235.5643822 | 2090194.12332646 | 37.7197965551917 | -122.410097874104 | (37.7197965551917, -122.410097874104) | 9 | 3 | 7 | 309 | 28 | |||
| 172839 | 54170 | Permitted Site 7 | Tree(s) :: 17 | 851 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9905 | 6009220.46805037 | 2090243.89911296 | 37.7199323829664 | -122.41015356936 | (37.7199323829664, -122.41015356936) | 9 | 3 | 7 | 309 | 28 | |||
| 56363 | 54168 | Permitted Site 7 | Tree(s) :: 17 | 845 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9903 | 6009212.91988445 | 2090268.7870062 | 37.7200002968427 | -122.410181417064 | (37.7200002968427, -122.410181417064) | 9 | 3 | 7 | 309 | 28 | |||
| 52906 | 54166 | Permitted Site 7 | Tree(s) :: 17 | 838 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9901 | 6009155.60998668 | 2090278.58284714 | 37.7200239816424 | -122.410380209835 | (37.7200239816424, -122.410380209835) | 9 | 3 | 7 | 309 | 28 | |||
| 66585 | 54165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 833 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 17 | Permit Number 9900 | 6009194.94472 | 2090308.57597 | 37.7201085414697 | -122.41024635908 | (37.7201085414697, -122.41024635908) | 9 | 3 | 7 | 309 | 28 | ||
| 16760 | 30450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3030 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 9 | Permit Number 99 | 5999622.18885 | 2116719.4943 | 37.7920851942278 | -122.44523389245 | (37.7920851942278, -122.44523389245) | 13 | 6 | 1 | 29490 | 27 | ||
| 40619 | 54163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 809 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 14 | Permit Number 9898 | 6009163.7285 | 2090404.08715 | 37.7203690453816 | -122.410361003783 | (37.7203690453816, -122.410361003783) | 9 | 3 | 7 | 309 | 28 | ||
| 66005 | 54162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 801 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 13 | Permit Number 9897 | 6009157.09852 | 2090431.14887 | 37.7204429795508 | -122.410385831368 | (37.7204429795508, -122.410385831368) | 9 | 3 | 7 | 309 | 28 | ||
| 84372 | 54161 | Permitted Site 7 | Tree(s) :: 17 | 289 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9896 | 6012957.31958324 | 2095132.98285563 | 37.7335655593608 | -122.397579198697 | (37.7335655593608, -122.397579198697) | 10 | 3 | 8 | 58 | 1 | |||
| 85231 | 54160 | Permitted Site 7 | Tree(s) :: 17 | 285 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1972 12:00:00 AM | Permit Number 9895 | 6012961.37568572 | 2095152.55575624 | 37.7336195283487 | -122.39756654777 | (37.7336195283487, -122.39756654777) | 10 | 3 | 8 | 58 | 1 | |||
| 27746 | 54159 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.83842 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | 10 | 3 | 8 | 58 | 1 | ||
| 54492 | 54158 | Permitted Site 7 | Tree(s) :: 17 | 239 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9893 | 6013008.02089396 | 2095377.6442566 | 37.7342401719727 | -122.397421060698 | (37.7342401719727, -122.397421060698) | 10 | 3 | 8 | 58 | 1 | |||
| 125179 | 54157 | Permitted Site 7 | Tree(s) :: 17 | 229 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9892 | 6013018.16115388 | 2095426.57652604 | 37.7343750944309 | -122.397389432761 | (37.7343750944309, -122.397389432761) | 10 | 3 | 8 | 58 | 1 | |||
| 86796 | 54156 | Permitted Site 7 | Tree(s) :: 17 | 187 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9891 | 6013109.68058036 | 2095642.16455221 | 37.734972149602 | -122.397088129643 | (37.734972149602, -122.397088129643) | 10 | 3 | 8 | 58 | 1 | |||
| 40437 | 54155 | Permitted Site 7 | Tree(s) :: 17 | 115 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9890 | 6013490.97783472 | 2095581.63192956 | 37.7348271583267 | -122.395765600719 | (37.7348271583267, -122.395765600719) | 10 | 3 | 8 | 58 | 1 | |||
| 87090 | 54154 | Permitted Site 7 | Tree(s) :: 17 | 114 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9889 | 6013459.63780597 | 2095630.80184111 | 37.7349604252662 | -122.3958773992 | (37.7349604252662, -122.3958773992) | 10 | 3 | 8 | 58 | 1 | |||
| 25514 | 54153 | Permitted Site 7 | Tree(s) :: 17 | 70 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9888 | 6013800.24074059 | 2095580.63070839 | 37.7348416084767 | -122.394696293612 | (37.7348416084767, -122.394696293612) | 10 | 3 | 8 | 58 | 1 | |||
| 9890 | 54152 | Permitted Site 7 | Tree(s) :: 17 | 62 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9887 | 6013860.72555877 | 2095569.21827622 | 37.7348136349442 | -122.394486376168 | (37.7348136349442, -122.394486376168) | 10 | 3 | 8 | 58 | 1 | |||
| 148767 | 54151 | Permitted Site 7 | Tree(s) :: 17 | 59 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9886 | 6013874.75190505 | 2095512.30353023 | 37.7346581384982 | -122.394433898021 | (37.7346581384982, -122.394433898021) | 10 | 3 | 8 | 58 | 1 | |||
| 25011 | 54150 | Permitted Site 7 | Tree(s) :: 17 | 55 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9885 | 6013898.26264123 | 2095494.80066031 | 37.7346113861595 | -122.394351387742 | (37.7346113861595, -122.394351387742) | 10 | 3 | 8 | 58 | 1 | |||
| 131166 | 54149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | 10 | 3 | 8 | 58 | 1 | ||
| 29331 | 54148 | Permitted Site 7 | Tree(s) :: 17 | 22 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9883 | 6014069.39743863 | 2095324.65039401 | 37.7341536999836 | -122.393747806992 | (37.7341536999836, -122.393747806992) | 10 | 3 | 8 | 58 | 1 | |||
| 120068 | 54147 | Permitted Site 7 | Tree(s) :: 17 | 11 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9882 | 6013981.98431201 | 2095285.15444132 | 37.7340403942352 | -122.394047260019 | (37.7340403942352, -122.394047260019) | 10 | 3 | 8 | 58 | 1 | |||
| 56643 | 54146 | DPW Maintained 1 | Tree(s) :: 17 | 1482 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 0 | Permit Number 9881 | 5984367.42341102 | 2105093.5901914 | 37.7592812470157 | -122.497156203194 | (37.7592812470157, -122.497156203194) | 1 | 8 | 3 | 56 | 35 | ||
| 151922 | 54144 | Permitted Site 7 | Tree(s) :: 17 | 1453 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9879 | 5984308.71127591 | 2105287.8013383 | 37.7598110555117 | -122.497373592535 | (37.7598110555117, -122.497373592535) | 1 | 8 | 3 | 56 | 35 | |||
| 87047 | 54143 | Permitted Site 7 | Tree(s) :: 17 | 1450 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9878 | 5984360.2310056 | 2105302.65582501 | 37.7598548612321 | -122.497196510338 | (37.7598548612321, -122.497196510338) | 1 | 8 | 3 | 56 | 35 | |||
| 151555 | 54140 | Permitted Site 7 | Tree(s) :: 17 | 1418 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9875 | 5984353.03860019 | 2105511.72145863 | 37.7604284753779 | -122.497236818104 | (37.7604284753779, -122.497236818104) | 1 | 8 | 3 | 56 | 35 | |||
| 86872 | 54138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.7949665825052 | -122.437710167809 | (37.7949665825052, -122.437710167809) | 13 | 9 | 1 | 57 | 27 |
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) );