trees
155 rows where qSpecies_id = 68 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
151548 | 179164 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 906 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001361.98728 | 2088931.83355 | 37.7158861309088 | -122.43722367146 | (37.7158861309088, -122.43722367146) | 9 | 7 | 6 | 28861 | 5 | |||
151735 | 102286 | Undocumented 4 | Prunus spp :: Cherry 68 | 122 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2014 12:00:00 AM | 26 | 4x4 | Permit Number 772865 | 6000574.8 | 2102350.7 | 37.7526864299915 | -122.440906621345 | (37.7526864299915, -122.440906621345) | 2 | 4 | 5 | 28862 | 22 | |
153560 | 20857 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1892X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
154514 | 109243 | Permitted Site 7 | Prunus spp :: Cherry 68 | 755 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.444002941237 | (37.7683780948237, -122.444002941237) | 15 | 5 | 11 | 29492 | 9 | ||||
154760 | 4161 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 3747 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2001 12:00:00 AM | 3 | 3X3 | 6005530.36537 | 2100484.52073 | 37.7478433240046 | -122.423636704969 | (37.7478433240046, -122.423636704969) | 2 | 4 | 5 | 28859 | 22 | ||
159933 | 183196 | Undocumented 4 | Prunus spp :: Cherry 68 | 2479 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983931.1246 | 2098292.1691 | 37.740580843976 | -122.498162805629 | (37.740580843976, -122.498162805629) | 1 | 8 | 3 | 29491 | 35 | |||
172948 | 51060 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
173341 | 51063 | Permitted Site 7 | Prunus spp :: Cherry 68 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
174186 | 105781 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1631 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 772613 | 6001347.6 | 2111440.1 | 37.7776876665107 | -122.43888545994 | (37.7776876665107, -122.43888545994) | 15 | 5 | 11 | 29492 | 41 | |||
174316 | 50441 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
174947 | 50443 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
175309 | 88559 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 13 | 9 | 1 | 57 | 17 | |||
177866 | 53304 | Permitted Site 7 | Prunus spp :: Cherry 68 | 47 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/1969 12:00:00 AM | 2 | 4x4 | Permit Number 6194 | 6004117.25840717 | 2102785.08371789 | 37.7540802654829 | -122.42868713344 | (37.7540802654829, -122.42868713344) | 2 | 4 | 5 | 28862 | 22 | |
178755 | 141006 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 269 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998171.184 | 2112777.5693 | 37.7811787774786 | -122.449970134459 | (37.7811787774786, -122.449970134459) | 15 | 6 | 2 | 54 | 16 | |||
181735 | 237947 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 923 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008000.76687 | 2102633.77568 | 37.7538838309939 | -122.415246269499 | (37.7538838309939, -122.415246269499) | 2 | 4 | 7 | 28859 | 19 | |||
186129 | 19033 | Permitted Site 7 | Prunus spp :: Cherry 68 | 3192 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 5999542.70067 | 2115392.3027 | 37.7884365373764 | -122.445413449171 | (37.7884365373764, -122.445413449171) | 13 | 6 | 1 | 29490 | 27 | |||
186812 | 234918 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1319 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011166.83162 | 2102201.8831 | 37.7528753762183 | -122.404266824377 | (37.7528753762183, -122.404266824377) | 10 | 4 | 8 | 28859 | 19 | |||
189054 | 19028 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 3176 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 2x2 | 5999568 | 2115477 | 37.7886705381772 | -122.44533201 | (37.7886705381772, -122.44533201) | 13 | 6 | 1 | 29490 | 27 | |||
189473 | 121317 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6007670 | 2102262 | 37.7528444245459 | -122.416363810551 | (37.7528444245459, -122.416363810551) | 2 | 4 | 7 | 28859 | 19 | |||
189823 | 19024 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 3170 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | 13 | 6 | 1 | 29490 | 27 | |||
190581 | 234912 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 266 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006193.38743 | 2096072.09961 | 37.7357652112859 | -122.421030756557 | (37.7357652112859, -122.421030756557) | 2 | 7 | 7 | 28859 | 2 | |||
191467 | 20855 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1892X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
191512 | 40428 | Permitted Site 7 | Prunus spp :: Cherry 68 | 29 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1999 12:00:00 AM | Permit Number 41523 | 6007969.10251409 | 2094049.49213596 | 37.7303115087504 | -122.414748301777 | (37.7303115087504, -122.414748301777) | 9 | 3 | 7 | 309 | 28 | |||
193278 | 50442 | Permitted Site 7 | Prunus spp :: Cherry 68 | 1539 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320979 | (37.7593865436509, -122.47037320979) | 1 | 8 | 4 | 56 | 12 | |||
193280 | 196534 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2221 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011830.1521 | 2101342.38489 | 37.7505524246675 | -122.401912510764 | (37.7505524246675, -122.401912510764) | 10 | 3 | 8 | 28856 | 1 | |||
12108 | 213702 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 714 Detroit St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | 9 | 7 | 4 | 63 | 40 | ||||
55945 | 234919 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 200 Saint Marys Ave | 5 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6003932.02563 | 2095971.19882 | 37.7353604264491 | -122.428841975603 | (37.7353604264491, -122.428841975603) | 2 | 7 | 5 | 63 | 7 | |||
76705 | 196372 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1700 Armstrong Ave | 7 | Side Yard : Yard | Tree | Private 2 | 1 | 6013890.96771 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | 10 | 3 | 8 | 58 | 1 | ||||
85690 | 196063 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1751 22nd St | 9 | Side Yard : Yard | Tree | Private 2 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.398493171445 | (37.757265535503, -122.398493171445) | 10 | 3 | 8 | 28856 | 29 | |||
85722 | 237945 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 99 Aztec St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | 2 | 7 | 7 | 28859 | 2 | ||||
149775 | 196062 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1751 22nd St | 8 | Side Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.7572647746544 | -122.398522052264 | (37.7572647746544, -122.398522052264) | 10 | 3 | 8 | 28856 | 29 | |||
191781 | 196068 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1700 Armstrong Ave | 9 | Side Yard : Yard | Tree | Private 2 | 3 | 6013885.20395 | 2092887.61216 | 37.7274518522042 | -122.394214063144 | (37.7274518522042, -122.394214063144) | 10 | 3 | 8 | 58 | 1 | ||||
160 | 107490 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1306x Montgomery St | 19 | Median : Cutout | Tree | DPW 1 | 12 | 6011447.18476 | 2119974.76336 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | 3 | 1 | 10 | 308 | 23 | ||||
479 | 122586 | Undocumented 4 | Prunus spp :: Cherry 68 | 2500X Lyon St | 6 | Median : Cutout | Tree | Private 2 | 12 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
28549 | 16688 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 600X Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 2 | 5992180.8132004 | 2103552.59538 | 37.7555048781502 | -122.470021758383 | (37.7555048781502, -122.470021758383) | 1 | 8 | 4 | 56 | 12 | |||
43975 | 122579 | Undocumented 4 | Prunus spp :: Cherry 68 | 2500X Lyon St | 1 | Median : Cutout | Tree | Private 2 | 30 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
82413 | 29657 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 299X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6016930.34883 | 2095863.99444 | 37.7357931999838 | -122.383894041377 | (37.7357931999838, -122.383894041377) | 10 | 3 | 8 | 58 | 1 | ||
164522 | 199890 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1200x Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6017354.2822 | 2093058.6837 | 37.7281137963921 | -122.382233221943 | (37.7281137963921, -122.382233221943) | 10 | 3 | 8 | 58 | 1 | |||
167001 | 11193 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 162 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995521.0890831 | 2099407.054304 | 37.7443147925186 | -122.458170108957 | (37.7443147925186, -122.458170108957) | 1 | 8 | 4 | 59 | 40 | |||
1082 | 261856 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 937x Meade Ave | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
1810 | 253859 | Planning Code 138.1 required 2 | Prunus spp :: Cherry 68 | 130 Graystone Ter | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | Permit Number 780749 | 5998952.88335 | 2104176.47413 | 37.7576070480405 | -122.446646826709 | (37.7576070480405, -122.446646826709) | 2 | 5 | 5 | 28862 | 3 | |||
4637 | 247987 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 124 Mullen Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6009857.2555 | 2099808.73815 | 37.7462310644209 | -122.408626794296 | (37.7462310644209, -122.408626794296) | 2 | 7 | 7 | 28859 | 2 | ||||
57739 | 247592 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 800 Tompkins Ave | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 6008994.80779 | 2096446.35961 | 37.7369503684581 | -122.411371547678 | (37.7369503684581, -122.411371547678) | 10 | 7 | 7 | 28859 | 2 | ||||
58981 | 196335 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1900 19th St | 10 | Front Yard : Yard | Tree | Private 2 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) | 10 | 3 | 8 | 28856 | 29 | ||||
65912 | 196067 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2338 Lane St | 2 | Front Yard : Yard | Tree | Private 2 | 2 | Width 5ft | 6013920.54146 | 2092873.26714 | 37.7274144278184 | -122.394090896496 | (37.7274144278184, -122.394090896496) | 10 | 3 | 8 | 58 | 1 | |||
107251 | 238534 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 671 Church St | 39 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004315.93981 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | 2 | 4 | 5 | 28862 | 3 | |||
130764 | 249657 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2401 Lyon St | 9 | Front Yard : Yard | Tree | Private 2 | 5 | Width 10ft | 5999220.85646 | 2117228.07126 | 37.7934586955217 | -122.446659110123 | (37.7934586955217, -122.446659110123) | 11 | 1 | 57 | 30 | ||||
166835 | 196065 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 602 Arthur Ave | 28 | Front Yard : Yard | Tree | Private 2 | 3 | 6015745.27894 | 2099859.59173 | 37.7466987082831 | -122.388270101098 | (37.7466987082831, -122.388270101098) | 3 | 8 | 58 | 1 | |||||
168750 | 116071 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 4150X CLEMENT ST | 1 | Front Yard : Yard | Tree | DPW 1 | 8 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||
190691 | 196373 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1900 19th St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6012066.64129 | 2105141.25616 | 37.760996487211 | -122.401361645431 | (37.760996487211, -122.401361645431) | 10 | 3 | 8 | 28856 | 29 | ||||
191979 | 196066 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 602 Arthur Ave | 29 | Front Yard : Yard | Tree | Private 2 | 3 | 6015729.65904 | 2099863.28866 | 37.7467079937826 | -122.38832437159 | (37.7467079937826, -122.38832437159) | 3 | 8 | 58 | 1 | |||||
83211 | 93959 | Permitted Site 7 | Prunus spp :: Cherry 68 | 419 Elizabeth St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 53399 | 6003681 | 2102149 | 37.7523090296265 | -122.430150445418 | (37.7523090296265, -122.430150445418) | 2 | 4 | 5 | 28862 | 22 | ||||
40074 | 238536 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1 Penny Ln | 4 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002355.47862 | 2096490.80035 | 37.736697774076 | -122.434329814067 | (37.736697774076, -122.434329814067) | 2 | 7 | 5 | 63 | 7 | |||
55073 | 213701 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 700 Junipero Serra Blvd | 130 | : | Tree | Private 2 | 8 | Width 0ft | 5991210.94255 | 2091714.66662 | 37.7229448341183 | -122.472512833822 | (37.7229448341183, -122.472512833822) | 9 | 8 | 4 | 64 | 40 | |||
129139 | 196536 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1422 Rhode Island St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6011983.19537 | 2101729.68858 | 37.7516244165498 | -122.401410487604 | (37.7516244165498, -122.401410487604) | 10 | 3 | 8 | 28856 | 29 |
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) );