trees
11,635 rows where qSpecies_id = 27 sorted by qCaretaker_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 424 | 13666 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 653 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/21/2014 12:00:00 AM | 3 | 4x4 | 6011846.3206496 | 2114969.3004876 | 37.7879697501429 | -122.402814861202 | (37.7879697501429, -122.402814861202) | 12 | 2 | 9 | 28855 | 6 | ||
| 582 | 20409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | |||||||||||||
| 760 | 112380 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3250 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6007972 | 2100641 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | 2 | 4 | 7 | 28859 | 19 | |||
| 898 | 262453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2005 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
| 946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
| 1302 | 14133 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1642X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006458.8907635 | 2109942.5653128 | 37.773865274364 | -122.421097370447 | (37.773865274364, -122.421097370447) | 7 | 2 | 11 | 28852 | 10 | |||
| 1311 | 23384 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1451X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | |||
| 1315 | 13622 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 562 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6012358.74659 | 2115584.5782 | 37.7896877563436 | -122.401085198325 | (37.7896877563436, -122.401085198325) | 4 | 2 | 10 | 28854 | 6 | |||
| 1400 | 23567 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.33723 | 2120589.48411 | 37.8030467266869 | -122.425063628702 | (37.8030467266869, -122.425063628702) | 13 | 9 | 1 | 28858 | 17 | ||
| 1449 | 13614 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6012641.55561 | 2115729.4469 | 37.7901013041673 | -122.400116879409 | (37.7901013041673, -122.400116879409) | 12 | 2 | 9 | 28855 | 6 | |||
| 1524 | 28207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1534 | 28217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
| 1625 | 27599 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2012 12:00:00 AM | 30 | 4X4 | Permit Number 769284 | 6014195.968415 | 2117306.152584 | 37.7945171162452 | -122.394849166766 | (37.7945171162452, -122.394849166766) | 4 | 2 | 10 | 28855 | 6 | |
| 1672 | 9818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005621.8341 | 2113520.56064 | 37.783642353453 | -122.424247412091 | (37.783642353453, -122.424247412091) | 7 | 9 | 11 | 28858 | 41 | |||
| 1792 | 195241 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400x Evans Ave | 17 | Median : Yard | Tree | DPW 1 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.385980035973 | (37.7416352733631, -122.385980035973) | 10 | 3 | 8 | 58 | 1 | ||||
| 1862 | 23733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X Webster St | 8 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6003923.026 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | 7 | 9 | 11 | 29490 | 41 | |||
| 1965 | 195920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 15 Baldwin Ct | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 784616 | 6017944.92051 | 2093525.02511 | 37.7294268839465 | -122.380223738131 | (37.7294268839465, -122.380223738131) | 10 | 3 | 8 | 58 | 1 | ||
| 2053 | 9801 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005681.92309 | 2113158.17696 | 37.7826507298416 | -122.424013748222 | (37.7826507298416, -122.424013748222) | 7 | 9 | 11 | 28858 | 41 | |||
| 2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
| 2097 | 12450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
| 2131 | 140415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6003782.7679 | 2112770.1424 | 37.7814778785376 | -122.430556314217 | (37.7814778785376, -122.430556314217) | 15 | 9 | 11 | 29490 | 41 | |||
| 2468 | 14078 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007428.1196287 | 2110750.9276325 | 37.7761394345379 | -122.417801951992 | (37.7761394345379, -122.417801951992) | 8 | 2 | 9 | 28853 | 34 | |||
| 2564 | 20333 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
| 2807 | 195472 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 450x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 7 | 6014582.56054 | 2117381.49578 | 37.7947454787808 | -122.393516774681 | (37.7947454787808, -122.393516774681) | 12 | 2 | 10 | 28860 | 6 | ||||
| 2888 | 13930 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1095 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1994 12:00:00 AM | 12 | 4X4 | 6009061.9861 | 2112312.9703 | 37.7805202452284 | -122.412260375327 | (37.7805202452284, -122.412260375327) | 14 | 2 | 9 | 28853 | 34 | ||
| 2923 | 138606 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725 CALIFORNIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6001407.3919 | 2115257.3022 | 37.7881721314677 | -122.438952247661 | (37.7881721314677, -122.438952247661) | 13 | 6 | 1 | 29490 | 27 | |||
| 2924 | 23991 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 288 West Portal Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5992343.1525 | 2097239.1889 | 37.7381792665746 | -122.469000905839 | (37.7381792665746, -122.469000905839) | 1 | 8 | 4 | 59 | 40 | |||
| 2955 | 13425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.52143 | 37.7942082021958 | -122.394990759026 | (37.7942082021958, -122.394990759026) | 12 | 2 | 9 | 28855 | 6 | ||
| 2964 | 22868 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993173.81508 | 2098252.95685 | 37.7410107778213 | -122.466202563499 | (37.7410107778213, -122.466202563499) | 1 | 8 | 4 | 59 | 40 | |||
| 3126 | 14303 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2175 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/2011 12:00:00 AM | 3 | 4x4 | 6003769.4342 | 2107258.5983 | 37.7663437768339 | -122.430209120484 | (37.7663437768339, -122.430209120484) | 8 | 4 | 5 | 28862 | 3 | ||
| 3144 | 113684 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
| 3352 | 20327 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 3544 | 79352 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | 15 | 6 | 1 | 29490 | 31 | ||
| 3709 | 33773 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2640 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/23/1996 12:00:00 AM | 12 | Permit Number 37820 | 5999639.77056 | 2117940.89784 | 37.7954398489265 | -122.44526091526 | (37.7954398489265, -122.44526091526) | 13 | 9 | 1 | 57 | 17 | |
| 3786 | 24010 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 398 West Portal Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5991871.0543 | 2096731.9947 | 37.7367593513498 | -122.470596240632 | (37.7367593513498, -122.470596240632) | 1 | 8 | 4 | 59 | 40 | |||
| 3858 | 23985 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5992667.0832 | 2097455.8503 | 37.7387928750296 | -122.467896678698 | (37.7387928750296, -122.467896678698) | 1 | 8 | 4 | 59 | 40 | |||
| 3864 | 2928 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1834 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005568.20527 | 2115901.70542 | 37.7901773571486 | -122.424602385305 | (37.7901773571486, -122.424602385305) | 13 | 9 | 1 | 28858 | 27 | |||
| 3979 | 13887 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6009423.70824 | 2112763.96692 | 37.7817788655291 | -122.411040866943 | (37.7817788655291, -122.411040866943) | 14 | 2 | 9 | 28852 | 36 | |||
| 4097 | 28336 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3211 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006589.4855 | 2099557.2485 | 37.7453569717428 | -122.419908520735 | (37.7453569717428, -122.419908520735) | 2 | 7 | 7 | 28859 | 2 | ||
| 4180 | 9858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1333 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005469.60975 | 2114245.25494 | 37.7856235881709 | -122.42482562463 | (37.7856235881709, -122.42482562463) | 13 | 9 | 11 | 28858 | 13 | |||
| 4186 | 133880 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | Permit Number 782825 | 5999941.97757 | 2117109.13743 | 37.7931733001669 | -122.444155434443 | (37.7931733001669, -122.444155434443) | 13 | 9 | 1 | 57 | 27 | ||
| 4354 | 20459 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 495X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 4440 | 27355 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1199 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006390.54447 | 2114591.44108 | 37.7866261028977 | -122.421664048525 | (37.7866261028977, -122.421664048525) | 13 | 9 | 1 | 28858 | 41 | |||
| 4452 | 3272 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4348 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994072.39789 | 2114299.50249 | 37.7851222112183 | -122.464260315544 | (37.7851222112183, -122.464260315544) | 11 | 6 | 1 | 54 | 11 | |||
| 4518 | 135591 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 6 | Width 7ft | 6013668.97989 | 2117535.62616 | 37.7951178808501 | -122.39668872043 | (37.7951178808501, -122.39668872043) | 4 | 1 | 10 | 28860 | 6 | |||
| 4653 | 14253 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2027 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004609.8473746 | 2108045.1512359 | 37.7685510269095 | -122.427358323998 | (37.7685510269095, -122.427358323998) | 8 | 4 | 5 | 28862 | 3 | |||
| 4697 | 6221 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1215 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6004907.86299 | 2113226.00352 | 37.7827932325916 | -122.426696498216 | (37.7827932325916, -122.426696498216) | 7 | 9 | 11 | 28858 | 41 | |||
| 4804 | 3777 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 Carpenter Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6016649.2597904 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | 10 | 3 | 8 | 58 | 1 | ||
| 4901 | 23987 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5992682.0839 | 2097477.0777 | 37.7388520263377 | -122.467846357266 | (37.7388520263377, -122.467846357266) | 1 | 8 | 4 | 59 | 40 | |||
| 4952 | 20349 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8 | |||||||||||||
| 5005 | 2976 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2187 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X2 | 6003939.8571 | 2115601.6948 | 37.7892615083399 | -122.430214930957 | (37.7892615083399, -122.430214930957) | 13 | 9 | 11 | 29490 | 27 | |||
| 5191 | 13827 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 964 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6009845.6649 | 2113195.3529 | 37.7829870022194 | -122.409611544992 | (37.7829870022194, -122.409611544992) | 14 | 2 | 9 | 28852 | 36 | |||
| 5256 | 20347 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 103X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8 | |||||||||||||
| 5863 | 18680 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 150X Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 15X15TR | 5999310.28796 | 2119651.54595 | 37.8001180187875 | -122.446524108406 | (37.8001180187875, -122.446524108406) | 13 | 9 | 1 | 57 | 17 | |||
| 5990 | 262465 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 0ft | 6001363.6521 | 2115250.4856 | 37.7881509261214 | -122.439103090842 | (37.7881509261214, -122.439103090842) | 13 | 6 | 1 | 29490 | 27 | ||||
| 6062 | 13434 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014136.36792 | 2117295.16476 | 37.7944836321678 | -122.395054623492 | (37.7944836321678, -122.395054623492) | 4 | 2 | 10 | 28855 | 6 | |||
| 6259 | 235602 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006265.75168 | 2105377.56697 | 37.7613199823389 | -122.421441210755 | (37.7613199823389, -122.421441210755) | 2 | 4 | 7 | 28859 | 19 | |||
| 6327 | 28873 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240 02nd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013332.85473 | 2114278.45679 | 37.7861557436438 | -122.397623212266 | (37.7861557436438, -122.397623212266) | 6 | 2 | 9 | 28855 | 6 | ||
| 6607 | 28204 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 6666 | 23307 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.62329 | 2114014.00443 | 37.7850491782092 | -122.421096875635 | (37.7850491782092, -122.421096875635) | 13 | 9 | 9 | 28858 | 36 | ||
| 6732 | 195683 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102x King St | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 10ft | 6015319.49651 | 2111685.54707 | 37.7791466227626 | -122.390568648644 | (37.7791466227626, -122.390568648644) | 6 | 2 | 9 | 28856 | 20 | |||
| 6782 | 14365 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2303X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002920.8566764 | 2106445.7230585 | 37.7640637191913 | -122.433086104861 | (37.7640637191913, -122.433086104861) | 15 | 4 | 5 | 28862 | 3 | |||
| 6860 | 262588 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725 CALIFORNIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 0ft | 6001407.3919 | 2115257.3022 | 37.7881721314677 | -122.438952247661 | (37.7881721314677, -122.438952247661) | 13 | 6 | 1 | 29490 | 27 | ||||
| 6960 | 23276 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 819 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 4x4 | 6006534.60812 | 2113350.76252 | 37.7832276265901 | -122.421077496141 | (37.7832276265901, -122.421077496141) | 7 | 9 | 11 | 28858 | 41 | |||
| 7108 | 138604 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725 CALIFORNIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6001310.2556 | 2115246.5093 | 37.7881369697943 | -122.439287548045 | (37.7881369697943, -122.439287548045) | 13 | 6 | 1 | 29490 | 27 | |||
| 7181 | 14058 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1390 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6007799.3288 | 2111218.6717 | 37.7774446311696 | -122.416550977219 | (37.7774446311696, -122.416550977219) | 7 | 2 | 9 | 28852 | 36 | |||
| 7212 | 195766 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6014104.38527 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | 6 | 2 | 9 | 310 | 20 | |||
| 7306 | 27309 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 781 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/1999 12:00:00 AM | 12 | 3X3 | 6005059.68985 | 2103819.7907 | 37.7569746209875 | -122.425501607539 | (37.7569746209875, -122.425501607539) | 2 | 4 | 5 | 28859 | 19 | ||
| 7560 | 13858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/1990 12:00:00 AM | 35 | 4X4 | 6009732.8033 | 2112958.8474 | 37.7823312894321 | -122.409985299939 | (37.7823312894321, -122.409985299939) | 14 | 2 | 9 | 28853 | 34 | ||
| 7654 | 254471 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 566x Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012330 | 2115645 | 37.7898520566818 | -122.401188906813 | (37.7898520566818, -122.401188906813) | 4 | 1 | 10 | 28854 | 6 | ||||
| 7860 | 13507 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6013261.04703 | 2116332.20959 | 37.7917908704129 | -122.398015777109 | (37.7917908704129, -122.398015777109) | 12 | 2 | 9 | 28855 | 6 | |||
| 8167 | 103924 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/1995 12:00:00 AM | 4x4 | 6013544.1 | 2119061 | 37.7992992444467 | -122.397227842585 | (37.7992992444467, -122.397227842585) | 1 | 10 | 28860 | 6 | ||||
| 8178 | 13824 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 964 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.409459958667 | (37.7830015179357, -122.409459958667) | 14 | 2 | 9 | 28852 | 36 | |||
| 8205 | 200857 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | 8 | 2 | 9 | 28853 | 34 | ||
| 8431 | 14116 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1564 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006761.0540098 | 2110225.9136176 | 37.7746603099629 | -122.420072248795 | (37.7746603099629, -122.420072248795) | 7 | 2 | 11 | 28852 | 10 | |||
| 8487 | 261462 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015505 | 2111943 | 37.7798638201711 | -122.3899448996 | (37.7798638201711, -122.3899448996) | 6 | 2 | 9 | 28856 | 20 | ||||
| 8508 | 3139 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3320 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5998401.91704 | 2114901.98047 | 37.7870250535005 | -122.449325021743 | (37.7870250535005, -122.449325021743) | 13 | 6 | 1 | 54 | 31 | |||
| 8516 | 21797 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
| 8607 | 23185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 560X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006458.921066 | 2112191.041059 | 37.7800390474075 | -122.421256963785 | (37.7800390474075, -122.421256963785) | 7 | 9 | 11 | 28852 | 41 | |||
| 8674 | 2880 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1477 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007321.86349 | 2116079.14078 | 37.7907634327304 | -122.41854743611 | (37.7907634327304, -122.41854743611) | 13 | 1 | 10 | 28858 | 21 | |||
| 8744 | 261463 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015505 | 2111943 | 37.7798638201711 | -122.3899448996 | (37.7798638201711, -122.3899448996) | 6 | 2 | 9 | 28856 | 20 | ||||
| 8787 | 260968 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2400x 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 9005 | 13638 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 576 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6012273.72895 | 2115490.32209 | 37.7894242082171 | -122.401372725978 | (37.7894242082171, -122.401372725978) | 4 | 2 | 10 | 28854 | 6 | |||
| 9068 | 74830 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 493 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.7979605016561 | -122.405348925503 | (37.7979605016561, -122.405348925503) | 3 | 1 | 10 | 308 | 23 | ||
| 9171 | 2793 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 5000 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 5992060.78894 | 2114166.03609 | 37.784639597517 | -122.471210061358 | (37.784639597517, -122.471210061358) | 11 | 6 | 2 | 54 | 11 | |||
| 9222 | 195471 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 450x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 7 | 6014542.5915 | 2117352.94839 | 37.7946648734448 | -122.393653075045 | (37.7946648734448, -122.393653075045) | 12 | 2 | 10 | 28855 | 6 | ||||
| 9513 | 13556 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 444 Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6013042.6331502 | 2116223.6547442 | 37.7914806373756 | -122.398763872051 | (37.7914806373756, -122.398763872051) | 4 | 2 | 10 | 28860 | 6 | |||
| 9558 | 13935 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1140X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 9637 | 23993 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 288 West Portal Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 5992331.2652 | 2097223.6221 | 37.7381358372367 | -122.469040873258 | (37.7381358372367, -122.469040873258) | 1 | 8 | 4 | 59 | 40 | |||
| 9671 | 13480 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4X4 | 6013615.86639 | 2116768.91037 | 37.7930097035807 | -122.396818723722 | (37.7930097035807, -122.396818723722) | 4 | 2 | 10 | 28860 | 6 | |||
| 9734 | 25567 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Industrial St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | |||
| 9762 | 971 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1599 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4X4 | 6001877.39832 | 2092933.59931 | 37.7269033673725 | -122.435728316515 | (37.7269033673725, -122.435728316515) | 9 | 7 | 6 | 28861 | 25 | |||
| 9820 | 212740 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 230 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5994691.78366 | 2087470.55549 | 37.7114923752566 | -122.460173034569 | (37.7114923752566, -122.460173034569) | 9 | 8 | 6 | 28861 | 24 | |||
| 9857 | 6607 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016551.31949 | 2097860.71449 | 37.7412548295561 | -122.385343601939 | (37.7412548295561, -122.385343601939) | 10 | 3 | 8 | 58 | 1 | ||
| 9898 | 135590 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6013675.90495 | 2117467.1976 | 37.7949303775801 | -122.396659959189 | (37.7949303775801, -122.396659959189) | 4 | 1 | 10 | 28860 | 6 | |||
| 10076 | 16711 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1025X O'Farrell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999244.9950908 | 2112749.8910686 | 37.7811641645517 | -122.446253303314 | (37.7811641645517, -122.446253303314) | 15 | 5 | 1 | 54 | 16 | |||
| 10525 | 3094 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3006 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 5999959.63527 | 2115120.4195 | 37.7877138091859 | -122.443951383666 | (37.7877138091859, -122.443951383666) | 13 | 6 | 1 | 29490 | 27 | |||
| 10568 | 14122 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/07/2011 03:22:00 PM | 2 | 4x4 | 6006469.71168 | 2109964.77137 | 37.7739268568633 | -122.42106151609 | (37.7739268568633, -122.42106151609) | 7 | 2 | 11 | 28852 | 10 | ||
| 10801 | 20411 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 |
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) );