trees
1,381 rows where qSpecies_id = 54 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37528 | 13212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2190 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001925.0681 | 2119471.9545 | 37.7997739121356 | -122.437463108341 | (37.7997739121356, -122.437463108341) | 13 | 9 | 1 | 57 | 17 | |||
37790 | 142634 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009751.1154 | 2121551.1896 | 37.8059247953292 | -122.410528881628 | (37.8059247953292, -122.410528881628) | 3 | 1 | 10 | 308 | 23 | |||
37814 | 13181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | 13 | 9 | 1 | 57 | 17 | |||
37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
37910 | 244243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005806.4217 | 2110019.2116 | 37.7740389237303 | -122.423359820085 | (37.7740389237303, -122.423359820085) | 7 | 9 | 11 | 28852 | 10 | |||
38110 | 138007 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.430355290708 | (37.7863960226531, -122.430355290708) | 13 | 9 | 11 | 29490 | 13 | |||
38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
38278 | 32778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.7754918376538 | -122.439679097651 | (37.7754918376538, -122.439679097651) | 15 | 5 | 11 | 29492 | 10 | |
38313 | 31337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 16 | 6x18 | Permit Number 34951 | 6004453.62375 | 2111092.99154 | 37.7769108173179 | -122.428115918737 | (37.7769108173179, -122.428115918737) | 7 | 9 | 11 | 28852 | 10 | |
38348 | 142947 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010050.2611 | 2121139.8618 | 37.8048121576562 | -122.40946458873 | (37.8048121576562, -122.40946458873) | 3 | 1 | 10 | 308 | 23 | |||
38413 | 4600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | 3 | 1 | 10 | 308 | 23 | |||
38615 | 98470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | 8 | 3 | 8 | 28853 | 20 | |||
38809 | 140069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005006.5887 | 2111294.3898 | 37.7774950779447 | -122.426217384893 | (37.7774950779447, -122.426217384893) | 7 | 9 | 11 | 28852 | 10 | |||
38889 | 246039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1378 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999138.4966 | 2108392.6745 | 37.7691942805388 | -122.446308196721 | (37.7691942805388, -122.446308196721) | 15 | 5 | 11 | 29492 | 9 | |||
38929 | 138927 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.7759574066142 | -122.431309905462 | (37.7759574066142, -122.431309905462) | 15 | 9 | 11 | 29492 | 10 | |||
39112 | 14585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918 | (37.7700327707282, -122.44520049918) | 15 | 5 | 11 | 29492 | 9 | |||
39177 | 141081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 190 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996587.7084 | 2113030.7088 | 37.7817830987642 | -122.455466443539 | (37.7817830987642, -122.455466443539) | 11 | 6 | 1 | 54 | 31 | |||
39578 | 140070 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 1 | 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 | |||
39581 | 142525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | 3 | 1 | 10 | 308 | 23 | |||
39594 | 245462 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386 | (37.7652781065022, -122.41711768386) | 8 | 4 | 7 | 28853 | 19 | |||
39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
39698 | 17058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.440245097963 | (37.7727028580257, -122.440245097963) | 15 | 5 | 11 | 29492 | 9 | |||
39745 | 142504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | 3 | 1 | 10 | 308 | 23 | ||
40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
40681 | 140585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 FILLMORE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003432.0437 | 2111445.4153 | 37.7778206333488 | -122.431675041477 | (37.7778206333488, -122.431675041477) | 15 | 9 | 11 | 29492 | 41 | |||
40786 | 143180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 37 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010061.0151 | 2121485.1789 | 37.8057609150954 | -122.409451758875 | (37.8057609150954, -122.409451758875) | 3 | 1 | 10 | 308 | 23 | |||
40875 | 138980 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.7761501973749 | -122.432868552462 | (37.7761501973749, -122.432868552462) | 15 | 9 | 11 | 29492 | 10 | |||
40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
41042 | 143548 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2237 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002268.9185 | 2118432.4796 | 37.7969393283412 | -122.4361988317 | (37.7969393283412, -122.4361988317) | 13 | 9 | 1 | 57 | 17 | |||
41460 | 248350 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.450322880989 | (37.7685597685915, -122.450322880989) | 15 | 5 | 11 | 29492 | 9 | |||
41482 | 142934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.405724174807 | (37.7990834099948, -122.405724174807) | 3 | 1 | 10 | 308 | 23 | |||
41596 | 141533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996746.9 | 2111493.597 | 37.7775717277647 | -122.454804626881 | (37.7775717277647, -122.454804626881) | 15 | 6 | 2 | 54 | 16 | |||
41625 | 142631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | 3 | 1 | 10 | 308 | 23 | |||
41667 | 56934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | 13 | 6 | 1 | 29490 | 27 | |
41692 | 138365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.7860352620012 | -122.434254240878 | (37.7860352620012, -122.434254240878) | 13 | 9 | 11 | 29490 | 27 | |||
41771 | 143014 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | 3 | 1 | 10 | 308 | 23 | |||
41892 | 138372 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002563.7609 | 2114481.5252 | 37.7861077705586 | -122.434895911649 | (37.7861077705586, -122.434895911649) | 13 | 9 | 11 | 29490 | 27 | |||
41921 | 141342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.7746107701242 | -122.439364995038 | (37.7746107701242, -122.439364995038) | 15 | 5 | 11 | 29492 | 10 | |||
42028 | 97242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | 10 | 3 | 8 | 58 | 1 | |||
42047 | 97114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.478214246151 | (37.7540855022306, -122.478214246151) | 1 | 8 | 3 | 56 | 35 | |||
42174 | 15298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 6006986.0945 | 2109290.5977 | 37.7721048323796 | -122.419227425547 | (37.7721048323796, -122.419227425547) | 8 | 2 | 9 | 28853 | 19 | ||||
42302 | 16867 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.423214402753 | (37.7748765923478, -122.423214402753) | 7 | 9 | 11 | 28852 | 10 | |||
42465 | 142940 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 318 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010703.4174 | 2118721.6624 | 37.7982089506036 | -122.407033709348 | (37.7982089506036, -122.407033709348) | 3 | 1 | 10 | 308 | 23 | |||
42630 | 199741 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2399 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | 10 | 3 | 8 | 58 | 1 | |||
42890 | 142518 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 420 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010399.3582 | 2119003.2321 | 37.7989650524767 | -122.408105717547 | (37.7989650524767, -122.408105717547) | 3 | 1 | 10 | 308 | 23 | |||
43116 | 18005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.7870944645688 | -122.439833960351 | (37.7870944645688, -122.439833960351) | 13 | 6 | 1 | 29490 | 27 | |||
43162 | 138126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003024.8426 | 2114663.3242 | 37.7866331126192 | -122.433313688795 | (37.7866331126192, -122.433313688795) | 13 | 9 | 11 | 29490 | 27 | |||
43203 | 30704 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.7746039663436 | -122.42535923638 | (37.7746039663436, -122.42535923638) | 7 | 9 | 11 | 28852 | 10 | |
43362 | 13125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | 13 | 9 | 1 | 57 | 17 | ||
43602 | 140542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.7788154803812 | -122.431872959815 | (37.7788154803812, -122.431872959815) | 15 | 9 | 11 | 29490 | 41 | |||
43620 | 12248 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004985.728 | 2110723.6115 | 37.7759266811529 | -122.426248902156 | (37.7759266811529, -122.426248902156) | 7 | 9 | 11 | 28852 | 10 | |||
43753 | 140708 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6002652.7615 | 2110375.0497 | 37.7748374734767 | -122.434294303619 | (37.7748374734767, -122.434294303619) | 15 | 5 | 11 | 29492 | 10 | |||
43809 | 141086 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3370 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5996653.0238 | 2112962.686 | 37.7816000737762 | -122.45523556685 | (37.7816000737762, -122.45523556685) | 11 | 6 | 1 | 54 | 31 | |||
43861 | 111731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | 7 | 9 | 11 | 28852 | 10 | |||
43953 | 138715 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.7855987705543 | -122.445234179741 | (37.7855987705543, -122.445234179741) | 15 | 6 | 1 | 29490 | 31 | |||
44260 | 199854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | 10 | 3 | 8 | 58 | 1 | |||
44629 | 13097 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005336.846 | 2119866.4127 | 37.8010503698402 | -122.42568517574 | (37.8010503698402, -122.42568517574) | 13 | 9 | 1 | 57 | 17 | |||
44783 | 142491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009641.4463 | 2119604.1083 | 37.8005724449635 | -122.410770813978 | (37.8005724449635, -122.410770813978) | 3 | 1 | 10 | 308 | 4 | |||
44948 | 143136 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2679 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999509.2265 | 2119087.2107 | 37.7985798662052 | -122.445795098614 | (37.7985798662052, -122.445795098614) | 13 | 9 | 1 | 57 | 17 | |||
45008 | 246387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | 15 | 5 | 11 | 29492 | 9 | |||
45097 | 138716 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | 15 | 6 | 1 | 29490 | 31 | |||
45477 | 138501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | 13 | 9 | 11 | 29490 | 13 | |||
45674 | 9652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.7734299424642 | -122.42238619159 | (37.7734299424642, -122.42238619159) | 7 | 9 | 11 | 28852 | 10 | ||
45707 | 142945 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 152 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010109.3364 | 2121119.0539 | 37.8047583341863 | -122.409258682298 | (37.8047583341863, -122.409258682298) | 3 | 1 | 10 | 308 | 23 | |||
45716 | 97934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | 3 | 1 | 10 | 308 | 23 | |||
45831 | 140535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003363.1308 | 2111944.3591 | 37.7791867024877 | -122.4319490716 | (37.7791867024877, -122.4319490716) | 15 | 9 | 11 | 29490 | 41 | |||
46162 | 183273 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.499763175358 | (37.7634443416971, -122.499763175358) | 1 | 8 | 3 | 56 | 35 | |||
46211 | 13183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.434578184633 | (37.7999239124366, -122.434578184633) | 13 | 9 | 1 | 57 | 17 | ||
46246 | 143537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.7971774642757 | -122.434327678668 | (37.7971774642757, -122.434327678668) | 13 | 9 | 1 | 57 | 17 | |||
46548 | 87369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | 1 | 8 | 3 | 29491 | 35 | |
46642 | 142949 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010058.1538 | 2121167.8448 | 37.8048894342531 | -122.40943925119 | (37.8048894342531, -122.40943925119) | 3 | 1 | 10 | 308 | 23 | |||
46647 | 494 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.7528808308555 | -122.406751179708 | (37.7528808308555, -122.406751179708) | 10 | 4 | 7 | 28859 | 19 | |||
46663 | 246098 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.453299429572 | (37.7684784553517, -122.453299429572) | 15 | 5 | 11 | 29492 | 9 | |||
46681 | 15435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | 8 | 4 | 7 | 28859 | 19 | |||
46831 | 140683 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.7742417384078 | -122.451736704617 | (37.7742417384078, -122.451736704617) | 15 | 5 | 2 | 29492 | 16 | |||
46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
47044 | 246126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998264.229 | 2108270.3316 | 37.7688083880526 | -122.449323411621 | (37.7688083880526, -122.449323411621) | 15 | 5 | 11 | 29492 | 9 | |||
47249 | 13281 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.443329222732 | (37.7990349463185, -122.443329222732) | 13 | 9 | 1 | 57 | 17 | ||
47439 | 137799 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004356.41 | 2115593.3639 | 37.789262218427 | -122.42877311351 | (37.789262218427, -122.42877311351) | 13 | 9 | 11 | 28858 | 27 | |||
47497 | 142605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.415550034395 | (37.8035348717489, -122.415550034395) | 5 | 1 | 10 | 308 | 32 | |||
47498 | 143390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1806 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004317.0708 | 2118762.9621 | 37.7979629017809 | -122.429135313255 | (37.7979629017809, -122.429135313255) | 13 | 9 | 1 | 57 | 17 | |||
47554 | 25267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.460649859339 | (37.7249427634406, -122.460649859339) | 9 | 8 | 4 | 28861 | 40 | |||
47862 | 17675 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.7794417346192 | -122.435215744209 | (37.7794417346192, -122.435215744209) | 15 | 5 | 11 | 29490 | 41 | |||
48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 2 | 7 | 7 | 28859 | 2 | |||
48457 | 4725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | 5 | 1 | 10 | 308 | 23 | |||
48538 | 142516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.405741479105 | (37.7991579346332, -122.405741479105) | 3 | 1 | 10 | 308 | 23 | |||
48547 | 142458 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1450 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000907.3913 | 2110378.0547 | 37.7747465034057 | -122.440332103705 | (37.7747465034057, -122.440332103705) | 15 | 5 | 11 | 29492 | 10 | |||
48736 | 22785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.440094040754 | (37.7793954847522, -122.440094040754) | 15 | 5 | 11 | 29490 | 41 | |||
49221 | 141496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997041.2335 | 2111532.8232 | 37.7776963116019 | -122.453789267371 | (37.7776963116019, -122.453789267371) | 15 | 6 | 2 | 54 | 16 | |||
49360 | 142923 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.405844458331 | (37.7996657782982, -122.405844458331) | 3 | 1 | 10 | 308 | 23 | |||
49426 | 137887 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 38 ORBEN PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003163.7564 | 2115374.888 | 37.788594765883 | -122.432883934493 | (37.788594765883, -122.432883934493) | 13 | 9 | 1 | 29490 | 27 | |||
49487 | 143166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009846.1251 | 2121530.2463 | 37.8058726162247 | -122.410198604722 | (37.8058726162247, -122.410198604722) | 3 | 1 | 10 | 308 | 23 | |||
49603 | 16972 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 780 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003244.9501 | 2110008.9107 | 37.7738657407699 | -122.432219647405 | (37.7738657407699, -122.432219647405) | 15 | 9 | 11 | 29492 | 10 | |||
49867 | 247452 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 913 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002642.725 | 2109874.1732 | 37.7734616212008 | -122.434293205315 | (37.7734616212008, -122.434293205315) | 15 | 5 | 11 | 29492 | 9 | |||
50053 | 140726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 507 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002621.396 | 2110304.4034 | 37.774641715946 | -122.434397751258 | (37.774641715946, -122.434397751258) | 15 | 5 | 11 | 29492 | 10 | |||
50060 | 248364 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.7687734106589 | -122.448621439577 | (37.7687734106589, -122.448621439577) | 15 | 5 | 11 | 29492 | 9 | |||
50148 | 247386 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1045 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001982.645 | 2109781.521 | 37.773169733383 | -122.436569880602 | (37.773169733383, -122.436569880602) | 15 | 5 | 11 | 29492 | 9 | |||
50167 | 244530 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258947 | (37.7701388371467, -122.44703258947) | 15 | 5 | 11 | 29492 | 9 | |||
50205 | 244507 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 480 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003680.127 | 2109976.8678 | 37.7738024231986 | -122.430712012932 | (37.7738024231986, -122.430712012932) | 7 | 9 | 11 | 29492 | 10 | |||
50284 | 142633 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009714.0145 | 2121546.0367 | 37.8059085667329 | -122.410656911507 | (37.8059085667329, -122.410656911507) | 3 | 1 | 10 | 308 | 23 |
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) );