trees
1,381 rows where qSpecies_id = 54 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13226 | 141684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998631.8104 | 2111816.1017 | 37.7785651829019 | -122.448307345965 | (37.7785651829019, -122.448307345965) | 15 | 6 | 2 | 54 | 16 | |||
13248 | 138690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2838 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999904.6577 | 2114405.5136 | 37.7857477274076 | -122.444090205696 | (37.7857477274076, -122.444090205696) | 15 | 6 | 1 | 29490 | 31 | |||
13607 | 140513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1060 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003397.5169 | 2112023.698 | 37.7794064966556 | -122.431835782497 | (37.7794064966556, -122.431835782497) | 15 | 9 | 11 | 29490 | 41 | |||
13989 | 137919 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1963 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004551.2938 | 2115340.9969 | 37.788580310137 | -122.428080846949 | (37.788580310137, -122.428080846949) | 13 | 9 | 11 | 28858 | 27 | |||
14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
14187 | 201882 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | 6 | 2 | 9 | 28856 | 6 | |||
14249 | 245420 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | 2 | 4 | 7 | 28859 | 19 | |||
14320 | 143346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003772.2749 | 2118686.9893 | 37.7977234452078 | -122.431015036831 | (37.7977234452078, -122.431015036831) | 13 | 9 | 1 | 57 | 17 | |||
14805 | 143525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1957 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003628.1215 | 2118621.4061 | 37.7975352014281 | -122.43150916251 | (37.7975352014281, -122.43150916251) | 13 | 9 | 1 | 57 | 17 | |||
15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
15342 | 113473 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
15508 | 244193 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998442.5226 | 2108797.178 | 37.7702651709945 | -122.448744661621 | (37.7702651709945, -122.448744661621) | 15 | 5 | 11 | 29492 | 9 | |||
16062 | 247337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.432773934025 | (37.7727099867472, -122.432773934025) | 15 | 5 | 11 | 29492 | 9 | |||
16127 | 246164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.7683928596779 | -122.452566262235 | (37.7683928596779, -122.452566262235) | 15 | 5 | 11 | 29492 | 9 | |||
16546 | 143187 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | 3 | 1 | 10 | 308 | 23 | |||
16609 | 141535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996788.0463 | 2111499.0832 | 37.777589151551 | -122.454662685268 | (37.777589151551, -122.454662685268) | 15 | 6 | 2 | 54 | 16 | |||
16934 | 143369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1763 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004565.1185 | 2118753.222 | 37.7979501963148 | -122.428276302626 | (37.7979501963148, -122.428276302626) | 13 | 9 | 1 | 57 | 17 | |||
17155 | 140539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003373.4703 | 2111871.9826 | 37.7789885607925 | -122.43190813363 | (37.7789885607925, -122.43190813363) | 15 | 9 | 11 | 29490 | 41 | |||
17483 | 247328 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | Permit Number 785235 | 6003691.2873 | 2110070.3794 | 37.7740598153428 | -122.430680081912 | (37.7740598153428, -122.430680081912) | 7 | 9 | 11 | 29492 | 10 | ||
17488 | 245410 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.7529335917078 | -122.407871614204 | (37.7529335917078, -122.407871614204) | 2 | 4 | 7 | 28859 | 19 | |||
17922 | 21738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.433942077336 | (37.7859289122324, -122.433942077336) | 13 | 9 | 11 | 29490 | 13 | |||
17983 | 107661 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | 15 | 5 | 5 | 28862 | 3 | |||
18163 | 140072 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
18387 | 245411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | 2 | 4 | 7 | 28859 | 19 | |||
18647 | 138987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.431524537427 | (37.7757340330654, -122.431524537427) | 15 | 9 | 11 | 29492 | 10 | |||
18863 | 138123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003035.9259 | 2114580.1998 | 37.7864055028496 | -122.433269401448 | (37.7864055028496, -122.433269401448) | 13 | 9 | 11 | 29490 | 27 | |||
19257 | 531 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.7527490975863 | -122.408903610932 | (37.7527490975863, -122.408903610932) | 2 | 4 | 7 | 28859 | 19 | |||
19361 | 61824 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | 7 | 9 | 11 | 28852 | 10 | ||
19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 | |||
19779 | 140264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997701.9343 | 2110276.144 | 37.7742836533846 | -122.451413027686 | (37.7742836533846, -122.451413027686) | 15 | 5 | 2 | 29492 | 16 | |||
20537 | 141610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
21039 | 97936 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.410321003577 | (37.8057498158932, -122.410321003577) | 3 | 1 | 10 | 308 | 23 | |||
21051 | 141109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.448827586566 | (37.7814254265925, -122.448827586566) | 15 | 6 | 2 | 54 | 16 | |||
21231 | 142496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 523 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010454.4069 | 2119574.2954 | 37.8005361345001 | -122.40795552252 | (37.8005361345001, -122.40795552252) | 3 | 1 | 10 | 308 | 23 | |||
21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
21641 | 17024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001643.357 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | 15 | 5 | 11 | 29492 | 9 | |||
21747 | 143165 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009847.836 | 2121509.3744 | 37.8058154030924 | -122.410191209337 | (37.8058154030924, -122.410191209337) | 3 | 1 | 10 | 308 | 23 | |||
22206 | 199853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.393042840565 | (37.7254588983374, -122.393042840565) | 10 | 3 | 8 | 58 | 1 | |||
22348 | 111433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | 15 | 6 | 1 | 29490 | 31 | |||
22419 | 138465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1870 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001534.446 | 2114897.4717 | 37.7871913575616 | -122.438486871914 | (37.7871913575616, -122.438486871914) | 13 | 6 | 11 | 29490 | 27 | |||
22448 | 143498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.724 | 2117930.0991 | 37.7960642762572 | -122.405198277055 | (37.7960642762572, -122.405198277055) | 3 | 1 | 10 | 28857 | 4 | |||
22527 | 184489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.498803633975 | (37.7519941007524, -122.498803633975) | 1 | 8 | 3 | 56 | 35 | |||
22696 | 143168 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 189 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009887.869 | 2121571.9902 | 37.8059895743176 | -122.410057091761 | (37.8059895743176, -122.410057091761) | 3 | 1 | 10 | 308 | 23 | |||
22833 | 244381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 221 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005910.0454 | 2110329.5608 | 37.7748969155572 | -122.423023430361 | (37.7748969155572, -122.423023430361) | 7 | 9 | 11 | 28852 | 10 | |||
23337 | 142265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004973.0459 | 2110598.408 | 37.7755821860494 | -122.426283856756 | (37.7755821860494, -122.426283856756) | 7 | 9 | 11 | 28852 | 10 | |||
23351 | 33662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | 7 | 9 | 11 | 28852 | 10 | ||
23493 | 199735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | 10 | 3 | 8 | 58 | 1 | |||
23530 | 245383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.424260783275 | (37.7369948294896, -122.424260783275) | 2 | 7 | 5 | 28859 | 2 | |||
23537 | 143389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004330.7069 | 2118766.2088 | 37.7979725882879 | -122.429088360064 | (37.7979725882879, -122.429088360064) | 13 | 9 | 1 | 57 | 17 | |||
23592 | 7266 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | 13 | 9 | 11 | 29490 | 13 | |||
23620 | 141343 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.439371501085 | (37.7746624976237, -122.439371501085) | 15 | 5 | 11 | 29492 | 10 | |||
23704 | 7163 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.7766622670699 | -122.431275186 | (37.7766622670699, -122.431275186) | 7 | 9 | 11 | 29492 | 10 | |||
23778 | 21585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | 13 | 9 | 11 | 28858 | 27 | |||
23992 | 20166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6002621 | 2112212 | 37.7798794773869 | -122.434535545992 | (37.7798794773869, -122.434535545992) | 15 | 5 | 11 | 29490 | 41 | |||
24027 | 17108 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | 15 | 5 | 11 | 29492 | 9 | |||
24167 | 31656 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | 13 | 9 | 11 | 28858 | 27 | |
24256 | 245132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999461.1138 | 2109428.314 | 37.7720563046211 | -122.445266756098 | (37.7720563046211, -122.445266756098) | 15 | 5 | 11 | 29492 | 9 | |||
24303 | 139447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | 7 | 9 | 11 | 28852 | 10 | |||
24475 | 183822 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2235 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987905.4957 | 2100075.9969 | 37.7457109948541 | -122.484551945811 | (37.7457109948541, -122.484551945811) | 1 | 8 | 3 | 29491 | 35 | |||
24536 | 16993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | 15 | 5 | 11 | 29492 | 10 | |||
24624 | 17680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.435234433978 | (37.7795688238035, -122.435234433978) | 15 | 5 | 11 | 29490 | 41 | |||
24735 | 137798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004365.9463 | 2115528.293 | 37.7890840898669 | -122.428735478435 | (37.7890840898669, -122.428735478435) | 13 | 9 | 11 | 28858 | 27 | |||
24828 | 143520 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2174 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002609.217 | 2118527.6063 | 37.7972198497902 | -122.435028126326 | (37.7972198497902, -122.435028126326) | 13 | 9 | 1 | 57 | 17 | |||
24988 | 143085 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 463 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010679.3104 | 2120299.3653 | 37.8025395875062 | -122.40722840197 | (37.8025395875062, -122.40722840197) | 3 | 1 | 10 | 308 | 23 | |||
25184 | 244323 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003563.5505 | 2110000.7658 | 37.7738614359578 | -122.431116975625 | (37.7738614359578, -122.431116975625) | 15 | 9 | 11 | 29492 | 10 | |||
25242 | 142827 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | 13 | 9 | 10 | 28858 | 32 | |||
25325 | 140508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820926 | -122.431748235324 | (37.778971820926, -122.431748235324) | 15 | 9 | 11 | 29490 | 41 | |||
25346 | 139115 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2613 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999526.5436 | 2113598.8751 | 37.7835113303016 | -122.445340349757 | (37.7835113303016, -122.445340349757) | 15 | 6 | 1 | 29490 | 31 | |||
25823 | 140682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | 15 | 5 | 2 | 29492 | 16 | |||
26277 | 138359 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.433864291751 | (37.7860784126894, -122.433864291751) | 13 | 9 | 11 | 29490 | 27 | |||
26414 | 143167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 195 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009865.9706 | 2121568.5686 | 37.8059789520686 | -122.410132633272 | (37.8059789520686, -122.410132633272) | 3 | 1 | 10 | 308 | 23 | |||
26458 | 248312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999157.272 | 2108349.6728 | 37.7690772810316 | -122.446240160162 | (37.7690772810316, -122.446240160162) | 15 | 5 | 11 | 29492 | 9 | |||
26924 | 142123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | 15 | 6 | 2 | 29492 | 16 | |||
27001 | 7264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.433120195092 | (37.78568958693, -122.433120195092) | 13 | 9 | 11 | 29490 | 13 | |||
27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
27215 | 13203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2143 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002126.2145 | 2119425.2487 | 37.7996571038373 | -122.436763723295 | (37.7996571038373, -122.436763723295) | 13 | 9 | 1 | 57 | 17 | |||
27263 | 140420 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.433665289686 | (37.7801136820125, -122.433665289686) | 15 | 9 | 11 | 29490 | 41 | |||
27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
27696 | 53066 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | 13 | 6 | 11 | 29490 | 13 | ||
27853 | 13195 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | 13 | 9 | 1 | 57 | 17 | |||
27911 | 121250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.7885569916775 | -122.432977615629 | (37.7885569916775, -122.432977615629) | 13 | 9 | 1 | 29490 | 27 | ||
28001 | 142492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009649.7576 | 2119605.0318 | 37.8005754466702 | -122.410742118634 | (37.8005754466702, -122.410742118634) | 3 | 1 | 10 | 308 | 4 | |||
28061 | 244147 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 405 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004529.1957 | 2109628.6007 | 37.7728942335898 | -122.427750128017 | (37.7728942335898, -122.427750128017) | 7 | 9 | 11 | 28852 | 10 | |||
28067 | 142120 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1218 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001961.8598 | 2110867.3987 | 37.7761501011447 | -122.436719523648 | (37.7761501011447, -122.436719523648) | 15 | 5 | 11 | 29492 | 10 | |||
28390 | 140425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.7803005084328 | -122.43321309579 | (37.7803005084328, -122.43321309579) | 15 | 9 | 11 | 29490 | 41 | |||
28509 | 13126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.429640016754 | (37.8005454550984, -122.429640016754) | 13 | 9 | 1 | 57 | 17 | |||
28705 | 143354 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005214.4581 | 2118841.5322 | 37.7982293936322 | -122.426035690785 | (37.7982293936322, -122.426035690785) | 13 | 9 | 1 | 57 | 17 | |||
29165 | 108003 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6005338.5862 | 2110997.1319 | 37.7766976400209 | -122.425047738741 | (37.7766976400209, -122.425047738741) | 7 | 9 | 11 | 28852 | 10 | |||
29405 | 21724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1942X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2003 12:00:00 AM | 17 | 4X4 | 6003291.3026 | 2114524.3217 | 37.786266559771 | -122.432381870835 | (37.786266559771, -122.432381870835) | 13 | 9 | 11 | 29490 | 27 | ||
29451 | 7685 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 521 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008756.4018 | 2121076.0419 | 37.8045643433196 | -122.41393762212 | (37.8045643433196, -122.41393762212) | 3 | 1 | 10 | 308 | 23 | |||
29602 | 139484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1216 FULTON ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6001778.449 | 2111192.2794 | 37.7770317168845 | -122.437377258879 | (37.7770317168845, -122.437377258879) | 15 | 5 | 11 | 29492 | 41 | |||
29624 | 181932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.7426650525628 | -122.49384596323 | (37.7426650525628, -122.49384596323) | 1 | 8 | 3 | 29491 | 35 | |||
29651 | 142950 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 156 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010083.0275 | 2121115.7055 | 37.8047476663275 | -122.409349490891 | (37.8047476663275, -122.409349490891) | 3 | 1 | 10 | 308 | 23 | |||
30141 | 143475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010503.0699 | 2116501.51 | 37.7921017369748 | -122.407570359871 | (37.7921017369748, -122.407570359871) | 5 | 1 | 10 | 28857 | 21 | |||
30158 | 244277 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
30164 | 138611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1711 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6000013.0072 | 2114911.1445 | 37.7871422388637 | -122.443751687038 | (37.7871422388637, -122.443751687038) | 15 | 6 | 1 | 29490 | 31 | |||
30570 | 9642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.434877632371 | (37.7792542228164, -122.434877632371) | 15 | 5 | 11 | 29490 | 41 | |||
30933 | 245077 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | 15 | 5 | 11 | 29492 | 9 |
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) );