772 rows where qCareAssistant = "DPW for City Agency" and qCaretaker_id = 4 sorted by qSpecies_id

View and edit SQL

qCareAssistant

  • DPW for City Agency · 772
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)
19907 102028 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
20458 42640 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1651 Union St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.425830717123 (37.7982497015198, -122.425830717123) 13 9 1 57 17
20806 102022 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
35858 102033 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
37102 77218 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 499X Hearst Ave 22 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
38321 102024 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
48405 102030 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
76443 102025 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
84100 77325 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/18/1988 12:00:00 AM 3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
113529 102032 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
129482 102027 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
130000 102029 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
131878 112062 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/18/2015 12:00:00 AM   4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
135552 102034 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
151130 97735 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1150 Francisco St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.979 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974) 5 9 1 28858 32
154395 112063 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
159171 112058 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
167233 102031 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
177368 102023 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
178370 112061 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
180505 112060 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
185959 102026 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
7794 78331 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014103.03356 2094377.1679 37.7315539757311 -122.393565225657 (37.7315539757311, -122.393565225657) 10 3 8 58 1
8094 78325 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 22 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014082.07463 2094268.00581 37.7312530742586 -122.393630047885 (37.7312530742586, -122.393630047885) 10 3 8 58 1
82714 94895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
84292 94894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
132285 94893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
167565 94892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
76214 37822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 10 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301) 9 7 6 28861 5
84190 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:41:00 AM 3 3x3   6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
92790 37817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 5 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.10251 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393) 9 7 6 28861 5
161401 37831 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003870.23097 2090403.35388 37.7200688687581 -122.428658848427 (37.7200688687581, -122.428658848427) 9 7 6 28861 5
176834 37820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018) 9 7 6 28861 5
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 9 7 6 28861 5
194372 37826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.428571430748 (37.7201841150858, -122.428571430748) 9 7 6 28861 5
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
34106 31711 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1250X Shrader St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.7638376395234 -122.450514467435 (37.7638376395234, -122.450514467435) 15 5 11 29492 9
115679 98564 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
128246 98744 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 540X Eureka St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
145225 98567 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
159114 98563 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
177484 98565 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
2999 94036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Lane St 4 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/14/2019 09:52:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968) 10 3 8 58 1
25347 98970 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
35960 99029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
39001 99032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
40144 40254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
40964 99037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
46230 99035 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
48192 99026 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
52900 40252 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
62996 99030 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
66136 99033 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
87632 98968 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/16/2015 08:08:00 AM 3 3x3 Permit Number 53353 6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
98389 99034 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
100312 98971 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
102622 99027 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
105771 99036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
106047 40253 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
117978 99025 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
127029 99028 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
134642 99031 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
151982 99038 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
165853 40251 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
166045 113827 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/16/2016 05:50:00 AM 3 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
169917 98974 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
170036 99040 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
182167 99024 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
185618 98973 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
4799 95481 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/12/2011 12:00:00 AM 3 3x3   5986568.37611 2111910.32722 37.778126839673 -122.490045739805 (37.778126839673, -122.490045739805) 11 6 2 55 26
9148 76641 DPW Maintained 1 Olea europaea :: Olive Tree 9 148X Paris St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002952.72216 2092480.76402 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653) 9 7 6 28861 5
18124 95460 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.7767753504668 -122.489949313769 (37.7767753504668, -122.489949313769) 11 6 2 55 26
61370 76728 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
69617 95465 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986594.5418 2111220.34134 37.7762338621769 -122.489904464478 (37.7762338621769, -122.489904464478) 11 6 2 55 26
100065 98885 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5994871.8 2088553.5 37.7144762388107 -122.459629241673 (37.7144762388107, -122.459629241673) 9 8 6 28861 24
105937 95458 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/12/2011 12:00:00 AM 3 3x3   5986582.44659 2111474.61787 37.7769313271764 -122.489965010922 (37.7769313271764, -122.489965010922) 11 6 2 55 26
113585 95463 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727) 11 6 2 55 26
115615 95468 Undocumented 4 Olea europaea :: Olive Tree 9 535X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/12/2011 12:00:00 AM 3 3x3 53267 5986556.7 2112284.6 37.7791538043677 -122.490113668043 (37.7791538043677, -122.490113668043) 11 6 2 55 26
119464 76771 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
129428 76768 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
140619 76757 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
165795 95471 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986558.17112 2112222.97674 37.778984690357 -122.49010404497 (37.778984690357, -122.49010404497) 11 6 2 55 26
26495 42983 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2X Yale St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
5378 76652 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 148X Paris St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6002965.38435 2092499.73249 37.7257738062998 -122.43193620819 (37.7257738062998, -122.43193620819) 9 7 6 28861 5
8452 116055 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/08/2020 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.403280067548 (37.7611252557522, -122.403280067548) 10 3 8 28856 29
10649 76037 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x6   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
12918 42635 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:32:00 AM 3 4x5 Permit Number 42688 6005113.34773 2118824.42387 37.7981767035488 -122.426384344263 (37.7981767035488, -122.426384344263) 13 9 1 57 17
13407 42632 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:07:00 PM 3 4x4 Permit Number 42688 6005134.31421 2118828.07494 37.7981879136105 -122.426312054082 (37.7981879136105, -122.426312054082) 13 9 1 57 17
15563 42636 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:48:00 AM 3 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479) 13 9 1 57 17
17590 73937 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
17940 42637 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:43:00 AM 3 4x4 Permit Number 42688 6005203.48268 2118840.06651 37.7982247489172 -122.42607356464 (37.7982247489172, -122.42607356464) 13 9 1 57 17
21099 76027 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
23498 76685 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
24208 76687 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
25637 76093 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
30221 95757 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.16774 37.7250685138993 -122.430292354528 (37.7250685138993, -122.430292354528) 9 7 6 28861 5
36927 95272 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2245 Jones St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/08/2011 12:00:00 AM 3 3x3   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
40315 116056 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/30/2018 12:00:00 AM 23 4x4   6011515.19198 2105171.68257 37.7610492486475 -122.403271019449 (37.7610492486475, -122.403271019449) 10 3 8 28856 29
44331 95756 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:16:00 PM 3 3x3 Permit Number 767495 6003442.24703 2092244.67659 37.7251005018853 -122.430269541405 (37.7251005018853, -122.430269541405) 9 7 6 28861 5

Next page

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