trees
51 rows where Fire Prevention Districts = 10 and qSpecies_id = 54
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2761 | 199857 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.393250745752 | (37.725186191812, -122.393250745752) | 10 | 3 | 8 | 58 | 1 | |||
| 5364 | 245472 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | 10 | 4 | 7 | 28859 | 19 | |||
| 6447 | 38608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.389473352601 | (37.7313671428977, -122.389473352601) | 10 | 3 | 8 | 58 | 1 | |
| 7684 | 245413 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | 10 | 4 | 7 | 28859 | 19 | |||
| 7692 | 199749 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.391217378098 | (37.7264976449454, -122.391217378098) | 10 | 3 | 8 | 58 | 1 | |||
| 11681 | 245470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.7530025990603 | -122.406625332729 | (37.7530025990603, -122.406625332729) | 10 | 4 | 7 | 28859 | 19 | |||
| 12248 | 245414 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.7529722724302 | -122.40713647447 | (37.7529722724302, -122.40713647447) | 10 | 4 | 7 | 28859 | 19 | |||
| 22206 | 199853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.393042840565 | (37.7254588983374, -122.393042840565) | 10 | 3 | 8 | 58 | 1 | |||
| 23493 | 199735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | 10 | 3 | 8 | 58 | 1 | |||
| 23864 | 38611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | 10 | 3 | 8 | 58 | 1 | |
| 42028 | 97242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | 10 | 3 | 8 | 58 | 1 | |||
| 42630 | 199741 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2399 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | 10 | 3 | 8 | 58 | 1 | |||
| 44260 | 199854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | 10 | 3 | 8 | 58 | 1 | |||
| 46647 | 494 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.7528808308555 | -122.406751179708 | (37.7528808308555, -122.406751179708) | 10 | 4 | 7 | 28859 | 19 | |||
| 57000 | 199732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | 10 | 3 | 8 | 58 | 1 | |||
| 57901 | 492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010397.1581 | 2102215.0511 | 37.7528684941587 | -122.406929439613 | (37.7528684941587, -122.406929439613) | 10 | 4 | 7 | 28859 | 19 | |||
| 61537 | 487 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | 10 | 4 | 7 | 28859 | 19 | |||
| 62896 | 199856 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.7252388819994 | -122.393199428445 | (37.7252388819994, -122.393199428445) | 10 | 3 | 8 | 58 | 1 | |||
| 64608 | 245471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | 10 | 4 | 7 | 28859 | 19 | |||
| 65580 | 199722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015093.5789 | 2092222.3792 | 37.72569234746 | -122.38999022092 | (37.72569234746, -122.38999022092) | 10 | 3 | 8 | 58 | 1 | |||
| 65948 | 497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.7528893415843 | -122.406517264254 | (37.7528893415843, -122.406517264254) | 10 | 4 | 7 | 28859 | 19 | |||
| 70044 | 38609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | 10 | 3 | 8 | 58 | 1 | |
| 75827 | 38610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.389546708337 | (37.7314112587254, -122.389546708337) | 10 | 3 | 8 | 58 | 1 | |
| 80537 | 199852 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | 10 | 3 | 8 | 58 | 1 | |||
| 80916 | 481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.7530114675552 | -122.406564050249 | (37.7530114675552, -122.406564050249) | 10 | 4 | 7 | 28859 | 19 | |||
| 82719 | 200689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.7351613961063 | -122.390444284047 | (37.7351613961063, -122.390444284047) | 10 | 3 | 8 | 58 | 1 | |||
| 84858 | 199734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | 10 | 3 | 8 | 58 | 1 | |||
| 85967 | 199730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014897.5638 | 2092133.7733 | 37.725438180339 | -122.390661646389 | (37.725438180339, -122.390661646389) | 10 | 3 | 8 | 58 | 1 | |||
| 86084 | 199739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014497.7489 | 2092432.2899 | 37.7262356573725 | -122.392064648003 | (37.7262356573725, -122.392064648003) | 10 | 3 | 8 | 58 | 1 | |||
| 86641 | 199738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014531.8139 | 2092406.2929 | 37.7261661660829 | -122.39194506905 | (37.7261661660829, -122.39194506905) | 10 | 3 | 8 | 58 | 1 | |||
| 88983 | 200684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1618 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6015017.6376 | 2095531.4827 | 37.7347742678836 | -122.390483861704 | (37.7347742678836, -122.390483861704) | 10 | 3 | 8 | 58 | 1 | |||
| 95718 | 97243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.386255822187 | (37.7329857540551, -122.386255822187) | 10 | 3 | 8 | 58 | 1 | |||
| 105727 | 199855 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2507 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014175.0737 | 2092094.9381 | 37.7252914365514 | -122.393156532831 | (37.7252914365514, -122.393156532831) | 10 | 3 | 8 | 58 | 1 | |||
| 108876 | 199858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | 10 | 3 | 8 | 58 | 1 | |||
| 109427 | 199728 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014985.6871 | 2092077.3996 | 37.725288278052 | -122.390353072543 | (37.725288278052, -122.390353072543) | 10 | 3 | 8 | 58 | 1 | |||
| 113982 | 97244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.386291808735 | (37.7329489559822, -122.386291808735) | 10 | 3 | 8 | 58 | 1 | |||
| 122068 | 200196 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1124 Fitzgerald Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 6015063.1024 | 2090263.455 | 37.720311838731 | -122.389958798873 | (37.720311838731, -122.389958798873) | 10 | 3 | 8 | 58 | 1 | |||
| 122091 | 493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010421.2461 | 2102217.9187 | 37.7528777158138 | -122.406846340514 | (37.7528777158138, -122.406846340514) | 10 | 4 | 7 | 28859 | 19 | |||
| 122229 | 496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | 10 | 4 | 7 | 28859 | 19 | |||
| 133221 | 199982 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | 10 | 3 | 8 | 58 | 1 | |||
| 139603 | 32290 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | 10 | 3 | 8 | 58 | 1 | ||
| 141408 | 199975 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1233 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016858.7319 | 2092693.7716 | 37.7270844364031 | -122.383920974413 | (37.7270844364031, -122.383920974413) | 10 | 3 | 8 | 58 | 1 | |||
| 146069 | 199726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.7254040160333 | -122.390258847729 | (37.7254040160333, -122.390258847729) | 10 | 3 | 8 | 58 | 1 | |||
| 157672 | 199724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015054.2433 | 2092170.681 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | 10 | 3 | 8 | 58 | 1 | |||
| 160447 | 489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.407061147073 | (37.7529750670361, -122.407061147073) | 10 | 4 | 7 | 28859 | 19 | |||
| 163064 | 199721 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015103.6937 | 2092236.9895 | 37.7257330254006 | -122.389956274684 | (37.7257330254006, -122.389956274684) | 10 | 3 | 8 | 58 | 1 | |||
| 165455 | 199757 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1555 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015056.6652 | 2092285.8367 | 37.7258645418149 | -122.390122260939 | (37.7258645418149, -122.390122260939) | 10 | 3 | 8 | 58 | 1 | |||
| 165518 | 32291 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.7229083485403 | -122.3928830953 | (37.7229083485403, -122.3928830953) | 10 | 3 | 8 | 58 | 1 | ||
| 170076 | 199769 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.7260239336289 | -122.383718829233 | (37.7260239336289, -122.383718829233) | 10 | 3 | 8 | 58 | 1 | |||
| 178727 | 199743 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2351 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | 10 | 3 | 8 | 58 | 1 | |||
| 183288 | 491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010371.9231 | 2102214.4775 | 37.7528655070754 | -122.407016666927 | (37.7528655070754, -122.407016666927) | 10 | 4 | 7 | 28859 | 19 |
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) );