trees
494 rows where qSpecies_id = 243 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
| 7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
| 11385 | 262470 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Broadmoor Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
| 12365 | 261369 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 48 Bache St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
| 25750 | 253293 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
| 44245 | 110874 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 47809 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | ||||
| 51759 | 114834 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 54834 | 114822 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 61799 | 114838 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 20 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 65999 | 110868 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 73005 | 49014 | Permitted Site 7 | Syzygium paniculatum :: Brush Cherry 243 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
| 79852 | 114825 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 85746 | 253294 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
| 90165 | 114837 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 19 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 91635 | 114828 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 93366 | 114824 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 99283 | 110872 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 102078 | 114823 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 120628 | 114830 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 126627 | 114831 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 13 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 128177 | 114826 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 147592 | 114827 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 147593 | 114821 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 154903 | 114832 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 14 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 161168 | 114820 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 170579 | 256058 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 1983 21st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5989689 | 2101877 | 37.7507597758645 | -122.478516596828 | (37.7507597758645, -122.478516596828) | 1 | 8 | 3 | 29491 | 35 | ||||
| 178799 | 114836 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 18 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 179206 | 114833 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 15 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 181192 | 110873 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 182055 | 114829 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 182265 | 114835 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 17 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 188045 | 114839 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 21 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 194453 | 265096 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194463 | 265099 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194464 | 265097 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194466 | 265098 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 28381 | 136612 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1697 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006706.3991 | 2116349.10339 | 37.7914700147761 | -122.420696089151 | (37.7914700147761, -122.420696089151) | 13 | 9 | 10 | 28858 | 21 | |||
| 31668 | 123333 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 737 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994714.05712 | 2110527.69086 | 37.7748027900674 | -122.461766808811 | (37.7748027900674, -122.461766808811) | 11 | 6 | 2 | 54 | 11 | |||
| 64047 | 136628 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6007442.68945 | 2119347.67651 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | 5 | 1 | 1 | 28858 | 32 | |||
| 98884 | 43333 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 355 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 1 | Permit Number 43090 | 6003660.20851 | 2091489.47516 | 37.723039229671 | -122.429462239795 | (37.723039229671, -122.429462239795) | 9 | 7 | 6 | 28861 | 5 | |
| 175975 | 215249 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5992441.12756 | 2089702.71282 | 37.717491627621 | -122.468114091393 | (37.717491627621, -122.468114091393) | 9 | 8 | 6 | 64 | 24 | |||
| 7239 | 117920 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 727 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983191.607 | 2110832.41366 | 37.7749694365706 | -122.501647249063 | (37.7749694365706, -122.501647249063) | 11 | 6 | 2 | 55 | 26 | |||
| 19921 | 215192 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 199 Lomita Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5991270.56411 | 2104187.78327 | 37.7571962750993 | -122.473215972337 | (37.7571962750993, -122.473215972337) | 1 | 8 | 4 | 56 | 12 | |||
| 20828 | 179697 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1100 Felton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007690.32077 | 2092934.09301 | 37.7272331955512 | -122.415633147958 | (37.7272331955512, -122.415633147958) | 9 | 3 | 7 | 309 | 5 | |||
| 33418 | 138663 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1722 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999590.4442 | 2114811.9884 | 37.7868458713434 | -122.44520652592 | (37.7868458713434, -122.44520652592) | 15 | 6 | 1 | 29490 | 31 | |||
| 34400 | 215259 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 41 | : | Tree | Private 2 | 10 | Width 0ft | 5991333.88736 | 2093532.91422 | 37.7279444054996 | -122.472220318525 | (37.7279444054996, -122.472220318525) | 9 | 8 | 4 | 64 | 40 | |||
| 41588 | 215191 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1762 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993759.89754 | 2103496.87888 | 37.7554430521829 | -122.46455679518 | (37.7554430521829, -122.46455679518) | 1 | 8 | 4 | 56 | 12 | |||
| 49407 | 179631 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 184 Mount Vernon Ave | 11 | Side Yard : Yard | Tree | Private 2 | 10 | 5998932.98787 | 2089405.36091 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | 9 | 7 | 6 | 28861 | 25 | ||||
| 52884 | 197877 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015625.5144 | 2101938.71923 | 37.7524009208729 | -122.388829363409 | (37.7524009208729, -122.388829363409) | 10 | 3 | 8 | 28856 | 1 | |||
| 54191 | 215255 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 4 | : | Tree | Private 2 | 10 | Width 0ft | 5991357.82029 | 2093790.09293 | 37.7286519390174 | -122.472156320955 | (37.7286519390174, -122.472156320955) | 9 | 8 | 4 | 64 | 40 | |||
| 56345 | 179632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5999581.03215 | 2090102.74199 | 37.7189997781048 | -122.443463521241 | (37.7189997781048, -122.443463521241) | 9 | 7 | 6 | 28861 | 25 | |||
| 56675 | 197879 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015633.71658 | 2101939.60961 | 37.7524038202784 | -122.388801060829 | (37.7524038202784, -122.388801060829) | 10 | 3 | 8 | 28856 | 1 | |||
| 60830 | 179647 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001184.8946 | 2089159.50887 | 37.7165012078479 | -122.43785208261 | (37.7165012078479, -122.43785208261) | 9 | 7 | 6 | 28861 | 5 | |||
| 61513 | 215194 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1338 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991837.99672 | 2098448.19702 | 37.7414696955783 | -122.47083551005 | (37.7414696955783, -122.47083551005) | 1 | 8 | 4 | 29491 | 40 | |||
| 72321 | 182264 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1446 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5984975.2043 | 2105354.9525 | 37.7600344747925 | -122.495073506222 | (37.7600344747925, -122.495073506222) | 1 | 8 | 3 | 56 | 35 | |||
| 81066 | 215219 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 450 Wildwood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5995190.90463 | 2093339.70409 | 37.7276363589212 | -122.458872613985 | (37.7276363589212, -122.458872613985) | 9 | 7 | 4 | 28861 | 40 | |||
| 84701 | 215271 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 320 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6000123.05752 | 2094800.74897 | 37.7319303213134 | -122.441926972846 | (37.7319303213134, -122.441926972846) | 9 | 7 | 4 | 63 | 40 | |||
| 88216 | 136632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 745 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010322.48557 | 2116149.01885 | 37.7911237712979 | -122.408170315501 | (37.7911237712979, -122.408170315501) | 5 | 1 | 10 | 28857 | 21 | |||
| 97469 | 179648 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001194.88831 | 2089176.29641 | 37.7165478709616 | -122.437818741162 | (37.7165478709616, -122.437818741162) | 9 | 7 | 6 | 28861 | 5 | |||
| 101440 | 215260 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500 Junipero Serra Blvd | 43 | : | Tree | Private 2 | 10 | Width 0ft | 5991332.77888 | 2093518.51077 | 37.7279047930719 | -122.472223101042 | (37.7279047930719, -122.472223101042) | 9 | 8 | 4 | 64 | 40 | |||
| 116217 | 241043 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 300 Virginia Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006909.48713 | 2098350.81017 | 37.7420623856656 | -122.418716463718 | (37.7420623856656, -122.418716463718) | 2 | 7 | 7 | 28859 | 2 | |||
| 124794 | 136586 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 6002062.37894 | 2118168.81121 | 37.7962036269473 | -122.436894621186 | (37.7962036269473, -122.436894621186) | 13 | 9 | 1 | 57 | 17 | |||
| 135670 | 179774 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6004801.46093 | 2094366.85627 | 37.7310044324123 | -122.425721858672 | (37.7310044324123, -122.425721858672) | 9 | 7 | 6 | 28861 | 5 | |||
| 142870 | 183743 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2275 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987913.6037 | 2099833.6094 | 37.745045935244 | -122.484506134369 | (37.745045935244, -122.484506134369) | 1 | 8 | 3 | 29491 | 35 | |||
| 144169 | 136605 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6002548.49635 | 2121661.6698 | 37.8058217179646 | -122.435462547977 | (37.8058217179646, -122.435462547977) | 13 | 9 | 1 | 57 | 17 | |||
| 152953 | 197878 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 13 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | 10 | 3 | 8 | 28856 | 1 | |||
| 154014 | 107677 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 305 NEVADA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 3x12 | 6008988.2 | 2096819.7 | 37.7379751095359 | -122.411420761527 | (37.7379751095359, -122.411420761527) | 10 | 7 | 7 | 28859 | 2 | |||
| 155477 | 141560 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 6 Loyola Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998459.5845 | 2110762.5456 | 37.7756625423159 | -122.448827231212 | (37.7756625423159, -122.448827231212) | 15 | 6 | 2 | 29492 | 16 | |||
| 164644 | 215195 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1338 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991851.77667 | 2098448.73773 | 37.7414719771425 | -122.470787903551 | (37.7414719771425, -122.470787903551) | 1 | 8 | 4 | 29491 | 40 | |||
| 168902 | 197889 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1098 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012673.3872 | 2089947.03209 | 37.7193101835929 | -122.398197126321 | (37.7193101835929, -122.398197126321) | 10 | 3 | 8 | 58 | 1 | |||
| 184319 | 179702 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1142 Silliman St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007383.53994 | 2093322.51563 | 37.7282824705509 | -122.416721195428 | (37.7282824705509, -122.416721195428) | 9 | 3 | 7 | 309 | 5 | |||
| 184740 | 179655 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6002626.5609 | 2090458.35615 | 37.7201494291437 | -122.432961716828 | (37.7201494291437, -122.432961716828) | 9 | 7 | 6 | 28861 | 5 | |||
| 188996 | 179661 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6012216.37842 | 2087780.43205 | 37.7133356679799 | -122.399624805455 | (37.7133356679799, -122.399624805455) | 10 | 3 | 8 | 309 | 1 | ||||
| 189136 | 215199 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992542.93884 | 2098523.05362 | 37.7417159758263 | -122.468403529221 | (37.7417159758263, -122.468403529221) | 1 | 8 | 4 | 59 | 40 | |||
| 191117 | 179772 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6004808.00576 | 2094366.06815 | 37.7310026382465 | -122.425699176002 | (37.7310026382465, -122.425699176002) | 9 | 7 | 6 | 28861 | 5 | |||
| 27104 | 136613 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1163 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008339.99161 | 2115873.76917 | 37.7902567978586 | -122.415010210055 | (37.7902567978586, -122.415010210055) | 5 | 1 | 10 | 28858 | 21 | |||
| 50773 | 119519 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986356.00779 | 2110632.67523 | 37.7746063664364 | -122.490686358973 | (37.7746063664364, -122.490686358973) | 11 | 6 | 2 | 55 | 26 | |||
| 51547 | 197881 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.7524092333136 | -122.388757586711 | (37.7524092333136, -122.388757586711) | 10 | 3 | 8 | 28856 | 1 | |||
| 55198 | 136607 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 4 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6002552.02607 | 2121667.51893 | 37.8058379785924 | -122.435450751546 | (37.8058379785924, -122.435450751546) | 13 | 9 | 1 | 57 | 17 | |||
| 72318 | 179757 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004862.37214 | 2094361.68258 | 37.7309936684225 | -122.425510910124 | (37.7309936684225, -122.425510910124) | 9 | 7 | 6 | 28861 | 5 | |||
| 94234 | 179656 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002583.76122 | 2090389.8333 | 37.7199588528956 | -122.433104767489 | (37.7199588528956, -122.433104767489) | 9 | 7 | 6 | 28861 | 5 | |||
| 111968 | 120218 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 366 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5988110.64493 | 2113522.23122 | 37.7826426136883 | -122.484828820519 | (37.7826426136883, -122.484828820519) | 11 | 6 | 2 | 55 | 26 | |||
| 115658 | 215241 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 978 Capitol Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 5995069.40558 | 2090424.49054 | 37.7196248968642 | -122.459081637134 | (37.7196248968642, -122.459081637134) | 9 | 8 | 6 | 28861 | 24 | |||
| 134267 | 215196 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992533.67584 | 2098495.57326 | 37.7416399866861 | -122.46843355846 | (37.7416399866861, -122.46843355846) | 1 | 8 | 4 | 59 | 40 | |||
| 138393 | 179737 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004916.3191 | 2094358.17697 | 37.7309870907763 | -122.425324156893 | (37.7309870907763, -122.425324156893) | 9 | 7 | 6 | 28861 | 5 | |||
| 138750 | 215223 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 496 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993599.22522 | 2101913.15714 | 37.7510852954735 | -122.464997428798 | (37.7510852954735, -122.464997428798) | 1 | 8 | 4 | 29491 | 12 | |||
| 143536 | 179782 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6004777.69099 | 2094370.17663 | 37.7310122061496 | -122.425804271672 | (37.7310122061496, -122.425804271672) | 9 | 7 | 6 | 28861 | 5 | ||||
| 165620 | 139522 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 715 CENTRAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999600.0854 | 2110958.1291 | 37.7762647192657 | -122.444896033282 | (37.7762647192657, -122.444896033282) | 15 | 5 | 11 | 29492 | 16 | |||
| 170109 | 179721 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004972.55508 | 2094359.63328 | 37.7309942664727 | -122.42512984309 | (37.7309942664727, -122.42512984309) | 9 | 7 | 6 | 28861 | 5 | |||
| 191245 | 215198 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 91 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992537.09615 | 2098513.66333 | 37.7416898549923 | -122.468423048099 | (37.7416898549923, -122.468423048099) | 1 | 8 | 4 | 59 | 40 | |||
| 10501 | 136602 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3698 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6002136.39741 | 2121144.63129 | 37.8043786541109 | -122.436851639901 | (37.8043786541109, -122.436851639901) | 13 | 9 | 1 | 57 | 17 | |||
| 22938 | 179742 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004901.02549 | 2094358.92727 | 37.7309882868812 | -122.425377082885 | (37.7309882868812, -122.425377082885) | 9 | 7 | 6 | 28861 | 5 | |||
| 23365 | 179763 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6004845.97197 | 2094361.80258 | 37.7309930712551 | -122.425567616849 | (37.7309930712551, -122.425567616849) | 9 | 7 | 6 | 28861 | 5 | |||
| 31527 | 241022 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 612 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001940.95583 | 2099448.41005 | 37.7447951429899 | -122.435974564372 | (37.7447951429899, -122.435974564372) | 2 | 7 | 5 | 63 | 22 | |||
| 33313 | 15991 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 236 Moncada Way | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | 9 | 8 | 4 | 59 | 40 |
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) );