trees
1,626 rows where qSpecies_id = 53 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
60447 | 20241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
60815 | 14812 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1190X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003455.90906 | 2111772.60341 | 37.7787203633271 | -122.431615848033 | (37.7787203633271, -122.431615848033) | 15 | 9 | 11 | 29490 | 41 | |||
61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
61417 | 7288 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1860 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003020.21181 | 2114689.03027 | 37.7867034322579 | -122.433331547756 | (37.7867034322579, -122.433331547756) | 13 | 9 | 11 | 29490 | 27 | |||
61483 | 17037 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | 15 | 5 | 11 | 29492 | 10 | |||
61535 | 5622 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.7500355321086 | -122.425175538874 | (37.7500355321086, -122.425175538874) | 2 | 4 | 5 | 28862 | 22 | |||
61629 | 117600 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 565 39TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983700 | 2111975 | 37.7781364952795 | -122.499973114435 | (37.7781364952795, -122.499973114435) | 11 | 6 | 2 | 55 | 26 | |||
61909 | 7229 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
62158 | 20114 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
62202 | 23539 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6005738.98285 | 2119846.6704 | 37.8010188777475 | -122.424292203059 | (37.8010188777475, -122.424292203059) | 13 | 9 | 1 | 28858 | 32 | |||
62418 | 2714 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003185.15216 | 2114858.41892 | 37.7871778864418 | -122.432772999031 | (37.7871778864418, -122.432772999031) | 13 | 9 | 11 | 29490 | 27 | |||
62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 | |||
63433 | 4418 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004420.05713 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | 2 | 4 | 5 | 28862 | 22 | |||
63549 | 18006 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2700X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
63919 | 20972 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
64595 | 20258 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x8 | 6009991.46116 | 2120547.45752 | 37.8031822677113 | -122.409626234652 | (37.8031822677113, -122.409626234652) | 3 | 1 | 10 | 308 | 23 | |||
64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
64749 | 17324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
65216 | 23529 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005762.85494 | 2119704.71005 | 37.8006304387912 | -122.42419949344 | (37.8006304387912, -122.42419949344) | 13 | 9 | 1 | 28858 | 32 | |||
65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
66600 | 17310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
66815 | 23796 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1133 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003746.01833 | 2112690.85168 | 37.7812580840725 | -122.430677790145 | (37.7812580840725, -122.430677790145) | 15 | 9 | 11 | 29490 | 41 | |||
66858 | 173948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999106 | 2105162 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | 15 | 5 | 5 | 28862 | 3 | ||||
67556 | 9975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
67743 | 26950 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6002695.46817 | 2114444.00008 | 37.7860122131882 | -122.434437556188 | (37.7860122131882, -122.434437556188) | 13 | 9 | 11 | 29490 | 27 | |||
67817 | 16940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
68956 | 16394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 41 | |||
69533 | 8763 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
70053 | 15430 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006871.65728 | 2105982.3734 | 37.7630147835921 | -122.419388541195 | (37.7630147835921, -122.419388541195) | 8 | 4 | 7 | 28859 | 19 | |||
70074 | 173891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
70974 | 23955 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | |||
71007 | 116518 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 480 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2016 12:00:00 AM | 3 | 9x6 | 6003703 | 2109976 | 37.7738013362642 | -122.430632829648 | (37.7738013362642, -122.430632829648) | 7 | 9 | 11 | 29492 | 10 | ||
71188 | 4619 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6010602.31813 | 2118839.00805 | 37.7985254951528 | -122.407391821594 | (37.7985254951528, -122.407391821594) | 3 | 1 | 10 | 308 | 23 | |||
72154 | 17321 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
72411 | 15256 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007417.64852 | 2109947.83449 | 37.7739337430824 | -122.417781236147 | (37.7739337430824, -122.417781236147) | 8 | 2 | 9 | 28853 | 19 | |||
72584 | 16863 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005958.79101 | 2110336.37823 | 37.774918385113 | -122.422855293382 | (37.774918385113, -122.422855293382) | 7 | 9 | 11 | 28852 | 10 | |||
72688 | 124729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 198X Division St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
72828 | 18316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
73104 | 5386 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
73509 | 21808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
73677 | 18366 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010418.5901612 | 2105518.9759028 | 37.7619415321313 | -122.407088188566 | (37.7619415321313, -122.407088188566) | 8 | 4 | 8 | 28859 | 19 | |||
74073 | 7223 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | 15 | 9 | 11 | 29490 | 41 | |||
74171 | 110682 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 370 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x4 | 6011146.7308 | 2119712.42854 | 37.8009541508763 | -122.405569522927 | (37.8009541508763, -122.405569522927) | 3 | 1 | 10 | 308 | 23 | |||
74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
75176 | 173949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999102 | 2105133 | 37.7602419475954 | -122.446199926833 | (37.7602419475954, -122.446199926833) | 15 | 5 | 5 | 28862 | 3 | ||||
75232 | 18306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
75386 | 23542 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005753.45253 | 2119744.59142 | 37.8007394119615 | -122.424234867659 | (37.8007394119615, -122.424234867659) | 13 | 9 | 1 | 28858 | 32 | |||
75688 | 6379 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
75844 | 13307 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
76207 | 127218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 7 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999923.49955 | 2117118.25276 | 37.7931972742965 | -122.44422002466 | (37.7931972742965, -122.44422002466) | 13 | 9 | 1 | 57 | 27 | ||
77397 | 16979 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6003018.00984 | 2109974.66323 | 37.7737588358485 | -122.43300222285 | (37.7737588358485, -122.43300222285) | 15 | 5 | 11 | 29492 | 10 | |||
77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
77688 | 1668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
77697 | 26275 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1770 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185 | 37.7293969298827 | -122.439434969516 | (37.7293969298827, -122.439434969516) | 9 | 7 | 6 | 28861 | 25 | |||
77847 | 13285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
77904 | 56931 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.69798 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | 13 | 9 | 1 | 28858 | 27 | ||
77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
77953 | 4657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
78216 | 148688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55 Sherman St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 10ft | 6010825.81515 | 2110877.63025 | 37.7766779522549 | -122.406057277416 | (37.7766779522549, -122.406057277416) | 14 | 2 | 9 | 28853 | 34 | |||
78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
78906 | 7228 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
79190 | 7215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
79332 | 124728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 198X Division St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
79632 | 20975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
79839 | 20974 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
79861 | 649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
79887 | 16728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
79982 | 628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | 2 | 4 | 7 | 28859 | 19 | |||
80201 | 20122 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
80355 | 588 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | 2 | 4 | 7 | 28859 | 19 | |||
80775 | 15434 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2137 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006871.30054 | 2105936.92899 | 37.7628899837695 | -122.419386550959 | (37.7628899837695, -122.419386550959) | 8 | 4 | 7 | 28859 | 19 | |||
80780 | 9576 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003446.27659 | 2112118.33325 | 37.7796691054144 | -122.431673860699 | (37.7796691054144, -122.431673860699) | 15 | 9 | 11 | 29490 | 41 | |||
81527 | 26942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x5 | 6002862.4862 | 2114464.90765 | 37.7860790992099 | -122.433861214618 | (37.7860790992099, -122.433861214618) | 13 | 9 | 11 | 29490 | 27 | |||
81673 | 21749 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002560.9316389 | 2114541.9034523 | 37.786273393243 | -122.434910019678 | (37.786273393243, -122.434910019678) | 13 | 9 | 11 | 29490 | 27 | |||
81976 | 7711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 43 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006508.0978555 | 2110273.8315465 | 37.7747776257034 | -122.420950679235 | (37.7747776257034, -122.420950679235) | 7 | 9 | 11 | 28852 | 10 | |||
82016 | 16948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 617 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
82543 | 7221 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
83228 | 28249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
83236 | 7211 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1225X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003292.0475526 | 2111699.258462 | 37.7785096871743 | -122.432177469127 | (37.7785096871743, -122.432177469127) | 15 | 9 | 11 | 29492 | 41 | |||
83435 | 14655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
83755 | 7286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1848 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003026.38997 | 2114635.62779 | 37.7865571530845 | -122.433306355459 | (37.7865571530845, -122.433306355459) | 13 | 9 | 11 | 29490 | 27 | |||
83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
85308 | 631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
85621 | 21994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015909.89309 | 2103367.89889 | 37.7563409047326 | -122.387945645479 | (37.7563409047326, -122.387945645479) | 10 | 3 | 8 | 28856 | 29 | |||
86183 | 645 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
86887 | 94302 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
87320 | 9574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x5 | 6003478.20667 | 2112124.62637 | 37.7796881945834 | -122.431563850171 | (37.7796881945834, -122.431563850171) | 15 | 9 | 11 | 29490 | 41 | |||
87434 | 7222 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003381.12091 | 2111775.83058 | 37.7787249849862 | -122.431874799698 | (37.7787249849862, -122.431874799698) | 15 | 9 | 11 | 29490 | 41 | |||
87620 | 13306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 |
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) );