trees
3,965 rows where qSpecies_id = 70 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 | |||||
| 57690 | 6714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 11 | 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 | |||
| 57732 | 24215 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
| 58144 | 175023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011015.66047 | 2087294.85448 | 37.7119353650883 | -122.403740780316 | (37.7119353650883, -122.403740780316) | 9 | 7 | 8 | 309 | 39 | |||
| 58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
| 58804 | 6420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | 10 | 3 | 8 | 58 | 1 | ||
| 59069 | 188565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Mississippi St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6014264.82681 | 2101105.60595 | 37.7500378577781 | -122.393476581286 | (37.7500378577781, -122.393476581286) | 10 | 3 | 8 | 58 | 1 | |||
| 59166 | 200544 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 20 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6016191.0622 | 2095640.0073 | 37.7351372799938 | -122.386434455904 | (37.7351372799938, -122.386434455904) | 10 | 3 | 8 | 58 | 1 | |||
| 59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 59890 | 188662 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 13 | Median : Yard | Tree | DPW 1 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.385064653831 | (37.7449879810223, -122.385064653831) | 10 | 3 | 8 | 58 | 1 | ||||
| 60018 | 187745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 3 | Median : Yard | Tree | DPW 1 | 14 | 6016145.55201 | 2096259.43964 | 37.7368355969845 | -122.386634982516 | (37.7368355969845, -122.386634982516) | 10 | 3 | 8 | 58 | 1 | ||||
| 60216 | 188625 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 23 | : | Tree | Private 2 | 16 | Width 3ft | 6016045.06184 | 2099009.53481 | 37.7443812336116 | -122.387174189957 | (37.7443812336116, -122.387174189957) | 10 | 3 | 8 | 58 | 1 | |||
| 60354 | 188756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6013935.51575 | 2087041.28736 | 37.711401800917 | -122.393631123501 | (37.711401800917, -122.393631123501) | 10 | 3 | 8 | 58 | 1 | |||
| 60668 | 200609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 49 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | 10 | 3 | 8 | 58 | 1 | |||
| 60879 | 6836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | 10 | 3 | 8 | 58 | 1 | ||
| 61212 | 187715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016846.76971 | 2094930.10872 | 37.7332243153459 | -122.384117995955 | (37.7332243153459, -122.384117995955) | 10 | 3 | 8 | 58 | 1 | |||
| 61626 | 188578 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601 Wisconsin St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 6012716.69454 | 2104629.3744 | 37.7596272199442 | -122.399077449262 | (37.7596272199442, -122.399077449262) | 10 | 3 | 8 | 28856 | 29 | |||
| 61906 | 3693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017817.275253 | 2098336.256691 | 37.7426305289053 | -122.380999383309 | (37.7426305289053, -122.380999383309) | 10 | 3 | 8 | 58 | 1 | |||
| 62386 | 187723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 57 Progress St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6016846.42344 | 2095098.5772 | 37.7336868771302 | -122.384130920999 | (37.7336868771302, -122.384130920999) | 10 | 3 | 8 | 58 | 1 | |||
| 62455 | 187749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6018386.68976 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | 10 | 3 | 8 | 58 | 1 | ||||
| 63455 | 188683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6018037.89274 | 2096788.1105 | 37.7383918036295 | -122.380128985564 | (37.7383918036295, -122.380128985564) | 10 | 3 | 8 | 58 | 1 | |||
| 64261 | 110884 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 64263 | 6567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2004 12:00:00 AM | 5 | 3X3 | 6017004.85053 | 2097463.70294 | 37.7401897966309 | -122.383747801739 | (37.7401897966309, -122.383747801739) | 10 | 3 | 8 | 58 | 1 | ||
| 64568 | 188646 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 9 | Median : Yard | Tree | DPW 1 | 5 | 6018092.67534 | 2098102.14022 | 37.7420028892302 | -122.380030855133 | (37.7420028892302, -122.380030855133) | 10 | 3 | 8 | 58 | 1 | ||||
| 64669 | 16531 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
| 64983 | 188602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 5 | : | Tree | Private 2 | 19 | Width 4ft | 6012654.45506 | 2103749.21947 | 37.7572070391022 | -122.39923092128 | (37.7572070391022, -122.39923092128) | 10 | 3 | 8 | 28856 | 29 | |||
| 65297 | 8253 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 GALVEZ AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 10 | 3 | 8 | 58 | 1 | |||
| 66534 | 188607 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6014156.72226 | 2105282.84935 | 37.7615016624873 | -122.394142824244 | (37.7615016624873, -122.394142824244) | 10 | 3 | 8 | 28856 | 29 | |||
| 67366 | 200556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 32 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.386181017716 | (37.734917146653, -122.386181017716) | 10 | 3 | 8 | 58 | 1 | |||
| 67591 | 187716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6016950.63846 | 2094900.99132 | 37.7331501068758 | -122.383756863312 | (37.7331501068758, -122.383756863312) | 10 | 3 | 8 | 58 | 1 | |||
| 67776 | 188594 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Jack Balestreri Way | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | 10 | 3 | 8 | 28856 | 29 | ||||
| 67925 | 175029 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010591.02139 | 2086933.10615 | 37.7109183460773 | -122.405183003288 | (37.7109183460773, -122.405183003288) | 9 | 7 | 8 | 309 | 39 | |||
| 67985 | 187772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1427x Innes Ave | 15 | Median : Yard | Tree | DPW 1 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | 10 | 3 | 8 | 58 | 1 | ||||
| 68498 | 200537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 13 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6016177.7125 | 2095662.3283 | 37.735197829979 | -122.38648216691 | (37.735197829979, -122.38648216691) | 10 | 3 | 8 | 58 | 1 | |||
| 69170 | 24189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
| 70005 | 116118 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x NEWHALL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | 6013898 | 2095214 | 37.7338403506101 | -122.394332641739 | (37.7338403506101, -122.394332641739) | 10 | 3 | 8 | 58 | 1 | ||
| 70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 70466 | 187701 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | 10 | 3 | 8 | 58 | 1 | |||
| 70795 | 106249 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 770844 | 6012059.45728 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | 8 | 3 | 8 | 28856 | 29 | |||
| 71055 | 187717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6016962.05106 | 2094901.44283 | 37.7331519774826 | -122.383717437926 | (37.7331519774826, -122.383717437926) | 10 | 3 | 8 | 58 | 1 | |||
| 71431 | 22127 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
| 71561 | 6553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6017462.04156 | 2097126.15561 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | 10 | 3 | 8 | 58 | 1 | |||
| 71865 | 187756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6018040.44211 | 2093268.12413 | 37.7287267536225 | -122.379875664545 | (37.7287267536225, -122.379875664545) | 10 | 3 | 8 | 58 | 1 | ||||
| 71908 | 87252 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.7098574142528 | -122.414638464087 | (37.7098574142528, -122.414638464087) | 9 | 7 | 8 | 309 | 39 | |||
| 72057 | 187738 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 11 | Median : Yard | Tree | DPW 1 | 16 | 6016145.73454 | 2096191.50071 | 37.7366490605065 | -122.386629615374 | (37.7366490605065, -122.386629615374) | 10 | 3 | 8 | 58 | 1 | ||||
| 72267 | 200610 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 50 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.7338361346818 | -122.385618942498 | (37.7338361346818, -122.385618942498) | 10 | 3 | 8 | 58 | 1 | |||
| 72330 | 188609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 5 | : | Tree | Private 2 | 15 | Width 3ft | 6015915.65511 | 2098586.79243 | 37.7432133029551 | -122.387592167846 | (37.7432133029551, -122.387592167846) | 10 | 3 | 8 | 58 | 1 | |||
| 72380 | 24224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016378.0406117 | 2096157.2731291 | 37.7365679365277 | -122.385824040568 | (37.7365679365277, -122.385824040568) | 10 | 3 | 8 | 58 | 1 | ||
| 73680 | 117162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 2 | Front Yard : Cutout | Tree | Private 2 | DPW | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | ||||
| 74538 | 188584 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 28 | Median : Yard | Tree | DPW 1 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710206 | -122.399788289593 | (37.756276710206, -122.399788289593) | 10 | 3 | 8 | 28856 | 29 | ||||
| 75058 | 187731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016728.56547 | 2095062.09483 | 37.733580186956 | -122.384535854255 | (37.733580186956, -122.384535854255) | 10 | 3 | 8 | 58 | 1 | |||
| 75672 | 188747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 15 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6014639.49411 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | 10 | 3 | 8 | 58 | 1 | |||
| 75803 | 6795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016906.37547 | 2097191.59326 | 37.7394371944809 | -122.384069348045 | (37.7394371944809, -122.384069348045) | 10 | 3 | 8 | 58 | 1 | |||
| 75999 | 3827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 130 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016793.8666003 | 2095959.0590849 | 37.736046682619 | -122.384372537421 | (37.736046682619, -122.384372537421) | 10 | 3 | 8 | 58 | 1 | |||
| 76132 | 1849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011118.84502 | 2087065.06419 | 37.7113101708062 | -122.403367987963 | (37.7113101708062, -122.403367987963) | 10 | 3 | 8 | 309 | 1 | |||
| 76219 | 24174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
| 76377 | 187724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6017001.33944 | 2094943.49204 | 37.7332696078935 | -122.383584532495 | (37.7332696078935, -122.383584532495) | 10 | 3 | 8 | 58 | 1 | |||
| 76427 | 188664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Amador St | 11 | Front Yard : Yard | Tree | Private 2 | 10 | Width 1ft | 6017799.22634 | 2099547.38372 | 37.745955042685 | -122.381145981202 | (37.745955042685, -122.381145981202) | 10 | 3 | 8 | 58 | 1 | |||
| 76510 | 188600 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 2 | : | Tree | Private 2 | 19 | Width 5ft | 6012542.53813 | 2103744.35344 | 37.7571874401736 | -122.399617634271 | (37.7571874401736, -122.399617634271) | 10 | 3 | 8 | 28856 | 29 | |||
| 76607 | 188660 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 22 | 6017087.32908 | 2098898.60664 | 37.7441343103446 | -122.383562491039 | (37.7441343103446, -122.383562491039) | 10 | 3 | 8 | 58 | 1 | ||||
| 77453 | 188727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Executive Park Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6014344.67322 | 2086951.52191 | 37.7111780496084 | -122.39221068479 | (37.7111780496084, -122.39221068479) | 10 | 3 | 8 | 58 | 1 | |||
| 77572 | 188752 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6014065.71388 | 2087031.57567 | 37.7113823683797 | -122.393180442647 | (37.7113823683797, -122.393180442647) | 10 | 3 | 8 | 58 | 1 | |||
| 78574 | 175032 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010498.816 | 2086727.27775 | 37.7103480275041 | -122.405487201665 | (37.7103480275041, -122.405487201665) | 9 | 7 | 8 | 309 | 39 | |||
| 78655 | 6794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.45833 | 2097207.36346 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | 10 | 3 | 8 | 58 | 1 | ||
| 78663 | 200554 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 30 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6016223.9574 | 2095601.7778 | 37.7350341303539 | -122.386318059776 | (37.7350341303539, -122.386318059776) | 10 | 3 | 8 | 58 | 1 | |||
| 79039 | 188649 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x Quesada Ave | 50 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.7342139599052 | -122.393020304839 | (37.7342139599052, -122.393020304839) | 10 | 3 | 8 | 58 | 1 | |||
| 79325 | 22131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
| 79885 | 187734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6016672.47216 | 2095023.06594 | 37.7334699192814 | -122.384727069019 | (37.7334699192814, -122.384727069019) | 10 | 3 | 8 | 58 | 1 | |||
| 81246 | 188635 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6010991.60027 | 2096196.82144 | 37.736376982304 | -122.404450150255 | (37.736376982304, -122.404450150255) | 10 | 3 | 8 | 58 | 1 | ||||
| 81345 | 187714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6016776.4454 | 2094960.14046 | 37.7333028882004 | -122.384363219486 | (37.7333028882004, -122.384363219486) | 10 | 3 | 8 | 58 | 1 | |||
| 81655 | 188698 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 2 | : | Tree | Private 2 | 16 | Width 4ft | 6016460.57689 | 2097987.87635 | 37.7415989695148 | -122.385666221144 | (37.7415989695148, -122.385666221144) | 10 | 3 | 8 | 58 | 1 | |||
| 82161 | 122795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | 14 | 3 | 8 | 28856 | 29 | |||
| 82195 | 188689 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 42 | : | Tree | Private 2 | 11 | Width 3ft | 6017291.85289 | 2097369.22431 | 37.7399462377322 | -122.382748880668 | (37.7399462377322, -122.382748880668) | 10 | 3 | 8 | 58 | 1 | |||
| 82244 | 188707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798 Revere Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6014081.18704 | 2095173.94358 | 37.7337405450892 | -122.393696501513 | (37.7337405450892, -122.393696501513) | 10 | 3 | 8 | 58 | 1 | ||||
| 82358 | 187755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | 10 | 3 | 8 | 58 | 1 | ||||
| 82895 | 6793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 2 | 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 | |||
| 83191 | 3743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 906 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 18 | 18 | 6012418 | 2103694 | 37.7570422378388 | -122.400044801952 | (37.7570422378388, -122.400044801952) | 10 | 3 | 8 | 28856 | 29 | |||
| 83416 | 188587 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 55 | Median : Yard | Tree | DPW 1 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | 10 | 3 | 8 | 28856 | 29 | ||||
| 83674 | 187567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 136 Alpha St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6010892.9605 | 2088110.22572 | 37.7141673547183 | -122.404222218893 | (37.7141673547183, -122.404222218893) | 9 | 7 | 8 | 309 | 39 | |||
| 83950 | 8256 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 GALVEZ AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 10 | 3 | 8 | 58 | 1 | |||
| 84145 | 14997 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1459X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
| 84923 | 17469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050X Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012504.42927 | 2097052.57322 | 37.7388111244659 | -122.399279687607 | (37.7388111244659, -122.399279687607) | 10 | 3 | 8 | 58 | 1 | |||
| 85436 | 6572 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1327 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017100.6753245 | 2097388.5899931 | 37.7399888480471 | -122.383411247575 | (37.7399888480471, -122.383411247575) | 10 | 3 | 8 | 58 | 1 | |||
| 85526 | 188650 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x Quesada Ave | 51 | Median : Yard | Tree | DPW 1 | 8 | 6014234.97615 | 2095377.10029 | 37.734306916536 | -122.393179013597 | (37.734306916536, -122.393179013597) | 10 | 3 | 8 | 58 | 1 | ||||
| 85556 | 24193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
| 85871 | 24225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.40196 | 2094982.30239 | 37.7333853506538 | -122.383013103287 | (37.7333853506538, -122.383013103287) | 10 | 3 | 8 | 58 | 1 | ||
| 86216 | 188746 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 14 | Median : Yard | Tree | DPW 1 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | 10 | 3 | 8 | 58 | 1 | |||
| 86376 | 187709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6013649.01686 | 2087002.29435 | 37.7112788096526 | -122.394618615964 | (37.7112788096526, -122.394618615964) | 10 | 3 | 8 | 58 | 1 | |||
| 86464 | 6772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.54071 | 37.7391349889858 | -122.383547704374 | (37.7391349889858, -122.383547704374) | 10 | 3 | 8 | 58 | 1 | ||
| 87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 87940 | 6594 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6016699.98802 | 2097810.08527 | 37.7411240357598 | -122.384826027706 | (37.7411240357598, -122.384826027706) | 10 | 3 | 8 | 58 | 1 | ||
| 88066 | 6718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 88347 | 175022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010987.76373 | 2087310.02713 | 37.7119754676783 | -122.403838266825 | (37.7119754676783, -122.403838266825) | 9 | 7 | 8 | 309 | 39 | |||
| 89154 | 188755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6013963.90027 | 2087039.17424 | 37.7113975759058 | -122.393532870747 | (37.7113975759058, -122.393532870747) | 10 | 3 | 8 | 58 | 1 | |||
| 89517 | 188722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 67 Jennings Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012907.82508 | 2089194.67107 | 37.7172574063701 | -122.397334024441 | (37.7172574063701, -122.397334024441) | 10 | 3 | 8 | 58 | 1 | |||
| 90387 | 188632 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Charter Oak Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010956.26861 | 2096182.79853 | 37.7363365038229 | -122.404571320413 | (37.7363365038229, -122.404571320413) | 10 | 3 | 8 | 58 | 1 | ||||
| 90425 | 173719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 922 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012422 | 2103621 | 37.7568420188621 | -122.400025841962 | (37.7568420188621, -122.400025841962) | 10 | 3 | 8 | 28856 | 29 | |||
| 91136 | 188624 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 22 | : | Tree | Private 2 | 16 | Width 3ft | 6016039.52279 | 2098990.21434 | 37.7443278768366 | -122.387191995632 | (37.7443278768366, -122.387191995632) | 10 | 3 | 8 | 58 | 1 | |||
| 91179 | 188736 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 4 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | 10 | 3 | 8 | 58 | 1 | |||
| 91391 | 6775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017039.80382 | 2097089.47454 | 37.7391641728912 | -122.383600899281 | (37.7391641728912, -122.383600899281) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );