54 rows where qSpecies_id = 24 sorted by rowid descending

View and edit SQL

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)
153096 228470 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 245 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004187.12028 2107418.48366 37.766806432287 -122.428775821463 (37.766806432287, -122.428775821463) 8 4 5 28862 3
108139 232395 Permitted Site 7 Hymenosporum flavum :: Sweetshade 24 315 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2018 12:00:00 AM 3 3x3 Permit Number 782341 6003588.27372 2106449.30544 37.7641113916603 -122.43077796144 (37.7641113916603, -122.43077796144) 8 4 5 28862 3
96691 228472 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 227 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004182.38579 2107503.9785 37.7670409125283 -122.428798292811 (37.7670409125283, -122.428798292811) 8 4 5 28862 3
81586 228498 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 450 Church St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6004181.58169 2106402.65123 37.7640168872847 -122.42872255552 (37.7640168872847, -122.42872255552) 8 4 5 28862 3
58353 228497 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 487 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004262.22293 2106063.80962 37.7630910730105 -122.428419488484 (37.7630910730105, -122.428419488484) 8 4 5 28862 3
19414 34455 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1711 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 7   Permit Number 38199 6008299.19736 2118343.4802 37.7970357237711 -122.415326264207 (37.7970357237711, -122.415326264207) 5 1 10 28858 21
19268 240769 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 67 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2016 12:00:00 AM 14 3x3   6002868.86107 2107912.19122 37.7680873339916 -122.433370741063 (37.7680873339916, -122.433370741063) 15 5 5 28862 3
19005 228460 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2625 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6010714.68048 2102241.99741 37.7529602452298 -122.405833280596 (37.7529602452298, -122.405833280596) 10 4 8 28859 19
18695 152862 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 78 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6005240.50344 2104972.86471 37.7601509059491 -122.424958321694 (37.7601509059491, -122.424958321694) 2 4 5 28859 19
18636 220039 Permitted Site 7 Hymenosporum flavum :: Sweetshade 24 819 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 784849 6001009.04844 2102577.75334 37.7533345862464 -122.439421190941 (37.7533345862464, -122.439421190941) 2 4 5 28862 22
17287 223277 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 950 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5999782.99991 2102046.02662 37.751804743197 -122.443622912589 (37.751804743197, -122.443622912589) 2 5 5 63 38
16284 228454 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 6 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009362.10361 2106372.48972 37.7642259068175 -122.410802457572 (37.7642259068175, -122.410802457572) 8 4 7 28859 19
15998 161276 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 578 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6002845.37486 2090276.36856 37.7196621404792 -122.432192361215 (37.7196621404792, -122.432192361215) 9 7 6 28861 5
15765 258114 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 22 Isis St   Sidewalk: Curb side : Cutout Tree DPW 1     3     6008329.87381 2108642.20827 37.7704000939468 -122.414533279126 (37.7704000939468, -122.414533279126) 8 2 9 28853 19
15664 10200 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1213 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/11/1993 12:00:00 AM 12 3x3   6005821.46028 2101837.96868 37.7515760087314 -122.422726279907 (37.7515760087314, -122.422726279907) 2 4 5 28859 19
15404 223295 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 19 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007196.68855 2097540.75873 37.7398543306231 -122.417666007897 (37.7398543306231, -122.417666007897) 2 7 7 28859 2
14737 100258 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 20X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 10:12:00 AM 3 3x3   6015031.62181 2113390.73913 37.7838127201334 -122.391683789074 (37.7838127201334, -122.391683789074) 6 2 9 28856 6
14734 86515 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1217 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2016 01:26:00 PM 3 3x3   5987669.651538 2107004.041134 37.7647197926712 -122.485875869509 (37.7647197926712, -122.485875869509) 1 8 3 56 35
14710 261104 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1700X Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     4x6   6015022 2094381 37.7316155174388 -122.390388421118 (37.7316155174388, -122.390388421118) 10 3 8 58 1
14641 228469 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 251 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004187.68386 2107403.80814 37.7667661687459 -122.428772825825 (37.7667661687459, -122.428772825825) 8 4 5 28862 3
14577 27519 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1212 Guerrero St 10 Sidewalk: Curb side : Cutout Tree DPW 1   06/08/2000 12:00:00 AM 8 3X3   6005760.41969 2101697.87743 37.7511879063069 -122.42292741057 (37.7511879063069, -122.42292741057) 2 4 5 28859 19
13686 170385 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 100 Lyell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2020 12:00:00 AM 3 Width 3ft   6003153.84638 2094356.3459 37.730882331448 -122.431417186961 (37.730882331448, -122.431417186961) 9 7 5 28861 25
13566 228455 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 7 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009383.67351 2106374.02164 37.7642313225287 -122.410727961341 (37.7642313225287, -122.410727961341) 8 4 7 28859 19
13548 127490 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1000 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2019 12:00:00 AM 3 Width 4ft Permit Number 783066 6007656.89689 2115128.36541 37.7881716927058 -122.417320828287 (37.7881716927058, -122.417320828287) 13 1 10 28858 21
13276 190354 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 20 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 10:20:00 AM 3 Width 3ft   6015003.991 2113364.09082 37.7837380161259 -122.391777518225 (37.7837380161259, -122.391777518225) 6 2 9 28856 6
13017 170386 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 100 Lyell St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003168.63891 2094316.61158 37.7307740683503 -122.431363211466 (37.7307740683503, -122.431363211466) 9 7 5 28861 25
12304 27514 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1212 Guerrero St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2000 12:00:00 AM 8 3X3   6005755.80226 2101784.51034 37.7514255197779 -122.422949534811 (37.7514255197779, -122.422949534811) 2 4 5 28859 19
12302 190355 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 20 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 10:16:00 AM 3 Width 3ft   6014990.18738 2113351.33782 37.7837022330098 -122.391824381909 (37.7837022330098, -122.391824381909) 6 2 9 28856 6
12029 228453 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009339.05918 2106371.48119 37.7642218454873 -122.410882090759 (37.7642218454873, -122.410882090759) 8 4 7 28859 19
11788 6761 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1275 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   05/01/2019 12:00:00 AM 3 3x3   6017199.30801 2096970.01555 37.738844977413 -122.383041088382 (37.738844977413, -122.383041088382) 10 3 8 58 1
11192 6765 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1275 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 01:37:00 PM 3 3x3   6017282.82119 2096909.09011 37.7386823026365 -122.382748097356 (37.7386823026365, -122.382748097356) 10 3 8 58 1
9618 228457 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009423.8763 2106376.92574 37.7642415505399 -122.410589115888 (37.7642415505399, -122.410589115888) 8 4 7 28859 19
9520 261605 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 78 Oakwood St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005240.53391 2104991.58672 37.7602023138964 -122.424959548361 (37.7602023138964, -122.424959548361) 2 4 5 28859 19
8288 152864 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 78 Oakwood St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6005243.87966 2104930.05152 37.7600335417272 -122.424943598861 (37.7600335417272, -122.424943598861) 2 4 5 28859 19
8198 190353 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 20 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 10:24:00 AM 3 Width 3ft   6015020.15445 2113379.99675 37.7837825874477 -122.391722710829 (37.7837825874477, -122.391722710829) 6 2 9 28856 6
8165 190352 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 8 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 10:28:00 AM 3 Width 2ft   6015093.65836 2113449.8432 37.783978449892 -122.391473297374 (37.783978449892, -122.391473297374) 6 2 9 28856 6
7517 228449 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009256.91005 2106366.76259 37.7642042826228 -122.411165888909 (37.7642042826228, -122.411165888909) 8 4 7 28859 19
7045 262404 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 100 Lyell St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003168.63891 2094316.61158 37.7307740683503 -122.431363211466 (37.7307740683503, -122.431363211466) 9 7 5 28861 25
6432 10064 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 512 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/1991 12:00:00 AM 30 3X3   6005527.25593 2105966.68025 37.762895882361 -122.42403725491 (37.762895882361, -122.42403725491) 8 4 5 28859 19
5763 228452 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009318.2366 2106370.18067 37.7642171069559 -122.410954018538 (37.7642171069559, -122.410954018538) 8 4 7 28859 19
4621 152863 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 78 Oakwood St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6005242.20984 2104952.34093 37.7600946488737 -122.424950959826 (37.7600946488737, -122.424950959826) 2 4 5 28859 19
4472 228451 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2701 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 6x6   6009297.41402 2106368.88017 37.7642123684355 -122.411025946309 (37.7642123684355, -122.411025946309) 8 4 7 28859 19
3866 18880 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 2315 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/13/2014 12:00:00 AM 3 3x3   6003622.42952 2115918.82336 37.7901142787066 -122.431335838788 (37.7901142787066, -122.431335838788) 13 9 1 29490 27
3216 27512 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1212 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2000 12:00:00 AM 8 3X3   6005753.54797 2101830.48031 37.75155161552 -122.422960597352 (37.75155161552, -122.422960597352) 2 4 5 28859 19
2788 235823 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 800 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x5   6005620.87436 2104260.20784 37.7582155954788 -122.423592129188 (37.7582155954788, -122.423592129188) 2 4 5 28859 19
2383 228491 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 544 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x4   6004217.2996 2105758.44512 37.7622500729091 -122.428553095368 (37.7622500729091, -122.428553095368) 8 4 5 28862 3
2347 228466 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 315 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/23/2015 01:54:00 PM 1 Width 3ft   6004209.32869 2107056.55416 37.7658139179905 -122.428673203406 (37.7658139179905, -122.428673203406) 8 4 5 28862 3
2133 27518 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1212 Guerrero St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2000 12:00:00 AM 4 3x3   6005759.73558 2101716.47325 37.7512389275446 -122.422931097816 (37.7512389275446, -122.422931097816) 2 4 5 28859 19
1421 235877 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1208 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2020 12:18:00 PM 3 6x5   6010019.59972 2102103.34196 37.7525406314463 -122.408227234492 (37.7525406314463, -122.408227234492) 2 4 7 28859 19
1047 42641 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1651 Union St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:11:00 PM 3 5x5 Permit Number 42688 6005090.06351 2118821.98656 37.7981686950973 -122.426464740961 (37.7981686950973, -122.426464740961) 13 9 1 57 17
751 261105 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1700X Lane St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6015022 2094381 37.7316155174388 -122.390388421118 (37.7316155174388, -122.390388421118) 10 3 8 58 1
744 152861 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 78 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6005240.53391 2104991.58672 37.7602023138964 -122.424959548361 (37.7602023138964, -122.424959548361) 2 4 5 28859 19
46 6035 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1826 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001552.687 2112546.4084 37.7807369756783 -122.438255270265 (37.7807369756783, -122.438255270265) 15 5 11 29490 41
40 6039 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1822 Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001574.3819 2112547.6661 37.7807416628926 -122.438180307395 (37.7807416628926, -122.438180307395) 15 5 11 29490 41

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);