trees
155 rows where qSpecies_id = 12 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
86775 | 67922 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 17 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2016 12:00:00 AM | 3 | Permit Number 776405 | 6003746.91064441 | 2095538.27676938 | 37.7341612413777 | -122.429451123322 | (37.7341612413777, -122.429451123322) | 2 | 7 | 5 | 28861 | 25 | |
54236 | 136738 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011887.11576 | 2118514.31229 | 37.7977057852396 | -122.402923146385 | (37.7977057852396, -122.402923146385) | 3 | 1 | 10 | 308 | 23 | |||
62557 | 136739 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011886.33726 | 2118519.22734 | 37.7977192373121 | -122.402926186096 | (37.7977192373121, -122.402926186096) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
112670 | 52291 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48450 | 6004924.5040582 | 2101031.6740118 | 37.7493114629054 | -122.425770685059 | (37.7493114629054, -122.425770685059) | 2 | 4 | 5 | 28862 | 22 | ||
166843 | 46865 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1114 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 11 | 3x3 | Permit Number 44932 | 6009363.96744 | 2117083.81904 | 37.793636788264 | -122.411552843787 | (37.793636788264, -122.411552843787) | 3 | 1 | 10 | 28857 | 21 |
23049 | 96152 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767787 | 6008219 | 2096805 | 37.7378915730232 | -122.414079234094 | (37.7378915730232, -122.414079234094) | 2 | 7 | 7 | 28859 | 2 | |
142926 | 241167 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008217.59189 | 2096787.94812 | 37.7378446732024 | -122.41408289663 | (37.7378446732024, -122.41408289663) | 2 | 7 | 7 | 28859 | 2 | |||
149175 | 156575 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 201 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781304 | 6006859.44436 | 2096783.37934 | 37.7377557518137 | -122.418778360432 | (37.7377557518137, -122.418778360432) | 2 | 7 | 7 | 28859 | 2 |
174061 | 241170 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 223 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007925.87251 | 2097558.85626 | 37.7399450281481 | -122.415146068833 | (37.7399450281481, -122.415146068833) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
21846 | 83987 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 619 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52667 | 6007916.08016795 | 2104321.00982212 | 37.7585118310793 | -122.415658591374 | (37.7585118310793, -122.415658591374) | 2 | 4 | 7 | 28859 | 19 | ||
21950 | 104740 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | On the 23rd side of property. | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | |||||
53766 | 83269 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.407088935203 | (37.7605882462434, -122.407088935203) | 10 | 4 | 8 | 28859 | 19 | ||
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 | |||
67272 | 241164 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 2720 17th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009338.64709 | 2106411.92088 | 37.7643328604997 | -122.410886372426 | (37.7643328604997, -122.410886372426) | 8 | 4 | 7 | 28859 | 19 | |||
85936 | 91212 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2901 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111 | 2101465 | 37.7506245935345 | -122.41824043827 | (37.7506245935345, -122.41824043827) | 2 | 4 | 7 | 28859 | 19 | ||
91367 | 104739 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | On the 23rd St Side of property | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | ||||
95482 | 84454 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.407088935203 | (37.7605882462434, -122.407088935203) | 10 | 4 | 8 | 28859 | 19 | ||
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 | |||
122098 | 241166 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781891 | 6010275.23752 | 2105021.26338 | 37.7605669026512 | -122.407548899265 | (37.7605669026512, -122.407548899265) | 10 | 4 | 8 | 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 | ||
140446 | 104738 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree on the 23rd St side of property | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | ||||
144433 | 241165 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1358 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009520.35544 | 2101278.61377 | 37.7502481435534 | -122.409895500301 | (37.7502481435534, -122.409895500301) | 2 | 4 | 7 | 28859 | 19 | |||
150053 | 96055 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1358 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767683 | 6009525 | 2101259 | 37.7501945487931 | -122.409878054668 | (37.7501945487931, -122.409878054668) | 2 | 4 | 7 | 28859 | 19 | |
160999 | 91211 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2901 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111 | 2101465 | 37.7506245935345 | -122.41824043827 | (37.7506245935345, -122.41824043827) | 2 | 4 | 7 | 28859 | 19 | |||
184080 | 84157 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 607 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52665 | 6007912.35762405 | 2104388.06639727 | 37.7586957437969 | -122.415676213523 | (37.7586957437969, -122.415676213523) | 2 | 4 | 7 | 28859 | 19 | ||
14109 | 215410 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1955 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993444.94344 | 2102189.18609 | 37.7518343030148 | -122.465550997481 | (37.7518343030148, -122.465550997481) | 1 | 8 | 4 | 29491 | 12 | |||
32676 | 94158 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53537 | 5993734.5 | 2104887.1 | 37.7592587757026 | -122.464745577182 | (37.7592587757026, -122.464745577182) | 1 | 8 | 4 | 56 | 12 | ||
92229 | 215408 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1478 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993690.81703 | 2105468.21978 | 37.7608518609501 | -122.46493885685 | (37.7608518609501, -122.46493885685) | 1 | 8 | 11 | 56 | 12 | |||
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 | |||
131589 | 81524 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1643 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53916 | 5993372.97126564 | 2104303.07947151 | 37.7576343572278 | -122.465953471382 | (37.7576343572278, -122.465953471382) | 1 | 8 | 4 | 56 | 12 | |
1320 | 124050 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992519.13358 | 2110941.9567 | 37.7758136556158 | -122.469389596118 | (37.7758136556158, -122.469389596118) | 11 | 6 | 2 | 54 | 11 | |||
69957 | 112882 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | 5994670.4 | 2110971.2 | 37.7760180351325 | -122.46194999449 | (37.7760180351325, -122.46194999449) | 11 | 6 | 2 | 54 | 11 | ||||
102491 | 123341 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994696.02985 | 2110963.62248 | 37.7759987047787 | -122.461860785147 | (37.7759987047787, -122.461860785147) | 11 | 6 | 2 | 54 | 11 | |||
143196 | 108470 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773783 | 5992531.7071 | 2110944.78333 | 37.7758221433837 | -122.469346307299 | (37.7758221433837, -122.469346307299) | 11 | 6 | 2 | 54 | 11 | |||
177018 | 123142 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 588 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992875.98523 | 2111469.09089 | 37.7772816395031 | -122.468193521633 | (37.7772816395031, -122.468193521633) | 11 | 6 | 2 | 54 | 11 | |||
32669 | 256769 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
48369 | 256770 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
74783 | 256773 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 16 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
107007 | 256771 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 14 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
152433 | 256772 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 15 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
13771 | 15042 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1024 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2008 12:00:00 AM | 3 | 3X3 | 6015618.91517 | 2096257.6222 | 37.7368014371311 | -122.388455686999 | (37.7368014371311, -122.388455686999) | 10 | 3 | 8 | 58 | 1 | ||
80443 | 197975 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1808 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013682.66617 | 2094773.96113 | 37.7326201220065 | -122.395046310152 | (37.7326201220065, -122.395046310152) | 10 | 3 | 8 | 58 | 1 | |||
192727 | 97026 | Property Tree 8 | Tilia cordata :: Littleleaf Linden 12 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
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 | |||||||||||||
4957 | 254245 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 1 | 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 | |||||||||||||
6884 | 259077 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
10107 | 259081 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1001 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
11266 | 259076 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2019 12:00:00 AM | 3 | |||||||||||||
12795 | 259079 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
17788 | 254246 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 |
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) );