trees
155 rows where qSpecies_id = 12 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174934 | 155501 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 175 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781267 | 5994415.96169 | 2098613.76746 | 37.7420730624341 | -122.461933863951 | (37.7420730624341, -122.461933863951) | 1 | 8 | 4 | 59 | 40 |
180437 | 241173 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 344 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003615.63748 | 2108670.28544 | 37.7702112142959 | -122.430841829505 | (37.7702112142959, -122.430841829505) | 15 | 9 | 11 | 29492 | 10 | |||
182009 | 243820 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 129 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781316 | 6007254.97464 | 2100142.23654 | 37.747000687137 | -122.417648817364 | (37.747000687137, -122.417648817364) | 2 | 7 | 7 | 28859 | 2 |
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 | |||
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 | |||
24409 | 246997 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004899.11495 | 2101036.5235 | 37.7493233437145 | -122.425858826318 | (37.7493233437145, -122.425858826318) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
87448 | 197940 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015409.43942 | 2115059.04086 | 37.7884144620023 | -122.39049328005 | (37.7884144620023, -122.39049328005) | 6 | 2 | 9 | 28855 | 6 | |||
100647 | 197939 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015423.89897 | 2115043.66303 | 37.7883730401228 | -122.390442176979 | (37.7883730401228, -122.390442176979) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
13327 | 197932 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6014511.51685 | 2115383.38885 | 37.7892551941278 | -122.393622683336 | (37.7892551941278, -122.393622683336) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
38525 | 197926 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014867.69164 | 2115525.84421 | 37.7896661285247 | -122.392400319429 | (37.7896661285247, -122.392400319429) | 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 | |||
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 | |||
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 | |||
63000 | 197955 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014952.39535 | 2115030.72864 | 37.7883113583401 | -122.392072611873 | (37.7883113583401, -122.392072611873) | 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 | |||
78617 | 120014 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 359 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5986817.89176 | 2113535.36693 | 37.7826033030644 | -122.489302099137 | (37.7826033030644, -122.489302099137) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
103456 | 121525 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | |||
115896 | 197931 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6014498.28246 | 2115400.43441 | 37.7893012619026 | -122.393669666621 | (37.7893012619026, -122.393669666621) | 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 | |||
132182 | 31880 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 357 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35318 | 5986819.04944 | 2113546.00987 | 37.7826325931106 | -122.489298876891 | (37.7826325931106, -122.489298876891) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
150389 | 197935 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 220 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6014614.74747 | 2115277.87841 | 37.7889712224 | -122.393258128754 | (37.7889712224, -122.393258128754) | 6 | 2 | 9 | 28855 | 6 | |||
33696 | 49458 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013268.6937 | 2111162.24572 | 37.7775957715643 | -122.397626550549 | (37.7775957715643, -122.397626550549) | 6 | 2 | 9 | 28856 | 34 | |
37313 | 49455 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013246.33649 | 2111139.83952 | 37.7775330042846 | -122.39770232023 | (37.7775330042846, -122.39770232023) | 6 | 2 | 9 | 28856 | 34 | |
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 | |||
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 | |||
46251 | 197930 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 276 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014937.43234 | 2115453.8839 | 37.7894724145659 | -122.392153987042 | (37.7894724145659, -122.392153987042) | 6 | 2 | 9 | 28855 | 6 | |||
77213 | 59528 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 286 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/1981 12:00:00 AM | 6 | 3x3 | Permit Number 18910 | 6010887.1653 | 2111573.26099 | 37.7785914236007 | -122.405894062179 | (37.7785914236007, -122.405894062179) | 14 | 2 | 9 | 28853 | 34 | |
86809 | 250931 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 263 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5987106.46019 | 2114196.92222 | 37.7844365852323 | -122.488352423026 | (37.7844365852323, -122.488352423026) | 11 | 6 | 1 | 55 | 33 | |||
124406 | 197925 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014850.28645 | 2115545.31088 | 37.7897186129805 | -122.392461902306 | (37.7897186129805, -122.392461902306) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
165547 | 197954 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014967.3458 | 2115010.36938 | 37.7882562865359 | -122.392019461055 | (37.7882562865359, -122.392019461055) | 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 | |||
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 | |||
5568 | 250930 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 263 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987104.77973 | 2114208.46331 | 37.7844681757127 | -122.488359085215 | (37.7844681757127, -122.488359085215) | 11 | 6 | 1 | 55 | 33 | |||
42591 | 197967 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010879.01966 | 2113009.66156 | 37.7825349876424 | -122.406023459311 | (37.7825349876424, -122.406023459311) | 12 | 2 | 9 | 28853 | 34 | |||
66782 | 197966 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010894.68049 | 2112991.13579 | 37.7824849961321 | -122.405967973868 | (37.7824849961321, -122.405967973868) | 12 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
190151 | 47913 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1025 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 7 | Permit Number 45650 | 6001905.584 | 2112009.098 | 37.7792817219988 | -122.436995952461 | (37.7792817219988, -122.436995952461) | 15 | 5 | 11 | 29490 | 41 | |
87777 | 104163 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 2127 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 76 | 4x3 | Permit Number 770670 | 5992542 | 2100965 | 37.7484208831153 | -122.468584409749 | (37.7484208831153, -122.468584409749) | 1 | 8 | 4 | 29491 | 40 | ||
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 | |||
105784 | 215409 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993712.25346 | 2104885.19549 | 37.7592522638043 | -122.464822377549 | (37.7592522638043, -122.464822377549) | 1 | 8 | 4 | 56 | 12 | |||
107947 | 28499 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 270 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010842.7805 | 2111615.69591 | 37.7787054576155 | -122.406050597275 | (37.7787054576155, -122.406050597275) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
40312 | 197971 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011459.89889 | 2113592.30017 | 37.7841672481653 | -122.404054873931 | (37.7841672481653, -122.404054873931) | 12 | 2 | 9 | 28853 | 34 |
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) );