trees
3,965 rows where qSpecies_id = 70 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58373 | 203679 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1459 15th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5991452.55697 | 2105482.734 | 37.7607624035742 | -122.472680990851 | (37.7607624035742, -122.472680990851) | 1 | 8 | 4 | 56 | 12 | |||
59113 | 124973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2815 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999464.00903 | 2118379.34034 | 37.796633661183 | -122.445900626411 | (37.796633661183, -122.445900626411) | 13 | 9 | 1 | 57 | 17 | |||
59228 | 184858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984642.9852 | 2106842.6618 | 37.7640998526008 | -122.49633224767 | (37.7640998526008, -122.49633224767) | 1 | 8 | 3 | 56 | 35 | |||
59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
62189 | 124823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Cervantes Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6000834.31444 | 2121522.83872 | 37.8053430214345 | -122.441384750901 | (37.8053430214345, -122.441384750901) | 13 | 9 | 1 | 57 | 17 | |||
62455 | 187749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6018386.68976 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | 10 | 3 | 8 | 58 | 1 | ||||
63360 | 203898 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5990605.80648 | 2090479.00693 | 37.7195169745995 | -122.474514509734 | (37.7195169745995, -122.474514509734) | 9 | 8 | 4 | 64 | 40 | |||
63377 | 186795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984860.9644 | 2106903.0931 | 37.7642785467413 | -122.495582789943 | (37.7642785467413, -122.495582789943) | 1 | 8 | 3 | 56 | 35 | |||
63479 | 184773 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984703.3606 | 2105992.6601 | 37.7617695231787 | -122.496060716498 | (37.7617695231787, -122.496060716498) | 1 | 8 | 3 | 56 | 35 | |||
64261 | 110884 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
64781 | 186950 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985227.0199 | 2096064.0189 | 37.7345388373659 | -122.493518032223 | (37.7345388373659, -122.493518032223) | 1 | 8 | 3 | 29491 | 35 | |||
64811 | 186915 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985160.3793 | 2096738.0161 | 37.7363855555031 | -122.493798079234 | (37.7363855555031, -122.493798079234) | 1 | 8 | 3 | 29491 | 35 | |||
64843 | 203262 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 512 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5997988.38195 | 2097644.1119 | 37.7396156424485 | -122.449511768663 | (37.7396156424485, -122.449511768663) | 9 | 7 | 4 | 59 | 40 | |||
65084 | 186946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985228.197 | 2095990.1961 | 37.7343362084437 | -122.493508525113 | (37.7343362084437, -122.493508525113) | 1 | 8 | 3 | 29491 | 35 | |||
66047 | 203851 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5998148.5387 | 2094357.88923 | 37.7306016197611 | -122.448721386881 | (37.7306016197611, -122.448721386881) | 9 | 7 | 4 | 28861 | 40 | |||
66144 | 220233 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.7643810731487 | -122.446070109962 | (37.7643810731487, -122.446070109962) | 15 | 5 | 11 | 29492 | 9 | |
66284 | 203884 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 181 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5990872.1544 | 2094661.20304 | 37.7310156703418 | -122.473898806879 | (37.7310156703418, -122.473898806879) | 9 | 8 | 4 | 64 | 40 | |||
66632 | 203274 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 52 Burnside Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6001172.3349 | 2095747.08466 | 37.7345884762734 | -122.438367180125 | (37.7345884762734, -122.438367180125) | 2 | 7 | 5 | 63 | 7 | ||||
67289 | 187116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985139.0056 | 2097294.5581 | 37.7379124205271 | -122.493912978366 | (37.7379124205271, -122.493912978366) | 1 | 8 | 3 | 29491 | 35 | |||
68079 | 203280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 59 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | Permit Number 781025 | 5999721.17343 | 2095479.15955 | 37.7337701687542 | -122.443365077855 | (37.7337701687542, -122.443365077855) | 9 | 7 | 4 | 63 | 40 | ||
68205 | 186870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985184.6756 | 2096368.5285 | 37.7353724625278 | -122.493686859622 | (37.7353724625278, -122.493686859622) | 1 | 8 | 3 | 29491 | 35 | |||
68848 | 181393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984912.5728 | 2104566.45 | 37.7578657995745 | -122.495231966638 | (37.7578657995745, -122.495231966638) | 1 | 8 | 3 | 56 | 35 | |||
69668 | 203260 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 31 Sequoia Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5998240.18934 | 2097553.89046 | 37.7393823178446 | -122.448634634681 | (37.7393823178446, -122.448634634681) | 9 | 7 | 4 | 59 | 40 | |||
70337 | 256353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 119 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | ||||
70664 | 186942 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985223.4885 | 2095964.6356 | 37.7342657506702 | -122.493522920975 | (37.7342657506702, -122.493522920975) | 1 | 8 | 3 | 29491 | 35 | |||
71865 | 187756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6018040.44211 | 2093268.12413 | 37.7287267536225 | -122.379875664545 | (37.7287267536225, -122.379875664545) | 10 | 3 | 8 | 58 | 1 | ||||
72123 | 184840 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984633.1125 | 2106860.5086 | 37.7641482765436 | -122.496367710892 | (37.7641482765436, -122.496367710892) | 1 | 8 | 3 | 56 | 35 | |||
73646 | 185188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985136.014 | 2097861.9726 | 37.7394702135829 | -122.493965126981 | (37.7394702135829, -122.493965126981) | 1 | 8 | 3 | 29491 | 35 | |||
74908 | 203780 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5995711.83898 | 2094094.29693 | 37.7297382193253 | -122.457126310455 | (37.7297382193253, -122.457126310455) | 9 | 7 | 4 | 28861 | 40 | |||
75013 | 184867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984635.0111 | 2106821.7773 | 37.7640420425175 | -122.496358286248 | (37.7640420425175, -122.496358286248) | 1 | 8 | 3 | 56 | 35 | |||
75143 | 255642 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
75285 | 120391 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 735 24th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5988455.47289 | 2110915.29878 | 37.775504786578 | -122.483444705322 | (37.775504786578, -122.483444705322) | 11 | 6 | 2 | 55 | 26 | ||||
75884 | 221410 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Digby St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6002579.41102 | 2097685.70424 | 37.7399914124663 | -122.433640955874 | (37.7399914124663, -122.433640955874) | 2 | 7 | 5 | 63 | 7 | |||
75951 | 203899 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990601.43491 | 2090484.56274 | 37.7195319761887 | -122.474530025745 | (37.7195319761887, -122.474530025745) | 9 | 8 | 4 | 64 | 40 | |||
76076 | 185010 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5985035.2011 | 2096476.1433 | 37.735659198289 | -122.494211570428 | (37.735659198289, -122.494211570428) | 1 | 8 | 3 | 29491 | 35 | |||
77073 | 85503 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
77628 | 203243 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1648 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5995591.85858 | 2094957.07718 | 37.7321003138704 | -122.45760349431 | (37.7321003138704, -122.45760349431) | 9 | 7 | 4 | 59 | 40 | |||
77667 | 203246 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 401 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995758.26971 | 2095116.97612 | 37.7325489155023 | -122.45703973989 | (37.7325489155023, -122.45703973989) | 9 | 7 | 4 | 59 | 40 | |||
78454 | 118056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5984738.41738 | 2112623.76679 | 37.7799787079086 | -122.49642879092 | (37.7799787079086, -122.49642879092) | 11 | 6 | 2 | 55 | 26 | |||
79806 | 203265 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998990.96313 | 2097286.06804 | 37.7386898425472 | -122.446019541966 | (37.7386898425472, -122.446019541966) | 9 | 7 | 4 | 59 | 40 | |||
79898 | 124306 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 165 Jordan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 5996204.49781 | 2113222.09495 | 37.782286597951 | -122.456806010866 | (37.782286597951, -122.456806010866) | 11 | 6 | 1 | 54 | 31 | |||
80008 | 203819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 224 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5996114.34243 | 2094848.95185 | 37.7318334274665 | -122.455789350407 | (37.7318334274665, -122.455789350407) | 9 | 7 | 4 | 59 | 40 | ||||
80056 | 98544 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
80608 | 203242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1660 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995530.96911 | 2095074.55373 | 37.7324193780388 | -122.457822499013 | (37.7324193780388, -122.457822499013) | 9 | 7 | 4 | 59 | 40 | |||
81805 | 186794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984862.0002 | 2106886.7785 | 37.7642338120894 | -122.495578004049 | (37.7642338120894, -122.495578004049) | 1 | 8 | 3 | 56 | 35 | |||
81939 | 255640 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
82006 | 203832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1625 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 5995572.09683 | 2094748.54485 | 37.731526599451 | -122.457656731475 | (37.731526599451, -122.457656731475) | 9 | 7 | 4 | 59 | 40 | |||
82358 | 187755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | 10 | 3 | 8 | 58 | 1 | ||||
82805 | 220262 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 29th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6002099.81762 | 2098825.68061 | 37.743094297472 | -122.435380714155 | (37.743094297472, -122.435380714155) | 2 | 7 | 5 | 63 | 7 | ||||
82863 | 203820 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 270 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5996086.90151 | 2095051.70628 | 37.7323885672656 | -122.455898870764 | (37.7323885672656, -122.455898870764) | 9 | 7 | 4 | 59 | 40 | ||||
83227 | 186802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984846.4625 | 2106932.8738 | 37.7643594669603 | -122.495635143928 | (37.7643594669603, -122.495635143928) | 1 | 8 | 3 | 56 | 35 | |||
83674 | 187567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 136 Alpha St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6010892.9605 | 2088110.22572 | 37.7141673547183 | -122.404222218893 | (37.7141673547183, -122.404222218893) | 9 | 7 | 8 | 309 | 39 | |||
84645 | 203261 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 506 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5997991.23111 | 2097614.06115 | 37.7395332933219 | -122.44949975281 | (37.7395332933219, -122.44949975281) | 9 | 7 | 4 | 59 | 40 | |||
85536 | 186746 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984859.6573 | 2106664.9352 | 37.7636245555119 | -122.495569743679 | (37.7636245555119, -122.495569743679) | 1 | 8 | 3 | 56 | 35 | |||
85723 | 186912 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985181.9251 | 2096714.1782 | 37.7363213635218 | -122.493721831405 | (37.7363213635218, -122.493721831405) | 1 | 8 | 3 | 29491 | 35 | |||
86340 | 123111 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 542 11th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5992554.48643 | 2111759.84228 | 37.7780613908307 | -122.469326847882 | (37.7780613908307, -122.469326847882) | 11 | 6 | 2 | 54 | 11 | |||
86660 | 186928 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985229.8786 | 2095924.6132 | 37.7341562336013 | -122.493497880781 | (37.7341562336013, -122.493497880781) | 1 | 8 | 3 | 29491 | 35 | |||
86832 | 125164 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2667 Vallejo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 6000873.86204 | 2117537.36223 | 37.7944022120528 | -122.440961798859 | (37.7944022120528, -122.440961798859) | 13 | 9 | 1 | 57 | 27 | |||
87537 | 203281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000198.21864 | 2096046.74444 | 37.7353558165236 | -122.441756516251 | (37.7353558165236, -122.441756516251) | 9 | 7 | 5 | 63 | 40 | |||
88064 | 184511 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1975 42nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983188.0663 | 2101701.7005 | 37.7498988817819 | -122.500984069855 | (37.7498988817819, -122.500984069855) | 1 | 8 | 3 | 29491 | 35 | |||
89106 | 184838 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984655.5159 | 2106866.5842 | 37.7641662708164 | -122.496290673488 | (37.7641662708164, -122.496290673488) | 1 | 8 | 3 | 56 | 35 | |||
89521 | 186896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985175.5072 | 2096596.8223 | 37.7359987600616 | -122.493735375196 | (37.7359987600616, -122.493735375196) | 1 | 8 | 3 | 29491 | 35 | |||
89960 | 204001 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 478 Warren Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994224.85636 | 2104697.70094 | 37.7587669932122 | -122.463035958859 | (37.7587669932122, -122.463035958859) | 1 | 5 | 4 | 56 | 12 | |||
91558 | 203887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 179 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5990924.31615 | 2094659.11816 | 37.7310129669604 | -122.47371832465 | (37.7310129669604, -122.47371832465) | 9 | 8 | 4 | 64 | 40 | |||
91816 | 175060 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.7292089332358 | -122.422256493849 | (37.7292089332358, -122.422256493849) | 9 | 7 | 6 | 28861 | 5 | |||
92676 | 186788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984852.1597 | 2106871.2408 | 37.7641905736904 | -122.495610892905 | (37.7641905736904, -122.495610892905) | 1 | 8 | 3 | 56 | 35 | |||
92744 | 184849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984683.2354 | 2106848.3576 | 37.7641178494327 | -122.496193456316 | (37.7641178494327, -122.496193456316) | 1 | 8 | 3 | 56 | 35 | |||
93607 | 186932 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.2822 | 2095936.7208 | 37.7341877465081 | -122.493601095228 | (37.7341877465081, -122.493601095228) | 1 | 8 | 3 | 29491 | 35 | |||
93613 | 203273 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 52 Burnside Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6001158.4895 | 2095751.00379 | 37.7345984497666 | -122.43841532891 | (37.7345984497666, -122.43841532891) | 2 | 7 | 5 | 63 | 7 | ||||
93704 | 186936 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985232.9055 | 2095957.9092 | 37.7342478326321 | -122.493489868422 | (37.7342478326321, -122.493489868422) | 1 | 8 | 3 | 29491 | 35 | |||
93813 | 184876 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984660.832 | 2106807.7277 | 37.7640049788393 | -122.496267944002 | (37.7640049788393, -122.496267944002) | 1 | 8 | 3 | 56 | 35 | |||
94056 | 186869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985195.6777 | 2096363.4859 | 37.7353592605359 | -122.493648450371 | (37.7353592605359, -122.493648450371) | 1 | 8 | 3 | 29491 | 35 | |||
95228 | 203833 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 470 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 5995548.29749 | 2095369.378 | 37.7332298893389 | -122.457783917193 | (37.7332298893389, -122.457783917193) | 9 | 7 | 4 | 59 | 40 | |||
96341 | 186860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985194.9901 | 2096324.7493 | 37.7352528599252 | -122.493647974184 | (37.7352528599252, -122.493647974184) | 1 | 8 | 3 | 29491 | 35 | |||
96391 | 123116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 562 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 3ft | 5992559.20376 | 2111633.72876 | 37.777715389925 | -122.469301347393 | (37.777715389925, -122.469301347393) | 11 | 6 | 2 | 54 | 11 | |||
96610 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
96625 | 124357 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 17 Palm Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5995831.62883 | 2114355.0626 | 37.7853760070031 | -122.458177988033 | (37.7853760070031, -122.458177988033) | 11 | 6 | 1 | 54 | 31 | |||
97294 | 203247 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 435 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5995610.12397 | 2095259.68006 | 37.732932237139 | -122.457562233408 | (37.732932237139, -122.457562233408) | 9 | 7 | 4 | 59 | 40 | |||
97413 | 184861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | 1 | 8 | 3 | 56 | 35 | |||
97610 | 186611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 82 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984721.577 | 2104411.7958 | 37.7574299779546 | -122.49588109169 | (37.7574299779546, -122.49588109169) | 1 | 8 | 3 | 56 | 35 | |||
97637 | 203891 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 173 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 5991044.7899 | 2094655.13381 | 37.7310090036421 | -122.473301540158 | (37.7310090036421, -122.473301540158) | 9 | 8 | 4 | 64 | 40 | |||
97954 | 203853 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 366 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5997667.53367 | 2093836.2933 | 37.7291419238547 | -122.450346700167 | (37.7291419238547, -122.450346700167) | 9 | 7 | 4 | 28861 | 40 | ||||
98024 | 186945 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985218.4436 | 2095979.0975 | 37.7343051640866 | -122.493541427788 | (37.7343051640866, -122.493541427788) | 1 | 8 | 3 | 29491 | 35 | |||
98157 | 186916 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985173.6735 | 2096745.3508 | 37.7364064724097 | -122.493752656611 | (37.7364064724097, -122.493752656611) | 1 | 8 | 3 | 29491 | 35 | |||
98211 | 123193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 563 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 5993115.20041 | 2111654.33982 | 37.7778040958117 | -122.46737948001 | (37.7778040958117, -122.46737948001) | 11 | 6 | 2 | 54 | 11 | |||
98724 | 221383 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 709 Duboce Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002125.30194 | 2108240.77443 | 37.768947330488 | -122.435966144022 | (37.768947330488, -122.435966144022) | 15 | 5 | 5 | 29492 | 3 | |||
99003 | 124644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Arguello Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 9ft | 5995537.35644 | 2115745.75128 | 37.7891775496077 | -122.459296819974 | (37.7891775496077, -122.459296819974) | 11 | 6 | 1 | 54 | 31 | |||
100281 | 188677 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Evans Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6018476.48235 | 2096364.95743 | 37.7372540964924 | -122.378583166995 | (37.7372540964924, -122.378583166995) | 10 | 3 | 8 | 58 | 1 | |||
100888 | 221412 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 45 Harry St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6003250.45835 | 2097675.29375 | 37.7400008805364 | -122.431320009807 | (37.7400008805364, -122.431320009807) | 2 | 7 | 5 | 63 | 7 | |||
101000 | 123120 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 578 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 3ft | 5992563.43594 | 2111513.74187 | 37.7773861830229 | -122.469277971458 | (37.7773861830229, -122.469277971458) | 11 | 6 | 2 | 54 | 11 | |||
101095 | 203252 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5996075.27063 | 2095441.53755 | 37.7334582820635 | -122.455967253399 | (37.7334582820635, -122.455967253399) | 9 | 7 | 4 | 59 | 40 | |||
101464 | 175043 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 199 Shakespeare St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.7092485595475 | -122.464240538697 | (37.7092485595475, -122.464240538697) | 9 | 8 | 6 | 28861 | 25 | |||
102846 | 188608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2370 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6011669.87256 | 2099790.80879 | 37.7462831864145 | -122.402357690473 | (37.7462831864145, -122.402357690473) | 10 | 3 | 8 | 58 | 1 | |||
103385 | 187760 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6017527.04391 | 2093321.80664 | 37.7288458211654 | -122.381654264546 | (37.7288458211654, -122.381654264546) | 10 | 3 | 8 | 58 | 1 | ||||
104813 | 203831 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1635 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 5995566.12601 | 2094800.15674 | 37.7316679701912 | -122.457681106717 | (37.7316679701912, -122.457681106717) | 9 | 7 | 4 | 59 | 40 | |||
105543 | 203821 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 280 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5996076.68769 | 2095086.62042 | 37.7324838468387 | -122.455936705234 | (37.7324838468387, -122.455936705234) | 9 | 7 | 4 | 59 | 40 | ||||
105612 | 120394 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 735 24th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5988458.95627 | 2110817.66479 | 37.7752369136053 | -122.483425496649 | (37.7752369136053, -122.483425496649) | 11 | 6 | 2 | 55 | 26 | ||||
105641 | 186614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 85 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984775.1737 | 2104397.9779 | 37.7573951766754 | -122.495694716519 | (37.7573951766754, -122.495694716519) | 1 | 8 | 3 | 56 | 35 | |||
106180 | 185720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984894.4324 | 2100359.2446 | 37.7463129086346 | -122.494984487249 | (37.7463129086346, -122.494984487249) | 1 | 8 | 3 | 29491 | 35 |
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) );