trees
155 rows where qSpecies_id = 12 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115101 | 241168 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3387 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007165.54985 | 2101454.26646 | 37.7505981920648 | -122.418051039151 | (37.7505981920648, -122.418051039151) | 2 | 4 | 7 | 28859 | 19 | |||
123127 | 34776 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1148 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 4x4 | Permit Number 38417 | 6008035.00461404 | 2101235.83901924 | 37.7500473368591 | -122.415028926905 | (37.7500473368591, -122.415028926905) | 2 | 4 | 7 | 28859 | 19 | ||
126102 | 197948 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015157.51241 | 2114808.67556 | 37.7877130375663 | -122.391347405751 | (37.7877130375663, -122.391347405751) | 6 | 2 | 9 | 28855 | 6 | |||
130472 | 197923 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013948.03305 | 2115996.75839 | 37.7909080374275 | -122.395615276145 | (37.7909080374275, -122.395615276145) | 12 | 2 | 9 | 28855 | 6 | ||
140184 | 255996 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 276 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6014937.43234 | 2115453.8839 | 37.7894724145659 | -122.392153987042 | (37.7894724145659, -122.392153987042) | 6 | 2 | 9 | 28855 | 6 | ||||
191478 | 197936 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 220 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014628.26894 | 2115262.57971 | 37.7889299668815 | -122.393210274953 | (37.7889299668815, -122.393210274953) | 6 | 2 | 9 | 28855 | 6 | |||
3511 | 254247 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 | |||||||||||||
6150 | 259078 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
28889 | 197972 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011477.0733 | 2113572.89989 | 37.7841149391088 | -122.403994090559 | (37.7841149391088, -122.403994090559) | 12 | 2 | 9 | 28853 | 34 | |||
37623 | 241174 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 315 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 778328 | 6003586.53553 | 2106468.03188 | 37.7641627114691 | -122.430785309798 | (37.7641627114691, -122.430785309798) | 8 | 4 | 5 | 28862 | 3 | ||
39209 | 197933 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014535.65426 | 2115358.35954 | 37.7891878106184 | -122.393537417717 | (37.7891878106184, -122.393537417717) | 6 | 2 | 9 | 28855 | 6 | |||
42209 | 112149 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
43435 | 197956 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014936.72139 | 2115049.06267 | 37.7883608291328 | -122.392128124328 | (37.7883608291328, -122.392128124328) | 6 | 2 | 9 | 28855 | 6 | |||
45536 | 50054 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 646 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51273 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | ||
100470 | 121527 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
106319 | 197974 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 248 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010760.66114 | 2111705.859 | 37.7789484310553 | -122.406341036019 | (37.7789484310553, -122.406341036019) | 14 | 2 | 9 | 28853 | 34 | |||
123910 | 197949 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015139.49005 | 2114827.68285 | 37.7877642269846 | -122.391411089446 | (37.7877642269846, -122.391411089446) | 6 | 2 | 9 | 28855 | 6 | |||
125287 | 197927 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014884.10651 | 2115509.17799 | 37.7896212784354 | -122.392342359022 | (37.7896212784354, -122.392342359022) | 6 | 2 | 9 | 28855 | 6 | |||
130425 | 197965 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 542 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013312.52382 | 2111204.97894 | 37.7777155477834 | -122.397477924066 | (37.7777155477834, -122.397477924066) | 6 | 2 | 9 | 28856 | 34 | |||
144647 | 197937 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 220 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014670.19606 | 2115221.91526 | 37.7888206408102 | -122.393062365246 | (37.7888206408102, -122.393062365246) | 6 | 2 | 9 | 28855 | 6 | |||
154232 | 197924 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013969.61875 | 2115974.72965 | 37.7908487523134 | -122.395539045996 | (37.7908487523134, -122.395539045996) | 12 | 2 | 9 | 28855 | 6 | ||
158604 | 197941 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015395.33914 | 2115073.46848 | 37.7884532947311 | -122.390543073727 | (37.7884532947311, -122.390543073727) | 6 | 2 | 9 | 28855 | 6 | |||
184350 | 197968 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010849.47884 | 2113039.65001 | 37.7826156766079 | -122.406127771681 | (37.7826156766079, -122.406127771681) | 12 | 2 | 9 | 28853 | 34 | |||
194150 | 121524 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 280 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
12795 | 259079 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
20157 | 121528 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
28759 | 197973 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011498.91524 | 2113552.62708 | 37.7840604950255 | -122.403917097798 | (37.7840604950255, -122.403917097798) | 12 | 2 | 9 | 28853 | 34 | |||
38450 | 197928 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014902.20963 | 2115489.69757 | 37.7895687949157 | -122.392278360564 | (37.7895687949157, -122.392278360564) | 6 | 2 | 9 | 28855 | 6 | |||
44644 | 197934 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014577.15457 | 2115321.46001 | 37.7890887988504 | -122.393391247314 | (37.7890887988504, -122.393391247314) | 6 | 2 | 9 | 28855 | 6 | |||
46324 | 112150 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
56111 | 197942 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015382.55256 | 2115087.30392 | 37.7884905743282 | -122.390588280823 | (37.7884905743282, -122.390588280823) | 6 | 2 | 9 | 28855 | 6 | |||
111850 | 197969 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010835.00932 | 2113053.67977 | 37.7826533896919 | -122.406178819023 | (37.7826533896919, -122.406178819023) | 12 | 2 | 9 | 28853 | 34 | |||
121522 | 197957 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014920.6101 | 2115062.64622 | 37.7883972318904 | -122.392184817599 | (37.7883972318904, -122.392184817599) | 6 | 2 | 9 | 28855 | 6 | |||
187036 | 197950 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.06913 | 2114845.42683 | 37.78781198099 | -122.39147260399 | (37.78781198099, -122.39147260399) | 6 | 2 | 9 | 28855 | 6 | |||
190403 | 197938 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 220 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014691.15207 | 2115201.2077 | 37.7887649467015 | -122.392988410406 | (37.7887649467015, -122.392988410406) | 6 | 2 | 9 | 28855 | 6 | |||
42435 | 197929 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014918.25453 | 2115471.99632 | 37.7895210822691 | -122.392221607957 | (37.7895210822691, -122.392221607957) | 6 | 2 | 9 | 28855 | 6 | |||
58032 | 241175 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3387 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007208.84788 | 2101457.68369 | 37.7506100118607 | -122.417901552934 | (37.7506100118607, -122.417901552934) | 2 | 4 | 7 | 28859 | 19 | |||
132212 | 197951 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015100.083 | 2114872.3871 | 37.7878847873904 | -122.391550558114 | (37.7878847873904, -122.391550558114) | 6 | 2 | 9 | 28855 | 6 | |||
141989 | 197943 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015369.55372 | 2115100.01237 | 37.7885247476754 | -122.390634143574 | (37.7885247476754, -122.390634143574) | 6 | 2 | 9 | 28855 | 6 | |||
153468 | 197958 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014908.62801 | 2115077.84616 | 37.7884383021313 | -122.392227337523 | (37.7884383021313, -122.392227337523) | 6 | 2 | 9 | 28855 | 6 | |||
184275 | 121529 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
11832 | 197944 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015356.38098 | 2115113.47831 | 37.7885609912507 | -122.390680660994 | (37.7885609912507, -122.390680660994) | 6 | 2 | 9 | 28855 | 6 | |||
77617 | 197959 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014895.93588 | 2115091.70056 | 37.7884756383871 | -122.392272219997 | (37.7884756383871, -122.392272219997) | 6 | 2 | 9 | 28855 | 6 | |||
126569 | 197952 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015071.96178 | 2114899.8114 | 37.7879585273121 | -122.391649771325 | (37.7879585273121, -122.391649771325) | 6 | 2 | 9 | 28855 | 6 | |||
170258 | 121530 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
52894 | 121531 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
80481 | 197953 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015054.91567 | 2114917.83312 | 37.7880070646074 | -122.391710008824 | (37.7880070646074, -122.391710008824) | 6 | 2 | 9 | 28855 | 6 | |||
113100 | 197945 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015345.08989 | 2115126.34059 | 37.7885956816912 | -122.390720625978 | (37.7885956816912, -122.390720625978) | 6 | 2 | 9 | 28855 | 6 | |||
137275 | 197960 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014878.139 | 2115106.33815 | 37.7885148416282 | -122.392334819105 | (37.7885148416282, -122.392334819105) | 6 | 2 | 9 | 28855 | 6 | |||
52544 | 197961 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014857.78399 | 2115129.52624 | 37.7885773804879 | -122.392406867389 | (37.7885773804879, -122.392406867389) | 6 | 2 | 9 | 28855 | 6 | |||
125340 | 197946 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015324.49804 | 2115147.49947 | 37.78865263665 | -122.390793350551 | (37.78865263665, -122.390793350551) | 6 | 2 | 9 | 28855 | 6 | |||
152599 | 121532 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
88352 | 197962 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014844.47808 | 2115146.79251 | 37.7886240508001 | -122.392454112385 | (37.7886240508001, -122.392454112385) | 6 | 2 | 9 | 28855 | 6 | |||
103030 | 121533 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 |
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) );