trees
1,377 rows where qSpecies_id = 61 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15166 | 10340 | DPW Maintained 1 | Tristania conferta :: 61 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | 15 | 5 | 11 | 29492 | 9 | |||
133868 | 14482 | DPW Maintained 1 | Tristania conferta :: 61 | 281 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5998940.9244 | 2112049.1164 | 37.7792226484867 | -122.447254781672 | (37.7792226484867, -122.447254781672) | 15 | 5 | 2 | 54 | 16 | |||
369 | 138522 | Undocumented 4 | Tristania conferta :: 61 | 1602 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001658.1955 | 2114019.9111 | 37.7847888393579 | -122.437995843174 | (37.7847888393579, -122.437995843174) | 13 | 6 | 11 | 29490 | 13 | |||
1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
5148 | 247454 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003114.7156 | 2110238.7499 | 37.7744894374273 | -122.432686570898 | (37.7744894374273, -122.432686570898) | 15 | 9 | 11 | 29492 | 10 | |||
11077 | 141992 | DPW Maintained 1 | Tristania conferta :: 61 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1991 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.7781662710742 | -122.429738185966 | (37.7781662710742, -122.429738185966) | 7 | 9 | 11 | 29490 | 41 | ||
17454 | 55475 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1972 12:00:00 AM | 9 | Permit Number 11427 | 6001668.0931 | 2110827.7285 | 37.7760244773884 | -122.437732898122 | (37.7760244773884, -122.437732898122) | 15 | 5 | 11 | 29492 | 10 | |
19744 | 138921 | DPW Maintained 1 | Tristania conferta :: 61 | 631 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004505.2517 | 2110712.757 | 37.7758697074358 | -122.427910221054 | (37.7758697074358, -122.427910221054) | 7 | 9 | 11 | 28852 | 10 | |||
26175 | 138912 | DPW Maintained 1 | Tristania conferta :: 61 | 719 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004292.6341 | 2110798.4737 | 37.7760930338959 | -122.428651831595 | (37.7760930338959, -122.428651831595) | 7 | 9 | 11 | 28852 | 10 | |||
26474 | 6905 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.7757977566382 | -122.423455896757 | (37.7757977566382, -122.423455896757) | 7 | 9 | 11 | 28852 | 10 | |||
33537 | 244129 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004596.6687 | 2109503.17 | 37.7725536479568 | -122.427507793274 | (37.7725536479568, -122.427507793274) | 7 | 9 | 11 | 28852 | 10 | |||
38347 | 247255 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997293.757 | 2109123.4893 | 37.7710953802668 | -122.452741770892 | (37.7710953802668, -122.452741770892) | 15 | 5 | 11 | 29492 | 9 | |||
41026 | 138710 | DPW Maintained 1 | Tristania conferta :: 61 | 2699 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000650.0889 | 2114452.8379 | 37.7859201640241 | -122.4415146292 | (37.7859201640241, -122.4415146292) | 15 | 6 | 1 | 29490 | 27 | |||
45944 | 200662 | DPW Maintained 1 | Tristania conferta :: 61 | 1532 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015174.2771 | 2095413.8657 | 37.734460003731 | -122.389934087199 | (37.734460003731, -122.389934087199) | 10 | 3 | 8 | 58 | 1 | |||
48658 | 139935 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005714.5324 | 2112478.1713 | 37.7807854422322 | -122.423852565408 | (37.7807854422322, -122.423852565408) | 7 | 9 | 11 | 28852 | 41 | |||
49075 | 142364 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005532.9915 | 2113401.0862 | 37.7833092892509 | -122.424546272586 | (37.7833092892509, -122.424546272586) | 7 | 9 | 11 | 28858 | 41 | |||
49529 | 244950 | DPW Maintained 1 | Tristania conferta :: 61 | 261 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005976.2472 | 2110605.9955 | 37.7756596739035 | -122.422814074007 | (37.7756596739035, -122.422814074007) | 7 | 9 | 11 | 28852 | 10 | |||
54378 | 142069 | DPW Maintained 1 | Tristania conferta :: 61 | 1000 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003891.204 | 2112315.3287 | 37.7802352155951 | -122.430148721701 | (37.7802352155951, -122.430148721701) | 7 | 9 | 11 | 29490 | 41 | |||
58128 | 114168 | DPW Maintained 1 | Tristania conferta :: 61 | 1x Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997246.1454 | 2110389.6791 | 37.7745692814468 | -122.452997873526 | (37.7745692814468, -122.452997873526) | 15 | 5 | 2 | 29492 | 16 | |||
64505 | 244137 | DPW Maintained 1 | Tristania conferta :: 61 | 358 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004342.0589 | 2109471.7403 | 37.7724529455195 | -122.428386274191 | (37.7724529455195, -122.428386274191) | 7 | 9 | 11 | 28852 | 10 | |||
68651 | 245425 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009073.1901 | 2106875.611 | 37.7655911583595 | -122.411837285128 | (37.7655911583595, -122.411837285128) | 8 | 4 | 7 | 28853 | 19 | |||
69876 | 13270 | DPW Maintained 1 | Tristania conferta :: 61 | 2498 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2000 12:00:00 AM | 9 | 3x3 | 6000499.2901 | 2119275.2189 | 37.7991525665006 | -122.442382681808 | (37.7991525665006, -122.442382681808) | 13 | 9 | 1 | 57 | 17 | ||
70707 | 107145 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5985834.5248 | 2098407.3335 | 37.7410084743792 | -122.491590149603 | (37.7410084743792, -122.491590149603) | 1 | 8 | 3 | 29491 | 35 | ||||
72173 | 22388 | DPW Maintained 1 | Tristania conferta :: 61 | 5600 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2010 12:00:00 AM | 9 | 3X3 | Permit Number 53445 | 6014004.2537 | 2092658.7566 | 37.7268300775798 | -122.393786492489 | (37.7268300775798, -122.393786492489) | 10 | 3 | 8 | 58 | 1 | |
80523 | 139854 | DPW Maintained 1 | Tristania conferta :: 61 | 715 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005760.424 | 2112155.9925 | 37.7799034087022 | -122.423670890236 | (37.7799034087022, -122.423670890236) | 7 | 9 | 11 | 28852 | 41 | |||
80781 | 141883 | DPW Maintained 1 | Tristania conferta :: 61 | 1170 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003827.7304 | 2112761.2344 | 37.7814559664057 | -122.430400129926 | (37.7814559664057, -122.430400129926) | 7 | 9 | 11 | 29490 | 41 | |||
81198 | 32143 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 9 | Permit Number 35498 | 6003111.4815 | 2110262.0358 | 37.774553191336 | -122.432699422008 | (37.774553191336, -122.432699422008) | 15 | 9 | 11 | 29492 | 10 | ||
82139 | 244946 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005905.5273 | 2110676.0221 | 37.7758479595317 | -122.423063690364 | (37.7758479595317, -122.423063690364) | 7 | 9 | 11 | 28852 | 10 | |||
83771 | 138883 | DPW Maintained 1 | Tristania conferta :: 61 | 520 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004085.5412 | 2110582.6752 | 37.7754887818854 | -122.42935282905 | (37.7754887818854, -122.42935282905) | 7 | 9 | 11 | 28852 | 10 | |||
87279 | 138907 | DPW Maintained 1 | Tristania conferta :: 61 | 735 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004163.0545 | 2110782.067 | 37.776040650851 | -122.429098911954 | (37.776040650851, -122.429098911954) | 7 | 9 | 11 | 28852 | 10 | |||
93703 | 199674 | DPW Maintained 1 | Tristania conferta :: 61 | 1453 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015501.9906 | 2093353.6888 | 37.7288213408036 | -122.388657298244 | (37.7288213408036, -122.388657298244) | 10 | 3 | 8 | 58 | 1 | |||
94108 | 141094 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | 11 | 6 | 1 | 54 | 31 | |||
95836 | 246309 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007064.7803 | 2109330.2021 | 37.772218007718 | -122.418958053835 | (37.772218007718, -122.418958053835) | 8 | 2 | 9 | 28853 | 19 | |||
97495 | 141403 | DPW Maintained 1 | Tristania conferta :: 61 | 637 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004926.4763 | 2111150.5659 | 37.777095644253 | -122.426484277073 | (37.777095644253, -122.426484277073) | 7 | 9 | 11 | 28852 | 10 | |||
100073 | 68137 | DPW Maintained 1 | Tristania conferta :: 61 | 2786 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31889 | 6000193.313 | 2114445.5102 | 37.7858740103556 | -122.443094416733 | (37.7858740103556, -122.443094416733) | 13 | 6 | 1 | 29490 | 27 | |
103159 | 138917 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004409.1552 | 2110814.8804 | 37.7761446763748 | -122.428249923485 | (37.7761446763748, -122.428249923485) | 7 | 9 | 11 | 28852 | 10 | |||
105762 | 200990 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015409.9294 | 2115740.0891 | 37.7902844914695 | -122.390539192334 | (37.7902844914695, -122.390539192334) | 6 | 2 | 9 | 28855 | 6 | |||
106135 | 142795 | DPW Maintained 1 | Tristania conferta :: 61 | 535 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007556.7713 | 2113214.153 | 37.7829100980098 | -122.417531527021 | (37.7829100980098, -122.417531527021) | 7 | 9 | 9 | 28852 | 36 | |||
106375 | 139616 | DPW Maintained 1 | Tristania conferta :: 61 | 1831 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001632.5496 | 2112513.0799 | 37.780650005986 | -122.437976599499 | (37.780650005986, -122.437976599499) | 15 | 5 | 11 | 29490 | 41 | |||
107909 | 142013 | DPW Maintained 1 | Tristania conferta :: 61 | 739 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004883.546 | 2111458.9748 | 37.7779400325415 | -122.426654753782 | (37.7779400325415, -122.426654753782) | 7 | 9 | 11 | 28852 | 10 | |||
111596 | 142336 | DPW Maintained 1 | Tristania conferta :: 61 | 1696 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999780.0519 | 2110221.7447 | 37.7742530643991 | -122.444220553239 | (37.7742530643991, -122.444220553239) | 15 | 5 | 11 | 29492 | 16 | |||
114052 | 244385 | DPW Maintained 1 | Tristania conferta :: 61 | 897 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003194.2623 | 2110294.2764 | 37.774646410436 | -122.432415370472 | (37.774646410436, -122.432415370472) | 15 | 9 | 11 | 29492 | 10 | |||
116473 | 138525 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001648.301 | 2114083.6756 | 37.7849633576893 | -122.438034643925 | (37.7849633576893, -122.438034643925) | 13 | 6 | 11 | 29490 | 13 | |||
118593 | 6900 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005641.7144 | 2110639.9688 | 37.7757340754101 | -122.423973723268 | (37.7757340754101, -122.423973723268) | 7 | 9 | 11 | 28852 | 10 | |||
125649 | 141854 | DPW Maintained 1 | Tristania conferta :: 61 | 1121 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004716.8501 | 2112697.6359 | 37.7813316649438 | -122.427319672392 | (37.7813316649438, -122.427319672392) | 7 | 9 | 11 | 29490 | 41 | |||
129628 | 245886 | DPW Maintained 1 | Tristania conferta :: 61 | 202 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001314.9652 | 2109417.844 | 37.7721332028798 | -122.438853400963 | (37.7721332028798, -122.438853400963) | 15 | 5 | 11 | 29492 | 9 | |||
130524 | 6253 | DPW Maintained 1 | Tristania conferta :: 61 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.7828709555828 | -122.428031512738 | (37.7828709555828, -122.428031512738) | 7 | 9 | 11 | 29490 | 41 | ||
140917 | 138908 | DPW Maintained 1 | Tristania conferta :: 61 | 731 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004183.814 | 2110783.7411 | 37.7760464226318 | -122.429027218737 | (37.7760464226318, -122.429027218737) | 7 | 9 | 11 | 28852 | 10 | |||
141864 | 246311 | Undocumented 4 | Tristania conferta :: 61 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.418874102872 | (37.772331017243, -122.418874102872) | 8 | 2 | 9 | 28853 | 19 | |||
141973 | 244132 | DPW Maintained 1 | Tristania conferta :: 61 | 322 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004530.9257 | 2109493.9429 | 37.7725245939109 | -122.427734547545 | (37.7725245939109, -122.427734547545) | 7 | 9 | 11 | 28852 | 10 | |||
142641 | 137788 | DPW Maintained 1 | Tristania conferta :: 61 | 1711 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005258.2038 | 2115760.6088 | 37.789772428971 | -122.425664920751 | (37.789772428971, -122.425664920751) | 13 | 9 | 1 | 28858 | 27 | |||
143131 | 200764 | DPW Maintained 1 | Tristania conferta :: 61 | 5279 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014431.9312 | 2093644.8594 | 37.7295614746291 | -122.39237695219 | (37.7295614746291, -122.39237695219) | 10 | 3 | 8 | 58 | 1 | |||
143756 | 65429 | DPW Maintained 1 | Tristania conferta :: 61 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.7912814481387 | -122.406942874303 | (37.7912814481387, -122.406942874303) | 5 | 1 | 10 | 28857 | 6 | |
149079 | 35644 | DPW Maintained 1 | Tristania conferta :: 61 | 635 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | 9 | Permit Number 38976 | 6004498.2203 | 2110755.6153 | 37.7759869880383 | -122.427937599156 | (37.7759869880383, -122.427937599156) | 7 | 9 | 11 | 28852 | 10 | ||
149456 | 244886 | DPW Maintained 1 | Tristania conferta :: 61 | 1421 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999792.9797 | 2109134.0789 | 37.7712673472558 | -122.444097663562 | (37.7712673472558, -122.444097663562) | 15 | 5 | 11 | 29492 | 9 | |||
152961 | 200663 | DPW Maintained 1 | Tristania conferta :: 61 | 1535 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015121.5143 | 2095453.4378 | 37.7345657344021 | -122.390119270723 | (37.7345657344021, -122.390119270723) | 10 | 3 | 8 | 58 | 1 | |||
153400 | 139239 | DPW Maintained 1 | Tristania conferta :: 61 | 1401 WEBSTER ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003667.9911 | 2113214.7954 | 37.7826922817775 | -122.43098513109 | (37.7826922817775, -122.43098513109) | 15 | 9 | 11 | 29490 | 41 | |||
154630 | 201231 | DPW Maintained 1 | Tristania conferta :: 61 | 405 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014377.5686 | 2114753.9994 | 37.7875195921585 | -122.394042053329 | (37.7875195921585, -122.394042053329) | 6 | 2 | 9 | 28855 | 6 | |||
156613 | 244948 | DPW Maintained 1 | Tristania conferta :: 61 | 281 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005970.7006 | 2110659.3821 | 37.7758059476355 | -122.422837056089 | (37.7758059476355, -122.422837056089) | 7 | 9 | 11 | 28852 | 10 | |||
164540 | 200668 | DPW Maintained 1 | Tristania conferta :: 61 | 1591 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015323.7716 | 2095585.3447 | 37.7349391399112 | -122.389429202238 | (37.7349391399112, -122.389429202238) | 10 | 3 | 8 | 58 | 1 | |||
165747 | 139976 | DPW Maintained 1 | Tristania conferta :: 61 | 1002 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001948.5635 | 2111960.0268 | 37.7791494276638 | -122.436843754953 | (37.7791494276638, -122.436843754953) | 15 | 5 | 11 | 29490 | 41 | |||
170633 | 137898 | DPW Maintained 1 | Tristania conferta :: 61 | 1826 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003442.8192 | 2115139.0382 | 37.787963006088 | -122.431901572466 | (37.787963006088, -122.431901572466) | 13 | 9 | 11 | 29490 | 27 | |||
172373 | 246307 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007039.6773 | 2109281.1913 | 37.7720820221483 | -122.419041410572 | (37.7720820221483, -122.419041410572) | 8 | 2 | 9 | 28853 | 19 | |||
174964 | 244213 | DPW Maintained 1 | Tristania conferta :: 61 | 322 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004508.1464 | 2109493.0779 | 37.7725209302455 | -122.427813281818 | (37.7725209302455, -122.427813281818) | 7 | 9 | 11 | 28852 | 10 | |||
176954 | 138915 | DPW Maintained 1 | Tristania conferta :: 61 | 711 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004375.6722 | 2110809.5231 | 37.7761280719449 | -122.428365368299 | (37.7761280719449, -122.428365368299) | 7 | 9 | 11 | 28852 | 10 | |||
179397 | 245062 | DPW Maintained 1 | Tristania conferta :: 61 | 1108 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000757.2591 | 2108969.2279 | 37.7708696699941 | -122.440750361991 | (37.7708696699941, -122.440750361991) | 15 | 5 | 11 | 29492 | 9 | |||
184424 | 138523 | DPW Maintained 1 | Tristania conferta :: 61 | 1604 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001653.2482 | 2114047.3958 | 37.7848640239748 | -122.438014928593 | (37.7848640239748, -122.438014928593) | 13 | 6 | 11 | 29490 | 13 | |||
189258 | 142363 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005513.0496 | 2113400.4215 | 37.7833063379401 | -122.424615216414 | (37.7833063379401, -122.424615216414) | 7 | 9 | 11 | 28858 | 41 | |||
192325 | 138909 | DPW Maintained 1 | Tristania conferta :: 61 | 727 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004219.3061 | 2110788.4288 | 37.776061302871 | -122.428904776437 | (37.776061302871, -122.428904776437) | 7 | 9 | 11 | 28852 | 10 | |||
147566 | 14452 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226 | (37.7808136360807, -122.44734276226) | 15 | 5 | 1 | 54 | 16 | |||
1445 | 140697 | DPW Maintained 1 | Tristania conferta :: 61 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.446098386426 | (37.7734481000077, -122.446098386426) | 15 | 5 | 11 | 29492 | 16 | |||
5368 | 73913 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.423208392543 | (37.7775067029674, -122.423208392543) | 7 | 9 | 11 | 28852 | 10 | |||
5979 | 137873 | DPW Maintained 1 | Tristania conferta :: 61 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | 13 | 9 | 11 | 28858 | 27 | |||
6244 | 138902 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004070.6412 | 2110683.9615 | 37.7757660455959 | -122.42941159626 | (37.7757660455959, -122.42941159626) | 7 | 9 | 11 | 28852 | 10 | |||
7492 | 138882 | DPW Maintained 1 | Tristania conferta :: 61 | 510 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004088.2198 | 2110564.2595 | 37.7754383685459 | -122.429342249625 | (37.7754383685459, -122.429342249625) | 7 | 9 | 11 | 28852 | 10 | |||
16548 | 143139 | DPW Maintained 1 | Tristania conferta :: 61 | 2520 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000358 | 2119336 | 37.7993114011756 | -122.442875959315 | (37.7993114011756, -122.442875959315) | 13 | 9 | 1 | 57 | 17 | |||
20396 | 246241 | DPW Maintained 1 | Tristania conferta :: 61 | 1395 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999547.9215 | 2107815.4823 | 37.7676328306769 | -122.444850527256 | (37.7676328306769, -122.444850527256) | 15 | 5 | 11 | 29492 | 9 | |||
22349 | 29469 | DPW Maintained 1 | Tristania conferta :: 61 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.384094597711 | (37.7288867261126, -122.384094597711) | 10 | 3 | 8 | 58 | 1 | ||
26846 | 15288 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.7721477499918 | -122.419195888407 | (37.7721477499918, -122.419195888407) | 8 | 2 | 9 | 28853 | 19 | ||
27170 | 68157 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 8 | Permit Number 33474 | 6005184.9642 | 2114742.2338 | 37.7869720870456 | -122.425845804507 | (37.7869720870456, -122.425845804507) | 13 | 9 | 11 | 28858 | 13 | ||
30243 | 13145 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | 13 | 9 | 1 | 57 | 17 | ||
30290 | 13100 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852 | -122.426586143087 | (37.800932566852, -122.426586143087) | 13 | 9 | 1 | 57 | 17 | ||
31234 | 141807 | DPW Maintained 1 | Tristania conferta :: 61 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.428784324512 | (37.7823289364611, -122.428784324512) | 7 | 9 | 11 | 29490 | 41 | |||
33197 | 200150 | DPW Maintained 1 | Tristania conferta :: 61 | 6199 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013507.0577 | 2091126.6395 | 37.7225955506276 | -122.395398012615 | (37.7225955506276, -122.395398012615) | 10 | 3 | 8 | 58 | 1 | |||
33612 | 201232 | DPW Maintained 1 | Tristania conferta :: 61 | 405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014397.1053 | 2114774.0503 | 37.7875757331087 | -122.393975863907 | (37.7875757331087, -122.393975863907) | 6 | 2 | 9 | 28855 | 6 | |||
37861 | 138901 | DPW Maintained 1 | Tristania conferta :: 61 | 512 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004073.9895 | 2110663.202 | 37.7757092346813 | -122.429398532918 | (37.7757092346813, -122.429398532918) | 7 | 9 | 11 | 28852 | 10 | |||
50869 | 246072 | DPW Maintained 1 | Tristania conferta :: 61 | 1827 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997411.4623 | 2108451.7262 | 37.7692576354413 | -122.452286145637 | (37.7692576354413, -122.452286145637) | 15 | 5 | 11 | 29492 | 9 | |||
51214 | 142785 | DPW Maintained 1 | Tristania conferta :: 61 | 730 POLK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007074.6935 | 2113542.206 | 37.7837837144855 | -122.419222597686 | (37.7837837144855, -122.419222597686) | 7 | 9 | 9 | 28858 | 36 | |||
51619 | 141090 | DPW Maintained 1 | Tristania conferta :: 61 | 196 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996268.5766 | 2112969.4544 | 37.7815965932692 | -122.456566052477 | (37.7815965932692, -122.456566052477) | 11 | 6 | 1 | 54 | 31 | |||
53377 | 199877 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6017008.6079 | 2093600.4201 | 37.7295821995791 | -122.383465938576 | (37.7295821995791, -122.383465938576) | 10 | 3 | 8 | 58 | 1 | |||
55564 | 142794 | DPW Maintained 1 | Tristania conferta :: 61 | 537 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007553.8618 | 2113233.0652 | 37.7829618626178 | -122.417542933515 | (37.7829618626178, -122.417542933515) | 7 | 9 | 9 | 28852 | 36 | |||
58484 | 140494 | DPW Maintained 1 | Tristania conferta :: 61 | 1366 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003559.5716 | 2112477.8503 | 37.7806626708462 | -122.431307594622 | (37.7806626708462, -122.431307594622) | 15 | 9 | 11 | 29490 | 41 | |||
59398 | 244220 | DPW Maintained 1 | Tristania conferta :: 61 | 575 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997973.512 | 2108683.547 | 37.7699263384799 | -122.450358767117 | (37.7699263384799, -122.450358767117) | 15 | 5 | 11 | 29492 | 9 | |||
59775 | 10431 | DPW Maintained 1 | Tristania conferta :: 61 | 1430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | 8 | 3X3 | 5999221.0892 | 2108752.9533 | 37.770188231639 | -122.446048431812 | (37.770188231639, -122.446048431812) | 15 | 5 | 11 | 29492 | 9 | ||
60050 | 143150 | DPW Maintained 1 | Tristania conferta :: 61 | 2218 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001729.5264 | 2119441.44 | 37.7996790084154 | -122.43813756656 | (37.7996790084154, -122.43813756656) | 13 | 9 | 1 | 57 | 17 | |||
60294 | 200917 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015704.1884 | 2097889.2984 | 37.7412864123015 | -122.388274701363 | (37.7412864123015, -122.388274701363) | 10 | 3 | 8 | 58 | 1 | |||
60333 | 142792 | DPW Maintained 1 | Tristania conferta :: 61 | 541 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007549.1337 | 2113275.4357 | 37.7830779357014 | -122.417562294779 | (37.7830779357014, -122.417562294779) | 7 | 9 | 9 | 28852 | 36 | |||
67764 | 244136 | DPW Maintained 1 | Tristania conferta :: 61 | 358 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004373.2003 | 2109476.3538 | 37.7724673751924 | -122.428278881898 | (37.7724673751924, -122.428278881898) | 7 | 9 | 11 | 28852 | 10 | |||
69936 | 200158 | DPW Maintained 1 | Tristania conferta :: 61 | 3198 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014214.6634 | 2089926.0284 | 37.7193382417884 | -122.392868002126 | (37.7193382417884, -122.392868002126) | 10 | 3 | 8 | 58 | 1 |
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) );