trees
1,914 rows where qSpecies_id = 45
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
119 | 184195 | DPW Maintained 1 | :: 45 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690204 | (37.759713770345, -122.49627690204) | 1 | 8 | 3 | 56 | 35 | |||
120 | 141225 | DPW Maintained 1 | :: 45 | 3 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5996479.075 | 2114520.1031 | 37.7858663452689 | -122.455949967769 | (37.7858663452689, -122.455949967769) | 11 | 6 | 1 | 54 | 31 | |||
132 | 182257 | DPW Maintained 1 | :: 45 | 1439 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985240.365 | 2105399.9729 | 37.7601736080068 | -122.494159774452 | (37.7601736080068, -122.494159774452) | 1 | 8 | 3 | 56 | 35 | |||
141 | 254165 | DPW Maintained 1 | :: 45 | 579 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983759 | 2111886 | 37.7778955894485 | -122.499762435435 | (37.7778955894485, -122.499762435435) | 11 | 6 | 2 | 55 | 26 | ||||
142 | 186181 | DPW Maintained 1 | :: 45 | 1700 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984741.0761 | 2103142.2522 | 37.75394530503 | -122.495720014116 | (37.75394530503, -122.495720014116) | 1 | 8 | 3 | 56 | 35 | |||
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
155 | 142339 | DPW Maintained 1 | :: 45 | 516 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999737.6235 | 2110265.9409 | 37.7743719952599 | -122.444370497086 | (37.7743719952599, -122.444370497086) | 15 | 5 | 11 | 29492 | 16 | |||
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
175 | 184150 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.7571490682193 | -122.503626084685 | (37.7571490682193, -122.503626084685) | 1 | 8 | 3 | 56 | 35 | |||
179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
185 | 184541 | DPW Maintained 1 | :: 45 | 1706 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984416.199 | 2103539.5001 | 37.7550170068332 | -122.496872815694 | (37.7550170068332, -122.496872815694) | 1 | 8 | 3 | 56 | 35 | |||
192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
212 | 138278 | DPW Maintained 1 | :: 45 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.7844923181381 | -122.437714255164 | (37.7844923181381, -122.437714255164) | 13 | 6 | 11 | 29490 | 13 | |||
214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
218 | 181787 | DPW Maintained 1 | :: 45 | 2915 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986983.636 | 2098224.4165 | 37.740573320949 | -122.487603561386 | (37.740573320949, -122.487603561386) | 1 | 8 | 3 | 29491 | 35 | |||
221 | 182334 | DPW Maintained 1 | :: 45 | 1507 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985257.4301 | 2104914.9526 | 37.758842875608 | -122.494065007935 | (37.758842875608, -122.494065007935) | 1 | 8 | 3 | 56 | 35 | |||
224 | 183657 | DPW Maintained 1 | :: 45 | 1490 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981573.7378 | 2104946.7308 | 37.7587138957913 | -122.506807059304 | (37.7587138957913, -122.506807059304) | 1 | 8 | 3 | 56 | 35 | |||
229 | 121402 | Undocumented 4 | :: 45 | 346X Duncan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6004011 | 2099874 | 37.7460810947058 | -122.428847079389 | (37.7460810947058, -122.428847079389) | 2 | 7 | 5 | 63 | 22 | ||||
232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
234 | 183167 | DPW Maintained 1 | :: 45 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.7413295619026 | -122.503441142831 | (37.7413295619026, -122.503441142831) | 1 | 8 | 3 | 29491 | 35 | |||
235 | 184469 | DPW Maintained 1 | :: 45 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.7457660664858 | -122.506976375045 | (37.7457660664858, -122.506976375045) | 1 | 8 | 3 | 29491 | 35 | |||
242 | 184584 | DPW Maintained 1 | :: 45 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | 1 | 8 | 3 | 56 | 35 | |||
244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
258 | 139105 | DPW Maintained 1 | :: 45 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.7829154028675 | -122.444405875371 | (37.7829154028675, -122.444405875371) | 15 | 6 | 1 | 29490 | 31 | |||
262 | 141330 | DPW Maintained 1 | :: 45 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | 15 | 5 | 11 | 29492 | 10 | |||
268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
270 | 182815 | DPW Maintained 1 | :: 45 | 2111 Noriega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987460.7639 | 2102999.1421 | 37.7537112584365 | -122.486304306666 | (37.7537112584365, -122.486304306666) | 1 | 8 | 3 | 56 | 35 | |||
276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
279 | 182423 | DPW Maintained 1 | :: 45 | 1539 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988365.4024 | 2104835.4768 | 37.7588060244513 | -122.483310502266 | (37.7588060244513, -122.483310502266) | 1 | 8 | 3 | 56 | 35 | |||
295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
296 | 185842 | DPW Maintained 1 | :: 45 | 2000 35th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985421.3197 | 2101412.6246 | 37.7492360339251 | -122.493240190301 | (37.7492360339251, -122.493240190301) | 1 | 8 | 3 | 29491 | 35 | |||
299 | 116945 | Undocumented 4 | :: 45 | 3676 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
302 | 184152 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | 1 | 8 | 3 | 56 | 35 | |||
314 | 184219 | DPW Maintained 1 | :: 45 | 3439 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984114.8945 | 2104934.4274 | 37.7588294281219 | -122.498017803137 | (37.7588294281219, -122.498017803137) | 1 | 8 | 3 | 56 | 35 | |||
316 | 245380 | DPW Maintained 1 | :: 45 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | 2 | 7 | 5 | 28859 | 2 | |||
320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
327 | 182422 | DPW Maintained 1 | :: 45 | 1534 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987477.4649 | 2104817.3887 | 37.7587046434176 | -122.486380033207 | (37.7587046434176, -122.486380033207) | 1 | 8 | 3 | 56 | 35 | |||
351 | 182685 | DPW Maintained 1 | :: 45 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | 1 | 8 | 3 | 56 | 35 | |||
354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
360 | 181895 | DPW Maintained 1 | :: 45 | 2366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986431.1624 | 2099136.6325 | 37.7430457847891 | -122.489580839702 | (37.7430457847891, -122.489580839702) | 1 | 8 | 3 | 29491 | 35 | |||
365 | 184621 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.7533372599652 | -122.496976365214 | (37.7533372599652, -122.496976365214) | 1 | 8 | 3 | 56 | 35 | |||
367 | 183862 | DPW Maintained 1 | :: 45 | 2239 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986357.5018 | 2099996.4101 | 37.7454022028518 | -122.489898755555 | (37.7454022028518, -122.489898755555) | 1 | 8 | 3 | 29491 | 35 | |||
370 | 183768 | DPW Maintained 1 | :: 45 | 2295 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987606.9921 | 2099698.5467 | 37.744657229257 | -122.485556419265 | (37.744657229257, -122.485556419265) | 1 | 8 | 3 | 29491 | 35 | |||
373 | 200940 | DPW Maintained 1 | :: 45 | 1515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008432.2434 | 2109068.8895 | 37.7715774111529 | -122.414209373869 | (37.7715774111529, -122.414209373869) | 8 | 2 | 9 | 28853 | 19 | |||
375 | 115067 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
377 | 142111 | DPW Maintained 1 | :: 45 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | 15 | 6 | 2 | 29492 | 16 | |||
378 | 182780 | DPW Maintained 1 | :: 45 | 1743 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985620.0055 | 2103342.2275 | 37.7545458149545 | -122.492695239531 | (37.7545458149545, -122.492695239531) | 1 | 8 | 3 | 56 | 35 | |||
380 | 116339 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
396 | 182481 | DPW Maintained 1 | :: 45 | 1556 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985002.9582 | 2104611.8375 | 37.7579957124827 | -122.494922727233 | (37.7579957124827, -122.494922727233) | 1 | 8 | 3 | 56 | 35 | |||
397 | 253904 | DPW Maintained 1 | :: 45 | 3637 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997456 | 2115038 | 37.7873443747179 | -122.4526074861 | (37.7873443747179, -122.4526074861) | 11 | 6 | 1 | 54 | 31 | ||||
401 | 183745 | DPW Maintained 1 | :: 45 | 2267 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986363.4761 | 2099812.4858 | 37.7448975449574 | -122.489864573201 | (37.7448975449574, -122.489864573201) | 1 | 8 | 3 | 29491 | 35 | |||
402 | 183817 | DPW Maintained 1 | :: 45 | 2133 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986490.2175 | 2100252.0265 | 37.7461118053863 | -122.489458644673 | (37.7461118053863, -122.489458644673) | 1 | 8 | 3 | 29491 | 35 | |||
404 | 182349 | DPW Maintained 1 | :: 45 | 3125 Kirkham St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985217.5678 | 2104973.2387 | 37.759000580496 | -122.494207164319 | (37.759000580496, -122.494207164319) | 1 | 8 | 3 | 56 | 35 | |||
410 | 183338 | DPW Maintained 1 | :: 45 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.509312865514 | (37.7637711641625, -122.509312865514) | 1 | 8 | 3 | 56 | 35 | |||
423 | 140125 | DPW Maintained 1 | :: 45 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.439251726799 | (37.7816688523257, -122.439251726799) | 15 | 5 | 11 | 29490 | 41 | |||
426 | 183962 | DPW Maintained 1 | :: 45 | 2158 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989481.017 | 2100669.218 | 37.7474314478739 | -122.479147472521 | (37.7474314478739, -122.479147472521) | 1 | 8 | 3 | 29491 | 35 | |||
427 | 114621 | Undocumented 4 | :: 45 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
446 | 182929 | DPW Maintained 1 | :: 45 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.73729554361 | -122.505454091008 | (37.73729554361, -122.505454091008) | 1 | 8 | 3 | 29491 | 35 | |||
452 | 182004 | DPW Maintained 1 | :: 45 | 3220 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986004.751 | 2098249.2905 | 37.7405844772428 | -122.490989950641 | (37.7405844772428, -122.490989950641) | 1 | 8 | 3 | 29491 | 35 | |||
460 | 182240 | DPW Maintained 1 | :: 45 | 1427 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985548.7085 | 2105482.2958 | 37.7604176820805 | -122.49309944026 | (37.7604176820805, -122.49309944026) | 1 | 8 | 3 | 56 | 35 | |||
466 | 116275 | Undocumented 4 | :: 45 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
468 | 121614 | Undocumented 4 | :: 45 | 800X Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001168 | 2102650 | 37.7535420028484 | -122.438876681597 | (37.7535420028484, -122.438876681597) | 2 | 4 | 5 | 28862 | 22 | ||||
484 | 182121 | DPW Maintained 1 | :: 45 | 2516 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988187.7408 | 2098326.2815 | 37.7409231701359 | -122.483447748483 | (37.7409231701359, -122.483447748483) | 1 | 8 | 3 | 29491 | 35 | |||
519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
534 | 183705 | Undocumented 4 | :: 45 | 3628 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983226.2116 | 2105643.5823 | 37.7607244242532 | -122.501143681764 | (37.7607244242532, -122.501143681764) | 1 | 8 | 3 | 56 | 35 | |||
570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
610 | 182578 | DPW Maintained 1 | :: 45 | 2451 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988885.5665 | 2098636.2758 | 37.7418149236633 | -122.481057645938 | (37.7418149236633, -122.481057645938) | 1 | 8 | 3 | 29491 | 35 | |||
644 | 182239 | DPW Maintained 1 | :: 45 | 1434 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985592.8101 | 2105449.5872 | 37.7603304525285 | -122.492944506053 | (37.7603304525285, -122.492944506053) | 1 | 8 | 3 | 56 | 35 | |||
740 | 105361 | Permitted Site 7 | :: 45 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
758 | 228462 | DPW Maintained 1 | :: 45 | 227 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.7683047783783 | -122.418472926402 | (37.7683047783783, -122.418472926402) | 8 | 4 | 7 | 28853 | 19 | |||
771 | 182161 | DPW Maintained 1 | :: 45 | 1634 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989670.2283 | 2104207.7015 | 37.757158173162 | -122.478751948653 | (37.757158173162, -122.478751948653) | 1 | 8 | 3 | 56 | 35 | |||
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
905 | 181988 | DPW Maintained 1 | :: 45 | 2838 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987152.1701 | 2098289.7319 | 37.740762487887 | -122.487025638785 | (37.740762487887, -122.487025638785) | 1 | 8 | 3 | 29491 | 35 | |||
956 | 183992 | DPW Maintained 1 | :: 45 | 1686 35th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985337.681 | 2103759.2633 | 37.7556743678806 | -122.493702306752 | (37.7556743678806, -122.493702306752) | 1 | 8 | 3 | 56 | 35 | |||
1022 | 182384 | DPW Maintained 1 | :: 45 | 1539 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985884.4808 | 2104746.0177 | 37.7584156979157 | -122.49188396911 | (37.7584156979157, -122.49188396911) | 1 | 8 | 3 | 56 | 35 | |||
1289 | 190652 | DPW Maintained 1 | :: 45 | 310 Arkansas St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.398528520183 | (37.7621425904374, -122.398528520183) | 10 | 3 | 8 | 28856 | 29 | |||
1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
1482 | 29956 | DPW Maintained 1 | :: 45 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.432282489737 | (37.7719405092432, -122.432282489737) | 15 | 5 | 11 | 29492 | 9 | ||
1503 | 33210 | Permitted Site 7 | :: 45 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.7446507048802 | -122.454762009134 | (37.7446507048802, -122.454762009134) | 1 | 5 | 4 | 59 | 40 |
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) );